APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_ROLES

Line 378: (p_role_id IN cn_roles.role_id%TYPE,

374: -- --------------------------------------------------------------------------*
375: -- Procedure: srp_plan_assignment_for_delete
376: -- --------------------------------------------------------------------------*
377: PROCEDURE srp_plan_assignment_for_delete
378: (p_role_id IN cn_roles.role_id%TYPE,
379: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
380: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
381: p_org_id IN cn_salesreps.org_id%TYPE,
382: x_return_status OUT NOCOPY VARCHAR2,

Line 495: l_role_id cn_roles.role_id%TYPE;

491:
492: l_api_name CONSTANT VARCHAR2(30) := 'Create_Srp_Pay_Group';
493: l_api_version CONSTANT NUMBER := 1.0;
494: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
495: l_role_id cn_roles.role_id%TYPE;
496: l_loading_status VARCHAR2(2000);
497: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
498: l_status VARCHAR2(30);
499: l_employee_number cn_salesreps.employee_number%TYPE;

Line 1578: l_role_id cn_roles.role_id%TYPE;

1574: ) IS
1575:
1576: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Srp_Pay_Group';
1577: l_api_version CONSTANT NUMBER := 1.0;
1578: l_role_id cn_roles.role_id%TYPE;
1579: l_loading_status VARCHAR2(2000);
1580: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
1581: -- Declaration for user hooks
1582:

Line 1589: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE) IS

1585: l_end_date DATE;
1586: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1587: l_paygroup_assign_rec paygroup_assign_rec;
1588:
1589: CURSOR get_role_plans(l_role_id cn_roles.role_id%TYPE) IS
1590: SELECT role_plan_id,role_id
1591: FROM cn_role_plans_all
1592: WHERE role_id = l_role_id
1593: AND org_id = p_paygroup_assign_rec.org_id;