|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.ivj.ejb.runtime.AbstractAccessBean | +--com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean | +--com.ibm.commerce.order.objects.OfferAccessBean
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.
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 |
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:
public OfferAccessBean(javax.ejb.EJBObject object) throws java.rmi.RemoteException
Creates an access bean for the specified EJB
object
- The EJB Object used for the access bean construction.java.rmi.RemoteException
- The java.rmi.RemoteException exception.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.
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.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.
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 |
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Update(flush) data to the EJBObject (persistent storage).
commitCopyHelper
in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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 = ?
catEntryId
- The catalog entry id.identifier
- The identifier.trdPosCntId
- The trading position container id.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 = ?))
catEntryId
- The catalog entry id.storeId
- The store id.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)
catEntryId
- The catalog entry id.trdPosCntId
- The trading position container id.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)
catEntryId
- The catalog entry id.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
timestamp1
- The range start timestamptimestamp2
- The range end timestampstoreId
- The store id.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 = ?)
tradingPositionContainerId
- The trading position container id.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"
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.java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
a0
- booleana1
- java.sql.Timestampa2
- java.lang.Long[]a3
- java.lang.Long[]a4
- java.lang.Integera5
- java.lang.Long[]a6
- java.lang.Long[]java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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"
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.java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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
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.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.
getCatalogEntryReferenceNumber
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getEndDate
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getField1
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getField2
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getFlags
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getIdentifier
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getLastUpdate
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getMaximumQuantity
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getMinimumQuantity
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getOfferId
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getOID
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getPrecedence
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
currency
- The currency to return.javax.naming.NamingException
- The javax.naming.NamingException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic 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.
negotiatedCurrency
- The currency of the offer.defaultCurrency
- The alternate currency.javax.naming.NamingException
- The javax.naming.NamingException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic 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.
currency
- The currency.javax.naming.NamingException
- The javax.naming.NamingException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjava.rmi.RemoteException
- The java.rmi.RemoteException exceptionpublic 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).
getPublished
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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).
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getQuantityUnitId
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getStartDate
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
getTradePosContainerId
in interface OfferAccessBeanData
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
Load data from the EJBObject.
refreshCopyHelper
in class com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean
java.rmi.RemoteException
- The java.rmi.RemoteException exceptionjavax.ejb.CreateException
- The javax.ejb.CreateException exceptionjavax.ejb.FinderException
- The javax.ejb.FinderException exceptionjavax.naming.NamingException
- The javax.naming.NamingException exceptionpublic 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.
aCatalogEntryReferenceNumber
- java.lang.Longpublic 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.
setCatalogEntryReferenceNumber
in interface OfferAccessBeanData
aCatalogEntryReferenceNumber
- java.lang.Stringpublic 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.
setEndDate
in interface OfferAccessBeanData
aEndDate
- java.lang.Stringpublic 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.
aEndDate
- java.sql.Timestamppublic 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.
setField1
in interface OfferAccessBeanData
aField1
- java.lang.Stringpublic 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.
setField2
in interface OfferAccessBeanData
aField2
- java.lang.Stringpublic 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.
aFlags
- java.lang.Integerpublic 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.
setFlags
in interface OfferAccessBeanData
aFlags
- java.lang.Stringpublic 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.
aIdentifier
- java.lang.Longpublic 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.
setIdentifier
in interface OfferAccessBeanData
aIdentifier
- java.lang.Stringpublic void setInitKey_offerId(java.lang.String aInitKey_offerId)
Set the primary key for this object
aInitKey_offerId
- java.lang.Stringpublic 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.
setLastUpdate
in interface OfferAccessBeanData
aLastUpdate
- java.lang.Stringpublic 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.
aLastUpdate
- java.sql.Timestamppublic 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.
aMaximumQuantity
- java.lang.Doublepublic 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.
setMaximumQuantity
in interface OfferAccessBeanData
aMaximumQuantity
- java.lang.Stringpublic 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.
aMinimumQuantity
- java.lang.Doublepublic 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.
setMinimumQuantity
in interface OfferAccessBeanData
aMinimumQuantity
- java.lang.Stringpublic 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.
setOID
in interface OfferAccessBeanData
aOID
- java.lang.Stringpublic 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.
aPrecedence
- java.lang.Doublepublic 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.
setPrecedence
in interface OfferAccessBeanData
aPrecedence
- java.lang.Stringpublic 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).
aPublished
- java.lang.Integerpublic 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).
setPublished
in interface OfferAccessBeanData
aPublished
- java.lang.Stringpublic 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.
setQuantityUnitId
in interface OfferAccessBeanData
aQuantityUnitId
- java.lang.Stringpublic 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.
setStartDate
in interface OfferAccessBeanData
aStartDate
- java.lang.Stringpublic 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.
aStartDate
- java.sql.Timestamppublic 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.
aTradePosContainerId
- java.lang.Longpublic 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.
setTradePosContainerId
in interface OfferAccessBeanData
aTradePosContainerId
- java.lang.String
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |