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.PER_PDS_UPD dependencies on HR_API

Line 149: When hr_api.check_integrity_violated Then

145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: --
148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error

Line 154: When hr_api.parent_integrity_violated Then

150: -- A check constraint has been violated
151: per_pds_shd.g_api_dml := false; -- Unset the api dml status
152: per_pds_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error

Line 159: When hr_api.unique_integrity_violated Then

155: -- Parent integrity has been violated
156: per_pds_shd.g_api_dml := false; -- Unset the api dml status
157: per_pds_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: per_pds_shd.g_api_dml := false; -- Unset the api dml status
162: per_pds_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: per_pds_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End update_dml;

Line 477: when hr_api.cannot_find_prog_unit then

473: ,p_pds_information30_o =>per_pds_shd.g_old_rec.pds_information30
474: );
475: --
476: exception
477: when hr_api.cannot_find_prog_unit then
478: hr_api.cannot_find_prog_unit_error
479: (
480: p_module_name => 'PER_PERIOD_OF_SERVICE',
481: p_hook_type => 'AU'

Line 478: hr_api.cannot_find_prog_unit_error

474: );
475: --
476: exception
477: when hr_api.cannot_find_prog_unit then
478: hr_api.cannot_find_prog_unit_error
479: (
480: p_module_name => 'PER_PERIOD_OF_SERVICE',
481: p_hook_type => 'AU'
482: );

Line 544: If (p_rec.business_group_id = hr_api.g_number) then

540: -- p_rec plsql record structure
541: -- to see if a system default is being used. If a system default
542: -- is being used then we must set to the 'current' argument value.
543: --
544: If (p_rec.business_group_id = hr_api.g_number) then
545: p_rec.business_group_id :=
546: per_pds_shd.g_old_rec.business_group_id;
547: End If;
548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then

Line 548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then

544: If (p_rec.business_group_id = hr_api.g_number) then
545: p_rec.business_group_id :=
546: per_pds_shd.g_old_rec.business_group_id;
547: End If;
548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then
549: p_rec.termination_accepted_person_id :=
550: per_pds_shd.g_old_rec.termination_accepted_person_id;
551: End If;
552: If (p_rec.person_id = hr_api.g_number) then

Line 552: If (p_rec.person_id = hr_api.g_number) then

548: If (p_rec.termination_accepted_person_id = hr_api.g_number) then
549: p_rec.termination_accepted_person_id :=
550: per_pds_shd.g_old_rec.termination_accepted_person_id;
551: End If;
552: If (p_rec.person_id = hr_api.g_number) then
553: p_rec.person_id :=
554: per_pds_shd.g_old_rec.person_id;
555: End If;
556: If (p_rec.date_start = hr_api.g_date) then

Line 556: If (p_rec.date_start = hr_api.g_date) then

552: If (p_rec.person_id = hr_api.g_number) then
553: p_rec.person_id :=
554: per_pds_shd.g_old_rec.person_id;
555: End If;
556: If (p_rec.date_start = hr_api.g_date) then
557: p_rec.date_start :=
558: per_pds_shd.g_old_rec.date_start;
559: End If;
560: If (p_rec.accepted_termination_date = hr_api.g_date) then

Line 560: If (p_rec.accepted_termination_date = hr_api.g_date) then

556: If (p_rec.date_start = hr_api.g_date) then
557: p_rec.date_start :=
558: per_pds_shd.g_old_rec.date_start;
559: End If;
560: If (p_rec.accepted_termination_date = hr_api.g_date) then
561: p_rec.accepted_termination_date :=
562: per_pds_shd.g_old_rec.accepted_termination_date;
563: End If;
564: If (p_rec.actual_termination_date = hr_api.g_date) then

Line 564: If (p_rec.actual_termination_date = hr_api.g_date) then

560: If (p_rec.accepted_termination_date = hr_api.g_date) then
561: p_rec.accepted_termination_date :=
562: per_pds_shd.g_old_rec.accepted_termination_date;
563: End If;
564: If (p_rec.actual_termination_date = hr_api.g_date) then
565: p_rec.actual_termination_date :=
566: per_pds_shd.g_old_rec.actual_termination_date;
567: End If;
568: If (p_rec.comments = hr_api.g_varchar2) then

Line 568: If (p_rec.comments = hr_api.g_varchar2) then

564: If (p_rec.actual_termination_date = hr_api.g_date) then
565: p_rec.actual_termination_date :=
566: per_pds_shd.g_old_rec.actual_termination_date;
567: End If;
568: If (p_rec.comments = hr_api.g_varchar2) then
569: p_rec.comments :=
570: per_pds_shd.g_old_rec.comments;
571: End If;
572: If (p_rec.final_process_date = hr_api.g_date) then

Line 572: If (p_rec.final_process_date = hr_api.g_date) then

568: If (p_rec.comments = hr_api.g_varchar2) then
569: p_rec.comments :=
570: per_pds_shd.g_old_rec.comments;
571: End If;
572: If (p_rec.final_process_date = hr_api.g_date) then
573: p_rec.final_process_date :=
574: per_pds_shd.g_old_rec.final_process_date;
575: End If;
576: If (p_rec.last_standard_process_date = hr_api.g_date) then

Line 576: If (p_rec.last_standard_process_date = hr_api.g_date) then

572: If (p_rec.final_process_date = hr_api.g_date) then
573: p_rec.final_process_date :=
574: per_pds_shd.g_old_rec.final_process_date;
575: End If;
576: If (p_rec.last_standard_process_date = hr_api.g_date) then
577: p_rec.last_standard_process_date :=
578: per_pds_shd.g_old_rec.last_standard_process_date;
579: End If;
580: If (p_rec.leaving_reason = hr_api.g_varchar2) then

Line 580: If (p_rec.leaving_reason = hr_api.g_varchar2) then

576: If (p_rec.last_standard_process_date = hr_api.g_date) then
577: p_rec.last_standard_process_date :=
578: per_pds_shd.g_old_rec.last_standard_process_date;
579: End If;
580: If (p_rec.leaving_reason = hr_api.g_varchar2) then
581: p_rec.leaving_reason :=
582: per_pds_shd.g_old_rec.leaving_reason;
583: End If;
584: If (p_rec.notified_termination_date = hr_api.g_date) then

