APPS.PER_PPB_UPD dependencies on HR_API

Line 134: When hr_api.check_integrity_violated Then

130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
137: p_rec := l_rec;
138: per_ppb_shd.constraint_error

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

135: -- A check constraint has been violated
136: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
137: p_rec := l_rec;
138: per_ppb_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
143: p_rec := l_rec;

Line 140: When hr_api.parent_integrity_violated Then

136: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
137: p_rec := l_rec;
138: per_ppb_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
143: p_rec := l_rec;
144: per_ppb_shd.constraint_error

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

141: -- Parent integrity has been violated
142: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
143: p_rec := l_rec;
144: per_ppb_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
149: p_rec := l_rec;

Line 146: When hr_api.unique_integrity_violated Then

142: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
143: p_rec := l_rec;
144: per_ppb_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
149: p_rec := l_rec;
150: per_ppb_shd.constraint_error

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

147: -- Unique integrity has been violated
148: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
149: p_rec := l_rec;
150: per_ppb_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: per_ppb_shd.g_api_dml := false; -- Unset the api dml status
154: p_rec := l_rec;
155: Raise;

Line 459: when hr_api.cannot_find_prog_unit then

455: );
456: --
457: exception
458: --
459: when hr_api.cannot_find_prog_unit then
460: --
461: hr_api.cannot_find_prog_unit_error
462: (p_module_name => 'PER_PAY_BASES'
463: ,p_hook_type => 'AU');

Line 461: hr_api.cannot_find_prog_unit_error

457: exception
458: --
459: when hr_api.cannot_find_prog_unit then
460: --
461: hr_api.cannot_find_prog_unit_error
462: (p_module_name => 'PER_PAY_BASES'
463: ,p_hook_type => 'AU');
464: --
465: end;

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

523: -- is being used then we must set to the 'current' argument value.
524: --
525: l_rec := p_rec;
526:
527: If (p_rec.input_value_id = hr_api.g_number) then
528: p_rec.input_value_id :=
529: per_ppb_shd.g_old_rec.input_value_id;
530: End If;
531: If (p_rec.rate_id = hr_api.g_number) then

Line 531: If (p_rec.rate_id = hr_api.g_number) then

527: If (p_rec.input_value_id = hr_api.g_number) then
528: p_rec.input_value_id :=
529: per_ppb_shd.g_old_rec.input_value_id;
530: End If;
531: If (p_rec.rate_id = hr_api.g_number) then
532: p_rec.rate_id :=
533: per_ppb_shd.g_old_rec.rate_id;
534: End If;
535: If (p_rec.business_group_id = hr_api.g_number) then

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

531: If (p_rec.rate_id = hr_api.g_number) then
532: p_rec.rate_id :=
533: per_ppb_shd.g_old_rec.rate_id;
534: End If;
535: If (p_rec.business_group_id = hr_api.g_number) then
536: p_rec.business_group_id :=
537: per_ppb_shd.g_old_rec.business_group_id;
538: End If;
539: If (p_rec.name = hr_api.g_varchar2) then

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

535: If (p_rec.business_group_id = hr_api.g_number) then
536: p_rec.business_group_id :=
537: per_ppb_shd.g_old_rec.business_group_id;
538: End If;
539: If (p_rec.name = hr_api.g_varchar2) then
540: p_rec.name :=
541: per_ppb_shd.g_old_rec.name;
542: End If;
543: If (p_rec.pay_basis = hr_api.g_varchar2) then

Line 543: If (p_rec.pay_basis = hr_api.g_varchar2) then

539: If (p_rec.name = hr_api.g_varchar2) then
540: p_rec.name :=
541: per_ppb_shd.g_old_rec.name;
542: End If;
543: If (p_rec.pay_basis = hr_api.g_varchar2) then
544: p_rec.pay_basis :=
545: per_ppb_shd.g_old_rec.pay_basis;
546: End If;
547: If (p_rec.rate_basis = hr_api.g_varchar2) then

Line 547: If (p_rec.rate_basis = hr_api.g_varchar2) then

543: If (p_rec.pay_basis = hr_api.g_varchar2) then
544: p_rec.pay_basis :=
545: per_ppb_shd.g_old_rec.pay_basis;
546: End If;
547: If (p_rec.rate_basis = hr_api.g_varchar2) then
548: p_rec.rate_basis :=
549: per_ppb_shd.g_old_rec.rate_basis;
550: End If;
551: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

547: If (p_rec.rate_basis = hr_api.g_varchar2) then
548: p_rec.rate_basis :=
549: per_ppb_shd.g_old_rec.rate_basis;
550: End If;
551: If (p_rec.attribute_category = hr_api.g_varchar2) then
552: p_rec.attribute_category :=
553: per_ppb_shd.g_old_rec.attribute_category;
554: End If;
555: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

551: If (p_rec.attribute_category = hr_api.g_varchar2) then
552: p_rec.attribute_category :=
553: per_ppb_shd.g_old_rec.attribute_category;
554: End If;
555: If (p_rec.attribute1 = hr_api.g_varchar2) then
556: p_rec.attribute1 :=
557: per_ppb_shd.g_old_rec.attribute1;
558: End If;
559: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

555: If (p_rec.attribute1 = hr_api.g_varchar2) then
556: p_rec.attribute1 :=
557: per_ppb_shd.g_old_rec.attribute1;
558: End If;
559: If (p_rec.attribute2 = hr_api.g_varchar2) then
560: p_rec.attribute2 :=
561: per_ppb_shd.g_old_rec.attribute2;
562: End If;
563: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

559: If (p_rec.attribute2 = hr_api.g_varchar2) then
560: p_rec.attribute2 :=
561: per_ppb_shd.g_old_rec.attribute2;
562: End If;
563: If (p_rec.attribute3 = hr_api.g_varchar2) then
564: p_rec.attribute3 :=
565: per_ppb_shd.g_old_rec.attribute3;
566: End If;
567: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

563: If (p_rec.attribute3 = hr_api.g_varchar2) then
564: p_rec.attribute3 :=
565: per_ppb_shd.g_old_rec.attribute3;
566: End If;
567: If (p_rec.attribute4 = hr_api.g_varchar2) then
568: p_rec.attribute4 :=
569: per_ppb_shd.g_old_rec.attribute4;
570: End If;
571: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

567: If (p_rec.attribute4 = hr_api.g_varchar2) then
568: p_rec.attribute4 :=
569: per_ppb_shd.g_old_rec.attribute4;
570: End If;
571: If (p_rec.attribute5 = hr_api.g_varchar2) then
572: p_rec.attribute5 :=
573: per_ppb_shd.g_old_rec.attribute5;
574: End If;
575: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

571: If (p_rec.attribute5 = hr_api.g_varchar2) then
572: p_rec.attribute5 :=
573: per_ppb_shd.g_old_rec.attribute5;
574: End If;
575: If (p_rec.attribute6 = hr_api.g_varchar2) then
576: p_rec.attribute6 :=
577: per_ppb_shd.g_old_rec.attribute6;
578: End If;
579: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

575: If (p_rec.attribute6 = hr_api.g_varchar2) then
576: p_rec.attribute6 :=
577: per_ppb_shd.g_old_rec.attribute6;
578: End If;
579: If (p_rec.attribute7 = hr_api.g_varchar2) then
580: p_rec.attribute7 :=
581: per_ppb_shd.g_old_rec.attribute7;
582: End If;
583: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

579: If (p_rec.attribute7 = hr_api.g_varchar2) then
580: p_rec.attribute7 :=
581: per_ppb_shd.g_old_rec.attribute7;
582: End If;
583: If (p_rec.attribute8 = hr_api.g_varchar2) then
584: p_rec.attribute8 :=
585: per_ppb_shd.g_old_rec.attribute8;
586: End If;
587: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

