DBA Data[Home] [Help]

APPS.CSC_CUST_PLANS_PVT dependencies on CSC_CUST_PLANS_AUDIT_PKG

Line 366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(

362:
363: -- For every operation on the CSC_CUST_PLANS table insert a record in the
364: -- CSC_CUST_PLANS_AUDIT table.
365:
366: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
367: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,

Line 780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(

776: p_ATTRIBUTE15 => l_upd_csc_cust_plans_rec.ATTRIBUTE15,
777: p_ATTRIBUTE_CATEGORY => l_upd_csc_cust_plans_rec.ATTRIBUTE_CATEGORY,
778: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
779:
780: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
781: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
782: p_PLAN_ID => l_upd_csc_cust_plans_rec.PLAN_ID ,
783: p_PARTY_ID => l_upd_csc_cust_plans_rec.PARTY_ID ,
784: p_CUST_ACCOUNT_ID => l_upd_csc_cust_plans_rec.CUST_ACCOUNT_ID ,

Line 1139: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(

1135: and party_id = nvl(p_party_id, party_id)
1136: and nvl(cust_account_id, 0) = nvl(p_cust_account_id, nvl(cust_account_id,0) )
1137: and object_version_number = p_object_version_number;
1138:
1139: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
1140: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
1141: p_PLAN_ID => P_PLAN_ID ,
1142: p_PARTY_ID => P_PARTY_ID ,
1143: p_CUST_ACCOUNT_ID => P_CUST_ACCOUNT_ID ,

Line 1256: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(

1252: p_CUST_PLAN_ID => p_CUST_PLAN_ID);
1253:
1254: -- Insert row into CSC_CUST_PLANS_AUDIT table with the selected cursor values
1255: -- and with PLAN_STATUS_CODE = 'DELETED';
1256: CSC_CUST_PLANS_AUDIT_PKG.Insert_Row(
1257: --px_PLAN_AUDIT_ID => G_PLAN_AUDIT_ID,-- will be selected from the sequence.
1258: p_PLAN_ID => c1rec.PLAN_ID ,
1259: p_PARTY_ID => c1rec.PARTY_ID ,
1260: p_CUST_ACCOUNT_ID => c1rec.CUST_ACCOUNT_ID ,