44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy per_sha_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
99: per_sha_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
103: per_sha_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_sha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: Raise;
111: End update_dml;
141: -- Internal Row Handler Use Only.
142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update(p_rec in per_sha_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --
149: Begin
183: -- Internal Row Handler Use Only.
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update(p_rec in per_sha_shd.g_rec_type) is
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
223: ,p_attribute18 => p_rec.attribute18
224: ,p_attribute19 => p_rec.attribute19
225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
224: ,p_attribute19 => p_rec.attribute19
225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
225: ,p_attribute20 => p_rec.attribute20
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
226: ,p_object_version_number => p_rec.object_version_number
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
227: ,p_date_not_taken_o => per_sha_shd.g_old_rec.date_not_taken
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
228: ,p_person_id_o => per_sha_shd.g_old_rec.person_id
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
229: ,p_standard_holiday_id_o => per_sha_shd.g_old_rec.standard_holiday_id
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
230: ,p_actual_date_taken_o => per_sha_shd.g_old_rec.actual_date_taken
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
231: ,p_reason_o => per_sha_shd.g_old_rec.reason
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
232: ,p_expired_o => per_sha_shd.g_old_rec.expired
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
233: ,p_attribute_category_o => per_sha_shd.g_old_rec.attribute_category
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
234: ,p_attribute1_o => per_sha_shd.g_old_rec.attribute1
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
235: ,p_attribute2_o => per_sha_shd.g_old_rec.attribute2
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
236: ,p_attribute3_o => per_sha_shd.g_old_rec.attribute3
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
237: ,p_attribute4_o => per_sha_shd.g_old_rec.attribute4
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
238: ,p_attribute5_o => per_sha_shd.g_old_rec.attribute5
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
239: ,p_attribute6_o => per_sha_shd.g_old_rec.attribute6
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
240: ,p_attribute7_o => per_sha_shd.g_old_rec.attribute7
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
241: ,p_attribute8_o => per_sha_shd.g_old_rec.attribute8
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
242: ,p_attribute9_o => per_sha_shd.g_old_rec.attribute9
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
243: ,p_attribute10_o => per_sha_shd.g_old_rec.attribute10
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
244: ,p_attribute11_o => per_sha_shd.g_old_rec.attribute11
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
245: ,p_attribute12_o => per_sha_shd.g_old_rec.attribute12
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
246: ,p_attribute13_o => per_sha_shd.g_old_rec.attribute13
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
247: ,p_attribute14_o => per_sha_shd.g_old_rec.attribute14
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
248: ,p_attribute15_o => per_sha_shd.g_old_rec.attribute15
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
249: ,p_attribute16_o => per_sha_shd.g_old_rec.attribute16
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
250: ,p_attribute17_o => per_sha_shd.g_old_rec.attribute17
251: ,p_attribute18_o => per_sha_shd.g_old_rec.attribute18
252: ,p_attribute19_o => per_sha_shd.g_old_rec.attribute19
253: ,p_attribute20_o => per_sha_shd.g_old_rec.attribute20
254: ,p_object_version_number_o => per_sha_shd.g_old_rec.object_version_number
255: );
256: exception
257: when hr_api.cannot_find_prog_unit then
258: hr_api.cannot_find_prog_unit_error
307: -- Internal Row Handler Use Only.
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure convert_defs(p_rec in out nocopy per_sha_shd.g_rec_type) is
312: --
313: l_proc varchar2(72) := g_package||'convert_defs';
314: --
315: Begin
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.date_not_taken = hr_api.g_date) then
325: p_rec.date_not_taken :=
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
326: per_sha_shd.g_old_rec.date_not_taken;
327: End If;
328: If (p_rec.person_id = hr_api.g_number) then
329: p_rec.person_id :=
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
330: per_sha_shd.g_old_rec.person_id;
331: End If;
332: If (p_rec.standard_holiday_id = hr_api.g_number) then
333: p_rec.standard_holiday_id :=
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
334: per_sha_shd.g_old_rec.standard_holiday_id;
335: End If;
336: If (p_rec.actual_date_taken = hr_api.g_date) then
337: p_rec.actual_date_taken :=
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
338: per_sha_shd.g_old_rec.actual_date_taken;
339: End If;
340: If (p_rec.reason = hr_api.g_varchar2) then
341: p_rec.reason :=
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
342: per_sha_shd.g_old_rec.reason;
343: End If;
344: If (p_rec.expired = hr_api.g_varchar2) then
345: p_rec.expired :=
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
346: per_sha_shd.g_old_rec.expired;
347: End If;
348: If (p_rec.attribute_category = hr_api.g_varchar2) then
349: p_rec.attribute_category :=
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
350: per_sha_shd.g_old_rec.attribute_category;
351: End If;
352: If (p_rec.attribute1 = hr_api.g_varchar2) then
353: p_rec.attribute1 :=
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
354: per_sha_shd.g_old_rec.attribute1;
355: End If;
356: If (p_rec.attribute2 = hr_api.g_varchar2) then
357: p_rec.attribute2 :=
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
358: per_sha_shd.g_old_rec.attribute2;
359: End If;
360: If (p_rec.attribute3 = hr_api.g_varchar2) then
361: p_rec.attribute3 :=
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
362: per_sha_shd.g_old_rec.attribute3;
363: End If;
364: If (p_rec.attribute4 = hr_api.g_varchar2) then
365: p_rec.attribute4 :=
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
366: per_sha_shd.g_old_rec.attribute4;
367: End If;
368: If (p_rec.attribute5 = hr_api.g_varchar2) then
369: p_rec.attribute5 :=
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
370: per_sha_shd.g_old_rec.attribute5;
371: End If;
372: If (p_rec.attribute6 = hr_api.g_varchar2) then
373: p_rec.attribute6 :=
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
374: per_sha_shd.g_old_rec.attribute6;
375: End If;
376: If (p_rec.attribute7 = hr_api.g_varchar2) then
377: p_rec.attribute7 :=
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
378: per_sha_shd.g_old_rec.attribute7;
379: End If;
380: If (p_rec.attribute8 = hr_api.g_varchar2) then
381: p_rec.attribute8 :=
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
382: per_sha_shd.g_old_rec.attribute8;
383: End If;
384: If (p_rec.attribute9 = hr_api.g_varchar2) then
385: p_rec.attribute9 :=
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
386: per_sha_shd.g_old_rec.attribute9;
387: End If;
388: If (p_rec.attribute10 = hr_api.g_varchar2) then
389: p_rec.attribute10 :=
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
390: per_sha_shd.g_old_rec.attribute10;
391: End If;
392: If (p_rec.attribute11 = hr_api.g_varchar2) then
393: p_rec.attribute11 :=
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
394: per_sha_shd.g_old_rec.attribute11;
395: End If;
396: If (p_rec.attribute12 = hr_api.g_varchar2) then
397: p_rec.attribute12 :=
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
398: per_sha_shd.g_old_rec.attribute12;
399: End If;
400: If (p_rec.attribute13 = hr_api.g_varchar2) then
401: p_rec.attribute13 :=
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
402: per_sha_shd.g_old_rec.attribute13;
403: End If;
404: If (p_rec.attribute14 = hr_api.g_varchar2) then
405: p_rec.attribute14 :=
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
406: per_sha_shd.g_old_rec.attribute14;
407: End If;
408: If (p_rec.attribute15 = hr_api.g_varchar2) then
409: p_rec.attribute15 :=
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
410: per_sha_shd.g_old_rec.attribute15;
411: End If;
412: If (p_rec.attribute16 = hr_api.g_varchar2) then
413: p_rec.attribute16 :=
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
414: per_sha_shd.g_old_rec.attribute16;
415: End If;
416: If (p_rec.attribute17 = hr_api.g_varchar2) then
417: p_rec.attribute17 :=
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
418: per_sha_shd.g_old_rec.attribute17;
419: End If;
420: If (p_rec.attribute18 = hr_api.g_varchar2) then
421: p_rec.attribute18 :=
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
422: per_sha_shd.g_old_rec.attribute18;
423: End If;
424: If (p_rec.attribute19 = hr_api.g_varchar2) then
425: p_rec.attribute19 :=
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;
426: per_sha_shd.g_old_rec.attribute19;
427: End If;
428: If (p_rec.attribute20 = hr_api.g_varchar2) then
429: p_rec.attribute20 :=
430: per_sha_shd.g_old_rec.attribute20;
431: End If;
432:
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: -- |---------------------------------< upd >----------------------------------|
440: -- ----------------------------------------------------------------------------
441: Procedure upd
442: (
443: p_rec in out nocopy per_sha_shd.g_rec_type
444: ) is
445: --
446: l_proc varchar2(72) := g_package||'upd';
447: --
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- We must lock the row which we need to update.
452: --
453: per_sha_shd.lck
454: (
455: p_rec.std_holiday_absences_id,
456: p_rec.object_version_number
457: );
513: p_attribute20 in varchar2 default hr_api.g_varchar2,
514: p_object_version_number in out nocopy number
515: ) is
516: --
517: l_rec per_sha_shd.g_rec_type;
518: l_proc varchar2(72) := g_package||'upd';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
523: -- Call conversion function to turn arguments into the
524: -- l_rec structure.
525: --
526: l_rec :=
527: per_sha_shd.convert_args
528: (
529: p_std_holiday_absences_id,
530: p_date_not_taken,
531: p_person_id,