61: -- {End of Comments}
62: --
63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
62: --
63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
63: -- ---------------------------------------------------------------------------
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --
64: procedure chk_date_not_taken
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --
72: -- ---------------------------------------------------------------------------
65: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
66: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
67: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
68: ,p_expired in per_std_holiday_absences.expired%TYPE
69: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
70: );
71: --
72: -- ---------------------------------------------------------------------------
73: -- |---------------------------< chk_person_id >-----------------------------|
99: -- {End of Comments}
100: --
101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
100: --
101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
108: -- ---------------------------------------------------------------------------
101: -- ---------------------------------------------------------------------------
102: procedure chk_person_id
103: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
104: ,p_person_id in per_std_holiday_absences.person_id%TYPE
105: ,p_date_not_taken in per_std_holiday_absences.date_not_taken%TYPE
106: );
107: --
108: -- ---------------------------------------------------------------------------
109: -- |----------------------< chk_standard_holiday_id >------------------------|
136: -- {End of Comments}
137: --
138: -- ---------------------------------------------------------------------------
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
137: --
138: -- ---------------------------------------------------------------------------
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
145: );
138: -- ---------------------------------------------------------------------------
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
145: );
146: --
139: procedure chk_standard_holiday_id
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
145: );
146: --
147: -- ---------------------------------------------------------------------------
140: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
141: ,p_standard_holiday_id in per_std_holiday_absences.standard_holiday_id%TYPE
142: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
143: ,p_expired in per_std_holiday_absences.expired%TYPE
144: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
145: );
146: --
147: -- ---------------------------------------------------------------------------
148: -- |-----------------------< chk_actual_date_taken >-------------------------|
175: -- {End of Comments}
176: --
177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
176: --
177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
177: -- ---------------------------------------------------------------------------
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --
178: procedure chk_actual_date_taken
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --
186: -- ---------------------------------------------------------------------------
179: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
180: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
181: ,p_person_id in per_std_holiday_absences.person_id%TYPE
182: ,p_expired in per_std_holiday_absences.expired%TYPE
183: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
184: );
185: --
186: -- ---------------------------------------------------------------------------
187: -- |-----------------------------< chk_expired >-----------------------------|
212: -- {End of Comments}
213: --
214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
213: --
214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --
214: -- ---------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --
222: -- ----------------------------------------------------------------------------
215: procedure chk_expired
216: (p_std_holiday_absences_id in per_std_holiday_absences.std_holiday_absences_id%TYPE
217: ,p_expired in per_std_holiday_absences.expired%TYPE
218: ,p_actual_date_taken in per_std_holiday_absences.actual_date_taken%TYPE
219: ,p_object_version_number in per_std_holiday_absences.object_version_number%TYPE
220: );
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------< insert_validate >----------------------------|