public class ContractJDBCHelperBeanBase extends BaseJDBCHelper implements javax.ejb.SessionBean
Constructor and Description |
---|
ContractJDBCHelperBeanBase() |
Modifier and Type | Method and Description |
---|---|
int | addContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML)
Deprecated.
This method is replaced by ContractStoreAccessBean#ContractStoreAccessBean(Long, String)
|
int | addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin)
Adds an entry to the contract name table.
|
int | addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush)
Adds an entry to the contract name table.
|
int | addPolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId)
Deprecated.
This method is replaced by PolicyTCRelationAccessBean#PolicyTCRelationAccessBean(Long, Long)
|
int | addProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type)
Inserts a product set adjustment row into the PSETADJMNT table.
|
int | addProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type, boolean flush)
Inserts a product set adjustment row into the PSETADJMNT table.
|
int | addStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId)
Deprecated.
This method is replaced by StoreContractAccessBean#StoreContractAccessBean(StoreContractKey)
|
int | addTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#TermConditionAttributeAccessBean(Long, Integer, Integer, Long, String)
|
int | addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#TradingPositionContainerXMLDefinitionAccessBean(Long, Integer, String)
|
int | addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec, boolean flush)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#TradingPositionContainerXMLDefinitionAccessBean(Long, Integer, String)
|
int | deleteContractStoreXML(java.lang.Long contractId)
Deprecated.
This method is replaced by ContractStoreAccessBean#getEJBRef().remove()
|
int | deleteContractStoreXML(java.lang.Long contractId, boolean flush)
Deprecated.
This method is replaced by ContractStoreAccessBean#getEJBRef().remove()
|
int | deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin)
Deletes an entry from the contract name table.
|
int | deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush)
Deletes an entry from the contract name table.
|
int | deletePolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId)
Deprecated.
This method is replaced by PolicyTCRelationAccessBean#getEJBRef().remove()
|
int | deletePolicyTCByTC(java.lang.Long argTCId)
Deprecated.
This method is replaced by PolicyTCRelationAccessBean#getEJBRef().remove()
|
int | deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId)
Deletes a product set adjustment row from the PSETADJMNT table.
|
int | deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, boolean flush)
Deletes a product set adjustment row from the PSETADJMNT table.
|
int | deleteStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId)
Deprecated.
This method is replaced by StoreContractAccessBean#getEJBRef().remove()
|
int | deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#getEJBRef().remove()
|
int | deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence, boolean flush)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#getEJBRef().remove()
|
int | deleteXMLDefByTPC(java.lang.Long argTPCId)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#getEJBRef().remove()
|
int | deleteXMLDefByTPC(java.lang.Long argTPCId, boolean flush)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#getEJBRef().remove()
|
void | ejbActivate()
Activates the EJB
|
void | ejbPassivate()
Passivates the EJB
|
void | ejbRemove()
Removes the EJB
|
java.lang.Long | findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId)
Retrieves the account ID associated with the specified user member ID & store ID
|
java.lang.Long | findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, boolean flush)
Retrieves the account ID associated with the specified user member ID & store ID
|
java.lang.Long | findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, java.lang.Long aOrganizationId)
Retrieves the account ID associated with the specified user member ID & store ID
|
java.lang.Long | findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, java.lang.Long aOrganizationId, boolean flush)
Retrieves the account ID associated with the specified user member ID & store ID
|
java.util.Vector | findActiveContractsDeployedInStore(java.lang.Integer storeId)
Retrieves the contracts in active state that are deployed in the specified store.
|
java.util.Vector | findActiveContractsDeployedInStore(java.lang.Integer storeId, boolean flush)
Retrieves the contracts in active state that are deployed in the specified store.
|
java.util.Vector | findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId)
Retrieves the names of all the business command classes associated with the specified policy
|
java.util.Vector | findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId, boolean flush)
Retrieves the names of all the business command classes associated with the specified policy
|
java.util.Vector | findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType)
Retrieves the names of all the business command interfaces associated with the specified policy
|
java.util.Vector | findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType, boolean flush)
Retrieves the names of all the business command interfaces associated with the specified policy
|
java.util.Vector | findAllBusinessPolicyType()
Retrieves all the policy types from the POLICYTYPE table.
|
java.util.Vector | findAllBusinessPolicyType(boolean flush)
Retrieves all the policy types from the POLICYTYPE table.
|
java.util.Vector | findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#findByTermConditionIdAndType(Long, Integer)
|
java.util.Vector | findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, boolean flush)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#findByTermConditionIdAndType(Long, Integer)
|
java.util.Vector | findAllTCSubType()
Retrieves all the term condition subtypes from the TCSUBTYPE table.
|
java.util.Vector | findAllTCSubType(boolean flush)
Retrieves all the term condition subtypes from the TCSUBTYPE table.
|
java.lang.String | findContractComments(java.lang.Long aContractId)
Deprecated.
This method is replaced by ContractAccessBean#getComments()
|
java.lang.String | findContractComments(java.lang.Long aContractId, boolean flush)
Deprecated.
This method is replaced by ContractAccessBean#getComments()
|
java.util.Vector | findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn)
Retrieves all contracts associated with the specified account ID
|
java.util.Vector | findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn, boolean flush)
Retrieves all contracts associated with the specified account ID
|
java.util.Vector | findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn)
Retrieves all contracts associated with the specified account ID and state
|
java.util.Vector | findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn, boolean flush)
Retrieves all contracts associated with the specified account ID and state
|
java.lang.String | findContractStoreXML(java.lang.Long argContractId)
Deprecated.
This method is replaced by ContractStoreAccessBean#getStoreXML()
|
java.lang.String | findContractStoreXML(java.lang.Long argContractId, boolean flush)
Deprecated.
This method is replaced by ContractStoreAccessBean#getStoreXML()
|
java.util.Vector | findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId)
Finds all the exclusion product sets.
|
java.util.Vector | findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush)
Finds all the exclusion product sets.
|
java.util.Vector | findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId)
Finds all the inclusion product sets.
|
java.util.Vector | findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush)
Finds all the inclusion product sets.
|
java.lang.String | findParticipntInformation(java.lang.Long aParticipntId)
Deprecated.
This method is replaced by ParticipantAccessBean#getInformation()
|
java.lang.String | findParticipntInformation(java.lang.Long aParticipntId, boolean flush)
Deprecated.
This method is replaced by ParticipantAccessBean#getInformation()
|
PAttrValueAccessBean[] | findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId)
Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
|
PAttrValueAccessBean[] | findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId, boolean flush)
Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
|
java.lang.String | findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId)
Deprecated.
This method is replaced by PolicyDescriptionAccessBean#getLongDescription()
|
java.lang.String | findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, boolean flush)
Deprecated.
This method is replaced by PolicyDescriptionAccessBean#getLongDescription()
|
java.util.Vector | findProductSetAdjustments(java.lang.Long termcondId)
Finds all the product set adjustments matching the specified term condition ID.
|
java.util.Vector | findProductSetAdjustments(java.lang.Long termcondId, boolean flush)
Finds all the product set adjustments matching the specified term condition ID.
|
java.lang.Integer[] | findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type)
Finds all the product sets in the product set adjustment table matching the specified term condition ID and type.
|
java.lang.Integer[] | findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type, boolean flush)
Finds all the product sets in the product set adjustment table matching the specified term condition ID and type.
|
java.lang.Long[] | findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId, java.lang.Integer origin, java.lang.Long contractId)
Finds all the contracts with the same name, owner, origin, and contract ID.
|
java.lang.Long[] | findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId, java.lang.Integer origin, java.lang.Long contractId, boolean flush)
Finds all the contracts with the same name, owner, origin, and contract ID.
|
java.lang.Integer[] | findStoreIdsInStoreContractByContractId(java.lang.Long contractId)
Finds all the stores in the store contract table matching the specified contract ID.
|
java.lang.Integer[] | findStoreIdsInStoreContractByContractId(java.lang.Long contractId, boolean flush)
Finds all the stores in the store contract table matching the specified contract ID.
|
java.lang.String | findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId)
Deprecated.
This method is replaced by TermConditionDescriptionAccessBean#getLongDescription()
|
java.lang.String | findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush)
Deprecated.
This method is replaced by TermConditionDescriptionAccessBean#getLongDescription()
|
java.util.Vector | findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type)
Finds all the terms and conditions in the TCATTR table matching the specified trading agreement ID and type.
|
java.util.Vector | findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type, boolean flush)
Finds all the terms and conditions in the TCATTR table matching the specified trading agreement ID and type.
|
java.lang.String | findTermCondStringField1(java.lang.Long aTermCondId)
Deprecated.
This method is replaced by directly mapping STRINGFIELD1 in the term and condition EJB.
|
java.lang.String | findTermCondStringField1(java.lang.Long aTermCondId, boolean flush)
Deprecated.
This method is replaced by directly mapping STRINGFIELD1 in the term and condition EJB.
|
java.lang.String | findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId)
Deprecated.
This method is replaced by TradingDescriptionAccessBean#getLongDescription()
|
java.lang.String | findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush)
Deprecated.
This method is replaced by TradingDescriptionAccessBean#getLongDescription()
|
java.lang.String | findXMLDefByTPC(java.lang.Long argTPCId)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#findByTradingPositionContainer(Long)
|
java.lang.String | findXMLDefByTPC(java.lang.Long argTPCId, boolean flush)
Deprecated.
This method is replaced by TradingPositionContainerXMLDefinitionAccessBean#findByTradingPositionContainer(Long)
|
int | getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type)
Finds the largest sequence in the TCATTR table matching the specified term condition ID and type.
|
int | getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type, boolean flush)
Finds the largest sequence in the TCATTR table matching the specified term condition ID and type.
|
int | getLargestTCSequenceByTrading(java.lang.Long argTradingId)
Retrieves the largest terms and conditions sequence number with the specified trading ID
|
int | getLargestTCSequenceByTrading(java.lang.Long argTradingId, boolean flush)
Retrieves the largest terms and conditions sequence number with the specified trading ID
|
javax.ejb.SessionContext | getSessionContext()
Returns this session's context.
|
java.lang.String | getTCAccessBeanNameBySubType(java.lang.String argTCSubType)
Retrieves the name of the terms and conditions access bean by the specified subtype
|
java.lang.String | getTCAccessBeanNameBySubType(java.lang.String argTCSubType, boolean flush)
Retrieves the name of the terms and conditions access bean by the specified subtype
|
java.lang.String | getTCAccessBeanNameByTC(java.lang.Long argTCId)
Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
|
java.lang.String | getTCAccessBeanNameByTC(java.lang.Long argTCId, boolean flush)
Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
|
java.lang.String | getTCDeployCmdBySubType(java.lang.String argTCSubType)
Retrieves the deploy command associated with the terms and conditions subtype
|
java.lang.String | getTCDeployCmdBySubType(java.lang.String argTCSubType, boolean flush)
Retrieves the deploy command associated with the terms and conditions subtype
|
java.lang.String | getTCDeployCmdByTC(java.lang.Long argTCId)
Retrieves the deploy command associated with the terms and conditions ID
|
java.lang.String | getTCDeployCmdByTC(java.lang.Long argTCId, boolean flush)
Retrieves the deploy command associated with the terms and conditions ID
|
java.lang.String | queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin)
Retrieves the name of the contract associated with the specified member ID and origin
|
java.lang.String | queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush)
Retrieves the name of the contract associated with the specified member ID and origin
|
boolean | queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId)
Deprecated.
This method is replaced by StoreContractAccessBean#findByContract(Long)
|
boolean | queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId, boolean flush)
Deprecated.
This method is replaced by StoreContractAccessBean#findByContract(Long)
|
void | setSessionContext(javax.ejb.SessionContext ctx)
Sets this session's context.
|
int | updateContractComments(java.lang.Long aContractId, java.lang.String aComments)
Deprecated.
This method is replaced by ContractAccessBean#setComments(String)
|
int | updateContractComments(java.lang.Long aContractId, java.lang.String aComments, boolean flush)
Deprecated.
This method is replaced by ContractAccessBean#setComments(String)
|
int | updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML)
Deprecated.
This method is replaced by ContractStoreAccessBean#setStoreXML(String)
|
int | updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML, boolean flush)
Deprecated.
This method is replaced by ContractStoreAccessBean#setStoreXML(String)
|
int | updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aStringField1)
Deprecated.
This method is replaced by ParticipantAccessBean#setInformation(String)
|
int | updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aParticipntInfo, boolean flush)
Deprecated.
This method is replaced by ParticipantAccessBean#setInformation(String)
|
int | updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription)
Deprecated.
This method is replaced by PolicyDescriptionAccessBean#setLongDescription(String)
|
int | updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush)
Deprecated.
This method is replaced by PolicyDescriptionAccessBean#setLongDescription(String)
|
int | updateProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type)
Updates a product set adjustment row in the PSETADJMNT table.
|
int | updateProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type, boolean flush)
Updates a product set adjustment row in the PSETADJMNT table.
|
int | updateTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#setXMLDefinition(String)
|
int | updateTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence, boolean flush)
Deprecated.
This method is replaced by TermConditionAttributeAccessBean#setXMLDefinition(String)
|
int | updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription)
Deprecated.
This method is replaced by TermConditionDescriptionAccessBean#setLongDescription(String)
|
int | updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush)
Deprecated.
This method is replaced by TermConditionDescriptionAccessBean#setLongDescription(String)
|
int | updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1)
Deprecated.
This method is replaced by directly mapping STRINGFIELD1 in the term and condition EJB.
|
int | updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1, boolean flush)
Deprecated.
This method is replaced by directly mapping STRINGFIELD1 in the term and condition EJB.
|
int | updateTRDDescLongDesc(java.lang.Long aTradingId, java.lang.Integer aLangId, java.lang.String aDescription)
Deprecated.
This method is replaced by TradingDescriptionAccessBean#setLongDescription(String)
|
int | updateTRDDescLongDesc(java.lang.Long aTradingId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush)
Deprecated.
This method is replaced by TradingDescriptionAccessBean#setLongDescription(String)
|
public static final java.lang.String COPYRIGHT
protected javax.ejb.SessionContext mySessionCtx
public static final java.lang.String queryContractNameSQL
public static final java.lang.String addTPCXMLDefSQL
public static final java.lang.String findXMLDefByTPCSQL
public static final java.lang.String deleteXMLDefByTPCSQL
public static final java.lang.String findTPCXMLDefForUpdateSQL
public static final java.lang.String updateTPCXMLDefSQL
public static final java.lang.String emptyTPCXMLDefSQL
public static final java.lang.String findContractStoreXMLSQL
public static final java.lang.String updateContractStoreXMLSQL
public static final java.lang.String emptyContractStoreXMLSQL
public static final java.lang.String findContractStoreXMLForUpdateSQL
public static final java.lang.String findActiveContractsDeployedInStoreSQL
public static final java.lang.String findActiveContractsDeployedInStoreSQLForPreview
public static final java.lang.String addTCAttributeXMLSQL
public static final java.lang.String deleteTCAttributeXMLSQL
public static final java.lang.String findAllTCAttributeXMLSQL
public static final java.lang.String updateTCAttributeXMLSQL
public static final java.lang.String emptyTCAttributeXMLSQL
public static final java.lang.String findTCAttributeXMLForUpdateSQL
public static final java.lang.String findTCIdInTCAttributeByTradingIdAndTypeSQL
public static final java.lang.String findTCIdInTCAttributeByTradingIdTCIdAndTypeSQL
public static final java.lang.String findInclusionProductSetIdsByTCIdAndTypeSQL
public static final java.lang.String findExclusionProductSetIdsByTCIdAndTypeSQL
public static final java.lang.String findStoreIdsInStoreContractByContractIdSQL
public static final java.lang.String addProductSetAdjustmentSQL
public static final java.lang.String updateProductSetAdjustmentSQL
public static final java.lang.String deleteProductSetAdjustmentSQL
public static final java.lang.String findProductSetIdsByTCIdAndTypeSQL
public static final java.lang.String findLargestSequenceInTCAttributeSQL
public static final java.lang.String findSequenceInTCAttributeSQL
public static final java.lang.String findSameFamilyContractsSQL
public static final java.lang.String findProductSetAdjustmentsSQL
public static final java.lang.String findAccountIdByUserIdStoreIdSQL
public static final java.lang.String findAccountIdByUserIdStoreIdByOrganizationSQL
public static final java.lang.String findContractCommentsSQL
public static final java.lang.String findParticipntInformationSQL
public static final java.lang.String findPolicyDescriptionSQL
public static final java.lang.String findTCDescLongDescSQL
public static final java.lang.String findTRDDescLongDescSQL
public static final java.lang.String findTermCondStringField1SQL
public static final java.lang.String updateContractCommentsSQL
public static final java.lang.String updateParticipntInfoSQL
public static final java.lang.String updatePolicyDescriptionSQL
public static final java.lang.String updateTCDescLongDescSQL
public static final java.lang.String updateTRDDescLongDescSQL
public static final java.lang.String updateTermCondStringField1SQL
public int addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the contract name table.
The SQL statement used to add a row to the CNTRNAME table is:
insert into cntrname (name, member_id, origin) values(?, ?, ?)
public int addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the contract name table.
The SQL statement used to add a row to the CNTRNAME table is:
insert into cntrname (name, member_id, origin) values(?, ?, ?)
public int addPolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the policy terms and conditions table.
The SQL statement used to add a row to the POLICYTC table is:
insert into policytc (policy_id, termcond_id) values(?, ?)
public int addStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the store contract table.
The SQL statement used to add a row to the STORECNTR table is:
insert into storecntr (store_id, contract_id) values(?, ?)
public int addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the trading position container XML table.
The SQL statement used to add a row to the TRDPSCNXML table is:
insert into trdpscnxml (tradeposcn_id, sequence, xmldefinition) values(?, ?, ?)
public int addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Adds an entry to the trading position container XML table.
The SQL statement used to add a row to the TRDPSCNXML table is:
insert into trdpscnxml (tradeposcn_id, sequence, xmldefinition) values(?, ?, ?)
public int deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, java.sql.SQLException
Deletes an entry from the contract name table.
The SQL statement used to delete a row from the CNTRNAME table is:
delete from cntrname where name = ? and member_id = ? and origin = ?
public int deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Deletes an entry from the contract name table.
The SQL statement used to delete a row from the CNTRNAME table is:
delete from cntrname where name = ? and member_id = ? and origin = ?
public int deletePolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Deletes an entry from the policy terms and conditions table.
The SQL statement used to delete a row from the POLICYTC table is:
delete from policytc where policy_id = ? and termcond_id= ?
public int deletePolicyTCByTC(java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Deletes entries from the policy terms and conditions table
The SQL statement used to delete rows from the POLICYTC table is:
delete from policytc where termcond_id= ?
public int deleteStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, java.sql.SQLException
Deletes an entry from the store contract table
The SQL statement used to delete a row from the STORECNTR table is:
delete from storecntr where store_id = ? and contract_id = ?
public int deleteXMLDefByTPC(java.lang.Long argTPCId) throws javax.naming.NamingException, java.sql.SQLException
Deletes an entry from the trading position container XML table
The SQL statement used to delete a row from the TRDPSCNXML table is:
delete from trdpscnxml where tradeposcn_id = ?
public int deleteXMLDefByTPC(java.lang.Long argTPCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Deletes entries from the trading position container XML table
The SQL statement used to delete rows from the TRDPSCNXML table is:
delete from trdpscnxml where tradeposcn_id = ?
public void ejbActivate()
public void ejbPassivate()
public void ejbRemove()
public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the names of all the business command classes associated with the specified policy
The SQL query used to fetch all the required rows from the POLICYCMD table is:
select policycmd.businesscmdclass from policycmd where policycmd.policy_id = ?
public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the names of all the business command classes associated with the specified policy
The SQL query used to fetch all the required rows from the POLICYCMD table is:
select policycmd.businesscmdclass from policycmd where policycmd.policy_id = ?
public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the names of all the business command interfaces associated with the specified policy
The SQL query used to fetch all the required rows from the PLCYTYCMIF table is:
select plcytycmif.businesscmdif from plcytycmif where plcytycmif.policytype_id = ?
public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the names of all the business command interfaces associated with the specified policy
The SQL query used to fetch all the required rows from the PLCYTYCMIF table is:
select plcytycmif.businesscmdif from plcytycmif where plcytycmif.policytype_id = ?
public java.util.Vector findAllBusinessPolicyType() throws javax.naming.NamingException, java.sql.SQLException
Retrieves all the policy types from the POLICYTYPE table.
The SQL query used to fetch all the required rows from the POLICYTYPE table is:
SELECT POLICYTYPE_ID FROM POLICYTYPE
public java.util.Vector findAllBusinessPolicyType(boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all the policy types from the POLICYTYPE table.
The SQL query used to fetch all the required rows from the POLICYTYPE table is:
SELECT POLICYTYPE_ID FROM POLICYTYPE
public java.util.Vector findAllTCSubType() throws javax.naming.NamingException, java.sql.SQLException
Retrieves all the term condition subtypes from the TCSUBTYPE table.
The SQL query used to fetch all the required rows from the TCSUBTYPE table is:
SELECT TCSUBTYPE_ID FROM TCSUBTYPE
public java.util.Vector findAllTCSubType(boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all the term condition subtypes from the TCSUBTYPE table.
The SQL query used to fetch all the required rows from the TCSUBTYPE table is:
SELECT TCSUBTYPE_ID FROM TCSUBTYPE
public java.util.Vector findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID
The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:
select distinct contract.contract_id, contract,name from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by argOrderByColumn
public java.util.Vector findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID
The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:
select distinct contract.contract_id, contract,name from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by argOrderByColumn
public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID and state
The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:
select distinct contract.contract_id, contract.name from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.state = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by argOrderByColumn
public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID and state
The SQL query used to fetch all the required rows from the CONTRACT table, the TRADING table, and the TRDDESC table is:
select distinct contract.contract_id, contract.name from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.state = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by argOrderByColumn
public PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
The SQL query used to fetch all the required rows from the PATTRVALUE table is:
select pattrvalue_id, pattribute_id from pattrvalue where termcond_id = ? order by pattribute_id
public PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID
The SQL query used to fetch all the required rows from the PATTRVALUE table is:
select pattrvalue_id, pattribute_id from pattrvalue where termcond_id = ? order by pattribute_id
public java.lang.String findXMLDefByTPC(java.lang.Long argTPCId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the XML definition of the trading position container
The SQL statement used to query the TRDPSCNXML table is:
select xmldefinition, sequence from trdpscnxml where tradeposcn_id = ? order by sequence
public java.lang.String findXMLDefByTPC(java.lang.Long argTPCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the XML definition of the trading position container
The SQL statement used to query the TRDPSCNXML table is:
select xmldefinition, sequence from trdpscnxml where tradeposcn_id = ? order by sequence
public int getLargestTCSequenceByTrading(java.lang.Long argTradingId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the largest terms and conditions sequence number with the specified trading ID
The SQL statement used to fetch the result from the TERMCOND table is:
select max(sequence) from termcond where trading_id = ?
public int getLargestTCSequenceByTrading(java.lang.Long argTradingId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the largest terms and conditions sequence number with the specified trading ID
The SQL statement used to fetch the result from the TERMCOND table is:
select max(sequence) from termcond where trading_id = ?
public javax.ejb.SessionContext getSessionContext()
public java.lang.String getTCAccessBeanNameBySubType(java.lang.String argTCSubType) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the terms and conditions access bean by the specified subtype
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.accessbeanname from tcsubtype t1 where (t1.tcsubtype_id = ?)
public java.lang.String getTCAccessBeanNameBySubType(java.lang.String argTCSubType, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the terms and conditions access bean by the specified subtype
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.accessbeanname from tcsubtype t1 where (t1.tcsubtype_id = ?)
public java.lang.String getTCAccessBeanNameByTC(java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.accessbeanname from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?
public java.lang.String getTCAccessBeanNameByTC(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the terms and conditions access bean by the specified terms and conditions ID
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.accessbeanname from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?
public java.lang.String getTCDeployCmdBySubType(java.lang.String argTCSubType) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the deploy command associated with the terms and conditions subtype
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.deploycommand from tcsubtype t1 where (t1.tcsubtype_id = ?)
public java.lang.String getTCDeployCmdBySubType(java.lang.String argTCSubType, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the deploy command associated with the terms and conditions subtype
The SQL statement used to query the TCSUBTYPE table is:
select distinct t1.deploycommand from tcsubtype t1 where (t1.tcsubtype_id = ?)
public java.lang.String getTCDeployCmdByTC(java.lang.Long argTCId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the deploy command associated with the terms and conditions ID
The SQL statement used to query the TCSUBTYPE table and the TERMCOND table is:
select distinct t1.deploycommand from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?
public java.lang.String getTCDeployCmdByTC(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the deploy command associated with the terms and conditions ID
The SQL statement used to query the TCSUBTYPE table and the TERMCOND table is:
select distinct t1.deploycommand from tcsubtype t1, termcond t2 where t1.tcsubtype_id = t2.tcsubtype_id and t2.termcond_id = ?
public java.lang.String queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the contract associated with the specified member ID and origin
The SQL statement used to query the CNTRNAME table is:
select name from cntrname where name = ? and member_id = ? and origin = ? //91983 for update
public java.lang.String queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the name of the contract associated with the specified member ID and origin
The SQL statement used to query the CNTRNAME table is:
select name from cntrname where name = ? and member_id = ? and origin = ? //91983 for update
public boolean queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, java.sql.SQLException
Queries whether a particular contract exists for a specified store
The SQL query used to fetch all the required rows from the STORECNTR table is:
select * from storecntr where store_id = ? and contract_id = ?
public boolean queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Queries whether a particular contract exists for a specified store
The SQL query used to fetch all the required rows from the STORECNTR table is:
select * from storecntr where store_id = ? and contract_id = ?
public void setSessionContext(javax.ejb.SessionContext ctx)
public java.lang.String findContractStoreXML(java.lang.Long argContractId) throws javax.naming.NamingException, java.sql.SQLException
Finds the XML in the Contract Store table associated with the specified contract ID.
The SQL statement used to fetch the XML from the STORECNTR table is:
SELECT STOREXML FROM CNTRSTORE WHERE CONTRACT_ID = ?
public java.lang.String findContractStoreXML(java.lang.Long argContractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds the XML in the Contract Store table associated with the specified contract ID.
The SQL statement used to fetch the XML from the STORECNTR table is:
SELECT STOREXML FROM CNTRSTORE WHERE CONTRACT_ID = ?
public int updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML) throws javax.naming.NamingException, java.sql.SQLException
Updates the XML in the Contract Store table associated with the specified contract ID.
The SQL statement used to update the XML in the STORECNTR table is:
UPDATE CNTRSTORE SET STOREXML = ? WHERE CONTRACT_ID = ?
public int updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the XML in the Contract Store table associated with the specified contract ID.
The SQL statement used to update the XML in the STORECNTR table is:
UPDATE CNTRSTORE SET STOREXML = ? WHERE CONTRACT_ID = ?
public int addContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML) throws javax.naming.NamingException, java.sql.SQLException
Inserts the XML in the Contract Store table associated with the specified contract ID.
The SQL statement used to insert the XML in the STORECNTR table is:
INSERT INTO CNTRSTORE (CONTRACT_ID, STOREXML) VALUES(?, ?)
public int deleteContractStoreXML(java.lang.Long contractId) throws javax.naming.NamingException, java.sql.SQLException
Deletes a row from the Contract Store table associated with the specified contract ID.
The SQL statement used to delete a row from the STORECNTR table is:
DELETE FROM CNTRSTORE WHERE CONTRACT_ID = ?
public int deleteContractStoreXML(java.lang.Long contractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Deletes a row from the Contract Store table associated with the specified contract ID.
The SQL statement used to delete a row from the STORECNTR table is:
DELETE FROM CNTRSTORE WHERE CONTRACT_ID = ?
public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the contracts in active state that are deployed in the specified store.
The SQL statement used to query the TRADING and STORECNTR tables is:
SELECT T1.TRADING_ID FROM TRADING T1, STORECNTR T2 WHERE T1.STATE = 1 AND T1.MARKFORDELETE = 0 AND T1.TRADING_ID = T2.CONTRACT_ID AND T2.STORE_ID = ? AND (T1.STARTTIME < %CURRENTTIME% OR T1.STARTTIME IS NULL ) AND (T1.ENDTIME > %CURRENTTIME% OR T1.ENDTIME IS NULL)
public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the contracts in active state that are deployed in the specified store.
The SQL statement used to query the TRADING and STORECNTR tables is:
SELECT T1.TRADING_ID FROM TRADING T1, STORECNTR T2 WHERE T1.STATE = 1 AND T1.MARKFORDELETE = 0 AND T1.TRADING_ID = T2.CONTRACT_ID AND T2.STORE_ID = ? AND (T1.STARTTIME < %CURRENTTIME% OR T1.STARTTIME IS NULL ) AND (T1.ENDTIME > %CURRENTTIME% OR T1.ENDTIME IS NULL)
public int addTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence) throws javax.naming.NamingException, java.sql.SQLException
Inserts the XML definition into the TCATTR table.
The SQL statement used to insert into the TCATTR table is:
INSERT INTO TCATTR (TERMCOND_ID, TRADING_ID, TYPE, XMLDEFINITION, SEQUENCE) VALUES(?, ?, ?, ?, ?)
public int deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence) throws javax.naming.NamingException, java.sql.SQLException
Deletes a row from the TCATTR table.
The SQL statement used to delete the row from the TCATTR table is:
DELETE FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ? AND SEQUENCE = ?
public int deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Deletes a row from the TCATTR table.
The SQL statement used to delete the row from the TCATTR table is:
DELETE FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ? AND SEQUENCE = ?
public java.util.Vector findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType) throws javax.naming.NamingException, java.sql.SQLException
Finds all the term condition attribute XML matching the specified term condition ID and type.
The SQL statement used to query the TCATTR table is:
SELECT XMLDEFINITION FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
public java.util.Vector findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the term condition attribute XML matching the specified term condition ID and type.
The SQL statement used to query the TCATTR table is:
SELECT XMLDEFINITION FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
public int updateTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence) throws javax.naming.NamingException, java.sql.SQLException
Updates the term condition attribute XML in the TCATTR table.
The SQL statement used to update the TCATTR table is:
UPDATE TCATTR SET XMLDEFINITION = ? WHERE TERMCOND_ID = ? AND TYPE = ? AND SEQUENCE = ?
public int updateTCAttributeXML(java.lang.Long argTermCondId, java.lang.Long argTradingId, java.lang.Integer argType, java.lang.String argXMLDefinition, java.lang.Integer argSequence, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the term condition attribute XML in the TCATTR table.
The SQL statement used to update the TCATTR table is:
UPDATE TCATTR SET XMLDEFINITION = ? WHERE TERMCOND_ID = ? AND TYPE = ? AND SEQUENCE = ?
public java.util.Vector findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type) throws javax.naming.NamingException, java.sql.SQLException
Finds all the terms and conditions in the TCATTR table matching the specified trading agreement ID and type.
The SQL statement used to query the TCATTR table is:
SELECT DISTINCT TERMCOND_ID FROM TCATTR WHERE TRADING_ID = ? AND TYPE = ?
public java.util.Vector findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the terms and conditions in the TCATTR table matching the specified trading agreement ID and type.
The SQL statement used to query the TCATTR table is:
SELECT DISTINCT TERMCOND_ID FROM TCATTR WHERE TRADING_ID = ? AND TYPE = ?
public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) throws javax.naming.NamingException, java.sql.SQLException
Finds all the inclusion product sets.
The SQL statement used to query the product set adjustment table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE IN (0, 2)
public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the inclusion product sets.
The SQL statement used to query the product set adjustment table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE IN (0, 2)
public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) throws javax.naming.NamingException, java.sql.SQLException
Finds all the exclusion product sets.
The SQL statement used to query the product set adjustment table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE IN (1, 3)
public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the exclusion product sets.
The SQL statement used to query the product set adjustment table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE IN (1, 3)
public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId) throws javax.naming.NamingException, java.sql.SQLException
Finds all the stores in the store contract table matching the specified contract ID.
The SQL statement used to query the STORECNTR table is:
SELECT STORE_ID FROM STORECNTR WHERE CONTRACT_ID = ?
public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the stores in the store contract table matching the specified contract ID.
The SQL statement used to query the STORECNTR table is:
SELECT STORE_ID FROM STORECNTR WHERE CONTRACT_ID = ?
public int addProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type) throws javax.naming.NamingException, java.sql.SQLException
Inserts a product set adjustment row into the PSETADJMNT table.
The SQL used to insert the row is:
INSERT INTO PSETADJMNT (TERMCOND_ID, PRODUCTSET_ID, ADJUSTMENT, PRECEDENCE, TYPE) VALUES (?, ?, ?, ?, ?)
public int addProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Inserts a product set adjustment row into the PSETADJMNT table.
The SQL used to insert the row is:
INSERT INTO PSETADJMNT (TERMCOND_ID, PRODUCTSET_ID, ADJUSTMENT, PRECEDENCE, TYPE) VALUES (?, ?, ?, ?, ?)
public int updateProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type) throws javax.naming.NamingException, java.sql.SQLException
Updates a product set adjustment row in the PSETADJMNT table.
The SQL used to update the PSETADJMNT table is:
UPDATE PSETADJMNT SET ADJUSTMENT = ?, PRECEDENCE = ?, TYPE = ? WHERE TERMCOND_ID = ? AND PRODUCTSET_ID = ?
public int updateProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, java.lang.Double adjustment, java.lang.Integer precedence, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates a product set adjustment row in the PSETADJMNT table.
The SQL used to update the PSETADJMNT table is:
UPDATE PSETADJMNT SET ADJUSTMENT = ?, PRECEDENCE = ?, TYPE = ? WHERE TERMCOND_ID = ? AND PRODUCTSET_ID = ?
public int deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId) throws javax.naming.NamingException, java.sql.SQLException
Deletes a product set adjustment row from the PSETADJMNT table.
The SQL used to delete the row from the PSETADJMNT table is:
DELETE FROM PSETADJMNT WHERE TERMCOND_ID = ? AND PRODUCTSET_ID = ?
public int deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Deletes a product set adjustment row from the PSETADJMNT table.
The SQL used to delete the row from the PSETADJMNT table is:
DELETE FROM PSETADJMNT WHERE TERMCOND_ID = ? AND PRODUCTSET_ID = ?
public java.lang.Integer[] findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type) throws javax.naming.NamingException, java.sql.SQLException
Finds all the product sets in the product set adjustment table matching the specified term condition ID and type.
The SQL statement used to query the PSETADJMNT table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE = ?
public java.lang.Integer[] findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the product sets in the product set adjustment table matching the specified term condition ID and type.
The SQL statement used to query the PSETADJMNT table is:
SELECT PRODUCTSET_ID FROM PSETADJMNT WHERE TERMCOND_ID = ? AND TYPE = ?
public int getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type) throws javax.naming.NamingException, java.sql.SQLException
Finds the largest sequence in the TCATTR table matching the specified term condition ID and type.
The SQL statements used to query the TCATTR table are:
SELECT SEQUENCE FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
SELECT MAX(SEQUENCE) FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
public int getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds the largest sequence in the TCATTR table matching the specified term condition ID and type.
The SQL statements used to query the TCATTR table are:
SELECT SEQUENCE FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
SELECT MAX(SEQUENCE) FROM TCATTR WHERE TERMCOND_ID = ? AND TYPE = ?
public java.lang.Long[] findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId, java.lang.Integer origin, java.lang.Long contractId) throws javax.naming.NamingException, java.sql.SQLException
Finds all the contracts with the same name, owner, origin, and contract ID.
The SQL statement used to query the CONTRACT table is:
SELECT CONTRACT_ID FROM CONTRACT WHERE NAME = ? AND MEMBER_ID = ? AND ORIGIN = ? AND MARKFORDELETE = 0 AND CONTRACT_ID %lt; > ?
public java.lang.Long[] findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId, java.lang.Integer origin, java.lang.Long contractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the contracts with the same name, owner, origin, and contract ID.
The SQL statement used to query the CONTRACT table is:
SELECT CONTRACT_ID FROM CONTRACT WHERE NAME = ? AND MEMBER_ID = ? AND ORIGIN = ? AND MARKFORDELETE = 0 AND CONTRACT_ID %lt; > ?
public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId) throws javax.naming.NamingException, java.sql.SQLException
Finds all the product set adjustments matching the specified term condition ID.
The SQL statement used to query the PSETADJMNT table is:
SELECT TERMCOND_ID, PRODUCTSET_ID, TYPE, ADJUSTMENT, PRECEDENCE FROM PSETADJMNT WHERE TERMCOND_ID = ? ORDER BY TERMCOND_ID, PRECEDENCE DESC, ADJUSTMENT, PRODUCTSET_ID
public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Finds all the product set adjustments matching the specified term condition ID.
The SQL statement used to query the PSETADJMNT table is:
SELECT TERMCOND_ID, PRODUCTSET_ID, TYPE, ADJUSTMENT, PRECEDENCE FROM PSETADJMNT WHERE TERMCOND_ID = ? ORDER BY TERMCOND_ID, PRECEDENCE DESC, ADJUSTMENT, PRODUCTSET_ID
public java.lang.Long findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the account ID associated with the specified user member ID & store ID
The SQL statement used to query the MBRREL, PARTICIPNT , and TRADING tables is:
SELECT DISTINCT T1.ACCOUNT_ID FROM ACCOUNT T1, PARTICIPNT T2, MBRREL T3 WHERE T2.MEMBER_ID=T3.ANCESTOR_ID AND T2.PARTROLE_ID=5 AND T1.ACCOUNT_ID=T2.TRADING_ID AND T1.MARKFORDELETE=0 AND T3.DESCENDANT_ID=? AND (T1.STORE_ID IS NULL OR T1.STORE_ID=?)
public java.lang.Long findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the account ID associated with the specified user member ID & store ID
The SQL statement used to query the MBRREL, PARTICIPNT , and TRADING tables is:
SELECT DISTINCT T1.ACCOUNT_ID FROM ACCOUNT T1, PARTICIPNT T2, MBRREL T3 WHERE T2.MEMBER_ID=T3.ANCESTOR_ID AND T2.PARTROLE_ID=5 AND T1.ACCOUNT_ID=T2.TRADING_ID AND T1.MARKFORDELETE=0 AND T3.DESCENDANT_ID=? AND (T1.STORE_ID IS NULL OR T1.STORE_ID=?)
public java.lang.Long findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, java.lang.Long aOrganizationId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the account ID associated with the specified user member ID & store ID
The SQL statement used to query the MBRREL, PARTICIPNT , and TRADING tables is:
SELECT DISTINCT T1.ACCOUNT_ID FROM ACCOUNT T1, PARTICIPNT T2 WHERE T2.MEMBER_ID=? AND T2.PARTROLE_ID=5 AND T1.ACCOUNT_ID=T2.TRADING_ID AND T1.MARKFORDELETE=0 AND (T1.STORE_ID IS NULL OR T1.STORE_ID=?)
public java.lang.Long findAccountIdByUserIdStoreId(java.lang.Long aUserId, java.lang.Integer aStoreId, java.lang.Long aOrganizationId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the account ID associated with the specified user member ID & store ID
The SQL statement used to query the MBRREL, PARTICIPNT , and TRADING tables is:
SELECT DISTINCT T1.ACCOUNT_ID FROM ACCOUNT T1, PARTICIPNT T2 WHERE T2.MEMBER_ID=? AND T2.PARTROLE_ID=5 AND T1.ACCOUNT_ID=T2.TRADING_ID AND T1.MARKFORDELETE=0 AND (T1.STORE_ID IS NULL OR T1.STORE_ID=?)
public java.lang.String findContractComments(java.lang.Long aContractId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the comments associated with the specified contract
The SQL statement used to query the CONTRACT table is:
select contract.origin, contract.comments, contract.state from contract where contract.contract_id = ?
public java.lang.String findContractComments(java.lang.Long aContractId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the comments associated with the specified contract
The SQL statement used to query the CONTRACT table is:
select contract.origin, contract.comments, contract.state from contract where contract.contract_id = ?
public java.lang.String findParticipntInformation(java.lang.Long aParticipntId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the information associated with the specified participant
The SQL statement used to query the PARTICIPNT table is:
slect participnt.member_id, participnt.information, participnt.termcond_id from participnt where participnt.participnt_id = ?
public java.lang.String findParticipntInformation(java.lang.Long aParticipntId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the information associated with the specified participant
The SQL statement used to query the PARTICIPNT table is:
select participnt.member_id, participnt.information, participnt.termcond_id from participnt where participnt.participnt_id = ?
public java.lang.String findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the description associated with the specified policy
The SQL statement used to query the POLICYDESC table is:
select policydesc.policy_id, policydesc.longdescription, policydesc.language_id from policydesc where policydesc.policy_id = ? and policydesc.language_id = ?
public java.lang.String findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the description associated with the specified policy
The SQL statement used to query the POLICYDESC table is:
select policydesc.policy_id, policydesc.longdescription, policydesc.language_id from policydesc where policydesc.policy_id = ? and policydesc.language_id = ?
public java.lang.String findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the long description of the specified terms and conditions
The SQL statement used to query the TCDESC table is:
select tcdesc.termcond_id, tcdesc.longdescription, tcdesc.language_id from tcdesc where tcdesc.termcond_id = ? and tcdesc.language_id = ?
public java.lang.String findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the long description of the specified terms and conditions
The SQL statement used to query the TCDESC table is:
select tcdesc.termcond_id, tcdesc.longdescription, tcdesc.language_id from tcdesc where tcdesc.termcond_id = ? and tcdesc.language_id = ?
public java.lang.String findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the long description of the specified trading agreement
The SQL statement used to query the TRDDESC table is:
select trddesc.trading_id, trddesc.longdescription, trddesc.language_id from trddesc where trddesc.trading_id = ? and trddesc.language_id = ?
public java.lang.String findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the long description of the specified trading agreement
The SQL statement used to query the TRDDESC table is:
select trddesc.trading_id, trddesc.longdescription, trddesc.language_id from trddesc where trddesc.trading_id = ? and trddesc.language_id = ?
public java.lang.String findTermCondStringField1(java.lang.Long aTermCondId) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the string field of the terms and conditions table
The SQL statement used to query the TERMCOND table is:
select termcond.integerfield1, termcond.stringfield1, termcond.integerfield2 from termcond where termcond.termcond_id = ?
public java.lang.String findTermCondStringField1(java.lang.Long aTermCondId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Retrieves the string field of the terms and conditions table
The SQL statement used to query the TERMCOND table is:
select termcond.integerfield1, termcond.stringfield1, termcond.integerfield2 from termcond where termcond.termcond_id = ?
public int updateContractComments(java.lang.Long aContractId, java.lang.String aComments) throws javax.naming.NamingException, java.sql.SQLException
Updates the comments field in the contract table
The SQL statement used to update the CONTRACT table is:
update contract set comments = ? where contract.contract_id = ?
public int updateContractComments(java.lang.Long aContractId, java.lang.String aComments, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the comments field in the contract table
The SQL statement used to update the CONTRACT table is:
update contract set comments = ? where contract.contract_id = ?
public int updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aStringField1) throws javax.naming.NamingException, java.sql.SQLException
Updates the information field in the participnt table
The SQL statement used to update the PARTICIPNT table is:
update participnt set information = ? where participnt.participnt_id = ?
public int updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aParticipntInfo, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the information field in the participnt table
The SQL statement used to update the PARTICIPNT table is:
update participnt set information = ? where participnt.participnt_id = ?
public int updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the policy description table
The SQL statement used to update the POLICYDESC table is:
update policydesc set longdescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?
public int updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the policy description table
The SQL statement used to update the POLICYDESC table is:
update policydesc set longdescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?
public int updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the terms and conditions description table
The SQL statement used to update the TCDESC table is:
update tcdesc set tcdesc.longdescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?
public int updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the terms and conditions description table
The SQL statement used to update the TCDESC table is:
update tcdesc set tcdesc.longdescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?
public int updateTRDDescLongDesc(java.lang.Long aTradingId, java.lang.Integer aLangId, java.lang.String aDescription) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the trading description table
The SQL statement used to update the TRDDESC table is:
update trddesc set trddesc.longdescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?
public int updateTRDDescLongDesc(java.lang.Long aTradingId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the long description field in the trading description table
The SQL statement used to update the TRDDESC table is:
update trddesc set trddesc.longdescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?
public int updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1) throws javax.naming.NamingException, java.sql.SQLException
Updates the string field in the terms and conditions table
The SQL statement used to update the TERMCOND table is:
update termcond set termcond.stringfield1 = ? where termcond.termcond_id = ?
public int updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
Updates the string field in the terms and conditions table
The SQL statement used to update the TERMCOND table is:
update termcond set termcond.stringfield1 = ? where termcond.termcond_id = ?