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:
1304: BEGIN
1305: -- Standard Start of API savepoint

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:
1304: BEGIN
1305: -- Standard Start of API savepoint
1306: SAVEPOINT Create_Mass_Asgn_Srp_Pay;

Line 1368: from cn_srp_pay_groups_all

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

Line 1481: l_srp_pmt_plan_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

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

Line 1484: l_lock_flag cn_srp_pay_groups.lock_flag%TYPE;

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

Line 1498: l_start_date_old cn_srp_pay_groups.start_date%TYPE;

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

Line 1499: l_end_date_old cn_srp_pay_groups.start_date%TYPE;

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

Line 1500: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;

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

Line 1501: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

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

Line 1502: l_org_id cn_srp_pay_groups.org_id%TYPE;

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

Line 1517: l_start_date_new cn_srp_pay_groups.start_date%TYPE;

1513: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1514: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1515: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1516: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1517: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1518: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1519:
1520:
1521: --changed the cursor to get proper srp-pay_group assignment to be updated--Hanaraya

Line 1518: l_end_date_new cn_srp_pay_groups.start_date%TYPE;

1514: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1515: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1516: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1517: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1518: l_end_date_new cn_srp_pay_groups.start_date%TYPE;
1519:
1520:
1521: --changed the cursor to get proper srp-pay_group assignment to be updated--Hanaraya
1522: CURSOR get_pay_groups

Line 1526: from cn_srp_pay_groups sp

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

Line 1582: FROM cn_srp_pay_groups_all

1578: AND org_id = l_org_id;
1579:
1580: SELECT count(*)
1581: INTO l_count
1582: FROM cn_srp_pay_groups_all
1583: WHERE salesrep_id = l_salesrep_id_old
1584: AND role_pay_group_id = p_role_pay_group_id;
1585:
1586: IF (l_count <> 0)

Line 1667: FROM cn_srp_pay_groups_all

1663: WHERE pay_group_id = l_pay_group_id_new;
1664:
1665: SELECT count(*)
1666: INTO l_count_srp_pay_group
1667: FROM cn_srp_pay_groups_all
1668: WHERE salesrep_id=l_salesrep_id_old
1669: AND org_id = l_org_id
1670: AND ((l_start_date_old between start_date and nvl(end_date,l_null_date))
1671: OR (l_end_date_old between start_date and nvl(end_date,l_null_date)));

Line 1737: FROM cn_srp_pay_groups_all

1733: THEN
1734:
1735: SELECT count(*)
1736: INTO l_count_srp_pay_group
1737: FROM cn_srp_pay_groups_all
1738: WHERE salesrep_id=l_salesrep_id_old
1739: AND org_id = l_org_id
1740: AND ((l_start_date_new between start_date and nvl(end_date,l_null_date))
1741: OR (l_end_date_new between start_date and nvl(end_date,l_null_date)));