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.PAY_GRR_BUS dependencies on HR_API

Line 109: and nvl(pg.date_to, hr_api.g_eot)

105: select business_group_id
106: from per_grades pg
107: where pg.grade_id = p_grade_or_spinal_point_id
108: and p_effective_start_date between pg.date_from
109: and nvl(pg.date_to, hr_api.g_eot)
110: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);
111: --
112: cursor csr_valid_spinal_point is
113: select business_group_id

Line 110: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);

106: from per_grades pg
107: where pg.grade_id = p_grade_or_spinal_point_id
108: and p_effective_start_date between pg.date_from
109: and nvl(pg.date_to, hr_api.g_eot)
110: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);
111: --
112: cursor csr_valid_spinal_point is
113: select business_group_id
114: from per_spinal_points psp

Line 132: hr_api.mandatory_arg_error

128: hr_utility.set_location('Entering:'|| l_proc, 10);
129: --
130: -- Check mandatory parameters have been set
131: --
132: hr_api.mandatory_arg_error
133: (p_api_name => l_proc
134: ,p_argument => 'grade_or_spinal_point_id'
135: ,p_argument_value => p_grade_or_spinal_point_id
136: );

Line 138: hr_api.mandatory_arg_error

134: ,p_argument => 'grade_or_spinal_point_id'
135: ,p_argument_value => p_grade_or_spinal_point_id
136: );
137: --
138: hr_api.mandatory_arg_error
139: (p_api_name => l_proc
140: ,p_argument => 'rate_id'
141: ,p_argument_value => p_rate_id
142: );

Line 144: hr_api.mandatory_arg_error

140: ,p_argument => 'rate_id'
141: ,p_argument_value => p_rate_id
142: );
143: --
144: hr_api.mandatory_arg_error
145: (p_api_name => l_proc
146: ,p_argument => 'rate_type'
147: ,p_argument_value => p_rate_type
148: );

Line 150: hr_api.mandatory_arg_error

146: ,p_argument => 'rate_type'
147: ,p_argument_value => p_rate_type
148: );
149: --
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'effective_start_date'
153: ,p_argument_value => p_effective_start_date
154: );

Line 156: hr_api.mandatory_arg_error

152: ,p_argument => 'effective_start_date'
153: ,p_argument_value => p_effective_start_date
154: );
155: --
156: hr_api.mandatory_arg_error
157: (p_api_name => l_proc
158: ,p_argument => 'effective_end_date'
159: ,p_argument_value => p_effective_end_date
160: );

Line 290: hr_api.mandatory_arg_error

286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Check mandatory parameters have been set
289: --
290: hr_api.mandatory_arg_error
291: (p_api_name => l_proc
292: ,p_argument => 'rate_id'
293: ,p_argument_value => p_rate_id
294: );

Line 380: hr_api.mandatory_arg_error

376: hr_utility.set_location('Entering:'|| l_proc, 1);
377: --
378: -- Check mandatory parameters have been set
379: --
380: hr_api.mandatory_arg_error
381: (p_api_name => l_proc
382: ,p_argument => 'p_rate_id'
383: ,p_argument_value => p_rate_id
384: );

Line 386: hr_api.mandatory_arg_error

382: ,p_argument => 'p_rate_id'
383: ,p_argument_value => p_rate_id
384: );
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'p_rate_type'
389: ,p_argument_value => p_rate_type
390: );

Line 494: hr_api.mandatory_arg_error

490: l_maximum := p_maximum;
491: --
492: -- Check mandatory parameters have been set
493: --
494: hr_api.mandatory_arg_error
495: (p_api_name => l_proc
496: ,p_argument => 'rate_type'
497: ,p_argument_value => p_rate_type
498: );

Line 500: hr_api.mandatory_arg_error

496: ,p_argument => 'rate_type'
497: ,p_argument_value => p_rate_type
498: );
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc
502: ,p_argument => 'rate_id'
503: ,p_argument_value => p_rate_id
504: );

Line 506: hr_api.mandatory_arg_error

502: ,p_argument => 'rate_id'
503: ,p_argument_value => p_rate_id
504: );
505: --
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc
508: ,p_argument => 'effective_date'
509: ,p_argument_value => p_effective_date
510: );

Line 522: nvl(pay_grr_shd.g_old_rec.maximum, hr_api.g_varchar2) <>

518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_object_version_number);
520: --
521: if ((l_api_updating and
522: nvl(pay_grr_shd.g_old_rec.maximum, hr_api.g_varchar2) <>
523: nvl(l_maximum, hr_api.g_varchar2)) or
524: (NOT l_api_updating)) then
525: hr_utility.set_location(l_proc, 2);
526: --

