public class RelatedCatalogEntryAccessBean extends com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean implements RelatedCatalogEntryAccessBeanData
Constructor and Description |
---|
RelatedCatalogEntryAccessBean()
Zero argument constructor used to initialize the access bean.
|
RelatedCatalogEntryAccessBean(javax.ejb.EJBObject o) |
RelatedCatalogEntryAccessBean(com.ibm.commerce.context.content.objects.EntityCreationData entityCreationData)
Contructor for the object that maps to a corresponding ejbCreate method in the home interface of the EJB.
|
RelatedCatalogEntryAccessBean(java.lang.String associationType_Id, java.lang.String association_Id, java.lang.Long catalogEntry_Id_From, java.lang.Long catalogEntry_Id_To)
Maps to a corresponding ejbCreate method in the home interface of the EJB.
|
Modifier and Type | Method and Description |
---|---|
void | commitCopyHelper() |
protected java.lang.String | defaultJNDIName() |
java.util.Enumeration | findAllSourceCatalogEntries(java.lang.Long catalogEntryId)
Finds all of the source cataglog entries.
|
java.util.Enumeration | findAllTargetCatalogEntries(java.lang.Long catalogEntryId)
Finds all of the target cataglog entries.
|
java.util.Enumeration | findByCatalogEntryAccessories(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryAccessories(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS)
findByCatalogEntryAccessories
|
java.util.Enumeration | findByCatalogEntryAccessoriesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId)
Finds the accessories of the given catalog entries in the store which are included in and not excluded in the product sets.
|
java.util.Enumeration | findByCatalogEntryAccessoriesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId)
findByCatalogEntryAccessoriesAndStore
|
java.util.Enumeration | findByCatalogEntryAccessory(java.lang.Long catalogEntryReferenceNumber)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryAccessoryAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId)
Finds the accessories of the given catalog entries in the store.
|
java.util.Enumeration | findByCatalogEntryAccessoryWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryAccessoryWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId)
Finds the accessories of the given catalog entries and semantic in the store.
|
java.util.Enumeration | findByCatalogEntryAndAllMAssocTypesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId)
Returns the prepared statement which does the query to find all entitled catalog entry merchandizing associations by catalog entry reference number, product set inclusion, product set exclusion and store id.
|
java.util.Enumeration | findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.lang.Integer anStoreId)
Finds the merchandizing associations of the given catalog entries and merchandizing association type in the store.
|
java.util.Enumeration | findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId)
Finds the merchandizing associations of the given catalog entries and the given catalog entries in the store which are included in and not excluded in the product sets.
|
java.util.Enumeration | findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId)
Finds the merchandizing associations of the given catalog entries and the given catalog entries in the store which are included in and not excluded in the product sets.
|
java.util.Enumeration | findByCatalogEntryAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId)
Finds the merchandizing associations of the given catalog entry in the store.
|
java.util.Enumeration | findByCatalogEntryCrossSell(java.lang.Long catalogEntryReferenceNumber)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryCrossSellAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId)
Finds the cross sells of the given catalog entries in the store.
|
java.util.Enumeration | findByCatalogEntryCrossSells(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryCrossSells(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS)
findByCatalogEntryCrossSells
|
java.util.Enumeration | findByCatalogEntryCrossSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId)
Finds the cross sells of the given catalog entries in the store which are included in and not excluded in the product sets.
|
java.util.Enumeration | findByCatalogEntryCrossSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId)
findByCatalogEntryCrossSellsAndStore
|
java.util.Enumeration | findByCatalogEntryCrossSellWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryCrossSellWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId)
Finds the cross sells of the given catalog entries and semantic in the store.
|
java.util.Enumeration | findByCatalogEntryUpSell(java.lang.Long catalogEntryReferenceNumber)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryUpSellAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId)
Finds the up sells of the given catalog entries in the store.
|
java.util.Enumeration | findByCatalogEntryUpSells(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryUpSells(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS)
findByCatalogEntryUpSells
|
java.util.Enumeration | findByCatalogEntryUpSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId)
Finds the up sells of the given catalog entries in the store which are included in and not excluded in the product sets.
|
java.util.Enumeration | findByCatalogEntryUpSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId)
findByCatalogEntryUpSellsAndStore
|
java.util.Enumeration | findByCatalogEntryUpSellWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic)
Finds the related catalog entry with the catalog entry accessories.
|
java.util.Enumeration | findByCatalogEntryUpSellWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId)
Finds the up sells of the given catalog entries and semantic in the store.
|
java.util.Enumeration | findByCatalogEntryWithSemanticAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.String astrMassocType, java.lang.Integer anStoreId)
Finds the merchandizing associations of the given catalog entries and the given catalog entries and semantic in the store.
|
java.util.Enumeration | findWithPushDownQuery(java.lang.String query)
Finds the related catalog entry with the specified query.
|
java.lang.Long | getAssociationReferenceNumber()
getAssociationReferenceNumber
|
java.lang.String | getAssociationType() |
java.sql.Timestamp | getDate1()
getDate1
|
java.lang.String | getField1() |
java.lang.String | getField2() |
java.lang.Integer | getField2InEJBType() |
java.lang.String | getField3() |
java.math.BigDecimal | getField3InEJBType() |
java.lang.String | getFromCatalogEntryReferenceNumber() |
java.lang.Long | getFromCatalogEntryReferenceNumberInEJBType() |
java.lang.String | getGroupName() |
java.lang.String | getOid() |
java.lang.String | getQuantity() |
java.lang.Double | getQuantityInEJBType() |
java.lang.String | getRank() |
java.math.BigDecimal | getRankInEJBType() |
CatalogEntryAccessBean | getRelatedCatalogEntry()
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL.
|
java.lang.String | getRule() |
java.lang.String | getSemanticSpecifier() |
java.lang.Integer | getStoreId()
getStoreId
|
java.lang.String | getToCatalogEntryReferenceNumber() |
java.lang.Long | getToCatalogEntryReferenceNumberInEJBType() |
protected void | instantiateEJB() |
protected boolean | instantiateEJBByPrimaryKey() |
void | refreshCopyHelper() |
void | setAssociationType(java.lang.String newValue) |
void | setDate1(java.sql.Timestamp newValue)
setDate1
|
void | setField1(java.lang.String newValue) |
void | setField2(java.lang.Integer newValue) |
void | setField2(java.lang.String newValue) |
void | setField3(java.math.BigDecimal newValue) |
void | setField3(java.lang.String newValue) |
void | setFromCatalogEntryReferenceNumber(java.lang.Long newValue) |
void | setFromCatalogEntryReferenceNumber(java.lang.String newValue) |
void | setGroupName(java.lang.String newValue) |
void | setInitKey_associationReferenceNumber(java.lang.String newValue) |
void | setOid(java.lang.String newValue) |
void | setQuantity(java.lang.Double newValue) |
void | setQuantity(java.lang.String newValue) |
void | setRank(java.math.BigDecimal newValue) |
void | setRank(java.lang.String newValue) |
void | setRule(java.lang.String newValue) |
void | setSemanticSpecifier(java.lang.String newValue) |
void | setStoreId(java.lang.Integer newValue)
setStoreId
|
void | setToCatalogEntryReferenceNumber(java.lang.Long newValue) |
void | setToCatalogEntryReferenceNumber(java.lang.String newValue) |
public RelatedCatalogEntryAccessBean()
public RelatedCatalogEntryAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
public RelatedCatalogEntryAccessBean(java.lang.String associationType_Id, java.lang.String association_Id, java.lang.Long catalogEntry_Id_From, java.lang.Long catalogEntry_Id_To) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, javax.ejb.FinderException
Maps to a corresponding ejbCreate method in the home interface of the EJB. Creates an access to the related catalog entry according to the association type ID, association reference number, from catalog entry ID, and to catalog entry ID.
public RelatedCatalogEntryAccessBean(com.ibm.commerce.context.content.objects.EntityCreationData entityCreationData) throws javax.naming.NamingException, javax.ejb.FinderException, javax.ejb.CreateException, java.rmi.RemoteException
Contructor for the object that maps to a corresponding ejbCreate method in the home interface of the EJB. Creates an access to the related catalog entry according to the CatalogEntityCreationData.
public java.util.Enumeration findByCatalogEntryAccessories(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY' AND PRODUCTSET.MARKFORDELETE=0 AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS) AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
public java.util.Enumeration findByCatalogEntryAccessory(java.lang.Long catalogEntryReferenceNumber) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT T1.CATENTRY_ID_TO, T1.QUANTITY, T1.MASSOCTYPE_ID, T1.MASSOCCECE_ID, T1.CATENTRY_ID_FROM, T1.MASSOC_ID, T1.RULE, T1.RANK, T1.FIELD1, T1.FIELD2, T1.FIELD3, T1.GROUPNAME, T1.OID FROM MASSOCCECE T1 WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryAccessoryWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOC_ID = semantic AND MASSOCCECE.MASSOCTYPE_ID = 'ACCESSORY' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryCrossSell(java.lang.Long catalogEntryReferenceNumber) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryCrossSellWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOC_ID = semantic AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryCrossSells(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL' AND PRODUCTSET.MARKFORDELETE=0 AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS) AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
public java.util.Enumeration findByCatalogEntryUpSell(java.lang.Long catalogEntryReferenceNumber) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'UPSELL' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryUpSellWithSemantic(java.lang.Long catalogEntryReferenceNumber, java.lang.String semantic) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOC_ID = semantic AND MASSOCCECE.MASSOCTYPE_ID = 'UPSELL' AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO ORDER BY MASSOCCECE.RANK
public java.util.Enumeration findByCatalogEntryUpSells(java.lang.Long catalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the catalog entry accessories.
SQL:
SELECT MASSOCCECE.CATENTRY_ID_TO, MASSOCCECE.QUANTITY, MASSOCCECE.MASSOCTYPE_ID, MASSOCCECE.MASSOCCECE_ID, MASSOCCECE.CATENTRY_ID_FROM, MASSOCCECE.MASSOC_ID, MASSOCCECE.RULE, MASSOCCECE.RANK, MASSOCCECE.FIELD1, MASSOCCECE.FIELD2, MASSOCCECE.FIELD3, MASSOCCECE.GROUPNAME, MASSOCCECE.OID FROM MASSOCCECE, CATENTRY, PRSETCEREL, PRODUCTSET WHERE CATENTRY.MARKFORDELETE = 0 AND MASSOCCECE.CATENTRY_ID_FROM = catalogEntryReferenceNumber AND MASSOCCECE.MASSOCTYPE_ID = 'XSELL' AND PRODUCTSET.MARKFORDELETE=0 AND CATENTRY.CATENTRY_ID = MASSOCCECE.CATENTRY_ID_TO AND MASSOCCECE.CATENTRY_ID_TO=CATENTRY.CATENTRY_ID AND MASSOCCECE.CATENTRY_ID_TO=PRSETCEREL.CATENTRY_ID AND PRSETCEREL.PRODUCTSET_ID = PRODUCTSET.PRODUCTSET_ID AND PRSETCEREL.PRODUCTSET_ID IN (inclusionPS) AND MASSOCCECE.CATENTRY_ID_TO NOT IN (SELECT CATENTRY_ID FROM PRSETCEREL WHERE PRODUCTSET_ID NOT IN (exclusionPS))
public java.util.Enumeration findWithPushDownQuery(java.lang.String query) throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
Finds the related catalog entry with the specified query. The push down query act as the where clause to search in the MASSOCCECE table. An example of the push down query: "CATENTRY_ID_TO=1234 AND CATENTRY_ID_FROM =5678"
public void setInitKey_associationReferenceNumber(java.lang.String newValue)
protected java.lang.String defaultJNDIName()
protected void instantiateEJB() throws java.rmi.RemoteException, javax.ejb.FinderException, javax.naming.NamingException
protected boolean instantiateEJBByPrimaryKey() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.naming.NamingException
public void commitCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void refreshCopyHelper() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.String getQuantity() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Double getQuantityInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setQuantity(java.lang.String newValue)
public void setQuantity(java.lang.Double newValue)
public java.lang.String getRule() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setRule(java.lang.String newValue)
public java.lang.String getField3() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.math.BigDecimal getField3InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setField3(java.lang.String newValue)
public void setField3(java.math.BigDecimal newValue)
public java.lang.String getField2() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Integer getField2InEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setField2(java.lang.String newValue)
public void setField2(java.lang.Integer newValue)
public java.lang.String getField1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setField1(java.lang.String newValue)
public java.lang.String getFromCatalogEntryReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getFromCatalogEntryReferenceNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setFromCatalogEntryReferenceNumber(java.lang.String newValue)
public void setFromCatalogEntryReferenceNumber(java.lang.Long newValue)
public java.lang.String getGroupName() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setGroupName(java.lang.String newValue)
public java.lang.String getOid() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setOid(java.lang.String newValue)
public java.lang.String getRank() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.math.BigDecimal getRankInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setRank(java.lang.String newValue)
public void setRank(java.math.BigDecimal newValue)
public java.lang.String getToCatalogEntryReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.lang.Long getToCatalogEntryReferenceNumberInEJBType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setToCatalogEntryReferenceNumber(java.lang.String newValue)
public void setToCatalogEntryReferenceNumber(java.lang.Long newValue)
public java.lang.String getSemanticSpecifier() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setSemanticSpecifier(java.lang.String newValue)
public java.lang.String getAssociationType() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setAssociationType(java.lang.String newValue)
public CatalogEntryAccessBean getRelatedCatalogEntry() throws javax.naming.NamingException, javax.ejb.CreateException, javax.ejb.FinderException, java.rmi.RemoteException
This method provides access to the MASSOCCECE.MASSOCTYPE_ID column of DB2 type CHAR(32) NOT NULL.
The following is a description of this column:
The Identifier of the association type. Foreign key to the MASSOCTYPE table.
public java.lang.Integer getStoreId() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setStoreId(java.lang.Integer newValue)
public java.sql.Timestamp getDate1() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public void setDate1(java.sql.Timestamp newValue)
public java.util.Enumeration findByCatalogEntryUpSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryUpSellAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAccessoryWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryCrossSellWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAccessoryAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAccessoriesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryCrossSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryCrossSellAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryUpSellWithSemanticAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryWithSemanticAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrSemantic, java.lang.String astrMassocType, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.lang.Long[] inclusionPS, java.lang.Long[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.lang.Long getAssociationReferenceNumber() throws java.rmi.RemoteException, javax.ejb.CreateException, javax.ejb.FinderException, javax.naming.NamingException
public java.util.Enumeration findByCatalogEntryUpSells(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAndMAssocTypeAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.lang.String astrMassocType, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryCrossSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAccessoriesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAccessories(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryUpSellsAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryCrossSells(java.lang.Long catalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findByCatalogEntryAndAllMAssocTypesAndStore(java.lang.Long anCatalogEntryReferenceNumber, java.util.Vector[] inclusionPS, java.util.Vector[] exclusionPS, java.lang.Integer anStoreId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findAllTargetCatalogEntries(java.lang.Long catalogEntryId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException
public java.util.Enumeration findAllSourceCatalogEntries(java.lang.Long catalogEntryId) throws javax.naming.NamingException, javax.ejb.FinderException, java.rmi.RemoteException