583: If (p_rec.attribute8 = hr_api.g_varchar2) then
584: p_rec.attribute8 :=
585: per_ppb_shd.g_old_rec.attribute8;
586: End If;
587: If (p_rec.attribute9 = hr_api.g_varchar2) then
588: p_rec.attribute9 :=
589: per_ppb_shd.g_old_rec.attribute9;
590: End If;
591: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

587: If (p_rec.attribute9 = hr_api.g_varchar2) then
588: p_rec.attribute9 :=
589: per_ppb_shd.g_old_rec.attribute9;
590: End If;
591: If (p_rec.attribute10 = hr_api.g_varchar2) then
592: p_rec.attribute10 :=
593: per_ppb_shd.g_old_rec.attribute10;
594: End If;
595: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

591: If (p_rec.attribute10 = hr_api.g_varchar2) then
592: p_rec.attribute10 :=
593: per_ppb_shd.g_old_rec.attribute10;
594: End If;
595: If (p_rec.attribute11 = hr_api.g_varchar2) then
596: p_rec.attribute11 :=
597: per_ppb_shd.g_old_rec.attribute11;
598: End If;
599: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

595: If (p_rec.attribute11 = hr_api.g_varchar2) then
596: p_rec.attribute11 :=
597: per_ppb_shd.g_old_rec.attribute11;
598: End If;
599: If (p_rec.attribute12 = hr_api.g_varchar2) then
600: p_rec.attribute12 :=
601: per_ppb_shd.g_old_rec.attribute12;
602: End If;
603: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

599: If (p_rec.attribute12 = hr_api.g_varchar2) then
600: p_rec.attribute12 :=
601: per_ppb_shd.g_old_rec.attribute12;
602: End If;
603: If (p_rec.attribute13 = hr_api.g_varchar2) then
604: p_rec.attribute13 :=
605: per_ppb_shd.g_old_rec.attribute13;
606: End If;
607: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

603: If (p_rec.attribute13 = hr_api.g_varchar2) then
604: p_rec.attribute13 :=
605: per_ppb_shd.g_old_rec.attribute13;
606: End If;
607: If (p_rec.attribute14 = hr_api.g_varchar2) then
608: p_rec.attribute14 :=
609: per_ppb_shd.g_old_rec.attribute14;
610: End If;
611: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

607: If (p_rec.attribute14 = hr_api.g_varchar2) then
608: p_rec.attribute14 :=
609: per_ppb_shd.g_old_rec.attribute14;
610: End If;
611: If (p_rec.attribute15 = hr_api.g_varchar2) then
612: p_rec.attribute15 :=
613: per_ppb_shd.g_old_rec.attribute15;
614: End If;
615: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

611: If (p_rec.attribute15 = hr_api.g_varchar2) then
612: p_rec.attribute15 :=
613: per_ppb_shd.g_old_rec.attribute15;
614: End If;
615: If (p_rec.attribute16 = hr_api.g_varchar2) then
616: p_rec.attribute16 :=
617: per_ppb_shd.g_old_rec.attribute16;
618: End If;
619: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

615: If (p_rec.attribute16 = hr_api.g_varchar2) then
616: p_rec.attribute16 :=
617: per_ppb_shd.g_old_rec.attribute16;
618: End If;
619: If (p_rec.attribute17 = hr_api.g_varchar2) then
620: p_rec.attribute17 :=
621: per_ppb_shd.g_old_rec.attribute17;
622: End If;
623: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

619: If (p_rec.attribute17 = hr_api.g_varchar2) then
620: p_rec.attribute17 :=
621: per_ppb_shd.g_old_rec.attribute17;
622: End If;
623: If (p_rec.attribute18 = hr_api.g_varchar2) then
624: p_rec.attribute18 :=
625: per_ppb_shd.g_old_rec.attribute18;
626: End If;
627: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

623: If (p_rec.attribute18 = hr_api.g_varchar2) then
624: p_rec.attribute18 :=
625: per_ppb_shd.g_old_rec.attribute18;
626: End If;
627: If (p_rec.attribute19 = hr_api.g_varchar2) then
628: p_rec.attribute19 :=
629: per_ppb_shd.g_old_rec.attribute19;
630: End If;
631: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

627: If (p_rec.attribute19 = hr_api.g_varchar2) then
628: p_rec.attribute19 :=
629: per_ppb_shd.g_old_rec.attribute19;
630: End If;
631: If (p_rec.attribute20 = hr_api.g_varchar2) then
632: p_rec.attribute20 :=
633: per_ppb_shd.g_old_rec.attribute20;
634: End If;
635: If (p_rec.annualized_hours = hr_api.g_number) then

Line 635: If (p_rec.annualized_hours = hr_api.g_number) then

631: If (p_rec.attribute20 = hr_api.g_varchar2) then
632: p_rec.attribute20 :=
633: per_ppb_shd.g_old_rec.attribute20;
634: End If;
635: If (p_rec.annualized_hours = hr_api.g_number) then
636: p_rec.annualized_hours :=
637: per_ppb_shd.g_old_rec.annualized_hours;
638: End If;
639: If (p_rec.pay_annualization_factor = hr_api.g_number) then

Line 639: If (p_rec.pay_annualization_factor = hr_api.g_number) then

635: If (p_rec.annualized_hours = hr_api.g_number) then
636: p_rec.annualized_hours :=
637: per_ppb_shd.g_old_rec.annualized_hours;
638: End If;
639: If (p_rec.pay_annualization_factor = hr_api.g_number) then
640: p_rec.pay_annualization_factor :=
641: per_ppb_shd.g_old_rec.pay_annualization_factor;
642: End If;
643: If (p_rec.grade_annualization_factor = hr_api.g_number) then

Line 643: If (p_rec.grade_annualization_factor = hr_api.g_number) then

639: If (p_rec.pay_annualization_factor = hr_api.g_number) then
640: p_rec.pay_annualization_factor :=
641: per_ppb_shd.g_old_rec.pay_annualization_factor;
642: End If;
643: If (p_rec.grade_annualization_factor = hr_api.g_number) then
644: p_rec.grade_annualization_factor :=
645: per_ppb_shd.g_old_rec.grade_annualization_factor;
646: End If;
647: If (p_rec.information_category = hr_api.g_varchar2) then

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

643: If (p_rec.grade_annualization_factor = hr_api.g_number) then
644: p_rec.grade_annualization_factor :=
645: per_ppb_shd.g_old_rec.grade_annualization_factor;
646: End If;
647: If (p_rec.information_category = hr_api.g_varchar2) then
648: p_rec.information_category :=
649: per_ppb_shd.g_old_rec.information_category;
650: End If;
651: If (p_rec.information1 = hr_api.g_varchar2) then

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

647: If (p_rec.information_category = hr_api.g_varchar2) then
648: p_rec.information_category :=
649: per_ppb_shd.g_old_rec.information_category;
650: End If;
651: If (p_rec.information1 = hr_api.g_varchar2) then
652: p_rec.information1 :=
653: per_ppb_shd.g_old_rec.information1;
654: End If;
655: If (p_rec.information2 = hr_api.g_varchar2) then

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

651: If (p_rec.information1 = hr_api.g_varchar2) then
652: p_rec.information1 :=
653: per_ppb_shd.g_old_rec.information1;
654: End If;
655: If (p_rec.information2 = hr_api.g_varchar2) then
656: p_rec.information2 :=
657: per_ppb_shd.g_old_rec.information2;
658: End If;
659: If (p_rec.information3 = hr_api.g_varchar2) then

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

655: If (p_rec.information2 = hr_api.g_varchar2) then
656: p_rec.information2 :=
657: per_ppb_shd.g_old_rec.information2;
658: End If;
659: If (p_rec.information3 = hr_api.g_varchar2) then
660: p_rec.information3 :=
661: per_ppb_shd.g_old_rec.information3;
662: End If;
663: If (p_rec.information4 = hr_api.g_varchar2) then

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

