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

Line 140: When hr_api.check_integrity_violated Then

136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error

Line 145: When hr_api.parent_integrity_violated Then

141: -- A check constraint has been violated
142: per_abb_shd.g_api_dml := false; -- Unset the api dml status
143: per_abb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error

Line 150: When hr_api.unique_integrity_violated Then

146: -- Parent integrity has been violated
147: per_abb_shd.g_api_dml := false; -- Unset the api dml status
148: per_abb_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: per_abb_shd.g_api_dml := false; -- Unset the api dml status
153: per_abb_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: per_abb_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;

Line 497: when hr_api.cannot_find_prog_unit then

493: );
494: --
495: exception
496: --
497: when hr_api.cannot_find_prog_unit then
498: --
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'PER_ABSENCE_ATTENDANCE_TYPES'
501: ,p_hook_type => 'AU');

Line 499: hr_api.cannot_find_prog_unit_error

495: exception
496: --
497: when hr_api.cannot_find_prog_unit then
498: --
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'PER_ABSENCE_ATTENDANCE_TYPES'
501: ,p_hook_type => 'AU');
502: --
503: end;

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

558: -- p_rec plsql record structure
559: -- to see if a system default is being used. If a system default
560: -- is being used then we must set to the 'current' argument value.
561: --
562: If (p_rec.business_group_id = hr_api.g_number) then
563: p_rec.business_group_id :=
564: per_abb_shd.g_old_rec.business_group_id;
565: End If;
566: If (p_rec.input_value_id = hr_api.g_number) then

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

562: If (p_rec.business_group_id = hr_api.g_number) then
563: p_rec.business_group_id :=
564: per_abb_shd.g_old_rec.business_group_id;
565: End If;
566: If (p_rec.input_value_id = hr_api.g_number) then
567: p_rec.input_value_id :=
568: per_abb_shd.g_old_rec.input_value_id;
569: End If;
570: If (p_rec.date_effective = hr_api.g_date) then

Line 570: If (p_rec.date_effective = hr_api.g_date) then

566: If (p_rec.input_value_id = hr_api.g_number) then
567: p_rec.input_value_id :=
568: per_abb_shd.g_old_rec.input_value_id;
569: End If;
570: If (p_rec.date_effective = hr_api.g_date) then
571: p_rec.date_effective :=
572: per_abb_shd.g_old_rec.date_effective;
573: End If;
574: If (p_rec.name = hr_api.g_varchar2) then

Line 574: If (p_rec.name = hr_api.g_varchar2) then

570: If (p_rec.date_effective = hr_api.g_date) then
571: p_rec.date_effective :=
572: per_abb_shd.g_old_rec.date_effective;
573: End If;
574: If (p_rec.name = hr_api.g_varchar2) then
575: p_rec.name :=
576: per_abb_shd.g_old_rec.name;
577: End If;
578: If (p_rec.absence_category = hr_api.g_varchar2) then

Line 578: If (p_rec.absence_category = hr_api.g_varchar2) then

574: If (p_rec.name = hr_api.g_varchar2) then
575: p_rec.name :=
576: per_abb_shd.g_old_rec.name;
577: End If;
578: If (p_rec.absence_category = hr_api.g_varchar2) then
579: p_rec.absence_category :=
580: per_abb_shd.g_old_rec.absence_category;
581: End If;
582: If (p_rec.comments = hr_api.g_varchar2) then

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

578: If (p_rec.absence_category = hr_api.g_varchar2) then
579: p_rec.absence_category :=
580: per_abb_shd.g_old_rec.absence_category;
581: End If;
582: If (p_rec.comments = hr_api.g_varchar2) then
583: p_rec.comments :=
584: per_abb_shd.g_old_rec.comments;
585: End If;
586: If (p_rec.hours_or_days = hr_api.g_varchar2) then

Line 586: If (p_rec.hours_or_days = hr_api.g_varchar2) then

582: If (p_rec.comments = hr_api.g_varchar2) then
583: p_rec.comments :=
584: per_abb_shd.g_old_rec.comments;
585: End If;
586: If (p_rec.hours_or_days = hr_api.g_varchar2) then
587: p_rec.hours_or_days :=
588: per_abb_shd.g_old_rec.hours_or_days;
589: End If;
590: If (p_rec.increasing_or_decreasing_flag = hr_api.g_varchar2) then

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