Line 584: If (p_rec.notified_termination_date = hr_api.g_date) then

580: If (p_rec.leaving_reason = hr_api.g_varchar2) then
581: p_rec.leaving_reason :=
582: per_pds_shd.g_old_rec.leaving_reason;
583: End If;
584: If (p_rec.notified_termination_date = hr_api.g_date) then
585: p_rec.notified_termination_date :=
586: per_pds_shd.g_old_rec.notified_termination_date;
587: End If;
588: If (p_rec.projected_termination_date = hr_api.g_date) then

Line 588: If (p_rec.projected_termination_date = hr_api.g_date) then

584: If (p_rec.notified_termination_date = hr_api.g_date) then
585: p_rec.notified_termination_date :=
586: per_pds_shd.g_old_rec.notified_termination_date;
587: End If;
588: If (p_rec.projected_termination_date = hr_api.g_date) then
589: p_rec.projected_termination_date :=
590: per_pds_shd.g_old_rec.projected_termination_date;
591: End If;
592: If (p_rec.adjusted_svc_date = hr_api.g_date) then

Line 592: If (p_rec.adjusted_svc_date = hr_api.g_date) then

588: If (p_rec.projected_termination_date = hr_api.g_date) then
589: p_rec.projected_termination_date :=
590: per_pds_shd.g_old_rec.projected_termination_date;
591: End If;
592: If (p_rec.adjusted_svc_date = hr_api.g_date) then
593: p_rec.adjusted_svc_date :=
594: per_pds_shd.g_old_rec.adjusted_svc_date;
595: End If;
596: If (p_rec.request_id = hr_api.g_number) then

Line 596: If (p_rec.request_id = hr_api.g_number) then

592: If (p_rec.adjusted_svc_date = hr_api.g_date) then
593: p_rec.adjusted_svc_date :=
594: per_pds_shd.g_old_rec.adjusted_svc_date;
595: End If;
596: If (p_rec.request_id = hr_api.g_number) then
597: p_rec.request_id :=
598: per_pds_shd.g_old_rec.request_id;
599: End If;
600: If (p_rec.program_application_id = hr_api.g_number) then

Line 600: If (p_rec.program_application_id = hr_api.g_number) then

596: If (p_rec.request_id = hr_api.g_number) then
597: p_rec.request_id :=
598: per_pds_shd.g_old_rec.request_id;
599: End If;
600: If (p_rec.program_application_id = hr_api.g_number) then
601: p_rec.program_application_id :=
602: per_pds_shd.g_old_rec.program_application_id;
603: End If;
604: If (p_rec.program_id = hr_api.g_number) then

Line 604: If (p_rec.program_id = hr_api.g_number) then

600: If (p_rec.program_application_id = hr_api.g_number) then
601: p_rec.program_application_id :=
602: per_pds_shd.g_old_rec.program_application_id;
603: End If;
604: If (p_rec.program_id = hr_api.g_number) then
605: p_rec.program_id :=
606: per_pds_shd.g_old_rec.program_id;
607: End If;
608: If (p_rec.program_update_date = hr_api.g_date) then

Line 608: If (p_rec.program_update_date = hr_api.g_date) then

604: If (p_rec.program_id = hr_api.g_number) then
605: p_rec.program_id :=
606: per_pds_shd.g_old_rec.program_id;
607: End If;
608: If (p_rec.program_update_date = hr_api.g_date) then
609: p_rec.program_update_date :=
610: per_pds_shd.g_old_rec.program_update_date;
611: End If;
612: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 612: If (p_rec.attribute_category = hr_api.g_varchar2) then

608: If (p_rec.program_update_date = hr_api.g_date) then
609: p_rec.program_update_date :=
610: per_pds_shd.g_old_rec.program_update_date;
611: End If;
612: If (p_rec.attribute_category = hr_api.g_varchar2) then
613: p_rec.attribute_category :=
614: per_pds_shd.g_old_rec.attribute_category;
615: End If;
616: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 616: If (p_rec.attribute1 = hr_api.g_varchar2) then

612: If (p_rec.attribute_category = hr_api.g_varchar2) then
613: p_rec.attribute_category :=
614: per_pds_shd.g_old_rec.attribute_category;
615: End If;
616: If (p_rec.attribute1 = hr_api.g_varchar2) then
617: p_rec.attribute1 :=
618: per_pds_shd.g_old_rec.attribute1;
619: End If;
620: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 620: If (p_rec.attribute2 = hr_api.g_varchar2) then

616: If (p_rec.attribute1 = hr_api.g_varchar2) then
617: p_rec.attribute1 :=
618: per_pds_shd.g_old_rec.attribute1;
619: End If;
620: If (p_rec.attribute2 = hr_api.g_varchar2) then
621: p_rec.attribute2 :=
622: per_pds_shd.g_old_rec.attribute2;
623: End If;
624: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 624: If (p_rec.attribute3 = hr_api.g_varchar2) then

620: If (p_rec.attribute2 = hr_api.g_varchar2) then
621: p_rec.attribute2 :=
622: per_pds_shd.g_old_rec.attribute2;
623: End If;
624: If (p_rec.attribute3 = hr_api.g_varchar2) then
625: p_rec.attribute3 :=
626: per_pds_shd.g_old_rec.attribute3;
627: End If;
628: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 628: If (p_rec.attribute4 = hr_api.g_varchar2) then

624: If (p_rec.attribute3 = hr_api.g_varchar2) then
625: p_rec.attribute3 :=
626: per_pds_shd.g_old_rec.attribute3;
627: End If;
628: If (p_rec.attribute4 = hr_api.g_varchar2) then
629: p_rec.attribute4 :=
630: per_pds_shd.g_old_rec.attribute4;
631: End If;
632: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 632: If (p_rec.attribute5 = hr_api.g_varchar2) then

628: If (p_rec.attribute4 = hr_api.g_varchar2) then
629: p_rec.attribute4 :=
630: per_pds_shd.g_old_rec.attribute4;
631: End If;
632: If (p_rec.attribute5 = hr_api.g_varchar2) then
633: p_rec.attribute5 :=
634: per_pds_shd.g_old_rec.attribute5;
635: End If;
636: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 636: If (p_rec.attribute6 = hr_api.g_varchar2) then

632: If (p_rec.attribute5 = hr_api.g_varchar2) then
633: p_rec.attribute5 :=
634: per_pds_shd.g_old_rec.attribute5;
635: End If;
636: If (p_rec.attribute6 = hr_api.g_varchar2) then
637: p_rec.attribute6 :=
638: per_pds_shd.g_old_rec.attribute6;
639: End If;
640: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 640: If (p_rec.attribute7 = hr_api.g_varchar2) then

636: If (p_rec.attribute6 = hr_api.g_varchar2) then
637: p_rec.attribute6 :=
638: per_pds_shd.g_old_rec.attribute6;
639: End If;
640: If (p_rec.attribute7 = hr_api.g_varchar2) then
641: p_rec.attribute7 :=
642: per_pds_shd.g_old_rec.attribute7;
643: End If;
644: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 644: If (p_rec.attribute8 = hr_api.g_varchar2) then

640: If (p_rec.attribute7 = hr_api.g_varchar2) then
641: p_rec.attribute7 :=
642: per_pds_shd.g_old_rec.attribute7;
643: End If;
644: If (p_rec.attribute8 = hr_api.g_varchar2) then
645: p_rec.attribute8 :=
646: per_pds_shd.g_old_rec.attribute8;
647: End If;
648: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 648: If (p_rec.attribute9 = hr_api.g_varchar2) then

644: If (p_rec.attribute8 = hr_api.g_varchar2) then
645: p_rec.attribute8 :=
646: per_pds_shd.g_old_rec.attribute8;
647: End If;
648: If (p_rec.attribute9 = hr_api.g_varchar2) then
649: p_rec.attribute9 :=
650: per_pds_shd.g_old_rec.attribute9;
651: End If;
652: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 652: If (p_rec.attribute10 = hr_api.g_varchar2) then

648: If (p_rec.attribute9 = hr_api.g_varchar2) then
649: p_rec.attribute9 :=
650: per_pds_shd.g_old_rec.attribute9;
651: End If;
652: If (p_rec.attribute10 = hr_api.g_varchar2) then
653: p_rec.attribute10 :=
654: per_pds_shd.g_old_rec.attribute10;
655: End If;
656: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 656: If (p_rec.attribute11 = hr_api.g_varchar2) then

652: If (p_rec.attribute10 = hr_api.g_varchar2) then
653: p_rec.attribute10 :=
654: per_pds_shd.g_old_rec.attribute10;
655: End If;
656: If (p_rec.attribute11 = hr_api.g_varchar2) then
657: p_rec.attribute11 :=
658: per_pds_shd.g_old_rec.attribute11;
659: End If;
660: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 660: If (p_rec.attribute12 = hr_api.g_varchar2) then

656: If (p_rec.attribute11 = hr_api.g_varchar2) then
657: p_rec.attribute11 :=
658: per_pds_shd.g_old_rec.attribute11;
659: End If;
660: If (p_rec.attribute12 = hr_api.g_varchar2) then
661: p_rec.attribute12 :=
662: per_pds_shd.g_old_rec.attribute12;
663: End If;
664: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 664: If (p_rec.attribute13 = hr_api.g_varchar2) then

660: If (p_rec.attribute12 = hr_api.g_varchar2) then
661: p_rec.attribute12 :=
662: per_pds_shd.g_old_rec.attribute12;
663: End If;
664: If (p_rec.attribute13 = hr_api.g_varchar2) then
665: p_rec.attribute13 :=
666: per_pds_shd.g_old_rec.attribute13;
667: End If;
668: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 668: If (p_rec.attribute14 = hr_api.g_varchar2) then

664: If (p_rec.attribute13 = hr_api.g_varchar2) then
665: p_rec.attribute13 :=
666: per_pds_shd.g_old_rec.attribute13;
667: End If;
668: If (p_rec.attribute14 = hr_api.g_varchar2) then
669: p_rec.attribute14 :=
670: per_pds_shd.g_old_rec.attribute14;
671: End If;
672: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 672: If (p_rec.attribute15 = hr_api.g_varchar2) then

668: If (p_rec.attribute14 = hr_api.g_varchar2) then
669: p_rec.attribute14 :=
670: per_pds_shd.g_old_rec.attribute14;
671: End If;
672: If (p_rec.attribute15 = hr_api.g_varchar2) then
673: p_rec.attribute15 :=
674: per_pds_shd.g_old_rec.attribute15;
675: End If;
676: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 676: If (p_rec.attribute16 = hr_api.g_varchar2) then

672: If (p_rec.attribute15 = hr_api.g_varchar2) then
673: p_rec.attribute15 :=
674: per_pds_shd.g_old_rec.attribute15;
675: End If;
676: If (p_rec.attribute16 = hr_api.g_varchar2) then
677: p_rec.attribute16 :=
678: per_pds_shd.g_old_rec.attribute16;
679: End If;
680: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 680: If (p_rec.attribute17 = hr_api.g_varchar2) then

676: If (p_rec.attribute16 = hr_api.g_varchar2) then
677: p_rec.attribute16 :=
678: per_pds_shd.g_old_rec.attribute16;
679: End If;
680: If (p_rec.attribute17 = hr_api.g_varchar2) then
681: p_rec.attribute17 :=
682: per_pds_shd.g_old_rec.attribute17;
683: End If;
684: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 684: If (p_rec.attribute18 = hr_api.g_varchar2) then

680: If (p_rec.attribute17 = hr_api.g_varchar2) then
681: p_rec.attribute17 :=
682: per_pds_shd.g_old_rec.attribute17;
683: End If;
684: If (p_rec.attribute18 = hr_api.g_varchar2) then
685: p_rec.attribute18 :=
686: per_pds_shd.g_old_rec.attribute18;
687: End If;
688: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 688: If (p_rec.attribute19 = hr_api.g_varchar2) then

684: If (p_rec.attribute18 = hr_api.g_varchar2) then
685: p_rec.attribute18 :=
686: per_pds_shd.g_old_rec.attribute18;
687: End If;
688: If (p_rec.attribute19 = hr_api.g_varchar2) then
689: p_rec.attribute19 :=
690: per_pds_shd.g_old_rec.attribute19;
691: End If;
692: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 692: If (p_rec.attribute20 = hr_api.g_varchar2) then

