APPS.CN_ROLE_PLANS_PUB dependencies on CN_SRP_PLAN_ASSIGNS_PVT

Line 1038: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

1034:
1035: -- dbms_output.put_line('insert into cn_srp_plan_assigns...');
1036: -- dbms_output.put_line('p_srp_role_id = ' || l_rec.srp_role_id);
1037: -- dbms_output.put_line('p_role_plan_id = ' || p_role_plan_id);
1038: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
1039: (p_api_version => 1.0,
1040: x_return_status => l_return_status,
1041: x_msg_count => l_msg_count,
1042: x_msg_data => l_msg_data,

Line 1119: cn_srp_plan_assigns_pvt.update_srp_plan_assigns

1115: FOR l_rec IN l_cur
1116: LOOP
1117: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR
1118: -- l_rec.push_status = 'PUSHED' THEN
1119: cn_srp_plan_assigns_pvt.update_srp_plan_assigns
1120: (p_api_version => 1.0,
1121: x_return_status => l_return_status,
1122: x_msg_count => l_msg_count,
1123: x_msg_data => l_msg_data,

Line 1144: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

1140: FOR l_rec_del IN l_cur_del
1141: LOOP
1142: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR
1143: -- l_rec.push_status = 'PUSHED' THEN
1144: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
1145: (p_api_version => 1.0,
1146: x_return_status => l_return_status,
1147: x_msg_count => l_msg_count,
1148: x_msg_data => l_msg_data,

Line 1164: cn_srp_plan_assigns_pvt.create_srp_plan_assigns

1160: END LOOP;
1161:
1162: FOR l_rec IN l_cur
1163: LOOP
1164: cn_srp_plan_assigns_pvt.create_srp_plan_assigns
1165: (p_api_version => 1.0,
1166: x_return_status => l_return_status,
1167: x_msg_count => l_msg_count,
1168: x_msg_data => l_msg_data,

Line 1217: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

1213: x_loading_status := p_loading_status;
1214:
1215: FOR l_rec IN l_cur
1216: LOOP
1217: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
1218: (p_api_version => 1.0,
1219: p_validation_level => fnd_api.g_valid_level_full,
1220: x_return_status => l_return_status,
1221: x_msg_count => l_msg_count,