com.ibm.commerce.contract.objects
Class ContractJDBCHelperAccessBean

java.lang.Object
  |
  +--AbstractSessionAccessBean
        |
        +--com.ibm.commerce.contract.objects.ContractJDBCHelperAccessBean

public class ContractJDBCHelperAccessBean
extends AbstractSessionAccessBean

From JavaDoc Build Script : Cannot find description for this AccessBean ContractJDBCHelperAccessBean

See Also:
Serialized Form

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

ContractJDBCHelperAccessBean

public ContractJDBCHelperAccessBean()
ContractJDBCHelperAccessBean

ContractJDBCHelperAccessBean

public ContractJDBCHelperAccessBean(javax.ejb.EJBObject o)
                             throws java.rmi.RemoteException
ContractJDBCHelperAccessBean
Method Detail

defaultJNDIName

public java.lang.String defaultJNDIName()
defaultJNDIName

instantiateEJB

protected void instantiateEJB()
                       throws javax.naming.NamingException,
                              javax.ejb.CreateException,
                              java.rmi.RemoteException
instantiateEJB
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException

deletePolicyTCByTC

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= ?

Parameters:
argTCId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the entry has been deleted.
Throws:
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

getTCDeployCmdByTC

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 = ?

Parameters:
argTCId - The ID of the terms and conditions.
Returns:
The deploy command associated with the terms and conditions ID.
Throws:
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

updateParticipntInfo

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 = ?

Parameters:
aParticipntId - The ID of the participant.
aParticipntInfo - The aParticipntInfo associated with the participant.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the participant table after the entry has updated.
Throws:
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

findContractStoreXML

public java.lang.String findContractStoreXML(java.lang.Long argContractId)
                                      throws javax.naming.NamingException,
                                             javax.ejb.CreateException,
                                             java.rmi.RemoteException,
                                             java.sql.SQLException
Parameters:
argContractId - java.lang.Long
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findAllBusinessCmdInterfaceNameByPolicyType

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 = ?

Parameters:
argPolicyType - The ID of the policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of business command interface names.
Throws:
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

findTermCondStringField1

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 = ?

Parameters:
aTermCondId - The ID of the terms and conditions.
Returns:
The string field of the terms and conditions table.
Throws:
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

updateContractStoreXML

public int updateContractStoreXML(java.lang.Long argContractId,
                                  java.lang.String argStoreXML)
                           throws javax.naming.NamingException,
                                  javax.ejb.CreateException,
                                  java.rmi.RemoteException,
                                  java.sql.SQLException
Parameters:
argContractId - java.lang.Long
argStoreXML - java.lang.String
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findTRDDescLongDesc

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 = ?

Parameters:
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.
Returns:
The long description of the specified trading agreement.
Throws:
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

findXMLDefByTPC

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

Parameters:
argTPCId - The ID of the trading position container.
Returns:
The XML definition associated with the trading position container.
Throws:
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

findContractListInOrderByAccount

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

Parameters:
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.
Returns:
A vector of contract IDs.
Throws:
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

findContractComments

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 = ?

Parameters:
aContractId - The ID of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The comments associated with the specified contract.
Throws:
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

deleteXMLDefByTPC

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 = ?

Parameters:
argTPCId - The ID of the trading position container.
Returns:
The number of rows in the trading position container xml table after the entry has been deleted.
Throws:
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

getTCAccessBeanNameBySubType

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 = ?)

Parameters:
argTCSubType - The subtype of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The name of the terms and conditions access bean.
Throws:
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

deletePolicyTC

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= ?

Parameters:
argPolicyId - The ID of the policy.
argTCId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the entry has been deleted.
Throws:
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

getTCAccessBeanNameBySubType

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 = ?)

Parameters:
argTCSubType - The subtype of the terms and conditions.
Returns:
The name of the terms and conditions access bean.
Throws:
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

findParticipntInformation

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 = ?

Parameters:
aParticipntId - The ID of the participant.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The information associated with the specified participant.
Throws:
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

findContractListInOrderByAccount

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

Parameters:
argAccountId - The ID of the account.
argOrderByColumn - The order by which to display the result.
Returns:
A vector of contract IDs.
Throws:
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

