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

Line 54: and nvl(p_schedd_hrs_rt_id,hr_api.g_number)

50: p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_schedd_hrs_rt_id,hr_api.g_number)
55: <> ben_shr_shd.g_old_rec.schedd_hrs_rt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_freq_cd
124: <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_freq_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_freq_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'FREQUENCY',
132: p_lookup_code => p_freq_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 189: where schedd_hrs_rt_id <> nvl(p_schedd_hrs_rt_id,hr_api.g_number)

185: l_dummy char(1);
186: cursor c1 is
187: select null
188: from ben_schedd_hrs_rt_f
189: where schedd_hrs_rt_id <> nvl(p_schedd_hrs_rt_id,hr_api.g_number)
190: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
191: and ordr_num = p_ordr_num
192: and business_group_id = p_business_group_id;
193: --

Line 267: and schedd_hrs_rt_id <> nvl(p_schedd_hrs_rt_id,hr_api.g_number)

263: and nvl(freq_cd,'freq_cd') = nvl(p_freq_cd,'freq_cd')
264: and nvl(max_hrs_num,-99999999999) = nvl(p_max_hrs_num,-99999999999)
265: and nvl(schedd_hrs_rl,-99999999999) = nvl(p_schedd_hrs_rl,-99999999999)
266: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
267: and schedd_hrs_rt_id <> nvl(p_schedd_hrs_rt_id,hr_api.g_number)
268: and business_group_id + 0 = p_business_group_id
269: and p_validation_start_date <= effective_end_date
270: and p_validation_end_date >= effective_start_date;
271: --

Line 282: and ( p_hrs_num <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)

278: p_effective_date => p_effective_date,
279: p_object_version_number => p_object_version_number);
280: --
281: if (l_api_updating
282: and ( p_hrs_num <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
283: or p_max_hrs_num <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
284: or p_freq_cd <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
285: or p_schedd_hrs_rl <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
286: or not l_api_updating) then

Line 283: or p_max_hrs_num <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)

279: p_object_version_number => p_object_version_number);
280: --
281: if (l_api_updating
282: and ( p_hrs_num <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
283: or p_max_hrs_num <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
284: or p_freq_cd <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
285: or p_schedd_hrs_rl <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
286: or not l_api_updating) then
287:

Line 284: or p_freq_cd <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)

280: --
281: if (l_api_updating
282: and ( p_hrs_num <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
283: or p_max_hrs_num <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
284: or p_freq_cd <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
285: or p_schedd_hrs_rl <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
286: or not l_api_updating) then
287:
288: open c_dup;

Line 285: or p_schedd_hrs_rl <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )

281: if (l_api_updating
282: and ( p_hrs_num <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
283: or p_max_hrs_num <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
284: or p_freq_cd <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
285: or p_schedd_hrs_rl <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
286: or not l_api_updating) then
287:
288: open c_dup;
289: fetch c_dup into l_exists;

Line 354: <> nvl(ben_shr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

350: p_object_version_number => p_object_version_number);
351: --
352: if (l_api_updating
353: and p_excld_flag
354: <> nvl(ben_shr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
355: or not l_api_updating) then
356: --
357: -- check if value of lookup falls within lookup type.
358: --

Line 360: if hr_api.not_exists_in_hr_lookups

356: --
357: -- check if value of lookup falls within lookup type.
358: --
359: --
360: if hr_api.not_exists_in_hr_lookups
361: (p_lookup_type => 'YES_NO',
362: p_lookup_code => p_excld_flag,
363: p_effective_date => p_effective_date) then
364: --

Line 408: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure dt_update_validate
408: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
409: p_datetrack_mode in varchar2,
410: p_validation_start_date in date,
411: p_validation_end_date in date) Is
412: --

Line 422: hr_api.mandatory_arg_error

418: hr_utility.set_location('Entering:'||l_proc, 5);
419: --
420: -- Ensure that the p_datetrack_mode argument is not null
421: --
422: hr_api.mandatory_arg_error
423: (p_api_name => l_proc,
424: p_argument => 'datetrack_mode',
425: p_argument_value => p_datetrack_mode);
426: --

Line 434: hr_api.mandatory_arg_error

430: --
431: --
432: -- Ensure the arguments are not null
433: --
434: hr_api.mandatory_arg_error
435: (p_api_name => l_proc,
436: p_argument => 'validation_start_date',
437: p_argument_value => p_validation_start_date);
438: --

Line 439: hr_api.mandatory_arg_error

435: (p_api_name => l_proc,
436: p_argument => 'validation_start_date',
437: p_argument_value => p_validation_start_date);
438: --
439: hr_api.mandatory_arg_error
440: (p_api_name => l_proc,
441: p_argument => 'validation_end_date',
442: p_argument_value => p_validation_end_date);
443: --

Line 444: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

440: (p_api_name => l_proc,
441: p_argument => 'validation_end_date',
442: p_argument_value => p_validation_end_date);
443: --
444: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
445: NOT (dt_api.check_min_max_dates
446: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
447: p_base_key_column => 'vrbl_rt_prfl_id',
448: p_base_key_value => p_vrbl_rt_prfl_id,

Line 528: hr_api.mandatory_arg_error

524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Ensure that the p_datetrack_mode argument is not null
527: --
528: hr_api.mandatory_arg_error
529: (p_api_name => l_proc,
530: p_argument => 'datetrack_mode',
531: p_argument_value => p_datetrack_mode);
532: --

Line 542: hr_api.mandatory_arg_error

538: --
539: --
540: -- Ensure the arguments are not null
541: --
542: hr_api.mandatory_arg_error
543: (p_api_name => l_proc,
544: p_argument => 'validation_start_date',
545: p_argument_value => p_validation_start_date);
546: --

Line 547: hr_api.mandatory_arg_error

543: (p_api_name => l_proc,
544: p_argument => 'validation_start_date',
545: p_argument_value => p_validation_start_date);
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => 'validation_end_date',
550: p_argument_value => p_validation_end_date);
551: --

Line 552: hr_api.mandatory_arg_error

548: (p_api_name => l_proc,
549: p_argument => 'validation_end_date',
550: p_argument_value => p_validation_end_date);
551: --
552: hr_api.mandatory_arg_error
553: (p_api_name => l_proc,
554: p_argument => 'schedd_hrs_rt_id',
555: p_argument_value => p_schedd_hrs_rt_id);
556: --

Line 630: and ( nvl(p_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)

626: p_effective_date => p_effective_date,
627: p_object_version_number => p_object_version_number);
628: --
629: if (l_api_updating
630: and ( nvl(p_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
631: or nvl(p_max_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
632: or nvl(p_freq_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
633: or nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
634: or not l_api_updating) then

Line 631: or nvl(p_max_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)

627: p_object_version_number => p_object_version_number);
628: --
629: if (l_api_updating
630: and ( nvl(p_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
631: or nvl(p_max_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
632: or nvl(p_freq_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
633: or nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
634: or not l_api_updating) then
635: --

Line 632: or nvl(p_freq_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)

628: --
629: if (l_api_updating
630: and ( nvl(p_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
631: or nvl(p_max_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
632: or nvl(p_freq_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
633: or nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
634: or not l_api_updating) then
635: --
636: if (p_schedd_hrs_rl is not null) then

Line 633: or nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )

629: if (l_api_updating
630: and ( nvl(p_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.hrs_num,hr_api.g_number)
631: or nvl(p_max_hrs_num,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.max_hrs_num,hr_api.g_number)
632: or nvl(p_freq_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.freq_cd,hr_api.g_varchar2)
633: or nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number) )
634: or not l_api_updating) then
635: --
636: if (p_schedd_hrs_rl is not null) then
637: if (p_hrs_num is not null) or (p_max_hrs_num is not null) then

Line 770: and nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number)

766: p_effective_date => p_effective_date,
767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating
770: and nvl(p_schedd_hrs_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.schedd_hrs_rl,hr_api.g_number)
771: or not l_api_updating) then
772: --
773: If (p_schedd_hrs_rl is not null) then
774: If (not match_formula_type

Line 831: and nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2)

827: p_effective_date => p_effective_date,
828: p_object_version_number => p_object_version_number);
829: --
830: if (l_api_updating
831: and nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2)
832: or not l_api_updating) then
833: --
834: if (p_determination_cd is not null) then
835: if hr_api.not_exists_in_hr_lookups

Line 835: if hr_api.not_exists_in_hr_lookups

831: and nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2)
832: or not l_api_updating) then
833: --
834: if (p_determination_cd is not null) then
835: if hr_api.not_exists_in_hr_lookups
836: (p_lookup_type => 'BEN_LOS_DET',
837: p_lookup_code => p_determination_cd,
838: p_effective_date => p_effective_date) then
839: --

Line 897: and (nvl(p_determination_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.determination_rl,hr_api.g_number)

893: p_effective_date => p_effective_date,
894: p_object_version_number => p_object_version_number);
895: --
896: if (l_api_updating
897: and (nvl(p_determination_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.determination_rl,hr_api.g_number)
898: or nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2) )
899: or not l_api_updating) then
900: --
901: If (p_determination_cd = 'RL') then

Line 898: or nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2) )

894: p_object_version_number => p_object_version_number);
895: --
896: if (l_api_updating
897: and (nvl(p_determination_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.determination_rl,hr_api.g_number)
898: or nvl(p_determination_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.determination_cd,hr_api.g_varchar2) )
899: or not l_api_updating) then
900: --
901: If (p_determination_cd = 'RL') then
902: If (p_determination_rl is null) then

