APPS.PQH_CPD_UPD dependencies on HR_API

Line 140: When hr_api.check_integrity_violated Then

136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: end if;
138: --
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_shd.constraint_error

Line 145: When hr_api.parent_integrity_violated Then

141: -- A check constraint has been violated
142: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
143: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_shd.constraint_error

Line 150: When hr_api.unique_integrity_violated Then

146: -- Parent integrity has been violated
147: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
148: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_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: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
153: pqh_cpd_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End update_dml;

Line 479: when hr_api.cannot_find_prog_unit then

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

Line 481: hr_api.cannot_find_prog_unit_error

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

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

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

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

546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: pqh_cpd_shd.g_old_rec.business_group_id;
549: End If;
550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: pqh_cpd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.status_cd = hr_api.g_varchar2) then

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

550: If (p_rec.name = hr_api.g_varchar2) then
551: p_rec.name :=
552: pqh_cpd_shd.g_old_rec.name;
553: End If;
554: If (p_rec.status_cd = hr_api.g_varchar2) then
555: p_rec.status_cd :=
556: pqh_cpd_shd.g_old_rec.status_cd;
557: End If;
558: If (p_rec.retirement_age = hr_api.g_number) then

Line 558: If (p_rec.retirement_age = hr_api.g_number) then

554: If (p_rec.status_cd = hr_api.g_varchar2) then
555: p_rec.status_cd :=
556: pqh_cpd_shd.g_old_rec.status_cd;
557: End If;
558: If (p_rec.retirement_age = hr_api.g_number) then
559: p_rec.retirement_age :=
560: pqh_cpd_shd.g_old_rec.retirement_age;
561: End If;
562: If (p_rec.category_cd = hr_api.g_varchar2) then

Line 562: If (p_rec.category_cd = hr_api.g_varchar2) then

558: If (p_rec.retirement_age = hr_api.g_number) then
559: p_rec.retirement_age :=
560: pqh_cpd_shd.g_old_rec.retirement_age;
561: End If;
562: If (p_rec.category_cd = hr_api.g_varchar2) then
563: p_rec.category_cd :=
564: pqh_cpd_shd.g_old_rec.category_cd;
565: End If;
566: If (p_rec.recruitment_end_date = hr_api.g_date) then

Line 566: If (p_rec.recruitment_end_date = hr_api.g_date) then

562: If (p_rec.category_cd = hr_api.g_varchar2) then
563: p_rec.category_cd :=
564: pqh_cpd_shd.g_old_rec.category_cd;
565: End If;
566: If (p_rec.recruitment_end_date = hr_api.g_date) then
567: p_rec.recruitment_end_date :=
568: pqh_cpd_shd.g_old_rec.recruitment_end_date;
569: End If;
570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then

Line 570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then

566: If (p_rec.recruitment_end_date = hr_api.g_date) then
567: p_rec.recruitment_end_date :=
568: pqh_cpd_shd.g_old_rec.recruitment_end_date;
569: End If;
570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then
571: p_rec.corps_type_cd :=
572: pqh_cpd_shd.g_old_rec.corps_type_cd;
573: End If;
574: If (p_rec.starting_grade_step_id = hr_api.g_number) then

Line 574: If (p_rec.starting_grade_step_id = hr_api.g_number) then

570: If (p_rec.corps_type_cd = hr_api.g_varchar2) then
571: p_rec.corps_type_cd :=
572: pqh_cpd_shd.g_old_rec.corps_type_cd;
573: End If;
574: If (p_rec.starting_grade_step_id = hr_api.g_number) then
575: p_rec.starting_grade_step_id :=
576: pqh_cpd_shd.g_old_rec.starting_grade_step_id;
577: End If;
578: If (p_rec.task_desc = hr_api.g_varchar2) then

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

