SQL-092: Update paymentplantype¶

Update paymentplantype in the context of clsPaymentPlanType.

Classification¶

Field	Value
SQL ID	SQL-092
Operation type	Update
Execution method	NonQuery
Database	Oracle
Command type	Text
Schema	[unqualified]
Business object	`clsPaymentPlanType`
Criteria property	`UpdateSQL`
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:Description`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:MarketTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:PolicyRenewalTrackCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:PayrollReportScheduleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:GenerateBillingCode`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:CreateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:CreateUser`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:UpdateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:UpdateUser`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:AuditTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:AdjustedRateCalculationFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:NewPolicyPeriodDefaultFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:AdjustedRateStyleRecapFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:DisplayOrderNumber`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:PayrollByClassFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:PaymentRequiredFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.
`:CreatePFTCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanType.UpdateSQL.

Tables¶

Table	Access	Columns used
PAYMENT_PLAN_TYPE_CODE	UPDATE	See sample SQL

Sample SQL¶

Update PAYMENT_PLAN_TYPE_CODE
SET
  CODE = :Code,
  CODE_DESCR = :Description,
  MARKET_TYPE_CODE = :MarketTypeCode,
  POLICY_RENEWAL_TRACK_CODE = :PolicyRenewalTrackCode,
  PAYROLL_REPORT_SCHEDULE_FLAG = :PayrollReportScheduleFlag,
  GENERATE_BILLING_CODE = :GenerateBillingCode,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  AUDIT_TYPE_CODE = :AuditTypeCode,
  ADJUSTED_RATE_CALCULATION_FLAG = :AdjustedRateCalculationFlag,
  NEW_POLICY_PERIOD_DEFAULT_FLAG = :NewPolicyPeriodDefaultFlag,
  ADJUSTED_RATE_STYLE_RECAP_FLAG = :AdjustedRateStyleRecapFlag,
  DISPLAY_ORDER_NUM = :DisplayOrderNumber,
  PAYROLL_BY_CLASS_FLAG = :PayrollByClassFlag,
  PAYMENT_REQUIRED_FLAG = :PaymentRequiredFlag,
  CREATE_PFT_CODE = :CreatePFTCode
WHERE
  PAYMENT_PLAN_TYPE_CODE.CODE = :Code

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.Premium/Billing/clsPaymentPlanType.vb