DBA Data[Home] [Help]

APPS.PER_PJO_UPD dependencies on HR_API

Line 153: When hr_api.check_integrity_violated Then

149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: per_pjo_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: per_pjo_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: per_pjo_shd.constraint_error

Line 158: When hr_api.parent_integrity_violated Then

154: -- A check constraint has been violated
155: --
156: per_pjo_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: per_pjo_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: per_pjo_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: per_pjo_shd.constraint_error

Line 163: When hr_api.unique_integrity_violated Then

159: -- Parent integrity has been violated
160: --
161: per_pjo_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: per_pjo_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: per_pjo_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When Others Then
169: --
170: Raise;
171: End update_dml;

Line 560: when hr_api.cannot_find_prog_unit then

556: );
557: --
558: exception
559: --
560: when hr_api.cannot_find_prog_unit then
561: --
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'PER_PREVIOUS_JOBS'
564: ,p_hook_type => 'AU');

Line 562: hr_api.cannot_find_prog_unit_error

558: exception
559: --
560: when hr_api.cannot_find_prog_unit then
561: --
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'PER_PREVIOUS_JOBS'
564: ,p_hook_type => 'AU');
565: --
566: end;

Line 625: If (p_rec.previous_employer_id = hr_api.g_number) then

621: -- p_rec plsql record structure
622: -- to see if a system default is being used. If a system default
623: -- is being used then we must set to the 'current' argument value.
624: --
625: If (p_rec.previous_employer_id = hr_api.g_number) then
626: p_rec.previous_employer_id :=
627: per_pjo_shd.g_old_rec.previous_employer_id;
628: End If;
629: If (p_rec.start_date = hr_api.g_date) then

Line 629: If (p_rec.start_date = hr_api.g_date) then

625: If (p_rec.previous_employer_id = hr_api.g_number) then
626: p_rec.previous_employer_id :=
627: per_pjo_shd.g_old_rec.previous_employer_id;
628: End If;
629: If (p_rec.start_date = hr_api.g_date) then
630: p_rec.start_date :=
631: per_pjo_shd.g_old_rec.start_date;
632: End If;
633: If (p_rec.end_date = hr_api.g_date) then

Line 633: If (p_rec.end_date = hr_api.g_date) then

629: If (p_rec.start_date = hr_api.g_date) then
630: p_rec.start_date :=
631: per_pjo_shd.g_old_rec.start_date;
632: End If;
633: If (p_rec.end_date = hr_api.g_date) then
634: p_rec.end_date :=
635: per_pjo_shd.g_old_rec.end_date;
636: End If;
637: If (p_rec.period_years = hr_api.g_number) then

Line 637: If (p_rec.period_years = hr_api.g_number) then

633: If (p_rec.end_date = hr_api.g_date) then
634: p_rec.end_date :=
635: per_pjo_shd.g_old_rec.end_date;
636: End If;
637: If (p_rec.period_years = hr_api.g_number) then
638: p_rec.period_years :=
639: per_pjo_shd.g_old_rec.period_years;
640: End If;
641: If (p_rec.period_days = hr_api.g_number) then

Line 641: If (p_rec.period_days = hr_api.g_number) then

637: If (p_rec.period_years = hr_api.g_number) then
638: p_rec.period_years :=
639: per_pjo_shd.g_old_rec.period_years;
640: End If;
641: If (p_rec.period_days = hr_api.g_number) then
642: p_rec.period_days :=
643: per_pjo_shd.g_old_rec.period_days;
644: End If;
645: If (p_rec.job_name = hr_api.g_varchar2) then

Line 645: If (p_rec.job_name = hr_api.g_varchar2) then

641: If (p_rec.period_days = hr_api.g_number) then
642: p_rec.period_days :=
643: per_pjo_shd.g_old_rec.period_days;
644: End If;
645: If (p_rec.job_name = hr_api.g_varchar2) then
646: p_rec.job_name :=
647: per_pjo_shd.g_old_rec.job_name;
648: End If;
649: If (p_rec.employment_category = hr_api.g_varchar2) then