574: If (p_rec.starting_grade_step_id = hr_api.g_number) then
575: p_rec.starting_grade_step_id :=
576: pqh_cpd_shd.g_old_rec.starting_grade_step_id;
577: End If;
578: If (p_rec.task_desc = hr_api.g_varchar2) then
579: p_rec.task_desc :=
580: pqh_cpd_shd.g_old_rec.task_desc;
581: End If;
582: If (p_rec.secondment_threshold = hr_api.g_number) then

Line 582: If (p_rec.secondment_threshold = hr_api.g_number) then

578: If (p_rec.task_desc = hr_api.g_varchar2) then
579: p_rec.task_desc :=
580: pqh_cpd_shd.g_old_rec.task_desc;
581: End If;
582: If (p_rec.secondment_threshold = hr_api.g_number) then
583: p_rec.secondment_threshold :=
584: pqh_cpd_shd.g_old_rec.secondment_threshold;
585: End If;
586: If (p_rec.normal_hours = hr_api.g_number) then

Line 586: If (p_rec.normal_hours = hr_api.g_number) then

582: If (p_rec.secondment_threshold = hr_api.g_number) then
583: p_rec.secondment_threshold :=
584: pqh_cpd_shd.g_old_rec.secondment_threshold;
585: End If;
586: If (p_rec.normal_hours = hr_api.g_number) then
587: p_rec.normal_hours :=
588: pqh_cpd_shd.g_old_rec.normal_hours;
589: End If;
590: If (p_rec.normal_hours_frequency = hr_api.g_varchar2) then

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

586: If (p_rec.normal_hours = hr_api.g_number) then
587: p_rec.normal_hours :=
588: pqh_cpd_shd.g_old_rec.normal_hours;
589: End If;
590: If (p_rec.normal_hours_frequency = hr_api.g_varchar2) then
591: p_rec.normal_hours_frequency :=
592: pqh_cpd_shd.g_old_rec.normal_hours_frequency;
593: End If;
594: If (p_rec.minimum_hours = hr_api.g_number) then

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

590: If (p_rec.normal_hours_frequency = hr_api.g_varchar2) then
591: p_rec.normal_hours_frequency :=
592: pqh_cpd_shd.g_old_rec.normal_hours_frequency;
593: End If;
594: If (p_rec.minimum_hours = hr_api.g_number) then
595: p_rec.minimum_hours :=
596: pqh_cpd_shd.g_old_rec.minimum_hours;
597: End If;
598: If (p_rec.minimum_hours_frequency = hr_api.g_varchar2) then

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

594: If (p_rec.minimum_hours = hr_api.g_number) then
595: p_rec.minimum_hours :=
596: pqh_cpd_shd.g_old_rec.minimum_hours;
597: End If;
598: If (p_rec.minimum_hours_frequency = hr_api.g_varchar2) then
599: p_rec.minimum_hours_frequency :=
600: pqh_cpd_shd.g_old_rec.minimum_hours_frequency;
601: End If;
602: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

598: If (p_rec.minimum_hours_frequency = hr_api.g_varchar2) then
599: p_rec.minimum_hours_frequency :=
600: pqh_cpd_shd.g_old_rec.minimum_hours_frequency;
601: End If;
602: If (p_rec.attribute1 = hr_api.g_varchar2) then
603: p_rec.attribute1 :=
604: pqh_cpd_shd.g_old_rec.attribute1;
605: End If;
606: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

678: If (p_rec.attribute20 = hr_api.g_varchar2) then
679: p_rec.attribute20 :=
680: pqh_cpd_shd.g_old_rec.attribute20;
681: End If;
682: If (p_rec.attribute21 = hr_api.g_varchar2) then
683: p_rec.attribute21 :=
684: pqh_cpd_shd.g_old_rec.attribute21;
685: End If;
686: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

682: If (p_rec.attribute21 = hr_api.g_varchar2) then
683: p_rec.attribute21 :=
684: pqh_cpd_shd.g_old_rec.attribute21;
685: End If;
686: If (p_rec.attribute22 = hr_api.g_varchar2) then
687: p_rec.attribute22 :=
688: pqh_cpd_shd.g_old_rec.attribute22;
689: End If;
690: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

