51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pgv_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: --
157: per_pgv_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: --
162: per_pgv_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: --
167: per_pgv_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;
203: --
204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure pre_update
207: (p_rec in per_pgv_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'pre_update';
211: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure post_update
251: (p_effective_date in date
252: ,p_rec in per_pgv_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'post_update';
256: --
406: => p_rec.information29
407: ,p_information30
408: => p_rec.information30
409: ,p_business_group_id_o
410: => per_pgv_shd.g_old_rec.business_group_id
411: ,p_version_number_o
412: => per_pgv_shd.g_old_rec.version_number
413: ,p_hierarchy_id_o
414: => per_pgv_shd.g_old_rec.hierarchy_id
408: => p_rec.information30
409: ,p_business_group_id_o
410: => per_pgv_shd.g_old_rec.business_group_id
411: ,p_version_number_o
412: => per_pgv_shd.g_old_rec.version_number
413: ,p_hierarchy_id_o
414: => per_pgv_shd.g_old_rec.hierarchy_id
415: ,p_date_from_o
416: => per_pgv_shd.g_old_rec.date_from
410: => per_pgv_shd.g_old_rec.business_group_id
411: ,p_version_number_o
412: => per_pgv_shd.g_old_rec.version_number
413: ,p_hierarchy_id_o
414: => per_pgv_shd.g_old_rec.hierarchy_id
415: ,p_date_from_o
416: => per_pgv_shd.g_old_rec.date_from
417: ,p_date_to_o
418: => per_pgv_shd.g_old_rec.date_to
412: => per_pgv_shd.g_old_rec.version_number
413: ,p_hierarchy_id_o
414: => per_pgv_shd.g_old_rec.hierarchy_id
415: ,p_date_from_o
416: => per_pgv_shd.g_old_rec.date_from
417: ,p_date_to_o
418: => per_pgv_shd.g_old_rec.date_to
419: ,p_status_o
420: => per_pgv_shd.g_old_rec.status
414: => per_pgv_shd.g_old_rec.hierarchy_id
415: ,p_date_from_o
416: => per_pgv_shd.g_old_rec.date_from
417: ,p_date_to_o
418: => per_pgv_shd.g_old_rec.date_to
419: ,p_status_o
420: => per_pgv_shd.g_old_rec.status
421: ,p_validate_flag_o
422: => per_pgv_shd.g_old_rec.validate_flag
416: => per_pgv_shd.g_old_rec.date_from
417: ,p_date_to_o
418: => per_pgv_shd.g_old_rec.date_to
419: ,p_status_o
420: => per_pgv_shd.g_old_rec.status
421: ,p_validate_flag_o
422: => per_pgv_shd.g_old_rec.validate_flag
423: ,p_request_id_o
424: => per_pgv_shd.g_old_rec.request_id
418: => per_pgv_shd.g_old_rec.date_to
419: ,p_status_o
420: => per_pgv_shd.g_old_rec.status
421: ,p_validate_flag_o
422: => per_pgv_shd.g_old_rec.validate_flag
423: ,p_request_id_o
424: => per_pgv_shd.g_old_rec.request_id
425: ,p_program_application_id_o
426: => per_pgv_shd.g_old_rec.program_application_id
420: => per_pgv_shd.g_old_rec.status
421: ,p_validate_flag_o
422: => per_pgv_shd.g_old_rec.validate_flag
423: ,p_request_id_o
424: => per_pgv_shd.g_old_rec.request_id
425: ,p_program_application_id_o
426: => per_pgv_shd.g_old_rec.program_application_id
427: ,p_program_id_o
428: => per_pgv_shd.g_old_rec.program_id
422: => per_pgv_shd.g_old_rec.validate_flag
423: ,p_request_id_o
424: => per_pgv_shd.g_old_rec.request_id
425: ,p_program_application_id_o
426: => per_pgv_shd.g_old_rec.program_application_id
427: ,p_program_id_o
428: => per_pgv_shd.g_old_rec.program_id
429: ,p_program_update_date_o
430: => per_pgv_shd.g_old_rec.program_update_date
424: => per_pgv_shd.g_old_rec.request_id
425: ,p_program_application_id_o
426: => per_pgv_shd.g_old_rec.program_application_id
427: ,p_program_id_o
428: => per_pgv_shd.g_old_rec.program_id
429: ,p_program_update_date_o
430: => per_pgv_shd.g_old_rec.program_update_date
431: ,p_object_version_number_o
432: => per_pgv_shd.g_old_rec.object_version_number
426: => per_pgv_shd.g_old_rec.program_application_id
427: ,p_program_id_o
428: => per_pgv_shd.g_old_rec.program_id
429: ,p_program_update_date_o
430: => per_pgv_shd.g_old_rec.program_update_date
431: ,p_object_version_number_o
432: => per_pgv_shd.g_old_rec.object_version_number
433: ,p_attribute_category_o
434: => per_pgv_shd.g_old_rec.attribute_category
428: => per_pgv_shd.g_old_rec.program_id
429: ,p_program_update_date_o
430: => per_pgv_shd.g_old_rec.program_update_date
431: ,p_object_version_number_o
432: => per_pgv_shd.g_old_rec.object_version_number
433: ,p_attribute_category_o
434: => per_pgv_shd.g_old_rec.attribute_category
435: ,p_attribute1_o
436: => per_pgv_shd.g_old_rec.attribute1
430: => per_pgv_shd.g_old_rec.program_update_date
431: ,p_object_version_number_o
432: => per_pgv_shd.g_old_rec.object_version_number
433: ,p_attribute_category_o
434: => per_pgv_shd.g_old_rec.attribute_category
435: ,p_attribute1_o
436: => per_pgv_shd.g_old_rec.attribute1
437: ,p_attribute2_o
438: => per_pgv_shd.g_old_rec.attribute2
432: => per_pgv_shd.g_old_rec.object_version_number
433: ,p_attribute_category_o
434: => per_pgv_shd.g_old_rec.attribute_category
435: ,p_attribute1_o
436: => per_pgv_shd.g_old_rec.attribute1
437: ,p_attribute2_o
438: => per_pgv_shd.g_old_rec.attribute2
439: ,p_attribute3_o
440: => per_pgv_shd.g_old_rec.attribute3
434: => per_pgv_shd.g_old_rec.attribute_category
435: ,p_attribute1_o
436: => per_pgv_shd.g_old_rec.attribute1
437: ,p_attribute2_o
438: => per_pgv_shd.g_old_rec.attribute2
439: ,p_attribute3_o
440: => per_pgv_shd.g_old_rec.attribute3
441: ,p_attribute4_o
442: => per_pgv_shd.g_old_rec.attribute4
436: => per_pgv_shd.g_old_rec.attribute1
437: ,p_attribute2_o
438: => per_pgv_shd.g_old_rec.attribute2
439: ,p_attribute3_o
440: => per_pgv_shd.g_old_rec.attribute3
441: ,p_attribute4_o
442: => per_pgv_shd.g_old_rec.attribute4
443: ,p_attribute5_o
444: => per_pgv_shd.g_old_rec.attribute5
438: => per_pgv_shd.g_old_rec.attribute2
439: ,p_attribute3_o
440: => per_pgv_shd.g_old_rec.attribute3
441: ,p_attribute4_o
442: => per_pgv_shd.g_old_rec.attribute4
443: ,p_attribute5_o
444: => per_pgv_shd.g_old_rec.attribute5
445: ,p_attribute6_o
446: => per_pgv_shd.g_old_rec.attribute6
440: => per_pgv_shd.g_old_rec.attribute3
441: ,p_attribute4_o
442: => per_pgv_shd.g_old_rec.attribute4
443: ,p_attribute5_o
444: => per_pgv_shd.g_old_rec.attribute5
445: ,p_attribute6_o
446: => per_pgv_shd.g_old_rec.attribute6
447: ,p_attribute7_o
448: => per_pgv_shd.g_old_rec.attribute7
442: => per_pgv_shd.g_old_rec.attribute4
443: ,p_attribute5_o
444: => per_pgv_shd.g_old_rec.attribute5
445: ,p_attribute6_o
446: => per_pgv_shd.g_old_rec.attribute6
447: ,p_attribute7_o
448: => per_pgv_shd.g_old_rec.attribute7
449: ,p_attribute8_o
450: => per_pgv_shd.g_old_rec.attribute8
444: => per_pgv_shd.g_old_rec.attribute5
445: ,p_attribute6_o
446: => per_pgv_shd.g_old_rec.attribute6
447: ,p_attribute7_o
448: => per_pgv_shd.g_old_rec.attribute7
449: ,p_attribute8_o
450: => per_pgv_shd.g_old_rec.attribute8
451: ,p_attribute9_o
452: => per_pgv_shd.g_old_rec.attribute9
446: => per_pgv_shd.g_old_rec.attribute6
447: ,p_attribute7_o
448: => per_pgv_shd.g_old_rec.attribute7
449: ,p_attribute8_o
450: => per_pgv_shd.g_old_rec.attribute8
451: ,p_attribute9_o
452: => per_pgv_shd.g_old_rec.attribute9
453: ,p_attribute10_o
454: => per_pgv_shd.g_old_rec.attribute10
448: => per_pgv_shd.g_old_rec.attribute7
449: ,p_attribute8_o
450: => per_pgv_shd.g_old_rec.attribute8
451: ,p_attribute9_o
452: => per_pgv_shd.g_old_rec.attribute9
453: ,p_attribute10_o
454: => per_pgv_shd.g_old_rec.attribute10
455: ,p_attribute11_o
456: => per_pgv_shd.g_old_rec.attribute11
450: => per_pgv_shd.g_old_rec.attribute8
451: ,p_attribute9_o
452: => per_pgv_shd.g_old_rec.attribute9
453: ,p_attribute10_o
454: => per_pgv_shd.g_old_rec.attribute10
455: ,p_attribute11_o
456: => per_pgv_shd.g_old_rec.attribute11
457: ,p_attribute12_o
458: => per_pgv_shd.g_old_rec.attribute12
452: => per_pgv_shd.g_old_rec.attribute9
453: ,p_attribute10_o
454: => per_pgv_shd.g_old_rec.attribute10
455: ,p_attribute11_o
456: => per_pgv_shd.g_old_rec.attribute11
457: ,p_attribute12_o
458: => per_pgv_shd.g_old_rec.attribute12
459: ,p_attribute13_o
460: => per_pgv_shd.g_old_rec.attribute13
454: => per_pgv_shd.g_old_rec.attribute10
455: ,p_attribute11_o
456: => per_pgv_shd.g_old_rec.attribute11
457: ,p_attribute12_o
458: => per_pgv_shd.g_old_rec.attribute12
459: ,p_attribute13_o
460: => per_pgv_shd.g_old_rec.attribute13
461: ,p_attribute14_o
462: => per_pgv_shd.g_old_rec.attribute14
456: => per_pgv_shd.g_old_rec.attribute11
457: ,p_attribute12_o
458: => per_pgv_shd.g_old_rec.attribute12
459: ,p_attribute13_o
460: => per_pgv_shd.g_old_rec.attribute13
461: ,p_attribute14_o
462: => per_pgv_shd.g_old_rec.attribute14
463: ,p_attribute15_o
464: => per_pgv_shd.g_old_rec.attribute15
458: => per_pgv_shd.g_old_rec.attribute12
459: ,p_attribute13_o
460: => per_pgv_shd.g_old_rec.attribute13
461: ,p_attribute14_o
462: => per_pgv_shd.g_old_rec.attribute14
463: ,p_attribute15_o
464: => per_pgv_shd.g_old_rec.attribute15
465: ,p_attribute16_o
466: => per_pgv_shd.g_old_rec.attribute16
460: => per_pgv_shd.g_old_rec.attribute13
461: ,p_attribute14_o
462: => per_pgv_shd.g_old_rec.attribute14
463: ,p_attribute15_o
464: => per_pgv_shd.g_old_rec.attribute15
465: ,p_attribute16_o
466: => per_pgv_shd.g_old_rec.attribute16
467: ,p_attribute17_o
468: => per_pgv_shd.g_old_rec.attribute17
462: => per_pgv_shd.g_old_rec.attribute14
463: ,p_attribute15_o
464: => per_pgv_shd.g_old_rec.attribute15
465: ,p_attribute16_o
466: => per_pgv_shd.g_old_rec.attribute16
467: ,p_attribute17_o
468: => per_pgv_shd.g_old_rec.attribute17
469: ,p_attribute18_o
470: => per_pgv_shd.g_old_rec.attribute18
464: => per_pgv_shd.g_old_rec.attribute15
465: ,p_attribute16_o
466: => per_pgv_shd.g_old_rec.attribute16
467: ,p_attribute17_o
468: => per_pgv_shd.g_old_rec.attribute17
469: ,p_attribute18_o
470: => per_pgv_shd.g_old_rec.attribute18
471: ,p_attribute19_o
472: => per_pgv_shd.g_old_rec.attribute19
466: => per_pgv_shd.g_old_rec.attribute16
467: ,p_attribute17_o
468: => per_pgv_shd.g_old_rec.attribute17
469: ,p_attribute18_o
470: => per_pgv_shd.g_old_rec.attribute18
471: ,p_attribute19_o
472: => per_pgv_shd.g_old_rec.attribute19
473: ,p_attribute20_o
474: => per_pgv_shd.g_old_rec.attribute20
468: => per_pgv_shd.g_old_rec.attribute17
469: ,p_attribute18_o
470: => per_pgv_shd.g_old_rec.attribute18
471: ,p_attribute19_o
472: => per_pgv_shd.g_old_rec.attribute19
473: ,p_attribute20_o
474: => per_pgv_shd.g_old_rec.attribute20
475: ,p_attribute21_o
476: => per_pgv_shd.g_old_rec.attribute21
470: => per_pgv_shd.g_old_rec.attribute18
471: ,p_attribute19_o
472: => per_pgv_shd.g_old_rec.attribute19
473: ,p_attribute20_o
474: => per_pgv_shd.g_old_rec.attribute20
475: ,p_attribute21_o
476: => per_pgv_shd.g_old_rec.attribute21
477: ,p_attribute22_o
478: => per_pgv_shd.g_old_rec.attribute22
472: => per_pgv_shd.g_old_rec.attribute19
473: ,p_attribute20_o
474: => per_pgv_shd.g_old_rec.attribute20
475: ,p_attribute21_o
476: => per_pgv_shd.g_old_rec.attribute21
477: ,p_attribute22_o
478: => per_pgv_shd.g_old_rec.attribute22
479: ,p_attribute23_o
480: => per_pgv_shd.g_old_rec.attribute23
474: => per_pgv_shd.g_old_rec.attribute20
475: ,p_attribute21_o
476: => per_pgv_shd.g_old_rec.attribute21
477: ,p_attribute22_o
478: => per_pgv_shd.g_old_rec.attribute22
479: ,p_attribute23_o
480: => per_pgv_shd.g_old_rec.attribute23
481: ,p_attribute24_o
482: => per_pgv_shd.g_old_rec.attribute24
476: => per_pgv_shd.g_old_rec.attribute21
477: ,p_attribute22_o
478: => per_pgv_shd.g_old_rec.attribute22
479: ,p_attribute23_o
480: => per_pgv_shd.g_old_rec.attribute23
481: ,p_attribute24_o
482: => per_pgv_shd.g_old_rec.attribute24
483: ,p_attribute25_o
484: => per_pgv_shd.g_old_rec.attribute25
478: => per_pgv_shd.g_old_rec.attribute22
479: ,p_attribute23_o
480: => per_pgv_shd.g_old_rec.attribute23
481: ,p_attribute24_o
482: => per_pgv_shd.g_old_rec.attribute24
483: ,p_attribute25_o
484: => per_pgv_shd.g_old_rec.attribute25
485: ,p_attribute26_o
486: => per_pgv_shd.g_old_rec.attribute26
480: => per_pgv_shd.g_old_rec.attribute23
481: ,p_attribute24_o
482: => per_pgv_shd.g_old_rec.attribute24
483: ,p_attribute25_o
484: => per_pgv_shd.g_old_rec.attribute25
485: ,p_attribute26_o
486: => per_pgv_shd.g_old_rec.attribute26
487: ,p_attribute27_o
488: => per_pgv_shd.g_old_rec.attribute27
482: => per_pgv_shd.g_old_rec.attribute24
483: ,p_attribute25_o
484: => per_pgv_shd.g_old_rec.attribute25
485: ,p_attribute26_o
486: => per_pgv_shd.g_old_rec.attribute26
487: ,p_attribute27_o
488: => per_pgv_shd.g_old_rec.attribute27
489: ,p_attribute28_o
490: => per_pgv_shd.g_old_rec.attribute28
484: => per_pgv_shd.g_old_rec.attribute25
485: ,p_attribute26_o
486: => per_pgv_shd.g_old_rec.attribute26
487: ,p_attribute27_o
488: => per_pgv_shd.g_old_rec.attribute27
489: ,p_attribute28_o
490: => per_pgv_shd.g_old_rec.attribute28
491: ,p_attribute29_o
492: => per_pgv_shd.g_old_rec.attribute29
486: => per_pgv_shd.g_old_rec.attribute26
487: ,p_attribute27_o
488: => per_pgv_shd.g_old_rec.attribute27
489: ,p_attribute28_o
490: => per_pgv_shd.g_old_rec.attribute28
491: ,p_attribute29_o
492: => per_pgv_shd.g_old_rec.attribute29
493: ,p_attribute30_o
494: => per_pgv_shd.g_old_rec.attribute30
488: => per_pgv_shd.g_old_rec.attribute27
489: ,p_attribute28_o
490: => per_pgv_shd.g_old_rec.attribute28
491: ,p_attribute29_o
492: => per_pgv_shd.g_old_rec.attribute29
493: ,p_attribute30_o
494: => per_pgv_shd.g_old_rec.attribute30
495: ,p_information_category_o
496: => per_pgv_shd.g_old_rec.information_category
490: => per_pgv_shd.g_old_rec.attribute28
491: ,p_attribute29_o
492: => per_pgv_shd.g_old_rec.attribute29
493: ,p_attribute30_o
494: => per_pgv_shd.g_old_rec.attribute30
495: ,p_information_category_o
496: => per_pgv_shd.g_old_rec.information_category
497: ,p_information1_o
498: => per_pgv_shd.g_old_rec.information1
492: => per_pgv_shd.g_old_rec.attribute29
493: ,p_attribute30_o
494: => per_pgv_shd.g_old_rec.attribute30
495: ,p_information_category_o
496: => per_pgv_shd.g_old_rec.information_category
497: ,p_information1_o
498: => per_pgv_shd.g_old_rec.information1
499: ,p_information2_o
500: => per_pgv_shd.g_old_rec.information2
494: => per_pgv_shd.g_old_rec.attribute30
495: ,p_information_category_o
496: => per_pgv_shd.g_old_rec.information_category
497: ,p_information1_o
498: => per_pgv_shd.g_old_rec.information1
499: ,p_information2_o
500: => per_pgv_shd.g_old_rec.information2
501: ,p_information3_o
502: => per_pgv_shd.g_old_rec.information3
496: => per_pgv_shd.g_old_rec.information_category
497: ,p_information1_o
498: => per_pgv_shd.g_old_rec.information1
499: ,p_information2_o
500: => per_pgv_shd.g_old_rec.information2
501: ,p_information3_o
502: => per_pgv_shd.g_old_rec.information3
503: ,p_information4_o
504: => per_pgv_shd.g_old_rec.information4
498: => per_pgv_shd.g_old_rec.information1
499: ,p_information2_o
500: => per_pgv_shd.g_old_rec.information2
501: ,p_information3_o
502: => per_pgv_shd.g_old_rec.information3
503: ,p_information4_o
504: => per_pgv_shd.g_old_rec.information4
505: ,p_information5_o
506: => per_pgv_shd.g_old_rec.information5
500: => per_pgv_shd.g_old_rec.information2
501: ,p_information3_o
502: => per_pgv_shd.g_old_rec.information3
503: ,p_information4_o
504: => per_pgv_shd.g_old_rec.information4
505: ,p_information5_o
506: => per_pgv_shd.g_old_rec.information5
507: ,p_information6_o
508: => per_pgv_shd.g_old_rec.information6
502: => per_pgv_shd.g_old_rec.information3
503: ,p_information4_o
504: => per_pgv_shd.g_old_rec.information4
505: ,p_information5_o
506: => per_pgv_shd.g_old_rec.information5
507: ,p_information6_o
508: => per_pgv_shd.g_old_rec.information6
509: ,p_information7_o
510: => per_pgv_shd.g_old_rec.information7
504: => per_pgv_shd.g_old_rec.information4
505: ,p_information5_o
506: => per_pgv_shd.g_old_rec.information5
507: ,p_information6_o
508: => per_pgv_shd.g_old_rec.information6
509: ,p_information7_o
510: => per_pgv_shd.g_old_rec.information7
511: ,p_information8_o
512: => per_pgv_shd.g_old_rec.information8
506: => per_pgv_shd.g_old_rec.information5
507: ,p_information6_o
508: => per_pgv_shd.g_old_rec.information6
509: ,p_information7_o
510: => per_pgv_shd.g_old_rec.information7
511: ,p_information8_o
512: => per_pgv_shd.g_old_rec.information8
513: ,p_information9_o
514: => per_pgv_shd.g_old_rec.information9
508: => per_pgv_shd.g_old_rec.information6
509: ,p_information7_o
510: => per_pgv_shd.g_old_rec.information7
511: ,p_information8_o
512: => per_pgv_shd.g_old_rec.information8
513: ,p_information9_o
514: => per_pgv_shd.g_old_rec.information9
515: ,p_information10_o
516: => per_pgv_shd.g_old_rec.information10
510: => per_pgv_shd.g_old_rec.information7
511: ,p_information8_o
512: => per_pgv_shd.g_old_rec.information8
513: ,p_information9_o
514: => per_pgv_shd.g_old_rec.information9
515: ,p_information10_o
516: => per_pgv_shd.g_old_rec.information10
517: ,p_information11_o
518: => per_pgv_shd.g_old_rec.information11
512: => per_pgv_shd.g_old_rec.information8
513: ,p_information9_o
514: => per_pgv_shd.g_old_rec.information9
515: ,p_information10_o
516: => per_pgv_shd.g_old_rec.information10
517: ,p_information11_o
518: => per_pgv_shd.g_old_rec.information11
519: ,p_information12_o
520: => per_pgv_shd.g_old_rec.information12
514: => per_pgv_shd.g_old_rec.information9
515: ,p_information10_o
516: => per_pgv_shd.g_old_rec.information10
517: ,p_information11_o
518: => per_pgv_shd.g_old_rec.information11
519: ,p_information12_o
520: => per_pgv_shd.g_old_rec.information12
521: ,p_information13_o
522: => per_pgv_shd.g_old_rec.information13
516: => per_pgv_shd.g_old_rec.information10
517: ,p_information11_o
518: => per_pgv_shd.g_old_rec.information11
519: ,p_information12_o
520: => per_pgv_shd.g_old_rec.information12
521: ,p_information13_o
522: => per_pgv_shd.g_old_rec.information13
523: ,p_information14_o
524: => per_pgv_shd.g_old_rec.information14
518: => per_pgv_shd.g_old_rec.information11
519: ,p_information12_o
520: => per_pgv_shd.g_old_rec.information12
521: ,p_information13_o
522: => per_pgv_shd.g_old_rec.information13
523: ,p_information14_o
524: => per_pgv_shd.g_old_rec.information14
525: ,p_information15_o
526: => per_pgv_shd.g_old_rec.information15
520: => per_pgv_shd.g_old_rec.information12
521: ,p_information13_o
522: => per_pgv_shd.g_old_rec.information13
523: ,p_information14_o
524: => per_pgv_shd.g_old_rec.information14
525: ,p_information15_o
526: => per_pgv_shd.g_old_rec.information15
527: ,p_information16_o
528: => per_pgv_shd.g_old_rec.information16
522: => per_pgv_shd.g_old_rec.information13
523: ,p_information14_o
524: => per_pgv_shd.g_old_rec.information14
525: ,p_information15_o
526: => per_pgv_shd.g_old_rec.information15
527: ,p_information16_o
528: => per_pgv_shd.g_old_rec.information16
529: ,p_information17_o
530: => per_pgv_shd.g_old_rec.information17
524: => per_pgv_shd.g_old_rec.information14
525: ,p_information15_o
526: => per_pgv_shd.g_old_rec.information15
527: ,p_information16_o
528: => per_pgv_shd.g_old_rec.information16
529: ,p_information17_o
530: => per_pgv_shd.g_old_rec.information17
531: ,p_information18_o
532: => per_pgv_shd.g_old_rec.information18
526: => per_pgv_shd.g_old_rec.information15
527: ,p_information16_o
528: => per_pgv_shd.g_old_rec.information16
529: ,p_information17_o
530: => per_pgv_shd.g_old_rec.information17
531: ,p_information18_o
532: => per_pgv_shd.g_old_rec.information18
533: ,p_information19_o
534: => per_pgv_shd.g_old_rec.information19
528: => per_pgv_shd.g_old_rec.information16
529: ,p_information17_o
530: => per_pgv_shd.g_old_rec.information17
531: ,p_information18_o
532: => per_pgv_shd.g_old_rec.information18
533: ,p_information19_o
534: => per_pgv_shd.g_old_rec.information19
535: ,p_information20_o
536: => per_pgv_shd.g_old_rec.information20
530: => per_pgv_shd.g_old_rec.information17
531: ,p_information18_o
532: => per_pgv_shd.g_old_rec.information18
533: ,p_information19_o
534: => per_pgv_shd.g_old_rec.information19
535: ,p_information20_o
536: => per_pgv_shd.g_old_rec.information20
537: ,p_information21_o
538: => per_pgv_shd.g_old_rec.information21
532: => per_pgv_shd.g_old_rec.information18
533: ,p_information19_o
534: => per_pgv_shd.g_old_rec.information19
535: ,p_information20_o
536: => per_pgv_shd.g_old_rec.information20
537: ,p_information21_o
538: => per_pgv_shd.g_old_rec.information21
539: ,p_information22_o
540: => per_pgv_shd.g_old_rec.information22
534: => per_pgv_shd.g_old_rec.information19
535: ,p_information20_o
536: => per_pgv_shd.g_old_rec.information20
537: ,p_information21_o
538: => per_pgv_shd.g_old_rec.information21
539: ,p_information22_o
540: => per_pgv_shd.g_old_rec.information22
541: ,p_information23_o
542: => per_pgv_shd.g_old_rec.information23
536: => per_pgv_shd.g_old_rec.information20
537: ,p_information21_o
538: => per_pgv_shd.g_old_rec.information21
539: ,p_information22_o
540: => per_pgv_shd.g_old_rec.information22
541: ,p_information23_o
542: => per_pgv_shd.g_old_rec.information23
543: ,p_information24_o
544: => per_pgv_shd.g_old_rec.information24
538: => per_pgv_shd.g_old_rec.information21
539: ,p_information22_o
540: => per_pgv_shd.g_old_rec.information22
541: ,p_information23_o
542: => per_pgv_shd.g_old_rec.information23
543: ,p_information24_o
544: => per_pgv_shd.g_old_rec.information24
545: ,p_information25_o
546: => per_pgv_shd.g_old_rec.information25
540: => per_pgv_shd.g_old_rec.information22
541: ,p_information23_o
542: => per_pgv_shd.g_old_rec.information23
543: ,p_information24_o
544: => per_pgv_shd.g_old_rec.information24
545: ,p_information25_o
546: => per_pgv_shd.g_old_rec.information25
547: ,p_information26_o
548: => per_pgv_shd.g_old_rec.information26
542: => per_pgv_shd.g_old_rec.information23
543: ,p_information24_o
544: => per_pgv_shd.g_old_rec.information24
545: ,p_information25_o
546: => per_pgv_shd.g_old_rec.information25
547: ,p_information26_o
548: => per_pgv_shd.g_old_rec.information26
549: ,p_information27_o
550: => per_pgv_shd.g_old_rec.information27
544: => per_pgv_shd.g_old_rec.information24
545: ,p_information25_o
546: => per_pgv_shd.g_old_rec.information25
547: ,p_information26_o
548: => per_pgv_shd.g_old_rec.information26
549: ,p_information27_o
550: => per_pgv_shd.g_old_rec.information27
551: ,p_information28_o
552: => per_pgv_shd.g_old_rec.information28
546: => per_pgv_shd.g_old_rec.information25
547: ,p_information26_o
548: => per_pgv_shd.g_old_rec.information26
549: ,p_information27_o
550: => per_pgv_shd.g_old_rec.information27
551: ,p_information28_o
552: => per_pgv_shd.g_old_rec.information28
553: ,p_information29_o
554: => per_pgv_shd.g_old_rec.information29
548: => per_pgv_shd.g_old_rec.information26
549: ,p_information27_o
550: => per_pgv_shd.g_old_rec.information27
551: ,p_information28_o
552: => per_pgv_shd.g_old_rec.information28
553: ,p_information29_o
554: => per_pgv_shd.g_old_rec.information29
555: ,p_information30_o
556: => per_pgv_shd.g_old_rec.information30
550: => per_pgv_shd.g_old_rec.information27
551: ,p_information28_o
552: => per_pgv_shd.g_old_rec.information28
553: ,p_information29_o
554: => per_pgv_shd.g_old_rec.information29
555: ,p_information30_o
556: => per_pgv_shd.g_old_rec.information30
557: );
558: --
552: => per_pgv_shd.g_old_rec.information28
553: ,p_information29_o
554: => per_pgv_shd.g_old_rec.information29
555: ,p_information30_o
556: => per_pgv_shd.g_old_rec.information30
557: );
558: --
559: exception
560: --
612: --
613: -- {End Of Comments}
614: -- ----------------------------------------------------------------------------
615: Procedure convert_defs
616: (p_rec in out nocopy per_pgv_shd.g_rec_type
617: ) is
618: --
619: Begin
620: --
624: -- is being used then we must set to the 'current' argument value.
625: --
626: If (p_rec.business_group_id = hr_api.g_number) then
627: p_rec.business_group_id :=
628: per_pgv_shd.g_old_rec.business_group_id;
629: End If;
630: If (p_rec.version_number = hr_api.g_number) then
631: p_rec.version_number :=
632: per_pgv_shd.g_old_rec.version_number;
628: per_pgv_shd.g_old_rec.business_group_id;
629: End If;
630: If (p_rec.version_number = hr_api.g_number) then
631: p_rec.version_number :=
632: per_pgv_shd.g_old_rec.version_number;
633: End If;
634: If (p_rec.hierarchy_id = hr_api.g_number) then
635: p_rec.hierarchy_id :=
636: per_pgv_shd.g_old_rec.hierarchy_id;
632: per_pgv_shd.g_old_rec.version_number;
633: End If;
634: If (p_rec.hierarchy_id = hr_api.g_number) then
635: p_rec.hierarchy_id :=
636: per_pgv_shd.g_old_rec.hierarchy_id;
637: End If;
638: If (p_rec.date_from = hr_api.g_date) then
639: p_rec.date_from :=
640: per_pgv_shd.g_old_rec.date_from;
636: per_pgv_shd.g_old_rec.hierarchy_id;
637: End If;
638: If (p_rec.date_from = hr_api.g_date) then
639: p_rec.date_from :=
640: per_pgv_shd.g_old_rec.date_from;
641: End If;
642: If (p_rec.date_to = hr_api.g_date) then
643: p_rec.date_to :=
644: per_pgv_shd.g_old_rec.date_to;
640: per_pgv_shd.g_old_rec.date_from;
641: End If;
642: If (p_rec.date_to = hr_api.g_date) then
643: p_rec.date_to :=
644: per_pgv_shd.g_old_rec.date_to;
645: End If;
646: If (p_rec.status = hr_api.g_varchar2) then
647: p_rec.status :=
648: per_pgv_shd.g_old_rec.status;
644: per_pgv_shd.g_old_rec.date_to;
645: End If;
646: If (p_rec.status = hr_api.g_varchar2) then
647: p_rec.status :=
648: per_pgv_shd.g_old_rec.status;
649: End If;
650: If (p_rec.validate_flag = hr_api.g_varchar2) then
651: p_rec.validate_flag :=
652: per_pgv_shd.g_old_rec.validate_flag;
648: per_pgv_shd.g_old_rec.status;
649: End If;
650: If (p_rec.validate_flag = hr_api.g_varchar2) then
651: p_rec.validate_flag :=
652: per_pgv_shd.g_old_rec.validate_flag;
653: End If;
654: If (p_rec.request_id = hr_api.g_number) then
655: p_rec.request_id :=
656: per_pgv_shd.g_old_rec.request_id;
652: per_pgv_shd.g_old_rec.validate_flag;
653: End If;
654: If (p_rec.request_id = hr_api.g_number) then
655: p_rec.request_id :=
656: per_pgv_shd.g_old_rec.request_id;
657: End If;
658: If (p_rec.program_application_id = hr_api.g_number) then
659: p_rec.program_application_id :=
660: per_pgv_shd.g_old_rec.program_application_id;
656: per_pgv_shd.g_old_rec.request_id;
657: End If;
658: If (p_rec.program_application_id = hr_api.g_number) then
659: p_rec.program_application_id :=
660: per_pgv_shd.g_old_rec.program_application_id;
661: End If;
662: If (p_rec.program_id = hr_api.g_number) then
663: p_rec.program_id :=
664: per_pgv_shd.g_old_rec.program_id;
660: per_pgv_shd.g_old_rec.program_application_id;
661: End If;
662: If (p_rec.program_id = hr_api.g_number) then
663: p_rec.program_id :=
664: per_pgv_shd.g_old_rec.program_id;
665: End If;
666: If (p_rec.program_update_date = hr_api.g_date) then
667: p_rec.program_update_date :=
668: per_pgv_shd.g_old_rec.program_update_date;
664: per_pgv_shd.g_old_rec.program_id;
665: End If;
666: If (p_rec.program_update_date = hr_api.g_date) then
667: p_rec.program_update_date :=
668: per_pgv_shd.g_old_rec.program_update_date;
669: End If;
670: If (p_rec.attribute_category = hr_api.g_varchar2) then
671: p_rec.attribute_category :=
672: per_pgv_shd.g_old_rec.attribute_category;
668: per_pgv_shd.g_old_rec.program_update_date;
669: End If;
670: If (p_rec.attribute_category = hr_api.g_varchar2) then
671: p_rec.attribute_category :=
672: per_pgv_shd.g_old_rec.attribute_category;
673: End If;
674: If (p_rec.attribute1 = hr_api.g_varchar2) then
675: p_rec.attribute1 :=
676: per_pgv_shd.g_old_rec.attribute1;
672: per_pgv_shd.g_old_rec.attribute_category;
673: End If;
674: If (p_rec.attribute1 = hr_api.g_varchar2) then
675: p_rec.attribute1 :=
676: per_pgv_shd.g_old_rec.attribute1;
677: End If;
678: If (p_rec.attribute2 = hr_api.g_varchar2) then
679: p_rec.attribute2 :=
680: per_pgv_shd.g_old_rec.attribute2;
676: per_pgv_shd.g_old_rec.attribute1;
677: End If;
678: If (p_rec.attribute2 = hr_api.g_varchar2) then
679: p_rec.attribute2 :=
680: per_pgv_shd.g_old_rec.attribute2;
681: End If;
682: If (p_rec.attribute3 = hr_api.g_varchar2) then
683: p_rec.attribute3 :=
684: per_pgv_shd.g_old_rec.attribute3;
680: per_pgv_shd.g_old_rec.attribute2;
681: End If;
682: If (p_rec.attribute3 = hr_api.g_varchar2) then
683: p_rec.attribute3 :=
684: per_pgv_shd.g_old_rec.attribute3;
685: End If;
686: If (p_rec.attribute4 = hr_api.g_varchar2) then
687: p_rec.attribute4 :=
688: per_pgv_shd.g_old_rec.attribute4;
684: per_pgv_shd.g_old_rec.attribute3;
685: End If;
686: If (p_rec.attribute4 = hr_api.g_varchar2) then
687: p_rec.attribute4 :=
688: per_pgv_shd.g_old_rec.attribute4;
689: End If;
690: If (p_rec.attribute5 = hr_api.g_varchar2) then
691: p_rec.attribute5 :=
692: per_pgv_shd.g_old_rec.attribute5;
688: per_pgv_shd.g_old_rec.attribute4;
689: End If;
690: If (p_rec.attribute5 = hr_api.g_varchar2) then
691: p_rec.attribute5 :=
692: per_pgv_shd.g_old_rec.attribute5;
693: End If;
694: If (p_rec.attribute6 = hr_api.g_varchar2) then
695: p_rec.attribute6 :=
696: per_pgv_shd.g_old_rec.attribute6;
692: per_pgv_shd.g_old_rec.attribute5;
693: End If;
694: If (p_rec.attribute6 = hr_api.g_varchar2) then
695: p_rec.attribute6 :=
696: per_pgv_shd.g_old_rec.attribute6;
697: End If;
698: If (p_rec.attribute7 = hr_api.g_varchar2) then
699: p_rec.attribute7 :=
700: per_pgv_shd.g_old_rec.attribute7;
696: per_pgv_shd.g_old_rec.attribute6;
697: End If;
698: If (p_rec.attribute7 = hr_api.g_varchar2) then
699: p_rec.attribute7 :=
700: per_pgv_shd.g_old_rec.attribute7;
701: End If;
702: If (p_rec.attribute8 = hr_api.g_varchar2) then
703: p_rec.attribute8 :=
704: per_pgv_shd.g_old_rec.attribute8;
700: per_pgv_shd.g_old_rec.attribute7;
701: End If;
702: If (p_rec.attribute8 = hr_api.g_varchar2) then
703: p_rec.attribute8 :=
704: per_pgv_shd.g_old_rec.attribute8;
705: End If;
706: If (p_rec.attribute9 = hr_api.g_varchar2) then
707: p_rec.attribute9 :=
708: per_pgv_shd.g_old_rec.attribute9;
704: per_pgv_shd.g_old_rec.attribute8;
705: End If;
706: If (p_rec.attribute9 = hr_api.g_varchar2) then
707: p_rec.attribute9 :=
708: per_pgv_shd.g_old_rec.attribute9;
709: End If;
710: If (p_rec.attribute10 = hr_api.g_varchar2) then
711: p_rec.attribute10 :=
712: per_pgv_shd.g_old_rec.attribute10;
708: per_pgv_shd.g_old_rec.attribute9;
709: End If;
710: If (p_rec.attribute10 = hr_api.g_varchar2) then
711: p_rec.attribute10 :=
712: per_pgv_shd.g_old_rec.attribute10;
713: End If;
714: If (p_rec.attribute11 = hr_api.g_varchar2) then
715: p_rec.attribute11 :=
716: per_pgv_shd.g_old_rec.attribute11;
712: per_pgv_shd.g_old_rec.attribute10;
713: End If;
714: If (p_rec.attribute11 = hr_api.g_varchar2) then
715: p_rec.attribute11 :=
716: per_pgv_shd.g_old_rec.attribute11;
717: End If;
718: If (p_rec.attribute12 = hr_api.g_varchar2) then
719: p_rec.attribute12 :=
720: per_pgv_shd.g_old_rec.attribute12;
716: per_pgv_shd.g_old_rec.attribute11;
717: End If;
718: If (p_rec.attribute12 = hr_api.g_varchar2) then
719: p_rec.attribute12 :=
720: per_pgv_shd.g_old_rec.attribute12;
721: End If;
722: If (p_rec.attribute13 = hr_api.g_varchar2) then
723: p_rec.attribute13 :=
724: per_pgv_shd.g_old_rec.attribute13;
720: per_pgv_shd.g_old_rec.attribute12;
721: End If;
722: If (p_rec.attribute13 = hr_api.g_varchar2) then
723: p_rec.attribute13 :=
724: per_pgv_shd.g_old_rec.attribute13;
725: End If;
726: If (p_rec.attribute14 = hr_api.g_varchar2) then
727: p_rec.attribute14 :=
728: per_pgv_shd.g_old_rec.attribute14;
724: per_pgv_shd.g_old_rec.attribute13;
725: End If;
726: If (p_rec.attribute14 = hr_api.g_varchar2) then
727: p_rec.attribute14 :=
728: per_pgv_shd.g_old_rec.attribute14;
729: End If;
730: If (p_rec.attribute15 = hr_api.g_varchar2) then
731: p_rec.attribute15 :=
732: per_pgv_shd.g_old_rec.attribute15;
728: per_pgv_shd.g_old_rec.attribute14;
729: End If;
730: If (p_rec.attribute15 = hr_api.g_varchar2) then
731: p_rec.attribute15 :=
732: per_pgv_shd.g_old_rec.attribute15;
733: End If;
734: If (p_rec.attribute16 = hr_api.g_varchar2) then
735: p_rec.attribute16 :=
736: per_pgv_shd.g_old_rec.attribute16;
732: per_pgv_shd.g_old_rec.attribute15;
733: End If;
734: If (p_rec.attribute16 = hr_api.g_varchar2) then
735: p_rec.attribute16 :=
736: per_pgv_shd.g_old_rec.attribute16;
737: End If;
738: If (p_rec.attribute17 = hr_api.g_varchar2) then
739: p_rec.attribute17 :=
740: per_pgv_shd.g_old_rec.attribute17;
736: per_pgv_shd.g_old_rec.attribute16;
737: End If;
738: If (p_rec.attribute17 = hr_api.g_varchar2) then
739: p_rec.attribute17 :=
740: per_pgv_shd.g_old_rec.attribute17;
741: End If;
742: If (p_rec.attribute18 = hr_api.g_varchar2) then
743: p_rec.attribute18 :=
744: per_pgv_shd.g_old_rec.attribute18;
740: per_pgv_shd.g_old_rec.attribute17;
741: End If;
742: If (p_rec.attribute18 = hr_api.g_varchar2) then
743: p_rec.attribute18 :=
744: per_pgv_shd.g_old_rec.attribute18;
745: End If;
746: If (p_rec.attribute19 = hr_api.g_varchar2) then
747: p_rec.attribute19 :=
748: per_pgv_shd.g_old_rec.attribute19;
744: per_pgv_shd.g_old_rec.attribute18;
745: End If;
746: If (p_rec.attribute19 = hr_api.g_varchar2) then
747: p_rec.attribute19 :=
748: per_pgv_shd.g_old_rec.attribute19;
749: End If;
750: If (p_rec.attribute20 = hr_api.g_varchar2) then
751: p_rec.attribute20 :=
752: per_pgv_shd.g_old_rec.attribute20;
748: per_pgv_shd.g_old_rec.attribute19;
749: End If;
750: If (p_rec.attribute20 = hr_api.g_varchar2) then
751: p_rec.attribute20 :=
752: per_pgv_shd.g_old_rec.attribute20;
753: End If;
754: If (p_rec.attribute21 = hr_api.g_varchar2) then
755: p_rec.attribute21 :=
756: per_pgv_shd.g_old_rec.attribute21;
752: per_pgv_shd.g_old_rec.attribute20;
753: End If;
754: If (p_rec.attribute21 = hr_api.g_varchar2) then
755: p_rec.attribute21 :=
756: per_pgv_shd.g_old_rec.attribute21;
757: End If;
758: If (p_rec.attribute22 = hr_api.g_varchar2) then
759: p_rec.attribute22 :=
760: per_pgv_shd.g_old_rec.attribute22;
756: per_pgv_shd.g_old_rec.attribute21;
757: End If;
758: If (p_rec.attribute22 = hr_api.g_varchar2) then
759: p_rec.attribute22 :=
760: per_pgv_shd.g_old_rec.attribute22;
761: End If;
762: If (p_rec.attribute23 = hr_api.g_varchar2) then
763: p_rec.attribute23 :=
764: per_pgv_shd.g_old_rec.attribute23;
760: per_pgv_shd.g_old_rec.attribute22;
761: End If;
762: If (p_rec.attribute23 = hr_api.g_varchar2) then
763: p_rec.attribute23 :=
764: per_pgv_shd.g_old_rec.attribute23;
765: End If;
766: If (p_rec.attribute24 = hr_api.g_varchar2) then
767: p_rec.attribute24 :=
768: per_pgv_shd.g_old_rec.attribute24;
764: per_pgv_shd.g_old_rec.attribute23;
765: End If;
766: If (p_rec.attribute24 = hr_api.g_varchar2) then
767: p_rec.attribute24 :=
768: per_pgv_shd.g_old_rec.attribute24;
769: End If;
770: If (p_rec.attribute25 = hr_api.g_varchar2) then
771: p_rec.attribute25 :=
772: per_pgv_shd.g_old_rec.attribute25;
768: per_pgv_shd.g_old_rec.attribute24;
769: End If;
770: If (p_rec.attribute25 = hr_api.g_varchar2) then
771: p_rec.attribute25 :=
772: per_pgv_shd.g_old_rec.attribute25;
773: End If;
774: If (p_rec.attribute26 = hr_api.g_varchar2) then
775: p_rec.attribute26 :=
776: per_pgv_shd.g_old_rec.attribute26;
772: per_pgv_shd.g_old_rec.attribute25;
773: End If;
774: If (p_rec.attribute26 = hr_api.g_varchar2) then
775: p_rec.attribute26 :=
776: per_pgv_shd.g_old_rec.attribute26;
777: End If;
778: If (p_rec.attribute27 = hr_api.g_varchar2) then
779: p_rec.attribute27 :=
780: per_pgv_shd.g_old_rec.attribute27;
776: per_pgv_shd.g_old_rec.attribute26;
777: End If;
778: If (p_rec.attribute27 = hr_api.g_varchar2) then
779: p_rec.attribute27 :=
780: per_pgv_shd.g_old_rec.attribute27;
781: End If;
782: If (p_rec.attribute28 = hr_api.g_varchar2) then
783: p_rec.attribute28 :=
784: per_pgv_shd.g_old_rec.attribute28;
780: per_pgv_shd.g_old_rec.attribute27;
781: End If;
782: If (p_rec.attribute28 = hr_api.g_varchar2) then
783: p_rec.attribute28 :=
784: per_pgv_shd.g_old_rec.attribute28;
785: End If;
786: If (p_rec.attribute29 = hr_api.g_varchar2) then
787: p_rec.attribute29 :=
788: per_pgv_shd.g_old_rec.attribute29;
784: per_pgv_shd.g_old_rec.attribute28;
785: End If;
786: If (p_rec.attribute29 = hr_api.g_varchar2) then
787: p_rec.attribute29 :=
788: per_pgv_shd.g_old_rec.attribute29;
789: End If;
790: If (p_rec.attribute30 = hr_api.g_varchar2) then
791: p_rec.attribute30 :=
792: per_pgv_shd.g_old_rec.attribute30;
788: per_pgv_shd.g_old_rec.attribute29;
789: End If;
790: If (p_rec.attribute30 = hr_api.g_varchar2) then
791: p_rec.attribute30 :=
792: per_pgv_shd.g_old_rec.attribute30;
793: End If;
794: If (p_rec.information_category = hr_api.g_varchar2) then
795: p_rec.information_category :=
796: per_pgn_shd.g_old_rec.information_category;
922: -- |---------------------------------< upd >----------------------------------|
923: -- ----------------------------------------------------------------------------
924: Procedure upd
925: (p_effective_date in date
926: ,p_rec in out nocopy per_pgv_shd.g_rec_type
927: ) is
928: --
929: l_proc varchar2(72) := g_package||'upd';
930: --
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: -- We must lock the row which we need to update.
935: --
936: per_pgv_shd.lck
937: (p_rec.hierarchy_version_id
938: ,p_rec.object_version_number
939: );
940: --
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec per_pgv_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';
1051: --
1052: Begin
1053: hr_utility.set_location('Entering:'||l_proc, 5);
1055: -- Call conversion function to turn arguments into the
1056: -- l_rec structure.
1057: --
1058: l_rec :=
1059: per_pgv_shd.convert_args
1060: (p_hierarchy_version_id
1061: ,hr_api.g_number
1062: ,p_version_number
1063: ,hr_api.g_number