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 813: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;

809:
810: l_role_pg_rec role_pay_groups_rec_type;
811: l_rec l_srp_cur%ROWTYPE;
812: l_lock_flag VARCHAR2(1);
813: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
814: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
815: l_start_date DATE;
816: l_end_date DATE;
817:

Line 814: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;

810: l_role_pg_rec role_pay_groups_rec_type;
811: l_rec l_srp_cur%ROWTYPE;
812: l_lock_flag VARCHAR2(1);
813: l_srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE;
814: l_object_version_number cn_srp_pay_groups.object_version_number%TYPE;
815: l_start_date DATE;
816: l_end_date DATE;
817:
818: BEGIN

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

944: IF l_count <> 0 THEN
945: GOTO end_create_srp_pay_groups;
946: END IF;
947:
948: -- If existing any same role_id in cn_srp_pay_groups THEN
949: -- check no overlap
950: SELECT count(1) into l_count
951: FROM cn_srp_pay_groups
952: WHERE salesrep_id = l_rec.salesrep_id

Line 951: FROM cn_srp_pay_groups

947:
948: -- If existing any same role_id in cn_srp_pay_groups THEN
949: -- check no overlap
950: SELECT count(1) into l_count
951: FROM cn_srp_pay_groups
952: WHERE salesrep_id = l_rec.salesrep_id
953: AND org_id = p_role_pay_groups_rec.ORG_ID
954: AND Greatest(start_date, l_rec.start_date) <=
955: Least(Nvl(end_date, l_null_date),

Line 961: SELECT cn_srp_pay_groups_s.NEXTVAL

957:
958: IF l_count = 0 THEN
959: l_lock_flag := 'N';
960:
961: SELECT cn_srp_pay_groups_s.NEXTVAL
962: INTO l_srp_pay_group_id
963: FROM dual;
964:
965: CN_SRP_Pay_Groups_Pkg.Begin_Record

Line 965: CN_SRP_Pay_Groups_Pkg.Begin_Record

961: SELECT cn_srp_pay_groups_s.NEXTVAL
962: INTO l_srp_pay_group_id
963: FROM dual;
964:
965: CN_SRP_Pay_Groups_Pkg.Begin_Record
966: (x_operation => 'INSERT',
967: x_srp_pay_group_id => l_srp_pay_group_id,
968: x_salesrep_id => l_rec.salesrep_id,
969: x_pay_group_id => l_pay_group_id,

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

1186: 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
1187: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1188: FROM cn_srp_roles
1189: WHERE role_id = l_role_id
1190: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)
1191: and org_id=l_org_id;
1192:
1193:
1194:

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

1251:
1252: LOOP
1253: SAVEPOINT delete_srp_pay_groups;
1254: --Included a where condition to delete the srp_pay_group record for the role_pay_group_id passed
1255: delete from cn_srp_pay_groups where salesrep_id=salesrep.salesrep_id
1256: AND role_pay_group_id=l_role_pay_group_id
1257: and org_id = l_org_id
1258: 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
1259: (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 1291: from cn_srp_pay_groups

1287: END LOOP ;
1288:
1289: select count (*),min(start_date),nvl(max(end_date),l_null_date) end_date
1290: INTO l_count,l_start_date,l_end_date
1291: from cn_srp_pay_groups
1292: where salesrep_id = salesrep.salesrep_id and org_id=salesrep.org_id;
1293:
1294: -- Bug fix 5200094 vensrini
1295: IF l_count = 0 THEN

Line 1393: Update cn_srp_pay_groups_all

1389: --Added by Harish
1390: -- if any of the salesreps with this role has any unpaid payment batch for this period,
1391: -- the paygroup mass assignment relationship is severed
1392: -- and is treated like an resource level paygroup assignment.
1393: Update cn_srp_pay_groups_all
1394: set role_pay_group_id = null
1395: where role_pay_group_id = l_role_pay_group_id;
1396: --End
1397: