127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: psp_era_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: psp_era_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: psp_era_shd.constraint_error
132: -- A check constraint has been violated
133: --
134: psp_era_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: psp_era_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: psp_era_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: psp_era_shd.constraint_error
137: -- Parent integrity has been violated
138: --
139: psp_era_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: psp_era_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: psp_era_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;
149: End update_dml;
444: );
445: --
446: exception
447: --
448: when hr_api.cannot_find_prog_unit then
449: --
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'PSP_EFF_REPORT_APPROVALS'
452: ,p_hook_type => 'AU');
446: exception
447: --
448: when hr_api.cannot_find_prog_unit then
449: --
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'PSP_EFF_REPORT_APPROVALS'
452: ,p_hook_type => 'AU');
453: --
454: end;
509: -- p_rec plsql record structure
510: -- to see if a system default is being used. If a system default
511: -- is being used then we must set to the 'current' argument value.
512: --
513: If (p_rec.effort_report_detail_id = hr_api.g_number) then
514: p_rec.effort_report_detail_id :=
515: psp_era_shd.g_old_rec.effort_report_detail_id;
516: End If;
517: If (p_rec.wf_role_name = hr_api.g_varchar2) then
513: If (p_rec.effort_report_detail_id = hr_api.g_number) then
514: p_rec.effort_report_detail_id :=
515: psp_era_shd.g_old_rec.effort_report_detail_id;
516: End If;
517: If (p_rec.wf_role_name = hr_api.g_varchar2) then
518: p_rec.wf_role_name :=
519: psp_era_shd.g_old_rec.wf_role_name;
520: End If;
521: If (p_rec.wf_orig_system_id = hr_api.g_number) then
517: If (p_rec.wf_role_name = hr_api.g_varchar2) then
518: p_rec.wf_role_name :=
519: psp_era_shd.g_old_rec.wf_role_name;
520: End If;
521: If (p_rec.wf_orig_system_id = hr_api.g_number) then
522: p_rec.wf_orig_system_id :=
523: psp_era_shd.g_old_rec.wf_orig_system_id;
524: End If;
525: If (p_rec.wf_orig_system = hr_api.g_varchar2) then
521: If (p_rec.wf_orig_system_id = hr_api.g_number) then
522: p_rec.wf_orig_system_id :=
523: psp_era_shd.g_old_rec.wf_orig_system_id;
524: End If;
525: If (p_rec.wf_orig_system = hr_api.g_varchar2) then
526: p_rec.wf_orig_system :=
527: psp_era_shd.g_old_rec.wf_orig_system;
528: End If;
529: If (p_rec.approver_order_num = hr_api.g_number) then
525: If (p_rec.wf_orig_system = hr_api.g_varchar2) then
526: p_rec.wf_orig_system :=
527: psp_era_shd.g_old_rec.wf_orig_system;
528: End If;
529: If (p_rec.approver_order_num = hr_api.g_number) then
530: p_rec.approver_order_num :=
531: psp_era_shd.g_old_rec.approver_order_num;
532: End If;
533: If (p_rec.approval_status = hr_api.g_varchar2) then
529: If (p_rec.approver_order_num = hr_api.g_number) then
530: p_rec.approver_order_num :=
531: psp_era_shd.g_old_rec.approver_order_num;
532: End If;
533: If (p_rec.approval_status = hr_api.g_varchar2) then
534: p_rec.approval_status :=
535: psp_era_shd.g_old_rec.approval_status;
536: End If;
537: If (p_rec.response_date = hr_api.g_date) then
533: If (p_rec.approval_status = hr_api.g_varchar2) then
534: p_rec.approval_status :=
535: psp_era_shd.g_old_rec.approval_status;
536: End If;
537: If (p_rec.response_date = hr_api.g_date) then
538: p_rec.response_date :=
539: psp_era_shd.g_old_rec.response_date;
540: End If;
541: If (p_rec.actual_cost_share = hr_api.g_number) then
537: If (p_rec.response_date = hr_api.g_date) then
538: p_rec.response_date :=
539: psp_era_shd.g_old_rec.response_date;
540: End If;
541: If (p_rec.actual_cost_share = hr_api.g_number) then
542: p_rec.actual_cost_share :=
543: psp_era_shd.g_old_rec.actual_cost_share;
544: End If;
545: If (p_rec.overwritten_effort_percent = hr_api.g_number) then
541: If (p_rec.actual_cost_share = hr_api.g_number) then
542: p_rec.actual_cost_share :=
543: psp_era_shd.g_old_rec.actual_cost_share;
544: End If;
545: If (p_rec.overwritten_effort_percent = hr_api.g_number) then
546: p_rec.overwritten_effort_percent :=
547: psp_era_shd.g_old_rec.overwritten_effort_percent;
548: End If;
549: If (p_rec.wf_item_key = hr_api.g_varchar2) then
545: If (p_rec.overwritten_effort_percent = hr_api.g_number) then
546: p_rec.overwritten_effort_percent :=
547: psp_era_shd.g_old_rec.overwritten_effort_percent;
548: End If;
549: If (p_rec.wf_item_key = hr_api.g_varchar2) then
550: p_rec.wf_item_key :=
551: psp_era_shd.g_old_rec.wf_item_key;
552: End If;
553: If (p_rec.comments = hr_api.g_varchar2) then
549: If (p_rec.wf_item_key = hr_api.g_varchar2) then
550: p_rec.wf_item_key :=
551: psp_era_shd.g_old_rec.wf_item_key;
552: End If;
553: If (p_rec.comments = hr_api.g_varchar2) then
554: p_rec.comments :=
555: psp_era_shd.g_old_rec.comments;
556: End If;
557: If (p_rec.pera_information_category = hr_api.g_varchar2) then
553: If (p_rec.comments = hr_api.g_varchar2) then
554: p_rec.comments :=
555: psp_era_shd.g_old_rec.comments;
556: End If;
557: If (p_rec.pera_information_category = hr_api.g_varchar2) then
558: p_rec.pera_information_category :=
559: psp_era_shd.g_old_rec.pera_information_category;
560: End If;
561: If (p_rec.pera_information1 = hr_api.g_varchar2) then
557: If (p_rec.pera_information_category = hr_api.g_varchar2) then
558: p_rec.pera_information_category :=
559: psp_era_shd.g_old_rec.pera_information_category;
560: End If;
561: If (p_rec.pera_information1 = hr_api.g_varchar2) then
562: p_rec.pera_information1 :=
563: psp_era_shd.g_old_rec.pera_information1;
564: End If;
565: If (p_rec.pera_information2 = hr_api.g_varchar2) then
561: If (p_rec.pera_information1 = hr_api.g_varchar2) then
562: p_rec.pera_information1 :=
563: psp_era_shd.g_old_rec.pera_information1;
564: End If;
565: If (p_rec.pera_information2 = hr_api.g_varchar2) then
566: p_rec.pera_information2 :=
567: psp_era_shd.g_old_rec.pera_information2;
568: End If;
569: If (p_rec.pera_information3 = hr_api.g_varchar2) then
565: If (p_rec.pera_information2 = hr_api.g_varchar2) then
566: p_rec.pera_information2 :=
567: psp_era_shd.g_old_rec.pera_information2;
568: End If;
569: If (p_rec.pera_information3 = hr_api.g_varchar2) then
570: p_rec.pera_information3 :=
571: psp_era_shd.g_old_rec.pera_information3;
572: End If;
573: If (p_rec.pera_information4 = hr_api.g_varchar2) then
569: If (p_rec.pera_information3 = hr_api.g_varchar2) then
570: p_rec.pera_information3 :=
571: psp_era_shd.g_old_rec.pera_information3;
572: End If;
573: If (p_rec.pera_information4 = hr_api.g_varchar2) then
574: p_rec.pera_information4 :=
575: psp_era_shd.g_old_rec.pera_information4;
576: End If;
577: If (p_rec.pera_information5 = hr_api.g_varchar2) then
573: If (p_rec.pera_information4 = hr_api.g_varchar2) then
574: p_rec.pera_information4 :=
575: psp_era_shd.g_old_rec.pera_information4;
576: End If;
577: If (p_rec.pera_information5 = hr_api.g_varchar2) then
578: p_rec.pera_information5 :=
579: psp_era_shd.g_old_rec.pera_information5;
580: End If;
581: If (p_rec.pera_information6 = hr_api.g_varchar2) then
577: If (p_rec.pera_information5 = hr_api.g_varchar2) then
578: p_rec.pera_information5 :=
579: psp_era_shd.g_old_rec.pera_information5;
580: End If;
581: If (p_rec.pera_information6 = hr_api.g_varchar2) then
582: p_rec.pera_information6 :=
583: psp_era_shd.g_old_rec.pera_information6;
584: End If;
585: If (p_rec.pera_information7 = hr_api.g_varchar2) then
581: If (p_rec.pera_information6 = hr_api.g_varchar2) then
582: p_rec.pera_information6 :=
583: psp_era_shd.g_old_rec.pera_information6;
584: End If;
585: If (p_rec.pera_information7 = hr_api.g_varchar2) then
586: p_rec.pera_information7 :=
587: psp_era_shd.g_old_rec.pera_information7;
588: End If;
589: If (p_rec.pera_information8 = hr_api.g_varchar2) then
585: If (p_rec.pera_information7 = hr_api.g_varchar2) then
586: p_rec.pera_information7 :=
587: psp_era_shd.g_old_rec.pera_information7;
588: End If;
589: If (p_rec.pera_information8 = hr_api.g_varchar2) then
590: p_rec.pera_information8 :=
591: psp_era_shd.g_old_rec.pera_information8;
592: End If;
593: If (p_rec.pera_information9 = hr_api.g_varchar2) then
589: If (p_rec.pera_information8 = hr_api.g_varchar2) then
590: p_rec.pera_information8 :=
591: psp_era_shd.g_old_rec.pera_information8;
592: End If;
593: If (p_rec.pera_information9 = hr_api.g_varchar2) then
594: p_rec.pera_information9 :=
595: psp_era_shd.g_old_rec.pera_information9;
596: End If;
597: If (p_rec.pera_information10 = hr_api.g_varchar2) then
593: If (p_rec.pera_information9 = hr_api.g_varchar2) then
594: p_rec.pera_information9 :=
595: psp_era_shd.g_old_rec.pera_information9;
596: End If;
597: If (p_rec.pera_information10 = hr_api.g_varchar2) then
598: p_rec.pera_information10 :=
599: psp_era_shd.g_old_rec.pera_information10;
600: End If;
601: If (p_rec.pera_information11 = hr_api.g_varchar2) then
597: If (p_rec.pera_information10 = hr_api.g_varchar2) then
598: p_rec.pera_information10 :=
599: psp_era_shd.g_old_rec.pera_information10;
600: End If;
601: If (p_rec.pera_information11 = hr_api.g_varchar2) then
602: p_rec.pera_information11 :=
603: psp_era_shd.g_old_rec.pera_information11;
604: End If;
605: If (p_rec.pera_information12 = hr_api.g_varchar2) then
601: If (p_rec.pera_information11 = hr_api.g_varchar2) then
602: p_rec.pera_information11 :=
603: psp_era_shd.g_old_rec.pera_information11;
604: End If;
605: If (p_rec.pera_information12 = hr_api.g_varchar2) then
606: p_rec.pera_information12 :=
607: psp_era_shd.g_old_rec.pera_information12;
608: End If;
609: If (p_rec.pera_information13 = hr_api.g_varchar2) then
605: If (p_rec.pera_information12 = hr_api.g_varchar2) then
606: p_rec.pera_information12 :=
607: psp_era_shd.g_old_rec.pera_information12;
608: End If;
609: If (p_rec.pera_information13 = hr_api.g_varchar2) then
610: p_rec.pera_information13 :=
611: psp_era_shd.g_old_rec.pera_information13;
612: End If;
613: If (p_rec.pera_information14 = hr_api.g_varchar2) then
609: If (p_rec.pera_information13 = hr_api.g_varchar2) then
610: p_rec.pera_information13 :=
611: psp_era_shd.g_old_rec.pera_information13;
612: End If;
613: If (p_rec.pera_information14 = hr_api.g_varchar2) then
614: p_rec.pera_information14 :=
615: psp_era_shd.g_old_rec.pera_information14;
616: End If;
617: If (p_rec.pera_information15 = hr_api.g_varchar2) then
613: If (p_rec.pera_information14 = hr_api.g_varchar2) then
614: p_rec.pera_information14 :=
615: psp_era_shd.g_old_rec.pera_information14;
616: End If;
617: If (p_rec.pera_information15 = hr_api.g_varchar2) then
618: p_rec.pera_information15 :=
619: psp_era_shd.g_old_rec.pera_information15;
620: End If;
621: If (p_rec.pera_information16 = hr_api.g_varchar2) then
617: If (p_rec.pera_information15 = hr_api.g_varchar2) then
618: p_rec.pera_information15 :=
619: psp_era_shd.g_old_rec.pera_information15;
620: End If;
621: If (p_rec.pera_information16 = hr_api.g_varchar2) then
622: p_rec.pera_information16 :=
623: psp_era_shd.g_old_rec.pera_information16;
624: End If;
625: If (p_rec.pera_information17 = hr_api.g_varchar2) then
621: If (p_rec.pera_information16 = hr_api.g_varchar2) then
622: p_rec.pera_information16 :=
623: psp_era_shd.g_old_rec.pera_information16;
624: End If;
625: If (p_rec.pera_information17 = hr_api.g_varchar2) then
626: p_rec.pera_information17 :=
627: psp_era_shd.g_old_rec.pera_information17;
628: End If;
629: If (p_rec.pera_information18 = hr_api.g_varchar2) then
625: If (p_rec.pera_information17 = hr_api.g_varchar2) then
626: p_rec.pera_information17 :=
627: psp_era_shd.g_old_rec.pera_information17;
628: End If;
629: If (p_rec.pera_information18 = hr_api.g_varchar2) then
630: p_rec.pera_information18 :=
631: psp_era_shd.g_old_rec.pera_information18;
632: End If;
633: If (p_rec.pera_information19 = hr_api.g_varchar2) then
629: If (p_rec.pera_information18 = hr_api.g_varchar2) then
630: p_rec.pera_information18 :=
631: psp_era_shd.g_old_rec.pera_information18;
632: End If;
633: If (p_rec.pera_information19 = hr_api.g_varchar2) then
634: p_rec.pera_information19 :=
635: psp_era_shd.g_old_rec.pera_information19;
636: End If;
637: If (p_rec.pera_information20 = hr_api.g_varchar2) then
633: If (p_rec.pera_information19 = hr_api.g_varchar2) then
634: p_rec.pera_information19 :=
635: psp_era_shd.g_old_rec.pera_information19;
636: End If;
637: If (p_rec.pera_information20 = hr_api.g_varchar2) then
638: p_rec.pera_information20 :=
639: psp_era_shd.g_old_rec.pera_information20;
640: End If;
641: If (p_rec.wf_role_display_name = hr_api.g_varchar2) then
637: If (p_rec.pera_information20 = hr_api.g_varchar2) then
638: p_rec.pera_information20 :=
639: psp_era_shd.g_old_rec.pera_information20;
640: End If;
641: If (p_rec.wf_role_display_name = hr_api.g_varchar2) then
642: p_rec.wf_role_display_name :=
643: psp_era_shd.g_old_rec.wf_role_display_name;
644: End If;
645: If (p_rec.notification_id = hr_api.g_number) then
641: If (p_rec.wf_role_display_name = hr_api.g_varchar2) then
642: p_rec.wf_role_display_name :=
643: psp_era_shd.g_old_rec.wf_role_display_name;
644: End If;
645: If (p_rec.notification_id = hr_api.g_number) then
646: p_rec.notification_id :=
647: psp_era_shd.g_old_rec.notification_id;
648: End If;
649: If (p_rec.eff_information_category = hr_api.g_varchar2) then
645: If (p_rec.notification_id = hr_api.g_number) then
646: p_rec.notification_id :=
647: psp_era_shd.g_old_rec.notification_id;
648: End If;
649: If (p_rec.eff_information_category = hr_api.g_varchar2) then
650: p_rec.eff_information_category :=
651: psp_era_shd.g_old_rec.eff_information_category;
652: End If;
653: If (p_rec.eff_information1 = hr_api.g_varchar2) then
649: If (p_rec.eff_information_category = hr_api.g_varchar2) then
650: p_rec.eff_information_category :=
651: psp_era_shd.g_old_rec.eff_information_category;
652: End If;
653: If (p_rec.eff_information1 = hr_api.g_varchar2) then
654: p_rec.eff_information1 :=
655: psp_era_shd.g_old_rec.eff_information1;
656: End If;
657: If (p_rec.eff_information2 = hr_api.g_varchar2) then
653: If (p_rec.eff_information1 = hr_api.g_varchar2) then
654: p_rec.eff_information1 :=
655: psp_era_shd.g_old_rec.eff_information1;
656: End If;
657: If (p_rec.eff_information2 = hr_api.g_varchar2) then
658: p_rec.eff_information2 :=
659: psp_era_shd.g_old_rec.eff_information2;
660: End If;
661: If (p_rec.eff_information3 = hr_api.g_varchar2) then
657: If (p_rec.eff_information2 = hr_api.g_varchar2) then
658: p_rec.eff_information2 :=
659: psp_era_shd.g_old_rec.eff_information2;
660: End If;
661: If (p_rec.eff_information3 = hr_api.g_varchar2) then
662: p_rec.eff_information3 :=
663: psp_era_shd.g_old_rec.eff_information3;
664: End If;
665: If (p_rec.eff_information4 = hr_api.g_varchar2) then
661: If (p_rec.eff_information3 = hr_api.g_varchar2) then
662: p_rec.eff_information3 :=
663: psp_era_shd.g_old_rec.eff_information3;
664: End If;
665: If (p_rec.eff_information4 = hr_api.g_varchar2) then
666: p_rec.eff_information4 :=
667: psp_era_shd.g_old_rec.eff_information4;
668: End If;
669: If (p_rec.eff_information5 = hr_api.g_varchar2) then
665: If (p_rec.eff_information4 = hr_api.g_varchar2) then
666: p_rec.eff_information4 :=
667: psp_era_shd.g_old_rec.eff_information4;
668: End If;
669: If (p_rec.eff_information5 = hr_api.g_varchar2) then
670: p_rec.eff_information5 :=
671: psp_era_shd.g_old_rec.eff_information5;
672: End If;
673: If (p_rec.eff_information6 = hr_api.g_varchar2) then
669: If (p_rec.eff_information5 = hr_api.g_varchar2) then
670: p_rec.eff_information5 :=
671: psp_era_shd.g_old_rec.eff_information5;
672: End If;
673: If (p_rec.eff_information6 = hr_api.g_varchar2) then
674: p_rec.eff_information6 :=
675: psp_era_shd.g_old_rec.eff_information6;
676: End If;
677: If (p_rec.eff_information7 = hr_api.g_varchar2) then
673: If (p_rec.eff_information6 = hr_api.g_varchar2) then
674: p_rec.eff_information6 :=
675: psp_era_shd.g_old_rec.eff_information6;
676: End If;
677: If (p_rec.eff_information7 = hr_api.g_varchar2) then
678: p_rec.eff_information7 :=
679: psp_era_shd.g_old_rec.eff_information7;
680: End If;
681: If (p_rec.eff_information8 = hr_api.g_varchar2) then
677: If (p_rec.eff_information7 = hr_api.g_varchar2) then
678: p_rec.eff_information7 :=
679: psp_era_shd.g_old_rec.eff_information7;
680: End If;
681: If (p_rec.eff_information8 = hr_api.g_varchar2) then
682: p_rec.eff_information8 :=
683: psp_era_shd.g_old_rec.eff_information8;
684: End If;
685: If (p_rec.eff_information9 = hr_api.g_varchar2) then
681: If (p_rec.eff_information8 = hr_api.g_varchar2) then
682: p_rec.eff_information8 :=
683: psp_era_shd.g_old_rec.eff_information8;
684: End If;
685: If (p_rec.eff_information9 = hr_api.g_varchar2) then
686: p_rec.eff_information9 :=
687: psp_era_shd.g_old_rec.eff_information9;
688: End If;
689: If (p_rec.eff_information10 = hr_api.g_varchar2) then
685: If (p_rec.eff_information9 = hr_api.g_varchar2) then
686: p_rec.eff_information9 :=
687: psp_era_shd.g_old_rec.eff_information9;
688: End If;
689: If (p_rec.eff_information10 = hr_api.g_varchar2) then
690: p_rec.eff_information10 :=
691: psp_era_shd.g_old_rec.eff_information10;
692: End If;
693: If (p_rec.eff_information11 = hr_api.g_varchar2) then
689: If (p_rec.eff_information10 = hr_api.g_varchar2) then
690: p_rec.eff_information10 :=
691: psp_era_shd.g_old_rec.eff_information10;
692: End If;
693: If (p_rec.eff_information11 = hr_api.g_varchar2) then
694: p_rec.eff_information11 :=
695: psp_era_shd.g_old_rec.eff_information11;
696: End If;
697: If (p_rec.eff_information12 = hr_api.g_varchar2) then
693: If (p_rec.eff_information11 = hr_api.g_varchar2) then
694: p_rec.eff_information11 :=
695: psp_era_shd.g_old_rec.eff_information11;
696: End If;
697: If (p_rec.eff_information12 = hr_api.g_varchar2) then
698: p_rec.eff_information12 :=
699: psp_era_shd.g_old_rec.eff_information12;
700: End If;
701: If (p_rec.eff_information13 = hr_api.g_varchar2) then
697: If (p_rec.eff_information12 = hr_api.g_varchar2) then
698: p_rec.eff_information12 :=
699: psp_era_shd.g_old_rec.eff_information12;
700: End If;
701: If (p_rec.eff_information13 = hr_api.g_varchar2) then
702: p_rec.eff_information13 :=
703: psp_era_shd.g_old_rec.eff_information13;
704: End If;
705: If (p_rec.eff_information14 = hr_api.g_varchar2) then
701: If (p_rec.eff_information13 = hr_api.g_varchar2) then
702: p_rec.eff_information13 :=
703: psp_era_shd.g_old_rec.eff_information13;
704: End If;
705: If (p_rec.eff_information14 = hr_api.g_varchar2) then
706: p_rec.eff_information14 :=
707: psp_era_shd.g_old_rec.eff_information14;
708: End If;
709: If (p_rec.eff_information15 = hr_api.g_varchar2) then
705: If (p_rec.eff_information14 = hr_api.g_varchar2) then
706: p_rec.eff_information14 :=
707: psp_era_shd.g_old_rec.eff_information14;
708: End If;
709: If (p_rec.eff_information15 = hr_api.g_varchar2) then
710: p_rec.eff_information15 :=
711: psp_era_shd.g_old_rec.eff_information15;
712: End If;
713: --
769: -- ----------------------------------------------------------------------------
770: Procedure upd
771: (p_effort_report_approval_id in number
772: ,p_object_version_number in out nocopy number
773: ,p_effort_report_detail_id in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
770: Procedure upd
771: (p_effort_report_approval_id in number
772: ,p_object_version_number in out nocopy number
773: ,p_effort_report_detail_id in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
771: (p_effort_report_approval_id in number
772: ,p_object_version_number in out nocopy number
773: ,p_effort_report_detail_id in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
772: ,p_object_version_number in out nocopy number
773: ,p_effort_report_detail_id in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
773: ,p_effort_report_detail_id in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
775: ,p_wf_orig_system_id in number default hr_api.g_number
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
777: ,p_approver_order_num in number default hr_api.g_number
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
778: ,p_approval_status in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
779: ,p_response_date in date default hr_api.g_date
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
780: ,p_actual_cost_share in number default hr_api.g_number
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
781: ,p_overwritten_effort_percent in number default hr_api.g_number
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
782: ,p_wf_item_key in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
783: ,p_comments in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
785: ,p_pera_information1 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
786: ,p_pera_information2 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
787: ,p_pera_information3 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
788: ,p_pera_information4 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
789: ,p_pera_information5 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
790: ,p_pera_information6 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
791: ,p_pera_information7 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
792: ,p_pera_information8 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
793: ,p_pera_information9 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
794: ,p_pera_information10 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
795: ,p_pera_information11 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
796: ,p_pera_information12 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
797: ,p_pera_information13 in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
798: ,p_pera_information14 in varchar2 default hr_api.g_varchar2
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
799: ,p_pera_information15 in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
800: ,p_pera_information16 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
801: ,p_pera_information17 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
802: ,p_pera_information18 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
803: ,p_pera_information19 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
804: ,p_pera_information20 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
805: ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
806: ,p_notification_id in number default hr_api.g_number
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
808: ,p_eff_information1 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
809: ,p_eff_information2 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
810: ,p_eff_information3 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
811: ,p_eff_information4 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
812: ,p_eff_information5 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
813: ,p_eff_information6 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
814: ,p_eff_information7 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
815: ,p_eff_information8 in varchar2 default hr_api.g_varchar2
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
823: ) is
816: ,p_eff_information9 in varchar2 default hr_api.g_varchar2
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
823: ) is
824: --
817: ,p_eff_information10 in varchar2 default hr_api.g_varchar2
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
823: ) is
824: --
825: l_rec psp_era_shd.g_rec_type;
818: ,p_eff_information11 in varchar2 default hr_api.g_varchar2
819: ,p_eff_information12 in varchar2 default hr_api.g_varchar2
820: ,p_eff_information13 in varchar2 default hr_api.g_varchar2
821: ,p_eff_information14 in varchar2 default hr_api.g_varchar2
822: ,p_eff_information15 in varchar2 default hr_api.g_varchar2
823: ) is
824: --
825: l_rec psp_era_shd.g_rec_type;
826: l_proc varchar2(72) := g_package||'upd';