688: If (p_rec.attribute19 = hr_api.g_varchar2) then
689: p_rec.attribute19 :=
690: per_pds_shd.g_old_rec.attribute19;
691: End If;
692: If (p_rec.attribute20 = hr_api.g_varchar2) then
693: p_rec.attribute20 :=
694: per_pds_shd.g_old_rec.attribute20;
695: End If;
696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then

Line 696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then

692: If (p_rec.attribute20 = hr_api.g_varchar2) then
693: p_rec.attribute20 :=
694: per_pds_shd.g_old_rec.attribute20;
695: End If;
696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then
697: p_rec.prior_employment_ssp_weeks :=
698: per_pds_shd.g_old_rec.prior_employment_ssp_weeks;
699: End If;
700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then

Line 700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then

696: If (p_rec.prior_employment_ssp_weeks = hr_api.g_number) then
697: p_rec.prior_employment_ssp_weeks :=
698: per_pds_shd.g_old_rec.prior_employment_ssp_weeks;
699: End If;
700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then
701: p_rec.prior_employment_ssp_paid_to :=
702: per_pds_shd.g_old_rec.prior_employment_ssp_paid_to;
703: End If;
704: If (p_rec.pds_information_category = hr_api.g_varchar2) then

Line 704: If (p_rec.pds_information_category = hr_api.g_varchar2) then

700: If (p_rec.prior_employment_ssp_paid_to = hr_api.g_date) then
701: p_rec.prior_employment_ssp_paid_to :=
702: per_pds_shd.g_old_rec.prior_employment_ssp_paid_to;
703: End If;
704: If (p_rec.pds_information_category = hr_api.g_varchar2) then
705: p_rec.pds_information_category :=
706: per_pds_shd.g_old_rec.pds_information_category;
707: End If;
708: If (p_rec.pds_information1 = hr_api.g_varchar2) then

Line 708: If (p_rec.pds_information1 = hr_api.g_varchar2) then

704: If (p_rec.pds_information_category = hr_api.g_varchar2) then
705: p_rec.pds_information_category :=
706: per_pds_shd.g_old_rec.pds_information_category;
707: End If;
708: If (p_rec.pds_information1 = hr_api.g_varchar2) then
709: p_rec.pds_information1 :=
710: per_pds_shd.g_old_rec.pds_information1;
711: End If;
712: If (p_rec.pds_information2 = hr_api.g_varchar2) then

Line 712: If (p_rec.pds_information2 = hr_api.g_varchar2) then

708: If (p_rec.pds_information1 = hr_api.g_varchar2) then
709: p_rec.pds_information1 :=
710: per_pds_shd.g_old_rec.pds_information1;
711: End If;
712: If (p_rec.pds_information2 = hr_api.g_varchar2) then
713: p_rec.pds_information2 :=
714: per_pds_shd.g_old_rec.pds_information2;
715: End If;
716: If (p_rec.pds_information3 = hr_api.g_varchar2) then

Line 716: If (p_rec.pds_information3 = hr_api.g_varchar2) then

712: If (p_rec.pds_information2 = hr_api.g_varchar2) then
713: p_rec.pds_information2 :=
714: per_pds_shd.g_old_rec.pds_information2;
715: End If;
716: If (p_rec.pds_information3 = hr_api.g_varchar2) then
717: p_rec.pds_information3 :=
718: per_pds_shd.g_old_rec.pds_information3;
719: End If;
720: If (p_rec.pds_information4 = hr_api.g_varchar2) then

Line 720: If (p_rec.pds_information4 = hr_api.g_varchar2) then

716: If (p_rec.pds_information3 = hr_api.g_varchar2) then
717: p_rec.pds_information3 :=
718: per_pds_shd.g_old_rec.pds_information3;
719: End If;
720: If (p_rec.pds_information4 = hr_api.g_varchar2) then
721: p_rec.pds_information4 :=
722: per_pds_shd.g_old_rec.pds_information4;
723: End If;
724: If (p_rec.pds_information5 = hr_api.g_varchar2) then

Line 724: If (p_rec.pds_information5 = hr_api.g_varchar2) then

720: If (p_rec.pds_information4 = hr_api.g_varchar2) then
721: p_rec.pds_information4 :=
722: per_pds_shd.g_old_rec.pds_information4;
723: End If;
724: If (p_rec.pds_information5 = hr_api.g_varchar2) then
725: p_rec.pds_information5 :=
726: per_pds_shd.g_old_rec.pds_information5;
727: End If;
728: If (p_rec.pds_information6 = hr_api.g_varchar2) then

Line 728: If (p_rec.pds_information6 = hr_api.g_varchar2) then

724: If (p_rec.pds_information5 = hr_api.g_varchar2) then
725: p_rec.pds_information5 :=
726: per_pds_shd.g_old_rec.pds_information5;
727: End If;
728: If (p_rec.pds_information6 = hr_api.g_varchar2) then
729: p_rec.pds_information6 :=
730: per_pds_shd.g_old_rec.pds_information6;
731: End If;
732: If (p_rec.pds_information7 = hr_api.g_varchar2) then

Line 732: If (p_rec.pds_information7 = hr_api.g_varchar2) then

728: If (p_rec.pds_information6 = hr_api.g_varchar2) then
729: p_rec.pds_information6 :=
730: per_pds_shd.g_old_rec.pds_information6;
731: End If;
732: If (p_rec.pds_information7 = hr_api.g_varchar2) then
733: p_rec.pds_information7 :=
734: per_pds_shd.g_old_rec.pds_information7;
735: End If;
736: If (p_rec.pds_information8 = hr_api.g_varchar2) then

Line 736: If (p_rec.pds_information8 = hr_api.g_varchar2) then

732: If (p_rec.pds_information7 = hr_api.g_varchar2) then
733: p_rec.pds_information7 :=
734: per_pds_shd.g_old_rec.pds_information7;
735: End If;
736: If (p_rec.pds_information8 = hr_api.g_varchar2) then
737: p_rec.pds_information8 :=
738: per_pds_shd.g_old_rec.pds_information8;
739: End If;
740: If (p_rec.pds_information9 = hr_api.g_varchar2) then

