com.ibm.commerce.order.objects
Class OfferAccessBean

java.lang.Object
  |
  +--com.ibm.ivj.ejb.runtime.AbstractAccessBean
        |
        +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
              |
              +--com.ibm.commerce.order.objects.OfferAccessBean
All Implemented Interfaces:
OfferAccessBeanData, java.io.Serializable

public class OfferAccessBean
extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
implements OfferAccessBeanData

This bean provides access to the OFFER table.

The following is a description of this table:

Each row of this table represents an Offer to sell a product identified by a CatalogEntry.

See Also:
Serialized Form

Fields inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
DEFAULT_NAMESERVICE_PROVIDER_URL, DEFAULT_NAMESERVICE_TYPE, ejbRef
 
Constructor Summary
OfferAccessBean()
          Zero argument constructor used to initialize the access bean.
OfferAccessBean(javax.ejb.EJBObject object)
          Creates an access bean for the specified EJB
OfferAccessBean(java.lang.Long itemId, java.lang.Double precedence, java.lang.Long containerId)
          Creates an access bean with the specified attributes.
OfferAccessBean(java.lang.Long itemId, java.lang.Double precedence, java.lang.Long containerId, java.lang.Long identifier)
          Creates an access bean with the specified attributes.
 
Method Summary
 void commitCopyHelper()
          Update(flush) data to the EJBObject (persistent storage).
 OfferAccessBean findByCatalogEntryAndIdentifierAndTradingPosContainer(java.lang.Long catEntryId, java.lang.Long identifier, java.lang.Long trdPosCntId)
          Retrieves the offer for the catalog entry, identifier, and trading position container.
 java.util.Enumeration findByCatalogEntryAndStore(java.lang.Long catEntryId, java.lang.Integer storeId)
          Retrieves all offers for the catalog entry and store.
 java.util.Enumeration findByCatalogEntryAndTradingPositionContainer(java.lang.Long catEntryId, java.lang.Long trdPosCntId)
          Retrieves the offers for the catalog entry and trading position container.
 java.util.Enumeration findByItem(java.lang.Long catEntryId)
          Retrieves all offers for the catalog entry.
 OfferAccessBean findByTimestampAndStore(java.sql.Timestamp timestamp1, java.sql.Timestamp timestamp2, java.lang.Integer storeId)
          Retrieves all offers for the store whose starting date falls within the specified range.
 java.util.Enumeration findByTradingPositionContainerId(java.lang.Long tradingPositionContainerId)
          Retrieves all offers for the trading position container.
 java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds)
          Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.
 java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStorePriceListsAndMemberGroups(boolean a0, java.sql.Timestamp a1, java.lang.Long[] a2, java.lang.Long[] a3, java.lang.Integer a4, java.lang.Long[] a5, java.lang.Long[] a6)
          This method should not be used.
 java.util.Enumeration findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long[] catEntryIds, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] priceListIds, java.lang.String exclusionPredicate, java.lang.String inclusionPredicate)
          Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.
 java.util.Enumeration findEffectiveOffersByTimestampCatentryOffersStoreContractsAndMemberGroups(boolean timestampFlag, java.sql.Timestamp timestamp, java.lang.Long catEntryId, java.lang.Long[] offerIds, java.lang.Integer storeId, java.lang.Long[] contractIds, java.lang.Long[] memberGroupIds)
          Retrieves all valid offers, for the store, for the item restricted by the specified offer ids, contract ids and member group ids.
 java.lang.String getCatalogEntryReferenceNumber()
          This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
 java.lang.Long getCatalogEntryReferenceNumberInEJBType()
          This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
 java.lang.String getEndDate()
          This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getEndDateInEJBType()
          This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.
 java.lang.String getField1()
          This method provides access to the OFFER.FIELD1 column of DB2 type CHAR(30) NULL.
 java.lang.String getField2()
          This method provides access to the OFFER.FIELD2 column of DB2 type CHAR(1) NULL.
 java.lang.String getFlags()
          This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.
 java.lang.Integer getFlagsInEJBType()
          This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.
 java.lang.String getIdentifier()
          This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.
 java.lang.Long getIdentifierInEJBType()
          This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.
 java.lang.String getLastUpdate()
          This method provides access to the OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getLastUpdateInEJBType()
          This method provides access to the OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 java.lang.String getMaximumQuantity()
          This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.
 java.lang.Double getMaximumQuantityInEJBType()
          This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.
 java.lang.String getMinimumQuantity()
          This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.
 java.lang.Double getMinimumQuantityInEJBType()
          This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.
 java.lang.String getOfferId()
          This method provides access to the OFFER.OFFER_ID column of DB2 type BIGINT NOT NULL.
 java.lang.Long getOfferIdInEJBType()
          This method provides access to the OFFER.OFFER_ID column of DB2 type BIGINT NOT NULL.
 java.lang.String getOID()
          This method provides access to the OFFER.OID column of DB2 type VARCHAR(64) NULL.
 java.lang.String getPrecedence()
          This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.
 java.lang.Double getPrecedenceInEJBType()
          This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.
 OfferPriceAccessBean getPrice(java.lang.String currency)
          Returns the OfferPriceAccessBean associated with this offer for the specified currency.
 OfferPriceAccessBean getPrice(java.lang.String negotiatedCurrency, java.lang.String defaultCurrency)
          Returns the OfferPriceAccessBean associated with this offer for the negotiated currency.
 java.util.Vector getPrices(java.lang.String aPrices)
          Returns a vector of OfferPriceAccessBean objects.
 java.lang.String getPublished()
          This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.
 java.lang.Integer getPublishedInEJBType()
          This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.
 java.lang.String getQuantityUnitId()
          This method provides access to the OFFER.QTYUNIT_ID column of DB2 type CHAR(16) NULL.
 java.lang.String getStartDate()
          This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.
 java.sql.Timestamp getStartDateInEJBType()
          This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.
 java.lang.String getTradePosContainerId()
          This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.
 java.lang.Long getTradePosContainerIdInEJBType()
          This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.
 void refreshCopyHelper()
          Load data from the EJBObject.
 void setCatalogEntryReferenceNumber(java.lang.Long aCatalogEntryReferenceNumber)
          This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
 void setCatalogEntryReferenceNumber(java.lang.String aCatalogEntryReferenceNumber)
          This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.
 void setEndDate(java.lang.String aEndDate)
          This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.
 void setEndDate(java.sql.Timestamp aEndDate)
          This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.
 void setField1(java.lang.String aField1)
          This method provides access to the OFFER.FIELD1 column of DB2 type CHAR(30) NULL.
 void setField2(java.lang.String aField2)
          This method provides access to the OFFER.FIELD2 column of DB2 type CHAR(1) NULL.
 void setFlags(java.lang.Integer aFlags)
          This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.
 void setFlags(java.lang.String aFlags)
          This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.
 void setIdentifier(java.lang.Long aIdentifier)
          This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.
 void setIdentifier(java.lang.String aIdentifier)
          This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.
 void setInitKey_offerId(java.lang.String aInitKey_offerId)
          Set the primary key for this object
 void setLastUpdate(java.lang.String aLastUpdate)
          This method provides access to the OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 void setLastUpdate(java.sql.Timestamp aLastUpdate)
          This method provides access to the OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.
 void setMaximumQuantity(java.lang.Double aMaximumQuantity)
          This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.
 void setMaximumQuantity(java.lang.String aMaximumQuantity)
          This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.
 void setMinimumQuantity(java.lang.Double aMinimumQuantity)
          This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.
 void setMinimumQuantity(java.lang.String aMinimumQuantity)
          This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.
 void setOID(java.lang.String aOID)
          This method provides access to the OFFER.OID column of DB2 type VARCHAR(64) NULL.
 void setPrecedence(java.lang.Double aPrecedence)
          This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.
 void setPrecedence(java.lang.String aPrecedence)
          This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.
 void setPublished(java.lang.Integer aPublished)
          This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.
 void setPublished(java.lang.String aPublished)
          This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.
 void setQuantityUnitId(java.lang.String aQuantityUnitId)
          This method provides access to the OFFER.QTYUNIT_ID column of DB2 type CHAR(16) NULL.
 void setStartDate(java.lang.String aStartDate)
          This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.
 void setStartDate(java.sql.Timestamp aStartDate)
          This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.
 void setTradePosContainerId(java.lang.Long aTradePosContainerId)
          This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.
 void setTradePosContainerId(java.lang.String aTradePosContainerId)
          This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
