com.ibm.commerce.ordermanagement.objects

Class OrderManagementJDBCHelperBean

java.lang.Object

com.ibm.commerce.base.helpers.BaseJDBCHelper

com.ibm.commerce.ordermanagement.objects.OrderManagementJDBCHelperBean

public class OrderManagementJDBCHelperBean
extends BaseJDBCHelper

Field Summary

Fields

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

Fields inherited from class com.ibm.commerce.base.helpers.BaseJDBCHelper

autoFlush, DB_AS400, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE

Constructor Summary

Constructors

Constructor and Description
OrderManagementJDBCHelperBean()

Method Summary

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.

Methods inherited from class com.ibm.commerce.base.helpers.BaseJDBCHelper

buildCommaSeparatedWhereClause, convertResultSetToTable, flush, flush, getCharacterStreamFromResultSet, getDataSource, getDataSource, getInQueryClause, getObject, getObject, getObject, getSavedOptCounterInfoForDelete, getSavedOptCounterInfoForOptimisticSelect, getSavedOptCounterInfoForUpdate, init, init, useCloudscape, useDB2_390, useDB2_400, useDB2, useOracle, useOracle9

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COPYRIGHT

public static final java.lang.String COPYRIGHT

Copyright.

See Also:

Constant Field Values

findReturnRecordComponentListByRmaId

public static final java.lang.String findReturnRecordComponentListByRmaId

findReturnRecordComponentListByRmaId

See Also:

Constant Field Values

findRMAForReceiver

public static final java.lang.String findRMAForReceiver

findRMAForReceiver

See Also:

Constant Field Values

findRMAForReceiverByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForReceiverByStoreIdAndFfmCenterId

findRMAForReceiverByStoreIdAndFfmCenterId

See Also:

Constant Field Values

findRMAForReturnAdminstrator

public static final java.lang.String findRMAForReturnAdminstrator

findRMAForReturnAdminstrator

See Also:

Constant Field Values

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

See Also:

Constant Field Values

findRMAForOperationManager

public static final java.lang.String findRMAForOperationManager

findRMAForOperationManager

See Also:

Constant Field Values

findRMAForOperationManagerByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForOperationManagerByStoreIdAndFfmCenterId

findRMAForOperationManagerByStoreIdAndFfmCenterId

See Also:

Constant Field Values

findPreviousDispositionsListByRtnReceiptIdAndLanguageId

public static final java.lang.String findPreviousDispositionsListByRtnReceiptIdAndLanguageId

findPreviousDispositionsListByRtnReceiptIdAndLanguageId

See Also:

Constant Field Values

findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

public static final java.lang.String findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

See Also:

Constant Field Values

findReturnedProductListByRmaIdAndLanguageId

public static final java.lang.String findReturnedProductListByRmaIdAndLanguageId

findReturnedProductListByRmaIdAndLanguageId

See Also:

Constant Field Values

findDispositionHeaderByRtnReceiptIdAndLanguageId

public static final java.lang.String findDispositionHeaderByRtnReceiptIdAndLanguageId

findDispositionHeaderByRtnReceiptIdAndLanguageId

See Also:

Constant Field Values

findReturnRecordComponentListByRmaIdAndLanguageId

public static final java.lang.String findReturnRecordComponentListByRmaIdAndLanguageId

findReturnRecordComponentListByRmaIdAndLanguageId

See Also:

Constant Field Values

findReturnReasonsListByLanguageIdAndStoreentId

public static final java.lang.String findReturnReasonsListByLanguageIdAndStoreentId

findReturnReasonsListByLanguageIdAndStoreentId

See Also:

Constant Field Values

findRMAItemApprovedRMANotCancelledByOrderId

public static final java.lang.String findRMAItemApprovedRMANotCancelledByOrderId

findRMAItemApprovedRMANotCancelledByOrderId

See Also:

Constant Field Values

findReturnDispositionListByStoreentIdAndLanguageId

public static final java.lang.String findReturnDispositionListByStoreentIdAndLanguageId

