SQL-022: Insert cancellation reason¶

Insert cancellation reason in the context of clsCancellationReason.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:DueDays`	Input	bound from `DueDays`	-	Bound in `clsCancellationReason.BeforeInsert` (line 496)
`:GraceDueDays`	Input	bound from `GraceDueDays`	-	Bound in `clsCancellationReason.BeforeInsert` (line 497)
`:CancelDays`	Input	bound from `CancelDays`	-	Bound in `clsCancellationReason.BeforeInsert` (line 498)
`:Code`	Input	bound from `Code`	5	Bound in `clsCancellationReason.BeforeInsert` (line 499)
`:CodeDescr`	Input	bound from `CodeDescr`	65	Bound in `clsCancellationReason.BeforeInsert` (line 500)
`:NCCICancelCode`	Input	bound from `m_NCCICancelCode`	2	Bound in `clsCancellationReason.BeforeInsert` (line 510)
`:CertholderNoticeFlag`	Input	bound from `m_CertholderNoticeFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 511)
`:CancelTypeCode`	Input	bound from `CancelTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 501)
`:BatchReasonFlag`	Input	bound from `BatchReasonFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 502)
`:CHNoticeTypeCode`	Input	bound from `m_CHNoticeTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 512)
`:HoldPrintFlag`	Input	bound from `m_HoldPrintFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 513)
`:PHCancelNoticeTypeCode`	Input	bound from `m_PHCancelNoticeTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 514)
`:PHIntentNoticeTypeCode`	Input	bound from `m_PHIntentNoticeTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 515)
`:PMSCancelReasonCode`	Input	bound from `PMSCancelReasonCode`	-	Bound in `clsCancellationReason.BeforeInsert` (line 503)
`:RequestDetailFlag`	Input	bound from `RequestDetailFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 504)
`:USLHWNoticeTypeCode`	Input	bound from `m_USLHWNoticeTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 516)
`:NoticeDescription`	Input	bound from `m_NoticeDescription`	254	Bound in `clsCancellationReason.BeforeInsert` (line 517)
`:CreditReasonFlag`	Input	bound from `CreditReasonFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 505)
`:USLHWIntentNoticeTypeCode`	Input	bound from `m_USLHWIntentNoticeTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 518)
`:CancellationCategoryCode`	Input	bound from `m_CancellationCategoryCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 519)
`:ShortRateDefaultFlag`	Input	bound from `ShortRateDefaultFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 506)
`:PrintCancelNoticeFlag`	Input	bound from `PrintCancelNoticeFlag`	1	Bound in `clsCancellationReason.BeforeInsert` (line 507)
`:CancelNoticeDescription`	Input	bound from `m_CancelNoticeDescription`	254	Bound in `clsCancellationReason.BeforeInsert` (line 520)
`:DelayDays`	Input	bound from `DelayDays`	-	Bound in `clsCancellationReason.BeforeInsert` (line 508)
`:ReinstateReasonCode`	Input	bound from `m_ReinstateReasonCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 521)
`:PHReminderTypeCode`	Input	bound from `m_PHReminderTypeCode`	5	Bound in `clsCancellationReason.BeforeInsert` (line 522)
`:ARPDepositDays`	Input	bound from `ARPDepositDays`	-	Bound in `clsCancellationReason.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,
    :NoticeDescription,
    :CreditReasonFlag,
    :USLHWIntentNoticeTypeCode,
    :CancellationCategoryCode,
    :ShortRateDefaultFlag,
    :PrintCancelNoticeFlag,
    :CancelNoticeDescription,
    :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\clsCancellationReason.vb