__getCache, __getCache, __getKey, __setCache, __setCache, __setKey, commitCopyHelper, createAccessBeans, createAccessBeans, instantiateEJBByPrimaryKey, refreshCopyHelper, setEJBRef
 
Methods inherited from class com.ibm.ivj.ejb.runtime.AbstractAccessBean
defaultJNDIName, defaultNameServiceType, defaultNameServiceURL, getEJBRef, getGlobalHome, getHome, getInit_GlobalNameServiceTypeName, getInit_GlobalNameServiceURLName, getInit_JNDIName, getInit_NameServiceTypeName, getInit_NameServiceURLName, getInitContext, getInitContext, instantiateEJB, resetEJBRef, resetHomeCache, setInit_GlobalNameServiceTypeName, setInit_GlobalNameServiceURLName, setInit_JNDIName, setInit_NameServiceTypeName, setInit_NameServiceURLName
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OfferAccessBean

public OfferAccessBean()

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.Offer com.ibm.commerce.order.objimpl.OfferHomeBase.findByPrimaryKey(com.ibm.commerce.order.objects.OfferKey) 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:


OfferAccessBean

public OfferAccessBean(javax.ejb.EJBObject object)
                throws java.rmi.RemoteException

Creates an access bean for the specified EJB

Parameters:
object - The EJB Object used for the access bean construction.
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception.