586: If (p_rec.hours_or_days = hr_api.g_varchar2) then
587: p_rec.hours_or_days :=
588: per_abb_shd.g_old_rec.hours_or_days;
589: End If;
590: If (p_rec.increasing_or_decreasing_flag = hr_api.g_varchar2) then
591: p_rec.increasing_or_decreasing_flag :=
592: per_abb_shd.g_old_rec.increasing_or_decreasing_flag;
593: End If;
594: If (p_rec.request_id = hr_api.g_number) then

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

590: If (p_rec.increasing_or_decreasing_flag = hr_api.g_varchar2) then
591: p_rec.increasing_or_decreasing_flag :=
592: per_abb_shd.g_old_rec.increasing_or_decreasing_flag;
593: End If;
594: If (p_rec.request_id = hr_api.g_number) then
595: p_rec.request_id :=
596: per_abb_shd.g_old_rec.request_id;
597: End If;
598: If (p_rec.program_application_id = hr_api.g_number) then

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

594: If (p_rec.request_id = hr_api.g_number) then
595: p_rec.request_id :=
596: per_abb_shd.g_old_rec.request_id;
597: End If;
598: If (p_rec.program_application_id = hr_api.g_number) then
599: p_rec.program_application_id :=
600: per_abb_shd.g_old_rec.program_application_id;
601: End If;
602: If (p_rec.program_id = hr_api.g_number) then

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

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

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

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

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

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

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

610: If (p_rec.attribute_category = hr_api.g_varchar2) then
611: p_rec.attribute_category :=
612: per_abb_shd.g_old_rec.attribute_category;
613: End If;
614: If (p_rec.attribute1 = hr_api.g_varchar2) then
615: p_rec.attribute1 :=
616: per_abb_shd.g_old_rec.attribute1;
617: End If;
618: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

614: If (p_rec.attribute1 = hr_api.g_varchar2) then
615: p_rec.attribute1 :=
616: per_abb_shd.g_old_rec.attribute1;
617: End If;
618: If (p_rec.attribute2 = hr_api.g_varchar2) then
619: p_rec.attribute2 :=
620: per_abb_shd.g_old_rec.attribute2;
621: End If;
622: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

618: If (p_rec.attribute2 = hr_api.g_varchar2) then
619: p_rec.attribute2 :=
620: per_abb_shd.g_old_rec.attribute2;
621: End If;
622: If (p_rec.attribute3 = hr_api.g_varchar2) then
623: p_rec.attribute3 :=
624: per_abb_shd.g_old_rec.attribute3;
625: End If;
626: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

622: If (p_rec.attribute3 = hr_api.g_varchar2) then
623: p_rec.attribute3 :=
624: per_abb_shd.g_old_rec.attribute3;
625: End If;
626: If (p_rec.attribute4 = hr_api.g_varchar2) then
627: p_rec.attribute4 :=
628: per_abb_shd.g_old_rec.attribute4;
629: End If;
630: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

626: If (p_rec.attribute4 = hr_api.g_varchar2) then
627: p_rec.attribute4 :=
628: per_abb_shd.g_old_rec.attribute4;
629: End If;
630: If (p_rec.attribute5 = hr_api.g_varchar2) then
631: p_rec.attribute5 :=
632: per_abb_shd.g_old_rec.attribute5;
633: End If;
634: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

630: If (p_rec.attribute5 = hr_api.g_varchar2) then
631: p_rec.attribute5 :=
632: per_abb_shd.g_old_rec.attribute5;
633: End If;
634: If (p_rec.attribute6 = hr_api.g_varchar2) then
635: p_rec.attribute6 :=
636: per_abb_shd.g_old_rec.attribute6;
637: End If;
638: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

634: If (p_rec.attribute6 = hr_api.g_varchar2) then
635: p_rec.attribute6 :=
636: per_abb_shd.g_old_rec.attribute6;
637: End If;
638: If (p_rec.attribute7 = hr_api.g_varchar2) then
639: p_rec.attribute7 :=
640: per_abb_shd.g_old_rec.attribute7;
641: End If;
642: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

