APPS.CSC_PLAN_ASSIGNMENT_PKG dependencies on CSC_CUST_PLANS_AUDIT

Line 1692: INSERT INTO csc_cust_plans_audit (

1688: into l_ins_end_date
1689: from sys.dual;
1690:
1691: FORALL i in 1..p_party_id_tbl.count
1692: INSERT INTO csc_cust_plans_audit (
1693: PLAN_AUDIT_ID, PLAN_ID, PARTY_ID,
1694: CUST_ACCOUNT_ID, PLAN_STATUS_CODE,
1695: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
1696: PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, CREATION_DATE,

Line 1705: CSC_CUST_PLANS_AUDIT_S.NEXTVAL, p_plan_id_tbl(i), p_party_id_tbl(i),

1701: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1702: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
1703: ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER )
1704: SELECT
1705: CSC_CUST_PLANS_AUDIT_S.NEXTVAL, p_plan_id_tbl(i), p_party_id_tbl(i),
1706: p_cust_id_tbl(i), CSC_CORE_UTILS_PVT.APPLY_PLAN,
1707: NULL, NULL, NULL,
1708: NULL, SYSDATE, SYSDATE,
1709: FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,

Line 1772: INSERT INTO csc_cust_plans_audit (

1768: RETURNING plan_id, party_id, cust_account_id
1769: BULK COLLECT INTO l_plan_id_tbl, l_party_id_tbl, l_cust_id_tbl;
1770:
1771: FORALL i in 1..l_party_id_tbl.count
1772: INSERT INTO csc_cust_plans_audit (
1773: PLAN_AUDIT_ID, PLAN_ID, PARTY_ID,
1774: CUST_ACCOUNT_ID, PLAN_STATUS_CODE,
1775: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
1776: PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE, CREATION_DATE,

Line 1785: CSC_CUST_PLANS_AUDIT_S.NEXTVAL, l_plan_id_tbl(i), l_party_id_tbl(i),

1781: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1782: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
1783: ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER )
1784: SELECT
1785: CSC_CUST_PLANS_AUDIT_S.NEXTVAL, l_plan_id_tbl(i), l_party_id_tbl(i),
1786: l_cust_id_tbl(i), CSC_CORE_UTILS_PVT.REMOVE_PLAN,
1787: NULL, NULL, NULL,
1788: NULL, SYSDATE, SYSDATE,
1789: FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,