DBA Data[Home] [Help]

APPS.PSP_ERD_UPD dependencies on HR_API

Line 160: When hr_api.check_integrity_violated Then

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

Line 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

Line 165: When hr_api.parent_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
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 170: When hr_api.unique_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
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

Line 593: when hr_api.cannot_find_prog_unit then

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

Line 595: hr_api.cannot_find_prog_unit_error

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;

Line 658: If (p_rec.effort_report_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 1034: ,p_effort_report_id in number default hr_api.g_number

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

Line 1035: ,p_actual_salary_amt in number default hr_api.g_number

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

Line 1036: ,p_payroll_percent in number default hr_api.g_number

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

Line 1037: ,p_assignment_id in number default hr_api.g_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
1041: ,p_gl_segment2 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_assignment_number 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

Line 1039: ,p_gl_sum_criteria_segment_name 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

Line 1040: ,p_gl_segment1 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

Line 1041: ,p_gl_segment2 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

Line 1042: ,p_gl_segment3 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

Line 1043: ,p_gl_segment4 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

Line 1044: ,p_gl_segment5 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

Line 1045: ,p_gl_segment6 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

Line 1046: ,p_gl_segment7 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

Line 1047: ,p_gl_segment8 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

Line 1048: ,p_gl_segment9 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

Line 1049: ,p_gl_segment10 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

Line 1050: ,p_gl_segment11 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

Line 1051: ,p_gl_segment12 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

Line 1052: ,p_gl_segment13 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

Line 1053: ,p_gl_segment14 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

Line 1054: ,p_gl_segment15 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

Line 1055: ,p_gl_segment16 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

Line 1056: ,p_gl_segment17 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

Line 1057: ,p_gl_segment18 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

Line 1058: ,p_gl_segment19 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

Line 1059: ,p_gl_segment20 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

Line 1060: ,p_gl_segment21 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

Line 1061: ,p_gl_segment22 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

Line 1062: ,p_gl_segment23 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

Line 1063: ,p_gl_segment24 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

Line 1064: ,p_gl_segment25 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

Line 1065: ,p_gl_segment26 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

Line 1066: ,p_gl_segment27 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

Line 1067: ,p_gl_segment28 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
1071: ,p_project_number in varchar2 default hr_api.g_varchar2

Line 1068: ,p_gl_segment29 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

Line 1069: ,p_gl_segment30 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

Line 1070: ,p_project_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

Line 1071: ,p_project_number 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

Line 1072: ,p_project_name 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

Line 1073: ,p_expenditure_organization_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

Line 1074: ,p_exp_org_name 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

Line 1075: ,p_expenditure_type 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

Line 1076: ,p_task_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

Line 1077: ,p_task_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

Line 1078: ,p_task_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

Line 1079: ,p_award_id 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

Line 1080: ,p_award_number 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
1084: ,p_committed_cost_share in number default hr_api.g_number

Line 1081: ,p_award_short_name in varchar2 default hr_api.g_varchar2

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

Line 1082: ,p_proposed_salary_amt in number default hr_api.g_number

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

Line 1083: ,p_proposed_effort_percent in number default hr_api.g_number

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

Line 1084: ,p_committed_cost_share 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
1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2

Line 1085: ,p_schedule_start_date in date default hr_api.g_date

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

Line 1086: ,p_schedule_end_date in date default hr_api.g_date

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

Line 1087: ,p_ame_transaction_id 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

Line 1088: ,p_investigator_name in varchar2 default hr_api.g_varchar2

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

Line 1089: ,p_investigator_person_id 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

Line 1090: ,p_investigator_org_name in varchar2 default hr_api.g_varchar2

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

Line 1091: ,p_investigator_primary_org_id 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

Line 1092: ,p_value1 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

Line 1093: ,p_value2 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

Line 1094: ,p_value3 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

Line 1095: ,p_value4 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

Line 1096: ,p_value5 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

Line 1097: ,p_value6 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

Line 1098: ,p_value7 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

Line 1099: ,p_value8 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
1103: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1100: ,p_value9 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
1104: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1101: ,p_value10 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
1105: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1102: ,p_attribute1 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

Line 1103: ,p_attribute2 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

Line 1104: ,p_attribute3 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

Line 1105: ,p_attribute4 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

Line 1106: ,p_attribute5 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

Line 1107: ,p_attribute6 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

Line 1108: ,p_attribute7 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

Line 1109: ,p_attribute8 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

Line 1110: ,p_attribute9 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
1114: --

Line 1111: ,p_attribute10 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: --
1115: l_rec psp_erd_shd.g_rec_type;

Line 1112: ,p_grouping_category 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;
1116: l_proc varchar2(72) := g_package||'upd';