OfferAccessBean

public OfferAccessBean(java.lang.Long itemId,
                       java.lang.Double precedence,
                       java.lang.Long containerId)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       java.rmi.RemoteException,
                       javax.ejb.FinderException

Creates an access bean with the specified attributes.

Parameters:
itemId - The catalog entry ID for which the offer is to apply.
precedence - The precedence of the offer.
containerId - The id of the trading position container to hold the offer.

OfferAccessBean

public OfferAccessBean(java.lang.Long itemId,
                       java.lang.Double precedence,
                       java.lang.Long containerId,
                       java.lang.Long identifier)
                throws javax.naming.NamingException,
                       javax.ejb.CreateException,
                       java.rmi.RemoteException,
                       javax.ejb.FinderException

Creates an access bean with the specified attributes.

Parameters:
itemId - The catalog entry ID for which the offer is to apply.
precedence - The precedence of the offer.
containerId - The id of the trading position container to hold the offer.
identifier - The identifier of the offer.
Method Detail

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).

Overrides:
commitCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findByCatalogEntryAndIdentifierAndTradingPosContainer

public OfferAccessBean findByCatalogEntryAndIdentifierAndTradingPosContainer(java.lang.Long catEntryId,
                                                                             java.lang.Long identifier,
                                                                             java.lang.Long trdPosCntId)
                                                                      throws java.rmi.RemoteException,
                                                                             javax.ejb.FinderException,
                                                                             javax.naming.NamingException

Retrieves the offer for the catalog entry, identifier, and trading position container.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE T1.CATENTRY_ID = ? AND T1.IDENTIFIER = ? AND T1.TRADEPOSCN_ID = ?

Parameters:
catEntryId - The catalog entry id.
identifier - The identifier.
trdPosCntId - The trading position container id.
Returns:
The OfferAccessBean representing the row that matches the search criteria.

findByCatalogEntryAndStore

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

Retrieves all offers for the catalog entry and store.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE (T1.CATENTRY_ID) = ? and (T1.TRADEPOSCN_ID IN (SELECT TRADEPOSCN_ID FROM TDPSCNCNTR, CONTRACT, STORECNTR WHERE CONTRACT.CONTRACT_ID = TDPSCNCNTR.CONTRACT_ID AND CONTRACT.CONTRACT_ID = STORECNTR.CONTRACT_ID AND STORECNTR.STORE_ID = ?))

Parameters:
catEntryId - The catalog entry id.
storeId - The store id.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

findByCatalogEntryAndTradingPositionContainer

public java.util.Enumeration findByCatalogEntryAndTradingPositionContainer(java.lang.Long catEntryId,
                                                                           java.lang.Long trdPosCntId)
                                                                    throws java.rmi.RemoteException,
                                                                           javax.ejb.FinderException,
                                                                           javax.naming.NamingException

Retrieves the offers for the catalog entry and trading position container.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE T1.CATENTRY_ID=? AND T1.TRADEPOSCN_ID = ? AND (T1.PUBLISHED = 1 OR T1.PUBLISHED IS NULL)

Parameters:
catEntryId - The catalog entry id.
trdPosCntId - The trading position container id.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

findByItem

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

Retrieves all offers for the catalog entry.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE (T1.CATENTRY_ID = ?) AND (T1.PUBLISHED = 1 OR T1.PUBLISHED IS NULL)

Parameters:
catEntryId - The catalog entry id.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

findByTimestampAndStore

public OfferAccessBean findByTimestampAndStore(java.sql.Timestamp timestamp1,
                                               java.sql.Timestamp timestamp2,
                                               java.lang.Integer storeId)
                                        throws java.rmi.RemoteException,
                                               javax.ejb.FinderException,
                                               javax.naming.NamingException

