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.PER_SHA_BUS dependencies on PER_STD_HOLIDAY_ABSENCES

Line 99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

95: -- {End of Comments}
96: --
97: -- ---------------------------------------------------------------------------
98: procedure chk_date_not_taken
99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
102: ,p_expired in per_std_holiday_absences.expired%TYPE
103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

Line 100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE

96: --
97: -- ---------------------------------------------------------------------------
98: procedure chk_date_not_taken
99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
102: ,p_expired in per_std_holiday_absences.expired%TYPE
103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
104: ) is

Line 101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

97: -- ---------------------------------------------------------------------------
98: procedure chk_date_not_taken
99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
102: ,p_expired in per_std_holiday_absences.expired%TYPE
103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
104: ) is
105: --

Line 102: ,p_expired in per_std_holiday_absences.expired%TYPE

98: procedure chk_date_not_taken
99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
102: ,p_expired in per_std_holiday_absences.expired%TYPE
103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
104: ) is
105: --
106: l_proc varchar2(72) := g_package||'chk_date_not_taken';

Line 103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

99: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
100: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
101: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
102: ,p_expired in per_std_holiday_absences.expired%TYPE
103: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
104: ) is
105: --
106: l_proc varchar2(72) := g_package||'chk_date_not_taken';
107: l_api_updating boolean;

Line 180: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

176: -- {End of Comments}
177: --
178: -- ---------------------------------------------------------------------------
179: procedure chk_person_id
180: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
183: ) is
184: --

Line 181: ,p_person_id in per_std_holiday_absences.person_id%TYPE

177: --
178: -- ---------------------------------------------------------------------------
179: procedure chk_person_id
180: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'chk_person_id';

Line 182: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE

178: -- ---------------------------------------------------------------------------
179: procedure chk_person_id
180: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'chk_person_id';
186: l_dummy number;

Line 251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

247: -- {End of Comments}
248: --
249: -- ---------------------------------------------------------------------------
250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

Line 252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE

248: --
249: -- ---------------------------------------------------------------------------
250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is

Line 253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

249: -- ---------------------------------------------------------------------------
250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is
257: --

Line 254: ,p_expired in per_std_holiday_absences.expired%TYPE

250: procedure chk_standard_holiday_id
251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'chk_standard_holiday_id';

Line 255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

251: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
252: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
253: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
254: ,p_expired in per_std_holiday_absences.expired%TYPE
255: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'chk_standard_holiday_id';
259: l_dummy number;

Line 343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

339: -- {End of Comments}
340: --
341: -- ---------------------------------------------------------------------------
342: procedure chk_actual_date_taken
343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
345: ,p_person_id in per_std_holiday_absences.person_id%TYPE
346: ,p_expired in per_std_holiday_absences.expired%TYPE
347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

Line 344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

340: --
341: -- ---------------------------------------------------------------------------
342: procedure chk_actual_date_taken
343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
345: ,p_person_id in per_std_holiday_absences.person_id%TYPE
346: ,p_expired in per_std_holiday_absences.expired%TYPE
347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
348: ) is

Line 345: ,p_person_id in per_std_holiday_absences.person_id%TYPE

341: -- ---------------------------------------------------------------------------
342: procedure chk_actual_date_taken
343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
345: ,p_person_id in per_std_holiday_absences.person_id%TYPE
346: ,p_expired in per_std_holiday_absences.expired%TYPE
347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
348: ) is
349: --

Line 346: ,p_expired in per_std_holiday_absences.expired%TYPE

342: procedure chk_actual_date_taken
343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
345: ,p_person_id in per_std_holiday_absences.person_id%TYPE
346: ,p_expired in per_std_holiday_absences.expired%TYPE
347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
348: ) is
349: --
350: l_proc varchar2(72) := g_package||'chk_actual_date_taken';

Line 347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

343: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
344: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
345: ,p_person_id in per_std_holiday_absences.person_id%TYPE
346: ,p_expired in per_std_holiday_absences.expired%TYPE
347: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
348: ) is
349: --
350: l_proc varchar2(72) := g_package||'chk_actual_date_taken';
351: l_dummy number(15);

Line 436: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE

432: -- {End of Comments}
433: --
434: -- ---------------------------------------------------------------------------
435: procedure chk_expired
436: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
437: ,p_expired in per_std_holiday_absences.expired%TYPE
438: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
439: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
440: ) is

Line 437: ,p_expired in per_std_holiday_absences.expired%TYPE

433: --
434: -- ---------------------------------------------------------------------------
435: procedure chk_expired
436: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
437: ,p_expired in per_std_holiday_absences.expired%TYPE
438: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
439: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
440: ) is
441: --

Line 438: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE

434: -- ---------------------------------------------------------------------------
435: procedure chk_expired
436: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
437: ,p_expired in per_std_holiday_absences.expired%TYPE
438: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
439: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
440: ) is
441: --
442: l_proc varchar2(72) := g_package||'chk_expired';

Line 439: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE

435: procedure chk_expired
436: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
437: ,p_expired in per_std_holiday_absences.expired%TYPE
438: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
439: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
440: ) is
441: --
442: l_proc varchar2(72) := g_package||'chk_expired';
443: l_api_updating boolean;

Line 561: ,p_descflex_name => 'PER_STD_HOLIDAY_ABSENCES'

557: -- b) During insert.
558: --
559: hr_dflex_utility.ins_or_upd_descflex_attribs
560: (p_appl_short_name => 'PER'
561: ,p_descflex_name => 'PER_STD_HOLIDAY_ABSENCES'
562: ,p_attribute_category => p_rec.attribute_category
563: ,p_attribute1_name => 'ATTRIBUTE1'
564: ,p_attribute1_value => p_rec.attribute1
565: ,p_attribute2_name => 'ATTRIBUTE2'

Line 778: , per_std_holiday_absences sha

774: cursor csr_leg_code is
775: select pbg.legislation_code
776: from per_business_groups pbg
777: , per_people_f per
778: , per_std_holiday_absences sha
779: where sha.std_holiday_absences_id = p_std_holiday_absences_id
780: and per.person_id = sha.person_id
781: and pbg.business_group_id = per.business_group_id
782: order by per.effective_start_date;