eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PAC_UPD dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated Then

131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated Then

136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
148: End update_dml;

Line 441: when hr_api.cannot_find_prog_unit then

437: );
438: --
439: exception
440: --
441: when hr_api.cannot_find_prog_unit then
442: --
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'
445: ,p_hook_type => 'AU');

Line 443: hr_api.cannot_find_prog_unit_error

439: exception
440: --
441: when hr_api.cannot_find_prog_unit then
442: --
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'
445: ,p_hook_type => 'AU');
446: --
447: end;

Line 506: If (p_rec.checklist_id = hr_api.g_number) then

502: -- p_rec plsql record structure
503: -- to see if a system default is being used. If a system default
504: -- is being used then we must set to the 'current' argument value.
505: --
506: If (p_rec.checklist_id = hr_api.g_number) then
507: p_rec.checklist_id :=
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then

Line 510: If (p_rec.person_id = hr_api.g_number) then

506: If (p_rec.checklist_id = hr_api.g_number) then
507: p_rec.checklist_id :=
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then

Line 514: If (p_rec.assignment_id = hr_api.g_number) then

510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then

Line 518: If (p_rec.checklist_name = hr_api.g_varchar2) then

514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then

Line 522: If (p_rec.description = hr_api.g_varchar2) then

518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then

Line 526: If (p_rec.checklist_category = hr_api.g_varchar2) then

522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 530: If (p_rec.attribute_category = hr_api.g_varchar2) then

526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 534: If (p_rec.attribute1 = hr_api.g_varchar2) then

530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 538: If (p_rec.attribute2 = hr_api.g_varchar2) then

534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 542: If (p_rec.attribute3 = hr_api.g_varchar2) then

538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 546: If (p_rec.attribute4 = hr_api.g_varchar2) then

542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 550: If (p_rec.attribute5 = hr_api.g_varchar2) then

546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 554: If (p_rec.attribute6 = hr_api.g_varchar2) then

550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 558: If (p_rec.attribute7 = hr_api.g_varchar2) then

554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 562: If (p_rec.attribute8 = hr_api.g_varchar2) then

558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 566: If (p_rec.attribute9 = hr_api.g_varchar2) then

562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 570: If (p_rec.attribute10 = hr_api.g_varchar2) then

566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 574: If (p_rec.attribute11 = hr_api.g_varchar2) then

570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 578: If (p_rec.attribute12 = hr_api.g_varchar2) then

574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 582: If (p_rec.attribute13 = hr_api.g_varchar2) then

578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 586: If (p_rec.attribute14 = hr_api.g_varchar2) then

582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 590: If (p_rec.attribute15 = hr_api.g_varchar2) then

586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 594: If (p_rec.attribute16 = hr_api.g_varchar2) then

590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 598: If (p_rec.attribute17 = hr_api.g_varchar2) then

594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 602: If (p_rec.attribute18 = hr_api.g_varchar2) then

598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 606: If (p_rec.attribute19 = hr_api.g_varchar2) then

602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 610: If (p_rec.attribute20 = hr_api.g_varchar2) then

606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then

Line 614: If (p_rec.information_category = hr_api.g_varchar2) then

610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then

Line 618: If (p_rec.information1 = hr_api.g_varchar2) then

614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then

Line 622: If (p_rec.information2 = hr_api.g_varchar2) then

618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then

Line 626: If (p_rec.information3 = hr_api.g_varchar2) then

622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then

Line 630: If (p_rec.information4 = hr_api.g_varchar2) then

626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then

Line 634: If (p_rec.information5 = hr_api.g_varchar2) then

630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then

Line 638: If (p_rec.information6 = hr_api.g_varchar2) then

634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then

Line 642: If (p_rec.information7 = hr_api.g_varchar2) then

638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then

Line 646: If (p_rec.information8 = hr_api.g_varchar2) then

642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then

Line 650: If (p_rec.information9 = hr_api.g_varchar2) then

646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then

Line 654: If (p_rec.information10 = hr_api.g_varchar2) then

650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then

Line 658: If (p_rec.information11 = hr_api.g_varchar2) then

654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then

Line 662: If (p_rec.information12 = hr_api.g_varchar2) then

658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then

Line 666: If (p_rec.information13 = hr_api.g_varchar2) then

662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then

Line 670: If (p_rec.information14 = hr_api.g_varchar2) then

666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then

Line 674: If (p_rec.information15 = hr_api.g_varchar2) then

670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then

Line 678: If (p_rec.information16 = hr_api.g_varchar2) then

674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then

Line 682: If (p_rec.information17 = hr_api.g_varchar2) then

678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then

Line 686: If (p_rec.information18 = hr_api.g_varchar2) then

682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then

Line 690: If (p_rec.information19 = hr_api.g_varchar2) then

686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then

Line 694: If (p_rec.information20 = hr_api.g_varchar2) then

690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then
695: p_rec.information20 :=
696: per_pac_shd.g_old_rec.information20;
697: End If;
698: --

Line 762: ,p_checklist_id in number default hr_api.g_number

758: Procedure upd
759: (p_effective_date in date
760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2

Line 763: ,p_person_id in number default hr_api.g_number

759: (p_effective_date in date
760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2

Line 764: ,p_assignment_id in number default hr_api.g_number

760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 765: ,p_checklist_name in varchar2 default hr_api.g_varchar2

761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 766: ,p_description in varchar2 default hr_api.g_varchar2

762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 767: ,p_checklist_category in varchar2 default hr_api.g_varchar2

763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 789: ,p_information_category in varchar2 default hr_api.g_varchar2

785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 790: ,p_information1 in varchar2 default hr_api.g_varchar2

786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 791: ,p_information2 in varchar2 default hr_api.g_varchar2

787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 792: ,p_information3 in varchar2 default hr_api.g_varchar2

788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 793: ,p_information4 in varchar2 default hr_api.g_varchar2

789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 794: ,p_information5 in varchar2 default hr_api.g_varchar2

790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 795: ,p_information6 in varchar2 default hr_api.g_varchar2

791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 796: ,p_information7 in varchar2 default hr_api.g_varchar2

792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 797: ,p_information8 in varchar2 default hr_api.g_varchar2

793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 798: ,p_information9 in varchar2 default hr_api.g_varchar2

794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 799: ,p_information10 in varchar2 default hr_api.g_varchar2

795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 800: ,p_information11 in varchar2 default hr_api.g_varchar2

796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 801: ,p_information12 in varchar2 default hr_api.g_varchar2

797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 802: ,p_information13 in varchar2 default hr_api.g_varchar2

798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 803: ,p_information14 in varchar2 default hr_api.g_varchar2

799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 804: ,p_information15 in varchar2 default hr_api.g_varchar2

800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 805: ,p_information16 in varchar2 default hr_api.g_varchar2

801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 806: ,p_information17 in varchar2 default hr_api.g_varchar2

802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is

Line 807: ,p_information18 in varchar2 default hr_api.g_varchar2

803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --

Line 808: ,p_information19 in varchar2 default hr_api.g_varchar2

804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
812: l_rec per_pac_shd.g_rec_type;

Line 809: ,p_information20 in varchar2 default hr_api.g_varchar2

805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
812: l_rec per_pac_shd.g_rec_type;
813: l_proc varchar2(72) := g_package||'upd';