SQL-016: Insert M C O Plan

Inserts a new m c o plan record into Oracle.

Classification

Field	Value
SQL ID	SQL-016
Operation type	Create
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMCOPlan
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

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	INSERT	See business-object criteria for key columns.

Sample SQL

Insert into MCO_PLAN ( MCO_PLAN_ID, MCO_CERT_NUM, EFF_DATE, EXP_DATE, APPLY_DISCOUNT_CODE, APPLY_ADMIN_FEE_CODE, CASE_MANAGEMENT_FEE_AMT, PROVIDER_LOCATION_SEQ_NUM, UPDATE_USER, UPDATE_NUM, UPDATE_DATE, CASE_MANAGEMENT_LATE_FEE_AMT, MCO_SHORT_DESCR ) Values ( :MCOPlanID, :McoCertNum, :EffDate, :ExpDate, :ApplyDiscountCode, :ApplyAdminFeeCode, :CaseManagementFeeAmt, :ProviderLocationSeqNum, :UpdateUser, :UpdateNum, :UpdateDate, :CaseManagementLateFeeAmt, :McoShortDescr)

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

Sources

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