[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_los_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: pqh_los_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: pqh_los_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: pqh_los_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When Others Then
169: --
170: Raise;
202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure pre_update
206: (p_rec in pqh_los_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_update
250: (p_effective_date in date
251: ,p_rec in pqh_los_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
407: => p_rec.attribute30
408: ,p_object_version_number
409: => p_rec.object_version_number
410: ,p_situation_o
411: => pqh_los_shd.g_old_rec.situation
412: ,p_effective_start_date_o
413: => pqh_los_shd.g_old_rec.effective_start_date
414: ,p_effective_end_date_o
415: => pqh_los_shd.g_old_rec.effective_end_date
409: => p_rec.object_version_number
410: ,p_situation_o
411: => pqh_los_shd.g_old_rec.situation
412: ,p_effective_start_date_o
413: => pqh_los_shd.g_old_rec.effective_start_date
414: ,p_effective_end_date_o
415: => pqh_los_shd.g_old_rec.effective_end_date
416: ,p_business_group_id_o
417: => pqh_los_shd.g_old_rec.business_group_id
411: => pqh_los_shd.g_old_rec.situation
412: ,p_effective_start_date_o
413: => pqh_los_shd.g_old_rec.effective_start_date
414: ,p_effective_end_date_o
415: => pqh_los_shd.g_old_rec.effective_end_date
416: ,p_business_group_id_o
417: => pqh_los_shd.g_old_rec.business_group_id
418: ,p_situation_type_o
419: => pqh_los_shd.g_old_rec.situation_type
413: => pqh_los_shd.g_old_rec.effective_start_date
414: ,p_effective_end_date_o
415: => pqh_los_shd.g_old_rec.effective_end_date
416: ,p_business_group_id_o
417: => pqh_los_shd.g_old_rec.business_group_id
418: ,p_situation_type_o
419: => pqh_los_shd.g_old_rec.situation_type
420: ,p_length_of_service_o
421: => pqh_los_shd.g_old_rec.length_of_service
415: => pqh_los_shd.g_old_rec.effective_end_date
416: ,p_business_group_id_o
417: => pqh_los_shd.g_old_rec.business_group_id
418: ,p_situation_type_o
419: => pqh_los_shd.g_old_rec.situation_type
420: ,p_length_of_service_o
421: => pqh_los_shd.g_old_rec.length_of_service
422: ,p_employee_type_o
423: => pqh_los_shd.g_old_rec.employee_type
417: => pqh_los_shd.g_old_rec.business_group_id
418: ,p_situation_type_o
419: => pqh_los_shd.g_old_rec.situation_type
420: ,p_length_of_service_o
421: => pqh_los_shd.g_old_rec.length_of_service
422: ,p_employee_type_o
423: => pqh_los_shd.g_old_rec.employee_type
424: ,p_entitlement_flag_o
425: => pqh_los_shd.g_old_rec.entitlement_flag
419: => pqh_los_shd.g_old_rec.situation_type
420: ,p_length_of_service_o
421: => pqh_los_shd.g_old_rec.length_of_service
422: ,p_employee_type_o
423: => pqh_los_shd.g_old_rec.employee_type
424: ,p_entitlement_flag_o
425: => pqh_los_shd.g_old_rec.entitlement_flag
426: ,p_worktime_proportional_o
427: => pqh_los_shd.g_old_rec.worktime_proportional
421: => pqh_los_shd.g_old_rec.length_of_service
422: ,p_employee_type_o
423: => pqh_los_shd.g_old_rec.employee_type
424: ,p_entitlement_flag_o
425: => pqh_los_shd.g_old_rec.entitlement_flag
426: ,p_worktime_proportional_o
427: => pqh_los_shd.g_old_rec.worktime_proportional
428: ,p_entitlement_value_o
429: => pqh_los_shd.g_old_rec.entitlement_value
423: => pqh_los_shd.g_old_rec.employee_type
424: ,p_entitlement_flag_o
425: => pqh_los_shd.g_old_rec.entitlement_flag
426: ,p_worktime_proportional_o
427: => pqh_los_shd.g_old_rec.worktime_proportional
428: ,p_entitlement_value_o
429: => pqh_los_shd.g_old_rec.entitlement_value
430: ,p_information_category_o
431: => pqh_los_shd.g_old_rec.information_category
425: => pqh_los_shd.g_old_rec.entitlement_flag
426: ,p_worktime_proportional_o
427: => pqh_los_shd.g_old_rec.worktime_proportional
428: ,p_entitlement_value_o
429: => pqh_los_shd.g_old_rec.entitlement_value
430: ,p_information_category_o
431: => pqh_los_shd.g_old_rec.information_category
432: ,p_information1_o
433: => pqh_los_shd.g_old_rec.information1
427: => pqh_los_shd.g_old_rec.worktime_proportional
428: ,p_entitlement_value_o
429: => pqh_los_shd.g_old_rec.entitlement_value
430: ,p_information_category_o
431: => pqh_los_shd.g_old_rec.information_category
432: ,p_information1_o
433: => pqh_los_shd.g_old_rec.information1
434: ,p_information2_o
435: => pqh_los_shd.g_old_rec.information2
429: => pqh_los_shd.g_old_rec.entitlement_value
430: ,p_information_category_o
431: => pqh_los_shd.g_old_rec.information_category
432: ,p_information1_o
433: => pqh_los_shd.g_old_rec.information1
434: ,p_information2_o
435: => pqh_los_shd.g_old_rec.information2
436: ,p_information3_o
437: => pqh_los_shd.g_old_rec.information3
431: => pqh_los_shd.g_old_rec.information_category
432: ,p_information1_o
433: => pqh_los_shd.g_old_rec.information1
434: ,p_information2_o
435: => pqh_los_shd.g_old_rec.information2
436: ,p_information3_o
437: => pqh_los_shd.g_old_rec.information3
438: ,p_information4_o
439: => pqh_los_shd.g_old_rec.information4
433: => pqh_los_shd.g_old_rec.information1
434: ,p_information2_o
435: => pqh_los_shd.g_old_rec.information2
436: ,p_information3_o
437: => pqh_los_shd.g_old_rec.information3
438: ,p_information4_o
439: => pqh_los_shd.g_old_rec.information4
440: ,p_information5_o
441: => pqh_los_shd.g_old_rec.information5
435: => pqh_los_shd.g_old_rec.information2
436: ,p_information3_o
437: => pqh_los_shd.g_old_rec.information3
438: ,p_information4_o
439: => pqh_los_shd.g_old_rec.information4
440: ,p_information5_o
441: => pqh_los_shd.g_old_rec.information5
442: ,p_information6_o
443: => pqh_los_shd.g_old_rec.information6
437: => pqh_los_shd.g_old_rec.information3
438: ,p_information4_o
439: => pqh_los_shd.g_old_rec.information4
440: ,p_information5_o
441: => pqh_los_shd.g_old_rec.information5
442: ,p_information6_o
443: => pqh_los_shd.g_old_rec.information6
444: ,p_information7_o
445: => pqh_los_shd.g_old_rec.information7
439: => pqh_los_shd.g_old_rec.information4
440: ,p_information5_o
441: => pqh_los_shd.g_old_rec.information5
442: ,p_information6_o
443: => pqh_los_shd.g_old_rec.information6
444: ,p_information7_o
445: => pqh_los_shd.g_old_rec.information7
446: ,p_information8_o
447: => pqh_los_shd.g_old_rec.information8
441: => pqh_los_shd.g_old_rec.information5
442: ,p_information6_o
443: => pqh_los_shd.g_old_rec.information6
444: ,p_information7_o
445: => pqh_los_shd.g_old_rec.information7
446: ,p_information8_o
447: => pqh_los_shd.g_old_rec.information8
448: ,p_information9_o
449: => pqh_los_shd.g_old_rec.information9
443: => pqh_los_shd.g_old_rec.information6
444: ,p_information7_o
445: => pqh_los_shd.g_old_rec.information7
446: ,p_information8_o
447: => pqh_los_shd.g_old_rec.information8
448: ,p_information9_o
449: => pqh_los_shd.g_old_rec.information9
450: ,p_information10_o
451: => pqh_los_shd.g_old_rec.information10
445: => pqh_los_shd.g_old_rec.information7
446: ,p_information8_o
447: => pqh_los_shd.g_old_rec.information8
448: ,p_information9_o
449: => pqh_los_shd.g_old_rec.information9
450: ,p_information10_o
451: => pqh_los_shd.g_old_rec.information10
452: ,p_information11_o
453: => pqh_los_shd.g_old_rec.information11
447: => pqh_los_shd.g_old_rec.information8
448: ,p_information9_o
449: => pqh_los_shd.g_old_rec.information9
450: ,p_information10_o
451: => pqh_los_shd.g_old_rec.information10
452: ,p_information11_o
453: => pqh_los_shd.g_old_rec.information11
454: ,p_information12_o
455: => pqh_los_shd.g_old_rec.information12
449: => pqh_los_shd.g_old_rec.information9
450: ,p_information10_o
451: => pqh_los_shd.g_old_rec.information10
452: ,p_information11_o
453: => pqh_los_shd.g_old_rec.information11
454: ,p_information12_o
455: => pqh_los_shd.g_old_rec.information12
456: ,p_information13_o
457: => pqh_los_shd.g_old_rec.information13
451: => pqh_los_shd.g_old_rec.information10
452: ,p_information11_o
453: => pqh_los_shd.g_old_rec.information11
454: ,p_information12_o
455: => pqh_los_shd.g_old_rec.information12
456: ,p_information13_o
457: => pqh_los_shd.g_old_rec.information13
458: ,p_information14_o
459: => pqh_los_shd.g_old_rec.information14
453: => pqh_los_shd.g_old_rec.information11
454: ,p_information12_o
455: => pqh_los_shd.g_old_rec.information12
456: ,p_information13_o
457: => pqh_los_shd.g_old_rec.information13
458: ,p_information14_o
459: => pqh_los_shd.g_old_rec.information14
460: ,p_information15_o
461: => pqh_los_shd.g_old_rec.information15
455: => pqh_los_shd.g_old_rec.information12
456: ,p_information13_o
457: => pqh_los_shd.g_old_rec.information13
458: ,p_information14_o
459: => pqh_los_shd.g_old_rec.information14
460: ,p_information15_o
461: => pqh_los_shd.g_old_rec.information15
462: ,p_information16_o
463: => pqh_los_shd.g_old_rec.information16
457: => pqh_los_shd.g_old_rec.information13
458: ,p_information14_o
459: => pqh_los_shd.g_old_rec.information14
460: ,p_information15_o
461: => pqh_los_shd.g_old_rec.information15
462: ,p_information16_o
463: => pqh_los_shd.g_old_rec.information16
464: ,p_information17_o
465: => pqh_los_shd.g_old_rec.information17
459: => pqh_los_shd.g_old_rec.information14
460: ,p_information15_o
461: => pqh_los_shd.g_old_rec.information15
462: ,p_information16_o
463: => pqh_los_shd.g_old_rec.information16
464: ,p_information17_o
465: => pqh_los_shd.g_old_rec.information17
466: ,p_information18_o
467: => pqh_los_shd.g_old_rec.information18
461: => pqh_los_shd.g_old_rec.information15
462: ,p_information16_o
463: => pqh_los_shd.g_old_rec.information16
464: ,p_information17_o
465: => pqh_los_shd.g_old_rec.information17
466: ,p_information18_o
467: => pqh_los_shd.g_old_rec.information18
468: ,p_information19_o
469: => pqh_los_shd.g_old_rec.information19
463: => pqh_los_shd.g_old_rec.information16
464: ,p_information17_o
465: => pqh_los_shd.g_old_rec.information17
466: ,p_information18_o
467: => pqh_los_shd.g_old_rec.information18
468: ,p_information19_o
469: => pqh_los_shd.g_old_rec.information19
470: ,p_information20_o
471: => pqh_los_shd.g_old_rec.information20
465: => pqh_los_shd.g_old_rec.information17
466: ,p_information18_o
467: => pqh_los_shd.g_old_rec.information18
468: ,p_information19_o
469: => pqh_los_shd.g_old_rec.information19
470: ,p_information20_o
471: => pqh_los_shd.g_old_rec.information20
472: ,p_information21_o
473: => pqh_los_shd.g_old_rec.information21
467: => pqh_los_shd.g_old_rec.information18
468: ,p_information19_o
469: => pqh_los_shd.g_old_rec.information19
470: ,p_information20_o
471: => pqh_los_shd.g_old_rec.information20
472: ,p_information21_o
473: => pqh_los_shd.g_old_rec.information21
474: ,p_information22_o
475: => pqh_los_shd.g_old_rec.information22
469: => pqh_los_shd.g_old_rec.information19
470: ,p_information20_o
471: => pqh_los_shd.g_old_rec.information20
472: ,p_information21_o
473: => pqh_los_shd.g_old_rec.information21
474: ,p_information22_o
475: => pqh_los_shd.g_old_rec.information22
476: ,p_information23_o
477: => pqh_los_shd.g_old_rec.information23
471: => pqh_los_shd.g_old_rec.information20
472: ,p_information21_o
473: => pqh_los_shd.g_old_rec.information21
474: ,p_information22_o
475: => pqh_los_shd.g_old_rec.information22
476: ,p_information23_o
477: => pqh_los_shd.g_old_rec.information23
478: ,p_information24_o
479: => pqh_los_shd.g_old_rec.information24
473: => pqh_los_shd.g_old_rec.information21
474: ,p_information22_o
475: => pqh_los_shd.g_old_rec.information22
476: ,p_information23_o
477: => pqh_los_shd.g_old_rec.information23
478: ,p_information24_o
479: => pqh_los_shd.g_old_rec.information24
480: ,p_information25_o
481: => pqh_los_shd.g_old_rec.information25
475: => pqh_los_shd.g_old_rec.information22
476: ,p_information23_o
477: => pqh_los_shd.g_old_rec.information23
478: ,p_information24_o
479: => pqh_los_shd.g_old_rec.information24
480: ,p_information25_o
481: => pqh_los_shd.g_old_rec.information25
482: ,p_information26_o
483: => pqh_los_shd.g_old_rec.information26
477: => pqh_los_shd.g_old_rec.information23
478: ,p_information24_o
479: => pqh_los_shd.g_old_rec.information24
480: ,p_information25_o
481: => pqh_los_shd.g_old_rec.information25
482: ,p_information26_o
483: => pqh_los_shd.g_old_rec.information26
484: ,p_information27_o
485: => pqh_los_shd.g_old_rec.information27
479: => pqh_los_shd.g_old_rec.information24
480: ,p_information25_o
481: => pqh_los_shd.g_old_rec.information25
482: ,p_information26_o
483: => pqh_los_shd.g_old_rec.information26
484: ,p_information27_o
485: => pqh_los_shd.g_old_rec.information27
486: ,p_information28_o
487: => pqh_los_shd.g_old_rec.information28
481: => pqh_los_shd.g_old_rec.information25
482: ,p_information26_o
483: => pqh_los_shd.g_old_rec.information26
484: ,p_information27_o
485: => pqh_los_shd.g_old_rec.information27
486: ,p_information28_o
487: => pqh_los_shd.g_old_rec.information28
488: ,p_information29_o
489: => pqh_los_shd.g_old_rec.information29
483: => pqh_los_shd.g_old_rec.information26
484: ,p_information27_o
485: => pqh_los_shd.g_old_rec.information27
486: ,p_information28_o
487: => pqh_los_shd.g_old_rec.information28
488: ,p_information29_o
489: => pqh_los_shd.g_old_rec.information29
490: ,p_information30_o
491: => pqh_los_shd.g_old_rec.information30
485: => pqh_los_shd.g_old_rec.information27
486: ,p_information28_o
487: => pqh_los_shd.g_old_rec.information28
488: ,p_information29_o
489: => pqh_los_shd.g_old_rec.information29
490: ,p_information30_o
491: => pqh_los_shd.g_old_rec.information30
492: ,p_attribute_category_o
493: => pqh_los_shd.g_old_rec.attribute_category
487: => pqh_los_shd.g_old_rec.information28
488: ,p_information29_o
489: => pqh_los_shd.g_old_rec.information29
490: ,p_information30_o
491: => pqh_los_shd.g_old_rec.information30
492: ,p_attribute_category_o
493: => pqh_los_shd.g_old_rec.attribute_category
494: ,p_attribute1_o
495: => pqh_los_shd.g_old_rec.attribute1
489: => pqh_los_shd.g_old_rec.information29
490: ,p_information30_o
491: => pqh_los_shd.g_old_rec.information30
492: ,p_attribute_category_o
493: => pqh_los_shd.g_old_rec.attribute_category
494: ,p_attribute1_o
495: => pqh_los_shd.g_old_rec.attribute1
496: ,p_attribute2_o
497: => pqh_los_shd.g_old_rec.attribute2
491: => pqh_los_shd.g_old_rec.information30
492: ,p_attribute_category_o
493: => pqh_los_shd.g_old_rec.attribute_category
494: ,p_attribute1_o
495: => pqh_los_shd.g_old_rec.attribute1
496: ,p_attribute2_o
497: => pqh_los_shd.g_old_rec.attribute2
498: ,p_attribute3_o
499: => pqh_los_shd.g_old_rec.attribute3
493: => pqh_los_shd.g_old_rec.attribute_category
494: ,p_attribute1_o
495: => pqh_los_shd.g_old_rec.attribute1
496: ,p_attribute2_o
497: => pqh_los_shd.g_old_rec.attribute2
498: ,p_attribute3_o
499: => pqh_los_shd.g_old_rec.attribute3
500: ,p_attribute4_o
501: => pqh_los_shd.g_old_rec.attribute4
495: => pqh_los_shd.g_old_rec.attribute1
496: ,p_attribute2_o
497: => pqh_los_shd.g_old_rec.attribute2
498: ,p_attribute3_o
499: => pqh_los_shd.g_old_rec.attribute3
500: ,p_attribute4_o
501: => pqh_los_shd.g_old_rec.attribute4
502: ,p_attribute5_o
503: => pqh_los_shd.g_old_rec.attribute5
497: => pqh_los_shd.g_old_rec.attribute2
498: ,p_attribute3_o
499: => pqh_los_shd.g_old_rec.attribute3
500: ,p_attribute4_o
501: => pqh_los_shd.g_old_rec.attribute4
502: ,p_attribute5_o
503: => pqh_los_shd.g_old_rec.attribute5
504: ,p_attribute6_o
505: => pqh_los_shd.g_old_rec.attribute6
499: => pqh_los_shd.g_old_rec.attribute3
500: ,p_attribute4_o
501: => pqh_los_shd.g_old_rec.attribute4
502: ,p_attribute5_o
503: => pqh_los_shd.g_old_rec.attribute5
504: ,p_attribute6_o
505: => pqh_los_shd.g_old_rec.attribute6
506: ,p_attribute7_o
507: => pqh_los_shd.g_old_rec.attribute7
501: => pqh_los_shd.g_old_rec.attribute4
502: ,p_attribute5_o
503: => pqh_los_shd.g_old_rec.attribute5
504: ,p_attribute6_o
505: => pqh_los_shd.g_old_rec.attribute6
506: ,p_attribute7_o
507: => pqh_los_shd.g_old_rec.attribute7
508: ,p_attribute8_o
509: => pqh_los_shd.g_old_rec.attribute8
503: => pqh_los_shd.g_old_rec.attribute5
504: ,p_attribute6_o
505: => pqh_los_shd.g_old_rec.attribute6
506: ,p_attribute7_o
507: => pqh_los_shd.g_old_rec.attribute7
508: ,p_attribute8_o
509: => pqh_los_shd.g_old_rec.attribute8
510: ,p_attribute9_o
511: => pqh_los_shd.g_old_rec.attribute9
505: => pqh_los_shd.g_old_rec.attribute6
506: ,p_attribute7_o
507: => pqh_los_shd.g_old_rec.attribute7
508: ,p_attribute8_o
509: => pqh_los_shd.g_old_rec.attribute8
510: ,p_attribute9_o
511: => pqh_los_shd.g_old_rec.attribute9
512: ,p_attribute10_o
513: => pqh_los_shd.g_old_rec.attribute10
507: => pqh_los_shd.g_old_rec.attribute7
508: ,p_attribute8_o
509: => pqh_los_shd.g_old_rec.attribute8
510: ,p_attribute9_o
511: => pqh_los_shd.g_old_rec.attribute9
512: ,p_attribute10_o
513: => pqh_los_shd.g_old_rec.attribute10
514: ,p_attribute11_o
515: => pqh_los_shd.g_old_rec.attribute11
509: => pqh_los_shd.g_old_rec.attribute8
510: ,p_attribute9_o
511: => pqh_los_shd.g_old_rec.attribute9
512: ,p_attribute10_o
513: => pqh_los_shd.g_old_rec.attribute10
514: ,p_attribute11_o
515: => pqh_los_shd.g_old_rec.attribute11
516: ,p_attribute12_o
517: => pqh_los_shd.g_old_rec.attribute12
511: => pqh_los_shd.g_old_rec.attribute9
512: ,p_attribute10_o
513: => pqh_los_shd.g_old_rec.attribute10
514: ,p_attribute11_o
515: => pqh_los_shd.g_old_rec.attribute11
516: ,p_attribute12_o
517: => pqh_los_shd.g_old_rec.attribute12
518: ,p_attribute13_o
519: => pqh_los_shd.g_old_rec.attribute13
513: => pqh_los_shd.g_old_rec.attribute10
514: ,p_attribute11_o
515: => pqh_los_shd.g_old_rec.attribute11
516: ,p_attribute12_o
517: => pqh_los_shd.g_old_rec.attribute12
518: ,p_attribute13_o
519: => pqh_los_shd.g_old_rec.attribute13
520: ,p_attribute14_o
521: => pqh_los_shd.g_old_rec.attribute14
515: => pqh_los_shd.g_old_rec.attribute11
516: ,p_attribute12_o
517: => pqh_los_shd.g_old_rec.attribute12
518: ,p_attribute13_o
519: => pqh_los_shd.g_old_rec.attribute13
520: ,p_attribute14_o
521: => pqh_los_shd.g_old_rec.attribute14
522: ,p_attribute15_o
523: => pqh_los_shd.g_old_rec.attribute15
517: => pqh_los_shd.g_old_rec.attribute12
518: ,p_attribute13_o
519: => pqh_los_shd.g_old_rec.attribute13
520: ,p_attribute14_o
521: => pqh_los_shd.g_old_rec.attribute14
522: ,p_attribute15_o
523: => pqh_los_shd.g_old_rec.attribute15
524: ,p_attribute16_o
525: => pqh_los_shd.g_old_rec.attribute16
519: => pqh_los_shd.g_old_rec.attribute13
520: ,p_attribute14_o
521: => pqh_los_shd.g_old_rec.attribute14
522: ,p_attribute15_o
523: => pqh_los_shd.g_old_rec.attribute15
524: ,p_attribute16_o
525: => pqh_los_shd.g_old_rec.attribute16
526: ,p_attribute17_o
527: => pqh_los_shd.g_old_rec.attribute17
521: => pqh_los_shd.g_old_rec.attribute14
522: ,p_attribute15_o
523: => pqh_los_shd.g_old_rec.attribute15
524: ,p_attribute16_o
525: => pqh_los_shd.g_old_rec.attribute16
526: ,p_attribute17_o
527: => pqh_los_shd.g_old_rec.attribute17
528: ,p_attribute18_o
529: => pqh_los_shd.g_old_rec.attribute18
523: => pqh_los_shd.g_old_rec.attribute15
524: ,p_attribute16_o
525: => pqh_los_shd.g_old_rec.attribute16
526: ,p_attribute17_o
527: => pqh_los_shd.g_old_rec.attribute17
528: ,p_attribute18_o
529: => pqh_los_shd.g_old_rec.attribute18
530: ,p_attribute19_o
531: => pqh_los_shd.g_old_rec.attribute19
525: => pqh_los_shd.g_old_rec.attribute16
526: ,p_attribute17_o
527: => pqh_los_shd.g_old_rec.attribute17
528: ,p_attribute18_o
529: => pqh_los_shd.g_old_rec.attribute18
530: ,p_attribute19_o
531: => pqh_los_shd.g_old_rec.attribute19
532: ,p_attribute20_o
533: => pqh_los_shd.g_old_rec.attribute20
527: => pqh_los_shd.g_old_rec.attribute17
528: ,p_attribute18_o
529: => pqh_los_shd.g_old_rec.attribute18
530: ,p_attribute19_o
531: => pqh_los_shd.g_old_rec.attribute19
532: ,p_attribute20_o
533: => pqh_los_shd.g_old_rec.attribute20
534: ,p_attribute21_o
535: => pqh_los_shd.g_old_rec.attribute21
529: => pqh_los_shd.g_old_rec.attribute18
530: ,p_attribute19_o
531: => pqh_los_shd.g_old_rec.attribute19
532: ,p_attribute20_o
533: => pqh_los_shd.g_old_rec.attribute20
534: ,p_attribute21_o
535: => pqh_los_shd.g_old_rec.attribute21
536: ,p_attribute22_o
537: => pqh_los_shd.g_old_rec.attribute22
531: => pqh_los_shd.g_old_rec.attribute19
532: ,p_attribute20_o
533: => pqh_los_shd.g_old_rec.attribute20
534: ,p_attribute21_o
535: => pqh_los_shd.g_old_rec.attribute21
536: ,p_attribute22_o
537: => pqh_los_shd.g_old_rec.attribute22
538: ,p_attribute23_o
539: => pqh_los_shd.g_old_rec.attribute23
533: => pqh_los_shd.g_old_rec.attribute20
534: ,p_attribute21_o
535: => pqh_los_shd.g_old_rec.attribute21
536: ,p_attribute22_o
537: => pqh_los_shd.g_old_rec.attribute22
538: ,p_attribute23_o
539: => pqh_los_shd.g_old_rec.attribute23
540: ,p_attribute24_o
541: => pqh_los_shd.g_old_rec.attribute24
535: => pqh_los_shd.g_old_rec.attribute21
536: ,p_attribute22_o
537: => pqh_los_shd.g_old_rec.attribute22
538: ,p_attribute23_o
539: => pqh_los_shd.g_old_rec.attribute23
540: ,p_attribute24_o
541: => pqh_los_shd.g_old_rec.attribute24
542: ,p_attribute25_o
543: => pqh_los_shd.g_old_rec.attribute25
537: => pqh_los_shd.g_old_rec.attribute22
538: ,p_attribute23_o
539: => pqh_los_shd.g_old_rec.attribute23
540: ,p_attribute24_o
541: => pqh_los_shd.g_old_rec.attribute24
542: ,p_attribute25_o
543: => pqh_los_shd.g_old_rec.attribute25
544: ,p_attribute26_o
545: => pqh_los_shd.g_old_rec.attribute26
539: => pqh_los_shd.g_old_rec.attribute23
540: ,p_attribute24_o
541: => pqh_los_shd.g_old_rec.attribute24
542: ,p_attribute25_o
543: => pqh_los_shd.g_old_rec.attribute25
544: ,p_attribute26_o
545: => pqh_los_shd.g_old_rec.attribute26
546: ,p_attribute27_o
547: => pqh_los_shd.g_old_rec.attribute27
541: => pqh_los_shd.g_old_rec.attribute24
542: ,p_attribute25_o
543: => pqh_los_shd.g_old_rec.attribute25
544: ,p_attribute26_o
545: => pqh_los_shd.g_old_rec.attribute26
546: ,p_attribute27_o
547: => pqh_los_shd.g_old_rec.attribute27
548: ,p_attribute28_o
549: => pqh_los_shd.g_old_rec.attribute28
543: => pqh_los_shd.g_old_rec.attribute25
544: ,p_attribute26_o
545: => pqh_los_shd.g_old_rec.attribute26
546: ,p_attribute27_o
547: => pqh_los_shd.g_old_rec.attribute27
548: ,p_attribute28_o
549: => pqh_los_shd.g_old_rec.attribute28
550: ,p_attribute29_o
551: => pqh_los_shd.g_old_rec.attribute29
545: => pqh_los_shd.g_old_rec.attribute26
546: ,p_attribute27_o
547: => pqh_los_shd.g_old_rec.attribute27
548: ,p_attribute28_o
549: => pqh_los_shd.g_old_rec.attribute28
550: ,p_attribute29_o
551: => pqh_los_shd.g_old_rec.attribute29
552: ,p_attribute30_o
553: => pqh_los_shd.g_old_rec.attribute30
547: => pqh_los_shd.g_old_rec.attribute27
548: ,p_attribute28_o
549: => pqh_los_shd.g_old_rec.attribute28
550: ,p_attribute29_o
551: => pqh_los_shd.g_old_rec.attribute29
552: ,p_attribute30_o
553: => pqh_los_shd.g_old_rec.attribute30
554: ,p_object_version_number_o
555: => pqh_los_shd.g_old_rec.object_version_number
549: => pqh_los_shd.g_old_rec.attribute28
550: ,p_attribute29_o
551: => pqh_los_shd.g_old_rec.attribute29
552: ,p_attribute30_o
553: => pqh_los_shd.g_old_rec.attribute30
554: ,p_object_version_number_o
555: => pqh_los_shd.g_old_rec.object_version_number
556: );
557: --
551: => pqh_los_shd.g_old_rec.attribute29
552: ,p_attribute30_o
553: => pqh_los_shd.g_old_rec.attribute30
554: ,p_object_version_number_o
555: => pqh_los_shd.g_old_rec.object_version_number
556: );
557: --
558: exception
559: --
611: --
612: -- {End Of Comments}
613: -- ----------------------------------------------------------------------------
614: Procedure convert_defs
615: (p_rec in out nocopy pqh_los_shd.g_rec_type
616: ) is
617: --
618: Begin
619: --
623: -- is being used then we must set to the 'current' argument value.
624: --
625: If (p_rec.situation = hr_api.g_varchar2) then
626: p_rec.situation :=
627: pqh_los_shd.g_old_rec.situation;
628: End If;
629: If (p_rec.effective_start_date = hr_api.g_date) then
630: p_rec.effective_start_date :=
631: pqh_los_shd.g_old_rec.effective_start_date;
627: pqh_los_shd.g_old_rec.situation;
628: End If;
629: If (p_rec.effective_start_date = hr_api.g_date) then
630: p_rec.effective_start_date :=
631: pqh_los_shd.g_old_rec.effective_start_date;
632: End If;
633: If (p_rec.effective_end_date = hr_api.g_date) then
634: p_rec.effective_end_date :=
635: pqh_los_shd.g_old_rec.effective_end_date;
631: pqh_los_shd.g_old_rec.effective_start_date;
632: End If;
633: If (p_rec.effective_end_date = hr_api.g_date) then
634: p_rec.effective_end_date :=
635: pqh_los_shd.g_old_rec.effective_end_date;
636: End If;
637: If (p_rec.business_group_id = hr_api.g_number) then
638: p_rec.business_group_id :=
639: pqh_los_shd.g_old_rec.business_group_id;
635: pqh_los_shd.g_old_rec.effective_end_date;
636: End If;
637: If (p_rec.business_group_id = hr_api.g_number) then
638: p_rec.business_group_id :=
639: pqh_los_shd.g_old_rec.business_group_id;
640: End If;
641: If (p_rec.situation_type = hr_api.g_varchar2) then
642: p_rec.situation_type :=
643: pqh_los_shd.g_old_rec.situation_type;
639: pqh_los_shd.g_old_rec.business_group_id;
640: End If;
641: If (p_rec.situation_type = hr_api.g_varchar2) then
642: p_rec.situation_type :=
643: pqh_los_shd.g_old_rec.situation_type;
644: End If;
645: If (p_rec.length_of_service = hr_api.g_varchar2) then
646: p_rec.length_of_service :=
647: pqh_los_shd.g_old_rec.length_of_service;
643: pqh_los_shd.g_old_rec.situation_type;
644: End If;
645: If (p_rec.length_of_service = hr_api.g_varchar2) then
646: p_rec.length_of_service :=
647: pqh_los_shd.g_old_rec.length_of_service;
648: End If;
649: If (p_rec.employee_type = hr_api.g_varchar2) then
650: p_rec.employee_type :=
651: pqh_los_shd.g_old_rec.employee_type;
647: pqh_los_shd.g_old_rec.length_of_service;
648: End If;
649: If (p_rec.employee_type = hr_api.g_varchar2) then
650: p_rec.employee_type :=
651: pqh_los_shd.g_old_rec.employee_type;
652: End If;
653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then
654: p_rec.entitlement_flag :=
655: pqh_los_shd.g_old_rec.entitlement_flag;
651: pqh_los_shd.g_old_rec.employee_type;
652: End If;
653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then
654: p_rec.entitlement_flag :=
655: pqh_los_shd.g_old_rec.entitlement_flag;
656: End If;
657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then
658: p_rec.worktime_proportional :=
659: pqh_los_shd.g_old_rec.worktime_proportional;
655: pqh_los_shd.g_old_rec.entitlement_flag;
656: End If;
657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then
658: p_rec.worktime_proportional :=
659: pqh_los_shd.g_old_rec.worktime_proportional;
660: End If;
661: If (p_rec.entitlement_value = hr_api.g_number) then
662: p_rec.entitlement_value :=
663: pqh_los_shd.g_old_rec.entitlement_value;
659: pqh_los_shd.g_old_rec.worktime_proportional;
660: End If;
661: If (p_rec.entitlement_value = hr_api.g_number) then
662: p_rec.entitlement_value :=
663: pqh_los_shd.g_old_rec.entitlement_value;
664: End If;
665: If (p_rec.information_category = hr_api.g_varchar2) then
666: p_rec.information_category :=
667: pqh_los_shd.g_old_rec.information_category;
663: pqh_los_shd.g_old_rec.entitlement_value;
664: End If;
665: If (p_rec.information_category = hr_api.g_varchar2) then
666: p_rec.information_category :=
667: pqh_los_shd.g_old_rec.information_category;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 :=
671: pqh_los_shd.g_old_rec.information1;
667: pqh_los_shd.g_old_rec.information_category;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 :=
671: pqh_los_shd.g_old_rec.information1;
672: End If;
673: If (p_rec.information2 = hr_api.g_varchar2) then
674: p_rec.information2 :=
675: pqh_los_shd.g_old_rec.information2;
671: pqh_los_shd.g_old_rec.information1;
672: End If;
673: If (p_rec.information2 = hr_api.g_varchar2) then
674: p_rec.information2 :=
675: pqh_los_shd.g_old_rec.information2;
676: End If;
677: If (p_rec.information3 = hr_api.g_varchar2) then
678: p_rec.information3 :=
679: pqh_los_shd.g_old_rec.information3;
675: pqh_los_shd.g_old_rec.information2;
676: End If;
677: If (p_rec.information3 = hr_api.g_varchar2) then
678: p_rec.information3 :=
679: pqh_los_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 :=
683: pqh_los_shd.g_old_rec.information4;
679: pqh_los_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 :=
683: pqh_los_shd.g_old_rec.information4;
684: End If;
685: If (p_rec.information5 = hr_api.g_varchar2) then
686: p_rec.information5 :=
687: pqh_los_shd.g_old_rec.information5;
683: pqh_los_shd.g_old_rec.information4;
684: End If;
685: If (p_rec.information5 = hr_api.g_varchar2) then
686: p_rec.information5 :=
687: pqh_los_shd.g_old_rec.information5;
688: End If;
689: If (p_rec.information6 = hr_api.g_varchar2) then
690: p_rec.information6 :=
691: pqh_los_shd.g_old_rec.information6;
687: pqh_los_shd.g_old_rec.information5;
688: End If;
689: If (p_rec.information6 = hr_api.g_varchar2) then
690: p_rec.information6 :=
691: pqh_los_shd.g_old_rec.information6;
692: End If;
693: If (p_rec.information7 = hr_api.g_varchar2) then
694: p_rec.information7 :=
695: pqh_los_shd.g_old_rec.information7;
691: pqh_los_shd.g_old_rec.information6;
692: End If;
693: If (p_rec.information7 = hr_api.g_varchar2) then
694: p_rec.information7 :=
695: pqh_los_shd.g_old_rec.information7;
696: End If;
697: If (p_rec.information8 = hr_api.g_varchar2) then
698: p_rec.information8 :=
699: pqh_los_shd.g_old_rec.information8;
695: pqh_los_shd.g_old_rec.information7;
696: End If;
697: If (p_rec.information8 = hr_api.g_varchar2) then
698: p_rec.information8 :=
699: pqh_los_shd.g_old_rec.information8;
700: End If;
701: If (p_rec.information9 = hr_api.g_varchar2) then
702: p_rec.information9 :=
703: pqh_los_shd.g_old_rec.information9;
699: pqh_los_shd.g_old_rec.information8;
700: End If;
701: If (p_rec.information9 = hr_api.g_varchar2) then
702: p_rec.information9 :=
703: pqh_los_shd.g_old_rec.information9;
704: End If;
705: If (p_rec.information10 = hr_api.g_varchar2) then
706: p_rec.information10 :=
707: pqh_los_shd.g_old_rec.information10;
703: pqh_los_shd.g_old_rec.information9;
704: End If;
705: If (p_rec.information10 = hr_api.g_varchar2) then
706: p_rec.information10 :=
707: pqh_los_shd.g_old_rec.information10;
708: End If;
709: If (p_rec.information11 = hr_api.g_varchar2) then
710: p_rec.information11 :=
711: pqh_los_shd.g_old_rec.information11;
707: pqh_los_shd.g_old_rec.information10;
708: End If;
709: If (p_rec.information11 = hr_api.g_varchar2) then
710: p_rec.information11 :=
711: pqh_los_shd.g_old_rec.information11;
712: End If;
713: If (p_rec.information12 = hr_api.g_varchar2) then
714: p_rec.information12 :=
715: pqh_los_shd.g_old_rec.information12;
711: pqh_los_shd.g_old_rec.information11;
712: End If;
713: If (p_rec.information12 = hr_api.g_varchar2) then
714: p_rec.information12 :=
715: pqh_los_shd.g_old_rec.information12;
716: End If;
717: If (p_rec.information13 = hr_api.g_varchar2) then
718: p_rec.information13 :=
719: pqh_los_shd.g_old_rec.information13;
715: pqh_los_shd.g_old_rec.information12;
716: End If;
717: If (p_rec.information13 = hr_api.g_varchar2) then
718: p_rec.information13 :=
719: pqh_los_shd.g_old_rec.information13;
720: End If;
721: If (p_rec.information14 = hr_api.g_varchar2) then
722: p_rec.information14 :=
723: pqh_los_shd.g_old_rec.information14;
719: pqh_los_shd.g_old_rec.information13;
720: End If;
721: If (p_rec.information14 = hr_api.g_varchar2) then
722: p_rec.information14 :=
723: pqh_los_shd.g_old_rec.information14;
724: End If;
725: If (p_rec.information15 = hr_api.g_varchar2) then
726: p_rec.information15 :=
727: pqh_los_shd.g_old_rec.information15;
723: pqh_los_shd.g_old_rec.information14;
724: End If;
725: If (p_rec.information15 = hr_api.g_varchar2) then
726: p_rec.information15 :=
727: pqh_los_shd.g_old_rec.information15;
728: End If;
729: If (p_rec.information16 = hr_api.g_varchar2) then
730: p_rec.information16 :=
731: pqh_los_shd.g_old_rec.information16;
727: pqh_los_shd.g_old_rec.information15;
728: End If;
729: If (p_rec.information16 = hr_api.g_varchar2) then
730: p_rec.information16 :=
731: pqh_los_shd.g_old_rec.information16;
732: End If;
733: If (p_rec.information17 = hr_api.g_varchar2) then
734: p_rec.information17 :=
735: pqh_los_shd.g_old_rec.information17;
731: pqh_los_shd.g_old_rec.information16;
732: End If;
733: If (p_rec.information17 = hr_api.g_varchar2) then
734: p_rec.information17 :=
735: pqh_los_shd.g_old_rec.information17;
736: End If;
737: If (p_rec.information18 = hr_api.g_varchar2) then
738: p_rec.information18 :=
739: pqh_los_shd.g_old_rec.information18;
735: pqh_los_shd.g_old_rec.information17;
736: End If;
737: If (p_rec.information18 = hr_api.g_varchar2) then
738: p_rec.information18 :=
739: pqh_los_shd.g_old_rec.information18;
740: End If;
741: If (p_rec.information19 = hr_api.g_varchar2) then
742: p_rec.information19 :=
743: pqh_los_shd.g_old_rec.information19;
739: pqh_los_shd.g_old_rec.information18;
740: End If;
741: If (p_rec.information19 = hr_api.g_varchar2) then
742: p_rec.information19 :=
743: pqh_los_shd.g_old_rec.information19;
744: End If;
745: If (p_rec.information20 = hr_api.g_varchar2) then
746: p_rec.information20 :=
747: pqh_los_shd.g_old_rec.information20;
743: pqh_los_shd.g_old_rec.information19;
744: End If;
745: If (p_rec.information20 = hr_api.g_varchar2) then
746: p_rec.information20 :=
747: pqh_los_shd.g_old_rec.information20;
748: End If;
749: If (p_rec.information21 = hr_api.g_varchar2) then
750: p_rec.information21 :=
751: pqh_los_shd.g_old_rec.information21;
747: pqh_los_shd.g_old_rec.information20;
748: End If;
749: If (p_rec.information21 = hr_api.g_varchar2) then
750: p_rec.information21 :=
751: pqh_los_shd.g_old_rec.information21;
752: End If;
753: If (p_rec.information22 = hr_api.g_varchar2) then
754: p_rec.information22 :=
755: pqh_los_shd.g_old_rec.information22;
751: pqh_los_shd.g_old_rec.information21;
752: End If;
753: If (p_rec.information22 = hr_api.g_varchar2) then
754: p_rec.information22 :=
755: pqh_los_shd.g_old_rec.information22;
756: End If;
757: If (p_rec.information23 = hr_api.g_varchar2) then
758: p_rec.information23 :=
759: pqh_los_shd.g_old_rec.information23;
755: pqh_los_shd.g_old_rec.information22;
756: End If;
757: If (p_rec.information23 = hr_api.g_varchar2) then
758: p_rec.information23 :=
759: pqh_los_shd.g_old_rec.information23;
760: End If;
761: If (p_rec.information24 = hr_api.g_varchar2) then
762: p_rec.information24 :=
763: pqh_los_shd.g_old_rec.information24;
759: pqh_los_shd.g_old_rec.information23;
760: End If;
761: If (p_rec.information24 = hr_api.g_varchar2) then
762: p_rec.information24 :=
763: pqh_los_shd.g_old_rec.information24;
764: End If;
765: If (p_rec.information25 = hr_api.g_varchar2) then
766: p_rec.information25 :=
767: pqh_los_shd.g_old_rec.information25;
763: pqh_los_shd.g_old_rec.information24;
764: End If;
765: If (p_rec.information25 = hr_api.g_varchar2) then
766: p_rec.information25 :=
767: pqh_los_shd.g_old_rec.information25;
768: End If;
769: If (p_rec.information26 = hr_api.g_varchar2) then
770: p_rec.information26 :=
771: pqh_los_shd.g_old_rec.information26;
767: pqh_los_shd.g_old_rec.information25;
768: End If;
769: If (p_rec.information26 = hr_api.g_varchar2) then
770: p_rec.information26 :=
771: pqh_los_shd.g_old_rec.information26;
772: End If;
773: If (p_rec.information27 = hr_api.g_varchar2) then
774: p_rec.information27 :=
775: pqh_los_shd.g_old_rec.information27;
771: pqh_los_shd.g_old_rec.information26;
772: End If;
773: If (p_rec.information27 = hr_api.g_varchar2) then
774: p_rec.information27 :=
775: pqh_los_shd.g_old_rec.information27;
776: End If;
777: If (p_rec.information28 = hr_api.g_varchar2) then
778: p_rec.information28 :=
779: pqh_los_shd.g_old_rec.information28;
775: pqh_los_shd.g_old_rec.information27;
776: End If;
777: If (p_rec.information28 = hr_api.g_varchar2) then
778: p_rec.information28 :=
779: pqh_los_shd.g_old_rec.information28;
780: End If;
781: If (p_rec.information29 = hr_api.g_varchar2) then
782: p_rec.information29 :=
783: pqh_los_shd.g_old_rec.information29;
779: pqh_los_shd.g_old_rec.information28;
780: End If;
781: If (p_rec.information29 = hr_api.g_varchar2) then
782: p_rec.information29 :=
783: pqh_los_shd.g_old_rec.information29;
784: End If;
785: If (p_rec.information30 = hr_api.g_varchar2) then
786: p_rec.information30 :=
787: pqh_los_shd.g_old_rec.information30;
783: pqh_los_shd.g_old_rec.information29;
784: End If;
785: If (p_rec.information30 = hr_api.g_varchar2) then
786: p_rec.information30 :=
787: pqh_los_shd.g_old_rec.information30;
788: End If;
789: If (p_rec.attribute_category = hr_api.g_varchar2) then
790: p_rec.attribute_category :=
791: pqh_los_shd.g_old_rec.attribute_category;
787: pqh_los_shd.g_old_rec.information30;
788: End If;
789: If (p_rec.attribute_category = hr_api.g_varchar2) then
790: p_rec.attribute_category :=
791: pqh_los_shd.g_old_rec.attribute_category;
792: End If;
793: If (p_rec.attribute1 = hr_api.g_varchar2) then
794: p_rec.attribute1 :=
795: pqh_los_shd.g_old_rec.attribute1;
791: pqh_los_shd.g_old_rec.attribute_category;
792: End If;
793: If (p_rec.attribute1 = hr_api.g_varchar2) then
794: p_rec.attribute1 :=
795: pqh_los_shd.g_old_rec.attribute1;
796: End If;
797: If (p_rec.attribute2 = hr_api.g_varchar2) then
798: p_rec.attribute2 :=
799: pqh_los_shd.g_old_rec.attribute2;
795: pqh_los_shd.g_old_rec.attribute1;
796: End If;
797: If (p_rec.attribute2 = hr_api.g_varchar2) then
798: p_rec.attribute2 :=
799: pqh_los_shd.g_old_rec.attribute2;
800: End If;
801: If (p_rec.attribute3 = hr_api.g_varchar2) then
802: p_rec.attribute3 :=
803: pqh_los_shd.g_old_rec.attribute3;
799: pqh_los_shd.g_old_rec.attribute2;
800: End If;
801: If (p_rec.attribute3 = hr_api.g_varchar2) then
802: p_rec.attribute3 :=
803: pqh_los_shd.g_old_rec.attribute3;
804: End If;
805: If (p_rec.attribute4 = hr_api.g_varchar2) then
806: p_rec.attribute4 :=
807: pqh_los_shd.g_old_rec.attribute4;
803: pqh_los_shd.g_old_rec.attribute3;
804: End If;
805: If (p_rec.attribute4 = hr_api.g_varchar2) then
806: p_rec.attribute4 :=
807: pqh_los_shd.g_old_rec.attribute4;
808: End If;
809: If (p_rec.attribute5 = hr_api.g_varchar2) then
810: p_rec.attribute5 :=
811: pqh_los_shd.g_old_rec.attribute5;
807: pqh_los_shd.g_old_rec.attribute4;
808: End If;
809: If (p_rec.attribute5 = hr_api.g_varchar2) then
810: p_rec.attribute5 :=
811: pqh_los_shd.g_old_rec.attribute5;
812: End If;
813: If (p_rec.attribute6 = hr_api.g_varchar2) then
814: p_rec.attribute6 :=
815: pqh_los_shd.g_old_rec.attribute6;
811: pqh_los_shd.g_old_rec.attribute5;
812: End If;
813: If (p_rec.attribute6 = hr_api.g_varchar2) then
814: p_rec.attribute6 :=
815: pqh_los_shd.g_old_rec.attribute6;
816: End If;
817: If (p_rec.attribute7 = hr_api.g_varchar2) then
818: p_rec.attribute7 :=
819: pqh_los_shd.g_old_rec.attribute7;
815: pqh_los_shd.g_old_rec.attribute6;
816: End If;
817: If (p_rec.attribute7 = hr_api.g_varchar2) then
818: p_rec.attribute7 :=
819: pqh_los_shd.g_old_rec.attribute7;
820: End If;
821: If (p_rec.attribute8 = hr_api.g_varchar2) then
822: p_rec.attribute8 :=
823: pqh_los_shd.g_old_rec.attribute8;
819: pqh_los_shd.g_old_rec.attribute7;
820: End If;
821: If (p_rec.attribute8 = hr_api.g_varchar2) then
822: p_rec.attribute8 :=
823: pqh_los_shd.g_old_rec.attribute8;
824: End If;
825: If (p_rec.attribute9 = hr_api.g_varchar2) then
826: p_rec.attribute9 :=
827: pqh_los_shd.g_old_rec.attribute9;
823: pqh_los_shd.g_old_rec.attribute8;
824: End If;
825: If (p_rec.attribute9 = hr_api.g_varchar2) then
826: p_rec.attribute9 :=
827: pqh_los_shd.g_old_rec.attribute9;
828: End If;
829: If (p_rec.attribute10 = hr_api.g_varchar2) then
830: p_rec.attribute10 :=
831: pqh_los_shd.g_old_rec.attribute10;
827: pqh_los_shd.g_old_rec.attribute9;
828: End If;
829: If (p_rec.attribute10 = hr_api.g_varchar2) then
830: p_rec.attribute10 :=
831: pqh_los_shd.g_old_rec.attribute10;
832: End If;
833: If (p_rec.attribute11 = hr_api.g_varchar2) then
834: p_rec.attribute11 :=
835: pqh_los_shd.g_old_rec.attribute11;
831: pqh_los_shd.g_old_rec.attribute10;
832: End If;
833: If (p_rec.attribute11 = hr_api.g_varchar2) then
834: p_rec.attribute11 :=
835: pqh_los_shd.g_old_rec.attribute11;
836: End If;
837: If (p_rec.attribute12 = hr_api.g_varchar2) then
838: p_rec.attribute12 :=
839: pqh_los_shd.g_old_rec.attribute12;
835: pqh_los_shd.g_old_rec.attribute11;
836: End If;
837: If (p_rec.attribute12 = hr_api.g_varchar2) then
838: p_rec.attribute12 :=
839: pqh_los_shd.g_old_rec.attribute12;
840: End If;
841: If (p_rec.attribute13 = hr_api.g_varchar2) then
842: p_rec.attribute13 :=
843: pqh_los_shd.g_old_rec.attribute13;
839: pqh_los_shd.g_old_rec.attribute12;
840: End If;
841: If (p_rec.attribute13 = hr_api.g_varchar2) then
842: p_rec.attribute13 :=
843: pqh_los_shd.g_old_rec.attribute13;
844: End If;
845: If (p_rec.attribute14 = hr_api.g_varchar2) then
846: p_rec.attribute14 :=
847: pqh_los_shd.g_old_rec.attribute14;
843: pqh_los_shd.g_old_rec.attribute13;
844: End If;
845: If (p_rec.attribute14 = hr_api.g_varchar2) then
846: p_rec.attribute14 :=
847: pqh_los_shd.g_old_rec.attribute14;
848: End If;
849: If (p_rec.attribute15 = hr_api.g_varchar2) then
850: p_rec.attribute15 :=
851: pqh_los_shd.g_old_rec.attribute15;
847: pqh_los_shd.g_old_rec.attribute14;
848: End If;
849: If (p_rec.attribute15 = hr_api.g_varchar2) then
850: p_rec.attribute15 :=
851: pqh_los_shd.g_old_rec.attribute15;
852: End If;
853: If (p_rec.attribute16 = hr_api.g_varchar2) then
854: p_rec.attribute16 :=
855: pqh_los_shd.g_old_rec.attribute16;
851: pqh_los_shd.g_old_rec.attribute15;
852: End If;
853: If (p_rec.attribute16 = hr_api.g_varchar2) then
854: p_rec.attribute16 :=
855: pqh_los_shd.g_old_rec.attribute16;
856: End If;
857: If (p_rec.attribute17 = hr_api.g_varchar2) then
858: p_rec.attribute17 :=
859: pqh_los_shd.g_old_rec.attribute17;
855: pqh_los_shd.g_old_rec.attribute16;
856: End If;
857: If (p_rec.attribute17 = hr_api.g_varchar2) then
858: p_rec.attribute17 :=
859: pqh_los_shd.g_old_rec.attribute17;
860: End If;
861: If (p_rec.attribute18 = hr_api.g_varchar2) then
862: p_rec.attribute18 :=
863: pqh_los_shd.g_old_rec.attribute18;
859: pqh_los_shd.g_old_rec.attribute17;
860: End If;
861: If (p_rec.attribute18 = hr_api.g_varchar2) then
862: p_rec.attribute18 :=
863: pqh_los_shd.g_old_rec.attribute18;
864: End If;
865: If (p_rec.attribute19 = hr_api.g_varchar2) then
866: p_rec.attribute19 :=
867: pqh_los_shd.g_old_rec.attribute19;
863: pqh_los_shd.g_old_rec.attribute18;
864: End If;
865: If (p_rec.attribute19 = hr_api.g_varchar2) then
866: p_rec.attribute19 :=
867: pqh_los_shd.g_old_rec.attribute19;
868: End If;
869: If (p_rec.attribute20 = hr_api.g_varchar2) then
870: p_rec.attribute20 :=
871: pqh_los_shd.g_old_rec.attribute20;
867: pqh_los_shd.g_old_rec.attribute19;
868: End If;
869: If (p_rec.attribute20 = hr_api.g_varchar2) then
870: p_rec.attribute20 :=
871: pqh_los_shd.g_old_rec.attribute20;
872: End If;
873: If (p_rec.attribute21 = hr_api.g_varchar2) then
874: p_rec.attribute21 :=
875: pqh_los_shd.g_old_rec.attribute21;
871: pqh_los_shd.g_old_rec.attribute20;
872: End If;
873: If (p_rec.attribute21 = hr_api.g_varchar2) then
874: p_rec.attribute21 :=
875: pqh_los_shd.g_old_rec.attribute21;
876: End If;
877: If (p_rec.attribute22 = hr_api.g_varchar2) then
878: p_rec.attribute22 :=
879: pqh_los_shd.g_old_rec.attribute22;
875: pqh_los_shd.g_old_rec.attribute21;
876: End If;
877: If (p_rec.attribute22 = hr_api.g_varchar2) then
878: p_rec.attribute22 :=
879: pqh_los_shd.g_old_rec.attribute22;
880: End If;
881: If (p_rec.attribute23 = hr_api.g_varchar2) then
882: p_rec.attribute23 :=
883: pqh_los_shd.g_old_rec.attribute23;
879: pqh_los_shd.g_old_rec.attribute22;
880: End If;
881: If (p_rec.attribute23 = hr_api.g_varchar2) then
882: p_rec.attribute23 :=
883: pqh_los_shd.g_old_rec.attribute23;
884: End If;
885: If (p_rec.attribute24 = hr_api.g_varchar2) then
886: p_rec.attribute24 :=
887: pqh_los_shd.g_old_rec.attribute24;
883: pqh_los_shd.g_old_rec.attribute23;
884: End If;
885: If (p_rec.attribute24 = hr_api.g_varchar2) then
886: p_rec.attribute24 :=
887: pqh_los_shd.g_old_rec.attribute24;
888: End If;
889: If (p_rec.attribute25 = hr_api.g_varchar2) then
890: p_rec.attribute25 :=
891: pqh_los_shd.g_old_rec.attribute25;
887: pqh_los_shd.g_old_rec.attribute24;
888: End If;
889: If (p_rec.attribute25 = hr_api.g_varchar2) then
890: p_rec.attribute25 :=
891: pqh_los_shd.g_old_rec.attribute25;
892: End If;
893: If (p_rec.attribute26 = hr_api.g_varchar2) then
894: p_rec.attribute26 :=
895: pqh_los_shd.g_old_rec.attribute26;
891: pqh_los_shd.g_old_rec.attribute25;
892: End If;
893: If (p_rec.attribute26 = hr_api.g_varchar2) then
894: p_rec.attribute26 :=
895: pqh_los_shd.g_old_rec.attribute26;
896: End If;
897: If (p_rec.attribute27 = hr_api.g_varchar2) then
898: p_rec.attribute27 :=
899: pqh_los_shd.g_old_rec.attribute27;
895: pqh_los_shd.g_old_rec.attribute26;
896: End If;
897: If (p_rec.attribute27 = hr_api.g_varchar2) then
898: p_rec.attribute27 :=
899: pqh_los_shd.g_old_rec.attribute27;
900: End If;
901: If (p_rec.attribute28 = hr_api.g_varchar2) then
902: p_rec.attribute28 :=
903: pqh_los_shd.g_old_rec.attribute28;
899: pqh_los_shd.g_old_rec.attribute27;
900: End If;
901: If (p_rec.attribute28 = hr_api.g_varchar2) then
902: p_rec.attribute28 :=
903: pqh_los_shd.g_old_rec.attribute28;
904: End If;
905: If (p_rec.attribute29 = hr_api.g_varchar2) then
906: p_rec.attribute29 :=
907: pqh_los_shd.g_old_rec.attribute29;
903: pqh_los_shd.g_old_rec.attribute28;
904: End If;
905: If (p_rec.attribute29 = hr_api.g_varchar2) then
906: p_rec.attribute29 :=
907: pqh_los_shd.g_old_rec.attribute29;
908: End If;
909: If (p_rec.attribute30 = hr_api.g_varchar2) then
910: p_rec.attribute30 :=
911: pqh_los_shd.g_old_rec.attribute30;
907: pqh_los_shd.g_old_rec.attribute29;
908: End If;
909: If (p_rec.attribute30 = hr_api.g_varchar2) then
910: p_rec.attribute30 :=
911: pqh_los_shd.g_old_rec.attribute30;
912: End If;
913: --
914: End convert_defs;
915: --
917: -- |---------------------------------< upd >----------------------------------|
918: -- ----------------------------------------------------------------------------
919: Procedure upd
920: (p_effective_date in date
921: ,p_rec in out nocopy pqh_los_shd.g_rec_type
922: ) is
923: --
924: l_proc varchar2(72) := g_package||'upd';
925: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: -- We must lock the row which we need to update.
930: --
931: pqh_los_shd.lck
932: (p_rec.situation_id
933: ,p_rec.object_version_number
934: );
935: --
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1049: ) is
1050: --
1051: l_rec pqh_los_shd.g_rec_type;
1052: l_proc varchar2(72) := g_package||'upd';
1053: --
1054: Begin
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1057: -- Call conversion function to turn arguments into the
1058: -- l_rec structure.
1059: --
1060: l_rec :=
1061: pqh_los_shd.convert_args
1062: (p_situation_id
1063: ,p_situation
1064: ,p_effective_start_date
1065: ,p_effective_end_date