eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_SRP_PAY_GROUPS

Line 37: l_start_date cn_srp_pay_groups.start_date%TYPE;

33: p_srp_role_id IN NUMBER,
34: x_start_date OUT NOCOPY DATE,
35: x_end_date OUT NOCOPY DATE) IS
36:
37: l_start_date cn_srp_pay_groups.start_date%TYPE;
38: l_end_date cn_srp_pay_groups.start_date%TYPE;
39:
40:
41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

Line 38: l_end_date cn_srp_pay_groups.start_date%TYPE;

34: x_start_date OUT NOCOPY DATE,
35: x_end_date OUT NOCOPY DATE) IS
36:
37: l_start_date cn_srp_pay_groups.start_date%TYPE;
38: l_end_date cn_srp_pay_groups.start_date%TYPE;
39:
40:
41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

Line 41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

37: l_start_date cn_srp_pay_groups.start_date%TYPE;
38: l_end_date cn_srp_pay_groups.start_date%TYPE;
39:
40:
41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
43:
44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

38: l_end_date cn_srp_pay_groups.start_date%TYPE;
39:
40:
41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
43:
44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
46:

Line 44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;

40:
41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
43:
44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
46:
47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

Line 45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

41: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
42: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
43:
44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
46:
47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
49:

Line 47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;

43:
44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
46:
47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
49:
50: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

44: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
45: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
46:
47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
49:
50: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
52:

Line 50: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;

46:
47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
49:
50: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_org_id NUMBER;
54: l_salesrep_id NUMBER;

Line 51: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

47: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
48: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
49:
50: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_org_id NUMBER;
54: l_salesrep_id NUMBER;
55: l_pay_group_id NUMBER;

Line 219: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;

215: l_api_version CONSTANT NUMBER := 1.0;
216: l_pay_group_id NUMBER;
217: l_org_id NUMBER;
218: l_srp_pay_group_id NUMBER;
219: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
220: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
221: l_status VARCHAR2(1);
222:
223: l_pay_group_name cn_pay_groups.name%TYPE;

Line 670: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;

666: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_assignment';
667: l_api_version CONSTANT NUMBER := 1.0;
668: l_pay_group_id NUMBER;
669: l_srp_pay_group_id NUMBER;
670: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
671: l_old_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
672: l_org_id cn_srp_pay_groups.org_id%TYPE;
673: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
674: l_ovn_old NUMBER;

Line 671: l_old_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;

667: l_api_version CONSTANT NUMBER := 1.0;
668: l_pay_group_id NUMBER;
669: l_srp_pay_group_id NUMBER;
670: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
671: l_old_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
672: l_org_id cn_srp_pay_groups.org_id%TYPE;
673: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
674: l_ovn_old NUMBER;
675: l_count NUMBER;

Line 672: l_org_id cn_srp_pay_groups.org_id%TYPE;

668: l_pay_group_id NUMBER;
669: l_srp_pay_group_id NUMBER;
670: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
671: l_old_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
672: l_org_id cn_srp_pay_groups.org_id%TYPE;
673: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
674: l_ovn_old NUMBER;
675: l_count NUMBER;
676: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;

Line 696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,

692: AND org_id = p_org_id;
693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;
694:
695: CURSOR get_srp_pay_group_id_cur (
696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,
697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id

Line 697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,

693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;
694:
695: CURSOR get_srp_pay_group_id_cur (
696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,
697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id
701: FROM cn_srp_pay_groups_all

Line 698: c_start_date cn_srp_pay_groups.start_date%TYPE,

694:
695: CURSOR get_srp_pay_group_id_cur (
696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,
697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id
701: FROM cn_srp_pay_groups_all
702: WHERE salesrep_id = c_salesrep_id

Line 699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS

695: CURSOR get_srp_pay_group_id_cur (
696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,
697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id
701: FROM cn_srp_pay_groups_all
702: WHERE salesrep_id = c_salesrep_id
703: AND pay_group_id = c_pay_group_id

Line 701: FROM cn_srp_pay_groups_all

697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,
698: c_start_date cn_srp_pay_groups.start_date%TYPE,
699: c_end_date cn_srp_pay_groups.end_date%TYPE) IS
700: SELECT srp_pay_group_id
701: FROM cn_srp_pay_groups_all
702: WHERE salesrep_id = c_salesrep_id
703: AND pay_group_id = c_pay_group_id
704: AND trunc(start_date) = trunc(c_start_date)
705: AND trunc(nvl(end_date, l_null_date)) =

Line 1283: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1279:
1280: l_return_status VARCHAR2(2000);
1281: l_msg_count NUMBER;
1282: l_msg_data VARCHAR2(2000);
1283: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1284: l_loading_status VARCHAR2(2000);
1285: l_status VARCHAR2(2000);
1286: l_count NUMBER;
1287: l_api_name CONSTANT VARCHAR2(30) := 'Create_Mass_Asgn_Srp_Pay';

Line 1301: l_start_date cn_srp_pay_groups.start_date%TYPE;

1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;
1303: l_source_id cn_salesreps.source_id%TYPE;
1304:
1305: BEGIN

Line 1302: l_end_date cn_srp_pay_groups.start_date%TYPE;

1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;
1303: l_source_id cn_salesreps.source_id%TYPE;
1304:
1305: BEGIN
1306: -- Standard Start of API savepoint

Line 1369: from cn_srp_pay_groups_all

1365: IF l_start_date IS NOT NULL AND l_end_date IS NOT NULL THEN
1366:
1367: select count(*)
1368: into l_count
1369: from cn_srp_pay_groups_all
1370: where salesrep_id = l_salesrep_id
1371: AND org_id = l_org_id
1372: and ((l_start_date between start_date and nvl(end_date,l_null_date))
1373: or (nvl(l_end_date,l_null_date) between

Line 1483: l_srp_pmt_plan_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1479:
1480: l_return_status VARCHAR2(2000);
1481: l_msg_count NUMBER;
1482: l_msg_data VARCHAR2(2000);
1483: l_srp_pmt_plan_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1484: l_loading_status VARCHAR2(2000);
1485: l_status VARCHAR2(2000);
1486: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1487: l_api_name CONSTANT VARCHAR2(30) := 'Update_Mass_Asgn_Srp_Pay';

Line 1486: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;

1482: l_msg_data VARCHAR2(2000);
1483: l_srp_pmt_plan_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1484: l_loading_status VARCHAR2(2000);
1485: l_status VARCHAR2(2000);
1486: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;
1487: l_api_name CONSTANT VARCHAR2(30) := 'Update_Mass_Asgn_Srp_Pay';
1488: l_api_version CONSTANT NUMBER := 1.0;
1489: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
1490: l_count NUMBER;

Line 1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;

1496: l_emp_num_old cn_salesreps.employee_number%TYPE;
1497: l_pay_group_name_old cn_pay_groups.name%TYPE;
1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1504: l_org_id cn_srp_pay_groups.org_id%TYPE;

Line 1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;

1497: l_pay_group_name_old cn_pay_groups.name%TYPE;
1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1504: l_org_id cn_srp_pay_groups.org_id%TYPE;
1505:

Line 1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;

1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1504: l_org_id cn_srp_pay_groups.org_id%TYPE;
1505:
1506: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;

Line 1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1504: l_org_id cn_srp_pay_groups.org_id%TYPE;
1505:
1506: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1507: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;

Line 1504: l_org_id cn_srp_pay_groups.org_id%TYPE;

1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;
1503: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
1504: l_org_id cn_srp_pay_groups.org_id%TYPE;
1505:
1506: newrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1507: oldrec CN_SRP_PAYGROUP_PUB.PayGroup_assign_rec;
1508:

Line 1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;

1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;
1522: l_source_id_new cn_salesreps.source_id%TYPE;
1523:

Line 1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;

1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1521: l_source_id_old cn_salesreps.source_id%TYPE;
1522: l_source_id_new cn_salesreps.source_id%TYPE;
1523:
1524:

Line 1530: from cn_srp_pay_groups sp

1526: CURSOR get_pay_groups
1527: (l_salesrep_id_old NUMBER,
1528: p_role_pay_group_id NUMBER) IS
1529: select srp_pay_group_id,pay_group_id, start_date, end_date,object_version_number,lock_flag
1530: from cn_srp_pay_groups sp
1531: where salesrep_id = l_salesrep_id_old
1532: AND role_pay_group_id = p_role_pay_group_id
1533: AND NOT EXISTS
1534: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp

Line 1586: FROM cn_srp_pay_groups_all

1582: AND org_id = l_org_id;
1583:
1584: SELECT count(*)
1585: INTO l_count
1586: FROM cn_srp_pay_groups_all
1587: WHERE salesrep_id = l_salesrep_id_old
1588: AND role_pay_group_id = p_role_pay_group_id;
1589:
1590: IF (l_count <> 0)

Line 1674: FROM cn_srp_pay_groups_all

1670: WHERE pay_group_id = l_pay_group_id_new;
1671:
1672: SELECT count(*)
1673: INTO l_count_srp_pay_group
1674: FROM cn_srp_pay_groups_all
1675: WHERE salesrep_id=l_salesrep_id_old
1676: AND org_id = l_org_id
1677: AND ((l_start_date_old between start_date and nvl(end_date,l_null_date))
1678: OR (l_end_date_old between start_date and nvl(end_date,l_null_date)));

Line 1745: FROM cn_srp_pay_groups_all

1741: THEN
1742:
1743: SELECT count(*)
1744: INTO l_count_srp_pay_group
1745: FROM cn_srp_pay_groups_all
1746: WHERE salesrep_id=l_salesrep_id_old
1747: AND org_id = l_org_id
1748: AND ((l_start_date_new between start_date and nvl(end_date,l_null_date))
1749: OR (l_end_date_new between start_date and nvl(end_date,l_null_date)));