Line 740: If (p_rec.pds_information9 = hr_api.g_varchar2) then

736: If (p_rec.pds_information8 = hr_api.g_varchar2) then
737: p_rec.pds_information8 :=
738: per_pds_shd.g_old_rec.pds_information8;
739: End If;
740: If (p_rec.pds_information9 = hr_api.g_varchar2) then
741: p_rec.pds_information9 :=
742: per_pds_shd.g_old_rec.pds_information9;
743: End If;
744: If (p_rec.pds_information10 = hr_api.g_varchar2) then

Line 744: If (p_rec.pds_information10 = hr_api.g_varchar2) then

740: If (p_rec.pds_information9 = hr_api.g_varchar2) then
741: p_rec.pds_information9 :=
742: per_pds_shd.g_old_rec.pds_information9;
743: End If;
744: If (p_rec.pds_information10 = hr_api.g_varchar2) then
745: p_rec.pds_information10 :=
746: per_pds_shd.g_old_rec.pds_information10;
747: End If;
748: If (p_rec.pds_information11 = hr_api.g_varchar2) then

Line 748: If (p_rec.pds_information11 = hr_api.g_varchar2) then

744: If (p_rec.pds_information10 = hr_api.g_varchar2) then
745: p_rec.pds_information10 :=
746: per_pds_shd.g_old_rec.pds_information10;
747: End If;
748: If (p_rec.pds_information11 = hr_api.g_varchar2) then
749: p_rec.pds_information11 :=
750: per_pds_shd.g_old_rec.pds_information11;
751: End If;
752: If (p_rec.pds_information12 = hr_api.g_varchar2) then

Line 752: If (p_rec.pds_information12 = hr_api.g_varchar2) then

748: If (p_rec.pds_information11 = hr_api.g_varchar2) then
749: p_rec.pds_information11 :=
750: per_pds_shd.g_old_rec.pds_information11;
751: End If;
752: If (p_rec.pds_information12 = hr_api.g_varchar2) then
753: p_rec.pds_information12 :=
754: per_pds_shd.g_old_rec.pds_information12;
755: End If;
756: If (p_rec.pds_information13 = hr_api.g_varchar2) then

Line 756: If (p_rec.pds_information13 = hr_api.g_varchar2) then

752: If (p_rec.pds_information12 = hr_api.g_varchar2) then
753: p_rec.pds_information12 :=
754: per_pds_shd.g_old_rec.pds_information12;
755: End If;
756: If (p_rec.pds_information13 = hr_api.g_varchar2) then
757: p_rec.pds_information13 :=
758: per_pds_shd.g_old_rec.pds_information13;
759: End If;
760: If (p_rec.pds_information14 = hr_api.g_varchar2) then

Line 760: If (p_rec.pds_information14 = hr_api.g_varchar2) then

756: If (p_rec.pds_information13 = hr_api.g_varchar2) then
757: p_rec.pds_information13 :=
758: per_pds_shd.g_old_rec.pds_information13;
759: End If;
760: If (p_rec.pds_information14 = hr_api.g_varchar2) then
761: p_rec.pds_information14 :=
762: per_pds_shd.g_old_rec.pds_information14;
763: End If;
764: If (p_rec.pds_information15 = hr_api.g_varchar2) then

Line 764: If (p_rec.pds_information15 = hr_api.g_varchar2) then

760: If (p_rec.pds_information14 = hr_api.g_varchar2) then
761: p_rec.pds_information14 :=
762: per_pds_shd.g_old_rec.pds_information14;
763: End If;
764: If (p_rec.pds_information15 = hr_api.g_varchar2) then
765: p_rec.pds_information15 :=
766: per_pds_shd.g_old_rec.pds_information15;
767: End If;
768: If (p_rec.pds_information16 = hr_api.g_varchar2) then

Line 768: If (p_rec.pds_information16 = hr_api.g_varchar2) then

764: If (p_rec.pds_information15 = hr_api.g_varchar2) then
765: p_rec.pds_information15 :=
766: per_pds_shd.g_old_rec.pds_information15;
767: End If;
768: If (p_rec.pds_information16 = hr_api.g_varchar2) then
769: p_rec.pds_information16 :=
770: per_pds_shd.g_old_rec.pds_information16;
771: End If;
772: If (p_rec.pds_information17 = hr_api.g_varchar2) then

Line 772: If (p_rec.pds_information17 = hr_api.g_varchar2) then

768: If (p_rec.pds_information16 = hr_api.g_varchar2) then
769: p_rec.pds_information16 :=
770: per_pds_shd.g_old_rec.pds_information16;
771: End If;
772: If (p_rec.pds_information17 = hr_api.g_varchar2) then
773: p_rec.pds_information17 :=
774: per_pds_shd.g_old_rec.pds_information17;
775: End If;
776: If (p_rec.pds_information18 = hr_api.g_varchar2) then

Line 776: If (p_rec.pds_information18 = hr_api.g_varchar2) then

772: If (p_rec.pds_information17 = hr_api.g_varchar2) then
773: p_rec.pds_information17 :=
774: per_pds_shd.g_old_rec.pds_information17;
775: End If;
776: If (p_rec.pds_information18 = hr_api.g_varchar2) then
777: p_rec.pds_information18 :=
778: per_pds_shd.g_old_rec.pds_information18;
779: End If;
780: If (p_rec.pds_information19 = hr_api.g_varchar2) then

Line 780: If (p_rec.pds_information19 = hr_api.g_varchar2) then

776: If (p_rec.pds_information18 = hr_api.g_varchar2) then
777: p_rec.pds_information18 :=
778: per_pds_shd.g_old_rec.pds_information18;
779: End If;
780: If (p_rec.pds_information19 = hr_api.g_varchar2) then
781: p_rec.pds_information19 :=
782: per_pds_shd.g_old_rec.pds_information19;
783: End If;
784: If (p_rec.pds_information20 = hr_api.g_varchar2) then

Line 784: If (p_rec.pds_information20 = hr_api.g_varchar2) then

