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

APPS.PSP_ERA_UPD dependencies on HR_API

Line 131: When hr_api.check_integrity_violated Then

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

Line 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

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

Line 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

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

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

Line 448: when hr_api.cannot_find_prog_unit then

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

Line 450: hr_api.cannot_find_prog_unit_error

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;

Line 513: If (p_rec.effort_report_detail_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 773: ,p_effort_report_detail_id in number default hr_api.g_number

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

Line 774: ,p_wf_role_name in varchar2 default hr_api.g_varchar2

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

Line 775: ,p_wf_orig_system_id in number default hr_api.g_number

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

Line 776: ,p_wf_orig_system in varchar2 default hr_api.g_varchar2

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

Line 777: ,p_approver_order_num 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

Line 778: ,p_approval_status in varchar2 default hr_api.g_varchar2

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

Line 779: ,p_response_date in date default hr_api.g_date

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

Line 780: ,p_actual_cost_share 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
784: ,p_pera_information_category in varchar2 default hr_api.g_varchar2

Line 781: ,p_overwritten_effort_percent in number default hr_api.g_number

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

Line 782: ,p_wf_item_key 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

Line 783: ,p_comments 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

Line 784: ,p_pera_information_category 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

Line 785: ,p_pera_information1 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

Line 786: ,p_pera_information2 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

Line 787: ,p_pera_information3 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

Line 788: ,p_pera_information4 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

Line 789: ,p_pera_information5 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

Line 790: ,p_pera_information6 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

Line 791: ,p_pera_information7 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

Line 792: ,p_pera_information8 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

Line 793: ,p_pera_information9 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

Line 794: ,p_pera_information10 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

Line 795: ,p_pera_information11 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

Line 796: ,p_pera_information12 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

Line 797: ,p_pera_information13 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

Line 798: ,p_pera_information14 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

Line 799: ,p_pera_information15 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

Line 800: ,p_pera_information16 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

Line 801: ,p_pera_information17 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

Line 802: ,p_pera_information18 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

Line 803: ,p_pera_information19 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
807: ,p_eff_information_category in varchar2 default hr_api.g_varchar2

Line 804: ,p_pera_information20 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

Line 805: ,p_wf_role_display_name 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

Line 806: ,p_notification_id in number default hr_api.g_number

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

Line 807: ,p_eff_information_category 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

Line 808: ,p_eff_information1 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

Line 809: ,p_eff_information2 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

Line 810: ,p_eff_information3 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

Line 811: ,p_eff_information4 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

Line 812: ,p_eff_information5 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

Line 813: ,p_eff_information6 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

Line 814: ,p_eff_information7 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

Line 815: ,p_eff_information8 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

Line 816: ,p_eff_information9 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

Line 817: ,p_eff_information10 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

Line 818: ,p_eff_information11 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

Line 819: ,p_eff_information12 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

Line 820: ,p_eff_information13 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
824: --

Line 821: ,p_eff_information14 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: --
825: l_rec psp_era_shd.g_rec_type;

Line 822: ,p_eff_information15 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;
826: l_proc varchar2(72) := g_package||'upd';