659: If (p_rec.information3 = hr_api.g_varchar2) then
660: p_rec.information3 :=
661: per_ppb_shd.g_old_rec.information3;
662: End If;
663: If (p_rec.information4 = hr_api.g_varchar2) then
664: p_rec.information4 :=
665: per_ppb_shd.g_old_rec.information4;
666: End If;
667: If (p_rec.information5 = hr_api.g_varchar2) then

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

663: If (p_rec.information4 = hr_api.g_varchar2) then
664: p_rec.information4 :=
665: per_ppb_shd.g_old_rec.information4;
666: End If;
667: If (p_rec.information5 = hr_api.g_varchar2) then
668: p_rec.information5 :=
669: per_ppb_shd.g_old_rec.information5;
670: End If;
671: If (p_rec.information6 = hr_api.g_varchar2) then

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

667: If (p_rec.information5 = hr_api.g_varchar2) then
668: p_rec.information5 :=
669: per_ppb_shd.g_old_rec.information5;
670: End If;
671: If (p_rec.information6 = hr_api.g_varchar2) then
672: p_rec.information6 :=
673: per_ppb_shd.g_old_rec.information6;
674: End If;
675: If (p_rec.information7 = hr_api.g_varchar2) then

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

671: If (p_rec.information6 = hr_api.g_varchar2) then
672: p_rec.information6 :=
673: per_ppb_shd.g_old_rec.information6;
674: End If;
675: If (p_rec.information7 = hr_api.g_varchar2) then
676: p_rec.information7 :=
677: per_ppb_shd.g_old_rec.information7;
678: End If;
679: If (p_rec.information8 = hr_api.g_varchar2) then

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

675: If (p_rec.information7 = hr_api.g_varchar2) then
676: p_rec.information7 :=
677: per_ppb_shd.g_old_rec.information7;
678: End If;
679: If (p_rec.information8 = hr_api.g_varchar2) then
680: p_rec.information8 :=
681: per_ppb_shd.g_old_rec.information8;
682: End If;
683: If (p_rec.information9 = hr_api.g_varchar2) then

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

679: If (p_rec.information8 = hr_api.g_varchar2) then
680: p_rec.information8 :=
681: per_ppb_shd.g_old_rec.information8;
682: End If;
683: If (p_rec.information9 = hr_api.g_varchar2) then
684: p_rec.information9 :=
685: per_ppb_shd.g_old_rec.information9;
686: End If;
687: If (p_rec.information10 = hr_api.g_varchar2) then

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

683: If (p_rec.information9 = hr_api.g_varchar2) then
684: p_rec.information9 :=
685: per_ppb_shd.g_old_rec.information9;
686: End If;
687: If (p_rec.information10 = hr_api.g_varchar2) then
688: p_rec.information10 :=
689: per_ppb_shd.g_old_rec.information10;
690: End If;
691: If (p_rec.information11 = hr_api.g_varchar2) then

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

687: If (p_rec.information10 = hr_api.g_varchar2) then
688: p_rec.information10 :=
689: per_ppb_shd.g_old_rec.information10;
690: End If;
691: If (p_rec.information11 = hr_api.g_varchar2) then
692: p_rec.information11 :=
693: per_ppb_shd.g_old_rec.information11;
694: End If;
695: If (p_rec.information12 = hr_api.g_varchar2) then

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

691: If (p_rec.information11 = hr_api.g_varchar2) then
692: p_rec.information11 :=
693: per_ppb_shd.g_old_rec.information11;
694: End If;
695: If (p_rec.information12 = hr_api.g_varchar2) then
696: p_rec.information12 :=
697: per_ppb_shd.g_old_rec.information12;
698: End If;
699: If (p_rec.information13 = hr_api.g_varchar2) then

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

695: If (p_rec.information12 = hr_api.g_varchar2) then
696: p_rec.information12 :=
697: per_ppb_shd.g_old_rec.information12;
698: End If;
699: If (p_rec.information13 = hr_api.g_varchar2) then
700: p_rec.information13 :=
701: per_ppb_shd.g_old_rec.information13;
702: End If;
703: If (p_rec.information14 = hr_api.g_varchar2) then

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

699: If (p_rec.information13 = hr_api.g_varchar2) then
700: p_rec.information13 :=
701: per_ppb_shd.g_old_rec.information13;
702: End If;
703: If (p_rec.information14 = hr_api.g_varchar2) then
704: p_rec.information14 :=
705: per_ppb_shd.g_old_rec.information14;
706: End If;
707: If (p_rec.information15 = hr_api.g_varchar2) then

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

703: If (p_rec.information14 = hr_api.g_varchar2) then
704: p_rec.information14 :=
705: per_ppb_shd.g_old_rec.information14;
706: End If;
707: If (p_rec.information15 = hr_api.g_varchar2) then
708: p_rec.information15 :=
709: per_ppb_shd.g_old_rec.information15;
710: End If;
711: If (p_rec.information16 = hr_api.g_varchar2) then

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

707: If (p_rec.information15 = hr_api.g_varchar2) then
708: p_rec.information15 :=
709: per_ppb_shd.g_old_rec.information15;
710: End If;
711: If (p_rec.information16 = hr_api.g_varchar2) then
712: p_rec.information16 :=
713: per_ppb_shd.g_old_rec.information16;
714: End If;
715: If (p_rec.information17 = hr_api.g_varchar2) then

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

711: If (p_rec.information16 = hr_api.g_varchar2) then
712: p_rec.information16 :=
713: per_ppb_shd.g_old_rec.information16;
714: End If;
715: If (p_rec.information17 = hr_api.g_varchar2) then
716: p_rec.information17 :=
717: per_ppb_shd.g_old_rec.information17;
718: End If;
719: If (p_rec.information18 = hr_api.g_varchar2) then

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

715: If (p_rec.information17 = hr_api.g_varchar2) then
716: p_rec.information17 :=
717: per_ppb_shd.g_old_rec.information17;
718: End If;
719: If (p_rec.information18 = hr_api.g_varchar2) then
720: p_rec.information18 :=
721: per_ppb_shd.g_old_rec.information18;
722: End If;
723: If (p_rec.information19 = hr_api.g_varchar2) then

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

719: If (p_rec.information18 = hr_api.g_varchar2) then
720: p_rec.information18 :=
721: per_ppb_shd.g_old_rec.information18;
722: End If;
723: If (p_rec.information19 = hr_api.g_varchar2) then
724: p_rec.information19 :=
725: per_ppb_shd.g_old_rec.information19;
726: End If;
727: If (p_rec.information20 = hr_api.g_varchar2) then

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

723: If (p_rec.information19 = hr_api.g_varchar2) then
724: p_rec.information19 :=
725: per_ppb_shd.g_old_rec.information19;
726: End If;
727: If (p_rec.information20 = hr_api.g_varchar2) then
728: p_rec.information20 :=
729: per_ppb_shd.g_old_rec.information20;
730: End If;
731: --

Line 800: ,p_input_value_id in number default hr_api.g_number

