SQL-026: Insert cancel reason override¶

Insert cancel reason override in the context of clsCancelReasonOverride.

Classification¶

Field	Value
SQL ID	SQL-026
Operation type	Insert
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsCancelReasonOverride`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert / AfterInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:CancelReasonOverrideSeqNum`	Input	bound from `CancelReasonOverrideSeqNum`	-	Bound in `clsCancelReasonOverride.BeforeInsert` (line 193)
`:CancellationSeqNum`	Input	bound from `MyCriteria.CancellationSeqNum`	-	Bound in `clsCancelReasonOverride.BeforeInsert` (line 194)
`:CancelReasonCode`	Input	bound from `CancelReasonCode`	5	Bound in `clsCancelReasonOverride.BeforeInsert` (line 186)
`:CarrierCode`	Input	bound from `CarrierCode`	5	Bound in `clsCancelReasonOverride.BeforeInsert` (line 187)
`:CarrierChangeReasonCode`	Input	bound from `CarrierChangeReasonCode`	5	Bound in `clsCancelReasonOverride.BeforeInsert` (line 188)
`:CreateDate`	Input	bound from `CreateDate`	-	Bound in `clsCancelReasonOverride.BeforeInsert` (line 190)
`:CreateUser`	Input	bound from `CreateUser`	30	Bound in `clsCancelReasonOverride.BeforeInsert` (line 189)

Tables¶

Table	Access	Columns used
CANCEL_REASON_OVERRIDE	INSERT	See sample SQL

Sample SQL¶

INSERT INTO
  CANCEL_REASON_OVERRIDE
  (
    CANCEL_REASON_OVERRIDE_SEQ_NUM,
    CANCELLATION_SEQ_NUM,
    CANCEL_REASON_CODE,
    CARRIER_CODE,
    CARRIER_CHANGE_REASON_CODE,
    CREATE_DATE,
    CREATE_USER
  )
VALUES
  (
    :CancelReasonOverrideSeqNum,
    :CancellationSeqNum,
    :CancelReasonCode,
    :CarrierCode,
    :CarrierChangeReasonCode,
    :CreateDate,
    :CreateUser
  )

Operations and processes¶

Record a cancellation reason override

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