156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: --
159: Exception
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: --
163: psp_erd_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.check_integrity_violated Then
161: -- A check constraint has been violated
162: --
163: psp_erd_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: psp_erd_shd.constraint_error
161: -- A check constraint has been violated
162: --
163: psp_erd_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: psp_erd_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.parent_integrity_violated Then
166: -- Parent integrity has been violated
167: --
168: psp_erd_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: psp_erd_shd.constraint_error
166: -- Parent integrity has been violated
167: --
168: psp_erd_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: psp_erd_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: --
173: psp_erd_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: --
177: Raise;
178: End update_dml;
589: );
590: --
591: exception
592: --
593: when hr_api.cannot_find_prog_unit then
594: --
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'PSP_EFF_REPORT_DETAILS'
597: ,p_hook_type => 'AU');
591: exception
592: --
593: when hr_api.cannot_find_prog_unit then
594: --
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'PSP_EFF_REPORT_DETAILS'
597: ,p_hook_type => 'AU');
598: --
599: end;
654: -- p_rec plsql record structure
655: -- to see if a system default is being used. If a system default
656: -- is being used then we must set to the 'current' argument value.
657: --
658: If (p_rec.effort_report_id = hr_api.g_number) then
659: p_rec.effort_report_id :=
660: psp_erd_shd.g_old_rec.effort_report_id;
661: End If;
662: If (p_rec.assignment_id = hr_api.g_number) then
658: If (p_rec.effort_report_id = hr_api.g_number) then
659: p_rec.effort_report_id :=
660: psp_erd_shd.g_old_rec.effort_report_id;
661: End If;
662: If (p_rec.assignment_id = hr_api.g_number) then
663: p_rec.assignment_id :=
664: psp_erd_shd.g_old_rec.assignment_id;
665: End If;
666: If (p_rec.assignment_number = hr_api.g_varchar2) then
662: If (p_rec.assignment_id = hr_api.g_number) then
663: p_rec.assignment_id :=
664: psp_erd_shd.g_old_rec.assignment_id;
665: End If;
666: If (p_rec.assignment_number = hr_api.g_varchar2) then
667: p_rec.assignment_number :=
668: psp_erd_shd.g_old_rec.assignment_number;
669: End If;
670: If (p_rec.gl_sum_criteria_segment_name = hr_api.g_varchar2) then
666: If (p_rec.assignment_number = hr_api.g_varchar2) then
667: p_rec.assignment_number :=
668: psp_erd_shd.g_old_rec.assignment_number;
669: End If;
670: If (p_rec.gl_sum_criteria_segment_name = hr_api.g_varchar2) then
671: p_rec.gl_sum_criteria_segment_name :=
672: psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name;
673: End If;
674: If (p_rec.gl_segment1 = hr_api.g_varchar2) then
670: If (p_rec.gl_sum_criteria_segment_name = hr_api.g_varchar2) then
671: p_rec.gl_sum_criteria_segment_name :=
672: psp_erd_shd.g_old_rec.gl_sum_criteria_segment_name;
673: End If;
674: If (p_rec.gl_segment1 = hr_api.g_varchar2) then
675: p_rec.gl_segment1 :=
676: psp_erd_shd.g_old_rec.gl_segment1;
677: End If;
678: If (p_rec.gl_segment2 = hr_api.g_varchar2) then
674: If (p_rec.gl_segment1 = hr_api.g_varchar2) then
675: p_rec.gl_segment1 :=
676: psp_erd_shd.g_old_rec.gl_segment1;
677: End If;
678: If (p_rec.gl_segment2 = hr_api.g_varchar2) then
679: p_rec.gl_segment2 :=
680: psp_erd_shd.g_old_rec.gl_segment2;
681: End If;
682: If (p_rec.gl_segment3 = hr_api.g_varchar2) then
678: If (p_rec.gl_segment2 = hr_api.g_varchar2) then
679: p_rec.gl_segment2 :=
680: psp_erd_shd.g_old_rec.gl_segment2;
681: End If;
682: If (p_rec.gl_segment3 = hr_api.g_varchar2) then
683: p_rec.gl_segment3 :=
684: psp_erd_shd.g_old_rec.gl_segment3;
685: End If;
686: If (p_rec.gl_segment4 = hr_api.g_varchar2) then
682: If (p_rec.gl_segment3 = hr_api.g_varchar2) then
683: p_rec.gl_segment3 :=
684: psp_erd_shd.g_old_rec.gl_segment3;
685: End If;
686: If (p_rec.gl_segment4 = hr_api.g_varchar2) then
687: p_rec.gl_segment4 :=
688: psp_erd_shd.g_old_rec.gl_segment4;
689: End If;
690: If (p_rec.gl_segment5 = hr_api.g_varchar2) then
686: If (p_rec.gl_segment4 = hr_api.g_varchar2) then
687: p_rec.gl_segment4 :=
688: psp_erd_shd.g_old_rec.gl_segment4;
689: End If;
690: If (p_rec.gl_segment5 = hr_api.g_varchar2) then
691: p_rec.gl_segment5 :=
692: psp_erd_shd.g_old_rec.gl_segment5;
693: End If;
694: If (p_rec.gl_segment6 = hr_api.g_varchar2) then
690: If (p_rec.gl_segment5 = hr_api.g_varchar2) then
691: p_rec.gl_segment5 :=
692: psp_erd_shd.g_old_rec.gl_segment5;
693: End If;
694: If (p_rec.gl_segment6 = hr_api.g_varchar2) then
695: p_rec.gl_segment6 :=
696: psp_erd_shd.g_old_rec.gl_segment6;
697: End If;
698: If (p_rec.gl_segment7 = hr_api.g_varchar2) then
694: If (p_rec.gl_segment6 = hr_api.g_varchar2) then
695: p_rec.gl_segment6 :=
696: psp_erd_shd.g_old_rec.gl_segment6;
697: End If;
698: If (p_rec.gl_segment7 = hr_api.g_varchar2) then
699: p_rec.gl_segment7 :=
700: psp_erd_shd.g_old_rec.gl_segment7;
701: End If;
702: If (p_rec.gl_segment8 = hr_api.g_varchar2) then
698: If (p_rec.gl_segment7 = hr_api.g_varchar2) then
699: p_rec.gl_segment7 :=
700: psp_erd_shd.g_old_rec.gl_segment7;
701: End If;
702: If (p_rec.gl_segment8 = hr_api.g_varchar2) then
703: p_rec.gl_segment8 :=
704: psp_erd_shd.g_old_rec.gl_segment8;
705: End If;
706: If (p_rec.gl_segment9 = hr_api.g_varchar2) then
702: If (p_rec.gl_segment8 = hr_api.g_varchar2) then
703: p_rec.gl_segment8 :=
704: psp_erd_shd.g_old_rec.gl_segment8;
705: End If;
706: If (p_rec.gl_segment9 = hr_api.g_varchar2) then
707: p_rec.gl_segment9 :=
708: psp_erd_shd.g_old_rec.gl_segment9;
709: End If;
710: If (p_rec.gl_segment10 = hr_api.g_varchar2) then
706: If (p_rec.gl_segment9 = hr_api.g_varchar2) then
707: p_rec.gl_segment9 :=
708: psp_erd_shd.g_old_rec.gl_segment9;
709: End If;
710: If (p_rec.gl_segment10 = hr_api.g_varchar2) then
711: p_rec.gl_segment10 :=
712: psp_erd_shd.g_old_rec.gl_segment10;
713: End If;
714: If (p_rec.gl_segment11 = hr_api.g_varchar2) then
710: If (p_rec.gl_segment10 = hr_api.g_varchar2) then
711: p_rec.gl_segment10 :=
712: psp_erd_shd.g_old_rec.gl_segment10;
713: End If;
714: If (p_rec.gl_segment11 = hr_api.g_varchar2) then
715: p_rec.gl_segment11 :=
716: psp_erd_shd.g_old_rec.gl_segment11;
717: End If;
718: If (p_rec.gl_segment12 = hr_api.g_varchar2) then
714: If (p_rec.gl_segment11 = hr_api.g_varchar2) then
715: p_rec.gl_segment11 :=
716: psp_erd_shd.g_old_rec.gl_segment11;
717: End If;
718: If (p_rec.gl_segment12 = hr_api.g_varchar2) then
719: p_rec.gl_segment12 :=
720: psp_erd_shd.g_old_rec.gl_segment12;
721: End If;
722: If (p_rec.gl_segment13 = hr_api.g_varchar2) then
718: If (p_rec.gl_segment12 = hr_api.g_varchar2) then
719: p_rec.gl_segment12 :=
720: psp_erd_shd.g_old_rec.gl_segment12;
721: End If;
722: If (p_rec.gl_segment13 = hr_api.g_varchar2) then
723: p_rec.gl_segment13 :=
724: psp_erd_shd.g_old_rec.gl_segment13;
725: End If;
726: If (p_rec.gl_segment14 = hr_api.g_varchar2) then
722: If (p_rec.gl_segment13 = hr_api.g_varchar2) then
723: p_rec.gl_segment13 :=
724: psp_erd_shd.g_old_rec.gl_segment13;
725: End If;
726: If (p_rec.gl_segment14 = hr_api.g_varchar2) then
727: p_rec.gl_segment14 :=
728: psp_erd_shd.g_old_rec.gl_segment14;
729: End If;
730: If (p_rec.gl_segment15 = hr_api.g_varchar2) then
726: If (p_rec.gl_segment14 = hr_api.g_varchar2) then
727: p_rec.gl_segment14 :=
728: psp_erd_shd.g_old_rec.gl_segment14;
729: End If;
730: If (p_rec.gl_segment15 = hr_api.g_varchar2) then
731: p_rec.gl_segment15 :=
732: psp_erd_shd.g_old_rec.gl_segment15;
733: End If;
734: If (p_rec.gl_segment16 = hr_api.g_varchar2) then
730: If (p_rec.gl_segment15 = hr_api.g_varchar2) then
731: p_rec.gl_segment15 :=
732: psp_erd_shd.g_old_rec.gl_segment15;
733: End If;
734: If (p_rec.gl_segment16 = hr_api.g_varchar2) then
735: p_rec.gl_segment16 :=
736: psp_erd_shd.g_old_rec.gl_segment16;
737: End If;
738: If (p_rec.gl_segment17 = hr_api.g_varchar2) then
734: If (p_rec.gl_segment16 = hr_api.g_varchar2) then
735: p_rec.gl_segment16 :=
736: psp_erd_shd.g_old_rec.gl_segment16;
737: End If;
738: If (p_rec.gl_segment17 = hr_api.g_varchar2) then
739: p_rec.gl_segment17 :=
740: psp_erd_shd.g_old_rec.gl_segment17;
741: End If;
742: If (p_rec.gl_segment18 = hr_api.g_varchar2) then
738: If (p_rec.gl_segment17 = hr_api.g_varchar2) then
739: p_rec.gl_segment17 :=
740: psp_erd_shd.g_old_rec.gl_segment17;
741: End If;
742: If (p_rec.gl_segment18 = hr_api.g_varchar2) then
743: p_rec.gl_segment18 :=
744: psp_erd_shd.g_old_rec.gl_segment18;
745: End If;
746: If (p_rec.gl_segment19 = hr_api.g_varchar2) then
742: If (p_rec.gl_segment18 = hr_api.g_varchar2) then
743: p_rec.gl_segment18 :=
744: psp_erd_shd.g_old_rec.gl_segment18;
745: End If;
746: If (p_rec.gl_segment19 = hr_api.g_varchar2) then
747: p_rec.gl_segment19 :=
748: psp_erd_shd.g_old_rec.gl_segment19;
749: End If;
750: If (p_rec.gl_segment20 = hr_api.g_varchar2) then
746: If (p_rec.gl_segment19 = hr_api.g_varchar2) then
747: p_rec.gl_segment19 :=
748: psp_erd_shd.g_old_rec.gl_segment19;
749: End If;
750: If (p_rec.gl_segment20 = hr_api.g_varchar2) then
751: p_rec.gl_segment20 :=
752: psp_erd_shd.g_old_rec.gl_segment20;
753: End If;
754: If (p_rec.gl_segment21 = hr_api.g_varchar2) then
750: If (p_rec.gl_segment20 = hr_api.g_varchar2) then
751: p_rec.gl_segment20 :=
752: psp_erd_shd.g_old_rec.gl_segment20;
753: End If;
754: If (p_rec.gl_segment21 = hr_api.g_varchar2) then
755: p_rec.gl_segment21 :=
756: psp_erd_shd.g_old_rec.gl_segment21;
757: End If;
758: If (p_rec.gl_segment22 = hr_api.g_varchar2) then
754: If (p_rec.gl_segment21 = hr_api.g_varchar2) then
755: p_rec.gl_segment21 :=
756: psp_erd_shd.g_old_rec.gl_segment21;
757: End If;
758: If (p_rec.gl_segment22 = hr_api.g_varchar2) then
759: p_rec.gl_segment22 :=
760: psp_erd_shd.g_old_rec.gl_segment22;
761: End If;
762: If (p_rec.gl_segment23 = hr_api.g_varchar2) then
758: If (p_rec.gl_segment22 = hr_api.g_varchar2) then
759: p_rec.gl_segment22 :=
760: psp_erd_shd.g_old_rec.gl_segment22;
761: End If;
762: If (p_rec.gl_segment23 = hr_api.g_varchar2) then
763: p_rec.gl_segment23 :=
764: psp_erd_shd.g_old_rec.gl_segment23;
765: End If;
766: If (p_rec.gl_segment24 = hr_api.g_varchar2) then
762: If (p_rec.gl_segment23 = hr_api.g_varchar2) then
763: p_rec.gl_segment23 :=
764: psp_erd_shd.g_old_rec.gl_segment23;
765: End If;
766: If (p_rec.gl_segment24 = hr_api.g_varchar2) then
767: p_rec.gl_segment24 :=
768: psp_erd_shd.g_old_rec.gl_segment24;
769: End If;
770: If (p_rec.gl_segment25 = hr_api.g_varchar2) then
766: If (p_rec.gl_segment24 = hr_api.g_varchar2) then
767: p_rec.gl_segment24 :=
768: psp_erd_shd.g_old_rec.gl_segment24;
769: End If;
770: If (p_rec.gl_segment25 = hr_api.g_varchar2) then
771: p_rec.gl_segment25 :=
772: psp_erd_shd.g_old_rec.gl_segment25;
773: End If;
774: If (p_rec.gl_segment26 = hr_api.g_varchar2) then
770: If (p_rec.gl_segment25 = hr_api.g_varchar2) then
771: p_rec.gl_segment25 :=
772: psp_erd_shd.g_old_rec.gl_segment25;
773: End If;
774: If (p_rec.gl_segment26 = hr_api.g_varchar2) then
775: p_rec.gl_segment26 :=
776: psp_erd_shd.g_old_rec.gl_segment26;
777: End If;
778: If (p_rec.gl_segment27 = hr_api.g_varchar2) then
774: If (p_rec.gl_segment26 = hr_api.g_varchar2) then
775: p_rec.gl_segment26 :=
776: psp_erd_shd.g_old_rec.gl_segment26;
777: End If;
778: If (p_rec.gl_segment27 = hr_api.g_varchar2) then
779: p_rec.gl_segment27 :=
780: psp_erd_shd.g_old_rec.gl_segment27;
781: End If;
782: If (p_rec.gl_segment28 = hr_api.g_varchar2) then
778: If (p_rec.gl_segment27 = hr_api.g_varchar2) then
779: p_rec.gl_segment27 :=
780: psp_erd_shd.g_old_rec.gl_segment27;
781: End If;
782: If (p_rec.gl_segment28 = hr_api.g_varchar2) then
783: p_rec.gl_segment28 :=
784: psp_erd_shd.g_old_rec.gl_segment28;
785: End If;
786: If (p_rec.gl_segment29 = hr_api.g_varchar2) then
782: If (p_rec.gl_segment28 = hr_api.g_varchar2) then
783: p_rec.gl_segment28 :=
784: psp_erd_shd.g_old_rec.gl_segment28;
785: End If;
786: If (p_rec.gl_segment29 = hr_api.g_varchar2) then
787: p_rec.gl_segment29 :=
788: psp_erd_shd.g_old_rec.gl_segment29;
789: End If;
790: If (p_rec.gl_segment30 = hr_api.g_varchar2) then
786: If (p_rec.gl_segment29 = hr_api.g_varchar2) then
787: p_rec.gl_segment29 :=
788: psp_erd_shd.g_old_rec.gl_segment29;
789: End If;
790: If (p_rec.gl_segment30 = hr_api.g_varchar2) then
791: p_rec.gl_segment30 :=
792: psp_erd_shd.g_old_rec.gl_segment30;
793: End If;
794: If (p_rec.project_id = hr_api.g_number) then
790: If (p_rec.gl_segment30 = hr_api.g_varchar2) then
791: p_rec.gl_segment30 :=
792: psp_erd_shd.g_old_rec.gl_segment30;
793: End If;
794: If (p_rec.project_id = hr_api.g_number) then
795: p_rec.project_id :=
796: psp_erd_shd.g_old_rec.project_id;
797: End If;
798: If (p_rec.project_number = hr_api.g_varchar2) then
794: If (p_rec.project_id = hr_api.g_number) then
795: p_rec.project_id :=
796: psp_erd_shd.g_old_rec.project_id;
797: End If;
798: If (p_rec.project_number = hr_api.g_varchar2) then
799: p_rec.project_number :=
800: psp_erd_shd.g_old_rec.project_number;
801: End If;
802: If (p_rec.project_name = hr_api.g_varchar2) then
798: If (p_rec.project_number = hr_api.g_varchar2) then
799: p_rec.project_number :=
800: psp_erd_shd.g_old_rec.project_number;
801: End If;
802: If (p_rec.project_name = hr_api.g_varchar2) then
803: p_rec.project_name :=
804: psp_erd_shd.g_old_rec.project_name;
805: End If;
806: If (p_rec.expenditure_organization_id = hr_api.g_number) then
802: If (p_rec.project_name = hr_api.g_varchar2) then
803: p_rec.project_name :=
804: psp_erd_shd.g_old_rec.project_name;
805: End If;
806: If (p_rec.expenditure_organization_id = hr_api.g_number) then
807: p_rec.expenditure_organization_id :=
808: psp_erd_shd.g_old_rec.expenditure_organization_id;
809: End If;
810: If (p_rec.exp_org_name = hr_api.g_varchar2) then
806: If (p_rec.expenditure_organization_id = hr_api.g_number) then
807: p_rec.expenditure_organization_id :=
808: psp_erd_shd.g_old_rec.expenditure_organization_id;
809: End If;
810: If (p_rec.exp_org_name = hr_api.g_varchar2) then
811: p_rec.exp_org_name :=
812: psp_erd_shd.g_old_rec.exp_org_name;
813: End If;
814: If (p_rec.expenditure_type = hr_api.g_varchar2) then
810: If (p_rec.exp_org_name = hr_api.g_varchar2) then
811: p_rec.exp_org_name :=
812: psp_erd_shd.g_old_rec.exp_org_name;
813: End If;
814: If (p_rec.expenditure_type = hr_api.g_varchar2) then
815: p_rec.expenditure_type :=
816: psp_erd_shd.g_old_rec.expenditure_type;
817: End If;
818: If (p_rec.task_id = hr_api.g_number) then
814: If (p_rec.expenditure_type = hr_api.g_varchar2) then
815: p_rec.expenditure_type :=
816: psp_erd_shd.g_old_rec.expenditure_type;
817: End If;
818: If (p_rec.task_id = hr_api.g_number) then
819: p_rec.task_id :=
820: psp_erd_shd.g_old_rec.task_id;
821: End If;
822: If (p_rec.task_number = hr_api.g_varchar2) then
818: If (p_rec.task_id = hr_api.g_number) then
819: p_rec.task_id :=
820: psp_erd_shd.g_old_rec.task_id;
821: End If;
822: If (p_rec.task_number = hr_api.g_varchar2) then
823: p_rec.task_number :=
824: psp_erd_shd.g_old_rec.task_number;
825: End If;
826: If (p_rec.task_name = hr_api.g_varchar2) then
822: If (p_rec.task_number = hr_api.g_varchar2) then
823: p_rec.task_number :=
824: psp_erd_shd.g_old_rec.task_number;
825: End If;
826: If (p_rec.task_name = hr_api.g_varchar2) then
827: p_rec.task_name :=
828: psp_erd_shd.g_old_rec.task_name;
829: End If;
830: If (p_rec.award_id = hr_api.g_number) then
826: If (p_rec.task_name = hr_api.g_varchar2) then
827: p_rec.task_name :=
828: psp_erd_shd.g_old_rec.task_name;
829: End If;
830: If (p_rec.award_id = hr_api.g_number) then
831: p_rec.award_id :=
832: psp_erd_shd.g_old_rec.award_id;
833: End If;
834: If (p_rec.award_number = hr_api.g_varchar2) then
830: If (p_rec.award_id = hr_api.g_number) then
831: p_rec.award_id :=
832: psp_erd_shd.g_old_rec.award_id;
833: End If;
834: If (p_rec.award_number = hr_api.g_varchar2) then
835: p_rec.award_number :=
836: psp_erd_shd.g_old_rec.award_number;
837: End If;
838: If (p_rec.award_short_name = hr_api.g_varchar2) then
834: If (p_rec.award_number = hr_api.g_varchar2) then
835: p_rec.award_number :=
836: psp_erd_shd.g_old_rec.award_number;
837: End If;
838: If (p_rec.award_short_name = hr_api.g_varchar2) then
839: p_rec.award_short_name :=
840: psp_erd_shd.g_old_rec.award_short_name;
841: End If;
842: If (p_rec.actual_salary_amt = hr_api.g_number) then
838: If (p_rec.award_short_name = hr_api.g_varchar2) then
839: p_rec.award_short_name :=
840: psp_erd_shd.g_old_rec.award_short_name;
841: End If;
842: If (p_rec.actual_salary_amt = hr_api.g_number) then
843: p_rec.actual_salary_amt :=
844: psp_erd_shd.g_old_rec.actual_salary_amt;
845: End If;
846: If (p_rec.payroll_percent = hr_api.g_number) then
842: If (p_rec.actual_salary_amt = hr_api.g_number) then
843: p_rec.actual_salary_amt :=
844: psp_erd_shd.g_old_rec.actual_salary_amt;
845: End If;
846: If (p_rec.payroll_percent = hr_api.g_number) then
847: p_rec.payroll_percent :=
848: psp_erd_shd.g_old_rec.payroll_percent;
849: End If;
850: If (p_rec.proposed_salary_amt = hr_api.g_number) then
846: If (p_rec.payroll_percent = hr_api.g_number) then
847: p_rec.payroll_percent :=
848: psp_erd_shd.g_old_rec.payroll_percent;
849: End If;
850: If (p_rec.proposed_salary_amt = hr_api.g_number) then
851: p_rec.proposed_salary_amt :=
852: psp_erd_shd.g_old_rec.proposed_salary_amt;
853: End If;
854: If (p_rec.proposed_effort_percent = hr_api.g_number) then
850: If (p_rec.proposed_salary_amt = hr_api.g_number) then
851: p_rec.proposed_salary_amt :=
852: psp_erd_shd.g_old_rec.proposed_salary_amt;
853: End If;
854: If (p_rec.proposed_effort_percent = hr_api.g_number) then
855: p_rec.proposed_effort_percent :=
856: psp_erd_shd.g_old_rec.proposed_effort_percent;
857: End If;
858: If (p_rec.committed_cost_share = hr_api.g_number) then
854: If (p_rec.proposed_effort_percent = hr_api.g_number) then
855: p_rec.proposed_effort_percent :=
856: psp_erd_shd.g_old_rec.proposed_effort_percent;
857: End If;
858: If (p_rec.committed_cost_share = hr_api.g_number) then
859: p_rec.committed_cost_share :=
860: psp_erd_shd.g_old_rec.committed_cost_share;
861: End If;
862: If (p_rec.schedule_start_date = hr_api.g_date) then
858: If (p_rec.committed_cost_share = hr_api.g_number) then
859: p_rec.committed_cost_share :=
860: psp_erd_shd.g_old_rec.committed_cost_share;
861: End If;
862: If (p_rec.schedule_start_date = hr_api.g_date) then
863: p_rec.schedule_start_date :=
864: psp_erd_shd.g_old_rec.schedule_start_date;
865: End If;
866: If (p_rec.schedule_end_date = hr_api.g_date) then
862: If (p_rec.schedule_start_date = hr_api.g_date) then
863: p_rec.schedule_start_date :=
864: psp_erd_shd.g_old_rec.schedule_start_date;
865: End If;
866: If (p_rec.schedule_end_date = hr_api.g_date) then
867: p_rec.schedule_end_date :=
868: psp_erd_shd.g_old_rec.schedule_end_date;
869: End If;
870: If (p_rec.ame_transaction_id = hr_api.g_varchar2) then
866: If (p_rec.schedule_end_date = hr_api.g_date) then
867: p_rec.schedule_end_date :=
868: psp_erd_shd.g_old_rec.schedule_end_date;
869: End If;
870: If (p_rec.ame_transaction_id = hr_api.g_varchar2) then
871: p_rec.ame_transaction_id :=
872: psp_erd_shd.g_old_rec.ame_transaction_id;
873: End If;
874: If (p_rec.investigator_name = hr_api.g_varchar2) then
870: If (p_rec.ame_transaction_id = hr_api.g_varchar2) then
871: p_rec.ame_transaction_id :=
872: psp_erd_shd.g_old_rec.ame_transaction_id;
873: End If;
874: If (p_rec.investigator_name = hr_api.g_varchar2) then
875: p_rec.investigator_name :=
876: psp_erd_shd.g_old_rec.investigator_name;
877: End If;
878: If (p_rec.investigator_person_id = hr_api.g_number) then
874: If (p_rec.investigator_name = hr_api.g_varchar2) then
875: p_rec.investigator_name :=
876: psp_erd_shd.g_old_rec.investigator_name;
877: End If;
878: If (p_rec.investigator_person_id = hr_api.g_number) then
879: p_rec.investigator_person_id :=
880: psp_erd_shd.g_old_rec.investigator_person_id;
881: End If;
882: If (p_rec.investigator_org_name = hr_api.g_varchar2) then
878: If (p_rec.investigator_person_id = hr_api.g_number) then
879: p_rec.investigator_person_id :=
880: psp_erd_shd.g_old_rec.investigator_person_id;
881: End If;
882: If (p_rec.investigator_org_name = hr_api.g_varchar2) then
883: p_rec.investigator_org_name :=
884: psp_erd_shd.g_old_rec.investigator_org_name;
885: End If;
886: If (p_rec.investigator_primary_org_id = hr_api.g_number) then
882: If (p_rec.investigator_org_name = hr_api.g_varchar2) then
883: p_rec.investigator_org_name :=
884: psp_erd_shd.g_old_rec.investigator_org_name;
885: End If;
886: If (p_rec.investigator_primary_org_id = hr_api.g_number) then
887: p_rec.investigator_primary_org_id :=
888: psp_erd_shd.g_old_rec.investigator_primary_org_id;
889: End If;
890: If (p_rec.value1 = hr_api.g_number) then
886: If (p_rec.investigator_primary_org_id = hr_api.g_number) then
887: p_rec.investigator_primary_org_id :=
888: psp_erd_shd.g_old_rec.investigator_primary_org_id;
889: End If;
890: If (p_rec.value1 = hr_api.g_number) then
891: p_rec.value1 :=
892: psp_erd_shd.g_old_rec.value1;
893: End If;
894: If (p_rec.value2 = hr_api.g_number) then
890: If (p_rec.value1 = hr_api.g_number) then
891: p_rec.value1 :=
892: psp_erd_shd.g_old_rec.value1;
893: End If;
894: If (p_rec.value2 = hr_api.g_number) then
895: p_rec.value2 :=
896: psp_erd_shd.g_old_rec.value2;
897: End If;
898: If (p_rec.value3 = hr_api.g_number) then
894: If (p_rec.value2 = hr_api.g_number) then
895: p_rec.value2 :=
896: psp_erd_shd.g_old_rec.value2;
897: End If;
898: If (p_rec.value3 = hr_api.g_number) then
899: p_rec.value3 :=
900: psp_erd_shd.g_old_rec.value3;
901: End If;
902: If (p_rec.value4 = hr_api.g_number) then
898: If (p_rec.value3 = hr_api.g_number) then
899: p_rec.value3 :=
900: psp_erd_shd.g_old_rec.value3;
901: End If;
902: If (p_rec.value4 = hr_api.g_number) then
903: p_rec.value4 :=
904: psp_erd_shd.g_old_rec.value4;
905: End If;
906: If (p_rec.value5 = hr_api.g_number) then
902: If (p_rec.value4 = hr_api.g_number) then
903: p_rec.value4 :=
904: psp_erd_shd.g_old_rec.value4;
905: End If;
906: If (p_rec.value5 = hr_api.g_number) then
907: p_rec.value5 :=
908: psp_erd_shd.g_old_rec.value5;
909: End If;
910: If (p_rec.value6 = hr_api.g_number) then
906: If (p_rec.value5 = hr_api.g_number) then
907: p_rec.value5 :=
908: psp_erd_shd.g_old_rec.value5;
909: End If;
910: If (p_rec.value6 = hr_api.g_number) then
911: p_rec.value6 :=
912: psp_erd_shd.g_old_rec.value6;
913: End If;
914: If (p_rec.value7 = hr_api.g_number) then
910: If (p_rec.value6 = hr_api.g_number) then
911: p_rec.value6 :=
912: psp_erd_shd.g_old_rec.value6;
913: End If;
914: If (p_rec.value7 = hr_api.g_number) then
915: p_rec.value7 :=
916: psp_erd_shd.g_old_rec.value7;
917: End If;
918: If (p_rec.value8 = hr_api.g_number) then
914: If (p_rec.value7 = hr_api.g_number) then
915: p_rec.value7 :=
916: psp_erd_shd.g_old_rec.value7;
917: End If;
918: If (p_rec.value8 = hr_api.g_number) then
919: p_rec.value8 :=
920: psp_erd_shd.g_old_rec.value8;
921: End If;
922: If (p_rec.value9 = hr_api.g_number) then
918: If (p_rec.value8 = hr_api.g_number) then
919: p_rec.value8 :=
920: psp_erd_shd.g_old_rec.value8;
921: End If;
922: If (p_rec.value9 = hr_api.g_number) then
923: p_rec.value9 :=
924: psp_erd_shd.g_old_rec.value9;
925: End If;
926: If (p_rec.value10 = hr_api.g_number) then
922: If (p_rec.value9 = hr_api.g_number) then
923: p_rec.value9 :=
924: psp_erd_shd.g_old_rec.value9;
925: End If;
926: If (p_rec.value10 = hr_api.g_number) then
927: p_rec.value10 :=
928: psp_erd_shd.g_old_rec.value10;
929: End If;
930: If (p_rec.attribute1 = hr_api.g_varchar2) then
926: If (p_rec.value10 = hr_api.g_number) then
927: p_rec.value10 :=
928: psp_erd_shd.g_old_rec.value10;
929: End If;
930: If (p_rec.attribute1 = hr_api.g_varchar2) then
931: p_rec.attribute1 :=
932: psp_erd_shd.g_old_rec.attribute1;
933: End If;
934: If (p_rec.attribute2 = hr_api.g_varchar2) then
930: If (p_rec.attribute1 = hr_api.g_varchar2) then
931: p_rec.attribute1 :=
932: psp_erd_shd.g_old_rec.attribute1;
933: End If;
934: If (p_rec.attribute2 = hr_api.g_varchar2) then
935: p_rec.attribute2 :=
936: psp_erd_shd.g_old_rec.attribute2;
937: End If;
938: If (p_rec.attribute3 = hr_api.g_varchar2) then
934: If (p_rec.attribute2 = hr_api.g_varchar2) then
935: p_rec.attribute2 :=
936: psp_erd_shd.g_old_rec.attribute2;
937: End If;
938: If (p_rec.attribute3 = hr_api.g_varchar2) then
939: p_rec.attribute3 :=
940: psp_erd_shd.g_old_rec.attribute3;
941: End If;
942: If (p_rec.attribute4 = hr_api.g_varchar2) then
938: If (p_rec.attribute3 = hr_api.g_varchar2) then
939: p_rec.attribute3 :=
940: psp_erd_shd.g_old_rec.attribute3;
941: End If;
942: If (p_rec.attribute4 = hr_api.g_varchar2) then
943: p_rec.attribute4 :=
944: psp_erd_shd.g_old_rec.attribute4;
945: End If;
946: If (p_rec.attribute5 = hr_api.g_varchar2) then
942: If (p_rec.attribute4 = hr_api.g_varchar2) then
943: p_rec.attribute4 :=
944: psp_erd_shd.g_old_rec.attribute4;
945: End If;
946: If (p_rec.attribute5 = hr_api.g_varchar2) then
947: p_rec.attribute5 :=
948: psp_erd_shd.g_old_rec.attribute5;
949: End If;
950: If (p_rec.attribute6 = hr_api.g_varchar2) then
946: If (p_rec.attribute5 = hr_api.g_varchar2) then
947: p_rec.attribute5 :=
948: psp_erd_shd.g_old_rec.attribute5;
949: End If;
950: If (p_rec.attribute6 = hr_api.g_varchar2) then
951: p_rec.attribute6 :=
952: psp_erd_shd.g_old_rec.attribute6;
953: End If;
954: If (p_rec.attribute7 = hr_api.g_varchar2) then
950: If (p_rec.attribute6 = hr_api.g_varchar2) then
951: p_rec.attribute6 :=
952: psp_erd_shd.g_old_rec.attribute6;
953: End If;
954: If (p_rec.attribute7 = hr_api.g_varchar2) then
955: p_rec.attribute7 :=
956: psp_erd_shd.g_old_rec.attribute7;
957: End If;
958: If (p_rec.attribute8 = hr_api.g_varchar2) then
954: If (p_rec.attribute7 = hr_api.g_varchar2) then
955: p_rec.attribute7 :=
956: psp_erd_shd.g_old_rec.attribute7;
957: End If;
958: If (p_rec.attribute8 = hr_api.g_varchar2) then
959: p_rec.attribute8 :=
960: psp_erd_shd.g_old_rec.attribute8;
961: End If;
962: If (p_rec.attribute9 = hr_api.g_varchar2) then
958: If (p_rec.attribute8 = hr_api.g_varchar2) then
959: p_rec.attribute8 :=
960: psp_erd_shd.g_old_rec.attribute8;
961: End If;
962: If (p_rec.attribute9 = hr_api.g_varchar2) then
963: p_rec.attribute9 :=
964: psp_erd_shd.g_old_rec.attribute9;
965: End If;
966: If (p_rec.attribute10 = hr_api.g_varchar2) then
962: If (p_rec.attribute9 = hr_api.g_varchar2) then
963: p_rec.attribute9 :=
964: psp_erd_shd.g_old_rec.attribute9;
965: End If;
966: If (p_rec.attribute10 = hr_api.g_varchar2) then
967: p_rec.attribute10 :=
968: psp_erd_shd.g_old_rec.attribute10;
969: End If;
970: If (p_rec.grouping_category = hr_api.g_varchar2) then
966: If (p_rec.attribute10 = hr_api.g_varchar2) then
967: p_rec.attribute10 :=
968: psp_erd_shd.g_old_rec.attribute10;
969: End If;
970: If (p_rec.grouping_category = hr_api.g_varchar2) then
971: p_rec.grouping_category :=
972: psp_erd_shd.g_old_rec.grouping_category;
973: End If;
974: --
1030: -- ----------------------------------------------------------------------------
1031: Procedure upd
1032: (p_effort_report_detail_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_effort_report_id in number default hr_api.g_number
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1031: Procedure upd
1032: (p_effort_report_detail_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_effort_report_id in number default hr_api.g_number
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1032: (p_effort_report_detail_id in number
1033: ,p_object_version_number in out nocopy number
1034: ,p_effort_report_id in number default hr_api.g_number
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1033: ,p_object_version_number in out nocopy number
1034: ,p_effort_report_id in number default hr_api.g_number
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1034: ,p_effort_report_id in number default hr_api.g_number
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1035: ,p_actual_salary_amt in number default hr_api.g_number
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1036: ,p_payroll_percent in number default hr_api.g_number
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1037: ,p_assignment_id in number default hr_api.g_number
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1038: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1039: ,p_gl_sum_criteria_segment_name in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1040: ,p_gl_segment1 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1042: ,p_gl_segment3 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1043: ,p_gl_segment4 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1044: ,p_gl_segment5 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1045: ,p_gl_segment6 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1046: ,p_gl_segment7 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1047: ,p_gl_segment8 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1048: ,p_gl_segment9 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1049: ,p_gl_segment10 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1050: ,p_gl_segment11 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1051: ,p_gl_segment12 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1052: ,p_gl_segment13 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1053: ,p_gl_segment14 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1054: ,p_gl_segment15 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1055: ,p_gl_segment16 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1056: ,p_gl_segment17 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1057: ,p_gl_segment18 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1058: ,p_gl_segment19 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1059: ,p_gl_segment20 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1060: ,p_gl_segment21 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1061: ,p_gl_segment22 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1062: ,p_gl_segment23 in varchar2 default hr_api.g_varchar2
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1063: ,p_gl_segment24 in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1064: ,p_gl_segment25 in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1065: ,p_gl_segment26 in varchar2 default hr_api.g_varchar2
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1066: ,p_gl_segment27 in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1067: ,p_gl_segment28 in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1068: ,p_gl_segment29 in varchar2 default hr_api.g_varchar2
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1069: ,p_gl_segment30 in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1070: ,p_project_id in number default hr_api.g_number
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1071: ,p_project_number in varchar2 default hr_api.g_varchar2
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1072: ,p_project_name in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1073: ,p_expenditure_organization_id in number default hr_api.g_number
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1074: ,p_exp_org_name in varchar2 default hr_api.g_varchar2
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1075: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1076: ,p_task_id in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1077: ,p_task_number in varchar2 default hr_api.g_varchar2
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1078: ,p_task_name in varchar2 default hr_api.g_varchar2
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1079: ,p_award_id in number default hr_api.g_number
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1080: ,p_award_number in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1082: ,p_proposed_salary_amt in number default hr_api.g_number
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1083: ,p_proposed_effort_percent in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1084: ,p_committed_cost_share in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1085: ,p_schedule_start_date in date default hr_api.g_date
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1086: ,p_schedule_end_date in date default hr_api.g_date
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1087: ,p_ame_transaction_id in varchar2 default hr_api.g_varchar2
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1089: ,p_investigator_person_id in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1091: ,p_investigator_primary_org_id in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1092: ,p_value1 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1093: ,p_value2 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1094: ,p_value3 in number default hr_api.g_number
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1095: ,p_value4 in number default hr_api.g_number
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1096: ,p_value5 in number default hr_api.g_number
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1097: ,p_value6 in number default hr_api.g_number
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1098: ,p_value7 in number default hr_api.g_number
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1099: ,p_value8 in number default hr_api.g_number
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1100: ,p_value9 in number default hr_api.g_number
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1101: ,p_value10 in number default hr_api.g_number
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1102: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1113: ) is
1106: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1113: ) is
1114: --
1107: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1113: ) is
1114: --
1115: l_rec psp_erd_shd.g_rec_type;
1108: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1109: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1110: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1111: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1112: ,p_grouping_category in varchar2 default hr_api.g_varchar2
1113: ) is
1114: --
1115: l_rec psp_erd_shd.g_rec_type;
1116: l_proc varchar2(72) := g_package||'upd';