getTCDeployCmdBySubType

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 = ?)

Parameters:
argTCSubType - The subtype of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The deploy command associated with the terms and conditions subtype.
Throws:
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

updateParticipntInfo

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 = ?

Parameters:
aParticipntId - The ID of the participant.
aStringField1 - The aStringField1 associated with the participant.
Returns:
The number of rows in the participant table after the entry has updated.
Throws:
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

getTCDeployCmdByTC

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 = ?

Parameters:
argTCId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The deploy command associated with the terms and conditions ID.
Throws:
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

addEntryToContractName

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(?, ?, ?)

Parameters:
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.
Returns:
The number of rows in the contract argName table after the new row has been inserted.
Throws:
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

updateTermCondStringField1

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 = ?

Parameters:
aTermCondId - The ID of the terms and conditions.
aStringField1 - The string field associated with the terms and conditions.
Returns:
The number of rows in the terms and conditions table after the entry has updated.
Throws:
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

queryStoreContract

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 = ?

Parameters:
argStoreId - The ID of the store.
argContractId - The ID of the contract.
Returns:
boolean A flag indicating whether the contract exists for the specified store.
Throws:
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

findAllBusinessPolicyType

public java.util.Vector findAllBusinessPolicyType()
                                           throws javax.naming.NamingException,
                                                  javax.ejb.CreateException,
                                                  java.rmi.RemoteException,
                                                  java.sql.SQLException
Returns:
java.util.Vector
Throws:
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findParticipntInformation

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 = ?

Parameters:
aParticipntId - The ID of the participant.
Returns:
The information associated with the specified participant.
Throws:
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

findAllBusinessCmdClassNameForPolicy

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 = ?

Parameters:
argPolicyId - The ID of the policy.
flush - The flag indicating whether changes should be committed immediately.
Returns:
A vector of business command class names.
Throws:
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

getLargestTCSequenceByTrading

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 = ?

Parameters:
argTradingId - The ID of the trading agreement.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The largest terms and conditions sequence number with the specified trading ID.
Throws:
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

updateTCDescLongDesc

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 = ?

Parameters:
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.
Returns:
The number of rows in the terms and conditions aDescription table after the entry has updated.
Throws:
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

findContractStoreXML

public java.lang.String findContractStoreXML(java.lang.Long argContractId,
                                             boolean flush)
                                      throws javax.naming.NamingException,
                                             javax.ejb.CreateException,
                                             java.rmi.RemoteException,
                                             java.sql.SQLException
Parameters:
argContractId - java.lang.Long
flush - boolean
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updateContractComments

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 = ?

Parameters:
aContractId - The ID of the contract.
aComments - The aComments of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the contract table after the entry has updated.
Throws:
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

updateTermCondStringField1

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 = ?

Parameters:
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.
Returns:
The number of rows in the terms and conditions table after the entry has updated.
Throws:
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

findXMLDefByTPC

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

Parameters:
argTPCId - The ID of the trading position container.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The XML definition associated with the trading position container.
Throws:
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

queryContractName

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

Parameters:
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.
Returns:
The argName of the contract.
Throws:
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

addEntryToContractName

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(?, ?, ?)

Parameters:
argName - The argName of the contract.
argMemberId - The ID of the owner member.
argOrigin - The argOrigin of the contract argName.
Returns:
The number of rows in the contract argName table after the new row has been inserted.
Throws:
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

findAllBusinessCmdClassNameForPolicy

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 = ?

Parameters:
argPolicyId - The ID of the policy.
Returns:
A vector of business command class names.
Throws:
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

findAllTCSubType

public java.util.Vector findAllTCSubType(boolean flush)
                                  throws javax.naming.NamingException,
                                         javax.ejb.CreateException,
                                         java.rmi.RemoteException,
                                         java.sql.SQLException
Parameters:
flush - boolean
Returns:
java.util.Vector
Throws:
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findTRDDescLongDesc

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 = ?

Parameters:
aTermCondId - The ID of the trading agreement.
aLangId - The ID of the language associated with the specified terms and conditions description.
Returns:
The long description of the specified trading agreement.
Throws:
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

updatePolicyDescription

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 = ?

Parameters:
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.
Returns:
The number of rows in the policy aDescription table after the entry has updated.
Throws:
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

