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_PAT_UPD dependencies on HR_API

Line 138: When hr_api.check_integrity_violated Then

134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: --
141: per_pat_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: --
141: per_pat_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: --
146: per_pat_shd.constraint_error

Line 143: When hr_api.parent_integrity_violated Then

139: -- A check constraint has been violated
140: --
141: per_pat_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: --
146: per_pat_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: --
146: per_pat_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: --
151: per_pat_shd.constraint_error

Line 148: When hr_api.unique_integrity_violated Then

144: -- Parent integrity has been violated
145: --
146: per_pat_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: --
151: per_pat_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: --
151: per_pat_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: --
155: Raise;
156: End update_dml;

Line 481: when hr_api.cannot_find_prog_unit then

477: );
478: --
479: exception
480: --
481: when hr_api.cannot_find_prog_unit then
482: --
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'PER_ALLOCATED_TASKS'
485: ,p_hook_type => 'AU');

Line 483: hr_api.cannot_find_prog_unit_error

479: exception
480: --
481: when hr_api.cannot_find_prog_unit then
482: --
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'PER_ALLOCATED_TASKS'
485: ,p_hook_type => 'AU');
486: --
487: end;

Line 546: If (p_rec.allocated_checklist_id = hr_api.g_number) then

542: -- p_rec plsql record structure
543: -- to see if a system default is being used. If a system default
544: -- is being used then we must set to the 'current' argument value.
545: --
546: If (p_rec.allocated_checklist_id = hr_api.g_number) then
547: p_rec.allocated_checklist_id :=
548: per_pat_shd.g_old_rec.allocated_checklist_id;
549: End If;
550: If (p_rec.task_name = hr_api.g_varchar2) then

Line 550: If (p_rec.task_name = hr_api.g_varchar2) then

546: If (p_rec.allocated_checklist_id = hr_api.g_number) then
547: p_rec.allocated_checklist_id :=
548: per_pat_shd.g_old_rec.allocated_checklist_id;
549: End If;
550: If (p_rec.task_name = hr_api.g_varchar2) then
551: p_rec.task_name :=
552: per_pat_shd.g_old_rec.task_name;
553: End If;
554: If (p_rec.description = hr_api.g_varchar2) then

Line 554: If (p_rec.description = hr_api.g_varchar2) then

550: If (p_rec.task_name = hr_api.g_varchar2) then
551: p_rec.task_name :=
552: per_pat_shd.g_old_rec.task_name;
553: End If;
554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_pat_shd.g_old_rec.description;
557: End If;
558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then

Line 558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then

554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_pat_shd.g_old_rec.description;
557: End If;
558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then
559: p_rec.performer_orig_system :=
560: per_pat_shd.g_old_rec.performer_orig_system;
561: End If;
562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then

Line 562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then

558: If (p_rec.performer_orig_system = hr_api.g_varchar2) then
559: p_rec.performer_orig_system :=
560: per_pat_shd.g_old_rec.performer_orig_system;
561: End If;
562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then
563: p_rec.performer_orig_sys_id :=
564: per_pat_shd.g_old_rec.performer_orig_sys_id;
565: End If;
566: If (p_rec.task_owner_person_id = hr_api.g_number) then

Line 566: If (p_rec.task_owner_person_id = hr_api.g_number) then

562: If (p_rec.performer_orig_sys_id = hr_api.g_number) then
563: p_rec.performer_orig_sys_id :=
564: per_pat_shd.g_old_rec.performer_orig_sys_id;
565: End If;
566: If (p_rec.task_owner_person_id = hr_api.g_number) then
567: p_rec.task_owner_person_id :=
568: per_pat_shd.g_old_rec.task_owner_person_id;
569: End If;
570: If (p_rec.task_sequence = hr_api.g_number) then

Line 570: If (p_rec.task_sequence = hr_api.g_number) then

566: If (p_rec.task_owner_person_id = hr_api.g_number) then
567: p_rec.task_owner_person_id :=
568: per_pat_shd.g_old_rec.task_owner_person_id;
569: End If;
570: If (p_rec.task_sequence = hr_api.g_number) then
571: p_rec.task_sequence :=
572: per_pat_shd.g_old_rec.task_sequence;
573: End If;
574: If (p_rec.target_start_date = hr_api.g_date) then