Line 523: nvl(l_maximum, hr_api.g_varchar2)) or

519: ,p_object_version_number => p_object_version_number);
520: --
521: if ((l_api_updating and
522: nvl(pay_grr_shd.g_old_rec.maximum, hr_api.g_varchar2) <>
523: nvl(l_maximum, hr_api.g_varchar2)) or
524: (NOT l_api_updating)) then
525: hr_utility.set_location(l_proc, 2);
526: --
527: if p_rate_type = 'G' then

Line 666: hr_api.mandatory_arg_error

662: l_mid_value := p_mid_value;
663: --
664: -- Check mandatory parameters have been set
665: --
666: hr_api.mandatory_arg_error
667: (p_api_name => l_proc
668: ,p_argument => 'rate_type'
669: ,p_argument_value => p_rate_type
670: );

Line 672: hr_api.mandatory_arg_error

668: ,p_argument => 'rate_type'
669: ,p_argument_value => p_rate_type
670: );
671: --
672: hr_api.mandatory_arg_error
673: (p_api_name => l_proc
674: ,p_argument => 'rate_id'
675: ,p_argument_value => p_rate_id
676: );

Line 678: hr_api.mandatory_arg_error

674: ,p_argument => 'rate_id'
675: ,p_argument_value => p_rate_id
676: );
677: --
678: hr_api.mandatory_arg_error
679: (p_api_name => l_proc
680: ,p_argument => 'effective_date'
681: ,p_argument_value => p_effective_date
682: );

Line 694: nvl(pay_grr_shd.g_old_rec.mid_value, hr_api.g_varchar2) <>

690: ,p_effective_date => p_effective_date
691: ,p_object_version_number => p_object_version_number);
692: --
693: if ((l_api_updating and
694: nvl(pay_grr_shd.g_old_rec.mid_value, hr_api.g_varchar2) <>
695: nvl(l_mid_value, hr_api.g_varchar2)) or
696: (NOT l_api_updating)) then
697: hr_utility.set_location(l_proc, 2);
698: --

Line 695: nvl(l_mid_value, hr_api.g_varchar2)) or

691: ,p_object_version_number => p_object_version_number);
692: --
693: if ((l_api_updating and
694: nvl(pay_grr_shd.g_old_rec.mid_value, hr_api.g_varchar2) <>
695: nvl(l_mid_value, hr_api.g_varchar2)) or
696: (NOT l_api_updating)) then
697: hr_utility.set_location(l_proc, 2);
698: --
699: if p_rate_type = 'G' then

Line 833: hr_api.mandatory_arg_error

829: l_value := p_value;
830: --
831: -- Check mandatory parameters have been set
832: --
833: hr_api.mandatory_arg_error
834: (p_api_name => l_proc
835: ,p_argument => 'rate_type'
836: ,p_argument_value => p_rate_type
837: );

Line 839: hr_api.mandatory_arg_error

835: ,p_argument => 'rate_type'
836: ,p_argument_value => p_rate_type
837: );
838: --
839: hr_api.mandatory_arg_error
840: (p_api_name => l_proc
841: ,p_argument => 'rate_id'
842: ,p_argument_value => p_rate_id
843: );

Line 845: hr_api.mandatory_arg_error

841: ,p_argument => 'rate_id'
842: ,p_argument_value => p_rate_id
843: );
844: --
845: hr_api.mandatory_arg_error
846: (p_api_name => l_proc
847: ,p_argument => 'effective_date'
848: ,p_argument_value => p_effective_date
849: );

Line 861: nvl(pay_grr_shd.g_old_rec.minimum, hr_api.g_varchar2) <>

857: ,p_effective_date => p_effective_date
858: ,p_object_version_number => p_object_version_number);
859: --
860: if ((l_api_updating and
861: nvl(pay_grr_shd.g_old_rec.minimum, hr_api.g_varchar2) <>
862: nvl(l_minimum, hr_api.g_varchar2)) or
863: (NOT l_api_updating)) then
864: hr_utility.set_location(l_proc, 2);
865: --

Line 862: nvl(l_minimum, hr_api.g_varchar2)) or

858: ,p_object_version_number => p_object_version_number);
859: --
860: if ((l_api_updating and
861: nvl(pay_grr_shd.g_old_rec.minimum, hr_api.g_varchar2) <>
862: nvl(l_minimum, hr_api.g_varchar2)) or
863: (NOT l_api_updating)) then
864: hr_utility.set_location(l_proc, 2);
865: --
866: if p_rate_type = 'G' then

Line 984: and nvl(pg.date_to, hr_api.g_eot)