updateTRDDescLongDesc

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 = ?

Parameters:
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.
Returns:
The number of rows in the trading aDescription table after the entry has updated.
Throws:
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

getTCDeployCmdBySubType

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 = ?)

Parameters:
argTCSubType - The subtype of the terms and conditions.
Returns:
The deploy command associated with the terms and conditions subtype.
Throws:
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

getTCAccessBeanNameByTC

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 = ?

Parameters:
argTCId - The ID of the terms and conditions.
Returns:
The name of the terms and conditions access bean.
Throws:
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

addStoreContract

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(?, ?)

Parameters:
argStoreId - The ID of the store.
argContractId - The ID of the contract.
Returns:
The number of rows in the store contract table after the new row has been inserted.
Throws:
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

findPolicyDescription

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 = ?

Parameters:
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.
Returns:
The description associated with the specified policy.
Throws:
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

findContractComments

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 = ?

Parameters:
aContractId - The ID of the contract.
Returns:
The comments associated with the specified contract.
Throws:
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

findTermCondStringField1

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 = ?

Parameters:
aTermCondId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The string field of the terms and conditions table.
Throws:
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

findPAttrValueByTCIdOrderByPAttribute

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

Parameters:
argTCId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
An array of PAttrValueAccessBean objects with the specified term condition ID.
Throws:
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

deleteEntryFromContractName

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 = ?

Parameters:
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.
Returns:
The number of rows in the contract argName after the entry has been deleted.
Throws:
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

findPolicyDescription

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 = ?

Parameters:
aPolicyId - The ID of the policy.
aLanguageId - The ID of the language associated with the specified policy.
Returns:
The description associated with the specified policy.
Throws:
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

findPAttrValueByTCIdOrderByPAttribute

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

Parameters:
argTCId - The ID of the terms and conditions.
Returns:
An array of PAttrValueAccessBean objects with the specified term condition ID.
Throws:
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

queryContractName

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

Parameters:
argName - The argName of the contract.
argMemberId - The ID of the owner member.
argOrigin - The argOrigin of the contract.
Returns:
The argName of the contract.
Throws:
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

addTPCXMLDefinition

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(?, ?, ?)

Parameters:
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.
Returns:
The number of rows in the trading position container xml table after the new row has been inserted.
Throws:
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

findTCDescLongDesc

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 = ?

Parameters:
aTermCondId - The ID of the terms and conditions.
aLangId - The ID of the language associated with the specified terms and conditions description.
Returns:
The long description of the specified terms and conditions.
Throws:
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

addPolicyTC

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(?, ?)

Parameters:
argPolicyId - The ID of the policy.
argTCId - The ID of the terms and conditions.
Returns:
The number of rows in the policy terms and conditions table after the new row has been inserted.
Throws:
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

queryStoreContract

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 = ?

Parameters:
argStoreId - The ID of the store.
argContractId - The ID of the contract.
flush - The flag indicating whether changes should be committed immediately.
Returns:
boolean A flag indicating whether the contract exists for the specified store.
Throws:
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

findTCDescLongDesc

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 = ?

Parameters:
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.
Returns:
The long description of the specified terms and conditions.
Throws:
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

deleteEntryFromContractName

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 = ?

Parameters:
argName - The argName of the contract.
argMemberId - The ID of the owner member.
argOrigin - The argOrigin of the contract argName.
Returns:
The number of rows in the contract argName table after the entry has been deleted.
Throws:
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

getLargestTCSequenceByTrading

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 = ?

Parameters:
argTradingId - The ID of the trading agreement.
Returns:
The largest terms and conditions sequence number with the specified trading ID.
Throws:
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

deleteStoreContract

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 = ?

Parameters:
argStoreId - The ID of the store.
argContractId - The ID of the contract.
Returns:
The number of rows in the store contract table after the entry has been deleted.
Throws:
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

findContractListInOrderByAccountAndState

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

Parameters:
argAccountId - The ID of the account.
argState - The argState of the contract.
argOrderByColumn - The order by which to display the result.
Returns:
A vector of contract IDs.
Throws:
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

deleteXMLDefByTPC

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 = ?

