APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 717: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

713:
714: l_return_status VARCHAR2(2000);
715: l_msg_count NUMBER;
716: l_msg_data VARCHAR2(2000);
717: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
718: l_loading_status VARCHAR2(2000);
719:
720: BEGIN
721:

Line 729: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

725:
726: FOR l_rec IN l_cur
727: LOOP
728:
729: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
730: (
731: p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false,
733: p_commit => fnd_api.g_false,

Line 801: FROM cn_srp_plan_assigns

797: p_org_id NUMBER) IS
798: SELECT comp_plan_id,
799: start_date,
800: end_date
801: FROM cn_srp_plan_assigns
802: WHERE role_id = p_role_id
803: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
804:
805: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

Line 1011: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1007: (roles.start_date <= l_rec.end_date AND roles.end_date >=
1008: l_rec.end_date ) ) THEN
1009:
1010: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id) LOOP
1011: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1012: (
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_commit => FND_API.G_FALSE,

Line 1179: FROM cn_srp_plan_assigns

1175: SELECT comp_plan_id,
1176: start_date,
1177: end_date,
1178: org_id
1179: FROM cn_srp_plan_assigns
1180: WHERE role_id = p_role_id
1181: AND salesrep_id = p_salesrep_id
1182: and org_id=p_org_id;
1183:

Line 1328: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1324: salesrep.end_date ) ) THEN
1325:
1326: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id)
1327: LOOP
1328: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1329: (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,