686: If (p_rec.attribute22 = hr_api.g_varchar2) then
687: p_rec.attribute22 :=
688: pqh_cpd_shd.g_old_rec.attribute22;
689: End If;
690: If (p_rec.attribute23 = hr_api.g_varchar2) then
691: p_rec.attribute23 :=
692: pqh_cpd_shd.g_old_rec.attribute23;
693: End If;
694: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

690: If (p_rec.attribute23 = hr_api.g_varchar2) then
691: p_rec.attribute23 :=
692: pqh_cpd_shd.g_old_rec.attribute23;
693: End If;
694: If (p_rec.attribute24 = hr_api.g_varchar2) then
695: p_rec.attribute24 :=
696: pqh_cpd_shd.g_old_rec.attribute24;
697: End If;
698: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

694: If (p_rec.attribute24 = hr_api.g_varchar2) then
695: p_rec.attribute24 :=
696: pqh_cpd_shd.g_old_rec.attribute24;
697: End If;
698: If (p_rec.attribute25 = hr_api.g_varchar2) then
699: p_rec.attribute25 :=
700: pqh_cpd_shd.g_old_rec.attribute25;
701: End If;
702: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

698: If (p_rec.attribute25 = hr_api.g_varchar2) then
699: p_rec.attribute25 :=
700: pqh_cpd_shd.g_old_rec.attribute25;
701: End If;
702: If (p_rec.attribute26 = hr_api.g_varchar2) then
703: p_rec.attribute26 :=
704: pqh_cpd_shd.g_old_rec.attribute26;
705: End If;
706: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

702: If (p_rec.attribute26 = hr_api.g_varchar2) then
703: p_rec.attribute26 :=
704: pqh_cpd_shd.g_old_rec.attribute26;
705: End If;
706: If (p_rec.attribute27 = hr_api.g_varchar2) then
707: p_rec.attribute27 :=
708: pqh_cpd_shd.g_old_rec.attribute27;
709: End If;
710: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

706: If (p_rec.attribute27 = hr_api.g_varchar2) then
707: p_rec.attribute27 :=
708: pqh_cpd_shd.g_old_rec.attribute27;
709: End If;
710: If (p_rec.attribute28 = hr_api.g_varchar2) then
711: p_rec.attribute28 :=
712: pqh_cpd_shd.g_old_rec.attribute28;
713: End If;
714: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

710: If (p_rec.attribute28 = hr_api.g_varchar2) then
711: p_rec.attribute28 :=
712: pqh_cpd_shd.g_old_rec.attribute28;
713: End If;
714: If (p_rec.attribute29 = hr_api.g_varchar2) then
715: p_rec.attribute29 :=
716: pqh_cpd_shd.g_old_rec.attribute29;
717: End If;
718: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

714: If (p_rec.attribute29 = hr_api.g_varchar2) then
715: p_rec.attribute29 :=
716: pqh_cpd_shd.g_old_rec.attribute29;
717: End If;
718: If (p_rec.attribute30 = hr_api.g_varchar2) then
719: p_rec.attribute30 :=
720: pqh_cpd_shd.g_old_rec.attribute30;
721: End If;
722: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

718: If (p_rec.attribute30 = hr_api.g_varchar2) then
719: p_rec.attribute30 :=
720: pqh_cpd_shd.g_old_rec.attribute30;
721: End If;
722: If (p_rec.attribute_category = hr_api.g_varchar2) then
723: p_rec.attribute_category :=
724: pqh_cpd_shd.g_old_rec.attribute_category;
725: End If;
726: If (p_rec.type_of_ps = hr_api.g_varchar2) then

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

722: If (p_rec.attribute_category = hr_api.g_varchar2) then
723: p_rec.attribute_category :=
724: pqh_cpd_shd.g_old_rec.attribute_category;
725: End If;
726: If (p_rec.type_of_ps = hr_api.g_varchar2) then
727: p_rec.type_of_ps :=
728: pqh_cpd_shd.g_old_rec.type_of_ps;
729: End If;
730: If (p_rec.date_from = hr_api.g_date) then