Line 649: If (p_rec.employment_category = hr_api.g_varchar2) then

645: If (p_rec.job_name = hr_api.g_varchar2) then
646: p_rec.job_name :=
647: per_pjo_shd.g_old_rec.job_name;
648: End If;
649: If (p_rec.employment_category = hr_api.g_varchar2) then
650: p_rec.employment_category :=
651: per_pjo_shd.g_old_rec.employment_category;
652: End If;
653: If (p_rec.description = hr_api.g_varchar2) then

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

649: If (p_rec.employment_category = hr_api.g_varchar2) then
650: p_rec.employment_category :=
651: per_pjo_shd.g_old_rec.employment_category;
652: End If;
653: If (p_rec.description = hr_api.g_varchar2) then
654: p_rec.description :=
655: per_pjo_shd.g_old_rec.description;
656: End If;
657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then

Line 657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then

653: If (p_rec.description = hr_api.g_varchar2) then
654: p_rec.description :=
655: per_pjo_shd.g_old_rec.description;
656: End If;
657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then
658: p_rec.pjo_attribute_category :=
659: per_pjo_shd.g_old_rec.pjo_attribute_category;
660: End If;
661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then

Line 661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then

657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then
658: p_rec.pjo_attribute_category :=
659: per_pjo_shd.g_old_rec.pjo_attribute_category;
660: End If;
661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then
662: p_rec.pjo_attribute1 :=
663: per_pjo_shd.g_old_rec.pjo_attribute1;
664: End If;
665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then

Line 665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then

661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then
662: p_rec.pjo_attribute1 :=
663: per_pjo_shd.g_old_rec.pjo_attribute1;
664: End If;
665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then
666: p_rec.pjo_attribute2 :=
667: per_pjo_shd.g_old_rec.pjo_attribute2;
668: End If;
669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then

Line 669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then

665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then
666: p_rec.pjo_attribute2 :=
667: per_pjo_shd.g_old_rec.pjo_attribute2;
668: End If;
669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then
670: p_rec.pjo_attribute3 :=
671: per_pjo_shd.g_old_rec.pjo_attribute3;
672: End If;
673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then

Line 673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then

669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then
670: p_rec.pjo_attribute3 :=
671: per_pjo_shd.g_old_rec.pjo_attribute3;
672: End If;
673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then
674: p_rec.pjo_attribute4 :=
675: per_pjo_shd.g_old_rec.pjo_attribute4;
676: End If;
677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then

Line 677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then

673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then
674: p_rec.pjo_attribute4 :=
675: per_pjo_shd.g_old_rec.pjo_attribute4;
676: End If;
677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then
678: p_rec.pjo_attribute5 :=
679: per_pjo_shd.g_old_rec.pjo_attribute5;
680: End If;
681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then

Line 681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then

677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then
678: p_rec.pjo_attribute5 :=
679: per_pjo_shd.g_old_rec.pjo_attribute5;
680: End If;
681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then
682: p_rec.pjo_attribute6 :=
683: per_pjo_shd.g_old_rec.pjo_attribute6;
684: End If;
685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then

Line 685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then

681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then
682: p_rec.pjo_attribute6 :=
683: per_pjo_shd.g_old_rec.pjo_attribute6;
684: End If;
685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then
686: p_rec.pjo_attribute7 :=
687: per_pjo_shd.g_old_rec.pjo_attribute7;
688: End If;
689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then

Line 689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then

685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then
686: p_rec.pjo_attribute7 :=
687: per_pjo_shd.g_old_rec.pjo_attribute7;
688: End If;
689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then
690: p_rec.pjo_attribute8 :=
691: per_pjo_shd.g_old_rec.pjo_attribute8;
692: End If;
693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then

Line 693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then

689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then
690: p_rec.pjo_attribute8 :=
691: per_pjo_shd.g_old_rec.pjo_attribute8;
692: End If;
693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then
694: p_rec.pjo_attribute9 :=
695: per_pjo_shd.g_old_rec.pjo_attribute9;
696: End If;
697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then

Line 697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then

693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then
694: p_rec.pjo_attribute9 :=
695: per_pjo_shd.g_old_rec.pjo_attribute9;
696: End If;
697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then
698: p_rec.pjo_attribute10 :=
699: per_pjo_shd.g_old_rec.pjo_attribute10;
700: End If;
701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then

Line 701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then

697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then
698: p_rec.pjo_attribute10 :=
699: per_pjo_shd.g_old_rec.pjo_attribute10;
700: End If;
701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then
702: p_rec.pjo_attribute11 :=
703: per_pjo_shd.g_old_rec.pjo_attribute11;
704: End If;
705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then

Line 705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then

701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then
702: p_rec.pjo_attribute11 :=
703: per_pjo_shd.g_old_rec.pjo_attribute11;
704: End If;
705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then
706: p_rec.pjo_attribute12 :=
707: per_pjo_shd.g_old_rec.pjo_attribute12;
708: End If;
709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then

Line 709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then

705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then
706: p_rec.pjo_attribute12 :=
707: per_pjo_shd.g_old_rec.pjo_attribute12;
708: End If;
709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then
710: p_rec.pjo_attribute13 :=
711: per_pjo_shd.g_old_rec.pjo_attribute13;
712: End If;
713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then

Line 713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then

709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then
710: p_rec.pjo_attribute13 :=
711: per_pjo_shd.g_old_rec.pjo_attribute13;
712: End If;
713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then
714: p_rec.pjo_attribute14 :=
715: per_pjo_shd.g_old_rec.pjo_attribute14;
716: End If;
717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then

Line 717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then

713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then
714: p_rec.pjo_attribute14 :=
715: per_pjo_shd.g_old_rec.pjo_attribute14;
716: End If;
717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then
718: p_rec.pjo_attribute15 :=
719: per_pjo_shd.g_old_rec.pjo_attribute15;
720: End If;
721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then

Line 721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then

717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then
718: p_rec.pjo_attribute15 :=
719: per_pjo_shd.g_old_rec.pjo_attribute15;
720: End If;
721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then
722: p_rec.pjo_attribute16 :=
723: per_pjo_shd.g_old_rec.pjo_attribute16;
724: End If;
725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then

Line 725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then

721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then
722: p_rec.pjo_attribute16 :=
723: per_pjo_shd.g_old_rec.pjo_attribute16;
724: End If;
725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then
726: p_rec.pjo_attribute17 :=
727: per_pjo_shd.g_old_rec.pjo_attribute17;
728: End If;
729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then

Line 729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then

725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then
726: p_rec.pjo_attribute17 :=
727: per_pjo_shd.g_old_rec.pjo_attribute17;
728: End If;
729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then
730: p_rec.pjo_attribute18 :=
731: per_pjo_shd.g_old_rec.pjo_attribute18;
732: End If;
733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then

Line 733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then

729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then
730: p_rec.pjo_attribute18 :=
731: per_pjo_shd.g_old_rec.pjo_attribute18;
732: End If;
733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then
734: p_rec.pjo_attribute19 :=
735: per_pjo_shd.g_old_rec.pjo_attribute19;
736: End If;
737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then

Line 737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then

733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then
734: p_rec.pjo_attribute19 :=
735: per_pjo_shd.g_old_rec.pjo_attribute19;
736: End If;
737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then
738: p_rec.pjo_attribute20 :=
739: per_pjo_shd.g_old_rec.pjo_attribute20;
740: End If;
741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then

Line 741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then

737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then
738: p_rec.pjo_attribute20 :=
739: per_pjo_shd.g_old_rec.pjo_attribute20;
740: End If;
741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then
742: p_rec.pjo_attribute21 :=
743: per_pjo_shd.g_old_rec.pjo_attribute21;
744: End If;
745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then

Line 745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then

741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then
742: p_rec.pjo_attribute21 :=
743: per_pjo_shd.g_old_rec.pjo_attribute21;
744: End If;
745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then
746: p_rec.pjo_attribute22 :=
747: per_pjo_shd.g_old_rec.pjo_attribute22;
748: End If;
749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then

Line 749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then

745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then
746: p_rec.pjo_attribute22 :=
747: per_pjo_shd.g_old_rec.pjo_attribute22;
748: End If;
749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then
750: p_rec.pjo_attribute23 :=
751: per_pjo_shd.g_old_rec.pjo_attribute23;
752: End If;
753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then

Line 753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then

749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then
750: p_rec.pjo_attribute23 :=
751: per_pjo_shd.g_old_rec.pjo_attribute23;
752: End If;
753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then
754: p_rec.pjo_attribute24 :=
755: per_pjo_shd.g_old_rec.pjo_attribute24;
756: End If;
757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then

Line 757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then

753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then
754: p_rec.pjo_attribute24 :=
755: per_pjo_shd.g_old_rec.pjo_attribute24;
756: End If;
757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then
758: p_rec.pjo_attribute25 :=
759: per_pjo_shd.g_old_rec.pjo_attribute25;
760: End If;
761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then

Line 761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then

757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then
758: p_rec.pjo_attribute25 :=
759: per_pjo_shd.g_old_rec.pjo_attribute25;
760: End If;
761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then
762: p_rec.pjo_attribute26 :=
763: per_pjo_shd.g_old_rec.pjo_attribute26;
764: End If;
765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then

Line 765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then

761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then
762: p_rec.pjo_attribute26 :=
763: per_pjo_shd.g_old_rec.pjo_attribute26;
764: End If;
765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then
766: p_rec.pjo_attribute27 :=
767: per_pjo_shd.g_old_rec.pjo_attribute27;
768: End If;
769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then

Line 769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then

765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then
766: p_rec.pjo_attribute27 :=
767: per_pjo_shd.g_old_rec.pjo_attribute27;
768: End If;
769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then
770: p_rec.pjo_attribute28 :=
771: per_pjo_shd.g_old_rec.pjo_attribute28;
772: End If;
773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then

Line 773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then

769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then
770: p_rec.pjo_attribute28 :=
771: per_pjo_shd.g_old_rec.pjo_attribute28;
772: End If;
773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then
774: p_rec.pjo_attribute29 :=
775: per_pjo_shd.g_old_rec.pjo_attribute29;
776: End If;
777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then

Line 777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then

773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then
774: p_rec.pjo_attribute29 :=
775: per_pjo_shd.g_old_rec.pjo_attribute29;
776: End If;
777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then
778: p_rec.pjo_attribute30 :=
779: per_pjo_shd.g_old_rec.pjo_attribute30;
780: End If;
781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then

Line 781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then

777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then
778: p_rec.pjo_attribute30 :=
779: per_pjo_shd.g_old_rec.pjo_attribute30;
780: End If;
781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then
782: p_rec.pjo_information_category :=
783: per_pjo_shd.g_old_rec.pjo_information_category;
784: End If;
785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then

Line 785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then

781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then
782: p_rec.pjo_information_category :=
783: per_pjo_shd.g_old_rec.pjo_information_category;
784: End If;
785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then
786: p_rec.pjo_information1 :=
787: per_pjo_shd.g_old_rec.pjo_information1;
788: End If;
789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then

Line 789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then

785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then
786: p_rec.pjo_information1 :=
787: per_pjo_shd.g_old_rec.pjo_information1;
788: End If;
789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then
790: p_rec.pjo_information2 :=
791: per_pjo_shd.g_old_rec.pjo_information2;
792: End If;
793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then

Line 793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then

789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then
790: p_rec.pjo_information2 :=
791: per_pjo_shd.g_old_rec.pjo_information2;
792: End If;
793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then
794: p_rec.pjo_information3 :=
795: per_pjo_shd.g_old_rec.pjo_information3;
796: End If;
797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then

Line 797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then

793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then
794: p_rec.pjo_information3 :=
795: per_pjo_shd.g_old_rec.pjo_information3;
796: End If;
797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then
798: p_rec.pjo_information4 :=
799: per_pjo_shd.g_old_rec.pjo_information4;
800: End If;
801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then

Line 801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then

797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then
798: p_rec.pjo_information4 :=
799: per_pjo_shd.g_old_rec.pjo_information4;
800: End If;
801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then
802: p_rec.pjo_information5 :=
803: per_pjo_shd.g_old_rec.pjo_information5;
804: End If;
805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then

Line 805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then

801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then
802: p_rec.pjo_information5 :=
803: per_pjo_shd.g_old_rec.pjo_information5;
804: End If;
805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then
806: p_rec.pjo_information6 :=
807: per_pjo_shd.g_old_rec.pjo_information6;
808: End If;
809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then

Line 809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then

805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then
806: p_rec.pjo_information6 :=
807: per_pjo_shd.g_old_rec.pjo_information6;
808: End If;
809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then
810: p_rec.pjo_information7 :=
811: per_pjo_shd.g_old_rec.pjo_information7;
812: End If;
813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then

Line 813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then

809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then
810: p_rec.pjo_information7 :=
811: per_pjo_shd.g_old_rec.pjo_information7;
812: End If;
813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then
814: p_rec.pjo_information8 :=
815: per_pjo_shd.g_old_rec.pjo_information8;
816: End If;
817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then

Line 817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then

813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then
814: p_rec.pjo_information8 :=
815: per_pjo_shd.g_old_rec.pjo_information8;
816: End If;
817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then
818: p_rec.pjo_information9 :=
819: per_pjo_shd.g_old_rec.pjo_information9;
820: End If;
821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then

Line 821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then

817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then
818: p_rec.pjo_information9 :=
819: per_pjo_shd.g_old_rec.pjo_information9;
820: End If;
821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then
822: p_rec.pjo_information10 :=
823: per_pjo_shd.g_old_rec.pjo_information10;
824: End If;
825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then

Line 825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then

821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then
822: p_rec.pjo_information10 :=
823: per_pjo_shd.g_old_rec.pjo_information10;
824: End If;
825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then
826: p_rec.pjo_information11 :=
827: per_pjo_shd.g_old_rec.pjo_information11;
828: End If;
829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then

Line 829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then

825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then
826: p_rec.pjo_information11 :=
827: per_pjo_shd.g_old_rec.pjo_information11;
828: End If;
829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then
830: p_rec.pjo_information12 :=
831: per_pjo_shd.g_old_rec.pjo_information12;
832: End If;
833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then

Line 833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then

829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then
830: p_rec.pjo_information12 :=
831: per_pjo_shd.g_old_rec.pjo_information12;
832: End If;
833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then
834: p_rec.pjo_information13 :=
835: per_pjo_shd.g_old_rec.pjo_information13;
836: End If;
837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then

Line 837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then

833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then
834: p_rec.pjo_information13 :=
835: per_pjo_shd.g_old_rec.pjo_information13;
836: End If;
837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then
838: p_rec.pjo_information14 :=
839: per_pjo_shd.g_old_rec.pjo_information14;
840: End If;
841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then

Line 841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then

837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then
838: p_rec.pjo_information14 :=
839: per_pjo_shd.g_old_rec.pjo_information14;
840: End If;
841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then
842: p_rec.pjo_information15 :=
843: per_pjo_shd.g_old_rec.pjo_information15;
844: End If;
845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then

Line 845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then

841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then
842: p_rec.pjo_information15 :=
843: per_pjo_shd.g_old_rec.pjo_information15;
844: End If;
845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then
846: p_rec.pjo_information16 :=
847: per_pjo_shd.g_old_rec.pjo_information16;
848: End If;
849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then

Line 849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then