796: -- ----------------------------------------------------------------------------
797: Procedure upd
798: (p_pay_basis_id in number
799: ,p_object_version_number in out nocopy number
800: ,p_input_value_id in number default hr_api.g_number
801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number

Line 801: ,p_business_group_id in number default hr_api.g_number

797: Procedure upd
798: (p_pay_basis_id in number
799: ,p_object_version_number in out nocopy number
800: ,p_input_value_id in number default hr_api.g_number
801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2

Line 802: ,p_name in varchar2 default hr_api.g_varchar2

798: (p_pay_basis_id in number
799: ,p_object_version_number in out nocopy number
800: ,p_input_value_id in number default hr_api.g_number
801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 803: ,p_pay_basis in varchar2 default hr_api.g_varchar2

799: ,p_object_version_number in out nocopy number
800: ,p_input_value_id in number default hr_api.g_number
801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 804: ,p_rate_id in number default hr_api.g_number

800: ,p_input_value_id in number default hr_api.g_number
801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 805: ,p_rate_basis in varchar2 default hr_api.g_varchar2

801: ,p_business_group_id in number default hr_api.g_number
802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 806: ,p_attribute_category in varchar2 default hr_api.g_varchar2

802: ,p_name in varchar2 default hr_api.g_varchar2
803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 807: ,p_attribute1 in varchar2 default hr_api.g_varchar2

803: ,p_pay_basis in varchar2 default hr_api.g_varchar2
804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 808: ,p_attribute2 in varchar2 default hr_api.g_varchar2

804: ,p_rate_id in number default hr_api.g_number
805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 809: ,p_attribute3 in varchar2 default hr_api.g_varchar2

805: ,p_rate_basis in varchar2 default hr_api.g_varchar2
806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 810: ,p_attribute4 in varchar2 default hr_api.g_varchar2

806: ,p_attribute_category in varchar2 default hr_api.g_varchar2
807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 811: ,p_attribute5 in varchar2 default hr_api.g_varchar2

807: ,p_attribute1 in varchar2 default hr_api.g_varchar2
808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 812: ,p_attribute6 in varchar2 default hr_api.g_varchar2

808: ,p_attribute2 in varchar2 default hr_api.g_varchar2
809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 813: ,p_attribute7 in varchar2 default hr_api.g_varchar2

809: ,p_attribute3 in varchar2 default hr_api.g_varchar2
810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 814: ,p_attribute8 in varchar2 default hr_api.g_varchar2

810: ,p_attribute4 in varchar2 default hr_api.g_varchar2
811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 815: ,p_attribute9 in varchar2 default hr_api.g_varchar2

811: ,p_attribute5 in varchar2 default hr_api.g_varchar2
812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 816: ,p_attribute10 in varchar2 default hr_api.g_varchar2

812: ,p_attribute6 in varchar2 default hr_api.g_varchar2
813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 817: ,p_attribute11 in varchar2 default hr_api.g_varchar2

813: ,p_attribute7 in varchar2 default hr_api.g_varchar2
814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 818: ,p_attribute12 in varchar2 default hr_api.g_varchar2

814: ,p_attribute8 in varchar2 default hr_api.g_varchar2
815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 819: ,p_attribute13 in varchar2 default hr_api.g_varchar2

815: ,p_attribute9 in varchar2 default hr_api.g_varchar2
816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 820: ,p_attribute14 in varchar2 default hr_api.g_varchar2

816: ,p_attribute10 in varchar2 default hr_api.g_varchar2
817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 821: ,p_attribute15 in varchar2 default hr_api.g_varchar2

817: ,p_attribute11 in varchar2 default hr_api.g_varchar2
818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 822: ,p_attribute16 in varchar2 default hr_api.g_varchar2

818: ,p_attribute12 in varchar2 default hr_api.g_varchar2
819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 823: ,p_attribute17 in varchar2 default hr_api.g_varchar2

819: ,p_attribute13 in varchar2 default hr_api.g_varchar2
820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number

Line 824: ,p_attribute18 in varchar2 default hr_api.g_varchar2

820: ,p_attribute14 in varchar2 default hr_api.g_varchar2
821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number

Line 825: ,p_attribute19 in varchar2 default hr_api.g_varchar2

821: ,p_attribute15 in varchar2 default hr_api.g_varchar2
822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number

Line 826: ,p_attribute20 in varchar2 default hr_api.g_varchar2

822: ,p_attribute16 in varchar2 default hr_api.g_varchar2
823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 827: ,p_annualized_hours in number default hr_api.g_number

823: ,p_attribute17 in varchar2 default hr_api.g_varchar2
824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 828: ,p_pay_annualization_factor in number default hr_api.g_number

824: ,p_attribute18 in varchar2 default hr_api.g_varchar2
825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 829: ,p_grade_annualization_factor in number default hr_api.g_number

825: ,p_attribute19 in varchar2 default hr_api.g_varchar2
826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 830: ,p_information_category in varchar2 default hr_api.g_varchar2

826: ,p_attribute20 in varchar2 default hr_api.g_varchar2
827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 831: ,p_information1 in varchar2 default hr_api.g_varchar2

827: ,p_annualized_hours in number default hr_api.g_number
828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 832: ,p_information2 in varchar2 default hr_api.g_varchar2

828: ,p_pay_annualization_factor in number default hr_api.g_number
829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 833: ,p_information3 in varchar2 default hr_api.g_varchar2

829: ,p_grade_annualization_factor in number default hr_api.g_number
830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 834: ,p_information4 in varchar2 default hr_api.g_varchar2

830: ,p_information_category in varchar2 default hr_api.g_varchar2
831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 835: ,p_information5 in varchar2 default hr_api.g_varchar2

831: ,p_information1 in varchar2 default hr_api.g_varchar2
832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 836: ,p_information6 in varchar2 default hr_api.g_varchar2

832: ,p_information2 in varchar2 default hr_api.g_varchar2
833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 837: ,p_information7 in varchar2 default hr_api.g_varchar2

833: ,p_information3 in varchar2 default hr_api.g_varchar2
834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 838: ,p_information8 in varchar2 default hr_api.g_varchar2

834: ,p_information4 in varchar2 default hr_api.g_varchar2
835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 839: ,p_information9 in varchar2 default hr_api.g_varchar2

835: ,p_information5 in varchar2 default hr_api.g_varchar2
836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 840: ,p_information10 in varchar2 default hr_api.g_varchar2

836: ,p_information6 in varchar2 default hr_api.g_varchar2
837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 841: ,p_information11 in varchar2 default hr_api.g_varchar2

837: ,p_information7 in varchar2 default hr_api.g_varchar2
838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 842: ,p_information12 in varchar2 default hr_api.g_varchar2

838: ,p_information8 in varchar2 default hr_api.g_varchar2
839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 843: ,p_information13 in varchar2 default hr_api.g_varchar2

839: ,p_information9 in varchar2 default hr_api.g_varchar2
840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 844: ,p_information14 in varchar2 default hr_api.g_varchar2

840: ,p_information10 in varchar2 default hr_api.g_varchar2
841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 845: ,p_information15 in varchar2 default hr_api.g_varchar2

841: ,p_information11 in varchar2 default hr_api.g_varchar2
842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 846: ,p_information16 in varchar2 default hr_api.g_varchar2

842: ,p_information12 in varchar2 default hr_api.g_varchar2
843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2
850: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 847: ,p_information17 in varchar2 default hr_api.g_varchar2

843: ,p_information13 in varchar2 default hr_api.g_varchar2
844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2
850: ,p_information20 in varchar2 default hr_api.g_varchar2
851: ) is

Line 848: ,p_information18 in varchar2 default hr_api.g_varchar2

844: ,p_information14 in varchar2 default hr_api.g_varchar2
845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2
850: ,p_information20 in varchar2 default hr_api.g_varchar2
851: ) is
852: --

Line 849: ,p_information19 in varchar2 default hr_api.g_varchar2

845: ,p_information15 in varchar2 default hr_api.g_varchar2
846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2
850: ,p_information20 in varchar2 default hr_api.g_varchar2
851: ) is
852: --
853: l_rec per_ppb_shd.g_rec_type;

Line 850: ,p_information20 in varchar2 default hr_api.g_varchar2

846: ,p_information16 in varchar2 default hr_api.g_varchar2
847: ,p_information17 in varchar2 default hr_api.g_varchar2
848: ,p_information18 in varchar2 default hr_api.g_varchar2
849: ,p_information19 in varchar2 default hr_api.g_varchar2
850: ,p_information20 in varchar2 default hr_api.g_varchar2
851: ) is
852: --
853: l_rec per_ppb_shd.g_rec_type;
854: l_proc varchar2(72) := g_package||'upd';