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:
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
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,
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
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
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,
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
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,
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