Retrieves all offers for the store whose starting date falls within the specified range.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE (T1.STARTDATE is not null and T1.STARTDATE > ? and T1.STARTDATE < ?) and (T1.TRADEPOSCN_ID in (select TRADEPOSCN_ID from TDPSCNCNTR, CONTRACT, STORECNTR where (TDPSCNCNTR.CONTRACT_ID = CONTRACT.CONTRACT_ID) and (STORECNTR.CONTRACT_ID = CONTRACT.CONTRACT_ID) and (STORECNTR.STORE_ID = ?) and CONTRACT.STATE = 3)) order by T1.STARTDATE asc

Parameters:
timestamp1 - The range start timestamp
timestamp2 - The range end timestamp
storeId - The store id.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

findByTradingPositionContainerId

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

Retrieves all offers for the trading position container.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE (T1.TRADEPOSCN_ID = ?)

Parameters:
tradingPositionContainerId - The trading position container id.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

findEffectiveOffersByTimestampCatentriesOffersStoreAndPriceLists

public java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStoreAndPriceLists(boolean timestampFlag,
                                                                                              java.sql.Timestamp timestamp,
                                                                                              java.lang.Long[] catEntryIds,
                                                                                              java.lang.Long[] offerIds,
                                                                                              java.lang.Integer storeId,
                                                                                              java.lang.Long[] priceListIds)
                                                                                       throws java.rmi.RemoteException,
                                                                                              javax.ejb.FinderException,
                                                                                              javax.naming.NamingException

Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE " (T1.startdate < " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.startdate is null) and" + " (T1.enddate > " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.enddate is null) and" + " (T1.published = 1) and" + (catentryIds == null ? "" : " (T1.catentry_id " + getInPredicate(catentryIds) + ") and") + (offerIds == null ? "" : " (T1.offer_id " + getInPredicate(offerIds) + ") and") + " T1.tradeposcn_id in (" + " select tradeposcn.tradeposcn_id from tradeposcn where" + " ((0 = 0)" + (priceListIds == null ? ")" : " and (tradeposcn_id " + getInPredicate(priceListIds) + ")))") + " order by catentry_id, tradeposcn_id, precedence desc"

Parameters:
timestampFlag - The flag that specifies whether a time stamp is passed in (true) or whether the current time stamp on the EJB machine is used.
time - stamp The time stamp to be compared with the offer's effective period.
catEntryIds - The catalog entry ids.
offerIds - The offer ids to be searched. If null then all offers are searched.
storeId - The store id to search.
priceListIds - The price ids to be searched. If null then all price lists are searched.
Returns:
An Enumeration of all the OfferAccessBeans 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 - The javax.naming.NamingException exception

findEffectiveOffersByTimestampCatentriesOffersStorePriceListsAndMemberGroups

public java.util.Enumeration findEffectiveOffersByTimestampCatentriesOffersStorePriceListsAndMemberGroups(boolean a0,
                                                                                                          java.sql.Timestamp a1,
                                                                                                          java.lang.Long[] a2,
                                                                                                          java.lang.Long[] a3,
                                                                                                          java.lang.Integer a4,
                                                                                                          java.lang.Long[] a5,
                                                                                                          java.lang.Long[] a6)
                                                                                                   throws java.rmi.RemoteException,
                                                                                                          javax.ejb.FinderException,
                                                                                                          javax.naming.NamingException

This method should not be used.

Parameters:
a0 - boolean
a1 - java.sql.Timestamp
a2 - java.lang.Long[]
a3 - java.lang.Long[]
a4 - java.lang.Integer
a5 - java.lang.Long[]
a6 - java.lang.Long[]
Returns:
java.util.Enumeration
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists

public java.util.Enumeration findEffectiveOffersByTimestampCatentriesPredicateOffersStoreAndPriceLists(boolean timestampFlag,
                                                                                                       java.sql.Timestamp timestamp,
                                                                                                       java.lang.Long[] catEntryIds,
                                                                                                       java.lang.Long[] offerIds,
                                                                                                       java.lang.Integer storeId,
                                                                                                       java.lang.Long[] priceListIds,
                                                                                                       java.lang.String exclusionPredicate,
                                                                                                       java.lang.String inclusionPredicate)
                                                                                                throws java.rmi.RemoteException,
                                                                                                       javax.ejb.FinderException,
                                                                                                       javax.naming.NamingException

Retrieves all valid offers, for the store, for the item restricted by the specified input parameters.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE (T1.startdate < " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.startdate is null) and" + " (T1.enddate > " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.enddate is null) and" + " (T1.published = 1) and" + (catentryIds == null ? " (0 = 0" : " (T1.catentry_id " + getInPredicate(catentryIds)) + (exclusionPredicate == null ? "" : " and (T1.catentry_id " + exclusionPredicate + ")") + (inclusionPredicate == null ? "" : " and (T1.catentry_id " + inclusionPredicate + ")") + ") and" + (offerIds == null ? "" : " (T1.offer_id " + getInPredicate(offerIds) + ") and") + " T1.tradeposcn_id in (" + " select tradeposcn.tradeposcn_id from tradeposcn where" + " ((0 = 0)" + (priceListIds == null ? ")" : " and (tradeposcn_id " + getInPredicate(priceListIds) + ")))") + " order by catentry_id, tradeposcn_id, precedence desc"

Parameters:
timestampFlag - The flag that specifies whether a time stamp is passed in (true) or whether the current time stamp on the EJB machine is used.
time - stamp The time stamp to be compared with the offer's effective period.
catEntryIds - The catalog entry ids.
offerIds - The offer ids to be searched. If null then all offers are searched.
storeId - The store id to search.
priceListIds - The price ids to be searched. If null then all price lists are searched.
exclusionPredicate - the list of product ids to be excluded from the search.
inclusionPredicate - the list of product ids to be included in the search only.
Returns:
An Enumeration of all the OfferAccessBeans 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 - The javax.naming.NamingException exception

findEffectiveOffersByTimestampCatentryOffersStoreContractsAndMemberGroups

public java.util.Enumeration findEffectiveOffersByTimestampCatentryOffersStoreContractsAndMemberGroups(boolean timestampFlag,
                                                                                                       java.sql.Timestamp timestamp,
                                                                                                       java.lang.Long catEntryId,
                                                                                                       java.lang.Long[] offerIds,
                                                                                                       java.lang.Integer storeId,
                                                                                                       java.lang.Long[] contractIds,
                                                                                                       java.lang.Long[] memberGroupIds)
                                                                                                throws java.rmi.RemoteException,
                                                                                                       javax.ejb.FinderException,
                                                                                                       javax.naming.NamingException

Retrieves all valid offers, for the store, for the item restricted by the specified offer ids, contract ids and member group ids.

The SQL query used to fetch all the required rows from the OFFER table is:

SELECT * FROM OFFER T1 WHERE "(T1.startdate < " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.startdate is null) and" + " (T1.enddate > " + (timestampFlag ? "?" : com.ibm.commerce.ejb.helpers.TimestampHelper.getSQLCurrentTimestamp()) + " or T1.enddate is null) and" + " (T1.published = 1) and (T1.catentry_id = ?) and" + (offerIds == null ? "" : " (T1.offer_id " + getInPredicate(offerIds) + ") and") + " T1.tradeposcn_id = any (" + " select tradeposcn.tradeposcn_id " + " from contract, tradeposcn, tdpscncntr, storecntr " + " where " + " contract.contract_id=tdpscncntr.contract_id and " + " tradeposcn.tradeposcn_id = tdpscncntr.tradeposcn_id and " + " storecntr.store_id = ? and storecntr.contract_id=tdpscncntr.contract_id and " + " contract.state = 3 and " + (contractIds == null ? "" : " contract.contract_id " + getInPredicate(contractIds) + " and ") + " (tradeposcn.flags = 0 " + " or ((tradeposcn.flags = 1) and tradeposcn.tradeposcn_id in" + " (select mgptrdpscn.tradeposcn_id as tradeposcn_id from mgptrdpscn, storembrgp" + " where mgptrdpscn.mbrgrp_id = storembrgp.mbrgrp_id and store_id = ? and mgptrdpscn.mbrgrp_id " + getInPredicate(memberGroupIds) + "))" + order by tradeposcn_id, precedence desc

Parameters:
timestampFlag - The flag that specifies whether a timestamp is passed in (true) or whether the current timestamp on the EJB machine is used.
timestamp - The timestamp to be compared with the offer's effective period.
catEntryId - The catalog entry id.
offerIds - The offer ids to be searched. If null then all offers are searched.
storeId - The store id to search.
contractIds - The contract ids to be searched. If null then all contracts are searched.
memberGroupIds - The member group ids to be searched. If null then trading position containers not restricted by member group are searched.
Returns:
An Enumeration of all the OfferAccessBeans representing rows that match the search criteria.

getCatalogEntryReferenceNumber

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

This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry offered for sale.

Specified by:
getCatalogEntryReferenceNumber in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getCatalogEntryReferenceNumberInEJBType

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

This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry offered for sale.

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

getEndDate

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

This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The end of the time range during which this Offer is effective.

Specified by:
getEndDate in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getEndDateInEJBType

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

This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The end of the time range during which this Offer is effective.

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

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 OFFER.FIELD1 column of DB2 type CHAR(30) NULL.

The following is a description of this column:

Customizable.

Specified by:
getField1 in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 OFFER.FIELD2 column of DB2 type CHAR(1) NULL.

The following is a description of this column:

Customizable.

Specified by:
getField2 in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getFlags

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

This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Contains the following bit flag value:
1 = shiptoAddressRequired - if 1, OrderPrepare will return an error if an OrderItem references this Offer but does not have a shipping address.

Specified by:
getFlags in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getFlagsInEJBType

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

This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Contains the following bit flag value:
1 = shiptoAddressRequired - if 1, OrderPrepare will return an error if an OrderItem references this Offer but does not have a shipping address.

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

getIdentifier

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

This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.

The following is a description of this column:

A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.

Specified by:
getIdentifier in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getIdentifierInEJBType

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

This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.

The following is a description of this column:

A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.

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

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 OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The last time this Offer was updated.

Specified by:
getLastUpdate in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

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 OFFER.LASTUPDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The last time this Offer was updated.

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

getMaximumQuantity

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

This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The maximum quantity that can be purchased in a single Order under this Offer.

Specified by:
getMaximumQuantity in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getMaximumQuantityInEJBType

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

This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The maximum quantity that can be purchased in a single Order under this Offer.

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

getMinimumQuantity

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

This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The minimum quantity that can be purchased in a single Order under this Offer.

Specified by:
getMinimumQuantity in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getMinimumQuantityInEJBType

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

This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The minimum quantity that can be purchased in a single Order under this Offer.

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

getOfferId

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

This method provides access to the OFFER.OFFER_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

Generated unique key.

Specified by:
getOfferId in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getOfferIdInEJBType

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

This method provides access to the OFFER.OFFER_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 - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getOID

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

This method provides access to the OFFER.OID column of DB2 type VARCHAR(64) NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
getOID in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getPrecedence

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

This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.

Specified by:
getPrecedence in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getPrecedenceInEJBType

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

This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.

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

getPrice

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

Returns the OfferPriceAccessBean associated with this offer for the specified currency.

Parameters:
currency - The currency to return.
Returns:
The offer price access bean.
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

getPrice

public OfferPriceAccessBean getPrice(java.lang.String negotiatedCurrency,
                                     java.lang.String defaultCurrency)
                              throws javax.naming.NamingException,
                                     javax.ejb.CreateException,
                                     javax.ejb.FinderException,
                                     java.rmi.RemoteException

Returns the OfferPriceAccessBean associated with this offer for the negotiated currency. If there is no price available for the negotiated currency, returns the OfferAccessBean for the default currency.

Parameters:
negotiatedCurrency - The currency of the offer.
defaultCurrency - The alternate currency.
Returns:
The offer price access bean.
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

getPrices

public java.util.Vector getPrices(java.lang.String aPrices)
                           throws javax.naming.NamingException,
                                  javax.ejb.CreateException,
                                  javax.ejb.FinderException,
                                  java.rmi.RemoteException

Returns a vector of OfferPriceAccessBean objects. If there is an OfferPrice for this offer and for the currency, return a one-element vector that only contains this OfferPriceAccessBean, otherwise returns a vector with all the OfferPriceAccessBean objects associated with this offer.

Parameters:
currency - The currency.
Returns:
The vector of offer price access beans.
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

getPublished

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

This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Describes whether or not the offer has been published as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).

Specified by:
getPublished in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getPublishedInEJBType

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

This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Describes whether or not the offer has been published as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).

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

getQuantityUnitId

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

This method provides access to the OFFER.QTYUNIT_ID column of DB2 type CHAR(16) NULL.

The following is a description of this column:

The unit of measure for MINIMUMQUANTITY and MAXIMUMQUANTITY. If this is NULL, then MINIMUMQUANTITY and MAXIMUMQUANTITY are multiplied by CATENTSHIP.NOMINALQUANTITY and the unit of measure of the results is CATENTSHIP.QUANTITYMEASURE.

Specified by:
getQuantityUnitId in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getStartDate

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

This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The start of the time range during which this Offer is effective.

Specified by:
getStartDate in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getStartDateInEJBType

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

This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The start of the time range during which this Offer is effective.

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

getTradePosContainerId

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

This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The TradingPositionContainer this Offer is part of.

Specified by:
getTradePosContainerId in interface OfferAccessBeanData
Returns:
java.lang.String
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

getTradePosContainerIdInEJBType

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

This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The TradingPositionContainer this Offer is part of.

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

refreshCopyHelper

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

Load data from the EJBObject.

Overrides:
refreshCopyHelper in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
Returns:
void
Throws:
java.rmi.RemoteException - The java.rmi.RemoteException exception
javax.ejb.CreateException - The javax.ejb.CreateException exception
javax.ejb.FinderException - The javax.ejb.FinderException exception
javax.naming.NamingException - The javax.naming.NamingException exception