Line 574: If (p_rec.target_start_date = hr_api.g_date) then

570: If (p_rec.task_sequence = hr_api.g_number) then
571: p_rec.task_sequence :=
572: per_pat_shd.g_old_rec.task_sequence;
573: End If;
574: If (p_rec.target_start_date = hr_api.g_date) then
575: p_rec.target_start_date :=
576: per_pat_shd.g_old_rec.target_start_date;
577: End If;
578: If (p_rec.target_end_date = hr_api.g_date) then

Line 578: If (p_rec.target_end_date = hr_api.g_date) then

574: If (p_rec.target_start_date = hr_api.g_date) then
575: p_rec.target_start_date :=
576: per_pat_shd.g_old_rec.target_start_date;
577: End If;
578: If (p_rec.target_end_date = hr_api.g_date) then
579: p_rec.target_end_date :=
580: per_pat_shd.g_old_rec.target_end_date;
581: End If;
582: If (p_rec.actual_start_date = hr_api.g_date) then

Line 582: If (p_rec.actual_start_date = hr_api.g_date) then

578: If (p_rec.target_end_date = hr_api.g_date) then
579: p_rec.target_end_date :=
580: per_pat_shd.g_old_rec.target_end_date;
581: End If;
582: If (p_rec.actual_start_date = hr_api.g_date) then
583: p_rec.actual_start_date :=
584: per_pat_shd.g_old_rec.actual_start_date;
585: End If;
586: If (p_rec.actual_end_date = hr_api.g_date) then

Line 586: If (p_rec.actual_end_date = hr_api.g_date) then

582: If (p_rec.actual_start_date = hr_api.g_date) then
583: p_rec.actual_start_date :=
584: per_pat_shd.g_old_rec.actual_start_date;
585: End If;
586: If (p_rec.actual_end_date = hr_api.g_date) then
587: p_rec.actual_end_date :=
588: per_pat_shd.g_old_rec.actual_end_date;
589: End If;
590: If (p_rec.action_url = hr_api.g_varchar2) then

Line 590: If (p_rec.action_url = hr_api.g_varchar2) then

586: If (p_rec.actual_end_date = hr_api.g_date) then
587: p_rec.actual_end_date :=
588: per_pat_shd.g_old_rec.actual_end_date;
589: End If;
590: If (p_rec.action_url = hr_api.g_varchar2) then
591: p_rec.action_url :=
592: per_pat_shd.g_old_rec.action_url;
593: End If;
594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

Line 594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

590: If (p_rec.action_url = hr_api.g_varchar2) then
591: p_rec.action_url :=
592: per_pat_shd.g_old_rec.action_url;
593: End If;
594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
595: p_rec.mandatory_flag :=
596: per_pat_shd.g_old_rec.mandatory_flag;
597: End If;
598: If (p_rec.status = hr_api.g_varchar2) then

Line 598: If (p_rec.status = hr_api.g_varchar2) then

594: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
595: p_rec.mandatory_flag :=
596: per_pat_shd.g_old_rec.mandatory_flag;
597: End If;
598: If (p_rec.status = hr_api.g_varchar2) then
599: p_rec.status :=
600: per_pat_shd.g_old_rec.status;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

598: If (p_rec.status = hr_api.g_varchar2) then
599: p_rec.status :=
600: per_pat_shd.g_old_rec.status;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_pat_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_pat_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_pat_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_pat_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_pat_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_pat_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_pat_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_pat_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_pat_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_pat_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_pat_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_pat_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_pat_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_pat_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_pat_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_pat_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_pat_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_pat_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_pat_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_pat_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_pat_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_pat_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_pat_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_pat_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_pat_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_pat_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_pat_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_pat_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_pat_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_pat_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_pat_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_pat_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_pat_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_pat_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_pat_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_pat_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_pat_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_pat_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_pat_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_pat_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_pat_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.information_category = hr_api.g_varchar2) then

Line 686: If (p_rec.information_category = hr_api.g_varchar2) then

682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_pat_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.information_category = hr_api.g_varchar2) then
687: p_rec.information_category :=
688: per_pat_shd.g_old_rec.information_category;
689: End If;
690: If (p_rec.information1 = hr_api.g_varchar2) then

Line 690: If (p_rec.information1 = hr_api.g_varchar2) then

