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 BEN_LAR_SHD

Line 48: l_api_updating := ben_lar_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_lar_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_loa_rsn_rt_id => p_loa_rsn_rt_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_lar_shd.g_old_rec.loa_rsn_rt_id) then

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: --
59: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_PK');

Line 59: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_PK');

55: <> ben_lar_shd.g_old_rec.loa_rsn_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_PK');

65: if p_loa_rsn_rt_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_PK');
70: --
71: end if;
72: --
73: end if;

Line 117: l_api_updating := ben_lar_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_lar_shd.api_updating
118: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

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 215: l_api_updating := ben_lar_shd.api_updating

211: BEGIN
212: --
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: l_api_updating := ben_lar_shd.api_updating
216: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
217: p_effective_date => p_effective_date,
218: p_object_version_number => p_object_version_number);
219: --

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 343: l_api_updating := ben_lar_shd.api_updating

339: Begin
340: --
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: l_api_updating := ben_lar_shd.api_updating
344: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
345: p_effective_date => p_effective_date,
346: p_object_version_number => p_object_version_number);
347: --

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 418: l_api_updating := ben_lar_shd.api_updating

414: Begin
415: --
416: hr_utility.set_location('Entering:'||l_proc,5);
417: --
418: l_api_updating := ben_lar_shd.api_updating
419: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
420: p_effective_date => p_effective_date,
421: p_object_version_number => p_object_version_number);
422: --

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 442: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK2');

438: --
439: -- raise error as FK does not relate to PK in
440: -- per_absence_attendance_types table.
441: --
442: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK2');
443: --
444: end if;
445: --
446: close c1;

Line 499: l_api_updating := ben_lar_shd.api_updating

495: Begin
496: --
497: hr_utility.set_location('Entering:'||l_proc,5);
498: --
499: l_api_updating := ben_lar_shd.api_updating
500: (p_loa_rsn_rt_id => p_loa_rsn_rt_id,
501: p_effective_date => p_effective_date,
502: p_object_version_number => p_object_version_number);
503: --

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 522: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK3');

518: --
519: -- raise error as FK does not relate to PK in
520: -- per_abs_attendance_reasons table.
521: --
522: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK3');
523: --
524: end if;
525: --
526: close c1;

Line 742: (p_rec in ben_lar_shd.g_rec_type,

738: -- ----------------------------------------------------------------------------
739: -- |---------------------------< insert_validate >----------------------------|
740: -- ----------------------------------------------------------------------------
741: Procedure insert_validate
742: (p_rec in ben_lar_shd.g_rec_type,
743: p_effective_date in date,
744: p_datetrack_mode in varchar2,
745: p_validation_start_date in date,
746: p_validation_end_date in date) is

Line 815: (p_rec in ben_lar_shd.g_rec_type,

811: -- ----------------------------------------------------------------------------
812: -- |---------------------------< update_validate >----------------------------|
813: -- ----------------------------------------------------------------------------
814: Procedure update_validate
815: (p_rec in ben_lar_shd.g_rec_type,
816: p_effective_date in date,
817: p_datetrack_mode in varchar2,
818: p_validation_start_date in date,
819: p_validation_end_date in date) is

Line 896: (p_rec in ben_lar_shd.g_rec_type,

892: -- ----------------------------------------------------------------------------
893: -- |---------------------------< delete_validate >----------------------------|
894: -- ----------------------------------------------------------------------------
895: Procedure delete_validate
896: (p_rec in ben_lar_shd.g_rec_type,
897: p_effective_date in date,
898: p_datetrack_mode in varchar2,
899: p_validation_start_date in date,
900: p_validation_end_date in date) is