[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_abb_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_abb_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_absence_attendance_types Row
69: --
70: update per_absence_attendance_types
131: ,advance_pay = p_rec.advance_pay
132: ,absence_overlap_flag = p_rec.absence_overlap_flag
133: where absence_attendance_type_id = p_rec.absence_attendance_type_id;
134: --
135: per_abb_shd.g_api_dml := false; -- Unset the api dml status
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: --
139: Exception
138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: per_abb_shd.g_api_dml := false; -- Unset the api dml status
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: per_abb_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: per_abb_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;
159: --
160: -- ----------------------------------------------------------------------------
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure pre_update
193: (p_rec in per_abb_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72) := g_package||'pre_update';
197: --
233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure post_update
237: (p_rec in per_abb_shd.g_rec_type
238: ) is
239: --
240: l_proc varchar2(72) := g_package||'post_update';
241: --
368: ,p_absence_overlap_flag
369: => p_rec.absence_overlap_flag
370: --
371: ,p_business_group_id_o
372: => per_abb_shd.g_old_rec.business_group_id
373: ,p_input_value_id_o
374: => per_abb_shd.g_old_rec.input_value_id
375: ,p_date_effective_o
376: => per_abb_shd.g_old_rec.date_effective
370: --
371: ,p_business_group_id_o
372: => per_abb_shd.g_old_rec.business_group_id
373: ,p_input_value_id_o
374: => per_abb_shd.g_old_rec.input_value_id
375: ,p_date_effective_o
376: => per_abb_shd.g_old_rec.date_effective
377: ,p_name_o
378: => per_abb_shd.g_old_rec.name
372: => per_abb_shd.g_old_rec.business_group_id
373: ,p_input_value_id_o
374: => per_abb_shd.g_old_rec.input_value_id
375: ,p_date_effective_o
376: => per_abb_shd.g_old_rec.date_effective
377: ,p_name_o
378: => per_abb_shd.g_old_rec.name
379: ,p_absence_category_o
380: => per_abb_shd.g_old_rec.absence_category
374: => per_abb_shd.g_old_rec.input_value_id
375: ,p_date_effective_o
376: => per_abb_shd.g_old_rec.date_effective
377: ,p_name_o
378: => per_abb_shd.g_old_rec.name
379: ,p_absence_category_o
380: => per_abb_shd.g_old_rec.absence_category
381: ,p_comments_o
382: => per_abb_shd.g_old_rec.comments
376: => per_abb_shd.g_old_rec.date_effective
377: ,p_name_o
378: => per_abb_shd.g_old_rec.name
379: ,p_absence_category_o
380: => per_abb_shd.g_old_rec.absence_category
381: ,p_comments_o
382: => per_abb_shd.g_old_rec.comments
383: ,p_date_end_o
384: => per_abb_shd.g_old_rec.date_end
378: => per_abb_shd.g_old_rec.name
379: ,p_absence_category_o
380: => per_abb_shd.g_old_rec.absence_category
381: ,p_comments_o
382: => per_abb_shd.g_old_rec.comments
383: ,p_date_end_o
384: => per_abb_shd.g_old_rec.date_end
385: ,p_hours_or_days_o
386: => per_abb_shd.g_old_rec.hours_or_days
380: => per_abb_shd.g_old_rec.absence_category
381: ,p_comments_o
382: => per_abb_shd.g_old_rec.comments
383: ,p_date_end_o
384: => per_abb_shd.g_old_rec.date_end
385: ,p_hours_or_days_o
386: => per_abb_shd.g_old_rec.hours_or_days
387: ,p_inc_or_dec_flag_o
388: => per_abb_shd.g_old_rec.increasing_or_decreasing_flag
382: => per_abb_shd.g_old_rec.comments
383: ,p_date_end_o
384: => per_abb_shd.g_old_rec.date_end
385: ,p_hours_or_days_o
386: => per_abb_shd.g_old_rec.hours_or_days
387: ,p_inc_or_dec_flag_o
388: => per_abb_shd.g_old_rec.increasing_or_decreasing_flag
389: ,p_request_id_o
390: => per_abb_shd.g_old_rec.request_id
384: => per_abb_shd.g_old_rec.date_end
385: ,p_hours_or_days_o
386: => per_abb_shd.g_old_rec.hours_or_days
387: ,p_inc_or_dec_flag_o
388: => per_abb_shd.g_old_rec.increasing_or_decreasing_flag
389: ,p_request_id_o
390: => per_abb_shd.g_old_rec.request_id
391: ,p_program_application_id_o
392: => per_abb_shd.g_old_rec.program_application_id
386: => per_abb_shd.g_old_rec.hours_or_days
387: ,p_inc_or_dec_flag_o
388: => per_abb_shd.g_old_rec.increasing_or_decreasing_flag
389: ,p_request_id_o
390: => per_abb_shd.g_old_rec.request_id
391: ,p_program_application_id_o
392: => per_abb_shd.g_old_rec.program_application_id
393: ,p_program_id_o
394: => per_abb_shd.g_old_rec.program_id
388: => per_abb_shd.g_old_rec.increasing_or_decreasing_flag
389: ,p_request_id_o
390: => per_abb_shd.g_old_rec.request_id
391: ,p_program_application_id_o
392: => per_abb_shd.g_old_rec.program_application_id
393: ,p_program_id_o
394: => per_abb_shd.g_old_rec.program_id
395: ,p_program_update_date_o
396: => per_abb_shd.g_old_rec.program_update_date
390: => per_abb_shd.g_old_rec.request_id
391: ,p_program_application_id_o
392: => per_abb_shd.g_old_rec.program_application_id
393: ,p_program_id_o
394: => per_abb_shd.g_old_rec.program_id
395: ,p_program_update_date_o
396: => per_abb_shd.g_old_rec.program_update_date
397: ,p_attribute_category_o
398: => per_abb_shd.g_old_rec.attribute_category
392: => per_abb_shd.g_old_rec.program_application_id
393: ,p_program_id_o
394: => per_abb_shd.g_old_rec.program_id
395: ,p_program_update_date_o
396: => per_abb_shd.g_old_rec.program_update_date
397: ,p_attribute_category_o
398: => per_abb_shd.g_old_rec.attribute_category
399: ,p_attribute1_o
400: => per_abb_shd.g_old_rec.attribute1
394: => per_abb_shd.g_old_rec.program_id
395: ,p_program_update_date_o
396: => per_abb_shd.g_old_rec.program_update_date
397: ,p_attribute_category_o
398: => per_abb_shd.g_old_rec.attribute_category
399: ,p_attribute1_o
400: => per_abb_shd.g_old_rec.attribute1
401: ,p_attribute2_o
402: => per_abb_shd.g_old_rec.attribute2
396: => per_abb_shd.g_old_rec.program_update_date
397: ,p_attribute_category_o
398: => per_abb_shd.g_old_rec.attribute_category
399: ,p_attribute1_o
400: => per_abb_shd.g_old_rec.attribute1
401: ,p_attribute2_o
402: => per_abb_shd.g_old_rec.attribute2
403: ,p_attribute3_o
404: => per_abb_shd.g_old_rec.attribute3
398: => per_abb_shd.g_old_rec.attribute_category
399: ,p_attribute1_o
400: => per_abb_shd.g_old_rec.attribute1
401: ,p_attribute2_o
402: => per_abb_shd.g_old_rec.attribute2
403: ,p_attribute3_o
404: => per_abb_shd.g_old_rec.attribute3
405: ,p_attribute4_o
406: => per_abb_shd.g_old_rec.attribute4
400: => per_abb_shd.g_old_rec.attribute1
401: ,p_attribute2_o
402: => per_abb_shd.g_old_rec.attribute2
403: ,p_attribute3_o
404: => per_abb_shd.g_old_rec.attribute3
405: ,p_attribute4_o
406: => per_abb_shd.g_old_rec.attribute4
407: ,p_attribute5_o
408: => per_abb_shd.g_old_rec.attribute5
402: => per_abb_shd.g_old_rec.attribute2
403: ,p_attribute3_o
404: => per_abb_shd.g_old_rec.attribute3
405: ,p_attribute4_o
406: => per_abb_shd.g_old_rec.attribute4
407: ,p_attribute5_o
408: => per_abb_shd.g_old_rec.attribute5
409: ,p_attribute6_o
410: => per_abb_shd.g_old_rec.attribute6
404: => per_abb_shd.g_old_rec.attribute3
405: ,p_attribute4_o
406: => per_abb_shd.g_old_rec.attribute4
407: ,p_attribute5_o
408: => per_abb_shd.g_old_rec.attribute5
409: ,p_attribute6_o
410: => per_abb_shd.g_old_rec.attribute6
411: ,p_attribute7_o
412: => per_abb_shd.g_old_rec.attribute7
406: => per_abb_shd.g_old_rec.attribute4
407: ,p_attribute5_o
408: => per_abb_shd.g_old_rec.attribute5
409: ,p_attribute6_o
410: => per_abb_shd.g_old_rec.attribute6
411: ,p_attribute7_o
412: => per_abb_shd.g_old_rec.attribute7
413: ,p_attribute8_o
414: => per_abb_shd.g_old_rec.attribute8
408: => per_abb_shd.g_old_rec.attribute5
409: ,p_attribute6_o
410: => per_abb_shd.g_old_rec.attribute6
411: ,p_attribute7_o
412: => per_abb_shd.g_old_rec.attribute7
413: ,p_attribute8_o
414: => per_abb_shd.g_old_rec.attribute8
415: ,p_attribute9_o
416: => per_abb_shd.g_old_rec.attribute9
410: => per_abb_shd.g_old_rec.attribute6
411: ,p_attribute7_o
412: => per_abb_shd.g_old_rec.attribute7
413: ,p_attribute8_o
414: => per_abb_shd.g_old_rec.attribute8
415: ,p_attribute9_o
416: => per_abb_shd.g_old_rec.attribute9
417: ,p_attribute10_o
418: => per_abb_shd.g_old_rec.attribute10
412: => per_abb_shd.g_old_rec.attribute7
413: ,p_attribute8_o
414: => per_abb_shd.g_old_rec.attribute8
415: ,p_attribute9_o
416: => per_abb_shd.g_old_rec.attribute9
417: ,p_attribute10_o
418: => per_abb_shd.g_old_rec.attribute10
419: ,p_attribute11_o
420: => per_abb_shd.g_old_rec.attribute11
414: => per_abb_shd.g_old_rec.attribute8
415: ,p_attribute9_o
416: => per_abb_shd.g_old_rec.attribute9
417: ,p_attribute10_o
418: => per_abb_shd.g_old_rec.attribute10
419: ,p_attribute11_o
420: => per_abb_shd.g_old_rec.attribute11
421: ,p_attribute12_o
422: => per_abb_shd.g_old_rec.attribute12
416: => per_abb_shd.g_old_rec.attribute9
417: ,p_attribute10_o
418: => per_abb_shd.g_old_rec.attribute10
419: ,p_attribute11_o
420: => per_abb_shd.g_old_rec.attribute11
421: ,p_attribute12_o
422: => per_abb_shd.g_old_rec.attribute12
423: ,p_attribute13_o
424: => per_abb_shd.g_old_rec.attribute13
418: => per_abb_shd.g_old_rec.attribute10
419: ,p_attribute11_o
420: => per_abb_shd.g_old_rec.attribute11
421: ,p_attribute12_o
422: => per_abb_shd.g_old_rec.attribute12
423: ,p_attribute13_o
424: => per_abb_shd.g_old_rec.attribute13
425: ,p_attribute14_o
426: => per_abb_shd.g_old_rec.attribute14
420: => per_abb_shd.g_old_rec.attribute11
421: ,p_attribute12_o
422: => per_abb_shd.g_old_rec.attribute12
423: ,p_attribute13_o
424: => per_abb_shd.g_old_rec.attribute13
425: ,p_attribute14_o
426: => per_abb_shd.g_old_rec.attribute14
427: ,p_attribute15_o
428: => per_abb_shd.g_old_rec.attribute15
422: => per_abb_shd.g_old_rec.attribute12
423: ,p_attribute13_o
424: => per_abb_shd.g_old_rec.attribute13
425: ,p_attribute14_o
426: => per_abb_shd.g_old_rec.attribute14
427: ,p_attribute15_o
428: => per_abb_shd.g_old_rec.attribute15
429: ,p_attribute16_o
430: => per_abb_shd.g_old_rec.attribute16
424: => per_abb_shd.g_old_rec.attribute13
425: ,p_attribute14_o
426: => per_abb_shd.g_old_rec.attribute14
427: ,p_attribute15_o
428: => per_abb_shd.g_old_rec.attribute15
429: ,p_attribute16_o
430: => per_abb_shd.g_old_rec.attribute16
431: ,p_attribute17_o
432: => per_abb_shd.g_old_rec.attribute17
426: => per_abb_shd.g_old_rec.attribute14
427: ,p_attribute15_o
428: => per_abb_shd.g_old_rec.attribute15
429: ,p_attribute16_o
430: => per_abb_shd.g_old_rec.attribute16
431: ,p_attribute17_o
432: => per_abb_shd.g_old_rec.attribute17
433: ,p_attribute18_o
434: => per_abb_shd.g_old_rec.attribute18
428: => per_abb_shd.g_old_rec.attribute15
429: ,p_attribute16_o
430: => per_abb_shd.g_old_rec.attribute16
431: ,p_attribute17_o
432: => per_abb_shd.g_old_rec.attribute17
433: ,p_attribute18_o
434: => per_abb_shd.g_old_rec.attribute18
435: ,p_attribute19_o
436: => per_abb_shd.g_old_rec.attribute19
430: => per_abb_shd.g_old_rec.attribute16
431: ,p_attribute17_o
432: => per_abb_shd.g_old_rec.attribute17
433: ,p_attribute18_o
434: => per_abb_shd.g_old_rec.attribute18
435: ,p_attribute19_o
436: => per_abb_shd.g_old_rec.attribute19
437: ,p_attribute20_o
438: => per_abb_shd.g_old_rec.attribute20
432: => per_abb_shd.g_old_rec.attribute17
433: ,p_attribute18_o
434: => per_abb_shd.g_old_rec.attribute18
435: ,p_attribute19_o
436: => per_abb_shd.g_old_rec.attribute19
437: ,p_attribute20_o
438: => per_abb_shd.g_old_rec.attribute20
439: ,p_object_version_number_o
440: => per_abb_shd.g_old_rec.object_version_number
434: => per_abb_shd.g_old_rec.attribute18
435: ,p_attribute19_o
436: => per_abb_shd.g_old_rec.attribute19
437: ,p_attribute20_o
438: => per_abb_shd.g_old_rec.attribute20
439: ,p_object_version_number_o
440: => per_abb_shd.g_old_rec.object_version_number
441: ,p_information_category_o
442: => per_abb_shd.g_old_rec.information_category
436: => per_abb_shd.g_old_rec.attribute19
437: ,p_attribute20_o
438: => per_abb_shd.g_old_rec.attribute20
439: ,p_object_version_number_o
440: => per_abb_shd.g_old_rec.object_version_number
441: ,p_information_category_o
442: => per_abb_shd.g_old_rec.information_category
443: ,p_information1_o
444: => per_abb_shd.g_old_rec.information1
438: => per_abb_shd.g_old_rec.attribute20
439: ,p_object_version_number_o
440: => per_abb_shd.g_old_rec.object_version_number
441: ,p_information_category_o
442: => per_abb_shd.g_old_rec.information_category
443: ,p_information1_o
444: => per_abb_shd.g_old_rec.information1
445: ,p_information2_o
446: => per_abb_shd.g_old_rec.information2
440: => per_abb_shd.g_old_rec.object_version_number
441: ,p_information_category_o
442: => per_abb_shd.g_old_rec.information_category
443: ,p_information1_o
444: => per_abb_shd.g_old_rec.information1
445: ,p_information2_o
446: => per_abb_shd.g_old_rec.information2
447: ,p_information3_o
448: => per_abb_shd.g_old_rec.information3
442: => per_abb_shd.g_old_rec.information_category
443: ,p_information1_o
444: => per_abb_shd.g_old_rec.information1
445: ,p_information2_o
446: => per_abb_shd.g_old_rec.information2
447: ,p_information3_o
448: => per_abb_shd.g_old_rec.information3
449: ,p_information4_o
450: => per_abb_shd.g_old_rec.information4
444: => per_abb_shd.g_old_rec.information1
445: ,p_information2_o
446: => per_abb_shd.g_old_rec.information2
447: ,p_information3_o
448: => per_abb_shd.g_old_rec.information3
449: ,p_information4_o
450: => per_abb_shd.g_old_rec.information4
451: ,p_information5_o
452: => per_abb_shd.g_old_rec.information5
446: => per_abb_shd.g_old_rec.information2
447: ,p_information3_o
448: => per_abb_shd.g_old_rec.information3
449: ,p_information4_o
450: => per_abb_shd.g_old_rec.information4
451: ,p_information5_o
452: => per_abb_shd.g_old_rec.information5
453: ,p_information6_o
454: => per_abb_shd.g_old_rec.information6
448: => per_abb_shd.g_old_rec.information3
449: ,p_information4_o
450: => per_abb_shd.g_old_rec.information4
451: ,p_information5_o
452: => per_abb_shd.g_old_rec.information5
453: ,p_information6_o
454: => per_abb_shd.g_old_rec.information6
455: ,p_information7_o
456: => per_abb_shd.g_old_rec.information7
450: => per_abb_shd.g_old_rec.information4
451: ,p_information5_o
452: => per_abb_shd.g_old_rec.information5
453: ,p_information6_o
454: => per_abb_shd.g_old_rec.information6
455: ,p_information7_o
456: => per_abb_shd.g_old_rec.information7
457: ,p_information8_o
458: => per_abb_shd.g_old_rec.information8
452: => per_abb_shd.g_old_rec.information5
453: ,p_information6_o
454: => per_abb_shd.g_old_rec.information6
455: ,p_information7_o
456: => per_abb_shd.g_old_rec.information7
457: ,p_information8_o
458: => per_abb_shd.g_old_rec.information8
459: ,p_information9_o
460: => per_abb_shd.g_old_rec.information9
454: => per_abb_shd.g_old_rec.information6
455: ,p_information7_o
456: => per_abb_shd.g_old_rec.information7
457: ,p_information8_o
458: => per_abb_shd.g_old_rec.information8
459: ,p_information9_o
460: => per_abb_shd.g_old_rec.information9
461: ,p_information10_o
462: => per_abb_shd.g_old_rec.information10
456: => per_abb_shd.g_old_rec.information7
457: ,p_information8_o
458: => per_abb_shd.g_old_rec.information8
459: ,p_information9_o
460: => per_abb_shd.g_old_rec.information9
461: ,p_information10_o
462: => per_abb_shd.g_old_rec.information10
463: ,p_information11_o
464: => per_abb_shd.g_old_rec.information11
458: => per_abb_shd.g_old_rec.information8
459: ,p_information9_o
460: => per_abb_shd.g_old_rec.information9
461: ,p_information10_o
462: => per_abb_shd.g_old_rec.information10
463: ,p_information11_o
464: => per_abb_shd.g_old_rec.information11
465: ,p_information12_o
466: => per_abb_shd.g_old_rec.information12
460: => per_abb_shd.g_old_rec.information9
461: ,p_information10_o
462: => per_abb_shd.g_old_rec.information10
463: ,p_information11_o
464: => per_abb_shd.g_old_rec.information11
465: ,p_information12_o
466: => per_abb_shd.g_old_rec.information12
467: ,p_information13_o
468: => per_abb_shd.g_old_rec.information13
462: => per_abb_shd.g_old_rec.information10
463: ,p_information11_o
464: => per_abb_shd.g_old_rec.information11
465: ,p_information12_o
466: => per_abb_shd.g_old_rec.information12
467: ,p_information13_o
468: => per_abb_shd.g_old_rec.information13
469: ,p_information14_o
470: => per_abb_shd.g_old_rec.information14
464: => per_abb_shd.g_old_rec.information11
465: ,p_information12_o
466: => per_abb_shd.g_old_rec.information12
467: ,p_information13_o
468: => per_abb_shd.g_old_rec.information13
469: ,p_information14_o
470: => per_abb_shd.g_old_rec.information14
471: ,p_information15_o
472: => per_abb_shd.g_old_rec.information15
466: => per_abb_shd.g_old_rec.information12
467: ,p_information13_o
468: => per_abb_shd.g_old_rec.information13
469: ,p_information14_o
470: => per_abb_shd.g_old_rec.information14
471: ,p_information15_o
472: => per_abb_shd.g_old_rec.information15
473: ,p_information16_o
474: => per_abb_shd.g_old_rec.information16
468: => per_abb_shd.g_old_rec.information13
469: ,p_information14_o
470: => per_abb_shd.g_old_rec.information14
471: ,p_information15_o
472: => per_abb_shd.g_old_rec.information15
473: ,p_information16_o
474: => per_abb_shd.g_old_rec.information16
475: ,p_information17_o
476: => per_abb_shd.g_old_rec.information17
470: => per_abb_shd.g_old_rec.information14
471: ,p_information15_o
472: => per_abb_shd.g_old_rec.information15
473: ,p_information16_o
474: => per_abb_shd.g_old_rec.information16
475: ,p_information17_o
476: => per_abb_shd.g_old_rec.information17
477: ,p_information18_o
478: => per_abb_shd.g_old_rec.information18
472: => per_abb_shd.g_old_rec.information15
473: ,p_information16_o
474: => per_abb_shd.g_old_rec.information16
475: ,p_information17_o
476: => per_abb_shd.g_old_rec.information17
477: ,p_information18_o
478: => per_abb_shd.g_old_rec.information18
479: ,p_information19_o
480: => per_abb_shd.g_old_rec.information19
474: => per_abb_shd.g_old_rec.information16
475: ,p_information17_o
476: => per_abb_shd.g_old_rec.information17
477: ,p_information18_o
478: => per_abb_shd.g_old_rec.information18
479: ,p_information19_o
480: => per_abb_shd.g_old_rec.information19
481: ,p_information20_o
482: => per_abb_shd.g_old_rec.information20
476: => per_abb_shd.g_old_rec.information17
477: ,p_information18_o
478: => per_abb_shd.g_old_rec.information18
479: ,p_information19_o
480: => per_abb_shd.g_old_rec.information19
481: ,p_information20_o
482: => per_abb_shd.g_old_rec.information20
483: --
484: ,p_user_role_o
478: => per_abb_shd.g_old_rec.information18
479: ,p_information19_o
480: => per_abb_shd.g_old_rec.information19
481: ,p_information20_o
482: => per_abb_shd.g_old_rec.information20
483: --
484: ,p_user_role_o
485: => per_abb_shd.g_old_rec.user_role
486: ,p_assignment_status_type_id_o
481: ,p_information20_o
482: => per_abb_shd.g_old_rec.information20
483: --
484: ,p_user_role_o
485: => per_abb_shd.g_old_rec.user_role
486: ,p_assignment_status_type_id_o
487: => per_abb_shd.g_old_rec.assignment_status_type_id
488: ,p_advance_pay_o
489: => per_abb_shd.g_old_rec.advance_pay
483: --
484: ,p_user_role_o
485: => per_abb_shd.g_old_rec.user_role
486: ,p_assignment_status_type_id_o
487: => per_abb_shd.g_old_rec.assignment_status_type_id
488: ,p_advance_pay_o
489: => per_abb_shd.g_old_rec.advance_pay
490: ,p_absence_overlap_flag_o
491: => p_rec.absence_overlap_flag
485: => per_abb_shd.g_old_rec.user_role
486: ,p_assignment_status_type_id_o
487: => per_abb_shd.g_old_rec.assignment_status_type_id
488: ,p_advance_pay_o
489: => per_abb_shd.g_old_rec.advance_pay
490: ,p_absence_overlap_flag_o
491: => p_rec.absence_overlap_flag
492: --
493: );
548: --
549: -- {End Of Comments}
550: -- ----------------------------------------------------------------------------
551: Procedure convert_defs
552: (p_rec in out nocopy per_abb_shd.g_rec_type
553: ) is
554: --
555: Begin
556: --
560: -- is being used then we must set to the 'current' argument value.
561: --
562: If (p_rec.business_group_id = hr_api.g_number) then
563: p_rec.business_group_id :=
564: per_abb_shd.g_old_rec.business_group_id;
565: End If;
566: If (p_rec.input_value_id = hr_api.g_number) then
567: p_rec.input_value_id :=
568: per_abb_shd.g_old_rec.input_value_id;
564: per_abb_shd.g_old_rec.business_group_id;
565: End If;
566: If (p_rec.input_value_id = hr_api.g_number) then
567: p_rec.input_value_id :=
568: per_abb_shd.g_old_rec.input_value_id;
569: End If;
570: If (p_rec.date_effective = hr_api.g_date) then
571: p_rec.date_effective :=
572: per_abb_shd.g_old_rec.date_effective;
568: per_abb_shd.g_old_rec.input_value_id;
569: End If;
570: If (p_rec.date_effective = hr_api.g_date) then
571: p_rec.date_effective :=
572: per_abb_shd.g_old_rec.date_effective;
573: End If;
574: If (p_rec.name = hr_api.g_varchar2) then
575: p_rec.name :=
576: per_abb_shd.g_old_rec.name;
572: per_abb_shd.g_old_rec.date_effective;
573: End If;
574: If (p_rec.name = hr_api.g_varchar2) then
575: p_rec.name :=
576: per_abb_shd.g_old_rec.name;
577: End If;
578: If (p_rec.absence_category = hr_api.g_varchar2) then
579: p_rec.absence_category :=
580: per_abb_shd.g_old_rec.absence_category;
576: per_abb_shd.g_old_rec.name;
577: End If;
578: If (p_rec.absence_category = hr_api.g_varchar2) then
579: p_rec.absence_category :=
580: per_abb_shd.g_old_rec.absence_category;
581: End If;
582: If (p_rec.comments = hr_api.g_varchar2) then
583: p_rec.comments :=
584: per_abb_shd.g_old_rec.comments;
580: per_abb_shd.g_old_rec.absence_category;
581: End If;
582: If (p_rec.comments = hr_api.g_varchar2) then
583: p_rec.comments :=
584: per_abb_shd.g_old_rec.comments;
585: End If;
586: If (p_rec.hours_or_days = hr_api.g_varchar2) then
587: p_rec.hours_or_days :=
588: per_abb_shd.g_old_rec.hours_or_days;
584: per_abb_shd.g_old_rec.comments;
585: End If;
586: If (p_rec.hours_or_days = hr_api.g_varchar2) then
587: p_rec.hours_or_days :=
588: per_abb_shd.g_old_rec.hours_or_days;
589: End If;
590: If (p_rec.increasing_or_decreasing_flag = hr_api.g_varchar2) then
591: p_rec.increasing_or_decreasing_flag :=
592: per_abb_shd.g_old_rec.increasing_or_decreasing_flag;
588: per_abb_shd.g_old_rec.hours_or_days;
589: End If;
590: If (p_rec.increasing_or_decreasing_flag = hr_api.g_varchar2) then
591: p_rec.increasing_or_decreasing_flag :=
592: per_abb_shd.g_old_rec.increasing_or_decreasing_flag;
593: End If;
594: If (p_rec.request_id = hr_api.g_number) then
595: p_rec.request_id :=
596: per_abb_shd.g_old_rec.request_id;
592: per_abb_shd.g_old_rec.increasing_or_decreasing_flag;
593: End If;
594: If (p_rec.request_id = hr_api.g_number) then
595: p_rec.request_id :=
596: per_abb_shd.g_old_rec.request_id;
597: End If;
598: If (p_rec.program_application_id = hr_api.g_number) then
599: p_rec.program_application_id :=
600: per_abb_shd.g_old_rec.program_application_id;
596: per_abb_shd.g_old_rec.request_id;
597: End If;
598: If (p_rec.program_application_id = hr_api.g_number) then
599: p_rec.program_application_id :=
600: per_abb_shd.g_old_rec.program_application_id;
601: End If;
602: If (p_rec.program_id = hr_api.g_number) then
603: p_rec.program_id :=
604: per_abb_shd.g_old_rec.program_id;
600: per_abb_shd.g_old_rec.program_application_id;
601: End If;
602: If (p_rec.program_id = hr_api.g_number) then
603: p_rec.program_id :=
604: per_abb_shd.g_old_rec.program_id;
605: End If;
606: If (p_rec.program_update_date = hr_api.g_date) then
607: p_rec.program_update_date :=
608: per_abb_shd.g_old_rec.program_update_date;
604: per_abb_shd.g_old_rec.program_id;
605: End If;
606: If (p_rec.program_update_date = hr_api.g_date) then
607: p_rec.program_update_date :=
608: per_abb_shd.g_old_rec.program_update_date;
609: End If;
610: If (p_rec.attribute_category = hr_api.g_varchar2) then
611: p_rec.attribute_category :=
612: per_abb_shd.g_old_rec.attribute_category;
608: per_abb_shd.g_old_rec.program_update_date;
609: End If;
610: If (p_rec.attribute_category = hr_api.g_varchar2) then
611: p_rec.attribute_category :=
612: per_abb_shd.g_old_rec.attribute_category;
613: End If;
614: If (p_rec.attribute1 = hr_api.g_varchar2) then
615: p_rec.attribute1 :=
616: per_abb_shd.g_old_rec.attribute1;
612: per_abb_shd.g_old_rec.attribute_category;
613: End If;
614: If (p_rec.attribute1 = hr_api.g_varchar2) then
615: p_rec.attribute1 :=
616: per_abb_shd.g_old_rec.attribute1;
617: End If;
618: If (p_rec.attribute2 = hr_api.g_varchar2) then
619: p_rec.attribute2 :=
620: per_abb_shd.g_old_rec.attribute2;
616: per_abb_shd.g_old_rec.attribute1;
617: End If;
618: If (p_rec.attribute2 = hr_api.g_varchar2) then
619: p_rec.attribute2 :=
620: per_abb_shd.g_old_rec.attribute2;
621: End If;
622: If (p_rec.attribute3 = hr_api.g_varchar2) then
623: p_rec.attribute3 :=
624: per_abb_shd.g_old_rec.attribute3;
620: per_abb_shd.g_old_rec.attribute2;
621: End If;
622: If (p_rec.attribute3 = hr_api.g_varchar2) then
623: p_rec.attribute3 :=
624: per_abb_shd.g_old_rec.attribute3;
625: End If;
626: If (p_rec.attribute4 = hr_api.g_varchar2) then
627: p_rec.attribute4 :=
628: per_abb_shd.g_old_rec.attribute4;
624: per_abb_shd.g_old_rec.attribute3;
625: End If;
626: If (p_rec.attribute4 = hr_api.g_varchar2) then
627: p_rec.attribute4 :=
628: per_abb_shd.g_old_rec.attribute4;
629: End If;
630: If (p_rec.attribute5 = hr_api.g_varchar2) then
631: p_rec.attribute5 :=
632: per_abb_shd.g_old_rec.attribute5;
628: per_abb_shd.g_old_rec.attribute4;
629: End If;
630: If (p_rec.attribute5 = hr_api.g_varchar2) then
631: p_rec.attribute5 :=
632: per_abb_shd.g_old_rec.attribute5;
633: End If;
634: If (p_rec.attribute6 = hr_api.g_varchar2) then
635: p_rec.attribute6 :=
636: per_abb_shd.g_old_rec.attribute6;
632: per_abb_shd.g_old_rec.attribute5;
633: End If;
634: If (p_rec.attribute6 = hr_api.g_varchar2) then
635: p_rec.attribute6 :=
636: per_abb_shd.g_old_rec.attribute6;
637: End If;
638: If (p_rec.attribute7 = hr_api.g_varchar2) then
639: p_rec.attribute7 :=
640: per_abb_shd.g_old_rec.attribute7;
636: per_abb_shd.g_old_rec.attribute6;
637: End If;
638: If (p_rec.attribute7 = hr_api.g_varchar2) then
639: p_rec.attribute7 :=
640: per_abb_shd.g_old_rec.attribute7;
641: End If;
642: If (p_rec.attribute8 = hr_api.g_varchar2) then
643: p_rec.attribute8 :=
644: per_abb_shd.g_old_rec.attribute8;
640: per_abb_shd.g_old_rec.attribute7;
641: End If;
642: If (p_rec.attribute8 = hr_api.g_varchar2) then
643: p_rec.attribute8 :=
644: per_abb_shd.g_old_rec.attribute8;
645: End If;
646: If (p_rec.attribute9 = hr_api.g_varchar2) then
647: p_rec.attribute9 :=
648: per_abb_shd.g_old_rec.attribute9;
644: per_abb_shd.g_old_rec.attribute8;
645: End If;
646: If (p_rec.attribute9 = hr_api.g_varchar2) then
647: p_rec.attribute9 :=
648: per_abb_shd.g_old_rec.attribute9;
649: End If;
650: If (p_rec.attribute10 = hr_api.g_varchar2) then
651: p_rec.attribute10 :=
652: per_abb_shd.g_old_rec.attribute10;
648: per_abb_shd.g_old_rec.attribute9;
649: End If;
650: If (p_rec.attribute10 = hr_api.g_varchar2) then
651: p_rec.attribute10 :=
652: per_abb_shd.g_old_rec.attribute10;
653: End If;
654: If (p_rec.attribute11 = hr_api.g_varchar2) then
655: p_rec.attribute11 :=
656: per_abb_shd.g_old_rec.attribute11;
652: per_abb_shd.g_old_rec.attribute10;
653: End If;
654: If (p_rec.attribute11 = hr_api.g_varchar2) then
655: p_rec.attribute11 :=
656: per_abb_shd.g_old_rec.attribute11;
657: End If;
658: If (p_rec.attribute12 = hr_api.g_varchar2) then
659: p_rec.attribute12 :=
660: per_abb_shd.g_old_rec.attribute12;
656: per_abb_shd.g_old_rec.attribute11;
657: End If;
658: If (p_rec.attribute12 = hr_api.g_varchar2) then
659: p_rec.attribute12 :=
660: per_abb_shd.g_old_rec.attribute12;
661: End If;
662: If (p_rec.attribute13 = hr_api.g_varchar2) then
663: p_rec.attribute13 :=
664: per_abb_shd.g_old_rec.attribute13;
660: per_abb_shd.g_old_rec.attribute12;
661: End If;
662: If (p_rec.attribute13 = hr_api.g_varchar2) then
663: p_rec.attribute13 :=
664: per_abb_shd.g_old_rec.attribute13;
665: End If;
666: If (p_rec.attribute14 = hr_api.g_varchar2) then
667: p_rec.attribute14 :=
668: per_abb_shd.g_old_rec.attribute14;
664: per_abb_shd.g_old_rec.attribute13;
665: End If;
666: If (p_rec.attribute14 = hr_api.g_varchar2) then
667: p_rec.attribute14 :=
668: per_abb_shd.g_old_rec.attribute14;
669: End If;
670: If (p_rec.attribute15 = hr_api.g_varchar2) then
671: p_rec.attribute15 :=
672: per_abb_shd.g_old_rec.attribute15;
668: per_abb_shd.g_old_rec.attribute14;
669: End If;
670: If (p_rec.attribute15 = hr_api.g_varchar2) then
671: p_rec.attribute15 :=
672: per_abb_shd.g_old_rec.attribute15;
673: End If;
674: If (p_rec.attribute16 = hr_api.g_varchar2) then
675: p_rec.attribute16 :=
676: per_abb_shd.g_old_rec.attribute16;
672: per_abb_shd.g_old_rec.attribute15;
673: End If;
674: If (p_rec.attribute16 = hr_api.g_varchar2) then
675: p_rec.attribute16 :=
676: per_abb_shd.g_old_rec.attribute16;
677: End If;
678: If (p_rec.attribute17 = hr_api.g_varchar2) then
679: p_rec.attribute17 :=
680: per_abb_shd.g_old_rec.attribute17;
676: per_abb_shd.g_old_rec.attribute16;
677: End If;
678: If (p_rec.attribute17 = hr_api.g_varchar2) then
679: p_rec.attribute17 :=
680: per_abb_shd.g_old_rec.attribute17;
681: End If;
682: If (p_rec.attribute18 = hr_api.g_varchar2) then
683: p_rec.attribute18 :=
684: per_abb_shd.g_old_rec.attribute18;
680: per_abb_shd.g_old_rec.attribute17;
681: End If;
682: If (p_rec.attribute18 = hr_api.g_varchar2) then
683: p_rec.attribute18 :=
684: per_abb_shd.g_old_rec.attribute18;
685: End If;
686: If (p_rec.attribute19 = hr_api.g_varchar2) then
687: p_rec.attribute19 :=
688: per_abb_shd.g_old_rec.attribute19;
684: per_abb_shd.g_old_rec.attribute18;
685: End If;
686: If (p_rec.attribute19 = hr_api.g_varchar2) then
687: p_rec.attribute19 :=
688: per_abb_shd.g_old_rec.attribute19;
689: End If;
690: If (p_rec.attribute20 = hr_api.g_varchar2) then
691: p_rec.attribute20 :=
692: per_abb_shd.g_old_rec.attribute20;
688: per_abb_shd.g_old_rec.attribute19;
689: End If;
690: If (p_rec.attribute20 = hr_api.g_varchar2) then
691: p_rec.attribute20 :=
692: per_abb_shd.g_old_rec.attribute20;
693: End If;
694: If (p_rec.information_category = hr_api.g_varchar2) then
695: p_rec.information_category :=
696: per_abb_shd.g_old_rec.information_category;
692: per_abb_shd.g_old_rec.attribute20;
693: End If;
694: If (p_rec.information_category = hr_api.g_varchar2) then
695: p_rec.information_category :=
696: per_abb_shd.g_old_rec.information_category;
697: End If;
698: If (p_rec.information1 = hr_api.g_varchar2) then
699: p_rec.information1 :=
700: per_abb_shd.g_old_rec.information1;
696: per_abb_shd.g_old_rec.information_category;
697: End If;
698: If (p_rec.information1 = hr_api.g_varchar2) then
699: p_rec.information1 :=
700: per_abb_shd.g_old_rec.information1;
701: End If;
702: If (p_rec.information2 = hr_api.g_varchar2) then
703: p_rec.information2 :=
704: per_abb_shd.g_old_rec.information2;
700: per_abb_shd.g_old_rec.information1;
701: End If;
702: If (p_rec.information2 = hr_api.g_varchar2) then
703: p_rec.information2 :=
704: per_abb_shd.g_old_rec.information2;
705: End If;
706: If (p_rec.information3 = hr_api.g_varchar2) then
707: p_rec.information3 :=
708: per_abb_shd.g_old_rec.information3;
704: per_abb_shd.g_old_rec.information2;
705: End If;
706: If (p_rec.information3 = hr_api.g_varchar2) then
707: p_rec.information3 :=
708: per_abb_shd.g_old_rec.information3;
709: End If;
710: If (p_rec.information4 = hr_api.g_varchar2) then
711: p_rec.information4 :=
712: per_abb_shd.g_old_rec.information4;
708: per_abb_shd.g_old_rec.information3;
709: End If;
710: If (p_rec.information4 = hr_api.g_varchar2) then
711: p_rec.information4 :=
712: per_abb_shd.g_old_rec.information4;
713: End If;
714: If (p_rec.information5 = hr_api.g_varchar2) then
715: p_rec.information5 :=
716: per_abb_shd.g_old_rec.information5;
712: per_abb_shd.g_old_rec.information4;
713: End If;
714: If (p_rec.information5 = hr_api.g_varchar2) then
715: p_rec.information5 :=
716: per_abb_shd.g_old_rec.information5;
717: End If;
718: If (p_rec.information6 = hr_api.g_varchar2) then
719: p_rec.information6 :=
720: per_abb_shd.g_old_rec.information6;
716: per_abb_shd.g_old_rec.information5;
717: End If;
718: If (p_rec.information6 = hr_api.g_varchar2) then
719: p_rec.information6 :=
720: per_abb_shd.g_old_rec.information6;
721: End If;
722: If (p_rec.information7 = hr_api.g_varchar2) then
723: p_rec.information7 :=
724: per_abb_shd.g_old_rec.information7;
720: per_abb_shd.g_old_rec.information6;
721: End If;
722: If (p_rec.information7 = hr_api.g_varchar2) then
723: p_rec.information7 :=
724: per_abb_shd.g_old_rec.information7;
725: End If;
726: If (p_rec.information8 = hr_api.g_varchar2) then
727: p_rec.information8 :=
728: per_abb_shd.g_old_rec.information8;
724: per_abb_shd.g_old_rec.information7;
725: End If;
726: If (p_rec.information8 = hr_api.g_varchar2) then
727: p_rec.information8 :=
728: per_abb_shd.g_old_rec.information8;
729: End If;
730: If (p_rec.information9 = hr_api.g_varchar2) then
731: p_rec.information9 :=
732: per_abb_shd.g_old_rec.information9;
728: per_abb_shd.g_old_rec.information8;
729: End If;
730: If (p_rec.information9 = hr_api.g_varchar2) then
731: p_rec.information9 :=
732: per_abb_shd.g_old_rec.information9;
733: End If;
734: If (p_rec.information10 = hr_api.g_varchar2) then
735: p_rec.information10 :=
736: per_abb_shd.g_old_rec.information10;
732: per_abb_shd.g_old_rec.information9;
733: End If;
734: If (p_rec.information10 = hr_api.g_varchar2) then
735: p_rec.information10 :=
736: per_abb_shd.g_old_rec.information10;
737: End If;
738: If (p_rec.information11 = hr_api.g_varchar2) then
739: p_rec.information11 :=
740: per_abb_shd.g_old_rec.information11;
736: per_abb_shd.g_old_rec.information10;
737: End If;
738: If (p_rec.information11 = hr_api.g_varchar2) then
739: p_rec.information11 :=
740: per_abb_shd.g_old_rec.information11;
741: End If;
742: If (p_rec.information12 = hr_api.g_varchar2) then
743: p_rec.information12 :=
744: per_abb_shd.g_old_rec.information12;
740: per_abb_shd.g_old_rec.information11;
741: End If;
742: If (p_rec.information12 = hr_api.g_varchar2) then
743: p_rec.information12 :=
744: per_abb_shd.g_old_rec.information12;
745: End If;
746: If (p_rec.information13 = hr_api.g_varchar2) then
747: p_rec.information13 :=
748: per_abb_shd.g_old_rec.information13;
744: per_abb_shd.g_old_rec.information12;
745: End If;
746: If (p_rec.information13 = hr_api.g_varchar2) then
747: p_rec.information13 :=
748: per_abb_shd.g_old_rec.information13;
749: End If;
750: If (p_rec.information14 = hr_api.g_varchar2) then
751: p_rec.information14 :=
752: per_abb_shd.g_old_rec.information14;
748: per_abb_shd.g_old_rec.information13;
749: End If;
750: If (p_rec.information14 = hr_api.g_varchar2) then
751: p_rec.information14 :=
752: per_abb_shd.g_old_rec.information14;
753: End If;
754: If (p_rec.information15 = hr_api.g_varchar2) then
755: p_rec.information15 :=
756: per_abb_shd.g_old_rec.information15;
752: per_abb_shd.g_old_rec.information14;
753: End If;
754: If (p_rec.information15 = hr_api.g_varchar2) then
755: p_rec.information15 :=
756: per_abb_shd.g_old_rec.information15;
757: End If;
758: If (p_rec.information16 = hr_api.g_varchar2) then
759: p_rec.information16 :=
760: per_abb_shd.g_old_rec.information16;
756: per_abb_shd.g_old_rec.information15;
757: End If;
758: If (p_rec.information16 = hr_api.g_varchar2) then
759: p_rec.information16 :=
760: per_abb_shd.g_old_rec.information16;
761: End If;
762: If (p_rec.information17 = hr_api.g_varchar2) then
763: p_rec.information17 :=
764: per_abb_shd.g_old_rec.information17;
760: per_abb_shd.g_old_rec.information16;
761: End If;
762: If (p_rec.information17 = hr_api.g_varchar2) then
763: p_rec.information17 :=
764: per_abb_shd.g_old_rec.information17;
765: End If;
766: If (p_rec.information18 = hr_api.g_varchar2) then
767: p_rec.information18 :=
768: per_abb_shd.g_old_rec.information18;
764: per_abb_shd.g_old_rec.information17;
765: End If;
766: If (p_rec.information18 = hr_api.g_varchar2) then
767: p_rec.information18 :=
768: per_abb_shd.g_old_rec.information18;
769: End If;
770: If (p_rec.information19 = hr_api.g_varchar2) then
771: p_rec.information19 :=
772: per_abb_shd.g_old_rec.information19;
768: per_abb_shd.g_old_rec.information18;
769: End If;
770: If (p_rec.information19 = hr_api.g_varchar2) then
771: p_rec.information19 :=
772: per_abb_shd.g_old_rec.information19;
773: End If;
774: If (p_rec.information20 = hr_api.g_varchar2) then
775: p_rec.information20 :=
776: per_abb_shd.g_old_rec.information20;
772: per_abb_shd.g_old_rec.information19;
773: End If;
774: If (p_rec.information20 = hr_api.g_varchar2) then
775: p_rec.information20 :=
776: per_abb_shd.g_old_rec.information20;
777: End If;
778: --
779: If (p_rec.user_role = hr_api.g_varchar2) then
780: p_rec.user_role :=
777: End If;
778: --
779: If (p_rec.user_role = hr_api.g_varchar2) then
780: p_rec.user_role :=
781: per_abb_shd.g_old_rec.user_role;
782: End If;
783: If (p_rec.assignment_status_type_id = hr_api.g_number) then
784: p_rec.assignment_status_type_id :=
785: per_abb_shd.g_old_rec.assignment_status_type_id;
781: per_abb_shd.g_old_rec.user_role;
782: End If;
783: If (p_rec.assignment_status_type_id = hr_api.g_number) then
784: p_rec.assignment_status_type_id :=
785: per_abb_shd.g_old_rec.assignment_status_type_id;
786: End If;
787: If (p_rec.advance_pay = hr_api.g_varchar2) then
788: p_rec.advance_pay :=
789: per_abb_shd.g_old_rec.advance_pay;
785: per_abb_shd.g_old_rec.assignment_status_type_id;
786: End If;
787: If (p_rec.advance_pay = hr_api.g_varchar2) then
788: p_rec.advance_pay :=
789: per_abb_shd.g_old_rec.advance_pay;
790: End If;
791: If (p_rec.absence_overlap_flag = hr_api.g_varchar2) then
792: p_rec.absence_overlap_flag :=
793: per_abb_shd.g_old_rec.absence_overlap_flag;
789: per_abb_shd.g_old_rec.advance_pay;
790: End If;
791: If (p_rec.absence_overlap_flag = hr_api.g_varchar2) then
792: p_rec.absence_overlap_flag :=
793: per_abb_shd.g_old_rec.absence_overlap_flag;
794: End If;
795: --
796: --
797: End convert_defs;
799: -- ----------------------------------------------------------------------------
800: -- |---------------------------------< upd >----------------------------------|
801: -- ----------------------------------------------------------------------------
802: Procedure upd
803: (p_rec in out nocopy per_abb_shd.g_rec_type
804: ) is
805: --
806: l_proc varchar2(72) := g_package||'upd';
807: --
809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: -- We must lock the row which we need to update.
812: --
813: per_abb_shd.lck
814: (p_rec.absence_attendance_type_id
815: ,p_rec.object_version_number
816: );
817: --
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
915: ) is
916: --
917: l_rec per_abb_shd.g_rec_type;
918: l_proc varchar2(72) := g_package||'upd';
919: --
920: Begin
921: hr_utility.set_location('Entering:'||l_proc, 5);
923: -- Call conversion function to turn arguments into the
924: -- l_rec structure.
925: --
926: l_rec :=
927: per_abb_shd.convert_args
928: (p_absence_attendance_type_id
929: ,p_business_group_id
930: ,p_input_value_id
931: ,p_date_effective