findReturnDispositionListByStoreentIdAndLanguageId

See Also:

Constant Field Values

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

public static final java.lang.String findTotalQuantityShippedByOrderItemsIdAndItemSpcId

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

See Also:

Constant Field Values

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

See Also:

Constant Field Values

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

See Also:

Constant Field Values

Constructor Detail

OrderManagementJDBCHelperBean

public OrderManagementJDBCHelperBean()

Method Detail

convertResultSetToRMAList

public java.util.Vector convertResultSetToRMAList(java.sql.ResultSet resultSet,
                                                  java.lang.Integer startindex,
                                                  java.lang.Integer maxLength)
                                           throws java.sql.SQLException

Converts a result set to a vector.

Parameters:

resultSet -

startindex -

maxLength -

Returns:

Throws:

java.sql.SQLException

convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId

public static java.util.Vector convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs)
                                                                                               throws java.sql.SQLException

Converts a result set to a vector.

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

java.sql.SQLException

convertResultSetToTableForMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

public static java.util.Vector convertResultSetToTableForMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.sql.ResultSet rs)
                                                                                                                   throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForPreviousDispositionsListByRtnReceiptIdAndLanguageId

public static java.util.Vector convertResultSetToTableForPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs)
                                                                                                      throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForReturnDispositionListByStoreentIdAndLanguageId

public static java.util.Vector convertResultSetToTableForReturnDispositionListByStoreentIdAndLanguageId(java.sql.ResultSet rs)
                                                                                                 throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForReturnedProductListByRmaIdAndLanguageId

public static java.util.Vector convertResultSetToTableForReturnedProductListByRmaIdAndLanguageId(java.sql.ResultSet rs)
                                                                                          throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForReturnReasonsListByLanguageIdAndStoreentId

public static java.util.Vector convertResultSetToTableForReturnReasonsListByLanguageIdAndStoreentId(java.sql.ResultSet rs)
                                                                                             throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForReturnRecordComponentListByRmaId

public static java.util.Vector convertResultSetToTableForReturnRecordComponentListByRmaId(java.sql.ResultSet rs)
                                                                                   throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForReturnRecordComponentListByRmaIdAndLanguageId

public static java.util.Vector convertResultSetToTableForReturnRecordComponentListByRmaIdAndLanguageId(java.sql.ResultSet rs)
                                                                                                throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForOperationManager

public static java.util.Vector convertResultSetToTableForRMAForOperationManager(java.sql.ResultSet rs)
                                                                         throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForOperationManagerByStoreIdAndFfmCenterId

public static java.util.Vector convertResultSetToTableForRMAForOperationManagerByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
                                                                                                throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForReceiver

public static java.util.Vector convertResultSetToTableForRMAForReceiver(java.sql.ResultSet rs)
                                                                 throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForReceiverByStoreIdAndFfmCenterId

public static java.util.Vector convertResultSetToTableForRMAForReceiverByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
                                                                                        throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForReturnAdminstrator

public static java.util.Vector convertResultSetToTableForRMAForReturnAdminstrator(java.sql.ResultSet rs)
                                                                           throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public static java.util.Vector convertResultSetToTableForRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.sql.ResultSet rs)
                                                                                                  throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForRMAItemApprovedRMANotCancelledByOrderId

public static java.util.Vector convertResultSetToTableForRMAItemApprovedRMANotCancelledByOrderId(java.sql.ResultSet rs)
                                                                                          throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

public static java.util.Vector convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.sql.ResultSet rs)
                                                                                                                           throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

public static java.util.Vector convertResultSetToTableForTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.sql.ResultSet rs)
                                                                                                                               throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

convertResultSetToTableForTotalQuantityShippedByOrderItemsIdAndItemSpcId

public static java.util.Vector convertResultSetToTableForTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.sql.ResultSet rs)
                                                                                                 throws java.sql.SQLException

