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
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
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: --
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';
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;
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: --
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';
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;
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
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
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: --
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';
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;
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
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
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: --
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';
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);
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
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: --
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';
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;
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'
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;