com.ibm.commerce.inventory.objects
Class InventoryJDBCHelperAccessBean

java.lang.Object
  com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
      com.ibm.commerce.inventory.objects.InventoryJDBCHelperAccessBean

public class InventoryJDBCHelperAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
See Also:
Serialized Form

Constructor Summary
InventoryJDBCHelperAccessBean()
InventoryJDBCHelperAccessBean(javax.ejb.EJBObject o)
This method was generated by the VisualAge for Java Access Bean SmartGuide.
Method Summary
java.util.Hashtable checkInventoryQuantity(java.lang.Long aCatalogEntryId, java.lang.Integer aFulfillmentId, java.lang.Integer aStoreId)
protected java.lang.String defaultJNDIName()
This method was generated by the VisualAge for Java Access Bean SmartGuide.
java.lang.Integer dummyUpdateInventoryQuantity(java.lang.Long arg0, java.lang.Integer arg1, java.lang.Integer arg2)
This method was generated by the VisualAge for Java Access Bean SmartGuide.
java.util.Vector findAvailableReceiptMaxAndMinPrecedence()
java.lang.Integer findAvailQuantityByItemFFCStore(java.lang.Integer storeentId, java.lang.Long itemSpcId, java.lang.Integer FFCId)
java.lang.String findBaseItemDescriptionLongDescription(java.lang.Long aBaseItemId, java.lang.Integer aLanguageId)
java.util.Vector findExpectedInventoryRecordDetailByRaDetailIdAndLanguageId(java.lang.Long raId, java.lang.Integer languageId)
java.util.Vector findExpectedInventoryRecordDetailListByRaIdAndLanguageId(java.lang.Long raId, java.lang.Integer languageId)
java.util.Vector findExpectedInventoryRecordListByStoreentId(java.lang.Integer storeentId)
java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId)
java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription(java.lang.Integer storeentId, java.lang.Integer languageId)
java.util.Vector findIsQtyReceivedByRaId(java.lang.Long raId)
java.util.Vector findItemAvailableInventoryByStoreIdAndItemSpcId(java.lang.Integer storeId, java.lang.Long itemSpcId)
java.util.Vector findItemCurrentVersion(java.lang.Long itemSpcId)
java.util.Vector findItemInventoryListByStoreIdAndItemSpcId(java.lang.Integer storeId, java.lang.Long itemSpcId, java.lang.Integer ffmCenterId)
java.util.Vector findItemSearchResultListByLanguageIdAndStoreentIdAndShortDescriptionAndPartNumber(java.lang.Integer languageId, java.lang.Integer storeentId, java.lang.String shortDescription, java.lang.String partNumber)
java.util.Vector findItemSpecWithWhereClause(java.lang.String whereClause, boolean flush)
java.lang.Integer findMaxOrderReleaseNumForOrder(java.lang.Long orderId)
java.util.Vector findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence(java.lang.Long orderItemsId)
java.lang.String findOrderReleasePackSlipXML(java.lang.Long aOrdersId, java.lang.Integer aOrderReleaseNum)
java.util.Vector findOrders()
java.util.Vector findPackageInformationListByOrdersId(java.lang.Long ordersId)
java.util.Vector findPackageInformationListByOrdersIdAndOrderReleaseNumber(java.lang.Long ordersId, java.lang.Integer orderReleaseNum)
java.util.Vector findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId(java.lang.Long manifestId, java.lang.Integer storeentId, java.lang.Integer ffmCenterId)
java.util.Vector findPackslipComponentsListByOrderItemsId(java.lang.Long orderItemsId)
java.util.Vector findPackslipItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
java.util.Vector findPackslipListByPickBatchId(java.lang.Long pickBatchId)
java.util.Vector findPickBatchListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId)
java.lang.String findPickBatchPickSlipXML(java.lang.Long aPickBatchId)
java.util.Vector findPickItemsListByPickbatchId(java.lang.Long pickbatchId)
java.util.Vector findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows)
java.util.Vector findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows, java.lang.Integer delayInMins)
Find Releases that are ready to be shipped by StoreentId and FfmcenterId Creation date: (3/15/01 10:37:28 AM) Added for 55674
java.util.Vector findReceiptByVersionSpecificationOrderByReceiptPrecedence(java.lang.Long versionSpecificationId)
java.util.Vector findReleaseAddressIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
java.util.Vector findReleaseItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer languageId)
java.util.Vector findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersId(java.lang.Integer ordReleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Long ordersId)
java.util.Vector findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersIdAndLanguageId(java.lang.Integer ordReleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Long ordersId, java.lang.Integer languageId)
java.util.Vector findReleaseShipListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId)
java.util.Vector findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
java.util.Vector findVendorInformationByVendorId(java.lang.Long vendorId)
java.util.Vector findVendorInformationByVendorIdAndLanguageId(java.lang.Long vendorId, java.lang.Integer languageId)
java.util.Vector findVendorListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId)
protected void instantiateEJB()
This method was generated by the VisualAge for Java Access Bean SmartGuide.
int updateBaseItemDescriptionLongDescription(java.lang.Long aBaseItemId, java.lang.Integer aLanguageId, java.lang.String aLongDescription)
java.lang.Integer updateInventoryQuantity(java.util.Hashtable aHashtable)
int updateOrderReleaseExternalOrderNumber(java.sql.Timestamp lastUpdate, java.lang.String externalOrderNumber, java.lang.Long aOrderId, java.lang.Integer[] orderReleaseNums)
updateOrderReleaseExternalOrderNumber
int updateOrderReleaseExternalOrderNumber(java.sql.Timestamp lastUpdate, java.lang.String externalOrderNumber, java.lang.Long aOrderId, java.lang.Long[] orderItemIds)
updateOrderReleaseExternalOrderNumber
int updateOrderReleasePackSlipXML(java.lang.Long aOrdersId, java.lang.Integer aOrderReleaseNum, java.lang.String aPackSlipXML)
int updatePickBatchPickSlipXML(java.lang.Long aPickBatchId, java.lang.String aPickSlipXML)
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

