SQL-141: Update s a i f office

Update s a i f office in the context of clsSAIFOffice.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:Code	Input	bound from Code	5	Bound in clsSAIFOffice.BeforeUpdate (line 345)
:Description	Input	bound from m_Description	65	Bound in clsSAIFOffice.BeforeUpdate (line 349)
:PMSOfficeCode	Input	bound from PMSOfficeCode	4	Bound in clsSAIFOffice.BeforeUpdate (line 346)
:PolicyRenewalTrackCode	Input	bound from PolicyRenewalTrackCode	5	Bound in clsSAIFOffice.BeforeUpdate (line 347)
:LocationSeqNum	Input	bound from m_LocationSeqNum	-	Bound in clsSAIFOffice.BeforeUpdate (line 350)
:CancellationTrackCode	Input	bound from CancellationTrackCode	5	Bound in clsSAIFOffice.BeforeUpdate (line 348)
:PolicyRegionCode	Input	bound from m_PolicyRegionCode	5	Bound in clsSAIFOffice.BeforeUpdate (line 351)

Tables

Table	Access	Columns used
OFFICE_CODE	UPDATE	See sample SQL

Sample SQL

UPDATE
  OFFICE_CODE
SET
  CODE = :Code,
  CODE_DESCR = :Description,
  PMS_OFFICE_CODE = :PMSOfficeCode,
  POLICY_RENEWAL_TRACK_CODE = :PolicyRenewalTrackCode,
  LOC_SEQ_NUM = :LocationSeqNum,
  CANCELLATION_TRACK_CODE = :CancellationTrackCode,
  POLICY_REGION_CODE = :PolicyRegionCode
WHERE
  OFFICE_CODE.CODE = :Code

Business rules

• BR-030: The service centre office is identified by office
• BR-033: New sequence values for writable entities are obtained

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\clsSAIFOffice.vb