686: If (p_rec.information_category = hr_api.g_varchar2) then
687: p_rec.information_category :=
688: per_pat_shd.g_old_rec.information_category;
689: End If;
690: If (p_rec.information1 = hr_api.g_varchar2) then
691: p_rec.information1 :=
692: per_pat_shd.g_old_rec.information1;
693: End If;
694: If (p_rec.information2 = hr_api.g_varchar2) then

Line 694: If (p_rec.information2 = hr_api.g_varchar2) then

690: If (p_rec.information1 = hr_api.g_varchar2) then
691: p_rec.information1 :=
692: per_pat_shd.g_old_rec.information1;
693: End If;
694: If (p_rec.information2 = hr_api.g_varchar2) then
695: p_rec.information2 :=
696: per_pat_shd.g_old_rec.information2;
697: End If;
698: If (p_rec.information3 = hr_api.g_varchar2) then

Line 698: If (p_rec.information3 = hr_api.g_varchar2) then

694: If (p_rec.information2 = hr_api.g_varchar2) then
695: p_rec.information2 :=
696: per_pat_shd.g_old_rec.information2;
697: End If;
698: If (p_rec.information3 = hr_api.g_varchar2) then
699: p_rec.information3 :=
700: per_pat_shd.g_old_rec.information3;
701: End If;
702: If (p_rec.information4 = hr_api.g_varchar2) then

Line 702: If (p_rec.information4 = hr_api.g_varchar2) then

698: If (p_rec.information3 = hr_api.g_varchar2) then
699: p_rec.information3 :=
700: per_pat_shd.g_old_rec.information3;
701: End If;
702: If (p_rec.information4 = hr_api.g_varchar2) then
703: p_rec.information4 :=
704: per_pat_shd.g_old_rec.information4;
705: End If;
706: If (p_rec.information5 = hr_api.g_varchar2) then

Line 706: If (p_rec.information5 = hr_api.g_varchar2) then

702: If (p_rec.information4 = hr_api.g_varchar2) then
703: p_rec.information4 :=
704: per_pat_shd.g_old_rec.information4;
705: End If;
706: If (p_rec.information5 = hr_api.g_varchar2) then
707: p_rec.information5 :=
708: per_pat_shd.g_old_rec.information5;
709: End If;
710: If (p_rec.information6 = hr_api.g_varchar2) then

Line 710: If (p_rec.information6 = hr_api.g_varchar2) then

706: If (p_rec.information5 = hr_api.g_varchar2) then
707: p_rec.information5 :=
708: per_pat_shd.g_old_rec.information5;
709: End If;
710: If (p_rec.information6 = hr_api.g_varchar2) then
711: p_rec.information6 :=
712: per_pat_shd.g_old_rec.information6;
713: End If;
714: If (p_rec.information7 = hr_api.g_varchar2) then

Line 714: If (p_rec.information7 = hr_api.g_varchar2) then

710: If (p_rec.information6 = hr_api.g_varchar2) then
711: p_rec.information6 :=
712: per_pat_shd.g_old_rec.information6;
713: End If;
714: If (p_rec.information7 = hr_api.g_varchar2) then
715: p_rec.information7 :=
716: per_pat_shd.g_old_rec.information7;
717: End If;
718: If (p_rec.information8 = hr_api.g_varchar2) then

Line 718: If (p_rec.information8 = hr_api.g_varchar2) then

714: If (p_rec.information7 = hr_api.g_varchar2) then
715: p_rec.information7 :=
716: per_pat_shd.g_old_rec.information7;
717: End If;
718: If (p_rec.information8 = hr_api.g_varchar2) then
719: p_rec.information8 :=
720: per_pat_shd.g_old_rec.information8;
721: End If;
722: If (p_rec.information9 = hr_api.g_varchar2) then

Line 722: If (p_rec.information9 = hr_api.g_varchar2) then

718: If (p_rec.information8 = hr_api.g_varchar2) then
719: p_rec.information8 :=
720: per_pat_shd.g_old_rec.information8;
721: End If;
722: If (p_rec.information9 = hr_api.g_varchar2) then
723: p_rec.information9 :=
724: per_pat_shd.g_old_rec.information9;
725: End If;
726: If (p_rec.information10 = hr_api.g_varchar2) then

Line 726: If (p_rec.information10 = hr_api.g_varchar2) then