638: If (p_rec.attribute7 = hr_api.g_varchar2) then
639: p_rec.attribute7 :=
640: per_abb_shd.g_old_rec.attribute7;
641: End If;
642: If (p_rec.attribute8 = hr_api.g_varchar2) then
643: p_rec.attribute8 :=
644: per_abb_shd.g_old_rec.attribute8;
645: End If;
646: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

642: If (p_rec.attribute8 = hr_api.g_varchar2) then
643: p_rec.attribute8 :=
644: per_abb_shd.g_old_rec.attribute8;
645: End If;
646: If (p_rec.attribute9 = hr_api.g_varchar2) then
647: p_rec.attribute9 :=
648: per_abb_shd.g_old_rec.attribute9;
649: End If;
650: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

646: If (p_rec.attribute9 = hr_api.g_varchar2) then
647: p_rec.attribute9 :=
648: per_abb_shd.g_old_rec.attribute9;
649: End If;
650: If (p_rec.attribute10 = hr_api.g_varchar2) then
651: p_rec.attribute10 :=
652: per_abb_shd.g_old_rec.attribute10;
653: End If;
654: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

650: If (p_rec.attribute10 = hr_api.g_varchar2) then
651: p_rec.attribute10 :=
652: per_abb_shd.g_old_rec.attribute10;
653: End If;
654: If (p_rec.attribute11 = hr_api.g_varchar2) then
655: p_rec.attribute11 :=
656: per_abb_shd.g_old_rec.attribute11;
657: End If;
658: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

654: If (p_rec.attribute11 = hr_api.g_varchar2) then
655: p_rec.attribute11 :=
656: per_abb_shd.g_old_rec.attribute11;
657: End If;
658: If (p_rec.attribute12 = hr_api.g_varchar2) then
659: p_rec.attribute12 :=
660: per_abb_shd.g_old_rec.attribute12;
661: End If;
662: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

658: If (p_rec.attribute12 = hr_api.g_varchar2) then
659: p_rec.attribute12 :=
660: per_abb_shd.g_old_rec.attribute12;
661: End If;
662: If (p_rec.attribute13 = hr_api.g_varchar2) then
663: p_rec.attribute13 :=
664: per_abb_shd.g_old_rec.attribute13;
665: End If;
666: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

662: If (p_rec.attribute13 = hr_api.g_varchar2) then
663: p_rec.attribute13 :=
664: per_abb_shd.g_old_rec.attribute13;
665: End If;
666: If (p_rec.attribute14 = hr_api.g_varchar2) then
667: p_rec.attribute14 :=
668: per_abb_shd.g_old_rec.attribute14;
669: End If;
670: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

666: If (p_rec.attribute14 = hr_api.g_varchar2) then
667: p_rec.attribute14 :=
668: per_abb_shd.g_old_rec.attribute14;
669: End If;
670: If (p_rec.attribute15 = hr_api.g_varchar2) then
671: p_rec.attribute15 :=
672: per_abb_shd.g_old_rec.attribute15;
673: End If;
674: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

670: If (p_rec.attribute15 = hr_api.g_varchar2) then
671: p_rec.attribute15 :=
672: per_abb_shd.g_old_rec.attribute15;
673: End If;
674: If (p_rec.attribute16 = hr_api.g_varchar2) then
675: p_rec.attribute16 :=
676: per_abb_shd.g_old_rec.attribute16;
677: End If;
678: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

674: If (p_rec.attribute16 = hr_api.g_varchar2) then
675: p_rec.attribute16 :=
676: per_abb_shd.g_old_rec.attribute16;
677: End If;
678: If (p_rec.attribute17 = hr_api.g_varchar2) then
679: p_rec.attribute17 :=
680: per_abb_shd.g_old_rec.attribute17;
681: End If;
682: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

678: If (p_rec.attribute17 = hr_api.g_varchar2) then
679: p_rec.attribute17 :=
680: per_abb_shd.g_old_rec.attribute17;
681: End If;
682: If (p_rec.attribute18 = hr_api.g_varchar2) then
683: p_rec.attribute18 :=
684: per_abb_shd.g_old_rec.attribute18;
685: End If;
686: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

