SQL-093: Update paymentplantype collection¶

Update paymentplantype collection in the context of clsPaymentPlanTypeCollection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:CodeDescr`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:MarketTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:PolicyRenewalTrackCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:PayrollReportScheduleFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:GenerateBillingCode`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:CreateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:CreateUser`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:UpdateDate`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:UpdateUser`	Input	Date	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:AuditTypeCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:AdjustedRateCalculationFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:NewPolicyPeriodDefaultFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:AdjustedRateStyleRecapFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:DisplayOrderNum`	Input	Numeric*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:PayrollBYClassFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:PaymentRequiredFlag`	Input	String (Y/N)*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.UpdateSQL.
`:CreatePftCode`	Input	String*	inferred/unknown	Bind variable in clsPaymentPlanTypeCollection.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 = :CodeDescr,
  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 = :DisplayOrderNum,
  PAYROLL_BY_CLASS_FLAG = :PayrollBYClassFlag,
  PAYMENT_REQUIRED_FLAG = :PaymentRequiredFlag,
  CREATE_PFT_CODE = :CreatePftCode Where

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/clsPaymentPlanTypeCollection.vb