APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PLAN_ASSIGNS

Line 399: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;

395:
396: l_return_status VARCHAR2(2000);
397: l_msg_count NUMBER;
398: l_msg_data VARCHAR2(2000);
399: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
400: l_loading_status VARCHAR2(2000);
401:
402: BEGIN
403:

Line 411: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns

407:
408: FOR l_rec IN l_cur
409: LOOP
410:
411: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
412: (
413: p_api_version => 1.0,
414: x_return_status => l_return_status,
415: x_msg_count => l_msg_count,

Line 521: FROM cn_srp_plan_assigns_all

517: p_salesrep_id NUMBER) IS
518: SELECT comp_plan_id,
519: start_date,
520: end_date
521: FROM cn_srp_plan_assigns_all
522: WHERE role_id = p_role_id
523: AND salesrep_id = p_salesrep_id
524: AND org_id = p_paygroup_assign_rec.org_id;
525:

Line 670: --Added by Zack 1/15/02 to populate cn_srp_plan_assigns

666:
667: -- Call cn_srp_periods_pvt api to affect the records in cn_srp_periods
668: FOR roles IN get_roles(p_paygroup_assign_rec.salesrep_id)
669: LOOP
670: --Added by Zack 1/15/02 to populate cn_srp_plan_assigns
671: IF ((roles.start_date <= p_paygroup_assign_rec.assignment_start_date
672: AND nvl(roles.end_date,l_null_date) >= p_paygroup_assign_rec.assignment_start_date)
673: OR (roles.start_date <= nvl(p_paygroup_assign_rec.assignment_end_date,l_null_date)
674: AND nvl(roles.end_date,l_null_date) >= nvl(p_paygroup_assign_rec.assignment_end_date,l_null_date))

Line 682: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

678: AND nvl(p_paygroup_assign_rec.assignment_end_date,l_null_date) >= roles.start_date)
679: ) THEN
680:
681: FOR role_plans IN get_role_plans(roles.role_id) LOOP
682: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
683: (p_api_version => 1.0,
684: x_return_status => x_return_status,
685: x_msg_count => x_msg_count,
686: x_msg_data => x_msg_data,

Line 847: FROM cn_srp_plan_assigns_all

843: p_salesrep_id NUMBER) IS
844: SELECT comp_plan_id,
845: start_date,
846: end_date
847: FROM cn_srp_plan_assigns_all
848: WHERE role_id = p_role_id
849: AND salesrep_id = p_salesrep_id
850: AND org_id = p_paygroup_assign_rec.org_id;
851:

Line 1238: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1234: (roles.start_date <= greatest(nvl(p_paygroup_assign_rec.assignment_end_date, l_null_date), nvl(l_old_assignment_end_date, l_null_date))
1235: AND roles.end_date >= greatest(nvl(p_paygroup_assign_rec.assignment_end_date, l_null_date), nvl(l_old_assignment_end_date, l_null_date)) ) )
1236: ) THEN
1237: FOR role_plans IN get_role_plans(roles.role_id) LOOP
1238: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1239: (
1240: p_api_version => 1.0,
1241: x_return_status => x_return_status,
1242: x_msg_count => x_msg_count,

Line 1613: FROM cn_srp_plan_assigns_all

1609: p_salesrep_id NUMBER) IS
1610: SELECT comp_plan_id,
1611: start_date,
1612: end_date
1613: FROM cn_srp_plan_assigns_all
1614: WHERE role_id = p_role_id
1615: AND salesrep_id = p_salesrep_id
1616: AND org_id = p_paygroup_assign_rec.org_id;
1617:

Line 1723: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns

1719: paygroups.end_date ) ) THEN
1720:
1721: FOR role_plans IN get_role_plans(roles.role_id)
1722: LOOP
1723: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1724: ( p_api_version => 1.0,
1725: x_return_status => x_return_status,
1726: x_msg_count => x_msg_count,
1727: x_msg_data => x_msg_data,