722: If (p_rec.information9 = hr_api.g_varchar2) then
723: p_rec.information9 :=
724: per_pat_shd.g_old_rec.information9;
725: End If;
726: If (p_rec.information10 = hr_api.g_varchar2) then
727: p_rec.information10 :=
728: per_pat_shd.g_old_rec.information10;
729: End If;
730: If (p_rec.information11 = hr_api.g_varchar2) then

Line 730: If (p_rec.information11 = hr_api.g_varchar2) then

726: If (p_rec.information10 = hr_api.g_varchar2) then
727: p_rec.information10 :=
728: per_pat_shd.g_old_rec.information10;
729: End If;
730: If (p_rec.information11 = hr_api.g_varchar2) then
731: p_rec.information11 :=
732: per_pat_shd.g_old_rec.information11;
733: End If;
734: If (p_rec.information12 = hr_api.g_varchar2) then

Line 734: If (p_rec.information12 = hr_api.g_varchar2) then

730: If (p_rec.information11 = hr_api.g_varchar2) then
731: p_rec.information11 :=
732: per_pat_shd.g_old_rec.information11;
733: End If;
734: If (p_rec.information12 = hr_api.g_varchar2) then
735: p_rec.information12 :=
736: per_pat_shd.g_old_rec.information12;
737: End If;
738: If (p_rec.information13 = hr_api.g_varchar2) then

Line 738: If (p_rec.information13 = hr_api.g_varchar2) then

734: If (p_rec.information12 = hr_api.g_varchar2) then
735: p_rec.information12 :=
736: per_pat_shd.g_old_rec.information12;
737: End If;
738: If (p_rec.information13 = hr_api.g_varchar2) then
739: p_rec.information13 :=
740: per_pat_shd.g_old_rec.information13;
741: End If;
742: If (p_rec.information14 = hr_api.g_varchar2) then

Line 742: If (p_rec.information14 = hr_api.g_varchar2) then

738: If (p_rec.information13 = hr_api.g_varchar2) then
739: p_rec.information13 :=
740: per_pat_shd.g_old_rec.information13;
741: End If;
742: If (p_rec.information14 = hr_api.g_varchar2) then
743: p_rec.information14 :=
744: per_pat_shd.g_old_rec.information14;
745: End If;
746: If (p_rec.information15 = hr_api.g_varchar2) then

Line 746: If (p_rec.information15 = hr_api.g_varchar2) then

742: If (p_rec.information14 = hr_api.g_varchar2) then
743: p_rec.information14 :=
744: per_pat_shd.g_old_rec.information14;
745: End If;
746: If (p_rec.information15 = hr_api.g_varchar2) then
747: p_rec.information15 :=
748: per_pat_shd.g_old_rec.information15;
749: End If;
750: If (p_rec.information16 = hr_api.g_varchar2) then

Line 750: If (p_rec.information16 = hr_api.g_varchar2) then

746: If (p_rec.information15 = hr_api.g_varchar2) then
747: p_rec.information15 :=
748: per_pat_shd.g_old_rec.information15;
749: End If;
750: If (p_rec.information16 = hr_api.g_varchar2) then
751: p_rec.information16 :=
752: per_pat_shd.g_old_rec.information16;
753: End If;
754: If (p_rec.information17 = hr_api.g_varchar2) then

Line 754: If (p_rec.information17 = hr_api.g_varchar2) then

750: If (p_rec.information16 = hr_api.g_varchar2) then
751: p_rec.information16 :=
752: per_pat_shd.g_old_rec.information16;
753: End If;
754: If (p_rec.information17 = hr_api.g_varchar2) then
755: p_rec.information17 :=
756: per_pat_shd.g_old_rec.information17;
757: End If;
758: If (p_rec.information18 = hr_api.g_varchar2) then

Line 758: If (p_rec.information18 = hr_api.g_varchar2) then

754: If (p_rec.information17 = hr_api.g_varchar2) then
755: p_rec.information17 :=
756: per_pat_shd.g_old_rec.information17;
757: End If;
758: If (p_rec.information18 = hr_api.g_varchar2) then
759: p_rec.information18 :=
760: per_pat_shd.g_old_rec.information18;
761: End If;
762: If (p_rec.information19 = hr_api.g_varchar2) then