Insert the method's description here. Creation date: (9/5/2001 9:03:07 PM)

Parameters:

rs - java.sql.ResultSet

Returns:

java.util.Vector

Throws:

java.sql.SQLException

findDispositionHeaderByRtnReceiptIdAndLanguageId

public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
                                                                         java.lang.Integer languageId)
                                                                  throws java.sql.SQLException,
                                                                         javax.naming.NamingException

Find disposition header by return receipt ID and language ID.

Parameters:

rtnReceiptId - return receipt ID

languageId - language ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findDispositionHeaderByRtnReceiptIdAndLanguageId

public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
                                                                         java.lang.Integer languageId,
                                                                         boolean flush)
                                                                  throws java.sql.SQLException,
                                                                         javax.naming.NamingException

Find disposition header by return receipt ID and language ID.

Parameters:

rtnReceiptId - return receipt ID

languageId - language ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

public java.util.Vector findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId,
                                                                                             java.lang.Integer storeentId,
                                                                                             java.lang.Integer storeGroupId)
                                                                                      throws java.sql.SQLException,
                                                                                             javax.naming.NamingException

Find merchant return reason list by language ID and store entity ID and store group ID.

Parameters:

languageId - language ID

storeentId - store entity ID

storeGroupId - store group ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

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

Find merchant return reason list by language ID and store entity ID and store group ID.

Parameters:

languageId - language ID

storeentId - store entity ID

storeGroupId - store group ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findPreviousDispositionsListByRtnReceiptIdAndLanguageId

public java.util.Vector findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
                                                                                java.lang.Integer languageId1,
                                                                                java.lang.Integer languageId2)
                                                                         throws java.sql.SQLException,
                                                                                javax.naming.NamingException

Find previous dispositions list by return receipt ID and language ID.

Parameters:

rtnReceiptId - return receipt ID

languageId1 - language ID 1

languageId2 - language ID 2

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findPreviousDispositionsListByRtnReceiptIdAndLanguageId

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

Find previous dispositions list by return receipt ID and language Id.

Parameters:

rtnReceiptId - return receipt ID

languageId1 - language ID 1

languageId2 - language ID 2

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnDispositionListByStoreentIdAndLanguageId

public java.util.Vector findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId,
                                                                           java.lang.Integer storeentId1,
                                                                           java.lang.Integer storeentId2)
                                                                    throws java.sql.SQLException,
                                                                           javax.naming.NamingException

Find return disposition list by store entity ID and language ID.

Parameters:

languageId - language ID

storeentId1 - store entity ID 1

storeentId2 - store entity ID 2

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnDispositionListByStoreentIdAndLanguageId

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

Find return disposition list by store entity ID and language ID.

Parameters:

languageId - language ID

storeentId1 - store entity ID 1

storeentId2 - store entity ID 2

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnedProductListByRmaIdAndLanguageId

public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
                                                                    java.lang.Integer languageId)
                                                             throws java.sql.SQLException,
                                                                    javax.naming.NamingException

Find returned product list by RMA ID and language ID.

Parameters:

rmaId - RMA ID

languageId - language ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnedProductListByRmaIdAndLanguageId

public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
                                                                    java.lang.Integer languageId,
                                                                    boolean flush)
                                                             throws java.sql.SQLException,
                                                                    javax.naming.NamingException

Find returned product list by RMA ID and language ID.

Parameters:

rmaId - RMA ID

languageId - language ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnReasonsListByLanguageIdAndStoreentId

public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
                                                                       java.lang.Integer storeentId)
                                                                throws java.sql.SQLException,
                                                                       javax.naming.NamingException

Find return reasons list by language ID and store entity ID.

Parameters:

languageId - language ID

storeentId - store entity ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnReasonsListByLanguageIdAndStoreentId

public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
                                                                       java.lang.Integer storeentId,
                                                                       boolean flush)
                                                                throws java.sql.SQLException,
                                                                       javax.naming.NamingException

Find return reasons list by language ID and store entity ID.