InventoryJDBCHelperAccessBean

public InventoryJDBCHelperAccessBean()
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.

InventoryJDBCHelperAccessBean

public InventoryJDBCHelperAccessBean(javax.ejb.EJBObject o)
                              throws java.rmi.RemoteException
This method was generated by the VisualAge for Java Access Bean SmartGuide. Warning: Modifications will be lost when this part is regenerated.
Method Detail

defaultJNDIName

protected java.lang.String defaultJNDIName()
This method was generated by the VisualAge for Java Access Bean SmartGuide. Warning: Modifications will be lost when this part is regenerated.

instantiateEJB

protected void instantiateEJB()
                       throws javax.ejb.CreateException,
                              java.rmi.RemoteException,
                              javax.naming.NamingException
This method was generated by the VisualAge for Java Access Bean SmartGuide. Warning: Modifications will be lost when this part is regenerated.
Throws:
javax.ejb.CreateException
java.rmi.RemoteException
javax.naming.NamingException

updateBaseItemDescriptionLongDescription

public int updateBaseItemDescriptionLongDescription(java.lang.Long aBaseItemId,
                                                    java.lang.Integer aLanguageId,
                                                    java.lang.String aLongDescription)
                                             throws javax.naming.NamingException,
                                                    java.sql.SQLException,
                                                    java.rmi.RemoteException,
                                                    javax.ejb.CreateException
Parameters:
aBaseItemId - java.lang.Long
aLanguageId - java.lang.Integer
aLongDescription - java.lang.String
Returns:
int
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updateOrderReleasePackSlipXML

public int updateOrderReleasePackSlipXML(java.lang.Long aOrdersId,
                                         java.lang.Integer aOrderReleaseNum,
                                         java.lang.String aPackSlipXML)
                                  throws javax.naming.NamingException,
                                         java.sql.SQLException,
                                         java.rmi.RemoteException,
                                         javax.ejb.CreateException
Parameters:
aOrdersId - java.lang.Long
aOrderReleaseNum - java.lang.Integer
aPackSlipXML - java.lang.String
Returns:
int
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updatePickBatchPickSlipXML

public int updatePickBatchPickSlipXML(java.lang.Long aPickBatchId,
                                      java.lang.String aPickSlipXML)
                               throws javax.naming.NamingException,
                                      java.sql.SQLException,
                                      java.rmi.RemoteException,
                                      javax.ejb.CreateException
Parameters:
aPickBatchId - java.lang.Long
aPickSlipXML - java.lang.String
Returns:
int
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

dummyUpdateInventoryQuantity

public java.lang.Integer dummyUpdateInventoryQuantity(java.lang.Long arg0,
                                                      java.lang.Integer arg1,
                                                      java.lang.Integer arg2)
                                               throws javax.naming.NamingException,
                                                      java.rmi.RemoteException,
                                                      java.sql.SQLException,
                                                      javax.ejb.CreateException
This method was generated by the VisualAge for Java Access Bean SmartGuide. Warning: Modifications will be lost when this part is regenerated.
Throws:
javax.naming.NamingException
java.rmi.RemoteException
java.sql.SQLException
javax.ejb.CreateException

findAvailQuantityByItemFFCStore

public java.lang.Integer findAvailQuantityByItemFFCStore(java.lang.Integer storeentId,
                                                         java.lang.Long itemSpcId,
                                                         java.lang.Integer FFCId)
                                                  throws javax.naming.NamingException,
                                                         java.sql.SQLException,
                                                         java.rmi.RemoteException,
                                                         javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
itemSpcId - java.lang.Long
FFCId - java.lang.Integer
Returns:
java.lang.Integer
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updateInventoryQuantity

public java.lang.Integer updateInventoryQuantity(java.util.Hashtable aHashtable)
                                          throws javax.naming.NamingException,
                                                 java.sql.SQLException,
                                                 java.rmi.RemoteException,
                                                 javax.ejb.CreateException
Parameters:
aHashtable - java.util.Hashtable
Returns:
java.lang.Integer
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findBaseItemDescriptionLongDescription

public java.lang.String findBaseItemDescriptionLongDescription(java.lang.Long aBaseItemId,
                                                               java.lang.Integer aLanguageId)
                                                        throws javax.naming.NamingException,
                                                               java.sql.SQLException,
                                                               java.rmi.RemoteException,
                                                               javax.ejb.CreateException
Parameters:
aBaseItemId - java.lang.Long
aLanguageId - java.lang.Integer
Returns:
java.lang.String
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findOrderReleasePackSlipXML

public java.lang.String findOrderReleasePackSlipXML(java.lang.Long aOrdersId,
                                                    java.lang.Integer aOrderReleaseNum)
                                             throws javax.naming.NamingException,
                                                    java.sql.SQLException,
                                                    java.rmi.RemoteException,
                                                    javax.ejb.CreateException
Parameters:
aOrdersId - java.lang.Long
aOrderReleaseNum - java.lang.Integer
Returns:
java.lang.String
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPickBatchPickSlipXML

public java.lang.String findPickBatchPickSlipXML(java.lang.Long aPickBatchId)
                                          throws javax.naming.NamingException,
                                                 java.sql.SQLException,
                                                 java.rmi.RemoteException,
                                                 javax.ejb.CreateException
Parameters:
aPickBatchId - java.lang.Long
Returns:
java.lang.String
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

checkInventoryQuantity

public java.util.Hashtable checkInventoryQuantity(java.lang.Long aCatalogEntryId,
                                                  java.lang.Integer aFulfillmentId,
                                                  java.lang.Integer aStoreId)
                                           throws javax.naming.NamingException,
                                                  java.sql.SQLException,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.CreateException
Parameters:
aCatalogEntryId - java.lang.Long
aFulfillmentId - java.lang.Integer
aStoreId - java.lang.Integer
Returns:
java.util.Hashtable
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findAvailableReceiptMaxAndMinPrecedence

public java.util.Vector findAvailableReceiptMaxAndMinPrecedence()
                                                         throws javax.naming.NamingException,
                                                                java.sql.SQLException,
                                                                java.rmi.RemoteException,
                                                                javax.ejb.CreateException
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findExpectedInventoryRecordDetailByRaDetailIdAndLanguageId

public java.util.Vector findExpectedInventoryRecordDetailByRaDetailIdAndLanguageId(java.lang.Long raId,
                                                                                   java.lang.Integer languageId)
                                                                            throws javax.naming.NamingException,
                                                                                   java.sql.SQLException,
                                                                                   java.rmi.RemoteException,
                                                                                   javax.ejb.CreateException
Parameters:
raId - java.lang.Long
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findExpectedInventoryRecordDetailListByRaIdAndLanguageId

public java.util.Vector findExpectedInventoryRecordDetailListByRaIdAndLanguageId(java.lang.Long raId,
                                                                                 java.lang.Integer languageId)
                                                                          throws javax.naming.NamingException,
                                                                                 java.sql.SQLException,
                                                                                 java.rmi.RemoteException,
                                                                                 javax.ejb.CreateException
Parameters:
raId - java.lang.Long
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findExpectedInventoryRecordListByStoreentId

public java.util.Vector findExpectedInventoryRecordListByStoreentId(java.lang.Integer storeentId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findInventoryAdjustmentCodeListByStoreentIdAndLanguageId

public java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
                                                                                 java.lang.Integer languageId)
                                                                          throws javax.naming.NamingException,
                                                                                 java.sql.SQLException,
                                                                                 java.rmi.RemoteException,
                                                                                 javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription

public java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription(java.lang.Integer storeentId,
                                                                                                   java.lang.Integer languageId)
                                                                                            throws javax.naming.NamingException,
                                                                                                   java.sql.SQLException,
                                                                                                   java.rmi.RemoteException,
                                                                                                   javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findIsQtyReceivedByRaId

public java.util.Vector findIsQtyReceivedByRaId(java.lang.Long raId)
                                         throws javax.naming.NamingException,
                                                java.sql.SQLException,
                                                java.rmi.RemoteException,
                                                javax.ejb.CreateException
Parameters:
raId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findItemCurrentVersion

public java.util.Vector findItemCurrentVersion(java.lang.Long itemSpcId)
                                        throws javax.naming.NamingException,
                                               java.sql.SQLException,
                                               java.rmi.RemoteException,
                                               javax.ejb.CreateException
Parameters:
itemSpcId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findItemInventoryListByStoreIdAndItemSpcId

public java.util.Vector findItemInventoryListByStoreIdAndItemSpcId(java.lang.Integer storeId,
                                                                   java.lang.Long itemSpcId,
                                                                   java.lang.Integer ffmCenterId)
                                                            throws javax.naming.NamingException,
                                                                   java.sql.SQLException,
                                                                   java.rmi.RemoteException,
                                                                   javax.ejb.CreateException
Parameters:
storeId - java.lang.Integer
itemSpcId - java.lang.Long
ffmCenterId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findItemSearchResultListByLanguageIdAndStoreentIdAndShortDescriptionAndPartNumber

public java.util.Vector findItemSearchResultListByLanguageIdAndStoreentIdAndShortDescriptionAndPartNumber(java.lang.Integer languageId,
                                                                                                          java.lang.Integer storeentId,
                                                                                                          java.lang.String shortDescription,
                                                                                                          java.lang.String partNumber)
                                                                                                   throws javax.naming.NamingException,
                                                                                                          java.sql.SQLException,
                                                                                                          java.rmi.RemoteException,
                                                                                                          javax.ejb.CreateException
Parameters:
languageId - java.lang.Integer
storeentId - java.lang.Integer
shortDescription - java.lang.String
partNumber - java.lang.String
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findItemSpecWithWhereClause

public java.util.Vector findItemSpecWithWhereClause(java.lang.String whereClause,
                                                    boolean flush)
                                             throws javax.naming.NamingException,
                                                    java.sql.SQLException,
                                                    java.rmi.RemoteException,
                                                    javax.ejb.CreateException
Parameters:
whereClause - java.lang.String
flush - boolean
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence

public java.util.Vector findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence(java.lang.Long orderItemsId)
                                                                                    throws javax.naming.NamingException,
                                                                                           java.sql.SQLException,
                                                                                           java.rmi.RemoteException,
                                                                                           javax.ejb.CreateException
Parameters:
orderItemsId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findOrders

public java.util.Vector findOrders()
                            throws javax.naming.NamingException,
                                   java.sql.SQLException,
                                   java.rmi.RemoteException,
                                   javax.ejb.CreateException
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackageInformationListByOrdersId

public java.util.Vector findPackageInformationListByOrdersId(java.lang.Long ordersId)
                                                      throws javax.naming.NamingException,
                                                             java.sql.SQLException,
                                                             java.rmi.RemoteException,
                                                             javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackageInformationListByOrdersIdAndOrderReleaseNumber

public java.util.Vector findPackageInformationListByOrdersIdAndOrderReleaseNumber(java.lang.Long ordersId,
                                                                                  java.lang.Integer orderReleaseNum)
                                                                           throws javax.naming.NamingException,
                                                                                  java.sql.SQLException,
                                                                                  java.rmi.RemoteException,
                                                                                  javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
orderReleaseNum - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId

public java.util.Vector findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId(java.lang.Long manifestId,
                                                                                     java.lang.Integer storeentId,
                                                                                     java.lang.Integer ffmCenterId)
                                                                              throws javax.naming.NamingException,
                                                                                     java.sql.SQLException,
                                                                                     java.rmi.RemoteException,
                                                                                     javax.ejb.CreateException
Parameters:
manifestId - java.lang.Long
storeentId - java.lang.Integer
ffmCenterId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackslipComponentsListByOrderItemsId

public java.util.Vector findPackslipComponentsListByOrderItemsId(java.lang.Long orderItemsId)
                                                          throws javax.naming.NamingException,
                                                                 java.sql.SQLException,
                                                                 java.rmi.RemoteException,
                                                                 javax.ejb.CreateException
Parameters:
orderItemsId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackslipItemsListByOrdersIdAndOrdreleaseNum

public java.util.Vector findPackslipItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId,
                                                                        java.lang.Integer ordreleaseNum)
                                                                 throws javax.naming.NamingException,
                                                                        java.sql.SQLException,
                                                                        java.rmi.RemoteException,
                                                                        javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
ordreleaseNum - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPackslipListByPickBatchId

public java.util.Vector findPackslipListByPickBatchId(java.lang.Long pickBatchId)
                                               throws javax.naming.NamingException,
                                                      java.sql.SQLException,
                                                      java.rmi.RemoteException,
                                                      javax.ejb.CreateException
Parameters:
pickBatchId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPickBatchListByStoreentIdAndFfmcenterId

public java.util.Vector findPickBatchListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId,
                                                                    java.lang.Integer ffmcenterId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException,
                                                                    java.rmi.RemoteException,
                                                                    javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
ffmcenterId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findPickItemsListByPickbatchId

public java.util.Vector findPickItemsListByPickbatchId(java.lang.Long pickbatchId)
                                                throws javax.naming.NamingException,
                                                       java.sql.SQLException,
                                                       java.rmi.RemoteException,
                                                       javax.ejb.CreateException
Parameters:
pickbatchId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId

public java.util.Vector findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId,
                                                                                  java.lang.Integer ffmCenterId,
                                                                                  java.lang.Integer firstRows)
                                                                           throws javax.naming.NamingException,
                                                                                  java.sql.SQLException,
                                                                                  java.rmi.RemoteException,
                                                                                  javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
ffmCenterId - java.lang.Integer
firstRows - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReceiptByVersionSpecificationOrderByReceiptPrecedence

public java.util.Vector findReceiptByVersionSpecificationOrderByReceiptPrecedence(java.lang.Long versionSpecificationId)
                                                                           throws javax.naming.NamingException,
                                                                                  java.sql.SQLException,
                                                                                  java.rmi.RemoteException,
                                                                                  javax.ejb.CreateException
Parameters:
versionSpecificationId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleaseAddressIdByOrdersIdAndOrdreleaseNum

public java.util.Vector findReleaseAddressIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId,
                                                                       java.lang.Integer ordreleaseNum)
                                                                throws javax.naming.NamingException,
                                                                       java.sql.SQLException,
                                                                       java.rmi.RemoteException,
                                                                       javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
ordreleaseNum - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleaseItemsListByOrdersIdAndOrdreleaseNum

public java.util.Vector findReleaseItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId,
                                                                       java.lang.Integer ordreleaseNum,
                                                                       java.lang.Integer storeentId,
                                                                       java.lang.Integer ffmCenterId,
                                                                       java.lang.Integer languageId)
                                                                throws javax.naming.NamingException,
                                                                       java.sql.SQLException,
                                                                       java.rmi.RemoteException,
                                                                       javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
ordreleaseNum - java.lang.Integer
storeentId - java.lang.Integer
ffmCenterId - java.lang.Integer
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersId

public java.util.Vector findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersId(java.lang.Integer ordReleaseNum,
                                                                                                    java.lang.Integer storeentId,
                                                                                                    java.lang.Integer ffmCenterId,
                                                                                                    java.lang.Long ordersId)
                                                                                             throws javax.naming.NamingException,
                                                                                                    java.sql.SQLException,
                                                                                                    java.rmi.RemoteException,
                                                                                                    javax.ejb.CreateException
Parameters:
ordReleaseNum - java.lang.Integer
storeentId - java.lang.Integer
ffmCenterId - java.lang.Integer
ordersId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersIdAndLanguageId

public java.util.Vector findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersIdAndLanguageId(java.lang.Integer ordReleaseNum,
                                                                                                                 java.lang.Integer storeentId,
                                                                                                                 java.lang.Integer ffmCenterId,
                                                                                                                 java.lang.Long ordersId,
                                                                                                                 java.lang.Integer languageId)
                                                                                                          throws javax.naming.NamingException,
                                                                                                                 java.sql.SQLException,
                                                                                                                 java.rmi.RemoteException,
                                                                                                                 javax.ejb.CreateException
Parameters:
ordReleaseNum - java.lang.Integer
storeentId - java.lang.Integer
ffmCenterId - java.lang.Integer
ordersId - java.lang.Long
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleaseShipListByStoreentIdAndFfmcenterId