setCatalogEntryReferenceNumber

public void setCatalogEntryReferenceNumber(java.lang.Long aCatalogEntryReferenceNumber)

This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry offered for sale.

Parameters:
aCatalogEntryReferenceNumber - java.lang.Long
Returns:
void

setCatalogEntryReferenceNumber

public void setCatalogEntryReferenceNumber(java.lang.String aCatalogEntryReferenceNumber)

This method provides access to the OFFER.CATENTRY_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The CatalogEntry offered for sale.

Specified by:
setCatalogEntryReferenceNumber in interface OfferAccessBeanData
Parameters:
aCatalogEntryReferenceNumber - java.lang.String
Returns:
void

setEndDate

public void setEndDate(java.lang.String aEndDate)

This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The end of the time range during which this Offer is effective.

Specified by:
setEndDate in interface OfferAccessBeanData
Parameters:
aEndDate - java.lang.String
Returns:
void

setEndDate

public void setEndDate(java.sql.Timestamp aEndDate)

This method provides access to the OFFER.ENDDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The end of the time range during which this Offer is effective.

Parameters:
aEndDate - java.sql.Timestamp
Returns:
void

setField1

public void setField1(java.lang.String aField1)

This method provides access to the OFFER.FIELD1 column of DB2 type CHAR(30) NULL.