Parameters:

languageId - language ID

storeentId - store entity ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnRecordComponentListByRmaId

public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaId)
                                                      throws java.sql.SQLException,
                                                             javax.naming.NamingException

Find return record component list by RMA ID

Parameters:

rmaId - RMA ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnRecordComponentListByRmaId

public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaId,
                                                             boolean flush)
                                                      throws java.sql.SQLException,
                                                             javax.naming.NamingException

Find return record component list by RMA ID.

Parameters:

rmaId - RMA ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnRecordComponentListByRmaIdAndLanguageId

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

Find return record component list by RMA ID and language ID.

Parameters:

rmaId1 - RMA ID 1

languageId1 - language ID 1

rmaId2 - RMA ID 2

languageId2 - language ID 2

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findReturnRecordComponentListByRmaIdAndLanguageId

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

Find return record component list by RMA ID and language ID.

Parameters:

rmaId1 - RMA ID 1

languageId1 - language ID 1

rmaId2 - RMA ID 2

languageId2 - language ID 2

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMABySearchCriteria

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

Find RMA by search criteria.

Parameters:

storeId - store ID

returnId - return ID

contractName - contract name

customerLogonId - customer logon ID

returnStatus - return status

orderId - order ID

startIndex - start index

maxLength - maximum length

Returns:

list of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForOperationManager

public java.util.Vector findRMAForOperationManager()
                                            throws java.sql.SQLException,
                                                   javax.naming.NamingException

Find RMA for operator manager.

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForOperationManager

public java.util.Vector findRMAForOperationManager(boolean flush)
                                            throws java.sql.SQLException,
                                                   javax.naming.NamingException

Find RMA for operation manager.

Parameters:

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForOperationManagerByStoreIdAndFfmCenterId

public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                          java.lang.Integer ffmCenterId)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException

Find RMA for operation manager by store ID and fulfillment center ID.

Parameters:

storeId1 - store ID

ffmCenterId1 - fulfillment center ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForOperationManagerByStoreIdAndFfmCenterId

public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                          java.lang.Integer ffmCenterId,
                                                                          boolean flush)
                                                                   throws java.sql.SQLException,
                                                                          javax.naming.NamingException

Find RMA for operation manager by store ID and fulfillment center ID.

Parameters:

storeId - store ID

ffmCenterId - fulfillment center ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReceiver

public java.util.Vector findRMAForReceiver()
                                    throws java.sql.SQLException,
                                           javax.naming.NamingException

Find RMA for receiver.

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReceiver

public java.util.Vector findRMAForReceiver(boolean flush)
                                    throws java.sql.SQLException,
                                           javax.naming.NamingException

Find RMA for receiver.

Parameters:

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReceiverByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                  java.lang.Integer ffmCenterId)
                                                           throws java.sql.SQLException,
                                                                  javax.naming.NamingException

Find RMA for receiver by store ID and fulfillment center ID.

Parameters:

storeId - store ID

ffmCenterId - fulfillment ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReceiverByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                  java.lang.Integer ffmCenterId,
                                                                  boolean flush)
                                                           throws java.sql.SQLException,
                                                                  javax.naming.NamingException

Find RMA for receiver by store ID and fulfillment center ID.

Parameters:

storeId - store ID

ffmCenterId - fulfillment ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReturnAdminstrator

public java.util.Vector findRMAForReturnAdminstrator()
                                              throws java.sql.SQLException,
                                                     javax.naming.NamingException

Find RMA for return administrator.

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReturnAdminstrator

public java.util.Vector findRMAForReturnAdminstrator(boolean flush)
                                              throws java.sql.SQLException,
                                                     javax.naming.NamingException

Find RMA for return administrator

Parameters:

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                            java.lang.Integer ffmCenterId)
                                                                     throws java.sql.SQLException,
                                                                            javax.naming.NamingException

Find RMA for return administrator by store ID and fulfillment center ID.

Parameters:

storeId - store ID

