SQL-064: Update M C O Plan

Updates an existing m c o plan record in Oracle.

Classification

Field	Value
SQL ID	SQL-064
Operation type	Update
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMCOPlan
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:McoCertNum	Input	String	6	Value from McoCertNum
:EffDate	Input	Date	N/A	Value from EffDate
:ApplyDiscountCode	Input	String	5	Value from ApplyDiscountCode
:ApplyAdminFeeCode	Input	String	5	Value from ApplyAdminFeeCode
:McoShortDescr	Input	String	20	Value from McoShortDescr
:ExpDate	Input	clsSmartDate	N/A	Value from m_ExpDate
:CaseManagementFeeAmt	Input	clsSmartDecimal	N/A	Value from m_CaseManagementFeeAmt
:ProviderLocationSeqNum	Input	clsSmartDecimal	N/A	Value from m_ProviderLocationSeqNum
:CaseManagementLateFeeAmt	Input	clsSmartDecimal	N/A	Value from m_CaseManagementLateFeeAmt
:MCOPlanID	Input	String	2	Value from MCOPlanID
:UpdateUser	Input	String	30	Value from UpdateUser
:UpdateNum	Input	Decimal	N/A	Value from UpdateNum
:UpdateDate	Input	Date	N/A	Value from UpdateDate
:MCOPlanID	Input	String	2	Value from MyCriteria.MCOPlanID

Tables

Table	Access	Columns used
MCO_PLAN	UPDATE	See business-object criteria for key columns.

Sample SQL

Update MCO_PLAN Set MCO_PLAN_ID = :MCOPlanID, MCO_CERT_NUM = :McoCertNum, EFF_DATE = :EffDate, EXP_DATE = :ExpDate, APPLY_DISCOUNT_CODE = :ApplyDiscountCode, APPLY_ADMIN_FEE_CODE = :ApplyAdminFeeCode, CASE_MANAGEMENT_FEE_AMT = :CaseManagementFeeAmt, PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum, UPDATE_USER = :UpdateUser, UPDATE_NUM = :UpdateNum, UPDATE_DATE = :UpdateDate, CASE_MANAGEMENT_LATE_FEE_AMT = :CaseManagementLateFeeAmt, MCO_SHORT_DESCR = :McoShortDescr Where MCO_PLAN.MCO_PLAN_ID = :MCOPlanID

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Provider\clsMCOPlan.vb