682: If (p_rec.attribute18 = hr_api.g_varchar2) then
683: p_rec.attribute18 :=
684: per_abb_shd.g_old_rec.attribute18;
685: End If;
686: If (p_rec.attribute19 = hr_api.g_varchar2) then
687: p_rec.attribute19 :=
688: per_abb_shd.g_old_rec.attribute19;
689: End If;
690: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

686: If (p_rec.attribute19 = hr_api.g_varchar2) then
687: p_rec.attribute19 :=
688: per_abb_shd.g_old_rec.attribute19;
689: End If;
690: If (p_rec.attribute20 = hr_api.g_varchar2) then
691: p_rec.attribute20 :=
692: per_abb_shd.g_old_rec.attribute20;
693: End If;
694: If (p_rec.information_category = hr_api.g_varchar2) then

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

690: If (p_rec.attribute20 = hr_api.g_varchar2) then
691: p_rec.attribute20 :=
692: per_abb_shd.g_old_rec.attribute20;
693: End If;
694: If (p_rec.information_category = hr_api.g_varchar2) then
695: p_rec.information_category :=
696: per_abb_shd.g_old_rec.information_category;
697: End If;
698: If (p_rec.information1 = hr_api.g_varchar2) then

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

694: If (p_rec.information_category = hr_api.g_varchar2) then
695: p_rec.information_category :=
696: per_abb_shd.g_old_rec.information_category;
697: End If;
698: If (p_rec.information1 = hr_api.g_varchar2) then
699: p_rec.information1 :=
700: per_abb_shd.g_old_rec.information1;
701: End If;
702: If (p_rec.information2 = hr_api.g_varchar2) then

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

698: If (p_rec.information1 = hr_api.g_varchar2) then
699: p_rec.information1 :=
700: per_abb_shd.g_old_rec.information1;
701: End If;
702: If (p_rec.information2 = hr_api.g_varchar2) then
703: p_rec.information2 :=
704: per_abb_shd.g_old_rec.information2;
705: End If;
706: If (p_rec.information3 = hr_api.g_varchar2) then

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

702: If (p_rec.information2 = hr_api.g_varchar2) then
703: p_rec.information2 :=
704: per_abb_shd.g_old_rec.information2;
705: End If;
706: If (p_rec.information3 = hr_api.g_varchar2) then
707: p_rec.information3 :=
708: per_abb_shd.g_old_rec.information3;
709: End If;
710: If (p_rec.information4 = hr_api.g_varchar2) then

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

706: If (p_rec.information3 = hr_api.g_varchar2) then
707: p_rec.information3 :=
708: per_abb_shd.g_old_rec.information3;
709: End If;
710: If (p_rec.information4 = hr_api.g_varchar2) then
711: p_rec.information4 :=
712: per_abb_shd.g_old_rec.information4;
713: End If;
714: If (p_rec.information5 = hr_api.g_varchar2) then

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

710: If (p_rec.information4 = hr_api.g_varchar2) then
711: p_rec.information4 :=
712: per_abb_shd.g_old_rec.information4;
713: End If;
714: If (p_rec.information5 = hr_api.g_varchar2) then
715: p_rec.information5 :=
716: per_abb_shd.g_old_rec.information5;
717: End If;
718: If (p_rec.information6 = hr_api.g_varchar2) then

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

714: If (p_rec.information5 = hr_api.g_varchar2) then
715: p_rec.information5 :=
716: per_abb_shd.g_old_rec.information5;
717: End If;
718: If (p_rec.information6 = hr_api.g_varchar2) then
719: p_rec.information6 :=
720: per_abb_shd.g_old_rec.information6;
721: End If;
722: If (p_rec.information7 = hr_api.g_varchar2) then

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

718: If (p_rec.information6 = hr_api.g_varchar2) then
719: p_rec.information6 :=
720: per_abb_shd.g_old_rec.information6;
721: End If;
722: If (p_rec.information7 = hr_api.g_varchar2) then
723: p_rec.information7 :=
724: per_abb_shd.g_old_rec.information7;
725: End If;
726: If (p_rec.information8 = hr_api.g_varchar2) then

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

