APPS.CN_PMTPLAN_PVT dependencies on CN_PMT_PLANS

Line 25: FROM cn_pmt_plans

21: l_api_name CONSTANT VARCHAR2(30) := 'Get_PmtPlan_ID';
22:
23: CURSOR get_PmtPlan_id is
24: SELECT pmt_plan_id
25: FROM cn_pmt_plans
26: WHERE name = p_PmtPlan_rec.name
27: AND start_date = p_PmtPlan_rec.start_date
28: AND end_date = p_PmtPlan_rec.end_date
29: AND org_id = p_PmtPlan_rec.org_id;

Line 34: FROM cn_pmt_plans

30:
31: --If end date is null, then use the following cursor
32: CURSOR get_PmtPlan_id2 is
33: SELECT pmt_plan_id
34: FROM cn_pmt_plans
35: WHERE name = p_PmtPlan_rec.name
36: AND start_date = p_PmtPlan_rec.start_date
37: AND org_id = p_PmtPlan_rec.org_id;
38:

Line 59: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)

55: FETCH get_PmtPlan_id INTO l_get_PmtPlan_id_rec;
56: IF get_PmtPlan_id%ROWCOUNT = 0
57: THEN
58: x_status := 'NEW PMT PLAN';
59: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)
60: INTO x_pmt_plan_id
61: FROM dual;
62: ELSIF get_PmtPlan_id%ROWCOUNT = 1
63: THEN

Line 74: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)

70: FETCH get_PmtPlan_id2 INTO l_get_PmtPlan_id_rec;
71: IF get_PmtPlan_id2%ROWCOUNT = 0
72: THEN
73: x_status := 'NEW PMT PLAN';
74: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)
75: INTO x_pmt_plan_id
76: FROM dual;
77:
78: ELSIF get_PmtPlan_id2%ROWCOUNT = 1

Line 318: FROM cn_pmt_plans

314: -- Since payment plan names are unique in an org, check if a record already exists with the same name.
315:
316: SELECT COUNT(*)
317: INTO l_count
318: FROM cn_pmt_plans
319: WHERE name = p_PmtPlan_rec.name
320: and org_id = p_PmtPlan_rec.org_id;
321:
322: IF (l_count <> 0) THEN

Line 401: -- CN_Pmt_Plans_Pkg.Begin_Record

397: --
398: -- Procedure : Create_PmtPlan
399: -- Description: Public API to create a pmt plan
400: -- Calls : validate_pmt_plan
401: -- CN_Pmt_Plans_Pkg.Begin_Record
402: --
403: PROCEDURE Create_PmtPlan(
404: p_api_version IN NUMBER,
405: p_init_msg_list IN VARCHAR2 ,

Line 613: CN_Pmt_Plans_Pkg.Begin_Record

609: x_loading_status := 'CCN_INVALID_REC_AND_PAC';
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:
613: CN_Pmt_Plans_Pkg.Begin_Record
614: (
615: x_operation => 'INSERT',
616: x_rowid => L_ROWID,
617: x_org_id => p_PmtPlan_rec.org_id,

Line 727: -- CN_Pmt_Plans_Pkg.Begin_Record

723: --
724: -- Procedure : Update PmtPlan
725: -- Description : This is a public procedure to update pmt plans
726: -- Calls : validate_pmt_plan
727: -- CN_Pmt_Plans_Pkg.Begin_Record
728: --
729:
730: PROCEDURE Update_PmtPlan (
731: p_api_version IN NUMBER,

Line 784: FROM cn_pmt_plans

780: AND org_id = p_PmtPlan_rec.org_id;
781:
782: CURSOR get_pmt_plan (p_pmt_plan_id NUMBER) IS
783: SELECT *
784: FROM cn_pmt_plans
785: WHERE pmt_plan_id = p_pmt_plan_id
786: AND org_id = p_PmtPlan_rec.org_id;
787:
788: l_pp_rec get_pmt_plan%ROWTYPE;

Line 807: FROM cn_pmt_plans

803: AND org_id = p_PmtPlan_rec.org_id;
804:
805: CURSOR l_ovn_csr IS
806: SELECT nvl(object_version_number,1)
807: FROM cn_pmt_plans
808: WHERE pmt_plan_id = p_old_PmtPlan_rec.pmt_plan_id
809: AND org_id = p_old_PmtPlan_rec.org_id;
810:
811: l_object_version_number NUMBER;

Line 1204: Cn_Pmt_Plans_Pkg.Begin_Record(

1200: x_loading_status := 'CN_INVALID_REC_AND_PAC';
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203:
1204: Cn_Pmt_Plans_Pkg.Begin_Record(
1205: x_operation => 'UPDATE',
1206: x_rowid => L_ROWID,
1207: x_org_id => p_PmtPlan_rec.org_id,
1208: x_pmt_plan_id => l_pmt_plan_id,

Line 1435: cn_pmt_plans_pkg.begin_record

1431: x_loading_status := 'CN_DELETE_NA';
1432: RAISE FND_API.G_EXC_ERROR;
1433: END IF;
1434:
1435: cn_pmt_plans_pkg.begin_record
1436: (
1437: x_operation => 'DELETE',
1438: x_rowid => L_ROWID,
1439: x_org_id => p_PmtPlan_rec.org_id,