ffmCenterId - fulfillment center ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                            java.lang.Integer ffmCenterId,
                                                                            boolean flush)
                                                                     throws java.sql.SQLException,
                                                                            javax.naming.NamingException

Find RMA for return administrator by store ID and fulfillment center ID.

Parameters:

storeId - store ID

ffmCenterId - fulfillment center ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAItemApprovedRMANotCancelledByOrderId

public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId)
                                                             throws java.sql.SQLException,
                                                                    javax.naming.NamingException

Find RMA item approved RMA not cancelled by order ID.

Parameters:

ordersId - order ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findRMAItemApprovedRMANotCancelledByOrderId

public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId,
                                                                    boolean flush)
                                                             throws java.sql.SQLException,
                                                                    javax.naming.NamingException

Find RMA item approved RMA not cancelled by order ID.

Parameters:

ordersId - order ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId,
                                                                                                     java.lang.Long itemSpcId,
                                                                                                     java.lang.Long RmaId)
                                                                                              throws java.sql.SQLException,
                                                                                                     javax.naming.NamingException

Find total inventory quantity previously approved by order items and item specification ID exclude RMA ID.

Parameters:

ordersItemsId - order item ID

itemSpcId - item specification ID

RmaId - RMA ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

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

Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA ID.

Parameters:

ordersItemsId - order item ID

itemSpcId - item specification ID

RmaId - RMA ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

public java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId,
                                                                                                         java.lang.Long itemSpcId,
                                                                                                         java.lang.Long RmaItemId)
                                                                                                  throws java.sql.SQLException,
                                                                                                         javax.naming.NamingException

Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA item ID.

Parameters:

ordersItemsId - order item ID

itemSpcId - item specification ID

RmaItemId - RMA item ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

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

Find total inventory quantity previously approved by order items ID and item specification ID exclude RMA item ID.

Parameters:

ordersItemsId -

itemSpcId -

RmaItemId -

flush -

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

public java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId,
                                                                           java.lang.Long itemSpcId)
                                                                    throws java.sql.SQLException,
                                                                           javax.naming.NamingException

Find total quantity shipped by order item ID and item specification ID.

Parameters:

ordersItemsId - order item ID

itemSpcId - item specification ID

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

public java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId,
                                                                           java.lang.Long itemSpcId,
                                                                           boolean flush)
                                                                    throws java.sql.SQLException,
                                                                           javax.naming.NamingException

Find total quantity shipped by order item ID and item specification ID.

Parameters:

ordersItemsId - order item ID

itemSpcId - item specification ID

flush - flush indicator

Returns:

vector of results

Throws:

javax.naming.NamingException

java.sql.SQLException

findExchangeBySearchCriteria

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

Search for Exchanges

Parameters:

storeId - String

customerLogonId - String

exchangeOrderId - String

exchangeAgainstOrderId - String

returnId - String

isCrossShipment - String

startIndex - Integer

maxLength - Integer

Returns:

exchangeList Hashtable

Throws:

javax.naming.NamingException

java.sql.SQLException

RemoteException

convertResultSetToExchangeList

public java.util.Hashtable convertResultSetToExchangeList(java.sql.ResultSet resultSet,
                                                          java.lang.Integer startindex,
                                                          java.lang.Integer maxLength)
                                                   throws java.sql.SQLException

Convert result set to exchange list.

Parameters:

resultSet -

startindex -

maxLength -

Returns:

Throws:

java.sql.SQLException

executeCustomizableReturnSearch

public java.util.Vector executeCustomizableReturnSearch(ECQuery aQuery)
                                                 throws java.sql.SQLException,
                                                        javax.naming.NamingException

Used to execute a customizable return search. This method is used by the ReturnSearchDataBean.

Parameters:

aQuery - The ECQuery object.

Returns:

Vector of Vectors. Each entry in the outer Vector is a row from the resultset, each entry in the inner Vector is a field from the SELECT clause.

Throws:

javax.naming.NamingException

java.sql.SQLException