java.lang.Object | +--AbstractSessionAccessBean | +--com.ibm.commerce.contract.objects.ContractJDBCHelperAccessBean
From JavaDoc Build Script : Cannot find description for this AccessBean ContractJDBCHelperAccessBean
Constructor Summary | |
---|---|
ContractJDBCHelperAccessBean() ContractJDBCHelperAccessBean | |
ContractJDBCHelperAccessBean(javax.ejb.EJBObject o) ContractJDBCHelperAccessBean |
Method Summary | |
---|---|
int |
addEntryToContractName(java.lang.String argName,
java.lang.Long argMemberId, java.lang.Integer argOrigin) Adds an entry to the contract argName table |
int |
addEntryToContractName(java.lang.String argName,
java.lang.Long argMemberId, java.lang.Integer argOrigin,
boolean flush) Adds an entry to the contract argName table |
int |
addPolicyTC(java.lang.Long argPolicyId,
java.lang.Long argTCId) Adds an entry to the policy terms and conditions table |
int |
addProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId, java.lang.Double adjustment,
java.lang.Integer precedence, java.lang.Integer type) addProductSetAdjustment |
int |
addProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId, java.lang.Double adjustment,
java.lang.Integer precedence, java.lang.Integer type,
boolean flush) addProductSetAdjustment |
int |
addStoreContract(java.lang.Long argStoreId,
java.lang.Long argContractId) Adds an entry to the store contract table |
int |
addTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Long argTradingId, java.lang.Integer argType,
java.lang.String argXMLDefinition, java.lang.Integer argSequence) |
int |
addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId,
java.util.Vector argXMLDefVec) Adds an entry to the trading position container xml table |
int |
addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId,
java.util.Vector argXMLDefVec, boolean flush) Adds an entry to the trading position container xml table |
java.lang.String |
defaultJNDIName() defaultJNDIName |
int |
deleteEntryFromContractName(java.lang.String argName,
java.lang.Long argMemberId, java.lang.Integer argOrigin) Deletes an entry from the contract argName table |
int |
deleteEntryFromContractName(java.lang.String argName,
java.lang.Long argMemberId, java.lang.Integer argOrigin,
boolean flush) Deletes an entry from the contract argName table |
int |
deletePolicyTC(java.lang.Long argPolicyId,
java.lang.Long argTCId) Deletes an entry from the policy terms and conditions table |
int |
deletePolicyTCByTC(java.lang.Long argTCId) Deletes an entry from the policy terms and conditions table |
int |
deleteProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId) deleteProductSetAdjustment |
int |
deleteProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId, boolean flush) deleteProductSetAdjustment |
int |
deleteStoreContract(java.lang.Long argStoreId,
java.lang.Long argContractId) Deletes an entry from the store contract table |
int |
deleteTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Integer argType, java.lang.Integer argSequence) |
int |
deleteTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Integer argType, java.lang.Integer argSequence,
boolean flush) |
int |
deleteXMLDefByTPC(java.lang.Long argTPCId) Deletes an entry from the trading position container xml table |
int |
deleteXMLDefByTPC(java.lang.Long argTPCId, boolean flush) Deletes an entry from the trading position container xml table |
java.util.Vector |
findActiveContractsDeployedInStore(java.lang.Integer storeId) |
java.util.Vector |
findActiveContractsDeployedInStore(java.lang.Integer storeId,
boolean flush) |
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() |
java.util.Vector |
findAllBusinessPolicyType(boolean flush) |
java.util.Vector |
findAllTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Integer argType) |
java.util.Vector |
findAllTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Integer argType, boolean flush) |
java.util.Vector |
findAllTCSubType() |
java.util.Vector |
findAllTCSubType(boolean flush) |
java.lang.String |
findContractComments(java.lang.Long aContractId) Retrieves the comments associated with the specified contract |
java.lang.String |
findContractComments(java.lang.Long aContractId,
boolean flush) Retrieves the comments associated with the specified contract |
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 argState |
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 argState |
java.lang.String |
findContractStoreXML(java.lang.Long argContractId) |
java.lang.String |
findContractStoreXML(java.lang.Long argContractId,
boolean flush) |
java.util.Vector |
findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) findExclusionProductSetIdsByTCIdAndType |
java.util.Vector |
findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId,
boolean flush) findExclusionProductSetIdsByTCIdAndType |
java.util.Vector |
findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) findInclusionProductSetIdsByTCIdAndType |
java.util.Vector |
findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId,
boolean flush) findInclusionProductSetIdsByTCIdAndType |
java.lang.String |
findParticipntInformation(java.lang.Long aParticipntId) Retrieves the information associated with the specified participant |
java.lang.String |
findParticipntInformation(java.lang.Long aParticipntId,
boolean flush) Retrieves the information associated with the specified participant |
com.ibm.commerce.utf.objects.PAttrValueAccessBean[] |
findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId) Retrieves an array of PAttrValueAccessBean objects with the specified term condition ID |
com.ibm.commerce.utf.objects.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) Retrieves the description associated with the specified policy |
java.lang.String |
findPolicyDescription(java.lang.Long aPolicyId,
java.lang.Integer aLanguageId, boolean flush) Retrieves the description associated with the specified policy |
java.util.Vector |
findProductSetAdjustments(java.lang.Long termcondId) findProductSetAdjustments |
java.util.Vector |
findProductSetAdjustments(java.lang.Long termcondId,
boolean flush) findProductSetAdjustments |
java.lang.Integer[] |
findProductSetIdsByTCIdAndType(java.lang.Long termcondId,
java.lang.Integer type) findProductSetIdsByTCIdAndType |
java.lang.Integer[] |
findProductSetIdsByTCIdAndType(java.lang.Long termcondId,
java.lang.Integer type, boolean flush) findProductSetIdsByTCIdAndType |
java.lang.Long[] |
findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId,
java.lang.Integer origin, java.lang.Long contractId) findSameFamilyContracts |
java.lang.Long[] |
findSameFamilyContracts(java.lang.String name, java.lang.Long ownerId,
java.lang.Integer origin, java.lang.Long contractId,
boolean flush) findSameFamilyContracts |
java.lang.Integer[] |
findStoreIdsInStoreContractByContractId(java.lang.Long contractId) findStoreIdsInStoreContractByContractId |
java.lang.Integer[] |
findStoreIdsInStoreContractByContractId(java.lang.Long contractId,
boolean flush) findStoreIdsInStoreContractByContractId |
java.lang.String |
findTCDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId) Retrieves the long description of the specified terms and conditions |
java.lang.String |
findTCDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId, boolean flush) Retrieves the long description of the specified terms and conditions |
java.util.Vector |
findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId,
java.lang.Integer type) findTCIdInTCAttributeByTradingIdAndType |
java.util.Vector |
findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId,
java.lang.Integer type, boolean flush) findTCIdInTCAttributeByTradingIdAndType |
java.lang.String |
findTermCondStringField1(java.lang.Long aTermCondId) Retrieves the string field of the terms and conditions table |
java.lang.String |
findTermCondStringField1(java.lang.Long aTermCondId,
boolean flush) Retrieves the string field of the terms and conditions table |
java.lang.String |
findTRDDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId) Retrieves the long description of the specified trading agreement |
java.lang.String |
findTRDDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId, boolean flush) Retrieves the long description of the specified trading agreement |
java.lang.String |
findXMLDefByTPC(java.lang.Long argTPCId) Retrieves the XML definition of the trading position container |
java.lang.String |
findXMLDefByTPC(java.lang.Long argTPCId, boolean flush) Retrieves the XML definition of the trading position container |
int |
getLargestSequenceInTCAttribute(java.lang.Long termcondId,
java.lang.Integer type) getLargestSequenceInTCAttribute |
int |
getLargestSequenceInTCAttribute(java.lang.Long termcondId,
java.lang.Integer type, boolean flush) getLargestSequenceInTCAttribute |
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 |
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 |
protected
void |
instantiateEJB() instantiateEJB |
java.lang.String |
queryContractName(java.lang.String argName, java.lang.Long argMemberId,
java.lang.Integer argOrigin) Retrieves the argName of the contract associated with the specified member ID and argOrigin |
java.lang.String |
queryContractName(java.lang.String argName, java.lang.Long argMemberId,
java.lang.Integer argOrigin, boolean flush) Retrieves the argName of the contract associated with the specified member ID and argOrigin |
boolean |
queryStoreContract(java.lang.Integer argStoreId,
java.lang.Long argContractId) Queries whether a particular contract exists for a specified store |
boolean |
queryStoreContract(java.lang.Integer argStoreId,
java.lang.Long argContractId, boolean flush) Queries whether a particular contract exists for a specified store |
int |
updateContractComments(java.lang.Long aContractId,
java.lang.String aComments) Updates the aComments field in the contract table |
int |
updateContractComments(java.lang.Long aContractId,
java.lang.String aComments, boolean flush) Updates the aComments field in the contract table |
int |
updateContractStoreXML(java.lang.Long argContractId,
java.lang.String argStoreXML) |
int |
updateContractStoreXML(java.lang.Long argContractId,
java.lang.String argStoreXML, boolean flush) |
int |
updateParticipntInfo(java.lang.Long aParticipntId,
java.lang.String aStringField1) Updates the aStringField1 field in the participant table |
int |
updateParticipntInfo(java.lang.Long aParticipntId,
java.lang.String aParticipntInfo, boolean flush) Updates the aParticipntInfo field in the participant table |
int |
updatePolicyDescription(java.lang.Long aPolicyId,
java.lang.Integer aLanguageId, java.lang.String aDescription) Updates the long aDescription field in the policy aDescription table |
int |
updatePolicyDescription(java.lang.Long aPolicyId,
java.lang.Integer aLanguageId, java.lang.String aDescription,
boolean flush) Updates the long aDescription field in the policy aDescription table |
int |
updateProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId, java.lang.Double adjustment,
java.lang.Integer precedence, java.lang.Integer type) updateProductSetAdjustment |
int |
updateProductSetAdjustment(java.lang.Long termcondId,
java.lang.Integer productsetId, java.lang.Double adjustment,
java.lang.Integer precedence, java.lang.Integer type,
boolean flush) updateProductSetAdjustment |
int |
updateTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Long argTradingId, java.lang.Integer argType,
java.lang.String argXMLDefinition, java.lang.Integer argSequence) |
int |
updateTCAttributeXML(java.lang.Long argTermCondId,
java.lang.Long argTradingId, java.lang.Integer argType,
java.lang.String argXMLDefinition, java.lang.Integer argSequence,
boolean flush) |
int |
updateTCDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId, java.lang.String aDescription) Updates the long aDescription field in the terms and conditions aDescription table |
int |
updateTCDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId, java.lang.String aDescription,
boolean flush) Updates the long aDescription field in the terms and conditions aDescription table |
int |
updateTermCondStringField1(java.lang.Long aTermCondId,
java.lang.String aStringField1) Updates the string field in the terms and conditions table |
int |
updateTermCondStringField1(java.lang.Long aTermCondId,
java.lang.String aStringField1, boolean flush) Updates the string field in the terms and conditions table |
int |
updateTRDDescLongDesc(java.lang.Long aTermCondId,
java.lang.Integer aLangId, java.lang.String aDescription) Updates the long aDescription field in the trading aDescription table |
int |
updateTRDDescLongDesc(java.lang.Long aTradingId,
java.lang.Integer aLangId, java.lang.String aDescription,
boolean flush) Updates the long aDescription field in the trading aDescription table |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll,
toString, wait, wait, wait |
Constructor Detail |
---|
public ContractJDBCHelperAccessBean()
public ContractJDBCHelperAccessBean(javax.ejb.EJBObject o) throws java.rmi.RemoteException
Method Detail |
---|
public java.lang.String defaultJNDIName()
protected void instantiateEJB() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
public int deletePolicyTCByTC(java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 termcond_id= ?
argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCDeployCmdByTC(java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aParticipntInfo, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the aParticipntInfo field in the participant table
The SQL statement used to update the PARTICIPNT table is:
update participnt set aParticipntInfo = ? where participnt.participnt_id = ?
aParticipntId
- The ID of the participant.aParticipntInfo
- The aParticipntInfo associated with the
participant.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findContractStoreXML(java.lang.Long argContractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argContractId
- java.lang.Longjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argPolicyType
- The ID of the policy.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findTermCondStringField1(java.lang.Long aTermCondId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argContractId
- java.lang.LongargStoreXML
- java.lang.Stringjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.lang.String findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the trading agreement.aLangId
- The ID of the language associated with the specified
terms and conditions description.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findXMLDefByTPC(java.lang.Long argTPCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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
argTPCId
- The ID of the trading position container.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 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
argAccountId
- The ID of the account.argOrderByColumn
- The order by which to display the
result.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findContractComments(java.lang.Long aContractId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aContractId
- The ID of the contract.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deleteXMLDefByTPC(java.lang.Long argTPCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTPCId
- The ID of the trading position container.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCAccessBeanNameBySubType(java.lang.String argTCSubType, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?)
argTCSubType
- The subtype of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deletePolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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= ?
argPolicyId
- The ID of the policy.argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCAccessBeanNameBySubType(java.lang.String argTCSubType) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?)
argTCSubType
- The subtype of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findParticipntInformation(java.lang.Long aParticipntId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aParticipntId
- The ID of the participant.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findContractListInOrderByAccount(java.lang.Long argAccountId, java.lang.String argOrderByColumn) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 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
argAccountId
- The ID of the account.argOrderByColumn
- The order by which to display the
result.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCDeployCmdBySubType(java.lang.String argTCSubType, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?)
argTCSubType
- The subtype of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateParticipntInfo(java.lang.Long aParticipntId, java.lang.String aStringField1) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the aStringField1 field in the participant table
The SQL statement used to update the PARTICIPNT table is:
update participnt set aStringField1 = ? where participnt.participnt_id = ?
aParticipntId
- The ID of the participant.aStringField1
- The aStringField1 associated with the
participant.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCDeployCmdByTC(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTCId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Adds an entry to the contract argName table
The SQL statement used to add a row to the CNTRNAME table is:
insert into cntrargName (argName, member_id, argOrigin) values(?, ?, ?)
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract argName.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.aStringField1
- The string field associated with the terms and
conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public boolean queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argStoreId
- The ID of the store.argContractId
- The ID of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllBusinessPolicyType() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.String findParticipntInformation(java.lang.Long aParticipntId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aParticipntId
- The ID of the participant.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argPolicyId
- The ID of the policy.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int getLargestTCSequenceByTrading(java.lang.Long argTradingId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTradingId
- The ID of the trading agreement.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the terms and conditions aDescription table
The SQL statement used to update the TCDESC table is:
update tcdesc set tcdesc.longaDescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?
aTermCondId
- The ID of the terms and conditions.aLangId
- The ID of the language associated with the terms and
conditions aDescription.aDescription
- The aDescription of the terms and
conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findContractStoreXML(java.lang.Long argContractId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argContractId
- java.lang.Longflush
- booleanjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public int updateContractComments(java.lang.Long aContractId, java.lang.String aComments, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the aComments field in the contract table
The SQL statement used to update the CONTRACT table is:
update contract set aComments = ? where contract.contract_id = ?
aContractId
- The ID of the contract.aComments
- The aComments of the contract.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateTermCondStringField1(java.lang.Long aTermCondId, java.lang.String aStringField1, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.aStringField1
- The string field associated with the terms and
conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findXMLDefByTPC(java.lang.Long argTPCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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
argTPCId
- The ID of the trading position container.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Retrieves the argName of the contract associated with the specified member ID and argOrigin
The SQL statement used to query the CNTRNAME table is:
select argName from cntrargName where argName = ? and member_id = ? and argOrigin = ? for update
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addEntryToContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Adds an entry to the contract argName table
The SQL statement used to add a row to the CNTRNAME table is:
insert into cntrargName (argName, member_id, argOrigin) values(?, ?, ?)
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract argName.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.java.sql.SQLException
- The java.sql.SQLException
exception.javax.ejb.CreateException
public java.util.Vector findAllBusinessCmdClassNameForPolicy(java.lang.Long argPolicyId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argPolicyId
- The ID of the policy.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllTCSubType(boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
flush
- booleanjavax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.String findTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the trading agreement.aLangId
- The ID of the language associated with the specified
terms and conditions description.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the policy aDescription table
The SQL statement used to update the POLICYDESC table is:
update policydesc set longaDescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?
aPolicyId
- The ID of the policy.aLanguageId
- The ID of the language associated with the
policy aDescription.aDescription
- The aDescription of the policy.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateTRDDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the trading aDescription table
The SQL statement used to update the TRDDESC table is:
update trddesc set trddesc.longaDescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?
aTermCondId
- The ID of the trading agreement.aLangId
- The ID of the language associated with the trading
aDescription.aDescription
- The aDescription of the trading agreement.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCDeployCmdBySubType(java.lang.String argTCSubType) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?)
argTCSubType
- The subtype of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String getTCAccessBeanNameByTC(java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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(?, ?)
argStoreId
- The ID of the store.argContractId
- The ID of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aPolicyId
- The ID of the policy.aLanguageId
- The ID of the language associated with the
specified policy.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findContractComments(java.lang.Long aContractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aContractId
- The ID of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findTermCondStringField1(java.lang.Long aTermCondId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public com.ibm.commerce.utf.objects.PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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
argTCId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Deletes an entry from the contract argName table
The SQL statement used to delete a row from the CNTRNAME table is:
delete from cntrargName where argName = ? and member_id = ? and argOrigin = ?
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract argName.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findPolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aPolicyId
- The ID of the policy.aLanguageId
- The ID of the language associated with the
specified policy.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public com.ibm.commerce.utf.objects.PAttrValueAccessBean[] findPAttrValueByTCIdOrderByPAttribute(java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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
argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String queryContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Retrieves the argName of the contract associated with the specified member ID and argOrigin
The SQL statement used to query the CNTRNAME table is:
select argName from cntrargName where argName = ? and member_id = ? and argOrigin = ? for update
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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(?, ?, ?)
argTradingPositionContainerId
- The ID of the trading position
container.argXMLDefVec
- The XML definition associated with the
specified trading position container.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.aLangId
- The ID of the language associated with the specified
terms and conditions description.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addPolicyTC(java.lang.Long argPolicyId, java.lang.Long argTCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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(?, ?)
argPolicyId
- The ID of the policy.argTCId
- The ID of the terms and conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public boolean queryStoreContract(java.lang.Integer argStoreId, java.lang.Long argContractId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argStoreId
- The ID of the store.argContractId
- The ID of the contract.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.lang.String findTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
aTermCondId
- The ID of the terms and conditions.aLangId
- The ID of the language associated with the specified
terms and conditions description.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deleteEntryFromContractName(java.lang.String argName, java.lang.Long argMemberId, java.lang.Integer argOrigin) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Deletes an entry from the contract argName table
The SQL statement used to delete a row from the CNTRNAME table is:
delete from cntrargName where argName = ? and member_id = ? and argOrigin = ?
argName
- The argName of the contract.argMemberId
- The ID of the owner member.argOrigin
- The argOrigin of the contract argName.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int getLargestTCSequenceByTrading(java.lang.Long argTradingId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTradingId
- The ID of the trading agreement.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deleteStoreContract(java.lang.Long argStoreId, java.lang.Long argContractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argStoreId
- The ID of the store.argContractId
- The ID of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID and argState
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 from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.argState = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by
argAccountId
- The ID of the account.argState
- The argState of the contract.argOrderByColumn
- The order by which to display the
result.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int deleteXMLDefByTPC(java.lang.Long argTPCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTPCId
- The ID of the trading position container.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllBusinessPolicyType(boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
flush
- booleanjavax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int updateTRDDescLongDesc(java.lang.Long aTradingId, java.lang.Integer aLangId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the trading aDescription table
The SQL statement used to update the TRDDESC table is:
update trddesc set trddesc.longaDescription = ? where trddesc.trading_id = ? and trddesc.language_id = ?
aTradingId
- The ID of the trading agreement.aLangId
- The ID of the language associated with the trading
aDescription.aDescription
- The aDescription of the trading agreement.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllBusinessCmdInterfaceNameByPolicyType(java.lang.String argPolicyType) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argPolicyType
- The ID of the policy.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateContractComments(java.lang.Long aContractId, java.lang.String aComments) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the aComments field in the contract table
The SQL statement used to update the CONTRACT table is:
update contract set aComments = ? where contract.contract_id = ?
aContractId
- The ID of the contract.aComments
- The aComments of the contract.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findContractListInOrderByAccountAndState(java.lang.Long argAccountId, java.lang.Integer argState, java.lang.String argOrderByColumn, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Retrieves all contracts associated with the specified account ID and argState
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 from contract, trading, trddesc where (trading.account_id = ? and trading.markfordelete = 0) and contract.argState = ? and contract.markfordelete = 0 and contract.contract_id = trading.trading_id and contract.contract_id = trddesc.trading_id order by
argAccountId
- The ID of the account.argState
- The argState of the contract.argOrderByColumn
- The order by which to display the
result.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public java.util.Vector findAllTCSubType() throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int updateContractStoreXML(java.lang.Long argContractId, java.lang.String argStoreXML, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argContractId
- java.lang.LongargStoreXML
- java.lang.Stringflush
- booleanjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.lang.String getTCAccessBeanNameByTC(java.lang.Long argTCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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 = ?
argTCId
- The ID of the terms and conditions.flush
- The flag indicating whether changes should be
committed immediately.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int addTPCXMLDefinition(java.lang.Long argTradingPositionContainerId, java.util.Vector argXMLDefVec) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, 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(?, ?, ?)
argTradingPositionContainerId
- The ID of the trading position
container.argXMLDefVec
- The XML definition associated with the
specified trading position container.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updatePolicyDescription(java.lang.Long aPolicyId, java.lang.Integer aLanguageId, java.lang.String aDescription) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the policy aDescription table
The SQL statement used to update the POLICYDESC table is:
update policydesc set longaDescription = ? where policydesc.policy_id = ? and policydesc.language_id = ?
aPolicyId
- The ID of the policy.aLanguageId
- The ID of the language associated with the
policy aDescription.aDescription
- The aDescription of the policy.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
public int updateTCDescLongDesc(java.lang.Long aTermCondId, java.lang.Integer aLangId, java.lang.String aDescription) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
Updates the long aDescription field in the terms and conditions aDescription table
The SQL statement used to update the TCDESC table is:
update tcdesc set tcdesc.longaDescription = ? where tcdesc.termcond_id = ? and tcdesc.language_id = ?
aTermCondId
- The ID of the terms and conditions.aLangId
- The ID of the language associated with the terms and
conditions aDescription.aDescription
- The aDescription of the terms and
conditions.javax.naming.NamingException
- The
javax.naming.NamingException exception.java.sql.SQLException
- The java.sql.SQLException
exception.java.rmi.RemoteException
- The java.rmi.RemoteException
exception.javax.ejb.CreateException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargTradingId
- java.lang.LongargXMLDefinition
- java.lang.StringargSequence
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
storeId
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargTradingId
- java.lang.LongargType
- java.lang.IntegerargXMLDefinition
- java.lang.StringargSequence
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargTradingId
- java.lang.IntegerargType
- java.lang.IntegerargXMLDefinition
- java.lang.StringargSequence
- java.lang.Integerflush
- booleanjava.lang.String
- The exception description.java.lang.String
- The exception description.java.lang.String
- The exception description.javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
storeId
- java.lang.Integerflush
- booleanjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public int deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargType
- java.lang.IntegerargSequence
- java.lang.Integerflush
- booleanjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.util.Vector findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargType
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public int deleteTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, java.lang.Integer argSequence) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargType
- java.lang.IntegerargSequence
- java.lang.Integerjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.util.Vector findAllTCAttributeXML(java.lang.Long argTermCondId, java.lang.Integer argType, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
argTermCondId
- java.lang.LongargType
- java.lang.Integerflush
- booleanjavax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException
public java.util.Vector findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findTCIdInTCAttributeByTradingIdAndType(java.lang.Long tradingId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int deleteProductSetAdjustment(java.lang.Long termcondId, java.lang.Integer productsetId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.Integer[] findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.lang.Integer[] findProductSetIdsByTCIdAndType(java.lang.Long termcondId, java.lang.Integer type) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public int getLargestSequenceInTCAttribute(java.lang.Long termcondId, java.lang.Integer type) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
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, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId, boolean flush) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException
public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId) throws javax.naming.NamingException, javax.ejb.CreateException, java.rmi.RemoteException, java.sql.SQLException
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException