DBA Data[Home] [Help]

APPS.PER_PGV_UPD dependencies on PER_PGV_SHD

Line 55: (p_rec in out nocopy per_pgv_shd.g_rec_type

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: --

Line 157: per_pgv_shd.constraint_error

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: --

Line 162: 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: --
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: --

Line 167: 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: --
167: per_pgv_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: --
171: Raise;

Line 207: (p_rec in per_pgv_shd.g_rec_type

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: --

Line 252: ,p_rec in per_pgv_shd.g_rec_type

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: --

Line 410: => per_pgv_shd.g_old_rec.business_group_id

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

Line 412: => per_pgv_shd.g_old_rec.version_number

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

Line 414: => per_pgv_shd.g_old_rec.hierarchy_id

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

Line 416: => per_pgv_shd.g_old_rec.date_from

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

Line 418: => per_pgv_shd.g_old_rec.date_to

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

Line 420: => per_pgv_shd.g_old_rec.status

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

Line 422: => per_pgv_shd.g_old_rec.validate_flag

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

Line 424: => per_pgv_shd.g_old_rec.request_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

Line 426: => per_pgv_shd.g_old_rec.program_application_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

Line 428: => per_pgv_shd.g_old_rec.program_id

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

Line 430: => per_pgv_shd.g_old_rec.program_update_date

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

Line 432: => per_pgv_shd.g_old_rec.object_version_number

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

Line 434: => per_pgv_shd.g_old_rec.attribute_category

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

Line 436: => per_pgv_shd.g_old_rec.attribute1

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

Line 438: => per_pgv_shd.g_old_rec.attribute2

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

Line 440: => per_pgv_shd.g_old_rec.attribute3

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

Line 442: => per_pgv_shd.g_old_rec.attribute4

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

Line 444: => per_pgv_shd.g_old_rec.attribute5

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

Line 446: => per_pgv_shd.g_old_rec.attribute6

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

Line 448: => per_pgv_shd.g_old_rec.attribute7

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

Line 450: => per_pgv_shd.g_old_rec.attribute8

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

Line 452: => per_pgv_shd.g_old_rec.attribute9

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

Line 454: => per_pgv_shd.g_old_rec.attribute10

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

Line 456: => per_pgv_shd.g_old_rec.attribute11

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

Line 458: => per_pgv_shd.g_old_rec.attribute12

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

Line 460: => per_pgv_shd.g_old_rec.attribute13

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

Line 462: => per_pgv_shd.g_old_rec.attribute14

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

Line 464: => per_pgv_shd.g_old_rec.attribute15

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

Line 466: => per_pgv_shd.g_old_rec.attribute16

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

Line 468: => per_pgv_shd.g_old_rec.attribute17

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

Line 470: => per_pgv_shd.g_old_rec.attribute18

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

Line 472: => per_pgv_shd.g_old_rec.attribute19

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

Line 474: => per_pgv_shd.g_old_rec.attribute20

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

Line 476: => per_pgv_shd.g_old_rec.attribute21

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

Line 478: => per_pgv_shd.g_old_rec.attribute22

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

Line 480: => per_pgv_shd.g_old_rec.attribute23

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

Line 482: => per_pgv_shd.g_old_rec.attribute24

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

Line 484: => per_pgv_shd.g_old_rec.attribute25

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

Line 486: => per_pgv_shd.g_old_rec.attribute26

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

Line 488: => per_pgv_shd.g_old_rec.attribute27

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

Line 490: => per_pgv_shd.g_old_rec.attribute28

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

Line 492: => per_pgv_shd.g_old_rec.attribute29

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

Line 494: => per_pgv_shd.g_old_rec.attribute30

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

Line 496: => per_pgv_shd.g_old_rec.information_category

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

Line 498: => per_pgv_shd.g_old_rec.information1

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

Line 500: => per_pgv_shd.g_old_rec.information2

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

Line 502: => per_pgv_shd.g_old_rec.information3

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

Line 504: => per_pgv_shd.g_old_rec.information4

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

Line 506: => per_pgv_shd.g_old_rec.information5

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

Line 508: => per_pgv_shd.g_old_rec.information6

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

Line 510: => per_pgv_shd.g_old_rec.information7

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

Line 512: => per_pgv_shd.g_old_rec.information8

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

Line 514: => per_pgv_shd.g_old_rec.information9

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

Line 516: => per_pgv_shd.g_old_rec.information10

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

Line 518: => per_pgv_shd.g_old_rec.information11

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

Line 520: => per_pgv_shd.g_old_rec.information12

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

Line 522: => per_pgv_shd.g_old_rec.information13

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

Line 524: => per_pgv_shd.g_old_rec.information14

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

Line 526: => per_pgv_shd.g_old_rec.information15

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

Line 528: => per_pgv_shd.g_old_rec.information16

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

Line 530: => per_pgv_shd.g_old_rec.information17

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

Line 532: => per_pgv_shd.g_old_rec.information18

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

Line 534: => per_pgv_shd.g_old_rec.information19

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

Line 536: => per_pgv_shd.g_old_rec.information20

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

Line 538: => per_pgv_shd.g_old_rec.information21

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

Line 540: => per_pgv_shd.g_old_rec.information22

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

Line 542: => per_pgv_shd.g_old_rec.information23

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

Line 544: => per_pgv_shd.g_old_rec.information24

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

Line 546: => per_pgv_shd.g_old_rec.information25

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

Line 548: => per_pgv_shd.g_old_rec.information26

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

Line 550: => per_pgv_shd.g_old_rec.information27

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

Line 552: => per_pgv_shd.g_old_rec.information28

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

Line 554: => per_pgv_shd.g_old_rec.information29

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: --

Line 556: => per_pgv_shd.g_old_rec.information30

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: --

Line 616: (p_rec in out nocopy per_pgv_shd.g_rec_type

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: --

Line 628: per_pgv_shd.g_old_rec.business_group_id;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 926: ,p_rec in out nocopy per_pgv_shd.g_rec_type

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: --

Line 936: per_pgv_shd.lck

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: --

Line 1049: l_rec per_pgv_shd.g_rec_type;

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);

Line 1059: per_pgv_shd.convert_args

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