APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_SRP_PAY_GROUPS_S

Line 494: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

490: ) IS
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);

Line 550: SELECT cn_srp_pay_groups_s.NEXTVAL

546: -- Initialize API return status to success
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548: x_loading_status := 'CN_CREATED';
549:
550: SELECT cn_srp_pay_groups_s.NEXTVAL
551: INTO l_srp_pay_group_id
552: FROM dual;
553:
554: Validate_assignment

Line 1383: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1379: l_srp_role_id NUMBER;
1380: l_ws_count NUMBER;
1381: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');
1382: l_count NUMBER;
1383: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1384:
1385: -- clku
1386: CURSOR payee_check_curs(l_salesrep_id NUMBER) IS
1387: select srp_role_id from cn_srp_roles where

Line 1586: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1582:
1583: l_count NUMBER(15);
1584: l_start_date DATE;
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

Line 1848: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1844:
1845: l_return_status VARCHAR2(2000);
1846: l_msg_count NUMBER;
1847: l_msg_data VARCHAR2(2000);
1848: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1849: l_loading_status VARCHAR2(2000);
1850:
1851: newrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1852: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

Line 1858: l_start_date cn_srp_pay_groups.start_date%TYPE;

1854: l_pg_start_date cn_pay_groups.start_date%TYPE;
1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;

Line 1859: l_end_date cn_srp_pay_groups.start_date%TYPE;

1855: l_pg_end_date cn_pay_groups.end_date%TYPE;
1856: l_srp_start_date cn_srp_roles.start_date%TYPE;
1857: l_srp_end_date cn_pmt_plans.end_date%TYPE;
1858: l_start_date cn_srp_pay_groups.start_date%TYPE;
1859: l_end_date cn_srp_pay_groups.start_date%TYPE;
1860: l_org_id cn_srp_pay_groups.org_id%TYPE;
1861: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1862: l_count NUMBER;
1863: l_null_date CONSTANT DATE := to_date('12/31/9999','MM/DD/YYYY');