SQL-086: Pk82033_ThirdParty.thrdparty_update¶

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

Classification¶

Field	Value
SQL ID	SQL-086
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
`:AttorneyFirmSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:AttorneyFirmSeqNum`	Input	Number	N/A	Source value `AttorneyFirmSeqNum`
`:CarrierClaimNum`	Input	Number	50	Source value `DbType.String`
`:CarrierClaimNum`	Input	Number	50	Source value `CarrierClaimNum`
`:CarrierFirmSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:CarrierFirmSeqNum`	Input	Number	N/A	Source value `CarrierFirmSeqNum`
`:CarrierPolicyNum`	Input	Number	50	Source value `DbType.String`
`:CarrierPolicyNum`	Input	Number	50	Source value `CarrierPolicyNum`
`:DistrictAttorneyNum`	Input	Number	20	Source value `DbType.String`
`:DistrictAttorneyNum`	Input	Number	20	Source value `DistrictAttorneyNum`
`:IdentifierText`	Input	Number	50	Source value `DbType.String`
`:IdentifierText`	Input	Number	50	Source value `IdentifierText`
`:PersonSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:PersonSeqNum`	Input	Number	N/A	Source value `PersonSeqNum`
`:ThrdpartyCaseSeqNum`	Input	Number	N/A	Source value `ThrdpartyCaseSeqNum`
`:ThrdpartyFirmSeqNum`	Input	Number	N/A	Source value `DbType.Int16`
`:ThrdpartyFirmSeqNum`	Input	Number	N/A	Source value `ThrdpartyFirmSeqNum`

Tables¶

Table	Access	Columns used
dual	UPDATE	See sample SQL.
person_phone	UPDATE	See sample SQL.
phone	UPDATE	See sample SQL.
v_phone_seq	UPDATE	See sample SQL.
v_fax_seq	UPDATE	See sample SQL.

Sample SQL¶

BEGIN Pk82033_ThirdParty.thrdparty_update(:AttorneyFirmSeqNum, :AttorneyFirmSeqNum, :CarrierClaimNum, :CarrierClaimNum, :CarrierFirmSeqNum, :CarrierFirmSeqNum, :CarrierPolicyNum, :CarrierPolicyNum, :DistrictAttorneyNum, :DistrictAttorneyNum, :IdentifierText, :IdentifierText, :PersonSeqNum, :PersonSeqNum, :ThrdpartyCaseSeqNum, :ThrdpartyFirmSeqNum, :ThrdpartyFirmSeqNum); 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\clsThrdparty.vb