980: from per_grades pg
981: where pg.grade_id = p_grade_or_spinal_point_id
982: and pg.sequence = p_sequence
983: and p_effective_start_date between pg.date_from
984: and nvl(pg.date_to, hr_api.g_eot)
985: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);
986: --
987: cursor csr_valid_sp_seq is
988: select null

Line 985: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);

981: where pg.grade_id = p_grade_or_spinal_point_id
982: and pg.sequence = p_sequence
983: and p_effective_start_date between pg.date_from
984: and nvl(pg.date_to, hr_api.g_eot)
985: and p_effective_end_date <= nvl(pg.date_to, hr_api.g_eot);
986: --
987: cursor csr_valid_sp_seq is
988: select null
989: from per_spinal_points psp

Line 998: hr_api.mandatory_arg_error

994: hr_utility.set_location('Entering:'|| l_proc, 1);
995: --
996: -- Check mandatory parameters have been set
997: --
998: hr_api.mandatory_arg_error
999: (p_api_name => l_proc
1000: ,p_argument => 'grade_or_spinal_point_id'
1001: ,p_argument_value => p_grade_or_spinal_point_id
1002: );

Line 1004: hr_api.mandatory_arg_error

1000: ,p_argument => 'grade_or_spinal_point_id'
1001: ,p_argument_value => p_grade_or_spinal_point_id
1002: );
1003: --
1004: hr_api.mandatory_arg_error
1005: (p_api_name => l_proc
1006: ,p_argument => 'rate_id'
1007: ,p_argument_value => p_rate_id
1008: );

Line 1010: hr_api.mandatory_arg_error

1006: ,p_argument => 'rate_id'
1007: ,p_argument_value => p_rate_id
1008: );
1009: --
1010: hr_api.mandatory_arg_error
1011: (p_api_name => l_proc
1012: ,p_argument => 'rate_type'
1013: ,p_argument_value => p_rate_type
1014: );

Line 1016: hr_api.mandatory_arg_error

1012: ,p_argument => 'rate_type'
1013: ,p_argument_value => p_rate_type
1014: );
1015: --
1016: hr_api.mandatory_arg_error
1017: (p_api_name => l_proc
1018: ,p_argument => 'effective_start_date'
1019: ,p_argument_value => p_effective_start_date
1020: );

Line 1022: hr_api.mandatory_arg_error

1018: ,p_argument => 'effective_start_date'
1019: ,p_argument_value => p_effective_start_date
1020: );
1021: --
1022: hr_api.mandatory_arg_error
1023: (p_api_name => l_proc
1024: ,p_argument => 'effective_end_date'
1025: ,p_argument_value => p_effective_end_date
1026: );

Line 1135: hr_api.mandatory_arg_error

1131: l_value := p_value;
1132: --
1133: -- Check mandatory parameters have been set
1134: --
1135: hr_api.mandatory_arg_error
1136: (p_api_name => l_proc
1137: ,p_argument => 'rate_type'
1138: ,p_argument_value => p_rate_type
1139: );

Line 1141: hr_api.mandatory_arg_error

1137: ,p_argument => 'rate_type'
1138: ,p_argument_value => p_rate_type
1139: );
1140: --
1141: hr_api.mandatory_arg_error
1142: (p_api_name => l_proc
1143: ,p_argument => 'rate_id'
1144: ,p_argument_value => p_rate_id
1145: );

Line 1147: hr_api.mandatory_arg_error

1143: ,p_argument => 'rate_id'
1144: ,p_argument_value => p_rate_id
1145: );
1146: --
1147: hr_api.mandatory_arg_error
1148: (p_api_name => l_proc
1149: ,p_argument => 'effective_date'
1150: ,p_argument_value => p_effective_date
1151: );

Line 1163: nvl(pay_grr_shd.g_old_rec.value, hr_api.g_varchar2) <>

1159: ,p_effective_date => p_effective_date
1160: ,p_object_version_number => p_object_version_number);
1161: --
1162: if ((l_api_updating and
1163: nvl(pay_grr_shd.g_old_rec.value, hr_api.g_varchar2) <>
1164: nvl(l_value, hr_api.g_varchar2)) or
1165: (NOT l_api_updating)) then
1166: hr_utility.set_location(l_proc, 2);
1167: --

Line 1164: nvl(l_value, hr_api.g_varchar2)) or

1160: ,p_object_version_number => p_object_version_number);
1161: --
1162: if ((l_api_updating and
1163: nvl(pay_grr_shd.g_old_rec.value, hr_api.g_varchar2) <>
1164: nvl(l_value, hr_api.g_varchar2)) or
1165: (NOT l_api_updating)) then
1166: hr_utility.set_location(l_proc, 2);
1167: --
1168: -- Check that value for Value is >= Minimum and <= Maximum

