SQL-023: Insert cancellation reason collection¶

Insert cancellation reason collection in the context of clsCancellationReasonCollection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:DueDays`	Input	bound from `DueDays`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 496)
`:GraceDueDays`	Input	bound from `GraceDueDays`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 497)
`:CancelDays`	Input	bound from `CancelDays`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 498)
`:Code`	Input	bound from `Code`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 499)
`:CodeDescr`	Input	bound from `CodeDescr`	65	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 500)
`:NcciCancelCode`	Input	bound from `m_NCCICancelCode`	2	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 510)
`:CertholderNoticeFlag`	Input	bound from `m_CertholderNoticeFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 511)
`:CancelTypeCode`	Input	bound from `CancelTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 501)
`:BatchReasonFlag`	Input	bound from `BatchReasonFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 502)
`:CHNoticeTypeCode`	Input	bound from `m_CHNoticeTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 512)
`:HoldPrintFlag`	Input	bound from `m_HoldPrintFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 513)
`:PHCancelNoticeTypeCode`	Input	bound from `m_PHCancelNoticeTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 514)
`:PHIntentNoticeTypeCode`	Input	bound from `m_PHIntentNoticeTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 515)
`:PmsCancelReasonCode`	Input	bound from `PMSCancelReasonCode`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 503)
`:RequestDetailFlag`	Input	bound from `RequestDetailFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 504)
`:UslhwNoticeTypeCode`	Input	bound from `m_USLHWNoticeTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 516)
`:NoticeDesc`	Input	unknown	-	Bind variable present in SQL text; no matching `AddParm` located - unknown**
`:CreditReasonFlag`	Input	bound from `CreditReasonFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 505)
`:UslhwIntentNoticeTypeCode`	Input	bound from `m_USLHWIntentNoticeTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 518)
`:CancellationCategoryCode`	Input	bound from `m_CancellationCategoryCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 519)
`:ShortRateDefaultFlag`	Input	bound from `ShortRateDefaultFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 506)
`:PrintCancelNoticeFlag`	Input	bound from `PrintCancelNoticeFlag`	1	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 507)
`:CancelNoticeDescr`	Input	unknown	-	Bind variable present in SQL text; no matching `AddParm` located - unknown**
`:DelayDays`	Input	bound from `DelayDays`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 508)
`:ReinstateReasonCode`	Input	bound from `m_ReinstateReasonCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 521)
`:PHReminderTypeCode`	Input	bound from `m_PHReminderTypeCode`	5	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 522)
`:ArpDepositDays`	Input	bound from `ARPDepositDays`	-	Bound in `clsCancellationReasonCollection.BeforeInsert` (line 509)

Tables¶

Table	Access	Columns used
CANCEL_REASON_CODE	INSERT	See sample SQL

Sample SQL¶

INSERT INTO
  CANCEL_REASON_CODE
  (
    DUE_DAYS,
    GRACE_DUE_DAYS,
    CANCEL_DAYS,
    CODE,
    CODE_DESCR,
    NCCI_CANCEL_CODE,
    CERTHOLDER_NOTICE_FLAG,
    CANCEL_TYPE_CODE,
    BATCH_REASON_FLAG,
    CH_NOTICE_TYPE_CODE,
    HOLD_PRINT_FLAG,
    PH_CANCEL_NOTICE_TYPE_CODE,
    PH_INTENT_NOTICE_TYPE_CODE,
    PMS_CANCEL_REASON_CODE,
    REQUEST_DETAIL_FLAG,
    USLHW_NOTICE_TYPE_CODE,
    NOTICE_DESC,
    CREDIT_REASON_FLAG,
    USLHW_INTENT_NOTICE_TYPE_CODE,
    CANCELLATION_CATEGORY_CODE,
    SHORT_RATE_DEFAULT_FLAG,
    PRINT_CANCEL_NOTICE_FLAG,
    CANCEL_NOTICE_DESCR,
    DELAY_DAYS,
    REINSTATE_REASON_CODE,
    PH_REMINDER_TYPE_CODE,
    ARP_DEPOSIT_DAYS
  )
VALUES
  (
    :DueDays,
    :GraceDueDays,
    :CancelDays,
    :Code,
    :CodeDescr,
    :NcciCancelCode,
    :CertholderNoticeFlag,
    :CancelTypeCode,
    :BatchReasonFlag,
    :CHNoticeTypeCode,
    :HoldPrintFlag,
    :PHCancelNoticeTypeCode,
    :PHIntentNoticeTypeCode,
    :PmsCancelReasonCode,
    :RequestDetailFlag,
    :UslhwNoticeTypeCode,
    :NoticeDesc,
    :CreditReasonFlag,
    :UslhwIntentNoticeTypeCode,
    :CancellationCategoryCode,
    :ShortRateDefaultFlag,
    :PrintCancelNoticeFlag,
    :CancelNoticeDescr,
    :DelayDays,
    :ReinstateReasonCode,
    :PHReminderTypeCode,
    :ArpDepositDays
  )

Operations and processes¶

Record a cancellation reason override

Business rules¶

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