Parameters:
argTPCId - The ID of the trading position container.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The number of rows in the trading position container xml table after the entry has been deleted.
Throws:
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

findAllBusinessPolicyType

public java.util.Vector findAllBusinessPolicyType(boolean flush)
                                           throws javax.naming.NamingException,
                                                  javax.ejb.CreateException,
                                                  java.rmi.RemoteException,
                                                  java.sql.SQLException
Parameters:
flush - boolean
Returns:
java.util.Vector
Throws:
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

updateTRDDescLongDesc

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 = ?

Parameters:
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.
Returns:
The number of rows in the trading aDescription table after the entry has updated.
Throws:
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

findAllBusinessCmdInterfaceNameByPolicyType

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 = ?

Parameters:
argPolicyType - The ID of the policy.
Returns:
A vector of business command interface names.
Throws:
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

updateContractComments

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 = ?

Parameters:
aContractId - The ID of the contract.
aComments - The aComments of the contract.
Returns:
The number of rows in the contract table after the entry has updated.
Throws:
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

findContractListInOrderByAccountAndState

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

Parameters:
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.
Returns:
A vector of contract IDs.
Throws:
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

findAllTCSubType

public java.util.Vector findAllTCSubType()
                                  throws javax.naming.NamingException,
                                         javax.ejb.CreateException,
                                         java.rmi.RemoteException,
                                         java.sql.SQLException
Returns:
java.util.Vector
Throws:
javax.naming.NamingException.
java.sql.SQLException.
java.rmi.RemoteException.
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

updateContractStoreXML

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
Parameters:
argContractId - java.lang.Long
argStoreXML - java.lang.String
flush - boolean
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

getTCAccessBeanNameByTC

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 = ?

Parameters:
argTCId - The ID of the terms and conditions.
flush - The flag indicating whether changes should be committed immediately.
Returns:
The name of the terms and conditions access bean.
Throws:
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

addTPCXMLDefinition

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(?, ?, ?)

Parameters:
argTradingPositionContainerId - The ID of the trading position container.
argXMLDefVec - The XML definition associated with the specified trading position container.
Returns:
The number of rows in the trading position container xml table after the new row has been inserted.
Throws:
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

updatePolicyDescription

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 = ?

Parameters:
aPolicyId - The ID of the policy.
aLanguageId - The ID of the language associated with the policy aDescription.
aDescription - The aDescription of the policy.
Returns:
The number of rows in the policy aDescription table after the entry has updated.
Throws:
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

updateTCDescLongDesc

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 = ?

Parameters:
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.
Returns:
The number of rows in the terms and conditions aDescription table after the entry has updated.
Throws:
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

updateTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argTradingId - java.lang.Long
argXMLDefinition - java.lang.String
argSequence - java.lang.Integer
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findActiveContractsDeployedInStore

public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId)
                                                    throws javax.naming.NamingException,
                                                           javax.ejb.CreateException,
                                                           java.rmi.RemoteException,
                                                           java.sql.SQLException
Parameters:
storeId - java.lang.Integer
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

addTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argTradingId - java.lang.Long
argType - java.lang.Integer
argXMLDefinition - java.lang.String
argSequence - java.lang.Integer
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

updateTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argTradingId - java.lang.Integer
argType - java.lang.Integer
argXMLDefinition - java.lang.String
argSequence - java.lang.Integer
flush - boolean
Returns:
int
Throws:
java.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

findActiveContractsDeployedInStore

public java.util.Vector findActiveContractsDeployedInStore(java.lang.Integer storeId,
                                                           boolean flush)
                                                    throws javax.naming.NamingException,
                                                           javax.ejb.CreateException,
                                                           java.rmi.RemoteException,
                                                           java.sql.SQLException
Parameters:
storeId - java.lang.Integer
flush - boolean
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

deleteTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argType - java.lang.Integer
argSequence - java.lang.Integer
flush - boolean
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findAllTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argType - java.lang.Integer
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

deleteTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argType - java.lang.Integer
argSequence - java.lang.Integer
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findAllTCAttributeXML

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
Parameters:
argTermCondId - java.lang.Long
argType - java.lang.Integer
flush - boolean
Returns:
int
Throws:
javax.naming.NamingException
java.sql.SQLException
java.rmi.RemoteException
javax.ejb.CreateException