Line 1280: if nvl(p_rec.business_group_id, hr_api.g_number) <>

1276: end if;
1277: --
1278: hr_utility.set_location(l_proc, 6);
1279: --
1280: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1281: nvl(pay_grr_shd.g_old_rec.business_group_id, hr_api.g_number) then
1282: l_argument := 'business_group_id';
1283: raise l_error;
1284: end if;

Line 1281: nvl(pay_grr_shd.g_old_rec.business_group_id, hr_api.g_number) then

1277: --
1278: hr_utility.set_location(l_proc, 6);
1279: --
1280: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1281: nvl(pay_grr_shd.g_old_rec.business_group_id, hr_api.g_number) then
1282: l_argument := 'business_group_id';
1283: raise l_error;
1284: end if;
1285: hr_utility.set_location(l_proc, 7);

Line 1293: if nvl(p_rec.grade_or_spinal_point_id, hr_api.g_number) <>

1289: raise l_error;
1290: end if;
1291: hr_utility.set_location(l_proc, 8);
1292: --
1293: if nvl(p_rec.grade_or_spinal_point_id, hr_api.g_number) <>
1294: nvl(pay_grr_shd.g_old_rec.grade_or_spinal_point_id, hr_api.g_number) then
1295: l_argument := 'grade_or_spinal_point_id';
1296: raise l_error;
1297: end if;

Line 1294: nvl(pay_grr_shd.g_old_rec.grade_or_spinal_point_id, hr_api.g_number) then

1290: end if;
1291: hr_utility.set_location(l_proc, 8);
1292: --
1293: if nvl(p_rec.grade_or_spinal_point_id, hr_api.g_number) <>
1294: nvl(pay_grr_shd.g_old_rec.grade_or_spinal_point_id, hr_api.g_number) then
1295: l_argument := 'grade_or_spinal_point_id';
1296: raise l_error;
1297: end if;
1298: hr_utility.set_location(l_proc, 9);

Line 1300: if nvl(p_rec.rate_id, hr_api.g_number) <>

1296: raise l_error;
1297: end if;
1298: hr_utility.set_location(l_proc, 9);
1299: --
1300: if nvl(p_rec.rate_id, hr_api.g_number) <>
1301: nvl(pay_grr_shd.g_old_rec.rate_id, hr_api.g_number) then
1302: l_argument := 'rate_id';
1303: raise l_error;
1304: end if;

Line 1301: nvl(pay_grr_shd.g_old_rec.rate_id, hr_api.g_number) then

1297: end if;
1298: hr_utility.set_location(l_proc, 9);
1299: --
1300: if nvl(p_rec.rate_id, hr_api.g_number) <>
1301: nvl(pay_grr_shd.g_old_rec.rate_id, hr_api.g_number) then
1302: l_argument := 'rate_id';
1303: raise l_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 10);

Line 1307: if nvl(p_rec.sequence, hr_api.g_number) <>

1303: raise l_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 10);
1306: --
1307: if nvl(p_rec.sequence, hr_api.g_number) <>
1308: nvl(pay_grr_shd.g_old_rec.sequence, hr_api.g_number) then
1309: l_argument := 'sequence';
1310: raise l_error;
1311: end if;

Line 1308: nvl(pay_grr_shd.g_old_rec.sequence, hr_api.g_number) then

1304: end if;
1305: hr_utility.set_location(l_proc, 10);
1306: --
1307: if nvl(p_rec.sequence, hr_api.g_number) <>
1308: nvl(pay_grr_shd.g_old_rec.sequence, hr_api.g_number) then
1309: l_argument := 'sequence';
1310: raise l_error;
1311: end if;
1312: hr_utility.set_location(l_proc, 11);

Line 1314: if nvl(p_rec.rate_type, hr_api.g_varchar2) <>

1310: raise l_error;
1311: end if;
1312: hr_utility.set_location(l_proc, 11);
1313: --
1314: if nvl(p_rec.rate_type, hr_api.g_varchar2) <>
1315: nvl(pay_grr_shd.g_old_rec.rate_type, hr_api.g_varchar2) then
1316: l_argument := 'rate_type';
1317: raise l_error;
1318: end if;

Line 1315: nvl(pay_grr_shd.g_old_rec.rate_type, hr_api.g_varchar2) then