The following is a description of this column:

Customizable.

Specified by:
setField1 in interface OfferAccessBeanData
Parameters:
aField1 - java.lang.String
Returns:
void

setField2

public void setField2(java.lang.String aField2)

This method provides access to the OFFER.FIELD2 column of DB2 type CHAR(1) NULL.

The following is a description of this column:

Customizable.

Specified by:
setField2 in interface OfferAccessBeanData
Parameters:
aField2 - java.lang.String
Returns:
void

setFlags

public void setFlags(java.lang.Integer aFlags)

This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Contains the following bit flag value:
1 = shiptoAddressRequired - if 1, OrderPrepare will return an error if an OrderItem references this Offer but does not have a shipping address.

Parameters:
aFlags - java.lang.Integer
Returns:
void

setFlags

public void setFlags(java.lang.String aFlags)

This method provides access to the OFFER.FLAGS column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Contains the following bit flag value:
1 = shiptoAddressRequired - if 1, OrderPrepare will return an error if an OrderItem references this Offer but does not have a shipping address.

Specified by:
setFlags in interface OfferAccessBeanData
Parameters:
aFlags - java.lang.String
Returns:
void

setIdentifier

public void setIdentifier(java.lang.Long aIdentifier)

This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.

The following is a description of this column:

A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.

Parameters:
aIdentifier - java.lang.Long
Returns:
void

setIdentifier

public void setIdentifier(java.lang.String aIdentifier)

This method provides access to the OFFER.IDENTIFIER column of DB2 type BIGINT NULL.

The following is a description of this column:

A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.

Specified by:
setIdentifier in interface OfferAccessBeanData
Parameters:
aIdentifier - java.lang.String
Returns:
void

setInitKey_offerId

public void setInitKey_offerId(java.lang.String aInitKey_offerId)

Set the primary key for this object

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

setLastUpdate

public void setLastUpdate(java.lang.String aLastUpdate)

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

The following is a description of this column:

The last time this Offer was updated.

Specified by:
setLastUpdate in interface OfferAccessBeanData
Parameters:
aLastUpdate - java.lang.String
Returns:
void

setLastUpdate

public void setLastUpdate(java.sql.Timestamp aLastUpdate)

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

The following is a description of this column:

The last time this Offer was updated.

Parameters:
aLastUpdate - java.sql.Timestamp
Returns:
void

setMaximumQuantity

public void setMaximumQuantity(java.lang.Double aMaximumQuantity)

This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The maximum quantity that can be purchased in a single Order under this Offer.

Parameters:
aMaximumQuantity - java.lang.Double
Returns:
void

setMaximumQuantity

public void setMaximumQuantity(java.lang.String aMaximumQuantity)

This method provides access to the OFFER.MAXIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The maximum quantity that can be purchased in a single Order under this Offer.

Specified by:
setMaximumQuantity in interface OfferAccessBeanData
Parameters:
aMaximumQuantity - java.lang.String
Returns:
void

setMinimumQuantity

public void setMinimumQuantity(java.lang.Double aMinimumQuantity)

This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The minimum quantity that can be purchased in a single Order under this Offer.

Parameters:
aMinimumQuantity - java.lang.Double
Returns:
void

setMinimumQuantity

public void setMinimumQuantity(java.lang.String aMinimumQuantity)

This method provides access to the OFFER.MINIMUMQUANTITY column of DB2 type FLOAT NULL.

The following is a description of this column:

The minimum quantity that can be purchased in a single Order under this Offer.

Specified by:
setMinimumQuantity in interface OfferAccessBeanData
Parameters:
aMinimumQuantity - java.lang.String
Returns:
void

setOID

public void setOID(java.lang.String aOID)

This method provides access to the OFFER.OID column of DB2 type VARCHAR(64) NULL.

The following is a description of this column:

Reserved for IBM internal use.

Specified by:
setOID in interface OfferAccessBeanData
Parameters:
aOID - java.lang.String
Returns:
void

setPrecedence

public void setPrecedence(java.lang.Double aPrecedence)

This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.

Parameters:
aPrecedence - java.lang.Double
Returns:
void

setPrecedence

public void setPrecedence(java.lang.String aPrecedence)

This method provides access to the OFFER.PRECEDENCE column of DB2 type FLOAT NOT NULL.

The following is a description of this column:

When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.

Specified by:
setPrecedence in interface OfferAccessBeanData
Parameters:
aPrecedence - java.lang.String
Returns:
void

setPublished

public void setPublished(java.lang.Integer aPublished)

This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Describes whether or not the offer has been published as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).

Parameters:
aPublished - java.lang.Integer
Returns:
void

setPublished

public void setPublished(java.lang.String aPublished)

This method provides access to the OFFER.PUBLISHED column of DB2 type INTEGER NOT NULL.

The following is a description of this column:

Describes whether or not the offer has been published as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).

Specified by:
setPublished in interface OfferAccessBeanData
Parameters:
aPublished - java.lang.String
Returns:
void

setQuantityUnitId

public void setQuantityUnitId(java.lang.String aQuantityUnitId)

This method provides access to the OFFER.QTYUNIT_ID column of DB2 type CHAR(16) NULL.

The following is a description of this column:

The unit of measure for MINIMUMQUANTITY and MAXIMUMQUANTITY. If this is NULL, then MINIMUMQUANTITY and MAXIMUMQUANTITY are multiplied by CATENTSHIP.NOMINALQUANTITY and the unit of measure of the results is CATENTSHIP.QUANTITYMEASURE.

Specified by:
setQuantityUnitId in interface OfferAccessBeanData
Parameters:
aQuantityUnitId - java.lang.String
Returns:
void

setStartDate

public void setStartDate(java.lang.String aStartDate)

This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The start of the time range during which this Offer is effective.

Specified by:
setStartDate in interface OfferAccessBeanData
Parameters:
aStartDate - java.lang.String
Returns:
void

setStartDate

public void setStartDate(java.sql.Timestamp aStartDate)

This method provides access to the OFFER.STARTDATE column of DB2 type TIMESTAMP NULL.

The following is a description of this column:

The start of the time range during which this Offer is effective.

Parameters:
aStartDate - java.sql.Timestamp
Returns:
void

setTradePosContainerId

public void setTradePosContainerId(java.lang.Long aTradePosContainerId)

This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The TradingPositionContainer this Offer is part of.

Parameters:
aTradePosContainerId - java.lang.Long
Returns:
void

setTradePosContainerId

public void setTradePosContainerId(java.lang.String aTradePosContainerId)

This method provides access to the OFFER.TRADEPOSCN_ID column of DB2 type BIGINT NOT NULL.

The following is a description of this column:

The TradingPositionContainer this Offer is part of.

Specified by:
setTradePosContainerId in interface OfferAccessBeanData
Parameters:
aTradePosContainerId - java.lang.String
Returns:
void