Line 762: If (p_rec.information19 = hr_api.g_varchar2) then

758: If (p_rec.information18 = hr_api.g_varchar2) then
759: p_rec.information18 :=
760: per_pat_shd.g_old_rec.information18;
761: End If;
762: If (p_rec.information19 = hr_api.g_varchar2) then
763: p_rec.information19 :=
764: per_pat_shd.g_old_rec.information19;
765: End If;
766: If (p_rec.information20 = hr_api.g_varchar2) then

Line 766: If (p_rec.information20 = hr_api.g_varchar2) then

762: If (p_rec.information19 = hr_api.g_varchar2) then
763: p_rec.information19 :=
764: per_pat_shd.g_old_rec.information19;
765: End If;
766: If (p_rec.information20 = hr_api.g_varchar2) then
767: p_rec.information20 :=
768: per_pat_shd.g_old_rec.information20;
769: End If;
770: --

Line 834: ,p_allocated_checklist_id in number default hr_api.g_number

830: Procedure upd
831: (p_effective_date in date
832: ,p_allocated_task_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_allocated_checklist_id in number default hr_api.g_number
835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number

Line 835: ,p_task_name in varchar2 default hr_api.g_varchar2

831: (p_effective_date in date
832: ,p_allocated_task_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_allocated_checklist_id in number default hr_api.g_number
835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number

Line 836: ,p_description in varchar2 default hr_api.g_varchar2

832: ,p_allocated_task_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_allocated_checklist_id in number default hr_api.g_number
835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number

Line 837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2

833: ,p_object_version_number in out nocopy number
834: ,p_allocated_checklist_id in number default hr_api.g_number
835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date

Line 838: ,p_performer_orig_sys_id in number default hr_api.g_number

834: ,p_allocated_checklist_id in number default hr_api.g_number
835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date

Line 839: ,p_task_owner_person_id in number default hr_api.g_number

835: ,p_task_name in varchar2 default hr_api.g_varchar2
836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date

Line 840: ,p_task_sequence in number default hr_api.g_number

836: ,p_description in varchar2 default hr_api.g_varchar2
837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date

Line 841: ,p_target_start_date in date default hr_api.g_date

837: ,p_performer_orig_system in varchar2 default hr_api.g_varchar2
838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2

Line 842: ,p_target_end_date in date default hr_api.g_date

838: ,p_performer_orig_sys_id in number default hr_api.g_number
839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

Line 843: ,p_actual_start_date in date default hr_api.g_date

839: ,p_task_owner_person_id in number default hr_api.g_number
840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2

Line 844: ,p_actual_end_date in date default hr_api.g_date

840: ,p_task_sequence in number default hr_api.g_number
841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 845: ,p_action_url in varchar2 default hr_api.g_varchar2

841: ,p_target_start_date in date default hr_api.g_date
842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

842: ,p_target_end_date in date default hr_api.g_date
843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 847: ,p_status in varchar2 default hr_api.g_varchar2

843: ,p_actual_start_date in date default hr_api.g_date
844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 848: ,p_attribute_category in varchar2 default hr_api.g_varchar2

844: ,p_actual_end_date in date default hr_api.g_date
845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 849: ,p_attribute1 in varchar2 default hr_api.g_varchar2

845: ,p_action_url in varchar2 default hr_api.g_varchar2
846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 850: ,p_attribute2 in varchar2 default hr_api.g_varchar2

846: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 851: ,p_attribute3 in varchar2 default hr_api.g_varchar2

847: ,p_status in varchar2 default hr_api.g_varchar2
848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 852: ,p_attribute4 in varchar2 default hr_api.g_varchar2

848: ,p_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 853: ,p_attribute5 in varchar2 default hr_api.g_varchar2

849: ,p_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 854: ,p_attribute6 in varchar2 default hr_api.g_varchar2

850: ,p_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 855: ,p_attribute7 in varchar2 default hr_api.g_varchar2

851: ,p_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 856: ,p_attribute8 in varchar2 default hr_api.g_varchar2

852: ,p_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 857: ,p_attribute9 in varchar2 default hr_api.g_varchar2

853: ,p_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 858: ,p_attribute10 in varchar2 default hr_api.g_varchar2

854: ,p_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 859: ,p_attribute11 in varchar2 default hr_api.g_varchar2

855: ,p_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 860: ,p_attribute12 in varchar2 default hr_api.g_varchar2

856: ,p_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 861: ,p_attribute13 in varchar2 default hr_api.g_varchar2

857: ,p_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 862: ,p_attribute14 in varchar2 default hr_api.g_varchar2

858: ,p_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 863: ,p_attribute15 in varchar2 default hr_api.g_varchar2

859: ,p_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 864: ,p_attribute16 in varchar2 default hr_api.g_varchar2

860: ,p_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 865: ,p_attribute17 in varchar2 default hr_api.g_varchar2

861: ,p_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 866: ,p_attribute18 in varchar2 default hr_api.g_varchar2

862: ,p_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 867: ,p_attribute19 in varchar2 default hr_api.g_varchar2

863: ,p_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 868: ,p_attribute20 in varchar2 default hr_api.g_varchar2

864: ,p_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 869: ,p_information_category in varchar2 default hr_api.g_varchar2

865: ,p_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 870: ,p_information1 in varchar2 default hr_api.g_varchar2

866: ,p_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 871: ,p_information2 in varchar2 default hr_api.g_varchar2

867: ,p_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 872: ,p_information3 in varchar2 default hr_api.g_varchar2

868: ,p_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 873: ,p_information4 in varchar2 default hr_api.g_varchar2

869: ,p_information_category in varchar2 default hr_api.g_varchar2
870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 874: ,p_information5 in varchar2 default hr_api.g_varchar2

870: ,p_information1 in varchar2 default hr_api.g_varchar2
871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 875: ,p_information6 in varchar2 default hr_api.g_varchar2

871: ,p_information2 in varchar2 default hr_api.g_varchar2
872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 876: ,p_information7 in varchar2 default hr_api.g_varchar2

872: ,p_information3 in varchar2 default hr_api.g_varchar2
873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 877: ,p_information8 in varchar2 default hr_api.g_varchar2

873: ,p_information4 in varchar2 default hr_api.g_varchar2
874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 878: ,p_information9 in varchar2 default hr_api.g_varchar2

874: ,p_information5 in varchar2 default hr_api.g_varchar2
875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 879: ,p_information10 in varchar2 default hr_api.g_varchar2

875: ,p_information6 in varchar2 default hr_api.g_varchar2
876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 880: ,p_information11 in varchar2 default hr_api.g_varchar2

876: ,p_information7 in varchar2 default hr_api.g_varchar2
877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 881: ,p_information12 in varchar2 default hr_api.g_varchar2

877: ,p_information8 in varchar2 default hr_api.g_varchar2
878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 882: ,p_information13 in varchar2 default hr_api.g_varchar2

878: ,p_information9 in varchar2 default hr_api.g_varchar2
879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 883: ,p_information14 in varchar2 default hr_api.g_varchar2

879: ,p_information10 in varchar2 default hr_api.g_varchar2
880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 884: ,p_information15 in varchar2 default hr_api.g_varchar2

880: ,p_information11 in varchar2 default hr_api.g_varchar2
881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 885: ,p_information16 in varchar2 default hr_api.g_varchar2

881: ,p_information12 in varchar2 default hr_api.g_varchar2
882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 886: ,p_information17 in varchar2 default hr_api.g_varchar2

882: ,p_information13 in varchar2 default hr_api.g_varchar2
883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2
890: ) is

Line 887: ,p_information18 in varchar2 default hr_api.g_varchar2

883: ,p_information14 in varchar2 default hr_api.g_varchar2
884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2
890: ) is
891: --

Line 888: ,p_information19 in varchar2 default hr_api.g_varchar2

884: ,p_information15 in varchar2 default hr_api.g_varchar2
885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2
890: ) is
891: --
892: l_rec per_pat_shd.g_rec_type;

Line 889: ,p_information20 in varchar2 default hr_api.g_varchar2

885: ,p_information16 in varchar2 default hr_api.g_varchar2
886: ,p_information17 in varchar2 default hr_api.g_varchar2
887: ,p_information18 in varchar2 default hr_api.g_varchar2
888: ,p_information19 in varchar2 default hr_api.g_varchar2
889: ,p_information20 in varchar2 default hr_api.g_varchar2
890: ) is
891: --
892: l_rec per_pat_shd.g_rec_type;
893: l_proc varchar2(72) := g_package||'upd';