Line 730: If (p_rec.date_from = hr_api.g_date) then

726: If (p_rec.type_of_ps = hr_api.g_varchar2) then
727: p_rec.type_of_ps :=
728: pqh_cpd_shd.g_old_rec.type_of_ps;
729: End If;
730: If (p_rec.date_from = hr_api.g_date) then
731: p_rec.date_from :=
732: pqh_cpd_shd.g_old_rec.date_from;
733: End If;
734: If (p_rec.date_to = hr_api.g_date) then

Line 734: If (p_rec.date_to = hr_api.g_date) then

730: If (p_rec.date_from = hr_api.g_date) then
731: p_rec.date_from :=
732: pqh_cpd_shd.g_old_rec.date_from;
733: End If;
734: If (p_rec.date_to = hr_api.g_date) then
735: p_rec.date_to :=
736: pqh_cpd_shd.g_old_rec.date_to;
737: End If;
738: If (p_rec.primary_prof_field_id = hr_api.g_number) then

Line 738: If (p_rec.primary_prof_field_id = hr_api.g_number) then

734: If (p_rec.date_to = hr_api.g_date) then
735: p_rec.date_to :=
736: pqh_cpd_shd.g_old_rec.date_to;
737: End If;
738: If (p_rec.primary_prof_field_id = hr_api.g_number) then
739: p_rec.primary_prof_field_id :=
740: pqh_cpd_shd.g_old_rec.primary_prof_field_id;
741: End If;
742: If (p_rec.starting_grade_id = hr_api.g_number) then

Line 742: If (p_rec.starting_grade_id = hr_api.g_number) then

738: If (p_rec.primary_prof_field_id = hr_api.g_number) then
739: p_rec.primary_prof_field_id :=
740: pqh_cpd_shd.g_old_rec.primary_prof_field_id;
741: End If;
742: If (p_rec.starting_grade_id = hr_api.g_number) then
743: p_rec.starting_grade_id :=
744: pqh_cpd_shd.g_old_rec.starting_grade_id;
745: End If;
746: If (p_rec.ben_pgm_id = hr_api.g_number) then

Line 746: If (p_rec.ben_pgm_id = hr_api.g_number) then

742: If (p_rec.starting_grade_id = hr_api.g_number) then
743: p_rec.starting_grade_id :=
744: pqh_cpd_shd.g_old_rec.starting_grade_id;
745: End If;
746: If (p_rec.ben_pgm_id = hr_api.g_number) then
747: p_rec.ben_pgm_id :=
748: pqh_cpd_shd.g_old_rec.ben_pgm_id;
749: End If;
750: If (p_rec.probation_period = hr_api.g_number) then

Line 750: If (p_rec.probation_period = hr_api.g_number) then

746: If (p_rec.ben_pgm_id = hr_api.g_number) then
747: p_rec.ben_pgm_id :=
748: pqh_cpd_shd.g_old_rec.ben_pgm_id;
749: End If;
750: If (p_rec.probation_period = hr_api.g_number) then
751: p_rec.probation_period :=
752: pqh_cpd_shd.g_old_rec.probation_period;
753: End If;
754: If (p_rec.probation_units = hr_api.g_varchar2) then

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

750: If (p_rec.probation_period = hr_api.g_number) then
751: p_rec.probation_period :=
752: pqh_cpd_shd.g_old_rec.probation_period;
753: End If;
754: If (p_rec.probation_units = hr_api.g_varchar2) then
755: p_rec.probation_units :=
756: pqh_cpd_shd.g_old_rec.probation_units;
757: End If;
758: --

Line 825: ,p_business_group_id in number default hr_api.g_number

