APPS.CN_PMTPLAN_PUB dependencies on CN_PMT_PLANS

Line 31: FROM cn_pmt_plans

27: l_api_name CONSTANT VARCHAR2(30) := 'Get_PmtPlan_ID';
28:
29: CURSOR get_PmtPlan_id is
30: SELECT pmt_plan_id
31: FROM cn_pmt_plans
32: WHERE name = p_PmtPlan_rec.name
33: AND start_date = p_PmtPlan_rec.start_date
34: AND end_date = p_PmtPlan_rec.end_date
35: AND org_id = p_PmtPlan_rec.org_id;

Line 40: FROM cn_pmt_plans

36:
37: --If end date is null, then use the following cursor
38: CURSOR get_PmtPlan_id2 is
39: SELECT pmt_plan_id
40: FROM cn_pmt_plans
41: WHERE name = p_PmtPlan_rec.name
42: AND start_date = p_PmtPlan_rec.start_date
43: AND org_id = p_PmtPlan_rec.org_id;
44:

Line 63: SELECT cn_pmt_plans_s.nextval

59: FETCH get_PmtPlan_id INTO l_get_PmtPlan_id_rec;
60: IF get_PmtPlan_id%ROWCOUNT = 0
61: THEN
62: x_status := 'NEW PMT PLAN';
63: SELECT cn_pmt_plans_s.nextval
64: INTO x_pmt_plan_id
65: FROM dual;
66: ELSIF get_PmtPlan_id%ROWCOUNT = 1
67: THEN

Line 78: SELECT cn_pmt_plans_s.nextval

74: FETCH get_PmtPlan_id2 INTO l_get_PmtPlan_id_rec;
75: IF get_PmtPlan_id2%ROWCOUNT = 0
76: THEN
77: x_status := 'NEW PMT PLAN';
78: SELECT cn_pmt_plans_s.nextval
79: INTO x_pmt_plan_id
80: FROM dual;
81: ELSIF get_PmtPlan_id2%ROWCOUNT = 1
82: THEN

Line 246: select start_date from cn_pmt_plans

242: l_update_rec cn_pmtplan_pvt.PmtPlan_rec_type;
243: l_update_old_rec cn_pmtplan_pvt.PmtPlan_rec_type;
244: l_status VARCHAR2(1);
245: cursor get_start_date is
246: select start_date from cn_pmt_plans
247: where name = p_PmtPlan_rec.name
248: and org_id = p_PmtPlan_rec.org_id;
249:
250: BEGIN

Line 444: l_start_date cn_pmt_plans.start_date%TYPE;

440: l_api_version CONSTANT NUMBER := 1.0;
441: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
442:
443: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;
444: l_start_date cn_pmt_plans.start_date%TYPE;
445: l_status VARCHAR2(1);
446: cursor get_start_date is
447: select start_date from cn_pmt_plans
448: where name = p_PmtPlan_rec.name

Line 447: select start_date from cn_pmt_plans

443: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;
444: l_start_date cn_pmt_plans.start_date%TYPE;
445: l_status VARCHAR2(1);
446: cursor get_start_date is
447: select start_date from cn_pmt_plans
448: where name = p_PmtPlan_rec.name
449: and org_id = p_PmtPlan_rec.org_id;
450:
451: BEGIN