845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then
846: p_rec.pjo_information16 :=
847: per_pjo_shd.g_old_rec.pjo_information16;
848: End If;
849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then
850: p_rec.pjo_information17 :=
851: per_pjo_shd.g_old_rec.pjo_information17;
852: End If;
853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then

Line 853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then

849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then
850: p_rec.pjo_information17 :=
851: per_pjo_shd.g_old_rec.pjo_information17;
852: End If;
853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then
854: p_rec.pjo_information18 :=
855: per_pjo_shd.g_old_rec.pjo_information18;
856: End If;
857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then

Line 857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then

853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then
854: p_rec.pjo_information18 :=
855: per_pjo_shd.g_old_rec.pjo_information18;
856: End If;
857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then
858: p_rec.pjo_information19 :=
859: per_pjo_shd.g_old_rec.pjo_information19;
860: End If;
861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then

Line 861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then

857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then
858: p_rec.pjo_information19 :=
859: per_pjo_shd.g_old_rec.pjo_information19;
860: End If;
861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then
862: p_rec.pjo_information20 :=
863: per_pjo_shd.g_old_rec.pjo_information20;
864: End If;
865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then

Line 865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then

861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then
862: p_rec.pjo_information20 :=
863: per_pjo_shd.g_old_rec.pjo_information20;
864: End If;
865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then
866: p_rec.pjo_information21 :=
867: per_pjo_shd.g_old_rec.pjo_information21;
868: End If;
869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then

Line 869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then

865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then
866: p_rec.pjo_information21 :=
867: per_pjo_shd.g_old_rec.pjo_information21;
868: End If;
869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then
870: p_rec.pjo_information22 :=
871: per_pjo_shd.g_old_rec.pjo_information22;
872: End If;
873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then

Line 873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then

869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then
870: p_rec.pjo_information22 :=
871: per_pjo_shd.g_old_rec.pjo_information22;
872: End If;
873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then
874: p_rec.pjo_information23 :=
875: per_pjo_shd.g_old_rec.pjo_information23;
876: End If;
877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then

Line 877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then

873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then
874: p_rec.pjo_information23 :=
875: per_pjo_shd.g_old_rec.pjo_information23;
876: End If;
877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then
878: p_rec.pjo_information24 :=
879: per_pjo_shd.g_old_rec.pjo_information24;
880: End If;
881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then

Line 881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then

877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then
878: p_rec.pjo_information24 :=
879: per_pjo_shd.g_old_rec.pjo_information24;
880: End If;
881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then
882: p_rec.pjo_information25 :=
883: per_pjo_shd.g_old_rec.pjo_information25;
884: End If;
885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then

Line 885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then

881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then
882: p_rec.pjo_information25 :=
883: per_pjo_shd.g_old_rec.pjo_information25;
884: End If;
885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then
886: p_rec.pjo_information26 :=
887: per_pjo_shd.g_old_rec.pjo_information26;
888: End If;
889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then

Line 889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then

885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then
886: p_rec.pjo_information26 :=
887: per_pjo_shd.g_old_rec.pjo_information26;
888: End If;
889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then
890: p_rec.pjo_information27 :=
891: per_pjo_shd.g_old_rec.pjo_information27;
892: End If;
893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then

Line 893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then

889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then
890: p_rec.pjo_information27 :=
891: per_pjo_shd.g_old_rec.pjo_information27;
892: End If;
893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then
894: p_rec.pjo_information28 :=
895: per_pjo_shd.g_old_rec.pjo_information28;
896: End If;
897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then

Line 897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then

893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then
894: p_rec.pjo_information28 :=
895: per_pjo_shd.g_old_rec.pjo_information28;
896: End If;
897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then
898: p_rec.pjo_information29 :=
899: per_pjo_shd.g_old_rec.pjo_information29;
900: End If;
901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then

Line 901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then

897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then
898: p_rec.pjo_information29 :=
899: per_pjo_shd.g_old_rec.pjo_information29;
900: End If;
901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then
902: p_rec.pjo_information30 :=
903: per_pjo_shd.g_old_rec.pjo_information30;
904: End If;
905: If (p_rec.all_assignments = hr_api.g_varchar2) then

Line 905: If (p_rec.all_assignments = hr_api.g_varchar2) then

901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then
902: p_rec.pjo_information30 :=
903: per_pjo_shd.g_old_rec.pjo_information30;
904: End If;
905: If (p_rec.all_assignments = hr_api.g_varchar2) then
906: p_rec.all_assignments :=
907: per_pjo_shd.g_old_rec.all_assignments;
908: End If;
909: If (p_rec.period_months = hr_api.g_number) then

Line 909: If (p_rec.period_months = hr_api.g_number) then

905: If (p_rec.all_assignments = hr_api.g_varchar2) then
906: p_rec.all_assignments :=
907: per_pjo_shd.g_old_rec.all_assignments;
908: End If;
909: If (p_rec.period_months = hr_api.g_number) then
910: p_rec.period_months :=
911: per_pjo_shd.g_old_rec.period_months;
912: End If;
913: --

Line 976: ,p_previous_employer_id in number default hr_api.g_number

972: Procedure upd
973: (p_effective_date in date
974: ,p_previous_job_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_previous_employer_id in number default hr_api.g_number
977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number

Line 977: ,p_start_date in date default hr_api.g_date

973: (p_effective_date in date
974: ,p_previous_job_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_previous_employer_id in number default hr_api.g_number
977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2

Line 978: ,p_end_date in date default hr_api.g_date

974: ,p_previous_job_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_previous_employer_id in number default hr_api.g_number
977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 979: ,p_period_years in number default hr_api.g_number

975: ,p_object_version_number in out nocopy number
976: ,p_previous_employer_id in number default hr_api.g_number
977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2

Line 980: ,p_period_days in number default hr_api.g_number

976: ,p_previous_employer_id in number default hr_api.g_number
977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2

Line 981: ,p_job_name in varchar2 default hr_api.g_varchar2

977: ,p_start_date in date default hr_api.g_date
978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2

Line 982: ,p_employment_category in varchar2 default hr_api.g_varchar2

978: ,p_end_date in date default hr_api.g_date
979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2

Line 983: ,p_description in varchar2 default hr_api.g_varchar2

979: ,p_period_years in number default hr_api.g_number
980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2

Line 984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2

980: ,p_period_days in number default hr_api.g_number
981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2

Line 985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2

981: ,p_job_name in varchar2 default hr_api.g_varchar2
982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2

Line 986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2

982: ,p_employment_category in varchar2 default hr_api.g_varchar2
983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2

Line 987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2

983: ,p_description in varchar2 default hr_api.g_varchar2
984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2

Line 988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2

984: ,p_pjo_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2

Line 989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2

985: ,p_pjo_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2

Line 990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2

986: ,p_pjo_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2

Line 991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2

987: ,p_pjo_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2

Line 992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2

988: ,p_pjo_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2

Line 993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2

989: ,p_pjo_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2

Line 994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2

990: ,p_pjo_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2

Line 995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2

991: ,p_pjo_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2

Line 996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2

992: ,p_pjo_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2

Line 997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2

993: ,p_pjo_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2

Line 998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2

994: ,p_pjo_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2

Line 999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2

995: ,p_pjo_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2

Line 1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2

996: ,p_pjo_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2

997: ,p_pjo_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2

Line 1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2

998: ,p_pjo_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2

999: ,p_pjo_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2

1000: ,p_pjo_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2

1001: ,p_pjo_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2

1002: ,p_pjo_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2

1003: ,p_pjo_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2

1004: ,p_pjo_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2

1005: ,p_pjo_attribute21 in varchar2 default hr_api.g_varchar2
1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2

1006: ,p_pjo_attribute22 in varchar2 default hr_api.g_varchar2
1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2

1007: ,p_pjo_attribute23 in varchar2 default hr_api.g_varchar2
1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2

Line 1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2

1008: ,p_pjo_attribute24 in varchar2 default hr_api.g_varchar2
1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2

1009: ,p_pjo_attribute25 in varchar2 default hr_api.g_varchar2
1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2

1010: ,p_pjo_attribute26 in varchar2 default hr_api.g_varchar2
1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2

1011: ,p_pjo_attribute27 in varchar2 default hr_api.g_varchar2
1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2

1012: ,p_pjo_attribute28 in varchar2 default hr_api.g_varchar2
1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2

1013: ,p_pjo_attribute29 in varchar2 default hr_api.g_varchar2
1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2

1014: ,p_pjo_attribute30 in varchar2 default hr_api.g_varchar2
1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2

1015: ,p_pjo_information_category in varchar2 default hr_api.g_varchar2
1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2

1016: ,p_pjo_information1 in varchar2 default hr_api.g_varchar2
1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2

1017: ,p_pjo_information2 in varchar2 default hr_api.g_varchar2
1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2

1018: ,p_pjo_information3 in varchar2 default hr_api.g_varchar2
1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2

1019: ,p_pjo_information4 in varchar2 default hr_api.g_varchar2
1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2

1020: ,p_pjo_information5 in varchar2 default hr_api.g_varchar2
1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2

1021: ,p_pjo_information6 in varchar2 default hr_api.g_varchar2
1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2

1022: ,p_pjo_information7 in varchar2 default hr_api.g_varchar2
1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2

1023: ,p_pjo_information8 in varchar2 default hr_api.g_varchar2
1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2

1024: ,p_pjo_information9 in varchar2 default hr_api.g_varchar2
1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2

1025: ,p_pjo_information10 in varchar2 default hr_api.g_varchar2
1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2

1026: ,p_pjo_information11 in varchar2 default hr_api.g_varchar2
1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2

1027: ,p_pjo_information12 in varchar2 default hr_api.g_varchar2
1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2

1028: ,p_pjo_information13 in varchar2 default hr_api.g_varchar2
1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2

1029: ,p_pjo_information14 in varchar2 default hr_api.g_varchar2
1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2

1030: ,p_pjo_information15 in varchar2 default hr_api.g_varchar2
1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2

1031: ,p_pjo_information16 in varchar2 default hr_api.g_varchar2
1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2

1032: ,p_pjo_information17 in varchar2 default hr_api.g_varchar2
1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2

1033: ,p_pjo_information18 in varchar2 default hr_api.g_varchar2
1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2

1034: ,p_pjo_information19 in varchar2 default hr_api.g_varchar2
1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2

1035: ,p_pjo_information20 in varchar2 default hr_api.g_varchar2
1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2

1036: ,p_pjo_information21 in varchar2 default hr_api.g_varchar2
1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2

1037: ,p_pjo_information22 in varchar2 default hr_api.g_varchar2
1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2

1038: ,p_pjo_information23 in varchar2 default hr_api.g_varchar2
1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2

Line 1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2

1039: ,p_pjo_information24 in varchar2 default hr_api.g_varchar2
1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number

Line 1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2

1040: ,p_pjo_information25 in varchar2 default hr_api.g_varchar2
1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number
1048: ) is

Line 1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2

1041: ,p_pjo_information26 in varchar2 default hr_api.g_varchar2
1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number
1048: ) is
1049: --

Line 1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2

1042: ,p_pjo_information27 in varchar2 default hr_api.g_varchar2
1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number
1048: ) is
1049: --
1050: l_rec per_pjo_shd.g_rec_type;

Line 1047: ,p_period_months in number default hr_api.g_number

1043: ,p_pjo_information28 in varchar2 default hr_api.g_varchar2
1044: ,p_pjo_information29 in varchar2 default hr_api.g_varchar2
1045: ,p_pjo_information30 in varchar2 default hr_api.g_varchar2
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number
1048: ) is
1049: --
1050: l_rec per_pjo_shd.g_rec_type;
1051: l_proc varchar2(72) := g_package||'upd';