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_LAR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_lar_shd.g_old_rec.loa_rsn_cd,hr_api.g_varchar2)

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

Line 131: if hr_api.not_exists_in_hr_lookups

127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: --
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'ABSENCE_REASON',
133: p_lookup_code => p_loa_rsn_cd,
134: p_effective_date => p_effective_date) then
135: --

Line 206: and loa_rsn_rt_id <> nvl(p_loa_rsn_rt_id,hr_api.g_number)

202: where -- loa_rsn_cd = p_loa_rsn_cd and
203: absence_attendance_type_id = p_absence_attendance_type_id
204: and nvl(abs_attendance_reason_id,-1) = nvl(p_abs_attendance_reason_id,-1)
205: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
206: and loa_rsn_rt_id <> nvl(p_loa_rsn_rt_id,hr_api.g_number)
207: and business_group_id + 0 = p_business_group_id
208: and p_validation_start_date <= effective_end_date
209: and p_validation_end_date >= effective_start_date;
210: --

Line 221: and ( -- p_loa_rsn_cd <> nvl(ben_lar_shd.g_old_rec.loa_rsn_cd,hr_api.g_varchar2) or

217: p_effective_date => p_effective_date,
218: p_object_version_number => p_object_version_number);
219: --
220: if (l_api_updating
221: and ( -- p_loa_rsn_cd <> nvl(ben_lar_shd.g_old_rec.loa_rsn_cd,hr_api.g_varchar2) or
222: p_absence_attendance_type_id <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
223: or nvl(p_abs_attendance_reason_id,hr_api.g_number) <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number))
224: or not l_api_updating) then
225:

Line 222: p_absence_attendance_type_id <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)

218: p_object_version_number => p_object_version_number);
219: --
220: if (l_api_updating
221: and ( -- p_loa_rsn_cd <> nvl(ben_lar_shd.g_old_rec.loa_rsn_cd,hr_api.g_varchar2) or
222: p_absence_attendance_type_id <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
223: or nvl(p_abs_attendance_reason_id,hr_api.g_number) <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number))
224: or not l_api_updating) then
225:
226: open c_dup;

Line 223: or nvl(p_abs_attendance_reason_id,hr_api.g_number) <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number))

219: --
220: if (l_api_updating
221: and ( -- p_loa_rsn_cd <> nvl(ben_lar_shd.g_old_rec.loa_rsn_cd,hr_api.g_varchar2) or
222: p_absence_attendance_type_id <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
223: or nvl(p_abs_attendance_reason_id,hr_api.g_number) <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number))
224: or not l_api_updating) then
225:
226: open c_dup;
227: fetch c_dup into l_exists;

Line 350: <> nvl(ben_lar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating
349: and p_excld_flag
350: <> nvl(ben_lar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
351: or not l_api_updating) then
352: --
353: -- check if value of lookup falls within lookup type.
354: --

Line 356: if hr_api.not_exists_in_hr_lookups

352: --
353: -- check if value of lookup falls within lookup type.
354: --
355: --
356: if hr_api.not_exists_in_hr_lookups
357: (p_lookup_type => 'YES_NO',
358: p_lookup_code => p_excld_flag,
359: p_effective_date => p_effective_date) then
360: --

Line 424: and nvl(p_absence_attendance_type_id,hr_api.g_number)

420: p_effective_date => p_effective_date,
421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and nvl(p_absence_attendance_type_id,hr_api.g_number)
425: <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
426: or not l_api_updating)
427: and p_absence_attendance_type_id is not null then
428: --

Line 425: <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)

421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and nvl(p_absence_attendance_type_id,hr_api.g_number)
425: <> nvl(ben_lar_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
426: or not l_api_updating)
427: and p_absence_attendance_type_id is not null then
428: --
429: -- check if absence_attendance_type_id value exists in

Line 505: and nvl(p_abs_attendance_reason_id,hr_api.g_number)

501: p_effective_date => p_effective_date,
502: p_object_version_number => p_object_version_number);
503: --
504: if (l_api_updating
505: and nvl(p_abs_attendance_reason_id,hr_api.g_number)
506: <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)
507: or not l_api_updating)
508: and p_abs_attendance_reason_id is not null then
509: --

Line 506: <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)

502: p_object_version_number => p_object_version_number);
503: --
504: if (l_api_updating
505: and nvl(p_abs_attendance_reason_id,hr_api.g_number)
506: <> nvl(ben_lar_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)
507: or not l_api_updating)
508: and p_abs_attendance_reason_id is not null then
509: --
510: -- check if abs_attendance_reason_id value exists in

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

561: --
562: -- {End Of Comments}
563: -- ----------------------------------------------------------------------------
564: Procedure dt_update_validate
565: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
566: p_datetrack_mode in varchar2,
567: p_validation_start_date in date,
568: p_validation_end_date in date) Is
569: --

Line 579: hr_api.mandatory_arg_error

575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Ensure that the p_datetrack_mode argument is not null
578: --
579: hr_api.mandatory_arg_error
580: (p_api_name => l_proc,
581: p_argument => 'datetrack_mode',
582: p_argument_value => p_datetrack_mode);
583: --

Line 591: hr_api.mandatory_arg_error

587: --
588: --
589: -- Ensure the arguments are not null
590: --
591: hr_api.mandatory_arg_error
592: (p_api_name => l_proc,
593: p_argument => 'validation_start_date',
594: p_argument_value => p_validation_start_date);
595: --

Line 596: hr_api.mandatory_arg_error

592: (p_api_name => l_proc,
593: p_argument => 'validation_start_date',
594: p_argument_value => p_validation_start_date);
595: --
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc,
598: p_argument => 'validation_end_date',
599: p_argument_value => p_validation_end_date);
600: --

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

598: p_argument => 'validation_end_date',
599: p_argument_value => p_validation_end_date);
600: --
601: --
602: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
603: NOT (dt_api.check_min_max_dates
604: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
605: p_base_key_column => 'vrbl_rt_prfl_id',
606: p_base_key_value => p_vrbl_rt_prfl_id,

Line 684: hr_api.mandatory_arg_error

680: hr_utility.set_location('Entering:'||l_proc, 5);
681: --
682: -- Ensure that the p_datetrack_mode argument is not null
683: --
684: hr_api.mandatory_arg_error
685: (p_api_name => l_proc,
686: p_argument => 'datetrack_mode',
687: p_argument_value => p_datetrack_mode);
688: --

Line 698: hr_api.mandatory_arg_error

694: --
695: --
696: -- Ensure the arguments are not null
697: --
698: hr_api.mandatory_arg_error
699: (p_api_name => l_proc,
700: p_argument => 'validation_start_date',
701: p_argument_value => p_validation_start_date);
702: --

Line 703: hr_api.mandatory_arg_error

699: (p_api_name => l_proc,
700: p_argument => 'validation_start_date',
701: p_argument_value => p_validation_start_date);
702: --
703: hr_api.mandatory_arg_error
704: (p_api_name => l_proc,
705: p_argument => 'validation_end_date',
706: p_argument_value => p_validation_end_date);
707: --

Line 708: hr_api.mandatory_arg_error

704: (p_api_name => l_proc,
705: p_argument => 'validation_end_date',
706: p_argument_value => p_validation_end_date);
707: --
708: hr_api.mandatory_arg_error
709: (p_api_name => l_proc,
710: p_argument => 'loa_rsn_rt_id',
711: p_argument_value => p_loa_rsn_rt_id);
712: --

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

752: --
753: -- Call all supporting business operations
754: --
755: --
756: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
757: --
758: chk_loa_rsn_rt_id
759: (p_loa_rsn_rt_id => p_rec.loa_rsn_rt_id,
760: p_effective_date => p_effective_date,

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

825: --
826: -- Call all supporting business operations
827: --
828: --
829: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
830: --
831: chk_loa_rsn_rt_id
832: (p_loa_rsn_rt_id => p_rec.loa_rsn_rt_id,
833: p_effective_date => p_effective_date,

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

942: hr_utility.set_location('Entering:'|| l_proc, 10);
943: --
944: -- Ensure that all the mandatory parameter are not null
945: --
946: hr_api.mandatory_arg_error(p_api_name => l_proc,
947: p_argument => 'loa_rsn_rt_id',
948: p_argument_value => p_loa_rsn_rt_id);
949: --
950: open csr_leg_code;