public java.util.Vector findReleaseShipListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId,
                                                                      java.lang.Integer ffmcenterId)
                                                               throws javax.naming.NamingException,
                                                                      java.sql.SQLException,
                                                                      java.rmi.RemoteException,
                                                                      javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
ffmcenterId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum

public java.util.Vector findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId,
                                                                        java.lang.Integer ordreleaseNum)
                                                                 throws javax.naming.NamingException,
                                                                        java.sql.SQLException,
                                                                        java.rmi.RemoteException,
                                                                        javax.ejb.CreateException
Parameters:
ordersId - java.lang.Long
ordreleaseNum - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findVendorInformationByVendorId

public java.util.Vector findVendorInformationByVendorId(java.lang.Long vendorId)
                                                 throws javax.naming.NamingException,
                                                        java.sql.SQLException,
                                                        java.rmi.RemoteException,
                                                        javax.ejb.CreateException
Parameters:
vendorId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findVendorInformationByVendorIdAndLanguageId

public java.util.Vector findVendorInformationByVendorIdAndLanguageId(java.lang.Long vendorId,
                                                                     java.lang.Integer languageId)
                                                              throws javax.naming.NamingException,
                                                                     java.sql.SQLException,
                                                                     java.rmi.RemoteException,
                                                                     javax.ejb.CreateException
Parameters:
vendorId - java.lang.Long
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findVendorListByStoreentIdAndLanguageId

public java.util.Vector findVendorListByStoreentIdAndLanguageId(java.lang.Integer storeentId,
                                                                java.lang.Integer languageId)
                                                         throws javax.naming.NamingException,
                                                                java.sql.SQLException,
                                                                java.rmi.RemoteException,
                                                                javax.ejb.CreateException
Parameters:
storeentId - java.lang.Integer
languageId - java.lang.Integer
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updateOrderReleaseExternalOrderNumber

public int updateOrderReleaseExternalOrderNumber(java.sql.Timestamp lastUpdate,
                                                 java.lang.String externalOrderNumber,
                                                 java.lang.Long aOrderId,
                                                 java.lang.Long[] orderItemIds)
                                          throws javax.naming.NamingException,
                                                 javax.ejb.CreateException,
                                                 java.rmi.RemoteException,
                                                 java.sql.SQLException
updateOrderReleaseExternalOrderNumber
Throws:
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

updateOrderReleaseExternalOrderNumber

public int updateOrderReleaseExternalOrderNumber(java.sql.Timestamp lastUpdate,
                                                 java.lang.String externalOrderNumber,
                                                 java.lang.Long aOrderId,
                                                 java.lang.Integer[] orderReleaseNums)
                                          throws javax.naming.NamingException,
                                                 javax.ejb.CreateException,
                                                 java.rmi.RemoteException,
                                                 java.sql.SQLException
updateOrderReleaseExternalOrderNumber
Throws:
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findItemAvailableInventoryByStoreIdAndItemSpcId

public java.util.Vector findItemAvailableInventoryByStoreIdAndItemSpcId(java.lang.Integer storeId,
                                                                        java.lang.Long itemSpcId)
                                                                 throws javax.naming.NamingException,
                                                                        javax.ejb.CreateException,
                                                                        java.rmi.RemoteException,
                                                                        java.sql.SQLException
Parameters:
storeId - java.lang.Integer
itemSpcId - java.lang.Long
Returns:
java.util.Vector
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findMaxOrderReleaseNumForOrder

public java.lang.Integer findMaxOrderReleaseNumForOrder(java.lang.Long orderId)
                                                 throws javax.naming.NamingException,
                                                        javax.ejb.CreateException,
                                                        java.rmi.RemoteException,
                                                        java.sql.SQLException
Parameters:
orderId -
Returns:
Integer
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId

public java.util.Vector findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId,
                                                                                  java.lang.Integer ffmCenterId,
                                                                                  java.lang.Integer firstRows,
                                                                                  java.lang.Integer delayInMins)
                                                                           throws javax.naming.NamingException,
                                                                                  javax.ejb.CreateException,
                                                                                  java.rmi.RemoteException,
                                                                                  java.sql.SQLException
Find Releases that are ready to be shipped by StoreentId and FfmcenterId Creation date: (3/15/01 10:37:28 AM) Added for 55674
Returns:
java.util.Vector
Throws:
javax.naming.NamingException
SQLException
java.rmi.RemoteException
javax.ejb.CreateException

Feedback