780: If (p_rec.pds_information19 = hr_api.g_varchar2) then
781: p_rec.pds_information19 :=
782: per_pds_shd.g_old_rec.pds_information19;
783: End If;
784: If (p_rec.pds_information20 = hr_api.g_varchar2) then
785: p_rec.pds_information20 :=
786: per_pds_shd.g_old_rec.pds_information20;
787: End If;
788: If (p_rec.pds_information21 = hr_api.g_varchar2) then

Line 788: If (p_rec.pds_information21 = hr_api.g_varchar2) then

784: If (p_rec.pds_information20 = hr_api.g_varchar2) then
785: p_rec.pds_information20 :=
786: per_pds_shd.g_old_rec.pds_information20;
787: End If;
788: If (p_rec.pds_information21 = hr_api.g_varchar2) then
789: p_rec.pds_information21 :=
790: per_pds_shd.g_old_rec.pds_information21;
791: End If;
792: If (p_rec.pds_information22 = hr_api.g_varchar2) then

Line 792: If (p_rec.pds_information22 = hr_api.g_varchar2) then

788: If (p_rec.pds_information21 = hr_api.g_varchar2) then
789: p_rec.pds_information21 :=
790: per_pds_shd.g_old_rec.pds_information21;
791: End If;
792: If (p_rec.pds_information22 = hr_api.g_varchar2) then
793: p_rec.pds_information22 :=
794: per_pds_shd.g_old_rec.pds_information22;
795: End If;
796: If (p_rec.pds_information23 = hr_api.g_varchar2) then

Line 796: If (p_rec.pds_information23 = hr_api.g_varchar2) then

792: If (p_rec.pds_information22 = hr_api.g_varchar2) then
793: p_rec.pds_information22 :=
794: per_pds_shd.g_old_rec.pds_information22;
795: End If;
796: If (p_rec.pds_information23 = hr_api.g_varchar2) then
797: p_rec.pds_information23 :=
798: per_pds_shd.g_old_rec.pds_information23;
799: End If;
800: If (p_rec.pds_information24 = hr_api.g_varchar2) then

Line 800: If (p_rec.pds_information24 = hr_api.g_varchar2) then

796: If (p_rec.pds_information23 = hr_api.g_varchar2) then
797: p_rec.pds_information23 :=
798: per_pds_shd.g_old_rec.pds_information23;
799: End If;
800: If (p_rec.pds_information24 = hr_api.g_varchar2) then
801: p_rec.pds_information24 :=
802: per_pds_shd.g_old_rec.pds_information24;
803: End If;
804: If (p_rec.pds_information25 = hr_api.g_varchar2) then

Line 804: If (p_rec.pds_information25 = hr_api.g_varchar2) then

800: If (p_rec.pds_information24 = hr_api.g_varchar2) then
801: p_rec.pds_information24 :=
802: per_pds_shd.g_old_rec.pds_information24;
803: End If;
804: If (p_rec.pds_information25 = hr_api.g_varchar2) then
805: p_rec.pds_information25 :=
806: per_pds_shd.g_old_rec.pds_information25;
807: End If;
808: If (p_rec.pds_information26 = hr_api.g_varchar2) then

Line 808: If (p_rec.pds_information26 = hr_api.g_varchar2) then

804: If (p_rec.pds_information25 = hr_api.g_varchar2) then
805: p_rec.pds_information25 :=
806: per_pds_shd.g_old_rec.pds_information25;
807: End If;
808: If (p_rec.pds_information26 = hr_api.g_varchar2) then
809: p_rec.pds_information26 :=
810: per_pds_shd.g_old_rec.pds_information26;
811: End If;
812: If (p_rec.pds_information27 = hr_api.g_varchar2) then

Line 812: If (p_rec.pds_information27 = hr_api.g_varchar2) then

808: If (p_rec.pds_information26 = hr_api.g_varchar2) then
809: p_rec.pds_information26 :=
810: per_pds_shd.g_old_rec.pds_information26;
811: End If;
812: If (p_rec.pds_information27 = hr_api.g_varchar2) then
813: p_rec.pds_information27 :=
814: per_pds_shd.g_old_rec.pds_information27;
815: End If;
816: If (p_rec.pds_information28 = hr_api.g_varchar2) then

Line 816: If (p_rec.pds_information28 = hr_api.g_varchar2) then

812: If (p_rec.pds_information27 = hr_api.g_varchar2) then
813: p_rec.pds_information27 :=
814: per_pds_shd.g_old_rec.pds_information27;
815: End If;
816: If (p_rec.pds_information28 = hr_api.g_varchar2) then
817: p_rec.pds_information28 :=
818: per_pds_shd.g_old_rec.pds_information28;
819: End If;
820: If (p_rec.pds_information29 = hr_api.g_varchar2) then

Line 820: If (p_rec.pds_information29 = hr_api.g_varchar2) then

816: If (p_rec.pds_information28 = hr_api.g_varchar2) then
817: p_rec.pds_information28 :=
818: per_pds_shd.g_old_rec.pds_information28;
819: End If;
820: If (p_rec.pds_information29 = hr_api.g_varchar2) then
821: p_rec.pds_information29 :=
822: per_pds_shd.g_old_rec.pds_information29;
823: End If;
824: If (p_rec.pds_information30 = hr_api.g_varchar2) then

Line 824: If (p_rec.pds_information30 = hr_api.g_varchar2) then

820: If (p_rec.pds_information29 = hr_api.g_varchar2) then
821: p_rec.pds_information29 :=
822: per_pds_shd.g_old_rec.pds_information29;
823: End If;
824: If (p_rec.pds_information30 = hr_api.g_varchar2) then
825: p_rec.pds_information30 :=
826: per_pds_shd.g_old_rec.pds_information30;
827: End If;
828: --

Line 891: Raise HR_Api.Validate_Enabled;

887: --
888: -- If we are validating then raise the Validate_Enabled exception
889: --
890: If p_validate then
891: Raise HR_Api.Validate_Enabled;
892: End If;
893: --
894: hr_utility.set_location(' Leaving:'||l_proc, 10);
895: Exception

Line 896: When HR_Api.Validate_Enabled Then

892: End If;
893: --
894: hr_utility.set_location(' Leaving:'||l_proc, 10);
895: Exception
896: When HR_Api.Validate_Enabled Then
897: --
898: -- As the Validate_Enabled exception has been raised
899: -- we must rollback to the savepoint
900: --

