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 BEN_SHR_SHD

Line 48: l_api_updating := ben_shr_shd.api_updating

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

Line 55: <> ben_shr_shd.g_old_rec.schedd_hrs_rt_id) then

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

Line 59: ben_shr_shd.constraint_error('BEN_SCHEDD_HRS_RT_PK');

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

Line 69: ben_shr_shd.constraint_error('BEN_SCHEDD_HRS_RT_PK');

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

Line 117: l_api_updating := ben_shr_shd.api_updating

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

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 276: l_api_updating := ben_shr_shd.api_updating

272: BEGIN
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_shr_shd.api_updating
277: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
278: p_effective_date => p_effective_date,
279: p_object_version_number => p_object_version_number);
280: --

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 347: l_api_updating := ben_shr_shd.api_updating

343: Begin
344: --
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: l_api_updating := ben_shr_shd.api_updating
348: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
349: p_effective_date => p_effective_date,
350: p_object_version_number => p_object_version_number);
351: --

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 624: l_api_updating := ben_shr_shd.api_updating

620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623:
624: l_api_updating := ben_shr_shd.api_updating
625: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
626: p_effective_date => p_effective_date,
627: p_object_version_number => p_object_version_number);
628: --

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 764: l_api_updating := ben_shr_shd.api_updating

760: --
761: Begin
762: hr_utility.set_location('Entering:'||l_proc, 5);
763: --
764: l_api_updating := ben_shr_shd.api_updating
765: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
766: p_effective_date => p_effective_date,
767: p_object_version_number => p_object_version_number);
768: --

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 825: l_api_updating := ben_shr_shd.api_updating

821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: l_api_updating := ben_shr_shd.api_updating
826: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
827: p_effective_date => p_effective_date,
828: p_object_version_number => p_object_version_number);
829: --

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 891: l_api_updating := ben_shr_shd.api_updating

887: --
888: Begin
889: hr_utility.set_location('Entering:'||l_proc, 5);
890:
891: l_api_updating := ben_shr_shd.api_updating
892: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
893: p_effective_date => p_effective_date,
894: p_object_version_number => p_object_version_number);
895: --

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 959: l_api_updating := ben_shr_shd.api_updating

955: --
956: Begin
957: hr_utility.set_location('Entering:'||l_proc, 5);
958: --
959: l_api_updating := ben_shr_shd.api_updating
960: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
961: p_effective_date => p_effective_date,
962: p_object_version_number => p_object_version_number);
963: --

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 1024: l_api_updating := ben_shr_shd.api_updating

1020:
1021: Begin
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: l_api_updating := ben_shr_shd.api_updating
1025: (p_schedd_hrs_rt_id => p_schedd_hrs_rt_id,
1026: p_effective_date => p_effective_date,
1027: p_object_version_number => p_object_version_number);
1028: --

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 1063: (p_rec in ben_shr_shd.g_rec_type,

1059: -- ----------------------------------------------------------------------------
1060: -- |---------------------------< insert_validate >----------------------------|
1061: -- ----------------------------------------------------------------------------
1062: Procedure insert_validate
1063: (p_rec in ben_shr_shd.g_rec_type,
1064: p_effective_date in date,
1065: p_datetrack_mode in varchar2,
1066: p_validation_start_date in date,
1067: p_validation_end_date in date) is

Line 1177: (p_rec in ben_shr_shd.g_rec_type,

1173: -- ----------------------------------------------------------------------------
1174: -- |---------------------------< update_validate >----------------------------|
1175: -- ----------------------------------------------------------------------------
1176: Procedure update_validate
1177: (p_rec in ben_shr_shd.g_rec_type,
1178: p_effective_date in date,
1179: p_datetrack_mode in varchar2,
1180: p_validation_start_date in date,
1181: p_validation_end_date in date) is

Line 1293: (p_rec in ben_shr_shd.g_rec_type,

1289: -- ----------------------------------------------------------------------------
1290: -- |---------------------------< delete_validate >----------------------------|
1291: -- ----------------------------------------------------------------------------
1292: Procedure delete_validate
1293: (p_rec in ben_shr_shd.g_rec_type,
1294: p_effective_date in date,
1295: p_datetrack_mode in varchar2,
1296: p_validation_start_date in date,
1297: p_validation_end_date in date) is