722: If (p_rec.information7 = hr_api.g_varchar2) then
723: p_rec.information7 :=
724: per_abb_shd.g_old_rec.information7;
725: End If;
726: If (p_rec.information8 = hr_api.g_varchar2) then
727: p_rec.information8 :=
728: per_abb_shd.g_old_rec.information8;
729: End If;
730: If (p_rec.information9 = hr_api.g_varchar2) then

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

726: If (p_rec.information8 = hr_api.g_varchar2) then
727: p_rec.information8 :=
728: per_abb_shd.g_old_rec.information8;
729: End If;
730: If (p_rec.information9 = hr_api.g_varchar2) then
731: p_rec.information9 :=
732: per_abb_shd.g_old_rec.information9;
733: End If;
734: If (p_rec.information10 = hr_api.g_varchar2) then

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

730: If (p_rec.information9 = hr_api.g_varchar2) then
731: p_rec.information9 :=
732: per_abb_shd.g_old_rec.information9;
733: End If;
734: If (p_rec.information10 = hr_api.g_varchar2) then
735: p_rec.information10 :=
736: per_abb_shd.g_old_rec.information10;
737: End If;
738: If (p_rec.information11 = hr_api.g_varchar2) then

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

734: If (p_rec.information10 = hr_api.g_varchar2) then
735: p_rec.information10 :=
736: per_abb_shd.g_old_rec.information10;
737: End If;
738: If (p_rec.information11 = hr_api.g_varchar2) then
739: p_rec.information11 :=
740: per_abb_shd.g_old_rec.information11;
741: End If;
742: If (p_rec.information12 = hr_api.g_varchar2) then

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

738: If (p_rec.information11 = hr_api.g_varchar2) then
739: p_rec.information11 :=
740: per_abb_shd.g_old_rec.information11;
741: End If;
742: If (p_rec.information12 = hr_api.g_varchar2) then
743: p_rec.information12 :=
744: per_abb_shd.g_old_rec.information12;
745: End If;
746: If (p_rec.information13 = hr_api.g_varchar2) then

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

742: If (p_rec.information12 = hr_api.g_varchar2) then
743: p_rec.information12 :=
744: per_abb_shd.g_old_rec.information12;
745: End If;
746: If (p_rec.information13 = hr_api.g_varchar2) then
747: p_rec.information13 :=
748: per_abb_shd.g_old_rec.information13;
749: End If;
750: If (p_rec.information14 = hr_api.g_varchar2) then

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

746: If (p_rec.information13 = hr_api.g_varchar2) then
747: p_rec.information13 :=
748: per_abb_shd.g_old_rec.information13;
749: End If;
750: If (p_rec.information14 = hr_api.g_varchar2) then
751: p_rec.information14 :=
752: per_abb_shd.g_old_rec.information14;
753: End If;
754: If (p_rec.information15 = hr_api.g_varchar2) then

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

750: If (p_rec.information14 = hr_api.g_varchar2) then
751: p_rec.information14 :=
752: per_abb_shd.g_old_rec.information14;
753: End If;
754: If (p_rec.information15 = hr_api.g_varchar2) then
755: p_rec.information15 :=
756: per_abb_shd.g_old_rec.information15;
757: End If;
758: If (p_rec.information16 = hr_api.g_varchar2) then

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

754: If (p_rec.information15 = hr_api.g_varchar2) then
755: p_rec.information15 :=
756: per_abb_shd.g_old_rec.information15;
757: End If;
758: If (p_rec.information16 = hr_api.g_varchar2) then
759: p_rec.information16 :=
760: per_abb_shd.g_old_rec.information16;
761: End If;
762: If (p_rec.information17 = hr_api.g_varchar2) then

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

758: If (p_rec.information16 = hr_api.g_varchar2) then
759: p_rec.information16 :=
760: per_abb_shd.g_old_rec.information16;
761: End If;
762: If (p_rec.information17 = hr_api.g_varchar2) then
763: p_rec.information17 :=
764: per_abb_shd.g_old_rec.information17;
765: End If;
766: If (p_rec.information18 = hr_api.g_varchar2) then

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