Line 910: p_termination_accepted_person in number default hr_api.g_number,

906: -- ----------------------------------------------------------------------------
907: Procedure upd
908: (
909: p_period_of_service_id in number,
910: p_termination_accepted_person in number default hr_api.g_number,
911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,

Line 911: p_date_start in date default hr_api.g_date,

907: Procedure upd
908: (
909: p_period_of_service_id in number,
910: p_termination_accepted_person in number default hr_api.g_number,
911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,

Line 912: p_accepted_termination_date in date default hr_api.g_date,

908: (
909: p_period_of_service_id in number,
910: p_termination_accepted_person in number default hr_api.g_number,
911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,

Line 913: p_actual_termination_date in date default hr_api.g_date,

909: p_period_of_service_id in number,
910: p_termination_accepted_person in number default hr_api.g_number,
911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,

Line 914: p_comments in varchar2 default hr_api.g_varchar2,

910: p_termination_accepted_person in number default hr_api.g_number,
911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,

Line 915: p_final_process_date in date default hr_api.g_date,

911: p_date_start in date default hr_api.g_date,
912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,

Line 916: p_last_standard_process_date in date default hr_api.g_date,

912: p_accepted_termination_date in date default hr_api.g_date,
913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,

Line 917: p_leaving_reason in varchar2 default hr_api.g_varchar2,

913: p_actual_termination_date in date default hr_api.g_date,
914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,

Line 918: p_notified_termination_date in date default hr_api.g_date,

914: p_comments in varchar2 default hr_api.g_varchar2,
915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,

Line 919: p_projected_termination_date in date default hr_api.g_date,

915: p_final_process_date in date default hr_api.g_date,
916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,

Line 920: p_adjusted_svc_date in date default hr_api.g_date,

916: p_last_standard_process_date in date default hr_api.g_date,
917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,

Line 921: p_request_id in number default hr_api.g_number,

917: p_leaving_reason in varchar2 default hr_api.g_varchar2,
918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 922: p_program_application_id in number default hr_api.g_number,

918: p_notified_termination_date in date default hr_api.g_date,
919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 923: p_program_id in number default hr_api.g_number,

919: p_projected_termination_date in date default hr_api.g_date,
920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 924: p_program_update_date in date default hr_api.g_date,

920: p_adjusted_svc_date in date default hr_api.g_date,
921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 925: p_attribute_category in varchar2 default hr_api.g_varchar2,

921: p_request_id in number default hr_api.g_number,
922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 926: p_attribute1 in varchar2 default hr_api.g_varchar2,

922: p_program_application_id in number default hr_api.g_number,
923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 927: p_attribute2 in varchar2 default hr_api.g_varchar2,

923: p_program_id in number default hr_api.g_number,
924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 928: p_attribute3 in varchar2 default hr_api.g_varchar2,

924: p_program_update_date in date default hr_api.g_date,
925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 929: p_attribute4 in varchar2 default hr_api.g_varchar2,

925: p_attribute_category in varchar2 default hr_api.g_varchar2,
926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 930: p_attribute5 in varchar2 default hr_api.g_varchar2,

926: p_attribute1 in varchar2 default hr_api.g_varchar2,
927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 931: p_attribute6 in varchar2 default hr_api.g_varchar2,

927: p_attribute2 in varchar2 default hr_api.g_varchar2,
928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 932: p_attribute7 in varchar2 default hr_api.g_varchar2,

928: p_attribute3 in varchar2 default hr_api.g_varchar2,
929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 933: p_attribute8 in varchar2 default hr_api.g_varchar2,

929: p_attribute4 in varchar2 default hr_api.g_varchar2,
930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 934: p_attribute9 in varchar2 default hr_api.g_varchar2,

930: p_attribute5 in varchar2 default hr_api.g_varchar2,
931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 935: p_attribute10 in varchar2 default hr_api.g_varchar2,

931: p_attribute6 in varchar2 default hr_api.g_varchar2,
932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 936: p_attribute11 in varchar2 default hr_api.g_varchar2,

932: p_attribute7 in varchar2 default hr_api.g_varchar2,
933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 937: p_attribute12 in varchar2 default hr_api.g_varchar2,

933: p_attribute8 in varchar2 default hr_api.g_varchar2,
934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 938: p_attribute13 in varchar2 default hr_api.g_varchar2,

934: p_attribute9 in varchar2 default hr_api.g_varchar2,
935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 939: p_attribute14 in varchar2 default hr_api.g_varchar2,

935: p_attribute10 in varchar2 default hr_api.g_varchar2,
936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 940: p_attribute15 in varchar2 default hr_api.g_varchar2,

936: p_attribute11 in varchar2 default hr_api.g_varchar2,
937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 941: p_attribute16 in varchar2 default hr_api.g_varchar2,

937: p_attribute12 in varchar2 default hr_api.g_varchar2,
938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 942: p_attribute17 in varchar2 default hr_api.g_varchar2,

938: p_attribute13 in varchar2 default hr_api.g_varchar2,
939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,

Line 943: p_attribute18 in varchar2 default hr_api.g_varchar2,

939: p_attribute14 in varchar2 default hr_api.g_varchar2,
940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,

Line 944: p_attribute19 in varchar2 default hr_api.g_varchar2,

940: p_attribute15 in varchar2 default hr_api.g_varchar2,
941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,

Line 945: p_attribute20 in varchar2 default hr_api.g_varchar2,

941: p_attribute16 in varchar2 default hr_api.g_varchar2,
942: p_attribute17 in varchar2 default hr_api.g_varchar2,
943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,

Line 947: p_prior_employment_ssp_weeks in number default hr_api.g_number,

943: p_attribute18 in varchar2 default hr_api.g_varchar2,
944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,

Line 948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,

944: p_attribute19 in varchar2 default hr_api.g_varchar2,
945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,

Line 949: p_pds_information_category in varchar2 default hr_api.g_varchar2,

945: p_attribute20 in varchar2 default hr_api.g_varchar2,
946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,

Line 950: p_pds_information1 in varchar2 default hr_api.g_varchar2,

946: p_object_version_number in out nocopy number,
947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,

Line 951: p_pds_information2 in varchar2 default hr_api.g_varchar2,

947: p_prior_employment_ssp_weeks in number default hr_api.g_number,
948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,

Line 952: p_pds_information3 in varchar2 default hr_api.g_varchar2,

948: p_prior_employment_ssp_paid_to in date default hr_api.g_date,
949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,

Line 953: p_pds_information4 in varchar2 default hr_api.g_varchar2,

949: p_pds_information_category in varchar2 default hr_api.g_varchar2,
950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,

Line 954: p_pds_information5 in varchar2 default hr_api.g_varchar2,

950: p_pds_information1 in varchar2 default hr_api.g_varchar2,
951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,

Line 955: p_pds_information6 in varchar2 default hr_api.g_varchar2,

951: p_pds_information2 in varchar2 default hr_api.g_varchar2,
952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,

Line 956: p_pds_information7 in varchar2 default hr_api.g_varchar2,

952: p_pds_information3 in varchar2 default hr_api.g_varchar2,
953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,

Line 957: p_pds_information8 in varchar2 default hr_api.g_varchar2,

953: p_pds_information4 in varchar2 default hr_api.g_varchar2,
954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,

Line 958: p_pds_information9 in varchar2 default hr_api.g_varchar2,

954: p_pds_information5 in varchar2 default hr_api.g_varchar2,
955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,

Line 959: p_pds_information10 in varchar2 default hr_api.g_varchar2,

955: p_pds_information6 in varchar2 default hr_api.g_varchar2,
956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,

Line 960: p_pds_information11 in varchar2 default hr_api.g_varchar2,

956: p_pds_information7 in varchar2 default hr_api.g_varchar2,
957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,

Line 961: p_pds_information12 in varchar2 default hr_api.g_varchar2,

957: p_pds_information8 in varchar2 default hr_api.g_varchar2,
958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,

Line 962: p_pds_information13 in varchar2 default hr_api.g_varchar2,

958: p_pds_information9 in varchar2 default hr_api.g_varchar2,
959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,

Line 963: p_pds_information14 in varchar2 default hr_api.g_varchar2,

959: p_pds_information10 in varchar2 default hr_api.g_varchar2,
960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,

Line 964: p_pds_information15 in varchar2 default hr_api.g_varchar2,

960: p_pds_information11 in varchar2 default hr_api.g_varchar2,
961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,

Line 965: p_pds_information16 in varchar2 default hr_api.g_varchar2,

961: p_pds_information12 in varchar2 default hr_api.g_varchar2,
962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,

Line 966: p_pds_information17 in varchar2 default hr_api.g_varchar2,

962: p_pds_information13 in varchar2 default hr_api.g_varchar2,
963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,

Line 967: p_pds_information18 in varchar2 default hr_api.g_varchar2,

963: p_pds_information14 in varchar2 default hr_api.g_varchar2,
964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,

Line 968: p_pds_information19 in varchar2 default hr_api.g_varchar2,

964: p_pds_information15 in varchar2 default hr_api.g_varchar2,
965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,

Line 969: p_pds_information20 in varchar2 default hr_api.g_varchar2,

965: p_pds_information16 in varchar2 default hr_api.g_varchar2,
966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,

Line 970: p_pds_information21 in varchar2 default hr_api.g_varchar2,

966: p_pds_information17 in varchar2 default hr_api.g_varchar2,
967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,

Line 971: p_pds_information22 in varchar2 default hr_api.g_varchar2,

967: p_pds_information18 in varchar2 default hr_api.g_varchar2,
968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,

Line 972: p_pds_information23 in varchar2 default hr_api.g_varchar2,

968: p_pds_information19 in varchar2 default hr_api.g_varchar2,
969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,

Line 973: p_pds_information24 in varchar2 default hr_api.g_varchar2,

969: p_pds_information20 in varchar2 default hr_api.g_varchar2,
970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,

Line 974: p_pds_information25 in varchar2 default hr_api.g_varchar2,

970: p_pds_information21 in varchar2 default hr_api.g_varchar2,
971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,

Line 975: p_pds_information26 in varchar2 default hr_api.g_varchar2,

971: p_pds_information22 in varchar2 default hr_api.g_varchar2,
972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,
979: p_pds_information30 in varchar2 default hr_api.g_varchar2,

Line 976: p_pds_information27 in varchar2 default hr_api.g_varchar2,

972: p_pds_information23 in varchar2 default hr_api.g_varchar2,
973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,
979: p_pds_information30 in varchar2 default hr_api.g_varchar2,
980: p_effective_date in date,

Line 977: p_pds_information28 in varchar2 default hr_api.g_varchar2,

973: p_pds_information24 in varchar2 default hr_api.g_varchar2,
974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,
979: p_pds_information30 in varchar2 default hr_api.g_varchar2,
980: p_effective_date in date,
981: p_validate in boolean default false

Line 978: p_pds_information29 in varchar2 default hr_api.g_varchar2,

974: p_pds_information25 in varchar2 default hr_api.g_varchar2,
975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,
979: p_pds_information30 in varchar2 default hr_api.g_varchar2,
980: p_effective_date in date,
981: p_validate in boolean default false
982: ) is

Line 979: p_pds_information30 in varchar2 default hr_api.g_varchar2,

975: p_pds_information26 in varchar2 default hr_api.g_varchar2,
976: p_pds_information27 in varchar2 default hr_api.g_varchar2,
977: p_pds_information28 in varchar2 default hr_api.g_varchar2,
978: p_pds_information29 in varchar2 default hr_api.g_varchar2,
979: p_pds_information30 in varchar2 default hr_api.g_varchar2,
980: p_effective_date in date,
981: p_validate in boolean default false
982: ) is
983: --

Line 997: hr_api.g_number,

993: l_rec :=
994: per_pds_shd.convert_args
995: (
996: p_period_of_service_id,
997: hr_api.g_number,
998: p_termination_accepted_person,
999: hr_api.g_number,
1000: p_date_start,
1001: p_accepted_termination_date,

Line 999: hr_api.g_number,

995: (
996: p_period_of_service_id,
997: hr_api.g_number,
998: p_termination_accepted_person,
999: hr_api.g_number,
1000: p_date_start,
1001: p_accepted_termination_date,
1002: p_actual_termination_date,
1003: p_comments,