APPS.CN_PMTPLAN_PVT dependencies on CN_PMTPLAN_PVT

Line 1: PACKAGE BODY CN_PMTPLAN_PVT as

1: PACKAGE BODY CN_PMTPLAN_PVT as
2: -- $Header: cnvpplnb.pls 120.11 2006/10/26 10:25:58 sjustina ship $
3: --
4: --
5: -- Procedure : Get_PmtPlan_ID

Line 40: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';

36: AND start_date = p_PmtPlan_rec.start_date
37: AND org_id = p_PmtPlan_rec.org_id;
38:
39: l_get_PmtPlan_id_rec get_PmtPlan_id%ROWTYPE;
40: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
41:
42:
43: BEGIN
44:

Line 122: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';

118: l_pg_count NUMBER;
119: l_pay_interval_type_id NUMBER;
120: l_credit_type_id NUMBER;
121: l_api_name CONSTANT VARCHAR2(30) := 'Validate_PmtPlan';
122: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
123:
124: CURSOR get_credit_type_id IS
125: SELECT credit_type_id
126: FROM cn_credit_types

Line 427: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';

423: l_recoverable_interval_type_id NUMBER;
424:
425: l_pay_against_commission VArchar2(02);
426:
427: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
428: L_LAST_UPDATE_DATE DATE := sysdate;
429: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
430: L_CREATION_DATE DATE := sysdate;
431: L_CREATED_BY NUMBER := fnd_global.user_id;

Line 760: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';

756: l_start_date DATE;
757: l_end_date DATE;
758: l_null_end_date_srps NUMBER := 0;
759:
760: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
761: L_LAST_UPDATE_DATE DATE := sysdate;
762: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
763: L_CREATION_DATE DATE := sysdate;
764: L_CREATED_BY NUMBER := fnd_global.user_id;

Line 1326: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';

1322: l_pmt_plan_id NUMBER;
1323: l_count NUMBER;
1324: l_role_count NUMBER;
1325:
1326: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
1327: L_LAST_UPDATE_DATE DATE := sysdate;
1328: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1329: L_CREATION_DATE DATE := sysdate;
1330: L_CREATED_BY NUMBER := fnd_global.user_id;

Line 1533: END CN_PmtPlan_PVT ;

1529: );
1530:
1531: END Delete_PmtPlan;
1532:
1533: END CN_PmtPlan_PVT ;