762: If (p_rec.information17 = hr_api.g_varchar2) then
763: p_rec.information17 :=
764: per_abb_shd.g_old_rec.information17;
765: End If;
766: If (p_rec.information18 = hr_api.g_varchar2) then
767: p_rec.information18 :=
768: per_abb_shd.g_old_rec.information18;
769: End If;
770: If (p_rec.information19 = hr_api.g_varchar2) then

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

766: If (p_rec.information18 = hr_api.g_varchar2) then
767: p_rec.information18 :=
768: per_abb_shd.g_old_rec.information18;
769: End If;
770: If (p_rec.information19 = hr_api.g_varchar2) then
771: p_rec.information19 :=
772: per_abb_shd.g_old_rec.information19;
773: End If;
774: If (p_rec.information20 = hr_api.g_varchar2) then

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

770: If (p_rec.information19 = hr_api.g_varchar2) then
771: p_rec.information19 :=
772: per_abb_shd.g_old_rec.information19;
773: End If;
774: If (p_rec.information20 = hr_api.g_varchar2) then
775: p_rec.information20 :=
776: per_abb_shd.g_old_rec.information20;
777: End If;
778: --

Line 779: If (p_rec.user_role = hr_api.g_varchar2) then

775: p_rec.information20 :=
776: per_abb_shd.g_old_rec.information20;
777: End If;
778: --
779: If (p_rec.user_role = hr_api.g_varchar2) then
780: p_rec.user_role :=
781: per_abb_shd.g_old_rec.user_role;
782: End If;
783: If (p_rec.assignment_status_type_id = hr_api.g_number) then

Line 783: If (p_rec.assignment_status_type_id = hr_api.g_number) then

779: If (p_rec.user_role = hr_api.g_varchar2) then
780: p_rec.user_role :=
781: per_abb_shd.g_old_rec.user_role;
782: End If;
783: If (p_rec.assignment_status_type_id = hr_api.g_number) then
784: p_rec.assignment_status_type_id :=
785: per_abb_shd.g_old_rec.assignment_status_type_id;
786: End If;
787: If (p_rec.advance_pay = hr_api.g_varchar2) then

Line 787: If (p_rec.advance_pay = hr_api.g_varchar2) then

783: If (p_rec.assignment_status_type_id = hr_api.g_number) then
784: p_rec.assignment_status_type_id :=
785: per_abb_shd.g_old_rec.assignment_status_type_id;
786: End If;
787: If (p_rec.advance_pay = hr_api.g_varchar2) then
788: p_rec.advance_pay :=
789: per_abb_shd.g_old_rec.advance_pay;
790: End If;
791: If (p_rec.absence_overlap_flag = hr_api.g_varchar2) then

Line 791: If (p_rec.absence_overlap_flag = hr_api.g_varchar2) then

787: If (p_rec.advance_pay = hr_api.g_varchar2) then
788: p_rec.advance_pay :=
789: per_abb_shd.g_old_rec.advance_pay;
790: End If;
791: If (p_rec.absence_overlap_flag = hr_api.g_varchar2) then
792: p_rec.absence_overlap_flag :=
793: per_abb_shd.g_old_rec.absence_overlap_flag;
794: End If;
795: --

Line 856: ,p_business_group_id in number default hr_api.g_number