821: Procedure upd
822: (p_effective_date in date
823: ,p_corps_definition_id in number
824: ,p_object_version_number in out nocopy number
825: ,p_business_group_id in number default hr_api.g_number
826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number

Line 826: ,p_name in varchar2 default hr_api.g_varchar2

822: (p_effective_date in date
823: ,p_corps_definition_id in number
824: ,p_object_version_number in out nocopy number
825: ,p_business_group_id in number default hr_api.g_number
826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date

Line 827: ,p_status_cd in varchar2 default hr_api.g_varchar2

823: ,p_corps_definition_id in number
824: ,p_object_version_number in out nocopy number
825: ,p_business_group_id in number default hr_api.g_number
826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2

Line 828: ,p_category_cd in varchar2 default hr_api.g_varchar2

824: ,p_object_version_number in out nocopy number
825: ,p_business_group_id in number default hr_api.g_number
826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number

Line 829: ,p_retirement_age in number default hr_api.g_number

825: ,p_business_group_id in number default hr_api.g_number
826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2

Line 830: ,p_recruitment_end_date in date default hr_api.g_date

826: ,p_name in varchar2 default hr_api.g_varchar2
827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number

Line 831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2

827: ,p_status_cd in varchar2 default hr_api.g_varchar2
828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number

Line 832: ,p_starting_grade_step_id in number default hr_api.g_number

828: ,p_category_cd in varchar2 default hr_api.g_varchar2
829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2

Line 833: ,p_task_desc in varchar2 default hr_api.g_varchar2

829: ,p_retirement_age in number default hr_api.g_number
830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number

Line 834: ,p_secondment_threshold in number default hr_api.g_number

830: ,p_recruitment_end_date in date default hr_api.g_date
831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2

Line 835: ,p_normal_hours in number default hr_api.g_number

831: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2

832: ,p_starting_grade_step_id in number default hr_api.g_number
833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 837: ,p_minimum_hours in number default hr_api.g_number

833: ,p_task_desc in varchar2 default hr_api.g_varchar2
834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2

834: ,p_secondment_threshold in number default hr_api.g_number
835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 839: ,p_attribute1 in varchar2 default hr_api.g_varchar2

835: ,p_normal_hours in number default hr_api.g_number
836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 840: ,p_attribute2 in varchar2 default hr_api.g_varchar2

836: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 841: ,p_attribute3 in varchar2 default hr_api.g_varchar2

837: ,p_minimum_hours in number default hr_api.g_number
838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 842: ,p_attribute4 in varchar2 default hr_api.g_varchar2

838: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 843: ,p_attribute5 in varchar2 default hr_api.g_varchar2

839: ,p_attribute1 in varchar2 default hr_api.g_varchar2
840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 844: ,p_attribute6 in varchar2 default hr_api.g_varchar2

840: ,p_attribute2 in varchar2 default hr_api.g_varchar2
841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 845: ,p_attribute7 in varchar2 default hr_api.g_varchar2

841: ,p_attribute3 in varchar2 default hr_api.g_varchar2
842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 846: ,p_attribute8 in varchar2 default hr_api.g_varchar2

842: ,p_attribute4 in varchar2 default hr_api.g_varchar2
843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 847: ,p_attribute9 in varchar2 default hr_api.g_varchar2

843: ,p_attribute5 in varchar2 default hr_api.g_varchar2
844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 848: ,p_attribute10 in varchar2 default hr_api.g_varchar2

844: ,p_attribute6 in varchar2 default hr_api.g_varchar2
845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 849: ,p_attribute11 in varchar2 default hr_api.g_varchar2

845: ,p_attribute7 in varchar2 default hr_api.g_varchar2
846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 850: ,p_attribute12 in varchar2 default hr_api.g_varchar2

846: ,p_attribute8 in varchar2 default hr_api.g_varchar2
847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 851: ,p_attribute13 in varchar2 default hr_api.g_varchar2

847: ,p_attribute9 in varchar2 default hr_api.g_varchar2
848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 852: ,p_attribute14 in varchar2 default hr_api.g_varchar2

848: ,p_attribute10 in varchar2 default hr_api.g_varchar2
849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 853: ,p_attribute15 in varchar2 default hr_api.g_varchar2

849: ,p_attribute11 in varchar2 default hr_api.g_varchar2
850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 854: ,p_attribute16 in varchar2 default hr_api.g_varchar2

850: ,p_attribute12 in varchar2 default hr_api.g_varchar2
851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 855: ,p_attribute17 in varchar2 default hr_api.g_varchar2

851: ,p_attribute13 in varchar2 default hr_api.g_varchar2
852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 856: ,p_attribute18 in varchar2 default hr_api.g_varchar2

852: ,p_attribute14 in varchar2 default hr_api.g_varchar2
853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 857: ,p_attribute19 in varchar2 default hr_api.g_varchar2

853: ,p_attribute15 in varchar2 default hr_api.g_varchar2
854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 858: ,p_attribute20 in varchar2 default hr_api.g_varchar2

854: ,p_attribute16 in varchar2 default hr_api.g_varchar2
855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 859: ,p_attribute21 in varchar2 default hr_api.g_varchar2

855: ,p_attribute17 in varchar2 default hr_api.g_varchar2
856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 860: ,p_attribute22 in varchar2 default hr_api.g_varchar2

856: ,p_attribute18 in varchar2 default hr_api.g_varchar2
857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 861: ,p_attribute23 in varchar2 default hr_api.g_varchar2

857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 862: ,p_attribute24 in varchar2 default hr_api.g_varchar2

858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 863: ,p_attribute25 in varchar2 default hr_api.g_varchar2

859: ,p_attribute21 in varchar2 default hr_api.g_varchar2
860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 864: ,p_attribute26 in varchar2 default hr_api.g_varchar2

860: ,p_attribute22 in varchar2 default hr_api.g_varchar2
861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 865: ,p_attribute27 in varchar2 default hr_api.g_varchar2

861: ,p_attribute23 in varchar2 default hr_api.g_varchar2
862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 866: ,p_attribute28 in varchar2 default hr_api.g_varchar2

862: ,p_attribute24 in varchar2 default hr_api.g_varchar2
863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

Line 867: ,p_attribute29 in varchar2 default hr_api.g_varchar2

863: ,p_attribute25 in varchar2 default hr_api.g_varchar2
864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date

Line 868: ,p_attribute30 in varchar2 default hr_api.g_varchar2

864: ,p_attribute26 in varchar2 default hr_api.g_varchar2
865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date

Line 869: ,p_attribute_category in varchar2 default hr_api.g_varchar2

865: ,p_attribute27 in varchar2 default hr_api.g_varchar2
866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number

Line 870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

866: ,p_attribute28 in varchar2 default hr_api.g_varchar2
867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number

Line 871: ,p_date_from in date default hr_api.g_date

867: ,p_attribute29 in varchar2 default hr_api.g_varchar2
868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number

Line 872: ,p_date_to in date default hr_api.g_date

868: ,p_attribute30 in varchar2 default hr_api.g_varchar2
869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number

Line 873: ,p_primary_prof_field_id in number default hr_api.g_number

869: ,p_attribute_category in varchar2 default hr_api.g_varchar2
870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2

Line 874: ,p_starting_grade_id in number default hr_api.g_number

870: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2
878: ) is

Line 875: ,p_ben_pgm_id in number default hr_api.g_number

871: ,p_date_from in date default hr_api.g_date
872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2
878: ) is
879: --

Line 876: ,p_probation_period in number default hr_api.g_number

872: ,p_date_to in date default hr_api.g_date
873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2
878: ) is
879: --
880: l_rec pqh_cpd_shd.g_rec_type;

Line 877: ,p_probation_units in varchar2 default hr_api.g_varchar2

873: ,p_primary_prof_field_id in number default hr_api.g_number
874: ,p_starting_grade_id in number default hr_api.g_number
875: ,p_ben_pgm_id in number default hr_api.g_number
876: ,p_probation_period in number default hr_api.g_number
877: ,p_probation_units in varchar2 default hr_api.g_varchar2
878: ) is
879: --
880: l_rec pqh_cpd_shd.g_rec_type;
881: l_proc varchar2(72);