java.lang.Objectcom.ibm.ivj.ejb.runtime.AbstractSessionAccessBean
com.ibm.commerce.inventory.objects.InventoryJDBCHelperAccessBean
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 |
public InventoryJDBCHelperAccessBean()
public InventoryJDBCHelperAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.ejb.CreateException, java.rmi.RemoteException, javax.naming.NamingException
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
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
public int updatePickBatchPickSlipXML(java.lang.Long aPickBatchId, java.lang.String aPickSlipXML) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.lang.Integer updateInventoryQuantity(java.util.Hashtable aHashtable) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.lang.String findPickBatchPickSlipXML(java.lang.Long aPickBatchId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
public java.util.Vector findAvailableReceiptMaxAndMinPrecedence() throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.util.Vector findExpectedInventoryRecordListByStoreentId(java.lang.Integer storeentId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.util.Vector findIsQtyReceivedByRaId(java.lang.Long raId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
public java.util.Vector findItemCurrentVersion(java.lang.Long itemSpcId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.util.Vector findItemSpecWithWhereClause(java.lang.String whereClause, boolean flush) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
public java.util.Vector findOrderItemShippingHistoryByOrderItemsIdOrderByReceiptPrecedence(java.lang.Long orderItemsId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
public java.util.Vector findOrders() throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
public java.util.Vector findPackageInformationListByOrdersId(java.lang.Long ordersId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
public java.util.Vector findPackslipComponentsListByOrderItemsId(java.lang.Long orderItemsId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
public java.util.Vector findPackslipListByPickBatchId(java.lang.Long pickBatchId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
public java.util.Vector findPickItemsListByPickbatchId(java.lang.Long pickbatchId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
public java.util.Vector findReceiptByVersionSpecificationOrderByReceiptPrecedence(java.lang.Long versionSpecificationId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
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
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
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
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
public java.util.Vector findVendorInformationByVendorId(java.lang.Long vendorId) throws javax.naming.NamingException, java.sql.SQLException, java.rmi.RemoteException, javax.ejb.CreateException
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
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
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 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 findItemAvailableInventoryByStoreIdAndItemSpcId(java.lang.Integer storeId, java.lang.Long itemSpcId) 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 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.