APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_SRP_PMT_PLANS

Line 115: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

111:
112: l_return_status VARCHAR2(200);
113: l_msg_count NUMBER;
114: l_msg_data VARCHAR2(2000);
115: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
116: l_loading_status VARCHAR2(2000);
117:
118: BEGIN
119:

Line 125: debugmsg('insert into cn_srp_pmt_plans...');

121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: x_loading_status := p_loading_status;
123:
124: FOR l_rec IN l_cur LOOP
125: debugmsg('insert into cn_srp_pmt_plans...');
126: debugmsg('p_srp_role_id = ' || p_srp_role_id);
127: debugmsg('l_rec.role_pmt_plan_id = ' || l_rec.role_pmt_plan_id);
128:
129: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan

Line 129: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan

125: debugmsg('insert into cn_srp_pmt_plans...');
126: debugmsg('p_srp_role_id = ' || p_srp_role_id);
127: debugmsg('l_rec.role_pmt_plan_id = ' || l_rec.role_pmt_plan_id);
128:
129: cn_srp_pmt_plans_pvt.create_mass_asgn_srp_pmt_plan
130: (p_api_version => 1.0,
131: x_return_status => l_return_status,
132: x_msg_count => l_msg_count,
133: x_msg_data => l_msg_data,

Line 417: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

413: l_rec l_cur%ROWTYPE;
414: l_return_status VARCHAR2(2000);
415: l_msg_count NUMBER;
416: l_msg_data VARCHAR2(2000);
417: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
418: l_loading_status VARCHAR2(2000);
419: created_in_osc BOOLEAN;
420:
421: BEGIN

Line 429: debugmsg('update cn_srp_pmt_plans.......');

425: x_loading_status := p_loading_status;
426:
427: FOR l_rec IN l_cur LOOP
428:
429: debugmsg('update cn_srp_pmt_plans.......');
430: debugmsg('p_srp_role_id = ' || p_srp_role_id);
431: debugmsg('l_rec.role_pmt_plan_id = ' || l_rec.role_pmt_plan_id);
432:
433: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan

Line 433: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan

429: debugmsg('update cn_srp_pmt_plans.......');
430: debugmsg('p_srp_role_id = ' || p_srp_role_id);
431: debugmsg('l_rec.role_pmt_plan_id = ' || l_rec.role_pmt_plan_id);
432:
433: cn_srp_pmt_plans_pvt.update_mass_asgn_srp_pmt_plan
434: (p_api_version => 1.0,
435: x_return_status => l_return_status,
436: x_msg_count => l_msg_count,
437: x_msg_data => l_msg_data,

Line 581: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

577: l_rec l_cur%ROWTYPE;
578: l_return_status VARCHAR2(2000);
579: l_msg_count NUMBER;
580: l_msg_data VARCHAR2(2000);
581: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
582: l_loading_status VARCHAR2(2000);
583:
584: BEGIN
585: -- Initialize API return status to success

Line 590: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan

586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587: x_loading_status := p_loading_status;
588:
589: FOR l_rec IN l_cur LOOP
590: cn_srp_pmt_plans_pvt.delete_mass_asgn_srp_pmt_plan
591: (p_api_version => 1.0,
592: p_init_msg_list => fnd_api.g_false,
593: p_commit => fnd_api.g_false,
594: p_validation_level => fnd_api.g_valid_level_full,

Line 715: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;

711: l_rec l_cur%ROWTYPE;
712: l_return_status VARCHAR2(2000);
713: l_msg_count NUMBER;
714: l_msg_data VARCHAR2(2000);
715: l_srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE;
716: l_loading_status VARCHAR2(2000);
717:
718: BEGIN
719: -- Initialize API return status to success