SQL-022: pk82033_thirdparty.thrdparty_case_insert¶

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

Classification¶

Field	Value
SQL ID	SQL-022
Operation type	Create
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`Criteria`
Criteria property	`insertsql`
Lifecycle method	`Criteria create`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimID`	Input	Number	N/A	Source value `ClaimID`
`:CreateUser`	Input	Number	30	Source value `MyCriteria.DataPortalInfo.UserID`
`:AdjusterCode`	Input	String	5	Source value `ThrdpartyAdjusterCode`
`:StatusCode`	Input	String	5	Source value `ThrdpartyStatusCode`
`:ClosureCode`	Input	String	5	Source value `ThrdpartyClosureCode`
`:TypeCode`	Input	String	5	Source value `ThrdpartyTypeCode`
`:UpdateSeqNum`	Input	Date	N/A	Source value `UpdateSeqNum`
`:CaseSeqNum`	Input	Number	N/A	Source value `CaseSeqNum`
`:CauseOFActionCode`	Input	String	5	Source value `m_CauseOfActionCode`
`:SICCode`	Input	Number	5	Source value `m_SubseqInterveningCauseCode`
`: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`
`:RowsAffected`	ReturnValue	Return value	N/A	Source value `m_RowsAffected`

Tables¶

Table	Access	Columns used
THRDPARTY_CASE	CREATE	See sample SQL.

Sample SQL¶

BEGIN pk82033_thirdparty.thrdparty_case_insert(:ClaimID, :CreateUser, :AdjusterCode, :StatusCode, :ClosureCode, :TypeCode, :UpdateSeqNum, :CaseSeqNum, :CauseOFActionCode, :SICCode, :CocounselFirmSeqNum, :CocounselFirmSeqNum, :PlaintiffFirmSeqNum, :PlaintiffFirmSeqNum, :StatuteDate, :StatuteDate, :RowsAffected); 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