Line 965: and nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2)

961: p_effective_date => p_effective_date,
962: p_object_version_number => p_object_version_number);
963: --
964: if (l_api_updating
965: and nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2)
966: or not l_api_updating) then
967:
968: if (p_rounding_cd is not null) then
969: if hr_api.not_exists_in_hr_lookups

Line 969: if hr_api.not_exists_in_hr_lookups

965: and nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2)
966: or not l_api_updating) then
967:
968: if (p_rounding_cd is not null) then
969: if hr_api.not_exists_in_hr_lookups
970: (p_lookup_type => 'BEN_RNDG',
971: p_lookup_code => p_rounding_cd,
972: p_effective_date => p_effective_date) then
973: --

Line 1030: and (nvl(p_rounding_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.rounding_rl,hr_api.g_number)

1026: p_effective_date => p_effective_date,
1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating
1030: and (nvl(p_rounding_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.rounding_rl,hr_api.g_number)
1031: or nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2) )
1032: or not l_api_updating) then
1033:
1034: If (p_rounding_cd = 'RL') then

Line 1031: or nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2) )

1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating
1030: and (nvl(p_rounding_rl,hr_api.g_number) <> nvl(ben_shr_shd.g_old_rec.rounding_rl,hr_api.g_number)
1031: or nvl(p_rounding_cd,hr_api.g_varchar2) <> nvl(ben_shr_shd.g_old_rec.rounding_cd,hr_api.g_varchar2) )
1032: or not l_api_updating) then
1033:
1034: If (p_rounding_cd = 'RL') then
1035: If (p_rounding_rl is null) then

Line 1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1075: --
1076: -- Call all supporting business operations
1077: --
1078: --
1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1080: --
1081: chk_schedd_hrs_rt_id
1082: (p_schedd_hrs_rt_id => p_rec.schedd_hrs_rt_id,
1083: p_effective_date => p_effective_date,

Line 1191: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1187: --
1188: -- Call all supporting business operations
1189: --
1190: --
1191: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1192: --
1193: chk_schedd_hrs_rt_id
1194: (p_schedd_hrs_rt_id => p_rec.schedd_hrs_rt_id,
1195: p_effective_date => p_effective_date,

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

1339: hr_utility.set_location('Entering:'|| l_proc, 10);
1340: --
1341: -- Ensure that all the mandatory parameter are not null
1342: --
1343: hr_api.mandatory_arg_error(p_api_name => l_proc,
1344: p_argument => 'schedd_hrs_rt_id',
1345: p_argument_value => p_schedd_hrs_rt_id);
1346: --
1347: open csr_leg_code;