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

This is a Session Bean Class


Field Summary
static java.lang.String COPYRIGHT
           
static java.lang.String findDispositionHeaderByRtnReceiptIdAndLanguageId
           
static java.lang.String findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId
           
static java.lang.String findPreviousDispositionsListByRtnReceiptIdAndLanguageId
           
static java.lang.String findReturnDispositionListByStoreentIdAndLanguageId
           
static java.lang.String findReturnedProductListByRmaIdAndLanguageId
           
static java.lang.String findReturnReasonsListByLanguageIdAndStoreentId
           
static java.lang.String findReturnRecordComponentListByRmaId
           
static java.lang.String findReturnRecordComponentListByRmaIdAndLanguageId
           
static java.lang.String findRMAForOperationManager
           
static java.lang.String findRMAForOperationManagerByStoreIdAndFfmCenterId
           
static java.lang.String findRMAForReceiver
           
static java.lang.String findRMAForReceiverByStoreIdAndFfmCenterId
           
static java.lang.String findRMAForReturnAdminstrator
           
static java.lang.String findRMAForReturnAdminstratorByStoreIdAndFfmCenterId
           
static java.lang.String findRMAItemApprovedRMANotCancelledByOrderId
           
static java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId
           
static java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId
           
static java.lang.String findTotalQuantityShippedByOrderItemsIdAndItemSpcId
           
 
Fields inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper
autoFlush, DATASOURCE, dataSourceConfigData, DB_DB2, DB_DB2_390, DB_DB2J, DB_ORACLE, DBTYPE, mySessionCtx
 
Constructor Summary
OrderManagementJDBCHelperBean()
           
 
Method Summary
static java.util.Vector convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId(java.sql.ResultSet rs)
          Insert the method's description here.
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.
 void ejbActivate()
          ejbActivate method comment
 void ejbCreate()
          ejbCreate method comment
 void ejbPassivate()
          ejbPassivate method comment
 void ejbRemove()
          ejbRemove method comment
 java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId)
          Insert the method's description here.
 java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId, boolean flush)
          Insert the method's description here.
 java.util.Vector findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId, java.lang.Integer storeentId, java.lang.Integer storeGroupId)
          Insert the method's description here.
 java.util.Vector findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId(java.lang.Integer languageId, java.lang.Integer storeentId, java.lang.Integer storeGroupId, boolean flush)
          Insert the method's description here.
 java.util.Vector findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId1, java.lang.Integer languageId2)
          Insert the method's description here.
 java.util.Vector findPreviousDispositionsListByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId, java.lang.Integer languageId1, java.lang.Integer languageId2, boolean flush)
          Insert the method's description here.
 java.util.Vector findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId, java.lang.Integer storeentId1, java.lang.Integer storeentId2)
          Insert the method's description here.
 java.util.Vector findReturnDispositionListByStoreentIdAndLanguageId(java.lang.Integer languageId, java.lang.Integer storeentId1, java.lang.Integer storeentId2, boolean flush)
          Insert the method's description here.
 java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId, java.lang.Integer languageId)
          Insert the method's description here.
 java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId, java.lang.Integer languageId, boolean flush)
          Insert the method's description here.
 java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId, java.lang.Integer storeentId)
          Insert the method's description here.
 java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId, java.lang.Integer storeentId, boolean flush)
          Insert the method's description here.
 java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaItemId)
          Insert the method's description here.
 java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaItemId, boolean flush)
          Insert the method's description here.
 java.util.Vector findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1, java.lang.Integer languageId1, java.lang.Long rmaId2, java.lang.Integer languageId2)
          Insert the method's description here.
 java.util.Vector findReturnRecordComponentListByRmaIdAndLanguageId(java.lang.Long rmaId1, java.lang.Integer languageId1, java.lang.Long rmaId2, java.lang.Integer languageId2, boolean flush)
          Insert the method's description here.
 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)
           
 java.util.Vector findRMAForOperationManager()
          Insert the method's description here.
 java.util.Vector findRMAForOperationManager(boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId1, java.lang.Integer ffmCenterId1)
          Insert the method's description here.
 java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId1, java.lang.Integer ffmCenterId1, boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAForReceiver()
          Insert the method's description here.
 java.util.Vector findRMAForReceiver(boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId)
          Insert the method's description here.
 java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId, boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAForReturnAdminstrator()
          Insert the method's description here.
 java.util.Vector findRMAForReturnAdminstrator(boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId)
          Insert the method's description here.
 java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId, java.lang.Integer ffmCenterId, boolean flush)
          Insert the method's description here.
 java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId)
          Insert the method's description here.
 java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId, boolean flush)
          Insert the method's description here.
 java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaId)
           
 java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaId, boolean flush)
           
 java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaItemId)
           
 java.util.Vector findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, java.lang.Long RmaItemId, boolean flush)
           
 java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId)
           
 java.util.Vector findTotalQuantityShippedByOrderItemsIdAndItemSpcId(java.lang.Long ordersItemsId, java.lang.Long itemSpcId, boolean flush)
           
 javax.ejb.SessionContext getSessionContext()
          getSessionContext method comment
 void setSessionContext(javax.ejb.SessionContext ctx)
          setSessionContext method comment
 
Methods inherited from class com.ibm.commerce.base.helpers. BaseJDBCHelper
buildCommaSeparatedWhereClause, closeConnection, convertFirstRowToHashtable, convertResultSetToTable, convertRowFromHashtable, debugInitConnection, executeQuery, executeUpdate, flush, getCallableStatement, getCharacterStreamFromResultSet, getConnection, getDataSource, getPreparedStatement, getPreparedStatement, init, init, makeConnection, useCloudscape, useDB2_390, useDB2, useOracle
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail
public static final java.lang.String COPYRIGHT
See Also:
Constant Field Values

findReturnRecordComponentListByRmaId

public static final java.lang.String findReturnRecordComponentListByRmaId
See Also:
Constant Field Values

findRMAForReceiver

public static final java.lang.String findRMAForReceiver
See Also:
Constant Field Values

findRMAForReceiverByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForReceiverByStoreIdAndFfmCenterId
See Also:
Constant Field Values

findRMAForReturnAdminstrator

public static final java.lang.String findRMAForReturnAdminstrator
See Also:
Constant Field Values

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForReturnAdminstratorByStoreIdAndFfmCenterId
See Also:
Constant Field Values

findRMAForOperationManager

public static final java.lang.String findRMAForOperationManager
See Also:
Constant Field Values

findRMAForOperationManagerByStoreIdAndFfmCenterId

public static final java.lang.String findRMAForOperationManagerByStoreIdAndFfmCenterId
See Also:
Constant Field Values

findPreviousDispositionsListByRtnReceiptIdAndLanguageId

public static final java.lang.String findPreviousDispositionsListByRtnReceiptIdAndLanguageId
See Also:
Constant Field Values

findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId

public static final java.lang.String findMerchantReturnReasonListByLanguageIdAndStoreentIdAndStoreGroupId
See Also:
Constant Field Values

findReturnedProductListByRmaIdAndLanguageId

public static final java.lang.String findReturnedProductListByRmaIdAndLanguageId
See Also:
Constant Field Values

findDispositionHeaderByRtnReceiptIdAndLanguageId

public static final java.lang.String findDispositionHeaderByRtnReceiptIdAndLanguageId
See Also:
Constant Field Values

findReturnRecordComponentListByRmaIdAndLanguageId

public static final java.lang.String findReturnRecordComponentListByRmaIdAndLanguageId
See Also:
Constant Field Values

findReturnReasonsListByLanguageIdAndStoreentId

public static final java.lang.String findReturnReasonsListByLanguageIdAndStoreentId
See Also:
Constant Field Values

findRMAItemApprovedRMANotCancelledByOrderId

public static final java.lang.String findRMAItemApprovedRMANotCancelledByOrderId
See Also:
Constant Field Values

findReturnDispositionListByStoreentIdAndLanguageId

public static final java.lang.String findReturnDispositionListByStoreentIdAndLanguageId
See Also:
Constant Field Values

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

public static final java.lang.String findTotalQuantityShippedByOrderItemsIdAndItemSpcId
See Also:
Constant Field Values

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId

public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaId
See Also:
Constant Field Values

findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId

public static final java.lang.String findTotalInvQuantityPreviouslyApprovedByOrderItemsIdAndItemSpcIdExcludeRmaItemId
See Also:
Constant Field Values
Constructor Detail

OrderManagementJDBCHelperBean

public OrderManagementJDBCHelperBean()
Method Detail

convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId

public static java.util.Vector convertResultSetToTableForDispositionHeaderByRtnReceiptIdAndLanguageId(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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
java.sql.SQLException

ejbActivate

public void ejbActivate()
ejbActivate method comment
Throws:
java.rmi.RemoteException - The exception description.

ejbCreate

public void ejbCreate()
               throws javax.ejb.CreateException
ejbCreate method comment
Throws:
javax.ejb.CreateException - The exception description.
java.rmi.RemoteException - The exception description.

ejbPassivate

public void ejbPassivate()
ejbPassivate method comment
Throws:
java.rmi.RemoteException - The exception description.

ejbRemove

public void ejbRemove()
ejbRemove method comment
Throws:
java.rmi.RemoteException - The exception description.

findDispositionHeaderByRtnReceiptIdAndLanguageId

public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
                                                                         java.lang.Integer languageId)
                                                                  throws javax.naming.NamingException,
                                                                         java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findDispositionHeaderByRtnReceiptIdAndLanguageId

public java.util.Vector findDispositionHeaderByRtnReceiptIdAndLanguageId(java.lang.Long rtnReceiptId,
                                                                         java.lang.Integer languageId,
                                                                         boolean flush)
                                                                  throws javax.naming.NamingException,
                                                                         java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
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 javax.naming.NamingException,
                                                                                             java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Parameters:
storeentId - java.lang.Integer
Returns:
java.lang.Integer
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 javax.naming.NamingException,
                                                                                             java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
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 javax.naming.NamingException,
                                                                                java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
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 javax.naming.NamingException,
                                                                                java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
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 javax.naming.NamingException,
                                                                           java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
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 javax.naming.NamingException,
                                                                           java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findReturnedProductListByRmaIdAndLanguageId

public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
                                                                    java.lang.Integer languageId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findReturnedProductListByRmaIdAndLanguageId

public java.util.Vector findReturnedProductListByRmaIdAndLanguageId(java.lang.Long rmaId,
                                                                    java.lang.Integer languageId,
                                                                    boolean flush)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findReturnReasonsListByLanguageIdAndStoreentId

public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
                                                                       java.lang.Integer storeentId)
                                                                throws javax.naming.NamingException,
                                                                       java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Parameters:
storeentId - java.lang.Integer
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findReturnReasonsListByLanguageIdAndStoreentId

public java.util.Vector findReturnReasonsListByLanguageIdAndStoreentId(java.lang.Integer languageId,
                                                                       java.lang.Integer storeentId,
                                                                       boolean flush)
                                                                throws javax.naming.NamingException,
                                                                       java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findReturnRecordComponentListByRmaId

public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaItemId)
                                                      throws javax.naming.NamingException,
                                                             java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findReturnRecordComponentListByRmaId

public java.util.Vector findReturnRecordComponentListByRmaId(java.lang.Long rmaItemId,
                                                             boolean flush)
                                                      throws javax.naming.NamingException,
                                                             java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
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 javax.naming.NamingException,
                                                                          java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
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 javax.naming.NamingException,
                                                                          java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMABySearchCriteria

public 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 javax.naming.NamingException,
                                               java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException

findRMAForOperationManager

public java.util.Vector findRMAForOperationManager()
                                            throws javax.naming.NamingException,
                                                   java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForOperationManager

public java.util.Vector findRMAForOperationManager(boolean flush)
                                            throws javax.naming.NamingException,
                                                   java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAForOperationManagerByStoreIdAndFfmCenterId

public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId1,
                                                                          java.lang.Integer ffmCenterId1)
                                                                   throws javax.naming.NamingException,
                                                                          java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForOperationManagerByStoreIdAndFfmCenterId

public java.util.Vector findRMAForOperationManagerByStoreIdAndFfmCenterId(java.lang.Integer storeId1,
                                                                          java.lang.Integer ffmCenterId1,
                                                                          boolean flush)
                                                                   throws javax.naming.NamingException,
                                                                          java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAForReceiver

public java.util.Vector findRMAForReceiver()
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForReceiver

public java.util.Vector findRMAForReceiver(boolean flush)
                                    throws javax.naming.NamingException,
                                           java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAForReceiverByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                  java.lang.Integer ffmCenterId)
                                                           throws javax.naming.NamingException,
                                                                  java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForReceiverByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReceiverByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                  java.lang.Integer ffmCenterId,
                                                                  boolean flush)
                                                           throws javax.naming.NamingException,
                                                                  java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAForReturnAdminstrator

public java.util.Vector findRMAForReturnAdminstrator()
                                              throws javax.naming.NamingException,
                                                     java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForReturnAdminstrator

public java.util.Vector findRMAForReturnAdminstrator(boolean flush)
                                              throws javax.naming.NamingException,
                                                     java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                            java.lang.Integer ffmCenterId)
                                                                     throws javax.naming.NamingException,
                                                                            java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAForReturnAdminstratorByStoreIdAndFfmCenterId

public java.util.Vector findRMAForReturnAdminstratorByStoreIdAndFfmCenterId(java.lang.Integer storeId,
                                                                            java.lang.Integer ffmCenterId,
                                                                            boolean flush)
                                                                     throws javax.naming.NamingException,
                                                                            java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
javax.naming.NamingException
java.sql.SQLException

findRMAItemApprovedRMANotCancelledByOrderId

public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException
Insert the method's description here. Creation date: (5/10/2001 10:08:32 AM)
Returns:
java.lang.Integer
javax.naming.NamingException
java.sql.SQLException

findRMAItemApprovedRMANotCancelledByOrderId

public java.util.Vector findRMAItemApprovedRMANotCancelledByOrderId(java.lang.Long ordersId,
                                                                    boolean flush)
                                                             throws javax.naming.NamingException,
                                                                    java.sql.SQLException
Insert the method's description here. Creation date: (3/15/01 10:37:28 AM)
Returns:
java.util.Vector
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 javax.naming.NamingException,
                                                                                                     java.sql.SQLException
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 javax.naming.NamingException,
                                                                                                     java.sql.SQLException
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 javax.naming.NamingException,
                                                                                                         java.sql.SQLException
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 javax.naming.NamingException,
                                                                                                         java.sql.SQLException
javax.naming.NamingException
java.sql.SQLException

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

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

findTotalQuantityShippedByOrderItemsIdAndItemSpcId

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

getSessionContext

public javax.ejb.SessionContext getSessionContext()
getSessionContext method comment
Specified by:
getSessionContext in class BaseJDBCHelper
Returns:
javax.ejb.SessionContext

setSessionContext

public void setSessionContext(javax.ejb.SessionContext ctx)
setSessionContext method comment
Parameters:
ctx - javax.ejb.SessionContext
Throws:
java.rmi.RemoteException - The exception description.