DBA Data[Home] [Help]

APPS.CN_WKSHT_CT_UP_PUB dependencies on CN_SRP_PMT_PLANS_PUB

Line 218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

214: ) IS
215:
216: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_Upd';
217: l_api_version CONSTANT NUMBER := 1.0;
218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
220:
221: --Bug 3670308 by Julia Huang on 6/4/04
222: CURSOR get_wksht IS

Line 219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

215:
216: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_Upd';
217: l_api_version CONSTANT NUMBER := 1.0;
218: oldrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
219: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
220:
221: --Bug 3670308 by Julia Huang on 6/4/04
222: CURSOR get_wksht IS
223: SELECT pw.payment_worksheet_id,

Line 293: CN_SRP_PMT_PLANS_PUB.Update_Srp_Pmt_Plan

289: newrec.end_date := p_srp_pmt_plans_rec.end_date;
290:
291: x_loading_status := 'CN_UPDATED';
292:
293: CN_SRP_PMT_PLANS_PUB.Update_Srp_Pmt_Plan
294: ( p_api_version => p_api_version,
295: p_init_msg_list => p_init_msg_list,
296: p_commit => p_commit,
297: p_validation_level=> p_validation_level,

Line 416: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

412: ) IS
413:
414: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_del';
415: l_api_version CONSTANT NUMBER := 1.0;
416: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
417:
418: --Bug 3670308 by Julia Huang on 6/4/04
419: CURSOR get_wksht IS
420: SELECT pw.payment_worksheet_id,

Line 516: CN_SRP_PMT_PLANS_PUB.Delete_Srp_Pmt_Plan

512: newrec.maximum_amount := p_srp_pmt_plans_rec.maximum_amount;
513: newrec.start_date := p_srp_pmt_plans_rec.start_date;
514: newrec.end_date := p_srp_pmt_plans_rec.end_date;
515:
516: CN_SRP_PMT_PLANS_PUB.Delete_Srp_Pmt_Plan
517: ( p_api_version => p_api_version,
518: p_init_msg_list => p_init_msg_list,
519: p_commit => p_commit,
520: p_validation_level=> p_validation_level,

Line 629: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;

625: ) IS
626:
627: l_api_name CONSTANT VARCHAR2(30) := 'Apply_Payment_Plan_del';
628: l_api_version CONSTANT NUMBER := 1.0;
629: newrec CN_SRP_PMT_PLANS_PUB.srp_pmt_plans_rec_type;
630:
631: --Bug 3670308 by Julia Huang on 6/4/04
632: CURSOR get_wksht IS
633: /*

Line 746: CN_SRP_PMT_PLANS_PUB.Create_Srp_Pmt_Plan

742: newrec.maximum_amount := p_srp_pmt_plans_rec.maximum_amount;
743: newrec.start_date := p_srp_pmt_plans_rec.start_date;
744: newrec.end_date := p_srp_pmt_plans_rec.end_date;
745:
746: CN_SRP_PMT_PLANS_PUB.Create_Srp_Pmt_Plan
747: ( p_api_version => p_api_version,
748: p_init_msg_list => p_init_msg_list,
749: p_commit => p_commit,
750: p_validation_level=> p_validation_level,