SQL-125: Update cancellation warning collection¶

Update cancellation warning collection in the context of clsCancellationWarningCollection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:BatchProcessedFlag`	Input	bound from `BatchProcessedFlag`	1	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 647)
`:CancellationSeqNum`	Input	bound from `CancellationSeqNum`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 648)
`:PolicyNum`	Input	bound from `MyCriteria.PolicyNum`	-	Bound in `clsCancellationWarningCollection.BeforeRetrieve` (line 249)
`:CancelDate`	Input	bound from `m_CancelDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 652)
`:CancelUser`	Input	bound from `m_CancelUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 653)
`:NoticeOFIntentDate`	Input	bound from `m_NoticeOfIntentDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 654)
`:NoticeOFIntentUser`	Input	bound from `m_NoticeOfIntentUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 655)
`:ReinstateReasonCode`	Input	bound from `m_ReinstateReasonCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 601)
`:CancelReasonCode`	Input	bound from `m_CancelReasonCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 657)
`:RescindDate`	Input	bound from `m_RescindDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 658)
`:RescindUser`	Input	bound from `m_RescindUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 659)
`:ReinstateDate`	Input	bound from `m_ReinstateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 660)
`:ReinstateUser`	Input	bound from `m_ReinstateUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 661)
`:ReinstatementFeeFlag`	Input	bound from `m_ReinstatementFeeFlag`	1	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 662)
`:CreateDate`	Input	bound from `CreateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 650)
`:CreateUser`	Input	bound from `CreateUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 651)
`:UpdateUser`	Input	bound from `m_UpdateUser`	30	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 663)
`:RescindUpdateDate`	Input	bound from `m_RescindUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 664)
`:CancelUpdateDate`	Input	bound from `m_CancelUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 665)
`:ReinstateUpdateDate`	Input	bound from `m_ReinstateUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 666)
`:NoticeOFIntentUpdateDate`	Input	bound from `m_NoticeOfIntentUpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 667)
`:FuturePlpStatusCode`	Input	bound from `m_FuturePLPStatusCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 668)
`:CancelRequestorName`	Input	bound from `m_CancelRequestorName`	50	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 669)
`:CancelRequestMethodCode`	Input	bound from `m_CancelRequestMethodCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 670)
`:RequestDate`	Input	bound from `m_RequestDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 671)
`:ShortRateFlag`	Input	bound from `m_ShortRateFlag`	1	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 672)
`:UpdateDate`	Input	bound from `m_UpdateDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 673)
`:CarrierCode`	Input	bound from `m_CarrierCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 674)
`:ReinstateRequestDate`	Input	bound from `m_ReinstateRequestDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 675)
`:PremHistSetID`	Input	unknown	-	Bind variable present in SQL text; no matching `AddParm` located - unknown**
`:PolicyMemoSeqNum`	Input	bound from `m_PolicyMemoSeqNum`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 677)
`:NoticeOFReminderDate`	Input	bound from `m_NoticeOfReminderDate`	-	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 678)
`:CancellationTrackCode`	Input	bound from `m_CancellationTrackCode`	5	Bound in `clsCancellationWarningCollection.BeforeUpdate` (line 679)

Tables¶

Table	Access	Columns used
CANCELLATION	UPDATE	See sample SQL

Sample SQL¶

UPDATE
  CANCELLATION
SET
  BATCH_PROCESSED_FLAG = :BatchProcessedFlag,
  CANCELLATION_SEQ_NUM = :CancellationSeqNum,
  POLICY_NUM = :PolicyNum,
  CANCEL_DATE = :CancelDate,
  CANCEL_USER = :CancelUser,
  NOTICE_OF_INTENT_DATE = :NoticeOFIntentDate,
  NOTICE_OF_INTENT_USER = :NoticeOFIntentUser,
  REINSTATE_REASON_CODE = :ReinstateReasonCode,
  CANCEL_REASON_CODE = :CancelReasonCode,
  RESCIND_DATE = :RescindDate,
  RESCIND_USER = :RescindUser,
  REINSTATE_DATE = :ReinstateDate,
  REINSTATE_USER = :ReinstateUser,
  REINSTATEMENT_FEE_FLAG = :ReinstatementFeeFlag,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_USER = :UpdateUser,
  RESCIND_UPDATE_DATE = :RescindUpdateDate,
  CANCEL_UPDATE_DATE = :CancelUpdateDate,
  REINSTATE_UPDATE_DATE = :ReinstateUpdateDate,
  NOTICE_OF_INTENT_UPDATE_DATE = :NoticeOFIntentUpdateDate,
  FUTURE_PLP_STATUS_CODE = :FuturePlpStatusCode,
  CANCEL_REQUESTOR_NAME = :CancelRequestorName,
  CANCEL_REQUEST_METHOD_CODE = :CancelRequestMethodCode,
  REQUEST_DATE = :RequestDate,
  SHORT_RATE_FLAG = :ShortRateFlag,
  UPDATE_DATE = :UpdateDate,
  CARRIER_CODE = :CarrierCode,
  REINSTATE_REQUEST_DATE = :ReinstateRequestDate,
  PREM_HIST_SET_ID = :PremHistSetID,
  POLICY_MEMO_SEQ_NUM = :PolicyMemoSeqNum,
  NOTICE_OF_REMINDER_DATE = :NoticeOFReminderDate,
  CANCELLATION_TRACK_CODE = :CancellationTrackCode
WHERE
  CANCELLATION.POLICY_NUM = :PolicyNum

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