SQL-124: Update cancellation warning

Update cancellation warning in the context of clsCancellationWarning.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:BatchProcessedFlag	Input	bound from BatchProcessedFlag	1	Bound in clsCancellationWarning.BeforeUpdate (line 647)
:CancellationSeqNum	Input	bound from CancellationSeqNum	-	Bound in clsCancellationWarning.BeforeUpdate (line 648)
:PolicyNum	Input	bound from m_PolicyNum	-	Bound in clsCancellationWarning.BeforeUpdate (line 486)
:CancelDate	Input	bound from m_CancelDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 652)
:CancelUser	Input	bound from m_CancelUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 653)
:NoticeOFIntentDate	Input	bound from m_NoticeOfIntentDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 654)
:NoticeOFIntentUser	Input	bound from m_NoticeOfIntentUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 655)
:ReinstateReasonCode	Input	bound from m_ReinstateReasonCode	5	Bound in clsCancellationWarning.BeforeUpdate (line 656)
:CancelReasonCode	Input	bound from m_CancelReasonCode	5	Bound in clsCancellationWarning.BeforeUpdate (line 657)
:RescindDate	Input	bound from m_RescindDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 658)
:RescindUser	Input	bound from m_RescindUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 659)
:ReinstateDate	Input	bound from m_ReinstateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 660)
:ReinstateUser	Input	bound from m_ReinstateUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 661)
:ReinstatementFeeFlag	Input	bound from m_ReinstatementFeeFlag	1	Bound in clsCancellationWarning.BeforeUpdate (line 662)
:CreateDate	Input	bound from CreateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 650)
:CreateUser	Input	bound from CreateUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 651)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsCancellationWarning.BeforeUpdate (line 663)
:RescindUpdateDate	Input	bound from m_RescindUpdateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 664)
:CancelUpdateDate	Input	bound from m_CancelUpdateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 665)
:ReinstateUpdateDate	Input	bound from m_ReinstateUpdateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 666)
:NoticeOFIntentUpdateDate	Input	bound from m_NoticeOfIntentUpdateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 667)
:FuturePlpStatusCode	Input	bound from m_FuturePLPStatusCode	5	Bound in clsCancellationWarning.BeforeUpdate (line 668)
:CancelRequestorName	Input	bound from m_CancelRequestorName	50	Bound in clsCancellationWarning.BeforeUpdate (line 669)
:CancelRequestMethodCode	Input	bound from m_CancelRequestMethodCode	5	Bound in clsCancellationWarning.BeforeUpdate (line 670)
:RequestDate	Input	bound from m_RequestDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 671)
:ShortRateFlag	Input	bound from m_ShortRateFlag	1	Bound in clsCancellationWarning.BeforeUpdate (line 672)
:UpdateDate	Input	bound from m_UpdateDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 673)
:CarrierCode	Input	bound from m_CarrierCode	5	Bound in clsCancellationWarning.BeforeUpdate (line 674)
:ReinstateRequestDate	Input	bound from m_ReinstateRequestDate	-	Bound in clsCancellationWarning.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 clsCancellationWarning.BeforeUpdate (line 677)
:NoticeOFReminderDate	Input	bound from m_NoticeOfReminderDate	-	Bound in clsCancellationWarning.BeforeUpdate (line 678)
:CancellationTrackCode	Input	bound from m_CancellationTrackCode	5	Bound in clsCancellationWarning.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

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