public class InventoryJDBCHelperAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
Constructor and Description |
---|
InventoryJDBCHelperAccessBean() |
InventoryJDBCHelperAccessBean(javax.ejb.EJBObject o)
InventoryJDBCHelperAccessBean
|
Modifier and Type | Method and Description |
---|---|
java.util.Hashtable | checkInventoryQuantity(java.lang.Long aCatalogEntryId, java.lang.Integer aFulfillmentId, java.lang.Integer aStoreId)
checkInventoryQuantity
|
java.lang.String | defaultJNDIName()
defaultJNDIName
|
java.lang.Integer | dummyUpdateInventoryQuantity(java.lang.Long aCatalogEntryId, java.lang.Integer aFulfillmentId, java.lang.Integer aStoreId)
dummyUpdateInventoryQuantity
|
java.util.Vector | findAvailableReceiptMaxAndMinPrecedence() |
java.lang.Integer | findAvailQuantityByItemFFCStore(java.lang.Integer storeentId, java.lang.Long itemSpcId, java.lang.Integer FFCId) |
java.util.HashMap | findCurrentCharges(java.lang.Long anOrderId)
findCurrentCharges
|
java.util.ArrayList | findExpectedFFCInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findExpectedFFCInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findExpectedFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findExpectedFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
java.util.ArrayList | findExpectedInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findExpectedInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findExpectedInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findExpectedInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
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 | findExpectedInventoryRecordDetailListByStoreIdAndCatentryId(java.lang.Integer storeId, java.lang.Long catentryId)
findExpectedInventoryRecordDetailListByStoreIdAndCatentryId
|
java.util.Vector | findExpectedInventoryRecordListByStoreentId(java.lang.Integer storeentId) |
java.util.ArrayList | findExpectedVendorInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findExpectedVendorInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findExpectedVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findExpectedVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
java.util.Vector | findInventoryAdjustmentCodeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) |
java.util.Vector | findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription(java.lang.Integer storeentId, java.lang.Integer languageId)
findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription
|
java.util.Vector | findIsQtyReceivedByRaId(java.lang.Long raId) |
java.util.Vector | findItemAvailableInventoryByStoreIdAndItemSpcId(java.lang.Integer storeId, java.lang.Long itemSpcId)
findItemAvailableInventoryByStoreIdAndItemSpcId
|
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 | findItemSpecWithParameterizedWhereClause(java.lang.String whereClause, java.lang.Object[] parameters, boolean flush)
findItemSpecWithParameterizedWhereClause
|
java.util.Vector | findItemSpecWithWhereClause(java.lang.String whereClause, boolean flush)
findItemSpecWithWhereClause
|
java.lang.Integer | findMaxOrderReleaseNumForOrder(java.lang.Long orderId)
findMaxOrderReleaseNumForOrder
|
java.util.ArrayList | findOnHandFFCInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findOnHandFFCInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findOnHandFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findOnHandFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
java.util.ArrayList | findOnHandInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findOnHandInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findOnHandInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findOnHandInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
java.util.ArrayList | findOnHandVendorInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId)
findOnHandVendorInventoryByStoreIdAndCatentryIdAndLanguageId
|
java.util.ArrayList | findOnHandVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId)
findOnHandVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId
|
java.util.Vector | findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence(java.lang.Long orderItemsId)
findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence
|
java.lang.String | findOrderReleasePackSlipXML(java.lang.Long aOrdersId, java.lang.Integer aOrderReleaseNum)
findOrderReleasePackSlipXML
|
java.util.Vector | findOrders()
findOrders
|
java.util.Vector | findPackageInformationListByOrdersId(java.lang.Long ordersId)
findPackageInformationListByOrdersId
|
java.util.Vector | findPackageInformationListByOrdersIdAndOrderReleaseNumber(java.lang.Long ordersId, java.lang.Integer orderReleaseNum)
findPackageInformationListByOrdersIdAndOrderReleaseNumber
|
java.util.Vector | findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId(java.lang.Long manifestId, java.lang.Integer storeentId, java.lang.Integer ffmCenterId)
findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId
|
java.util.Vector | findPackslipComponentsListByOrderItemsId(java.lang.Long orderItemsId)
findPackslipComponentsListByOrderItemsId
|
java.util.Vector | findPackslipItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
findPackslipItemsListByOrdersIdAndOrdreleaseNum
|
java.util.Vector | findPackslipListByPickBatchId(java.lang.Long pickBatchId)
findPackslipListByPickBatchId
|
java.util.Vector | findPickBatchListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId)
findPickBatchListByStoreentIdAndFfmcenterId
|
java.lang.String | findPickBatchPickSlipXML(java.lang.Long aPickBatchId)
findPickBatchPickSlipXML
|
java.util.Vector | findPickItemsListByPickbatchId(java.lang.Long pickbatchId)
findPickItemsListByPickbatchId
|
java.util.ArrayList | findQuantityPickedAndReceptIdByOrdersIdandReleaseNum(java.lang.Long anOrdersId, java.lang.Integer aReleaseNum)
findQuantityPickedAndReceptIdByOrdersIdandReleaseNum
|
java.util.ArrayList | findQuantityPickedAndReceptIdByOrdersIdandReleaseNum(java.lang.Long anOrdersId, java.lang.Integer aReleaseNum, boolean flush)
findQuantityPickedAndReceptIdByOrdersIdandReleaseNum
|
java.util.Vector | findReadyToBeShippedExpeditedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows, java.lang.Integer delayInMins)
findReadyToBeShippedExpeditedReleaseListByStoreentIdAndFfmcenterId
|
java.util.Vector | findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows)
findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId
|
java.util.Vector | findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows, java.lang.Integer delayInMins)
findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId
|
java.util.Vector | findReceiptByVersionSpecificationOrderByReceiptPrecedence(java.lang.Long versionSpecificationId)
findReceiptByVersionSpecificationOrderByReceiptPrecedence
|
java.util.Vector | findReleaseAddressIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
findReleaseAddressIdByOrdersIdAndOrdreleaseNum
|
java.util.Vector | findReleaseItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer languageId)
findReleaseItemsListByOrdersIdAndOrdreleaseNum
|
java.util.Vector | findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersId(java.lang.Integer ordReleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Long ordersId)
findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersId
|
java.util.Vector | findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersIdAndLanguageId(java.lang.Integer ordReleaseNum, java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Long ordersId, java.lang.Integer languageId)
findReleasePackageListByOrdReleaseNumAndStoreentIdAndFfmcenterIdAndOrdersIdAndLanguageId
|
java.util.Vector | findReleaseShipListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId)
findReleaseShipListByStoreentIdAndFfmcenterId
|
java.util.Vector | findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum)
findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum
|
java.util.Vector | findVendorInformationByVendorId(java.lang.Long vendorId)
findVendorInformationByVendorId
|
java.util.Vector | findVendorInformationByVendorIdAndLanguageId(java.lang.Long vendorId, java.lang.Integer languageId)
findVendorInformationByVendorIdAndLanguageId
|
java.util.Vector | findVendorListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId)
findVendorListByStoreentIdAndLanguageId
|
protected void | instantiateEJB()
instantiateEJB
|
java.lang.Integer | updateInventoryQuantity(java.util.Hashtable aHashtable)
updateInventoryQuantity
|
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)
updateOrderReleasePackSlipXML
|
int | updatePickBatchPickSlipXML(java.lang.Long aPickBatchId, java.lang.String aPickSlipXML)
updatePickBatchPickSlipXML
|
public InventoryJDBCHelperAccessBean()
public InventoryJDBCHelperAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException
public java.util.HashMap findCurrentCharges(java.lang.Long anOrderId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.lang.Integer findAvailQuantityByItemFFCStore(java.lang.Integer storeentId, java.lang.Long itemSpcId, java.lang.Integer FFCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findIsQtyReceivedByRaId(java.lang.Long raId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findItemCurrentVersion(java.lang.Long itemSpcId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findVendorInformationByVendorIdAndLanguageId(java.lang.Long vendorId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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
public java.util.Vector findPackslipComponentsListByOrderItemsId(java.lang.Long orderItemsId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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
public java.util.Vector findReadyToBeShippedExpeditedReleaseListByStoreentIdAndFfmcenterId(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
public java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findAvailableReceiptMaxAndMinPrecedence() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findQuantityPickedAndReceptIdByOrdersIdandReleaseNum(java.lang.Long anOrdersId, java.lang.Integer aReleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPackageInformationListByOrdersIdAndOrderReleaseNumber(java.lang.Long ordersId, java.lang.Integer orderReleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandFFCInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPickBatchListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findExpectedInventoryRecordDetailByRaDetailIdAndLanguageId(java.lang.Long raId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findReleaseShipListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmcenterId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findExpectedInventoryRecordDetailListByRaIdAndLanguageId(java.lang.Long raId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandVendorInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findVendorListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPackslipItemsListByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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
public java.util.Vector findReleaseAddressIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPackageInformationListByOrdersId(java.lang.Long ordersId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPickItemsListByPickbatchId(java.lang.Long pickbatchId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPackslipListByPickBatchId(java.lang.Long pickBatchId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedVendorInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findQuantityPickedAndReceptIdByOrdersIdandReleaseNum(java.lang.Long anOrdersId, java.lang.Integer aReleaseNum, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedVendorInventoryByStoreIdAndPartnumberAndCatentrynameAndLanguageId(java.lang.Integer storeId, java.lang.String partNumber, java.lang.String catentryName, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findItemSpecWithParameterizedWhereClause(java.lang.String whereClause, java.lang.Object[] parameters, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findReceiptByVersionSpecificationOrderByReceiptPrecedence(java.lang.Long versionSpecificationId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandFFCInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findReleaseShipmodeIdByOrdersIdAndOrdreleaseNum(java.lang.Long ordersId, java.lang.Integer ordreleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findPackageShipDetailByManifestIdAndStoreentIdAndFfmCenterId(java.lang.Long manifestId, java.lang.Integer storeentId, java.lang.Integer ffmCenterId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findExpectedFFCInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findExpectedInventoryRecordListByStoreentId(java.lang.Integer storeentId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.ArrayList findOnHandInventoryByStoreIdAndCatentryIdAndLanguageId(java.lang.Integer storeId, java.lang.Long catentryId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.lang.Integer findMaxOrderReleaseNumForOrder(java.lang.Long orderId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findItemInventoryListByStoreIdAndItemSpcId(java.lang.Integer storeId, java.lang.Long itemSpcId, java.lang.Integer ffmCenterId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence(java.lang.Long orderItemsId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.lang.String findOrderReleasePackSlipXML(java.lang.Long aOrdersId, java.lang.Integer aOrderReleaseNum) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Hashtable checkInventoryQuantity(java.lang.Long aCatalogEntryId, java.lang.Integer aFulfillmentId, java.lang.Integer aStoreId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findItemSpecWithWhereClause(java.lang.String whereClause, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public int updateOrderReleasePackSlipXML(java.lang.Long aOrdersId, java.lang.Integer aOrderReleaseNum, java.lang.String aPackSlipXML) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findOrders() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findInventoryAdjustmentCodeListByStoreentIdAndLanguageIdOrderByDescription(java.lang.Integer storeentId, java.lang.Integer languageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findReadyToBeShippedReleaseListByStoreentIdAndFfmcenterId(java.lang.Integer storeentId, java.lang.Integer ffmCenterId, java.lang.Integer firstRows) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.lang.Integer dummyUpdateInventoryQuantity(java.lang.Long aCatalogEntryId, java.lang.Integer aFulfillmentId, java.lang.Integer aStoreId) throws javax.naming.NamingException, javax.ejb.CreateException, java.sql.SQLException, java.rmi.RemoteException
public int updatePickBatchPickSlipXML(java.lang.Long aPickBatchId, java.lang.String aPickSlipXML) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.lang.String findPickBatchPickSlipXML(java.lang.Long aPickBatchId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findVendorInformationByVendorId(java.lang.Long vendorId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
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
public java.lang.Integer updateInventoryQuantity(java.util.Hashtable aHashtable) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
public java.util.Vector findExpectedInventoryRecordDetailListByStoreIdAndCatentryId(java.lang.Integer storeId, java.lang.Long catentryId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException