com.ibm.commerce.order.objects
Class OrderAccessBean

java.lang.Object
  com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
      com.ibm.commerce.order.objects.OrderAccessBean
All Implemented Interfaces:
OrderAccessBeanData
Direct Known Subclasses:
OrderDataBeanBase, OrderFlowEntityBean, OrderListDataBeanBase, RequisitionDataBeanBase

public class OrderAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements OrderAccessBeanData

Each row in this table represents an order in a store. This access bean corresponds to the database table 'ORDERS'.

See Also:
Serialized Form

Constructor Summary
OrderAccessBean()
Zero argument constructor used to initialize the access bean.
OrderAccessBean(javax.ejb.EJBObject o)
constructor
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.math.BigDecimal arg4, java.sql.Timestamp arg5)
Maps to a corresponding ejbCreate method in the home interface of the EJB
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.lang.Double arg3, java.sql.Timestamp arg4)
Maps to a corresponding ejbCreate method in the home interface of the EJB
OrderAccessBean(java.lang.Long arg1, java.lang.Integer arg2, java.sql.Timestamp arg3)
Maps to a corresponding ejbCreate method in the home interface of the EJB
Method Summary
void clearOrderItemsCache()
void commitCopyHelper()
Update(flush) data to the EJBObject (persistent storage).
protected java.lang.String defaultJNDIName()
java.util.Enumeration findByMemberForUpdate(java.lang.Long memberId) Retrieves all the orders for given customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update
OrderAccessBean findByOrderForUpdate(java.lang.Long orderId) Retrieves OrderAccessBean representing the order with specified order identifier. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update
java.util.Enumeration findByOrderIds(java.lang.Long[] anOrderIds)
findByOrderIds
java.util.Enumeration findByStatus(java.lang.String argStatus) Retrieves all the orders with specified status. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?)
java.util.Enumeration findByStatusAndMember(java.lang.String argStatus, java.lang.Long argMemberId) Retrieves all the orders for specified status and member. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID
java.util.Enumeration findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusAndMemberScopedByLastUpdate
java.util.Enumeration findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusAndMemberScopedByTimePlaced
java.util.Enumeration findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer aChannelStoreId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField
java.util.Enumeration findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.lang.String aRelType, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findByStatusesMemberStoresRelTypeStartEndDateAndDateField
java.util.Enumeration findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList, java.lang.Long aMemberId, java.lang.Integer[] aStoreIdList, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findByStatusesMemberStoresStartEndDateAndDateField
java.util.Enumeration findByStatusMemberAndRelType(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType)
findByStatusMemberAndRelType
java.util.Enumeration findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberAndRelTypeScopedByLastUpdate
java.util.Enumeration findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberAndRelTypeScopedByTimePlaced
java.util.Enumeration findByStatusMemberAndStore(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId) Retrieves all the orders for specified status, member and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID
java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String status, java.lang.Long memberId, java.lang.Integer storeId) Retrieves all the orders for specified status, member and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update
java.util.Enumeration findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId)
Gets all the orders for the user under those merchant hosted at channel merchant that are in the state specified.
java.util.Enumeration findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberAndStoreScopedByLastUpdate
java.util.Enumeration findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus, java.lang.Long argMemberId, java.lang.Integer argStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberAndStoreScopedByTimePlaced
java.util.Enumeration findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId)
findByStatusMemberRelTypeAndStore
java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberRelTypeAndStoreScopedByLastUpdate
java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus, java.lang.Long inUserId, java.lang.String istrRelType, java.lang.Integer inStoreId, java.sql.Timestamp argStartDate, java.sql.Timestamp argEndDate)
findByStatusMemberRelTypeAndStoreScopedByTimePlaced
java.util.Enumeration findByStatusStoreentIdAndDescription(java.lang.String status, java.lang.Integer storeentId, java.lang.String description)
findByStatusStoreentIdAndDescription
java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer storeId, java.lang.Long memberId, java.lang.String status, java.lang.String orderByClause, boolean forUpdate)
IBM internal use only.
java.util.Enumeration findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds, java.lang.Long aOrdersId, java.lang.String aRelType)
findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType
java.util.Enumeration findCurrentPendingOrders() Retrieves all the current pending orders. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long argMemberId) Retrieves all the current pending orders for specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE
java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long argMemberId, java.lang.Integer argStoreId) Retrieves all the current pending orders for specified customer and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE
java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
findFullyTransferredOrdersByChannelStoreIdAndShopperId
java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
java.util.Enumeration findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
findNotTransferredOrdersByChannelStoreIdAndShopperId
java.util.Enumeration findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
java.util.Enumeration findOrderTemplatesByMember(java.lang.Long memberId) Retrieves all the order templates for specified member. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long memberId, java.lang.Integer usage) Retrieves all the order templates for specified member and usage. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer storeId, java.lang.Long memberId) Retrieves all the order templates for specified store and member. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)
java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage) Retrieves all the order templates for specified store, member and usage. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)
OrderAccessBean findParentOrderByOrdersId(java.lang.Long aOrdersId)
findParentOrderByOrdersId
java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
findPartlyTransferredOrdersByChannelStoreIdAndShopperId
java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
java.util.Enumeration findPendingOrders(java.lang.Long argUserReferenceNumber, java.lang.Long argMerchantReferenceNumber) Retrieves all the pending orders for given customer and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P')
java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long memberId) Retrieves all the private requisition lists for specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) Retrieves all the private requisition lists for specified customer and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
java.util.Enumeration findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long memberId) Retrieves all the private requisition lists for specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE
java.util.Enumeration findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId, java.lang.Long aShopperId)
findProcessedOrdersByChannelStoreIdAndShopperId
java.util.Enumeration findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId, java.lang.Long memberId, java.sql.Timestamp startDate, java.sql.Timestamp endDate, java.lang.String dateField)
findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long memberId) Retrieves all the shareable requisition lists that can be accessed by the specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?))
java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?)
java.util.Enumeration findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long memberId) Retrieves all the shareable requisition lists for specified customer. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?)
java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long memberId, java.lang.Integer storeId) Retrieves all the shareable requisition lists for specified customer and store. The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)
java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId, java.lang.Integer channelStoreId)
findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel
java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer storeId, java.lang.Long memberId, java.lang.Integer usage, java.lang.String orderByClause, boolean forUpdate)
IBM internal use only.
java.util.Collection findWithParameterizedPushDownQuery(java.lang.String pushDownQuery, java.lang.Object[] parameters)
findWithParameterizedPushDownQuery
java.util.Enumeration findWithPushDownQuery(java.lang.String query)
Retrieves orders identified by the specified WHERE clause.
boolean fulfills(java.lang.Long arg0, java.lang.String arg1)
java.sql.Timestamp getActualShipDate() Retrieves the latest time any of the order items in the order have been shipped. The SQL query used to fetch the requested data from the ORDERITEMS table is:
SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?";
java.lang.String getAddressId()
This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
java.lang.Long getAddressIdInEJBType()
This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.
java.lang.String getComment()
getComment
java.lang.String getCurrency()
This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10).
java.lang.String getDescription()
This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254).
java.sql.Timestamp getEstimatedOrPromisedShipDate()
Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped.
java.sql.Timestamp getEstimatedShipDate()
Retreives the latest time any of the order items in the order are expected to be shipped.
java.lang.String getField1()
This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
java.lang.Integer getField1InEJBType()
This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.
java.lang.String getField2()
This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
java.math.BigDecimal getField2InEJBType()
This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).
java.lang.String getField3()
This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254).
java.lang.Object getGroupingAttributeValue(java.lang.String arg0, GroupingContext arg1)
This method accesses a non-CMP field
java.lang.String getLastUpdate()
This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
java.sql.Timestamp getLastUpdateInEJBType()
This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.
java.lang.String getLock()
This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1).
java.lang.String getMemberId()
This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
java.lang.Long getMemberIdInEJBType()
This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.
java.lang.String getMerchantOrderId()
This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30).
java.lang.String getNotificationId()
getNotificationId
java.lang.Long getNotificationIdInEJBType()
getNotificationIdInEJBType
java.lang.String getOrderChannelTypeId()
This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
java.lang.Long getOrderChannelTypeIdInEJBType()
This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.
java.lang.String getOrderId()
This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
java.lang.Long getOrderIdInEJBType()
This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.
OrderItemAccessBean[] getOrderItems()
Returns an array of OrderItemAccessBean objects representing order items in this order.
OrderItemAccessBean[] getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus)
OrderItemAccessBean[] getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus)
OrderItemAccessBean[] getOrderItemsForUpdate()
Returns an array of OrderItemAccessBean objects representing order items in this order.
OrderItemAccessBean[] getOrderItemsSortedByCatalogEntryId()
Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
OrderItemAccessBean[] getOrderItemsSortedByOrderItemId()
Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
java.lang.String getOrganizationId()
This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
java.lang.Long getOrganizationIdInEJBType()
This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.
java.lang.Long getOwner()
This method accesses a non-CMP field
java.lang.String getPlaceOrderTime()
This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
java.sql.Timestamp getPlaceOrderTimeInEJBType()
This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.
java.sql.Timestamp getPromisedShipDate()
Retreives the latest time that any of the order items in the order are promised to be shipped.
java.lang.String getProviderOrderNumber()
This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
java.lang.Integer getProviderOrderNumberInEJBType()
This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.
java.lang.String getSequence()
This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
java.lang.Double getSequenceInEJBType()
This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.
java.lang.String getShipAsComplete()
This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'.
java.lang.String getStatus()
This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1).
java.lang.String getStoreEntityId()
This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
java.lang.Integer getStoreEntityIdInEJBType()
This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.
SubOrderAccessBean[] getSubOrders()
Returns an array of SubOrderAccessBean objects representing suborders for this order.
java.lang.String getTotalAdjustment()
This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer displayLevel)
IBM internal use only.
java.math.BigDecimal getTotalAdjustmentInEJBType()
This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.lang.String getTotalProductPrice()
This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.math.BigDecimal getTotalProductPriceInEJBType()
This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.lang.String getTotalShippingCharge()
This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.math.BigDecimal getTotalShippingChargeInEJBType()
This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.lang.String getTotalShippingTax()
This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.math.BigDecimal getTotalShippingTaxInEJBType()
This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.lang.String getTotalTax()
This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
java.math.BigDecimal getTotalTaxInEJBType()
This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.
protected void instantiateEJB()
protected boolean instantiateEJBByPrimaryKey()
void refreshCopyHelper()
Load data from the EJBObject.
void setAddressId(java.lang.Long newValue)
This method accesses a non-CMP field
void setAddressId(java.lang.String newValue)
This method accesses a non-CMP field
void setComment(java.lang.String newValue)
This method accesses a non-CMP field
void setCurrency(java.lang.String newValue)
This method accesses a non-CMP field
void setDescription(java.lang.String newValue)
This method accesses a non-CMP field
void setField1(java.lang.Integer newValue)
This method accesses a non-CMP field
void setField1(java.lang.String newValue)
This method accesses a non-CMP field
void setField2(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setField2(java.lang.String newValue)
This method accesses a non-CMP field
void setField3(java.lang.String newValue)
This method accesses a non-CMP field
void setInitKey_orderId(java.lang.String newValue)
Set the primary key for this object
void setLastUpdate(java.lang.String newValue)
This method accesses a non-CMP field
void setLastUpdate(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setLastUpdateWithoutCheck(java.sql.Timestamp argLastUpdate)
The time this Order was most recently updated without checking whether the previous update time.
void setLock(java.lang.String newValue)
This method accesses a non-CMP field
void setMemberId(java.lang.Long newValue)
This method accesses a non-CMP field
void setMemberId(java.lang.String newValue)
This method accesses a non-CMP field
void setMerchantOrderId(java.lang.String newValue)
This method accesses a non-CMP field
void setNotificationId(java.lang.Long newValue)
This method accesses a non-CMP field
void setNotificationId(java.lang.String newValue)
This method accesses a non-CMP field
void setOrderChannelTypeId(java.lang.Long newValue)
This method accesses a non-CMP field
void setOrderChannelTypeId(java.lang.String newValue)
This method accesses a non-CMP field
void setOrganizationId(java.lang.Long newValue)
This method accesses a non-CMP field
void setOrganizationId(java.lang.String newValue)
This method accesses a non-CMP field
void setPlaceOrderTime(java.lang.String newValue)
This method accesses a non-CMP field
void setPlaceOrderTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field
void setProviderOrderNumber(java.lang.Integer newValue)
This method accesses a non-CMP field
void setProviderOrderNumber(java.lang.String newValue)
This method accesses a non-CMP field
void setSequence(java.lang.Double newValue)
This method accesses a non-CMP field
void setSequence(java.lang.String newValue)
This method accesses a non-CMP field
void setShipAsComplete(java.lang.String newValue)
This method accesses a non-CMP field
void setStatus(java.lang.String newValue)
This method accesses a non-CMP field
void setStoreEntityId(java.lang.Integer newValue)
This method accesses a non-CMP field
void setStoreEntityId(java.lang.String newValue)
This method accesses a non-CMP field
void setTotalAdjustment(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTotalAdjustment(java.lang.String newValue)
This method accesses a non-CMP field
void setTotalProductPrice(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTotalProductPrice(java.lang.String newValue)
This method accesses a non-CMP field
void setTotalShippingCharge(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTotalShippingCharge(java.lang.String newValue)
This method accesses a non-CMP field
void setTotalShippingTax(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTotalShippingTax(java.lang.String newValue)
This method accesses a non-CMP field
void setTotalTax(java.math.BigDecimal newValue)
This method accesses a non-CMP field
void setTotalTax(java.lang.String newValue)
This method accesses a non-CMP field
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OrderAccessBean

public OrderAccessBean()
Zero argument constructor used to initialize the access bean. This constructor corresponds to the following home interface method: public abstract com.ibm.commerce.order.objects.Order com.ibm.commerce.order.objimpl.OrderHomeBase.findByPrimaryKey(com.ibm.commerce.order.objects.OrderKey) throws java.rmi.RemoteException,javax.ejb.FinderException The home interface method properties need to be set by calling the following setter methods before calling any business methods: setInitKey_orderId( java.lang.Long )

OrderAccessBean

public OrderAccessBean(javax.ejb.EJBObject o)
                throws java.rmi.RemoteException
constructor
Parameters:
o - javax.ejb.EJBObject
Throws:
java.rmi.RemoteException

OrderAccessBean

public OrderAccessBean(java.lang.Long arg1,
                       java.lang.Integer arg2,
                       java.lang.Double arg3,
                       java.math.BigDecimal arg4,
                       java.sql.Timestamp arg5)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

Maps to a corresponding ejbCreate method in the home interface of the EJB

Parameters:
arg1 - java.lang.Long The customer of the order
arg2 - java.lang.Integer The store entity the order is part of
arg3 - java.lang.Double Maybe used by a user interface to control the sequence of orders in a list
arg4 - java.math.BigDecimal The sum of order items' tax amount for the order items in the order
arg5 - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

OrderAccessBean

public OrderAccessBean(java.lang.Long arg1,
                       java.lang.Integer arg2,
                       java.lang.Double arg3,
                       java.sql.Timestamp arg4)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

Maps to a corresponding ejbCreate method in the home interface of the EJB

Parameters:
arg1 - java.lang.Long The customer of the order
arg2 - java.lang.Integer The store entity the order is part of
arg3 - java.lang.Double Maybe used by a user interface to control the sequence of orders in a list
arg4 - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception

OrderAccessBean

public OrderAccessBean(java.lang.Long arg1,
                       java.lang.Integer arg2,
                       java.sql.Timestamp arg3)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       javax.ejb.FinderException,
                       java.rmi.RemoteException

Maps to a corresponding ejbCreate method in the home interface of the EJB

Parameters:
arg1 - java.lang.Long The customer of the order
arg2 - java.lang.Integer The store entity the order is part of
arg3 - java.sql.Timestamp The time the order was most recently updated
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
Method Detail

findByOrderForUpdate

public OrderAccessBean findByOrderForUpdate(java.lang.Long orderId)
                                     throws java.rmi.RemoteException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

Retrieves OrderAccessBean representing the order with specified order identifier.
The SQL query used to fetch all the required rows from the ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID = ? for update

Parameters:
orderId - java.lang.Long Order identifier
Returns:
com.ibm.commerce.order.objects.OrderAccessBean The OrderAccessBean representing the row that matches the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByMemberForUpdate

public java.util.Enumeration findByMemberForUpdate(java.lang.Long memberId)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves all the orders for given customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.MEMBER_ID = ? for update

Parameters:
memberId - java.lang.Long The customer of the orders
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByStatus

public java.util.Enumeration findByStatus(java.lang.String argStatus)
                                   throws java.rmi.RemoteException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

Retrieves all the orders with specified status.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?)

Parameters:
argStatus - java.lang.String Order status
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByStatusAndMember

public java.util.Enumeration findByStatusAndMember(java.lang.String argStatus,
                                                   java.lang.Long argMemberId)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves all the orders for specified status and member.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) ORDER BY T1.ORDERS_ID

Parameters:
argStatus - java.lang.String Order status
argMemberId - java.lang.Long The customer of the order
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByStatusMemberAndStore

public java.util.Enumeration findByStatusMemberAndStore(java.lang.String argStatus,
                                                        java.lang.Long argMemberId,
                                                        java.lang.Integer argStoreId)
                                                 throws java.rmi.RemoteException,
                                                        javax.ejb.FinderException,
                                                        javax.naming.NamingException

Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID

Parameters:
argStatus - java.lang.String Order status
argMemberId - java.lang.Long The customer of the order
argStoreId - java.lang.Integer The store entity the order is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByStatusMemberAndStoreForUpdate

public java.util.Enumeration findByStatusMemberAndStoreForUpdate(java.lang.String status,
                                                                 java.lang.Long memberId,
                                                                 java.lang.Integer storeId)
                                                          throws java.rmi.RemoteException,
                                                                 javax.ejb.FinderException,
                                                                 javax.naming.NamingException

Retrieves all the orders for specified status, member and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = ?) AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) ORDER BY T1.ORDERS_ID for update

Parameters:
status - java.lang.String Order status
memberId - java.lang.Long The customer of the order
storeId - java.lang.Integer The store entity the order is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findByStoreIdMemberIdAndStatus

public java.util.Enumeration findByStoreIdMemberIdAndStatus(java.lang.Integer storeId,
                                                            java.lang.Long memberId,
                                                            java.lang.String status,
                                                            java.lang.String orderByClause,
                                                            boolean forUpdate)
                                                     throws javax.ejb.FinderException,
                                                            java.rmi.RemoteException,
                                                            javax.naming.NamingException

IBM internal use only.

Parameters:
storeId - java.lang.Integer
memberId - java.lang.Long
status - java.lang.String
orderByClause - java.lang.String
forUpdate - boolean
Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException

findCurrentPendingOrders

public java.util.Enumeration findCurrentPendingOrders()
                                               throws java.rmi.RemoteException,
                                                      javax.ejb.FinderException,
                                                      javax.naming.NamingException

Retrieves all the current pending orders.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE

Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findCurrentPendingOrdersByMember

public java.util.Enumeration findCurrentPendingOrdersByMember(java.lang.Long argMemberId)
                                                       throws java.rmi.RemoteException,
                                                              javax.ejb.FinderException,
                                                              javax.naming.NamingException

Retrieves all the current pending orders for specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER) ORDER BY T1.LASTUPDATE

Parameters:
argMemberId - java.lang.Long The customer of the order
Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findCurrentPendingOrdersByMemberAndStore

public java.util.Enumeration findCurrentPendingOrdersByMemberAndStore(java.lang.Long argMemberId,
                                                                      java.lang.Integer argStoreId)
                                                               throws java.rmi.RemoteException,
                                                                      javax.ejb.FinderException,
                                                                      javax.naming.NamingException

Retrieves all the current pending orders for specified customer and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'P') AND (T1.ORDERS_ID IN (SELECT ORDERS_ID FROM CPENDORDER WHERE MEMBER_ID = ?)) AND (STOREENT_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
argMemberId - java.lang.Long The customer of the order
argStoreId - java.lang.Integer The store entity the order is part of
Returns:
An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findOrderTemplatesByMember

public java.util.Enumeration findOrderTemplatesByMember(java.lang.Long memberId)
                                                 throws java.rmi.RemoteException,
                                                        javax.ejb.FinderException,
                                                        javax.naming.NamingException

Retrieves all the order templates for specified member.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)

Parameters:
memberId - java.lang.Long The customer of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findOrderTemplatesByMemberAndUsage

public java.util.Enumeration findOrderTemplatesByMemberAndUsage(java.lang.Long memberId,
                                                                java.lang.Integer usage)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the order templates for specified member and usage.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)

Parameters:
memberId - java.lang.Long The customer of the order templates
usage - java.lang.Integer The intended usage of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findOrderTemplatesByStoreAndMember

public java.util.Enumeration findOrderTemplatesByStoreAndMember(java.lang.Integer storeId,
                                                                java.lang.Long memberId)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the order templates for specified store and member.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ?)

Parameters:
storeId - java.lang.Integer The store entity the order templates are part of
memberId - java.lang.Long The customer of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findOrderTemplatesByStoreMemberAndUsage

public java.util.Enumeration findOrderTemplatesByStoreMemberAndUsage(java.lang.Integer storeId,
                                                                     java.lang.Long memberId,
                                                                     java.lang.Integer usage)
                                                              throws java.rmi.RemoteException,
                                                                     javax.ejb.FinderException,
                                                                     javax.naming.NamingException

Retrieves all the order templates for specified store, member and usage.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE T1.STOREENT_ID = ? and T1.ORDERS_ID in (select ORDERS_ID from ORDERTMPL where MEMBER_ID = ? and USAGE = ?)

Parameters:
storeId - java.lang.Integer The store entity the order templates are part of
memberId - java.lang.Long The customer of the order templates
usage - java.lang.Integer The intended usage of the order templates
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findPendingOrders

public java.util.Enumeration findPendingOrders(java.lang.Long argUserReferenceNumber,
                                               java.lang.Long argMerchantReferenceNumber)
                                        throws java.rmi.RemoteException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

Retrieves all the pending orders for given customer and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?) AND (T1.STATUS = 'P')

Parameters:
argUserReferenceNumber - java.lang.Long The customer of the orders
argMerchantReferenceNumber - java.lang.Long The store entity the orders are part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findPrivateRequisitionListByMember

public java.util.Enumeration findPrivateRequisitionListByMember(java.lang.Long memberId)
                                                         throws java.rmi.RemoteException,
                                                                javax.ejb.FinderException,
                                                                javax.naming.NamingException

Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
memberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findPrivateRequisitionListByMemberAndStore

public java.util.Enumeration findPrivateRequisitionListByMemberAndStore(java.lang.Long memberId,
                                                                        java.lang.Integer storeId)
                                                                 throws java.rmi.RemoteException,
                                                                        javax.ejb.FinderException,
                                                                        javax.naming.NamingException

Retrieves all the private requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)

Parameters:
memberId - java.lang.Long The customer of the requisition list
storeId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findPrivateRequisitionListByMemberOrderByLastUpdate

public java.util.Enumeration findPrivateRequisitionListByMemberOrderByLastUpdate(java.lang.Long memberId)
                                                                          throws java.rmi.RemoteException,
                                                                                 javax.ejb.FinderException,
                                                                                 javax.naming.NamingException

Retrieves all the private requisition lists for specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Y') AND (T1.MEMBER_ID = ?) ORDER BY T1.LASTUPDATE

Parameters:
memberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects ordered by creation date representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findShareableRequisitionListByMember

public java.util.Enumeration findShareableRequisitionListByMember(java.lang.Long memberId)
                                                           throws java.rmi.RemoteException,
                                                                  javax.ejb.FinderException,
                                                                  javax.naming.NamingException

Retrieves all the shareable requisition lists that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?))

Parameters:
memberId - java.lang.Long The customer to access the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findShareableRequisitionListByMemberAndStore

public java.util.Enumeration findShareableRequisitionListByMemberAndStore(java.lang.Long memberId,
                                                                          java.lang.Integer storeId)
                                                                   throws java.rmi.RemoteException,
                                                                          javax.ejb.FinderException,
                                                                          javax.naming.NamingException

Retrieves all the shareable requisition lists for given store that can be accessed by the specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ANY (SELECT T3.DESCENDANT_ID FROM MBRREL T2, MBRREL T3 WHERE T2.ANCESTOR_ID = T3.ANCESTOR_ID AND T2.SEQUENCE = 1 AND T3.SEQUENCE = 1 AND T2.DESCENDANT_ID = ?)) AND (T1.STOREENT_ID = ?)

Parameters:
memberId - java.lang.Long The customer to access the requisition list
storeId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findShareableRequisitionListOwnedByMember

public java.util.Enumeration findShareableRequisitionListOwnedByMember(java.lang.Long memberId)
                                                                throws java.rmi.RemoteException,
                                                                       javax.ejb.FinderException,
                                                                       javax.naming.NamingException

Retrieves all the shareable requisition lists for specified customer.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?)

Parameters:
memberId - java.lang.Long The customer of the requisition list
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findShareableRequisitionListOwnedByMemberAndStore

public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStore(java.lang.Long memberId,
                                                                               java.lang.Integer storeId)
                                                                        throws java.rmi.RemoteException,
                                                                               javax.ejb.FinderException,
                                                                               javax.naming.NamingException

Retrieves all the shareable requisition lists for specified customer and store.
The SQL query used to fetch all the required rows from the
ORDERS table is:
SELECT * FROM ORDERS T1 WHERE (T1.STATUS = 'Z') AND (T1.MEMBER_ID = ?) AND (T1.STOREENT_ID = ?)

Parameters:
memberId - java.lang.Long The customer of the requisition list
storeId - java.lang.Integer The store entity the requisition list is part of
Returns:
java.util.Enumeration An Enumeration of all the OrderAccessBean objects representing rows that match the search criteria.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

findTemplatedOrdersByStoreIdMemberIdAndUsage

public java.util.Enumeration findTemplatedOrdersByStoreIdMemberIdAndUsage(java.lang.Integer storeId,
                                                                          java.lang.Long memberId,
                                                                          java.lang.Integer usage,
                                                                          java.lang.String orderByClause,
                                                                          boolean forUpdate)
                                                                   throws javax.ejb.FinderException,
                                                                          java.rmi.RemoteException,
                                                                          javax.naming.NamingException

IBM internal use only.

Parameters:
storeId - java.lang.Integer
Returns:
java.util.Enumeration
Throws:
javax.ejb.FinderException - The javax.ejb.FinderException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.naming.NamingException

findWithPushDownQuery

public java.util.Enumeration findWithPushDownQuery(java.lang.String query)
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

Retrieves orders identified by the specified WHERE clause.

Parameters:
query - java.lang.String The WHERE clause string.
Returns:
java.util.Enumeration
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException

setInitKey_orderId

public void setInitKey_orderId(java.lang.String newValue)

Set the primary key for this object

Parameters:
newValue - java.lang.String
Returns:
void

defaultJNDIName

protected java.lang.String defaultJNDIName()
Returns:
String

instantiateEJB

protected void instantiateEJB()
                       throws java.rmi.RemoteException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException
Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

instantiateEJBByPrimaryKey

protected boolean instantiateEJBByPrimaryKey()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.naming.NamingException
Returns:
boolean
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.naming.NamingException

commitCopyHelper

public void commitCopyHelper()
                      throws java.rmi.RemoteException,
                             javax.ejb.CreateException,
                             javax.ejb.FinderException,
                             javax.naming.NamingException

Update(flush) data to the EJBObject (persistent storage).

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

refreshCopyHelper

public void refreshCopyHelper()
                       throws java.rmi.RemoteException,
                              javax.ejb.CreateException,
                              javax.ejb.FinderException,
                              javax.naming.NamingException

Load data from the EJBObject.

Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getDescription

public java.lang.String getDescription()
                                throws java.rmi.RemoteException,
                                       javax.ejb.CreateException,
                                       javax.ejb.FinderException,
                                       javax.naming.NamingException

This method provides access to the ORDERS.DESCRIPTION column of DB2 type VARCHAR(254).

The following is a description of this column:

A mnemonic description of the order, entered by the customer, suitable for display to the customer.

Specified by:
getDescription in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setDescription

public void setDescription(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setDescription in interface OrderAccessBeanData

getLastUpdate

public java.lang.String getLastUpdate()
                               throws java.rmi.RemoteException,
                                      javax.ejb.CreateException,
                                      javax.ejb.FinderException,
                                      javax.naming.NamingException

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.

The following is a description of this column:

The time this order was most recently updated.

Specified by:
getLastUpdate in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getLastUpdateInEJBType

public java.sql.Timestamp getLastUpdateInEJBType()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException

This method provides access to the ORDERS.LASTUPDATE column of DB2 type TIMESTAMP.

The following is a description of this column:

The time this order was most recently updated.

Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setLastUpdate

public void setLastUpdate(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setLastUpdate in interface OrderAccessBeanData

setLastUpdate

public void setLastUpdate(java.sql.Timestamp newValue)
This method accesses a non-CMP field

getPlaceOrderTime

public java.lang.String getPlaceOrderTime()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.

The following is a description of this column:

The time this order was processed by the OrderProcess command.

Specified by:
getPlaceOrderTime in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getPlaceOrderTimeInEJBType

public java.sql.Timestamp getPlaceOrderTimeInEJBType()
                                              throws java.rmi.RemoteException,
                                                     javax.ejb.CreateException,
                                                     javax.ejb.FinderException,
                                                     javax.naming.NamingException

This method provides access to the ORDERS.TIMEPLACED column of DB2 type TIMESTAMP.

The following is a description of this column:

The time this order was processed by the OrderProcess command.

Returns:
java.sql.Timestamp
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setPlaceOrderTime

public void setPlaceOrderTime(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setPlaceOrderTime in interface OrderAccessBeanData

setPlaceOrderTime

public void setPlaceOrderTime(java.sql.Timestamp newValue)
This method accesses a non-CMP field

getTotalShippingTax

public java.lang.String getTotalShippingTax()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

Specified by:
getTotalShippingTax in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getTotalShippingTaxInEJBType

public java.math.BigDecimal getTotalShippingTaxInEJBType()
                                                  throws java.rmi.RemoteException,
                                                         javax.ejb.CreateException,
                                                         javax.ejb.FinderException,
                                                         javax.naming.NamingException

This method provides access to the ORDERS.TOTALTAXSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.SHIPTAXAMOUNT for the OrderItems in the Order.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalShippingTax

public void setTotalShippingTax(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setTotalShippingTax in interface OrderAccessBeanData

setTotalShippingTax

public void setTotalShippingTax(java.math.BigDecimal newValue)
This method accesses a non-CMP field

getCurrency

public java.lang.String getCurrency()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the ORDERS.CURRENCY column of DB2 type CHAR(10).

The following is a description of this column:

The currency for monetary amounts associated with this order. This is the currency code according to ISO 4217 standards.

Specified by:
getCurrency in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setCurrency

public void setCurrency(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setCurrency in interface OrderAccessBeanData

getField3

public java.lang.String getField3()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

This method provides access to the ORDERS.FIELD3 column of DB2 type VARCHAR(254).

The following is a description of this column:

Customizable.

Specified by:
getField3 in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField3

public void setField3(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setField3 in interface OrderAccessBeanData

getField2

public java.lang.String getField2()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Customizable.

Specified by:
getField2 in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getField2InEJBType

public java.math.BigDecimal getField2InEJBType()
                                        throws java.rmi.RemoteException,
                                               javax.ejb.CreateException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

This method provides access to the ORDERS.FIELD2 column of DB2 type DECIMAL(20 5).

The following is a description of this column:

Customizable.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField2

public void setField2(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setField2 in interface OrderAccessBeanData

setField2

public void setField2(java.math.BigDecimal newValue)
This method accesses a non-CMP field

getField1

public java.lang.String getField1()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.

The following is a description of this column:

Customizable.

Specified by:
getField1 in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getField1InEJBType

public java.lang.Integer getField1InEJBType()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDERS.FIELD1 column of DB2 type INTEGER.

The following is a description of this column:

Customizable.

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setField1

public void setField1(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setField1 in interface OrderAccessBeanData

setField1

public void setField1(java.lang.Integer newValue)
This method accesses a non-CMP field

getShipAsComplete

public java.lang.String getShipAsComplete()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDERS.SHIPASCOMPLETE column of DB2 type CHAR(1) NOT NULL DEFAULT 'Y'.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getShipAsComplete in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setShipAsComplete

public void setShipAsComplete(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setShipAsComplete in interface OrderAccessBeanData

getTotalShippingCharge

public java.lang.String getTotalShippingCharge()
                                        throws java.rmi.RemoteException,
                                               javax.ejb.CreateException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order. This quantity should be the result of (ORDERS.BASETOTALSHIPPING - ORDERS.TOTALSHIPADJUST). It is the adjusted amount acually charged to the customer.

Specified by:
getTotalShippingCharge in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getTotalShippingChargeInEJBType

public java.math.BigDecimal getTotalShippingChargeInEJBType()
                                                     throws java.rmi.RemoteException,
                                                            javax.ejb.CreateException,
                                                            javax.ejb.FinderException,
                                                            javax.naming.NamingException

This method provides access to the ORDERS.TOTALSHIPPING column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.SHIPCHARGE for the OrderItems in the Order. This quantity should be the result of (ORDERS.BASETOTALSHIPPING - ORDERS.TOTALSHIPADJUST). It is the adjusted amount acually charged to the customer.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalShippingCharge

public void setTotalShippingCharge(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setTotalShippingCharge in interface OrderAccessBeanData

setTotalShippingCharge

public void setTotalShippingCharge(java.math.BigDecimal newValue)
This method accesses a non-CMP field

getOrganizationId

public java.lang.String getOrganizationId()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.

The following is a description of this column:

The immediate parent organization ID of the creator.

Specified by:
getOrganizationId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getOrganizationIdInEJBType

public java.lang.Long getOrganizationIdInEJBType()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException

This method provides access to the ORDERS.ORGENTITY_ID column of DB2 type BIGINT.

The following is a description of this column:

The immediate parent organization ID of the creator.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOrganizationId

public void setOrganizationId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setOrganizationId in interface OrderAccessBeanData

setOrganizationId

public void setOrganizationId(java.lang.Long newValue)
This method accesses a non-CMP field

getStatus

public java.lang.String getStatus()
                           throws java.rmi.RemoteException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  javax.naming.NamingException

This method provides access to the ORDERS.STATUS column of DB2 type CHAR(1).

The following is a description of this column:

The status of a standard order.

Specified by:
getStatus in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setStatus

public void setStatus(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setStatus in interface OrderAccessBeanData

getProviderOrderNumber

public java.lang.String getProviderOrderNumber()
                                        throws java.rmi.RemoteException,
                                               javax.ejb.CreateException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getProviderOrderNumber in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getProviderOrderNumberInEJBType

public java.lang.Integer getProviderOrderNumberInEJBType()
                                                  throws java.rmi.RemoteException,
                                                         javax.ejb.CreateException,
                                                         javax.ejb.FinderException,
                                                         javax.naming.NamingException

This method provides access to the ORDERS.PROVIDERORDERNUM column of DB2 type INTEGER.

The following is a description of this column:

Reserved for IBM internal use.

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setProviderOrderNumber in interface OrderAccessBeanData

setProviderOrderNumber

public void setProviderOrderNumber(java.lang.Integer newValue)
This method accesses a non-CMP field

getLock

public java.lang.String getLock()
                         throws java.rmi.RemoteException,
                                javax.ejb.CreateException,
                                javax.ejb.FinderException,
                                javax.naming.NamingException

This method provides access to the ORDERS.LOCKED column of DB2 type CHAR(1).

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getLock in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setLock

public void setLock(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setLock in interface OrderAccessBeanData

getOrderId

public java.lang.String getOrderId()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException

This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

Generated unique key.

Specified by:
getOrderId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getOrderIdInEJBType

public java.lang.Long getOrderIdInEJBType()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException

This method provides access to the ORDERS.ORDERS_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

Generated unique key.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getStoreEntityId

public java.lang.String getStoreEntityId()
                                  throws java.rmi.RemoteException,
                                         javax.ejb.CreateException,
                                         javax.ejb.FinderException,
                                         javax.naming.NamingException

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The store entity the order is part of. This is normally a store unless STATUS is Q, in which case it is normally a store group.

Specified by:
getStoreEntityId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getStoreEntityIdInEJBType

public java.lang.Integer getStoreEntityIdInEJBType()
                                            throws java.rmi.RemoteException,
                                                   javax.ejb.CreateException,
                                                   javax.ejb.FinderException,
                                                   javax.naming.NamingException

This method provides access to the ORDERS.STOREENT_ID column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

The store entity the order is part of. This is normally a store unless STATUS is Q, in which case it is normally a store group.

Returns:
java.lang.Integer
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setStoreEntityId

public void setStoreEntityId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setStoreEntityId in interface OrderAccessBeanData

setStoreEntityId

public void setStoreEntityId(java.lang.Integer newValue)
This method accesses a non-CMP field

getMemberId

public java.lang.String getMemberId()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer that placed the order.

Specified by:
getMemberId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getMemberIdInEJBType

public java.lang.Long getMemberIdInEJBType()
                                    throws java.rmi.RemoteException,
                                           javax.ejb.CreateException,
                                           javax.ejb.FinderException,
                                           javax.naming.NamingException

This method provides access to the ORDERS.MEMBER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The customer that placed the order.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setMemberId

public void setMemberId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setMemberId in interface OrderAccessBeanData

setMemberId

public void setMemberId(java.lang.Long newValue)
This method accesses a non-CMP field

getTotalProductPrice

public java.lang.String getTotalProductPrice()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

Specified by:
getTotalProductPrice in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getTotalProductPriceInEJBType

public java.math.BigDecimal getTotalProductPriceInEJBType()
                                                   throws java.rmi.RemoteException,
                                                          javax.ejb.CreateException,
                                                          javax.ejb.FinderException,
                                                          javax.naming.NamingException

This method provides access to the ORDERS.TOTALPRODUCT column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TOTALPRODUCT for the OrderItems in the Order.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalProductPrice

public void setTotalProductPrice(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setTotalProductPrice in interface OrderAccessBeanData

setTotalProductPrice

public void setTotalProductPrice(java.math.BigDecimal newValue)
This method accesses a non-CMP field

getTotalTax

public java.lang.String getTotalTax()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

Specified by:
getTotalTax in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getTotalTaxInEJBType

public java.math.BigDecimal getTotalTaxInEJBType()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException

This method provides access to the ORDERS.TOTALTAX column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TAXAMOUNT for the OrderItems in the Order.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalTax

public void setTotalTax(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setTotalTax in interface OrderAccessBeanData

setTotalTax

public void setTotalTax(java.math.BigDecimal newValue)
This method accesses a non-CMP field

getMerchantOrderId

public java.lang.String getMerchantOrderId()
                                    throws java.rmi.RemoteException,
                                           javax.ejb.CreateException,
                                           javax.ejb.FinderException,
                                           javax.naming.NamingException

This method provides access to the ORDERS.ORMORDER column of DB2 type CHAR(30).

The following is a description of this column:

A merchant-assigned order reference number, if any.

Specified by:
getMerchantOrderId in interface OrderAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setMerchantOrderId

public void setMerchantOrderId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setMerchantOrderId in interface OrderAccessBeanData

getSequence

public java.lang.String getSequence()
                             throws java.rmi.RemoteException,
                                    javax.ejb.CreateException,
                                    javax.ejb.FinderException,
                                    javax.naming.NamingException

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.

The following is a description of this column:

Can be used by a user interface to control the sequence of orders in a list.

Specified by:
getSequence in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getSequenceInEJBType

public java.lang.Double getSequenceInEJBType()
                                      throws java.rmi.RemoteException,
                                             javax.ejb.CreateException,
                                             javax.ejb.FinderException,
                                             javax.naming.NamingException

This method provides access to the ORDERS.SEQUENCE column of DB2 type FLOAT NOT NULL DEFAULT 0.

The following is a description of this column:

Can be used by a user interface to control the sequence of orders in a list.

Returns:
java.lang.Double
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setSequence

public void setSequence(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setSequence in interface OrderAccessBeanData

setSequence

public void setSequence(java.lang.Double newValue)
This method accesses a non-CMP field

getAddressId

public java.lang.String getAddressId()
                              throws java.rmi.RemoteException,
                                     javax.ejb.CreateException,
                                     javax.ejb.FinderException,
                                     javax.naming.NamingException

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.

The following is a description of this column:

The billing address, if known.

Specified by:
getAddressId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getAddressIdInEJBType

public java.lang.Long getAddressIdInEJBType()
                                     throws java.rmi.RemoteException,
                                            javax.ejb.CreateException,
                                            javax.ejb.FinderException,
                                            javax.naming.NamingException

This method provides access to the ORDERS.ADDRESS_ID column of DB2 type BIGINT.

The following is a description of this column:

The billing address, if known.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setAddressId

public void setAddressId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setAddressId in interface OrderAccessBeanData

setAddressId

public void setAddressId(java.lang.Long newValue)
This method accesses a non-CMP field

getOrderChannelTypeId

public java.lang.String getOrderChannelTypeId()
                                       throws java.rmi.RemoteException,
                                              javax.ejb.CreateException,
                                              javax.ejb.FinderException,
                                              javax.naming.NamingException

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getOrderChannelTypeId in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getOrderChannelTypeIdInEJBType

public java.lang.Long getOrderChannelTypeIdInEJBType()
                                              throws java.rmi.RemoteException,
                                                     javax.ejb.CreateException,
                                                     javax.ejb.FinderException,
                                                     javax.naming.NamingException

This method provides access to the ORDERS.ORDCHNLTYP_ID column of DB2 type BIGINT.

The following is a description of this column:

Reserved for IBM internal use.

Returns:
java.lang.Long
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setOrderChannelTypeId in interface OrderAccessBeanData

setOrderChannelTypeId

public void setOrderChannelTypeId(java.lang.Long newValue)
This method accesses a non-CMP field

getTotalAdjustment

public java.lang.String getTotalAdjustment()
                                    throws java.rmi.RemoteException,
                                           javax.ejb.CreateException,
                                           javax.ejb.FinderException,
                                           javax.naming.NamingException

This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the order items in the order.

Specified by:
getTotalAdjustment in interface OrderAccessBeanData
Returns:
String
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

getTotalAdjustmentInEJBType

public java.math.BigDecimal getTotalAdjustmentInEJBType()
                                                 throws java.rmi.RemoteException,
                                                        javax.ejb.CreateException,
                                                        javax.ejb.FinderException,
                                                        javax.naming.NamingException

This method provides access to the ORDERS.TOTALADJUSTMENT column of DB2 type DECIMAL(20 5) DEFAULT 0.

The following is a description of this column:

The sum of ORDERITEMS.TOTALADJUSTMENT for the order items in the order.

Returns:
java.math.BigDecimal
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setTotalAdjustment

public void setTotalAdjustment(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setTotalAdjustment in interface OrderAccessBeanData

setTotalAdjustment

public void setTotalAdjustment(java.math.BigDecimal newValue)
This method accesses a non-CMP field

fulfills

public boolean fulfills(java.lang.Long arg0,
                        java.lang.String arg1)
                 throws java.rmi.RemoteException,
                        java.lang.Exception,
                        javax.ejb.FinderException,
                        javax.naming.NamingException
Parameters:
arg0 - java.lang.Long
arg1 - java.lang.String
Returns:
boolean
Throws:
java.rmi.RemoteException
java.lang.Exception
javax.ejb.FinderException
javax.naming.NamingException

getOrderItems

public OrderItemAccessBean[] getOrderItems()
                                    throws javax.naming.NamingException,
                                           java.rmi.RemoteException,
                                           javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ADDRESS_ID, T1.ORDERITEMS_ID

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOrderItemsForUpdate

public OrderItemAccessBean[] getOrderItemsForUpdate()
                                             throws javax.naming.NamingException,
                                                    java.rmi.RemoteException,
                                                    javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE T1.ORDERS_ID = ? for update

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOrderItemsSortedByOrderItemId

public OrderItemAccessBean[] getOrderItemsSortedByOrderItemId()
                                                       throws javax.naming.NamingException,
                                                              java.rmi.RemoteException,
                                                              javax.ejb.FinderException

Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.ORDERITEMS_ID

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getSubOrders

public SubOrderAccessBean[] getSubOrders()
                                  throws javax.naming.NamingException,
                                         java.rmi.RemoteException,
                                         javax.ejb.FinderException

Returns an array of SubOrderAccessBean objects representing suborders for this order.

Returns:
com.ibm.commerce.order.objects.SubOrderAccessBean[]
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

getOwner

public java.lang.Long getOwner()
                        throws java.lang.Exception,
                               java.rmi.RemoteException,
                               javax.ejb.FinderException,
                               javax.naming.NamingException
This method accesses a non-CMP field
Throws:
java.lang.Exception
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

getGroupingAttributeValue

public java.lang.Object getGroupingAttributeValue(java.lang.String arg0,
                                                  GroupingContext arg1)
                                           throws java.lang.Exception,
                                                  java.rmi.RemoteException,
                                                  javax.ejb.FinderException,
                                                  javax.naming.NamingException
This method accesses a non-CMP field
Throws:
java.lang.Exception
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

getTotalAdjustmentByDisplayLevel

public java.math.BigDecimal getTotalAdjustmentByDisplayLevel(java.lang.Integer displayLevel)
                                                      throws javax.naming.NamingException,
                                                             javax.ejb.CreateException,
                                                             java.sql.SQLException,
                                                             java.rmi.RemoteException,
                                                             javax.ejb.FinderException

IBM internal use only.

Parameters:
displayLevel - java.lang.Integer
Returns:
java.math.BigDecimal
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException

getActualShipDate

public java.sql.Timestamp getActualShipDate()
                                     throws javax.naming.NamingException,
                                            javax.ejb.CreateException,
                                            java.sql.SQLException,
                                            java.rmi.RemoteException,
                                            javax.ejb.FinderException

Retrieves the latest time any of the order items in the order have been shipped.
The SQL query used to fetch the requested data from the
ORDERITEMS table is:
SELECT MAX(T1.TIMESHIPPED) FROM ORDERITEMS T1 WHERE T1.ORDERS_ID=?";

Returns:
java.sql.Timestamp Time when the last order item in the order has been shipped
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException

getEstimatedOrPromisedShipDate

public java.sql.Timestamp getEstimatedOrPromisedShipDate()
                                                  throws javax.naming.NamingException,
                                                         javax.ejb.CreateException,
                                                         java.sql.SQLException,
                                                         java.rmi.RemoteException,
                                                         javax.ejb.FinderException

Retreives the latest time any of the order items in the order are expected or promised (for placed orders) to be shipped.

Returns:
java.sql.Timestamp Expected or promised ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException

getEstimatedShipDate

public java.sql.Timestamp getEstimatedShipDate()
                                        throws javax.naming.NamingException,
                                               javax.ejb.CreateException,
                                               java.sql.SQLException,
                                               java.rmi.RemoteException,
                                               javax.ejb.FinderException

Retreives the latest time any of the order items in the order are expected to be shipped.

Returns:
java.sql.Timestamp Expected ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException

getPromisedShipDate

public java.sql.Timestamp getPromisedShipDate()
                                       throws javax.naming.NamingException,
                                              javax.ejb.CreateException,
                                              java.sql.SQLException,
                                              java.rmi.RemoteException,
                                              javax.ejb.FinderException

Retreives the latest time that any of the order items in the order are promised to be shipped.

Returns:
java.sql.Timestamp Expected or promised ship time
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
java.sql.SQLException - The java.sql.SQLException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException

clearOrderItemsCache

public void clearOrderItemsCache()
                          throws java.rmi.RemoteException,
                                 javax.ejb.FinderException,
                                 javax.naming.NamingException
Returns:
void
Throws:
java.rmi.RemoteException
javax.ejb.FinderException
javax.naming.NamingException

getComment

public java.lang.String getComment()
                            throws java.rmi.RemoteException,
                                   javax.ejb.CreateException,
                                   javax.ejb.FinderException,
                                   javax.naming.NamingException
getComment
Specified by:
getComment in interface OrderAccessBeanData
Returns:
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setComment

public void setComment(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setComment in interface OrderAccessBeanData

findParentOrderByOrdersId

public OrderAccessBean findParentOrderByOrdersId(java.lang.Long aOrdersId)
                                          throws javax.naming.NamingException,
                                                 javax.ejb.FinderException,
                                                 java.rmi.RemoteException
findParentOrderByOrdersId
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

getOrderItemsByFulfillmentStatus

public OrderItemAccessBean[] getOrderItemsByFulfillmentStatus(java.lang.String strFulfillmentStatus)
                                                       throws javax.naming.NamingException,
                                                              javax.ejb.FinderException,
                                                              java.rmi.RemoteException
Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean []
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

getOrderItemsByFulfillmentStatusForUpdate

public OrderItemAccessBean[] getOrderItemsByFulfillmentStatusForUpdate(java.lang.String strFulfillmentStatus)
                                                                throws javax.naming.NamingException,
                                                                       javax.ejb.FinderException,
                                                                       java.rmi.RemoteException
Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean []
Throws:
java.lang.String - The exception description.
java.lang.String - The exception description.
java.lang.String - The exception description.
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findNotTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                  java.lang.Long aShopperId)
                                                                           throws javax.naming.NamingException,
                                                                                  javax.ejb.FinderException,
                                                                                  java.rmi.RemoteException
findNotTransferredOrdersByChannelStoreIdAndShopperId
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findProcessedOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findProcessedOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                             java.lang.Long aShopperId)
                                                                      throws javax.naming.NamingException,
                                                                             javax.ejb.FinderException,
                                                                             java.rmi.RemoteException
findProcessedOrdersByChannelStoreIdAndShopperId
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findFullyTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                    java.lang.Long aShopperId)
                                                                             throws javax.naming.NamingException,
                                                                                    javax.ejb.FinderException,
                                                                                    java.rmi.RemoteException
findFullyTransferredOrdersByChannelStoreIdAndShopperId
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findPartlyTransferredOrdersByChannelStoreIdAndShopperId

public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdAndShopperId(java.lang.Integer aChannelStoreId,
                                                                                     java.lang.Long aShopperId)
                                                                              throws javax.naming.NamingException,
                                                                                     javax.ejb.FinderException,
                                                                                     java.rmi.RemoteException
findPartlyTransferredOrdersByChannelStoreIdAndShopperId
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberRelTypeAndStore

public java.util.Enumeration findByStatusMemberRelTypeAndStore(java.lang.String istrOrderStatus,
                                                               java.lang.Long inUserId,
                                                               java.lang.String istrRelType,
                                                               java.lang.Integer inStoreId)
                                                        throws javax.naming.NamingException,
                                                               javax.ejb.FinderException,
                                                               java.rmi.RemoteException
findByStatusMemberRelTypeAndStore
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelType

public java.util.Enumeration findByStatusMemberAndRelType(java.lang.String istrOrderStatus,
                                                          java.lang.Long inUserId,
                                                          java.lang.String istrRelType)
                                                   throws javax.naming.NamingException,
                                                          javax.ejb.FinderException,
                                                          java.rmi.RemoteException
findByStatusMemberAndRelType
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByOrderIds

public java.util.Enumeration findByOrderIds(java.lang.Long[] anOrderIds)
                                     throws javax.naming.NamingException,
                                            javax.ejb.FinderException,
                                            java.rmi.RemoteException
findByOrderIds
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType

public java.util.Enumeration findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType(java.lang.Integer[] aDistributorStoreIds,
                                                                                      java.lang.Long aOrdersId,
                                                                                      java.lang.String aRelType)
                                                                               throws javax.naming.NamingException,
                                                                                      javax.ejb.FinderException,
                                                                                      java.rmi.RemoteException
findChildOrderByDistributorStoreIdsAndOrdersIdAndRelType
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelTypeScopedByTimePlaced

public java.util.Enumeration findByStatusMemberAndRelTypeScopedByTimePlaced(java.lang.String istrOrderStatus,
                                                                            java.lang.Long inUserId,
                                                                            java.lang.String istrRelType,
                                                                            java.sql.Timestamp argStartDate,
                                                                            java.sql.Timestamp argEndDate)
                                                                     throws javax.naming.NamingException,
                                                                            javax.ejb.FinderException,
                                                                            java.rmi.RemoteException
findByStatusMemberAndRelTypeScopedByTimePlaced
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndStoreScopedByLastUpdate

public java.util.Enumeration findByStatusMemberAndStoreScopedByLastUpdate(java.lang.String argStatus,
                                                                          java.lang.Long argMemberId,
                                                                          java.lang.Integer argStoreId,
                                                                          java.sql.Timestamp argStartDate,
                                                                          java.sql.Timestamp argEndDate)
                                                                   throws javax.naming.NamingException,
                                                                          javax.ejb.FinderException,
                                                                          java.rmi.RemoteException
findByStatusMemberAndStoreScopedByLastUpdate
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberRelTypeAndStoreScopedByLastUpdate

public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByLastUpdate(java.lang.String istrOrderStatus,
                                                                                 java.lang.Long inUserId,
                                                                                 java.lang.String istrRelType,
                                                                                 java.lang.Integer inStoreId,
                                                                                 java.sql.Timestamp argStartDate,
                                                                                 java.sql.Timestamp argEndDate)
                                                                          throws javax.naming.NamingException,
                                                                                 javax.ejb.FinderException,
                                                                                 java.rmi.RemoteException
findByStatusMemberRelTypeAndStoreScopedByLastUpdate
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndRelTypeScopedByLastUpdate

public java.util.Enumeration findByStatusMemberAndRelTypeScopedByLastUpdate(java.lang.String istrOrderStatus,
                                                                            java.lang.Long inUserId,
                                                                            java.lang.String istrRelType,
                                                                            java.sql.Timestamp argStartDate,
                                                                            java.sql.Timestamp argEndDate)
                                                                     throws javax.naming.NamingException,
                                                                            javax.ejb.FinderException,
                                                                            java.rmi.RemoteException
findByStatusMemberAndRelTypeScopedByLastUpdate
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusAndMemberScopedByLastUpdate

public java.util.Enumeration findByStatusAndMemberScopedByLastUpdate(java.lang.String argStatus,
                                                                     java.lang.Long argMemberId,
                                                                     java.sql.Timestamp argStartDate,
                                                                     java.sql.Timestamp argEndDate)
                                                              throws javax.naming.NamingException,
                                                                     javax.ejb.FinderException,
                                                                     java.rmi.RemoteException
findByStatusAndMemberScopedByLastUpdate
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberAndStoreScopedByTimePlaced

public java.util.Enumeration findByStatusMemberAndStoreScopedByTimePlaced(java.lang.String argStatus,
                                                                          java.lang.Long argMemberId,
                                                                          java.lang.Integer argStoreId,
                                                                          java.sql.Timestamp argStartDate,
                                                                          java.sql.Timestamp argEndDate)
                                                                   throws javax.naming.NamingException,
                                                                          javax.ejb.FinderException,
                                                                          java.rmi.RemoteException
findByStatusMemberAndStoreScopedByTimePlaced
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusMemberRelTypeAndStoreScopedByTimePlaced

public java.util.Enumeration findByStatusMemberRelTypeAndStoreScopedByTimePlaced(java.lang.String istrOrderStatus,
                                                                                 java.lang.Long inUserId,
                                                                                 java.lang.String istrRelType,
                                                                                 java.lang.Integer inStoreId,
                                                                                 java.sql.Timestamp argStartDate,
                                                                                 java.sql.Timestamp argEndDate)
                                                                          throws javax.naming.NamingException,
                                                                                 javax.ejb.FinderException,
                                                                                 java.rmi.RemoteException
findByStatusMemberRelTypeAndStoreScopedByTimePlaced
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusAndMemberScopedByTimePlaced

public java.util.Enumeration findByStatusAndMemberScopedByTimePlaced(java.lang.String argStatus,
                                                                     java.lang.Long argMemberId,
                                                                     java.sql.Timestamp argStartDate,
                                                                     java.sql.Timestamp argEndDate)
                                                              throws javax.naming.NamingException,
                                                                     javax.ejb.FinderException,
                                                                     java.rmi.RemoteException
findByStatusAndMemberScopedByTimePlaced
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusesMemberStoresRelTypeStartEndDateAndDateField

public java.util.Enumeration findByStatusesMemberStoresRelTypeStartEndDateAndDateField(java.lang.String[] aStatusList,
                                                                                       java.lang.Long aMemberId,
                                                                                       java.lang.Integer[] aStoreIdList,
                                                                                       java.lang.String aRelType,
                                                                                       java.sql.Timestamp startDate,
                                                                                       java.sql.Timestamp endDate,
                                                                                       java.lang.String dateField)
                                                                                throws javax.naming.NamingException,
                                                                                       javax.ejb.FinderException,
                                                                                       java.rmi.RemoteException
findByStatusesMemberStoresRelTypeStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusesMemberStoresStartEndDateAndDateField

public java.util.Enumeration findByStatusesMemberStoresStartEndDateAndDateField(java.lang.String[] aStatusList,
                                                                                java.lang.Long aMemberId,
                                                                                java.lang.Integer[] aStoreIdList,
                                                                                java.sql.Timestamp startDate,
                                                                                java.sql.Timestamp endDate,
                                                                                java.lang.String dateField)
                                                                         throws javax.naming.NamingException,
                                                                                javax.ejb.FinderException,
                                                                                java.rmi.RemoteException
findByStatusesMemberStoresStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                          java.lang.Long memberId,
                                                                                                          java.sql.Timestamp startDate,
                                                                                                          java.sql.Timestamp endDate,
                                                                                                          java.lang.String dateField)
                                                                                                   throws javax.naming.NamingException,
                                                                                                          javax.ejb.FinderException,
                                                                                                          java.rmi.RemoteException
findPartlyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                         java.lang.Long memberId,
                                                                                                         java.sql.Timestamp startDate,
                                                                                                         java.sql.Timestamp endDate,
                                                                                                         java.lang.String dateField)
                                                                                                  throws javax.naming.NamingException,
                                                                                                         javax.ejb.FinderException,
                                                                                                         java.rmi.RemoteException
findFullyTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                       java.lang.Long memberId,
                                                                                                       java.sql.Timestamp startDate,
                                                                                                       java.sql.Timestamp endDate,
                                                                                                       java.lang.String dateField)
                                                                                                throws javax.naming.NamingException,
                                                                                                       javax.ejb.FinderException,
                                                                                                       java.rmi.RemoteException
findNotTransferredOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField

public java.util.Enumeration findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField(java.lang.Integer storeId,
                                                                                                  java.lang.Long memberId,
                                                                                                  java.sql.Timestamp startDate,
                                                                                                  java.sql.Timestamp endDate,
                                                                                                  java.lang.String dateField)
                                                                                           throws javax.naming.NamingException,
                                                                                                  javax.ejb.FinderException,
                                                                                                  java.rmi.RemoteException
findProcessedOrdersByChannelStoreIdShopperIdStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel

public java.util.Enumeration findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                              java.lang.Integer channelStoreId)
                                                                                       throws javax.naming.NamingException,
                                                                                              javax.ejb.FinderException,
                                                                                              java.rmi.RemoteException
findShareableRequisitionListOwnedByMemberAndStoreHostedAtChannel
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findShareableRequisitionListByMemberAndStoreHostedAtChannel

public java.util.Enumeration findShareableRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                         java.lang.Integer channelStoreId)
                                                                                  throws javax.naming.NamingException,
                                                                                         javax.ejb.FinderException,
                                                                                         java.rmi.RemoteException
Parameters:
memberId - java.lang.Long member ID
channelStoreId - java.lang.Integer Channel Store Id
Returns:
java.util.Enumeration An enumeration of orders
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findPrivateRequisitionListByMemberAndStoreHostedAtChannel

public java.util.Enumeration findPrivateRequisitionListByMemberAndStoreHostedAtChannel(java.lang.Long memberId,
                                                                                       java.lang.Integer channelStoreId)
                                                                                throws javax.naming.NamingException,
                                                                                       javax.ejb.FinderException,
                                                                                       java.rmi.RemoteException
Parameters:
memberId - java.lang.Long member ID
channelStoreId - java.lang.Integer Channel Store Id
Returns:
java.util.Enumeration An enumeration of orders
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

findByStatusMemberAndStoreHostedAtChannel

public java.util.Enumeration findByStatusMemberAndStoreHostedAtChannel(java.lang.String argStatus,
                                                                       java.lang.Long argMemberId,
                                                                       java.lang.Integer argStoreId)
                                                                throws javax.naming.NamingException,
                                                                       javax.ejb.FinderException,
                                                                       java.rmi.RemoteException
Gets all the orders for the user under those merchant hosted at channel merchant that are in the state specified.
Parameters:
argStatus - java.lang.String The state of the order to query.
Returns:
java.util.Enumeration An enumeration of orders sorted by ascending reference number.
Throws:
java.rmi.RemoteException - The exception description.
javax.ejb.FinderException - Exception thrown if this method does not find an object.
javax.naming.NamingException

getNotificationId

public java.lang.String getNotificationId()
                                   throws java.rmi.RemoteException,
                                          javax.ejb.CreateException,
                                          javax.ejb.FinderException,
                                          javax.naming.NamingException
getNotificationId
Specified by:
getNotificationId in interface OrderAccessBeanData
Returns:
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setNotificationId

public void setNotificationId(java.lang.Long newValue)
This method accesses a non-CMP field

getNotificationIdInEJBType

public java.lang.Long getNotificationIdInEJBType()
                                          throws java.rmi.RemoteException,
                                                 javax.ejb.CreateException,
                                                 javax.ejb.FinderException,
                                                 javax.naming.NamingException
getNotificationIdInEJBType
Returns:
Throws:
java.rmi.RemoteException
javax.ejb.CreateException
javax.ejb.FinderException
javax.naming.NamingException

setNotificationId

public void setNotificationId(java.lang.String newValue)
This method accesses a non-CMP field
Specified by:
setNotificationId in interface OrderAccessBeanData

setLastUpdateWithoutCheck

public void setLastUpdateWithoutCheck(java.sql.Timestamp argLastUpdate)
The time this Order was most recently updated without checking whether the previous update time.
Specified by:
setLastUpdateWithoutCheck in interface OrderAccessBeanData
Parameters:
argLastUpdate - java.sql.Timestamp

findByStatusStoreentIdAndDescription

public java.util.Enumeration findByStatusStoreentIdAndDescription(java.lang.String status,
                                                                  java.lang.Integer storeentId,
                                                                  java.lang.String description)
                                                           throws javax.naming.NamingException,
                                                                  javax.ejb.FinderException,
                                                                  java.rmi.RemoteException
findByStatusStoreentIdAndDescription
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findWithParameterizedPushDownQuery

public java.util.Collection findWithParameterizedPushDownQuery(java.lang.String pushDownQuery,
                                                               java.lang.Object[] parameters)
                                                        throws javax.naming.NamingException,
                                                               javax.ejb.FinderException,
                                                               java.rmi.RemoteException
findWithParameterizedPushDownQuery
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField

public java.util.Enumeration findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField(java.lang.String[] aStatusList,
                                                                                              java.lang.Long aMemberId,
                                                                                              java.lang.Integer aChannelStoreId,
                                                                                              java.sql.Timestamp startDate,
                                                                                              java.sql.Timestamp endDate,
                                                                                              java.lang.String dateField)
                                                                                       throws javax.naming.NamingException,
                                                                                              javax.ejb.FinderException,
                                                                                              java.rmi.RemoteException
findByStatusesMemberStoreHostedAtChannelStartEndDateAndDateField
Returns:
Throws:
javax.naming.NamingException
javax.ejb.FinderException
java.rmi.RemoteException

getOrderItemsSortedByCatalogEntryId

public OrderItemAccessBean[] getOrderItemsSortedByCatalogEntryId()
                                                          throws javax.naming.NamingException,
                                                                 javax.ejb.FinderException,
                                                                 java.rmi.RemoteException

Returns an array of OrderItemAccessBean objects sorted by order item id representing order items in this order.
The SQL query used to fetch all the required rows from the ORDERITEMS table is:
SELECT * FROM ORDERITEMS T1 WHERE (T1.ORDERS_ID = ?) order by T1.CATENTRY_ID

Returns:
com.ibm.commerce.order.objects.OrderItemAccessBean[] An array of OrderItemAccessBean objects representing rows that match the search criteria.
Throws:
javax.naming.NamingException - The javax.naming.NamingException exception
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception

Feedback