eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PLAN_ASSIGNMENT_PKG dependencies on CSC_CUST_PLANS

Line 16: -- insert into CSC_CUST_PLANS. ie cust_account_id and org.

12: -- MM-DD-YYYY NAME MODIFICATIONS
13: -- 12-16-1999 dejoseph Created.
14: -- 01-03-2000 dejoseph 'Arcs'ed in for third code freeze. (10-JAN-2000)
15: -- 01-25-2000 dejoseph Added where condition in the NOT EXISTS sub query of the bulk
16: -- insert into CSC_CUST_PLANS. ie cust_account_id and org.
17: -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)
18: -- 02-13-2000 dejoseph 'Arcs'ed on for fifth code freeze. (21-FEB-2000)
19: -- 02-28-2000 dejoseph 'Arcs'ed on for sixth code freeze. (06-MAR-2000)
20: -- 03-28-2000 dejoseph Removed references to CUST_ACCOUNT_ID and ORG_ID from all

Line 86: -- no. of recs that are inserted into CSC_CUST_PLANS

82:
83: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_ASSIGNMENT_PKG';
84: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvengb.pls';
85: G_COMMIT_TIME CONSTANT NUMBER := 1000;
86: -- no. of recs that are inserted into CSC_CUST_PLANS
87: G_ERRBUF VARCHAR2(2000) := NULL;
88: -- the error text from SQLERRM
89: G_MESG VARCHAR2(2000); -- message into log files.
90: G_MESG_LINE VARCHAR2(2000); -- has single lines of error text

Line 94: -- plans need to be added to this customer in the CSC_CUST_PLANS table.

90: G_MESG_LINE VARCHAR2(2000); -- has single lines of error text
91:
92: -- The following tables stores the column values of all the plans that
93: -- a customer satisfies. It has an 'add' in its name to denote that these
94: -- plans need to be added to this customer in the CSC_CUST_PLANS table.
95: G_PLAN_ID_ADD_TBL CSC_PLAN_ID_TBL_TYPE;
96: G_PARTY_ID_ADD_TBL CSC_PARTY_ID_TBL_TYPE;
97: G_CUST_ID_ADD_TBL CSC_CUST_ID_TBL_TYPE;
98: G_START_DATE_ACTIVE_ADD_TBL CSC_DATE_TBL_TYPE;

Line 104: -- name to denote that these rows need to be deleted from CSC_CUST_PLANS

100: G_ADD_IDX NUMBER := 0; -- index for add tables
101:
102: -- The following tables stores plan and customer information, when a
103: -- customer no longer satisfies a plan criteria. It has a 'del' to its
104: -- name to denote that these rows need to be deleted from CSC_CUST_PLANS
105: -- table.
106: G_PLAN_ID_DEL_TBL CSC_PLAN_ID_TBL_TYPE;
107: G_PARTY_ID_DEL_TBL CSC_PARTY_ID_TBL_TYPE;
108: G_CUST_ID_DEL_TBL CSC_CUST_ID_TBL_TYPE;

Line 1300: -- plans need to be added to this customer in the CSC_CUST_PLANS table.

1296: l_assign_plan VARCHAR2(1) := NULL;
1297:
1298: -- The following tables stores the column values of all the plans that
1299: -- a customer satisfies. It has an 'add' in its name to denote that these
1300: -- plans need to be added to this customer in the CSC_CUST_PLANS table.
1301: L_PLAN_ID_ADD_TBL CSC_PLAN_ID_TBL_TYPE;
1302: L_PARTY_ID_ADD_TBL CSC_PARTY_ID_TBL_TYPE;
1303: L_CUST_ID_ADD_TBL CSC_CUST_ID_TBL_TYPE;
1304: L_START_DATE_ACTIVE_ADD_TBL CSC_DATE_TBL_TYPE;

Line 1310: -- name to denote that these rows need to be deleted from CSC_CUST_PLANS

1306: L_ADD_IDX NUMBER := 0; -- index for add tables
1307:
1308: -- The following tables stores plan and customer information, when a
1309: -- customer no longer satisfies a plan criteria. It has a 'del' to its
1310: -- name to denote that these rows need to be deleted from CSC_CUST_PLANS
1311: -- table.
1312: L_PLAN_ID_DEL_TBL CSC_PLAN_ID_TBL_TYPE;
1313: L_PARTY_ID_DEL_TBL CSC_PARTY_ID_TBL_TYPE;
1314: L_CUST_ID_DEL_TBL CSC_CUST_ID_TBL_TYPE;

Line 1626: -- Dates to track the start and end time of the bulk insert into CSC_CUST_PLANS.

1622: IS
1623: l_api_name CONSTANT VARCHAR2(30) := 'ADD_CUST_PLANS';
1624: l_api_version_number CONSTANT NUMBER := 1.0;
1625:
1626: -- Dates to track the start and end time of the bulk insert into CSC_CUST_PLANS.
1627: -- These are then used as a filter in the bulk insert of the AUDIT table.
1628: l_ins_start_date DATE;
1629: l_ins_end_date DATE;
1630:

Line 1653: INSERT INTO csc_cust_plans (

1649: into l_ins_start_date
1650: from sys.dual;
1651:
1652: FORALL i in 1..p_plan_id_tbl.count
1653: INSERT INTO csc_cust_plans (
1654: CUST_PLAN_ID, PLAN_ID, PARTY_ID,
1655: CUST_ACCOUNT_ID, START_DATE_ACTIVE,
1656: END_DATE_ACTIVE, MANUAL_FLAG, PLAN_STATUS_CODE,
1657: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 1667: CSC_CUST_PLANS_S.NEXTVAL, p_plan_id_tbl(i), p_party_id_tbl(i),

1663: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
1664: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
1665: ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER )
1666: SELECT
1667: CSC_CUST_PLANS_S.NEXTVAL, p_plan_id_tbl(i), p_party_id_tbl(i),
1668: p_cust_id_tbl(i), p_start_date_active_tbl(i),
1669: p_end_date_active_tbl(i), 'N', CSC_CORE_UTILS_PVT.APPLY_PLAN,
1670: NULL, NULL, NULL,
1671: NULL, sysdate, sysdate,

Line 1681: from csc_cust_plans

1677: NULL, NULL, NULL,
1678: NULL, 1
1679: FROM SYS.DUAL
1680: WHERE NOT EXISTS ( select 1
1681: from csc_cust_plans
1682: where plan_id = p_plan_id_tbl(i)
1683: and party_id = p_party_id_tbl(i)
1684: and nvl(cust_account_id, 0) = nvl(p_cust_id_tbl(i), 0)
1685: );

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 1718: from csc_cust_plans

1714: NULL, NULL, NULL,
1715: NULL, 1
1716: FROM SYS.DUAL
1717: WHERE EXISTS ( select 1
1718: from csc_cust_plans
1719: where plan_id = p_plan_id_tbl(i)
1720: and party_id = p_party_id_tbl(i)
1721: and creation_date between l_ins_start_date and l_ins_end_date);
1722:

Line 1763: DELETE FROM csc_cust_plans

1759: RAISE FND_API.G_EXC_ERROR;
1760: END IF;
1761:
1762: FORALL i in 1..P_PLAN_ID_TBL.COUNT
1763: DELETE FROM csc_cust_plans
1764: WHERE plan_id = p_plan_id_tbl(i)
1765: AND party_id = p_party_id_tbl(i)
1766: AND nvl(cust_account_id,0) = nvl(p_cust_id_tbl(i), nvl(cust_account_id,0) )
1767: AND manual_flag = 'N'

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,