SQL-142: Update s a i f office collection¶

Update s a i f office collection in the context of clsSAIFOfficeCollection.

Classification¶

Field	Value
SQL ID	SQL-142
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsSAIFOfficeCollection`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate / AfterUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	bound from `Code`	5	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 579)
`:CodeDescr`	Input	bound from `CodeDescr`	65	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 580)
`:PmsOfficeCode`	Input	bound from `PMSOfficeCode`	4	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 346)
`:PolicyRenewalTrackCode`	Input	bound from `PolicyRenewalTrackCode`	5	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 347)
`:LocSeqNum`	Input	bound from `LocSeqNum`	-	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 480)
`:CancellationTrackCode`	Input	bound from `m_CancellationTrackCode`	5	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 679)
`:PolicyRegionCode`	Input	bound from `m_PolicyRegionCode`	5	Bound in `clsSAIFOfficeCollection.BeforeUpdate` (line 351)

Tables¶

Table	Access	Columns used
OFFICE_CODE	UPDATE	See sample SQL

Sample SQL¶

UPDATE
  OFFICE_CODE
SET
  CODE = :Code,
  CODE_DESCR = :CodeDescr,
  PMS_OFFICE_CODE = :PmsOfficeCode,
  POLICY_RENEWAL_TRACK_CODE = :PolicyRenewalTrackCode,
  LOC_SEQ_NUM = :LocSeqNum,
  CANCELLATION_TRACK_CODE = :CancellationTrackCode,
  POLICY_REGION_CODE = :PolicyRegionCode
WHERE

Business rules¶

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.Policy.Core\clsSAIFOfficeCollection.vb