APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 740: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

736:
737: l_return_status VARCHAR2(2000);
738: l_msg_count NUMBER;
739: l_msg_data VARCHAR2(2000);
740: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
741: l_loading_status VARCHAR2(2000);
742:
743: BEGIN
744:

Line 752: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

748:
749: FOR l_rec IN l_cur
750: LOOP
751:
752: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
753: (
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_false,
756: p_commit => fnd_api.g_false,

Line 837: FROM cn_srp_plan_assigns

833: p_org_id NUMBER) IS
834: SELECT comp_plan_id,
835: start_date,
836: end_date
837: FROM cn_srp_plan_assigns
838: WHERE role_id = p_role_id
839: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
840:
841: /*

Line 1061: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1057: (roles.start_date <= l_rec.end_date AND roles.end_date >=
1058: l_rec.end_date ) ) THEN
1059:
1060: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id) LOOP
1061: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1062: (
1063: p_api_version => 1.0,
1064: p_init_msg_list => FND_API.G_FALSE,
1065: p_commit => FND_API.G_FALSE,

Line 1229: FROM cn_srp_plan_assigns

1225: SELECT comp_plan_id,
1226: start_date,
1227: end_date,
1228: org_id
1229: FROM cn_srp_plan_assigns
1230: WHERE role_id = p_role_id
1231: AND salesrep_id = p_salesrep_id
1232: and org_id=p_org_id;
1233:

Line 1378: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1374: salesrep.end_date ) ) THEN
1375:
1376: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id)
1377: LOOP
1378: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1379: (
1380: p_api_version => 1.0,
1381: p_init_msg_list => FND_API.G_FALSE,
1382: p_commit => FND_API.G_FALSE,