852: -- ----------------------------------------------------------------------------
853: Procedure upd
854: (p_absence_attendance_type_id in number
855: ,p_object_version_number in out nocopy number
856: ,p_business_group_id in number default hr_api.g_number
857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2

Line 857: ,p_date_effective in date default hr_api.g_date

853: Procedure upd
854: (p_absence_attendance_type_id in number
855: ,p_object_version_number in out nocopy number
856: ,p_business_group_id in number default hr_api.g_number
857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2

Line 858: ,p_name in varchar2 default hr_api.g_varchar2

854: (p_absence_attendance_type_id in number
855: ,p_object_version_number in out nocopy number
856: ,p_business_group_id in number default hr_api.g_number
857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date

Line 859: ,p_input_value_id in number default hr_api.g_number

855: ,p_object_version_number in out nocopy number
856: ,p_business_group_id in number default hr_api.g_number
857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2

Line 860: ,p_absence_category in varchar2 default hr_api.g_varchar2

856: ,p_business_group_id in number default hr_api.g_number
857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2

Line 861: ,p_comments in varchar2 default hr_api.g_varchar2

857: ,p_date_effective in date default hr_api.g_date
858: ,p_name in varchar2 default hr_api.g_varchar2
859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number

Line 863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2

859: ,p_input_value_id in number default hr_api.g_number
860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number

Line 864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2

860: ,p_absence_category in varchar2 default hr_api.g_varchar2
861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date

Line 865: ,p_request_id in number default hr_api.g_number

861: ,p_comments in varchar2 default hr_api.g_varchar2
862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 866: ,p_program_application_id in number default hr_api.g_number

862: ,p_date_end in out nocopy date
863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 867: ,p_program_id in number default hr_api.g_number

863: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 868: ,p_program_update_date in date default hr_api.g_date

864: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 869: ,p_attribute_category in varchar2 default hr_api.g_varchar2

865: ,p_request_id in number default hr_api.g_number
866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 870: ,p_attribute1 in varchar2 default hr_api.g_varchar2

866: ,p_program_application_id in number default hr_api.g_number
867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 871: ,p_attribute2 in varchar2 default hr_api.g_varchar2

867: ,p_program_id in number default hr_api.g_number
868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 872: ,p_attribute3 in varchar2 default hr_api.g_varchar2

868: ,p_program_update_date in date default hr_api.g_date
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 873: ,p_attribute4 in varchar2 default hr_api.g_varchar2

869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 874: ,p_attribute5 in varchar2 default hr_api.g_varchar2

870: ,p_attribute1 in varchar2 default hr_api.g_varchar2
871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 875: ,p_attribute6 in varchar2 default hr_api.g_varchar2

871: ,p_attribute2 in varchar2 default hr_api.g_varchar2
872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 876: ,p_attribute7 in varchar2 default hr_api.g_varchar2

872: ,p_attribute3 in varchar2 default hr_api.g_varchar2
873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 877: ,p_attribute8 in varchar2 default hr_api.g_varchar2

873: ,p_attribute4 in varchar2 default hr_api.g_varchar2
874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 878: ,p_attribute9 in varchar2 default hr_api.g_varchar2

874: ,p_attribute5 in varchar2 default hr_api.g_varchar2
875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 879: ,p_attribute10 in varchar2 default hr_api.g_varchar2

875: ,p_attribute6 in varchar2 default hr_api.g_varchar2
876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 880: ,p_attribute11 in varchar2 default hr_api.g_varchar2

876: ,p_attribute7 in varchar2 default hr_api.g_varchar2
877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 881: ,p_attribute12 in varchar2 default hr_api.g_varchar2

877: ,p_attribute8 in varchar2 default hr_api.g_varchar2
878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 882: ,p_attribute13 in varchar2 default hr_api.g_varchar2

878: ,p_attribute9 in varchar2 default hr_api.g_varchar2
879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 883: ,p_attribute14 in varchar2 default hr_api.g_varchar2

879: ,p_attribute10 in varchar2 default hr_api.g_varchar2
880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 884: ,p_attribute15 in varchar2 default hr_api.g_varchar2

880: ,p_attribute11 in varchar2 default hr_api.g_varchar2
881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 885: ,p_attribute16 in varchar2 default hr_api.g_varchar2

881: ,p_attribute12 in varchar2 default hr_api.g_varchar2
882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 886: ,p_attribute17 in varchar2 default hr_api.g_varchar2

882: ,p_attribute13 in varchar2 default hr_api.g_varchar2
883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 887: ,p_attribute18 in varchar2 default hr_api.g_varchar2

883: ,p_attribute14 in varchar2 default hr_api.g_varchar2
884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 888: ,p_attribute19 in varchar2 default hr_api.g_varchar2

884: ,p_attribute15 in varchar2 default hr_api.g_varchar2
885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 889: ,p_attribute20 in varchar2 default hr_api.g_varchar2

885: ,p_attribute16 in varchar2 default hr_api.g_varchar2
886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 890: ,p_information_category in varchar2 default hr_api.g_varchar2

886: ,p_attribute17 in varchar2 default hr_api.g_varchar2
887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 891: ,p_information1 in varchar2 default hr_api.g_varchar2

887: ,p_attribute18 in varchar2 default hr_api.g_varchar2
888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 892: ,p_information2 in varchar2 default hr_api.g_varchar2

888: ,p_attribute19 in varchar2 default hr_api.g_varchar2
889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 893: ,p_information3 in varchar2 default hr_api.g_varchar2

889: ,p_attribute20 in varchar2 default hr_api.g_varchar2
890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 894: ,p_information4 in varchar2 default hr_api.g_varchar2

890: ,p_information_category in varchar2 default hr_api.g_varchar2
891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 895: ,p_information5 in varchar2 default hr_api.g_varchar2

891: ,p_information1 in varchar2 default hr_api.g_varchar2
892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 896: ,p_information6 in varchar2 default hr_api.g_varchar2

892: ,p_information2 in varchar2 default hr_api.g_varchar2
893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 897: ,p_information7 in varchar2 default hr_api.g_varchar2

893: ,p_information3 in varchar2 default hr_api.g_varchar2
894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 898: ,p_information8 in varchar2 default hr_api.g_varchar2

894: ,p_information4 in varchar2 default hr_api.g_varchar2
895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 899: ,p_information9 in varchar2 default hr_api.g_varchar2

895: ,p_information5 in varchar2 default hr_api.g_varchar2
896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 900: ,p_information10 in varchar2 default hr_api.g_varchar2

896: ,p_information6 in varchar2 default hr_api.g_varchar2
897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 901: ,p_information11 in varchar2 default hr_api.g_varchar2

897: ,p_information7 in varchar2 default hr_api.g_varchar2
898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 902: ,p_information12 in varchar2 default hr_api.g_varchar2

898: ,p_information8 in varchar2 default hr_api.g_varchar2
899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 903: ,p_information13 in varchar2 default hr_api.g_varchar2

899: ,p_information9 in varchar2 default hr_api.g_varchar2
900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 904: ,p_information14 in varchar2 default hr_api.g_varchar2

900: ,p_information10 in varchar2 default hr_api.g_varchar2
901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 905: ,p_information15 in varchar2 default hr_api.g_varchar2

901: ,p_information11 in varchar2 default hr_api.g_varchar2
902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 906: ,p_information16 in varchar2 default hr_api.g_varchar2

902: ,p_information12 in varchar2 default hr_api.g_varchar2
903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 907: ,p_information17 in varchar2 default hr_api.g_varchar2

903: ,p_information13 in varchar2 default hr_api.g_varchar2
904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2

Line 908: ,p_information18 in varchar2 default hr_api.g_varchar2

904: ,p_information14 in varchar2 default hr_api.g_varchar2
905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number

Line 909: ,p_information19 in varchar2 default hr_api.g_varchar2

905: ,p_information15 in varchar2 default hr_api.g_varchar2
906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2

Line 910: ,p_information20 in varchar2 default hr_api.g_varchar2

906: ,p_information16 in varchar2 default hr_api.g_varchar2
907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2

Line 911: ,p_user_role in varchar2 default hr_api.g_varchar2

907: ,p_information17 in varchar2 default hr_api.g_varchar2
908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
915: ) is

Line 912: ,p_assignment_status_type_id in number default hr_api.g_number

908: ,p_information18 in varchar2 default hr_api.g_varchar2
909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
915: ) is
916: --

Line 913: ,p_advance_pay in varchar2 default hr_api.g_varchar2

909: ,p_information19 in varchar2 default hr_api.g_varchar2
910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
915: ) is
916: --
917: l_rec per_abb_shd.g_rec_type;

Line 914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2

910: ,p_information20 in varchar2 default hr_api.g_varchar2
911: ,p_user_role in varchar2 default hr_api.g_varchar2
912: ,p_assignment_status_type_id in number default hr_api.g_number
913: ,p_advance_pay in varchar2 default hr_api.g_varchar2
914: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
915: ) is
916: --
917: l_rec per_abb_shd.g_rec_type;
918: l_proc varchar2(72) := g_package||'upd';