findTCIdInTCAttributeByTradingIdAndType

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
findTCIdInTCAttributeByTradingIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findTCIdInTCAttributeByTradingIdAndType

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
findTCIdInTCAttributeByTradingIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findInclusionProductSetIdsByTCIdAndType

public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId,
                                                                boolean flush)
                                                         throws javax.naming.NamingException,
                                                                javax.ejb.CreateException,
                                                                java.rmi.RemoteException,
                                                                java.sql.SQLException
findInclusionProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findExclusionProductSetIdsByTCIdAndType

public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId,
                                                                boolean flush)
                                                         throws javax.naming.NamingException,
                                                                javax.ejb.CreateException,
                                                                java.rmi.RemoteException,
                                                                java.sql.SQLException
findExclusionProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findExclusionProductSetIdsByTCIdAndType

public java.util.Vector findExclusionProductSetIdsByTCIdAndType(java.lang.Long TCId)
                                                         throws javax.naming.NamingException,
                                                                javax.ejb.CreateException,
                                                                java.rmi.RemoteException,
                                                                java.sql.SQLException
findExclusionProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findInclusionProductSetIdsByTCIdAndType

public java.util.Vector findInclusionProductSetIdsByTCIdAndType(java.lang.Long TCId)
                                                         throws javax.naming.NamingException,
                                                                javax.ejb.CreateException,
                                                                java.rmi.RemoteException,
                                                                java.sql.SQLException
findInclusionProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

addProductSetAdjustment

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
addProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

deleteProductSetAdjustment

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
deleteProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

updateProductSetAdjustment

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
updateProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findStoreIdsInStoreContractByContractId

public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId)
                                                            throws javax.naming.NamingException,
                                                                   javax.ejb.CreateException,
                                                                   java.rmi.RemoteException,
                                                                   java.sql.SQLException
findStoreIdsInStoreContractByContractId
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

deleteProductSetAdjustment

public int deleteProductSetAdjustment(java.lang.Long termcondId,
                                      java.lang.Integer productsetId)
                               throws javax.naming.NamingException,
                                      javax.ejb.CreateException,
                                      java.rmi.RemoteException,
                                      java.sql.SQLException
deleteProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findStoreIdsInStoreContractByContractId

public java.lang.Integer[] findStoreIdsInStoreContractByContractId(java.lang.Long contractId,
                                                                   boolean flush)
                                                            throws javax.naming.NamingException,
                                                                   javax.ejb.CreateException,
                                                                   java.rmi.RemoteException,
                                                                   java.sql.SQLException
findStoreIdsInStoreContractByContractId
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findProductSetIdsByTCIdAndType

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
findProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findProductSetIdsByTCIdAndType

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
findProductSetIdsByTCIdAndType
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

updateProductSetAdjustment

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
updateProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

addProductSetAdjustment

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
addProductSetAdjustment
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

getLargestSequenceInTCAttribute

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
getLargestSequenceInTCAttribute
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

getLargestSequenceInTCAttribute

public int getLargestSequenceInTCAttribute(java.lang.Long termcondId,
                                           java.lang.Integer type)
                                    throws javax.naming.NamingException,
                                           javax.ejb.CreateException,
                                           java.rmi.RemoteException,
                                           java.sql.SQLException
getLargestSequenceInTCAttribute
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findSameFamilyContracts

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
findSameFamilyContracts
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findSameFamilyContracts

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
findSameFamilyContracts
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findProductSetAdjustments

public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId,
                                                  boolean flush)
                                           throws javax.naming.NamingException,
                                                  javax.ejb.CreateException,
                                                  java.rmi.RemoteException,
                                                  java.sql.SQLException
findProductSetAdjustments
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException

findProductSetAdjustments

public java.util.Vector findProductSetAdjustments(java.lang.Long termcondId)
                                           throws javax.naming.NamingException,
                                                  javax.ejb.CreateException,
                                                  java.rmi.RemoteException,
                                                  java.sql.SQLException
findProductSetAdjustments
javax.naming.NamingException
javax.ejb.CreateException
java.rmi.RemoteException
java.sql.SQLException