APPS.CN_PMTPLAN_PUB dependencies on CN_PMTPLAN_PVT

Line 104: -- Calls : CN_PMTPLAN_PVT.Create_PmtPlan

100:
101: --------------------------------------------------------------------------*
102: -- Procedure : Create_PmtPlan
103: -- Description: Public API to create a pmt plan
104: -- Calls : CN_PMTPLAN_PVT.Create_PmtPlan
105: --------------------------------------------------------------------------*
106: PROCEDURE Create_PmtPlan(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 ,

Line 124: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;

120: l_api_name CONSTANT VARCHAR2(30) := 'Create_PmtPlan';
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123:
124: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;
125: l_payment_grp_code varchar2(40);
126: l_status VARCHAR2(1);
127:
128: BEGIN

Line 162: CN_PMTPLAN_PVT.Create_PmtPlan

158: l_create_rec.pay_against_commission := 'Y';
159: end if;
160:
161:
162: CN_PMTPLAN_PVT.Create_PmtPlan
163: (p_api_version => p_api_version,
164: p_init_msg_list => p_init_msg_list,
165: p_commit => p_commit,
166: p_validation_level => p_validation_level,

Line 206: -- Calls : CN_PMTPLAN_PVT.Update_PmtPlan

202:
203: ---------------------------------------------------------------------------*
204: -- Procedure : Update PmtPlan
205: -- Description : This is a public procedure to update pmt plans
206: -- Calls : CN_PMTPLAN_PVT.Update_PmtPlan
207: ---------------------------------------------------------------------------*
208:
209: PROCEDURE Update_PmtPlan (
210: p_api_version IN NUMBER,

Line 242: l_update_rec cn_pmtplan_pvt.PmtPlan_rec_type;

238: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
239: L_ROWID VARCHAR2(30);
240: L_PROGRAM_TYPE VARCHAR2(30);
241:
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

Line 243: l_update_old_rec cn_pmtplan_pvt.PmtPlan_rec_type;

239: L_ROWID VARCHAR2(30);
240: L_PROGRAM_TYPE VARCHAR2(30);
241:
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

Line 361: CN_PMTPLAN_PVT.Update_PmtPlan

357: x_status => x_status
358: );
359:
360: l_update_rec.pmt_plan_id := l_pmt_plan_id;
361: CN_PMTPLAN_PVT.Update_PmtPlan
362: (p_api_version => p_api_version,
363: p_init_msg_list => p_init_msg_list,
364: p_commit => p_commit,
365: p_validation_level => p_validation_level,

Line 443: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;

439: l_api_name CONSTANT VARCHAR2(30) := 'Delete_PmtPlan';
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

Line 470: CN_PMTPLAN_PVT.Delete_PmtPlan

466: FETCH get_start_date INTO l_create_rec.start_date;
467: END IF;
468:
469: -- call the private package for deleting the payment plan
470: CN_PMTPLAN_PVT.Delete_PmtPlan
471: (p_api_version => p_api_version,
472: p_init_msg_list => p_init_msg_list,
473: p_commit => p_commit,
474: p_validation_level => p_validation_level,