public class OrderManagementJDBCHelperBean extends BaseJDBCHelper
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
COPYRIGHT
Copyright.
|
static java.lang.String |
findDispositionHeaderByRtnReceiptIdAndLanguageId
findDispositionHeaderByRtnReceiptIdAndLanguageId
|
static java.lang.String |
findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId
findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId
|
static java.lang.String |
findPreviousDispositionsListByRtnReceiptIdAndLanguageId
findPreviousDispositionsListByRtnReceiptIdAndLanguageId
|
static java.lang.String |
findReturnDispositionListByStoreentIdAndLanguageId
findReturnDispositionListByStoreentIdAndLanguageId
|
static java.lang.String |
findReturnedProductListByRmaIdAndLanguageId
findReturnedProductListByRmaIdAndLanguageId
|
static java.lang.String |
findReturnReasonsListByLanguageIdAndStoreentId
findReturnReasonsListByLanguageIdAndStoreentId
|
static java.lang.String |
findReturnRecordComponentListByRmaId
findReturnRecordComponentListByRmaId
|
static java.lang.String |
findReturnRecordComponentListByRmaIdAndLanguageId
findReturnRecordComponentListByRmaIdAndLanguageId
|
static java.lang.String |
findRMAForOperationManager
findRMAForOperationManager
|
static java.lang.String |
findRMAForOperationManagerByStoreIdAndFfmCenterId
findRMAForOperationManagerByStoreIdAndFfmCenterId
|
static java.lang.String |
findRMAForReceiver
findRMAForReceiver
|
static java.lang.String |
findRMAForReceiverByStoreIdAndFfmCenterId
findRMAForReceiverByStoreIdAndFfmCenterId
|
static java.lang.String |
findRMAForReturnAdminstrator
findRMAForReturnAdminstrator
|
static java.lang.String |
findRMAForReturnAdminstratorByStoreIdAndFfmCenterId
findRMAForReturnAdminstratorByStoreIdAndFfmCenterId
|
static java.lang.String |
findRMAItemApprovedRMANotCancelledByOrderId
findRMAItemApprovedRMANotCancelledByOrderId
|
static java.lang.String |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId
|
static java.lang.String |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId
|
static java.lang.String |
findTotalQuantityShippedByOrderItemsIdAndItemSpcId
findTotalQuantityShippedByOrderItemsIdAndItemSpcId
|
autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE
Constructor and Description |
---|
OrderManagementJDBCHelperBean() |
Modifier and Type | Method and Description |
---|---|
java.util.Hashtable |
convertResultSetToExchangeList(java.sql.ResultSet resultSet,
java.lang.Integer startindex,
java.lang.Integer maxLength)
Convert result set to exchange list.
|
java.util.Vector |
convertResultSetToRMAList(java.sql.ResultSet resultSet,
java.lang.Integer startindex,
java.lang.Integer maxLength)
Converts a result set to a vector.
|
static java.util.Vector |
convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs)
Converts a result set to a vector.
|
static java.util.Vector |
convertResultSetToTableForMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForReturnDispositionListByStoreentIdAndLanguageId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForReturnedProductListByRmaIdAndLanguageId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForReturnReasonsListByLanguageIdAndStoreentId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForReturnRecordComponentListByRmaId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForReturnRecordComponentListByRmaIdAndLanguageId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForOperationManager(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForOperationManagerByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForReceiver(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForReceiverByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForReturnAdminstrator(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForRMAItemApprovedRMANotCancelledByOrderId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.sql.ResultSet rs)
Insert the method's description here.
|
static java.util.Vector |
convertResultSetToTableForTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.sql.ResultSet rs)
Insert the method's description here.
|
java.util.Vector |
executeCustomizableReturnSearch(ECQuery aQuery)
Used to execute a customizable return search.
|
java.util.Vector |
findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
java.lang.Integer languageId)
Find disposition header by return receipt ID and language ID.
|
java.util.Vector |
findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
java.lang.Integer languageId,
boolean flush)
Find disposition header by return receipt ID and language ID.
|
java.util.Hashtable |
findExchangeBySearchCriteria(java.lang.String storeId,
java.lang.String customerLogonId,
java.lang.String exchangeOrderId,
java.lang.String exchangeAgainstOrderId,
java.lang.String returnId,
java.lang.String isCrossShipment,
java.lang.Integer startIndex,
java.lang.Integer maxLength)
Search for Exchanges
|
java.util.Vector |
findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId,
java.lang.Integer storeentId,
java.lang.Integer storeGroupId)
Find merchant return reason list by language ID and store entity ID and store group ID.
|
java.util.Vector |
findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId,
java.lang.Integer storeentId,
java.lang.Integer storeGroupId,
boolean flush)
Find merchant return reason list by language ID and store entity ID and store group ID.
|
java.util.Vector |
findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
java.lang.Integer languageId1,
java.lang.Integer languageId2)
Find previous dispositions list by return receipt ID and language ID.
|
java.util.Vector |
findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
java.lang.Integer languageId1,
java.lang.Integer languageId2,
boolean flush)
Find previous dispositions list by return receipt ID and language Id.
|
java.util.Vector |
findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId,
java.lang.Integer storeentId1,
java.lang.Integer storeentId2)
Find return disposition list by store entity ID and language ID.
|
java.util.Vector |
findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId,
java.lang.Integer storeentId1,
java.lang.Integer storeentId2,
boolean flush)
Find return disposition list by store entity ID and language ID.
|
java.util.Vector |
findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
java.lang.Integer languageId)
Find returned product list by RMA ID and language ID.
|
java.util.Vector |
findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
java.lang.Integer languageId,
boolean flush)
Find returned product list by RMA ID and language ID.
|
java.util.Vector |
findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
java.lang.Integer storeentId)
Find return reasons list by language ID and store entity ID.
|
java.util.Vector |
findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
java.lang.Integer storeentId,
boolean flush)
Find return reasons list by language ID and store entity ID.
|
java.util.Vector |
findReturnRecordComponentListByRmaId(java.lang.Long rmaId)
Find return record component list by RMA ID
|
java.util.Vector |
findReturnRecordComponentListByRmaId(java.lang.Long rmaId,
boolean flush)
Find return record component list by RMA ID.
|
java.util.Vector |
findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1,
java.lang.Integer languageId1,
java.lang.Long rmaId2,
java.lang.Integer languageId2)
Find return record component list by RMA ID and language ID.
|
java.util.Vector |
findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1,
java.lang.Integer languageId1,
java.lang.Long rmaId2,
java.lang.Integer languageId2,
boolean flush)
Find return record component list by RMA ID and language ID.
|
com.ibm.commerce.tools.optools.common.helpers.DynamicListData |
findRMABySearchCriteria(java.lang.String storeId,
java.lang.String returnId,
java.lang.String contractName,
java.lang.String customerLogonId,
java.lang.String returnStatus,
java.lang.String orderId,
java.lang.Integer startIndex,
java.lang.Integer maxLength)
Find RMA by search criteria.
|
java.util.Vector |
findRMAForOperationManager()
Find RMA for operator manager.
|
java.util.Vector |
findRMAForOperationManager(boolean flush)
Find RMA for operation manager.
|
java.util.Vector |
findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId)
Find RMA for operation manager by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId,
boolean flush)
Find RMA for operation manager by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAForReceiver()
Find RMA for receiver.
|
java.util.Vector |
findRMAForReceiver(boolean flush)
Find RMA for receiver.
|
java.util.Vector |
findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId)
Find RMA for receiver by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId,
boolean flush)
Find RMA for receiver by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAForReturnAdminstrator()
Find RMA for return administrator.
|
java.util.Vector |
findRMAForReturnAdminstrator(boolean flush)
Find RMA for return administrator
|
java.util.Vector |
findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId)
Find RMA for return administrator by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
java.lang.Integer ffmCenterId,
boolean flush)
Find RMA for return administrator by store ID and fulfillment center ID.
|
java.util.Vector |
findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId)
Find RMA item approved RMA not cancelled by order ID.
|
java.util.Vector |
findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId,
boolean flush)
Find RMA item approved RMA not cancelled by order ID.
|
java.util.Vector |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId,
java.lang.Long RmaId)
Find total inventory quantity previously approved by order items and item specification ID exclude RMA ID.
|
java.util.Vector |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId,
java.lang.Long RmaId,
boolean flush)
Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA ID.
|
java.util.Vector |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId,
java.lang.Long RmaItemId)
Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA item ID.
|
java.util.Vector |
findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId,
java.lang.Long RmaItemId,
boolean flush)
Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA item ID.
|
java.util.Vector |
findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId)
Find total quantity shipped by order item ID and item specification ID.
|
java.util.Vector |
findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId,
java.lang.Long itemSpcId,
boolean flush)
Find total quantity shipped by order item ID and item specification ID.
|
buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9
public static final java.lang.String COPYRIGHT
public static final java.lang.String findReturnRecordComponentListByRmaId
public static final java.lang.String findRMAForReceiver
public static final java.lang.String findRMAForReceiverByStoreIdAndFfmCenterId
public static final java.lang.String findRMAForReturnAdminstrator
public static final java.lang.String findRMAForReturnAdminstratorByStoreIdAndFfmCenterId
public static final java.lang.String findRMAForOperationManager
public static final java.lang.String findRMAForOperationManagerByStoreIdAndFfmCenterId
public static final java.lang.String findPreviousDispositionsListByRtnReceiptIdAndLanguageId
public static final java.lang.String findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId
public static final java.lang.String findReturnedProductListByRmaIdAndLanguageId
public static final java.lang.String findDispositionHeaderByRtnReceiptIdAndLanguageId
public static final java.lang.String findReturnRecordComponentListByRmaIdAndLanguageId
public static final java.lang.String findReturnReasonsListByLanguageIdAndStoreentId
public static final java.lang.String findRMAItemApprovedRMANotCancelledByOrderId
public static final java.lang.String findReturnDispositionListByStoreentIdAndLanguageId
public static final java.lang.String findTotalQuantityShippedByOrderItemsIdAndItemSpcId
public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId
public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId
public java.util.Vector convertResultSetToRMAList(java.sql.ResultSet resultSet, java.lang.Integer startindex, java.lang.Integer maxLength) throws java.sql.SQLException
resultSet
- startindex
- maxLength
- java.sql.SQLException
public static java.util.Vector convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
java.sql.SQLException
public static java.util.Vector convertResultSetToTableForMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForReturnDispositionListByStoreentIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForReturnedProductListByRmaIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForReturnReasonsListByLanguageIdAndStoreentId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForReturnRecordComponentListByRmaId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForReturnRecordComponentListByRmaIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForOperationManager(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForOperationManagerByStoreIdAndFfmCenterId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForReceiver(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForReceiverByStoreIdAndFfmCenterId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForReturnAdminstrator(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForRMAItemApprovedRMANotCancelledByOrderId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public static java.util.Vector convertResultSetToTableForTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- java.sql.ResultSetjava.sql.SQLException
public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId) throws java.sql.SQLException, javax.naming.NamingException
rtnReceiptId
- return receipt IDlanguageId
- language IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
rtnReceiptId
- return receipt IDlanguageId
- language IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId, java.lang.Integer storeentId, java.lang.Integer storeGroupId) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId
- store entity IDstoreGroupId
- store group IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId, java.lang.Integer storeentId, java.lang.Integer storeGroupId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId
- store entity IDstoreGroupId
- store group IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId1, java.lang.Integer languageId2) throws java.sql.SQLException, javax.naming.NamingException
rtnReceiptId
- return receipt IDlanguageId1
- language ID 1languageId2
- language ID 2javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId1, java.lang.Integer languageId2, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
rtnReceiptId
- return receipt IDlanguageId1
- language ID 1languageId2
- language ID 2flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId, java.lang.Integer storeentId1, java.lang.Integer storeentId2) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId1
- store entity ID 1storeentId2
- store entity ID 2javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId, java.lang.Integer storeentId1, java.lang.Integer storeentId2, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId1
- store entity ID 1storeentId2
- store entity ID 2flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId, java.lang.Integer languageId) throws java.sql.SQLException, javax.naming.NamingException
rmaId
- RMA IDlanguageId
- language IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId, java.lang.Integer languageId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
rmaId
- RMA IDlanguageId
- language IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId, java.lang.Integer storeentId) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId
- store entity IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId, java.lang.Integer storeentId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
languageId
- language IDstoreentId
- store entity IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaId) throws java.sql.SQLException, javax.naming.NamingException
rmaId
- RMA IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
rmaId
- RMA IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1, java.lang.Integer languageId1, java.lang.Long rmaId2, java.lang.Integer languageId2) throws java.sql.SQLException, javax.naming.NamingException
rmaId1
- RMA ID 1languageId1
- language ID 1rmaId2
- RMA ID 2languageId2
- language ID 2javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1, java.lang.Integer languageId1, java.lang.Long rmaId2, java.lang.Integer languageId2, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
rmaId1
- RMA ID 1languageId1
- language ID 1rmaId2
- RMA ID 2languageId2
- language ID 2flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public com.ibm.commerce.tools.optools.common.helpers.DynamicListData findRMABySearchCriteria(java.lang.String storeId, java.lang.String returnId, java.lang.String contractName, java.lang.String customerLogonId, java.lang.String returnStatus, java.lang.String orderId, java.lang.Integer startIndex, java.lang.Integer maxLength) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDreturnId
- return IDcontractName
- contract namecustomerLogonId
- customer logon IDreturnStatus
- return statusorderId
- order IDstartIndex
- start indexmaxLength
- maximum lengthjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForOperationManager() throws java.sql.SQLException, javax.naming.NamingException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForOperationManager(boolean flush) throws java.sql.SQLException, javax.naming.NamingException
flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId) throws java.sql.SQLException, javax.naming.NamingException
storeId1
- store IDffmCenterId1
- fulfillment center IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDffmCenterId
- fulfillment center IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReceiver() throws java.sql.SQLException, javax.naming.NamingException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReceiver(boolean flush) throws java.sql.SQLException, javax.naming.NamingException
flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDffmCenterId
- fulfillment IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDffmCenterId
- fulfillment IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReturnAdminstrator() throws java.sql.SQLException, javax.naming.NamingException
javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReturnAdminstrator(boolean flush) throws java.sql.SQLException, javax.naming.NamingException
flush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDffmCenterId
- fulfillment center IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
storeId
- store IDffmCenterId
- fulfillment center IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId) throws java.sql.SQLException, javax.naming.NamingException
ordersId
- order IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
ordersId
- order IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaId) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- order item IDitemSpcId
- item specification IDRmaId
- RMA IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- order item IDitemSpcId
- item specification IDRmaId
- RMA IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaItemId) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- order item IDitemSpcId
- item specification IDRmaItemId
- RMA item IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaItemId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- itemSpcId
- RmaItemId
- flush
- javax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- order item IDitemSpcId
- item specification IDjavax.naming.NamingException
java.sql.SQLException
public java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, boolean flush) throws java.sql.SQLException, javax.naming.NamingException
ordersItemsId
- order item IDitemSpcId
- item specification IDflush
- flush indicatorjavax.naming.NamingException
java.sql.SQLException
public java.util.Hashtable findExchangeBySearchCriteria(java.lang.String storeId, java.lang.String customerLogonId, java.lang.String exchangeOrderId, java.lang.String exchangeAgainstOrderId, java.lang.String returnId, java.lang.String isCrossShipment, java.lang.Integer startIndex, java.lang.Integer maxLength) throws java.sql.SQLException, javax.naming.NamingException
storeId
- StringcustomerLogonId
- StringexchangeOrderId
- StringexchangeAgainstOrderId
- StringreturnId
- StringisCrossShipment
- StringstartIndex
- IntegermaxLength
- Integerjavax.naming.NamingException
java.sql.SQLException
RemoteException
public java.util.Hashtable convertResultSetToExchangeList(java.sql.ResultSet resultSet, java.lang.Integer startindex, java.lang.Integer maxLength) throws java.sql.SQLException
resultSet
- startindex
- maxLength
- java.sql.SQLException
public java.util.Vector executeCustomizableReturnSearch(ECQuery aQuery) throws java.sql.SQLException, javax.naming.NamingException
aQuery
- The ECQuery object.javax.naming.NamingException
java.sql.SQLException