SQL-076: pk82033_thirdparty.thrdparty_case_update¶

This SQL artifact supports Criteria by executing a update operation through StoredProc.

Classification¶

Field	Value
SQL ID	SQL-076
Operation type	Update
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`Criteria`
Criteria property	`updatesql`
Lifecycle method	`Criteria update`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:CauseOFActionCode`	Input	String	5	Source value `m_CauseOfActionCode`
`:CocounselFirmSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:CocounselFirmSeqNum`	Input	Number	N/A	Source value `m_CocounselFirmSeqNum`
`:PlaintiffFirmSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:PlaintiffFirmSeqNum`	Input	Number	N/A	Source value `m_PlaintiffFirmSeqNum`
`:StatuteDate`	Input	Date	N/A	Source value `DbType.Date`
`:StatuteDate`	Input	Date	N/A	Source value `m_StatuteDate`
`:SubseqInterveningCauseDate`	Input	Date	N/A	Source value `DbType.Date`
`:SubseqInterveningCauseDate`	Input	Date	N/A	Source value `m_SubseqInterveningCauseDate`
`:SubseqInterveningCauseCode`	Input	Number	5	Source value `m_SubseqInterveningCauseCode`
`:SuitFiledDate`	Input	Date	N/A	Source value `DbType.Date`
`:SuitFiledDate`	Input	Date	N/A	Source value `m_SuitFiledDate`
`:AdjusterCode`	Input	String	5	Source value `m_ThrdpartyAdjusterCode`
`:ClosureCode`	Input	String	5	Source value `m_ThrdpartyClosureCode`
`:StatusCode`	Input	String	5	Source value `m_ThrdpartyStatusCode`
`:TypeCode`	Input	String	5	Source value `m_ThrdpartyTypeCode`
`:UpdateUser`	Input	Date	30	Source value `MyCriteria.DataPortalInfo.UserID`
`:AccidentLocationText`	Input	Number	100	Source value `m_AccidentLocationText`
`:NDReimbursementAmt`	Input	Unknown	N/A	Source value `m_NDReimbursementAmt`
`:CaseSeqNum`	Input	Number	N/A	Source value `m_CaseSeqNum`
`:UpdateSeqNum`	Input	Date	N/A	Source value `m_UpdateSeqNum`
`:ClaimID`	Input	Number	N/A	Source value `m_ClaimID`

Tables¶

Table	Access	Columns used
thrdparty_note	UPDATE	See sample SQL.
thrdparty_case	UPDATE	See sample SQL.
thrdparty_task	UPDATE	See sample SQL.
thrdparty_status_hist	UPDATE	See sample SQL.

Sample SQL¶

BEGIN pk82033_thirdparty.thrdparty_case_update(:CauseOFActionCode, :CocounselFirmSeqNum, :CocounselFirmSeqNum, :PlaintiffFirmSeqNum, :PlaintiffFirmSeqNum, :StatuteDate, :StatuteDate, :SubseqInterveningCauseDate, :SubseqInterveningCauseDate, :SubseqInterveningCauseCode, :SuitFiledDate, :SuitFiledDate, :AdjusterCode, :ClosureCode, :StatusCode, :TypeCode, :UpdateUser, :AccidentLocationText, :NDReimbursementAmt, :CaseSeqNum, :UpdateSeqNum, :ClaimID); END;
-- Stored procedure body retrieved from Oracle package WCIS_DBA.Pk82033_ThirdParty.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Claim.ThirdParty\clsThirdPartyCase.vb