1311: end if;
1312: hr_utility.set_location(l_proc, 11);
1313: --
1314: if nvl(p_rec.rate_type, hr_api.g_varchar2) <>
1315: nvl(pay_grr_shd.g_old_rec.rate_type, hr_api.g_varchar2) then
1316: l_argument := 'rate_type';
1317: raise l_error;
1318: end if;
1319: hr_utility.set_location(l_proc, 12);

Line 1322: hr_api.argument_changed_error

1318: end if;
1319: hr_utility.set_location(l_proc, 12);
1320: exception
1321: when l_error then
1322: hr_api.argument_changed_error
1323: (p_api_name => l_proc
1324: ,p_argument => l_argument);
1325: when others then
1326: raise;

Line 1374: hr_api.mandatory_arg_error

1370: hr_utility.set_location('Entering:'||l_proc, 5);
1371: --
1372: -- Ensure that the p_datetrack_mode argument is not null
1373: --
1374: hr_api.mandatory_arg_error
1375: (p_api_name => l_proc,
1376: p_argument => 'datetrack_mode',
1377: p_argument_value => p_datetrack_mode);
1378: --

Line 1386: hr_api.mandatory_arg_error

1382: --
1383: --
1384: -- Ensure the arguments are not null
1385: --
1386: hr_api.mandatory_arg_error
1387: (p_api_name => l_proc,
1388: p_argument => 'validation_start_date',
1389: p_argument_value => p_validation_start_date);
1390: --

Line 1391: hr_api.mandatory_arg_error

1387: (p_api_name => l_proc,
1388: p_argument => 'validation_start_date',
1389: p_argument_value => p_validation_start_date);
1390: --
1391: hr_api.mandatory_arg_error
1392: (p_api_name => l_proc,
1393: p_argument => 'validation_end_date',
1394: p_argument_value => p_validation_end_date);
1395: --

Line 1471: hr_api.mandatory_arg_error

1467: hr_utility.set_location('Entering:'||l_proc, 5);
1468: --
1469: -- Ensure that the p_datetrack_mode argument is not null
1470: --
1471: hr_api.mandatory_arg_error
1472: (p_api_name => l_proc,
1473: p_argument => 'datetrack_mode',
1474: p_argument_value => p_datetrack_mode);
1475: --

Line 1485: hr_api.mandatory_arg_error

1481: --
1482: --
1483: -- Ensure the arguments are not null
1484: --
1485: hr_api.mandatory_arg_error
1486: (p_api_name => l_proc,
1487: p_argument => 'validation_start_date',
1488: p_argument_value => p_validation_start_date);
1489: --

Line 1490: hr_api.mandatory_arg_error

1486: (p_api_name => l_proc,
1487: p_argument => 'validation_start_date',
1488: p_argument_value => p_validation_start_date);
1489: --
1490: hr_api.mandatory_arg_error
1491: (p_api_name => l_proc,
1492: p_argument => 'validation_end_date',
1493: p_argument_value => p_validation_end_date);
1494: --

Line 1495: hr_api.mandatory_arg_error

1491: (p_api_name => l_proc,
1492: p_argument => 'validation_end_date',
1493: p_argument_value => p_validation_end_date);
1494: --
1495: hr_api.mandatory_arg_error
1496: (p_api_name => l_proc,
1497: p_argument => 'grade_rule_id',
1498: p_argument_value => p_grade_rule_id);
1499: --

Line 1549: hr_api.validate_bus_grp_id(p_rec.business_group_id);

1545: -- Business Rule Mapping
1546: -- =====================
1547: -- Rule CHK_BUSINESS_GROUP_ID / a,c
1548: --
1549: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1550: --
1551: hr_utility.set_location(l_proc, 6);
1552: --
1553: -- Validate grade or spinal point id

Line 1863: hr_api.mandatory_arg_error(p_api_name => l_proc,

1859: hr_utility.set_location('Entering:'|| l_proc, 10);
1860: --
1861: -- Ensure that all the mandatory parameter are not null
1862: --
1863: hr_api.mandatory_arg_error(p_api_name => l_proc,
1864: p_argument => 'grade_rule_id',
1865: p_argument_value => p_grade_rule_id);
1866: --
1867: if nvl(g_grade_rule_id, hr_api.g_number) = p_grade_rule_id then

Line 1867: if nvl(g_grade_rule_id, hr_api.g_number) = p_grade_rule_id then

1863: hr_api.mandatory_arg_error(p_api_name => l_proc,
1864: p_argument => 'grade_rule_id',
1865: p_argument_value => p_grade_rule_id);
1866: --
1867: if nvl(g_grade_rule_id, hr_api.g_number) = p_grade_rule_id then
1868: --
1869: -- The legislation code has already been found with a previous
1870: -- call to this function. Just return the value in the global
1871: -- variable.