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_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_PAY_GROUPS

Line 46: l_start_date cn_srp_pay_groups.start_date%TYPE;

42: p_srp_role_id IN NUMBER,
43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

Line 47: l_end_date cn_srp_pay_groups.start_date%TYPE;

43: x_start_date OUT NOCOPY DATE,
44: x_end_date OUT NOCOPY DATE) IS
45:
46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

Line 50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;

46: l_start_date cn_srp_pay_groups.start_date%TYPE;
47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;

47: l_end_date cn_srp_pay_groups.start_date%TYPE;
48:
49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:

Line 53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;

49:
50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

Line 54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;

50: l_res_start_date cn_srp_pay_groups.start_date%TYPE;
51: l_res_end_date cn_srp_pay_groups.start_date%TYPE;
52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:

Line 56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;

52:
53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

Line 57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;

53: l_role_pg_start_date cn_srp_pay_groups.start_date%TYPE;
54: l_role_pg_end_date cn_srp_pay_groups.start_date%TYPE;
55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:

Line 59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;

55:
56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;

Line 60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;

56: l_srp_role_start_date cn_srp_pay_groups.start_date%TYPE;
57: l_srp_role_end_date cn_srp_pay_groups.start_date%TYPE;
58:
59: l_pg_start_date cn_srp_pay_groups.start_date%TYPE;
60: l_pg_end_date cn_srp_pay_groups.start_date%TYPE;
61:
62: l_org_id NUMBER;
63: l_salesrep_id NUMBER;
64: l_pay_group_id NUMBER;

Line 863: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

859:
860: l_role_pg_rec role_pay_groups_rec_type;
861: l_rec l_srp_cur%ROWTYPE;
862: l_lock_flag VARCHAR2(1);
863: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
864: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
865: l_start_date DATE;
866: l_end_date DATE;
867:

Line 864: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;

860: l_role_pg_rec role_pay_groups_rec_type;
861: l_rec l_srp_cur%ROWTYPE;
862: l_lock_flag VARCHAR2(1);
863: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
864: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
865: l_start_date DATE;
866: l_end_date DATE;
867:
868: BEGIN

Line 998: -- If existing any same role_id in cn_srp_pay_groups THEN

994: IF l_count <> 0 THEN
995: GOTO end_create_srp_pay_groups;
996: END IF;
997:
998: -- If existing any same role_id in cn_srp_pay_groups THEN
999: -- check no overlap
1000: SELECT count(1) into l_count
1001: FROM cn_srp_pay_groups
1002: WHERE salesrep_id = l_rec.salesrep_id

Line 1001: FROM cn_srp_pay_groups

997:
998: -- If existing any same role_id in cn_srp_pay_groups THEN
999: -- check no overlap
1000: SELECT count(1) into l_count
1001: FROM cn_srp_pay_groups
1002: WHERE salesrep_id = l_rec.salesrep_id
1003: AND org_id = p_role_pay_groups_rec.ORG_ID
1004: AND Greatest(start_date, l_rec.start_date) <=
1005: Least(Nvl(end_date, l_null_date),

Line 1011: SELECT cn_srp_pay_groups_s.NEXTVAL

1007:
1008: IF l_count = 0 THEN
1009: l_lock_flag := 'N';
1010:
1011: SELECT cn_srp_pay_groups_s.NEXTVAL
1012: INTO l_srp_pay_group_id
1013: FROM dual;
1014:
1015: CN_SRP_Pay_Groups_Pkg.Begin_Record

Line 1015: CN_SRP_Pay_Groups_Pkg.Begin_Record

1011: SELECT cn_srp_pay_groups_s.NEXTVAL
1012: INTO l_srp_pay_group_id
1013: FROM dual;
1014:
1015: CN_SRP_Pay_Groups_Pkg.Begin_Record
1016: (x_operation => 'INSERT',
1017: x_srp_pay_group_id => l_srp_pay_group_id,
1018: x_salesrep_id => l_rec.salesrep_id,
1019: x_pay_group_id => l_pay_group_id,

Line 1240: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)

1236: CURSOR get_salesreps(l_role_id NUMBER,l_pay_group_id cn_pay_groups.pay_group_id%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
1237: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1238: FROM cn_srp_roles
1239: WHERE role_id = l_role_id
1240: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)
1241: and org_id=l_org_id;
1242:
1243:
1244:

Line 1305: delete from cn_srp_pay_groups where salesrep_id=salesrep.salesrep_id

1301:
1302: LOOP
1303: SAVEPOINT delete_srp_pay_groups;
1304: --Included a where condition to delete the srp_pay_group record for the role_pay_group_id passed
1305: delete from cn_srp_pay_groups where salesrep_id=salesrep.salesrep_id
1306: AND role_pay_group_id=l_role_pay_group_id
1307: and org_id = l_org_id
1308: AND lock_flag='N' AND pay_group_id=l_pay_group_id AND (start_date between p_role_pay_groups_rec.start_date AND nvl(p_role_pay_groups_rec.end_date,l_null_date)) AND
1309: (nvl(end_date,l_null_date) between p_role_pay_groups_rec.start_date AND nvl(p_role_pay_groups_rec.end_date,l_null_date))

Line 1341: from cn_srp_pay_groups

1337: END LOOP ;
1338:
1339: select count (*),min(start_date),nvl(max(end_date),l_null_date) end_date
1340: INTO l_count,l_start_date,l_end_date
1341: from cn_srp_pay_groups
1342: where salesrep_id = salesrep.salesrep_id and org_id=salesrep.org_id;
1343:
1344: -- Bug fix 5200094 vensrini
1345: IF l_count = 0 THEN

Line 1443: Update cn_srp_pay_groups_all

1439: --Added by Harish
1440: -- if any of the salesreps with this role has any unpaid payment batch for this period,
1441: -- the paygroup mass assignment relationship is severed
1442: -- and is treated like an resource level paygroup assignment.
1443: Update cn_srp_pay_groups_all
1444: set role_pay_group_id = null
1445: where role_pay_group_id = l_role_pay_group_id;
1446: --End
1447: