eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SIP_UPD dependencies on HR_API

Line 136: When hr_api.check_integrity_violated Then

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

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

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

Line 141: When hr_api.parent_integrity_violated Then

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

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

141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: per_sip_shd.g_api_dml := false; -- Unset the api dml status
144: per_sip_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_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error

Line 146: When hr_api.unique_integrity_violated Then

142: -- Parent integrity has been violated
143: per_sip_shd.g_api_dml := false; -- Unset the api dml status
144: per_sip_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_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 150: (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_sip_shd.g_api_dml := false; -- Unset the api dml status
149: per_sip_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: per_sip_shd.g_api_dml := false; -- Unset the api dml status
153: Raise;
154: End update_dml;

Line 475: when hr_api.cannot_find_prog_unit then

471: );
472: --
473: exception
474: --
475: when hr_api.cannot_find_prog_unit then
476: --
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'PER_SP_SUCCESSOR_IN_PLAN'
479: ,p_hook_type => 'AU');

Line 477: hr_api.cannot_find_prog_unit_error

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

Line 540: If (p_rec.plan_id = hr_api.g_number) then

536: -- p_rec plsql record structure
537: -- to see if a system default is being used. If a system default
538: -- is being used then we must set to the 'current' argument value.
539: --
540: If (p_rec.plan_id = hr_api.g_number) then
541: p_rec.plan_id :=
542: per_sip_shd.g_old_rec.plan_id;
543: End If;
544: If (p_rec.successor_id = hr_api.g_number) then

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

540: If (p_rec.plan_id = hr_api.g_number) then
541: p_rec.plan_id :=
542: per_sip_shd.g_old_rec.plan_id;
543: End If;
544: If (p_rec.successor_id = hr_api.g_number) then
545: p_rec.successor_id :=
546: per_sip_shd.g_old_rec.successor_id;
547: End If;
548: If (p_rec.business_group_id = hr_api.g_number) then

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

544: If (p_rec.successor_id = hr_api.g_number) then
545: p_rec.successor_id :=
546: per_sip_shd.g_old_rec.successor_id;
547: End If;
548: If (p_rec.business_group_id = hr_api.g_number) then
549: p_rec.business_group_id :=
550: per_sip_shd.g_old_rec.business_group_id;
551: End If;
552: If (p_rec.status = hr_api.g_varchar2) then

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

548: If (p_rec.business_group_id = hr_api.g_number) then
549: p_rec.business_group_id :=
550: per_sip_shd.g_old_rec.business_group_id;
551: End If;
552: If (p_rec.status = hr_api.g_varchar2) then
553: p_rec.status :=
554: per_sip_shd.g_old_rec.status;
555: End If;
556: If (p_rec.potential = hr_api.g_varchar2) then

Line 556: If (p_rec.potential = hr_api.g_varchar2) then

552: If (p_rec.status = hr_api.g_varchar2) then
553: p_rec.status :=
554: per_sip_shd.g_old_rec.status;
555: End If;
556: If (p_rec.potential = hr_api.g_varchar2) then
557: p_rec.potential :=
558: per_sip_shd.g_old_rec.potential;
559: End If;
560: If (p_rec.performance_rating = hr_api.g_varchar2) then

Line 560: If (p_rec.performance_rating = hr_api.g_varchar2) then

556: If (p_rec.potential = hr_api.g_varchar2) then
557: p_rec.potential :=
558: per_sip_shd.g_old_rec.potential;
559: End If;
560: If (p_rec.performance_rating = hr_api.g_varchar2) then
561: p_rec.performance_rating :=
562: per_sip_shd.g_old_rec.performance_rating;
563: End If;
564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then

Line 564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then

560: If (p_rec.performance_rating = hr_api.g_varchar2) then
561: p_rec.performance_rating :=
562: per_sip_shd.g_old_rec.performance_rating;
563: End If;
564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
565: p_rec.risk_of_loss :=
566: per_sip_shd.g_old_rec.risk_of_loss;
567: End If;
568: If (p_rec.impact_of_loss = hr_api.g_varchar2) then

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

564: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
565: p_rec.risk_of_loss :=
566: per_sip_shd.g_old_rec.risk_of_loss;
567: End If;
568: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
569: p_rec.impact_of_loss :=
570: per_sip_shd.g_old_rec.impact_of_loss;
571: End If;
572: If (p_rec.readiness_pct = hr_api.g_number) then

Line 572: If (p_rec.readiness_pct = hr_api.g_number) then

568: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
569: p_rec.impact_of_loss :=
570: per_sip_shd.g_old_rec.impact_of_loss;
571: End If;
572: If (p_rec.readiness_pct = hr_api.g_number) then
573: p_rec.readiness_pct :=
574: per_sip_shd.g_old_rec.readiness_pct;
575: End If;
576: If (p_rec.rank = hr_api.g_number) then

Line 576: If (p_rec.rank = hr_api.g_number) then

572: If (p_rec.readiness_pct = hr_api.g_number) then
573: p_rec.readiness_pct :=
574: per_sip_shd.g_old_rec.readiness_pct;
575: End If;
576: If (p_rec.rank = hr_api.g_number) then
577: p_rec.rank :=
578: per_sip_shd.g_old_rec.rank;
579: End If;
580: If (p_rec.eligible_for_promotion = hr_api.g_varchar2) then

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

576: If (p_rec.rank = hr_api.g_number) then
577: p_rec.rank :=
578: per_sip_shd.g_old_rec.rank;
579: End If;
580: If (p_rec.eligible_for_promotion = hr_api.g_varchar2) then
581: p_rec.eligible_for_promotion :=
582: per_sip_shd.g_old_rec.eligible_for_promotion;
583: End If;
584: If (p_rec.earliest_succession_date = hr_api.g_date) then

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

580: If (p_rec.eligible_for_promotion = hr_api.g_varchar2) then
581: p_rec.eligible_for_promotion :=
582: per_sip_shd.g_old_rec.eligible_for_promotion;
583: End If;
584: If (p_rec.earliest_succession_date = hr_api.g_date) then
585: p_rec.earliest_succession_date :=
586: per_sip_shd.g_old_rec.earliest_succession_date;
587: End If;
588: If (p_rec.latest_succession_date = hr_api.g_date) then

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

584: If (p_rec.earliest_succession_date = hr_api.g_date) then
585: p_rec.earliest_succession_date :=
586: per_sip_shd.g_old_rec.earliest_succession_date;
587: End If;
588: If (p_rec.latest_succession_date = hr_api.g_date) then
589: p_rec.latest_succession_date :=
590: per_sip_shd.g_old_rec.latest_succession_date;
591: End If;
592: If (p_rec.comments = hr_api.g_varchar2) then

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

588: If (p_rec.latest_succession_date = hr_api.g_date) then
589: p_rec.latest_succession_date :=
590: per_sip_shd.g_old_rec.latest_succession_date;
591: End If;
592: If (p_rec.comments = hr_api.g_varchar2) then
593: p_rec.comments :=
594: per_sip_shd.g_old_rec.comments;
595: End If;
596: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

592: If (p_rec.comments = hr_api.g_varchar2) then
593: p_rec.comments :=
594: per_sip_shd.g_old_rec.comments;
595: End If;
596: If (p_rec.attribute_category = hr_api.g_varchar2) then
597: p_rec.attribute_category :=
598: per_sip_shd.g_old_rec.attribute_category;
599: End If;
600: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

596: If (p_rec.attribute_category = hr_api.g_varchar2) then
597: p_rec.attribute_category :=
598: per_sip_shd.g_old_rec.attribute_category;
599: End If;
600: If (p_rec.attribute1 = hr_api.g_varchar2) then
601: p_rec.attribute1 :=
602: per_sip_shd.g_old_rec.attribute1;
603: End If;
604: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

600: If (p_rec.attribute1 = hr_api.g_varchar2) then
601: p_rec.attribute1 :=
602: per_sip_shd.g_old_rec.attribute1;
603: End If;
604: If (p_rec.attribute2 = hr_api.g_varchar2) then
605: p_rec.attribute2 :=
606: per_sip_shd.g_old_rec.attribute2;
607: End If;
608: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

604: If (p_rec.attribute2 = hr_api.g_varchar2) then
605: p_rec.attribute2 :=
606: per_sip_shd.g_old_rec.attribute2;
607: End If;
608: If (p_rec.attribute3 = hr_api.g_varchar2) then
609: p_rec.attribute3 :=
610: per_sip_shd.g_old_rec.attribute3;
611: End If;
612: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

608: If (p_rec.attribute3 = hr_api.g_varchar2) then
609: p_rec.attribute3 :=
610: per_sip_shd.g_old_rec.attribute3;
611: End If;
612: If (p_rec.attribute4 = hr_api.g_varchar2) then
613: p_rec.attribute4 :=
614: per_sip_shd.g_old_rec.attribute4;
615: End If;
616: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

612: If (p_rec.attribute4 = hr_api.g_varchar2) then
613: p_rec.attribute4 :=
614: per_sip_shd.g_old_rec.attribute4;
615: End If;
616: If (p_rec.attribute5 = hr_api.g_varchar2) then
617: p_rec.attribute5 :=
618: per_sip_shd.g_old_rec.attribute5;
619: End If;
620: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

616: If (p_rec.attribute5 = hr_api.g_varchar2) then
617: p_rec.attribute5 :=
618: per_sip_shd.g_old_rec.attribute5;
619: End If;
620: If (p_rec.attribute6 = hr_api.g_varchar2) then
621: p_rec.attribute6 :=
622: per_sip_shd.g_old_rec.attribute6;
623: End If;
624: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

620: If (p_rec.attribute6 = hr_api.g_varchar2) then
621: p_rec.attribute6 :=
622: per_sip_shd.g_old_rec.attribute6;
623: End If;
624: If (p_rec.attribute7 = hr_api.g_varchar2) then
625: p_rec.attribute7 :=
626: per_sip_shd.g_old_rec.attribute7;
627: End If;
628: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

624: If (p_rec.attribute7 = hr_api.g_varchar2) then
625: p_rec.attribute7 :=
626: per_sip_shd.g_old_rec.attribute7;
627: End If;
628: If (p_rec.attribute8 = hr_api.g_varchar2) then
629: p_rec.attribute8 :=
630: per_sip_shd.g_old_rec.attribute8;
631: End If;
632: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

628: If (p_rec.attribute8 = hr_api.g_varchar2) then
629: p_rec.attribute8 :=
630: per_sip_shd.g_old_rec.attribute8;
631: End If;
632: If (p_rec.attribute9 = hr_api.g_varchar2) then
633: p_rec.attribute9 :=
634: per_sip_shd.g_old_rec.attribute9;
635: End If;
636: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

632: If (p_rec.attribute9 = hr_api.g_varchar2) then
633: p_rec.attribute9 :=
634: per_sip_shd.g_old_rec.attribute9;
635: End If;
636: If (p_rec.attribute10 = hr_api.g_varchar2) then
637: p_rec.attribute10 :=
638: per_sip_shd.g_old_rec.attribute10;
639: End If;
640: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

636: If (p_rec.attribute10 = hr_api.g_varchar2) then
637: p_rec.attribute10 :=
638: per_sip_shd.g_old_rec.attribute10;
639: End If;
640: If (p_rec.attribute11 = hr_api.g_varchar2) then
641: p_rec.attribute11 :=
642: per_sip_shd.g_old_rec.attribute11;
643: End If;
644: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

640: If (p_rec.attribute11 = hr_api.g_varchar2) then
641: p_rec.attribute11 :=
642: per_sip_shd.g_old_rec.attribute11;
643: End If;
644: If (p_rec.attribute12 = hr_api.g_varchar2) then
645: p_rec.attribute12 :=
646: per_sip_shd.g_old_rec.attribute12;
647: End If;
648: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

644: If (p_rec.attribute12 = hr_api.g_varchar2) then
645: p_rec.attribute12 :=
646: per_sip_shd.g_old_rec.attribute12;
647: End If;
648: If (p_rec.attribute13 = hr_api.g_varchar2) then
649: p_rec.attribute13 :=
650: per_sip_shd.g_old_rec.attribute13;
651: End If;
652: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

648: If (p_rec.attribute13 = hr_api.g_varchar2) then
649: p_rec.attribute13 :=
650: per_sip_shd.g_old_rec.attribute13;
651: End If;
652: If (p_rec.attribute14 = hr_api.g_varchar2) then
653: p_rec.attribute14 :=
654: per_sip_shd.g_old_rec.attribute14;
655: End If;
656: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

652: If (p_rec.attribute14 = hr_api.g_varchar2) then
653: p_rec.attribute14 :=
654: per_sip_shd.g_old_rec.attribute14;
655: End If;
656: If (p_rec.attribute15 = hr_api.g_varchar2) then
657: p_rec.attribute15 :=
658: per_sip_shd.g_old_rec.attribute15;
659: End If;
660: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

656: If (p_rec.attribute15 = hr_api.g_varchar2) then
657: p_rec.attribute15 :=
658: per_sip_shd.g_old_rec.attribute15;
659: End If;
660: If (p_rec.attribute16 = hr_api.g_varchar2) then
661: p_rec.attribute16 :=
662: per_sip_shd.g_old_rec.attribute16;
663: End If;
664: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

660: If (p_rec.attribute16 = hr_api.g_varchar2) then
661: p_rec.attribute16 :=
662: per_sip_shd.g_old_rec.attribute16;
663: End If;
664: If (p_rec.attribute17 = hr_api.g_varchar2) then
665: p_rec.attribute17 :=
666: per_sip_shd.g_old_rec.attribute17;
667: End If;
668: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

664: If (p_rec.attribute17 = hr_api.g_varchar2) then
665: p_rec.attribute17 :=
666: per_sip_shd.g_old_rec.attribute17;
667: End If;
668: If (p_rec.attribute18 = hr_api.g_varchar2) then
669: p_rec.attribute18 :=
670: per_sip_shd.g_old_rec.attribute18;
671: End If;
672: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

668: If (p_rec.attribute18 = hr_api.g_varchar2) then
669: p_rec.attribute18 :=
670: per_sip_shd.g_old_rec.attribute18;
671: End If;
672: If (p_rec.attribute19 = hr_api.g_varchar2) then
673: p_rec.attribute19 :=
674: per_sip_shd.g_old_rec.attribute19;
675: End If;
676: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

672: If (p_rec.attribute19 = hr_api.g_varchar2) then
673: p_rec.attribute19 :=
674: per_sip_shd.g_old_rec.attribute19;
675: End If;
676: If (p_rec.attribute20 = hr_api.g_varchar2) then
677: p_rec.attribute20 :=
678: per_sip_shd.g_old_rec.attribute20;
679: End If;
680: If (p_rec.planned_date = hr_api.g_date) then

Line 680: If (p_rec.planned_date = hr_api.g_date) then

676: If (p_rec.attribute20 = hr_api.g_varchar2) then
677: p_rec.attribute20 :=
678: per_sip_shd.g_old_rec.attribute20;
679: End If;
680: If (p_rec.planned_date = hr_api.g_date) then
681: p_rec.planned_date :=
682: per_sip_shd.g_old_rec.planned_date;
683: End If;
684: If (p_rec.assignment_id = hr_api.g_number) then

Line 684: If (p_rec.assignment_id = hr_api.g_number) then

680: If (p_rec.planned_date = hr_api.g_date) then
681: p_rec.planned_date :=
682: per_sip_shd.g_old_rec.planned_date;
683: End If;
684: If (p_rec.assignment_id = hr_api.g_number) then
685: p_rec.assignment_id :=
686: per_sip_shd.g_old_rec.assignment_id;
687: End If;
688: If (p_rec.supervisor_id = hr_api.g_number) then

Line 688: If (p_rec.supervisor_id = hr_api.g_number) then

684: If (p_rec.assignment_id = hr_api.g_number) then
685: p_rec.assignment_id :=
686: per_sip_shd.g_old_rec.assignment_id;
687: End If;
688: If (p_rec.supervisor_id = hr_api.g_number) then
689: p_rec.supervisor_id :=
690: per_sip_shd.g_old_rec.supervisor_id;
691: End If;
692: If (p_rec.grade_id = hr_api.g_number) then

Line 692: If (p_rec.grade_id = hr_api.g_number) then

688: If (p_rec.supervisor_id = hr_api.g_number) then
689: p_rec.supervisor_id :=
690: per_sip_shd.g_old_rec.supervisor_id;
691: End If;
692: If (p_rec.grade_id = hr_api.g_number) then
693: p_rec.grade_id :=
694: per_sip_shd.g_old_rec.grade_id;
695: End If;
696: If (p_rec.grade_ladder_id = hr_api.g_number) then

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

692: If (p_rec.grade_id = hr_api.g_number) then
693: p_rec.grade_id :=
694: per_sip_shd.g_old_rec.grade_id;
695: End If;
696: If (p_rec.grade_ladder_id = hr_api.g_number) then
697: p_rec.grade_ladder_id :=
698: per_sip_shd.g_old_rec.grade_ladder_id;
699: End If;
700: If (p_rec.grade_step_id = hr_api.g_number) then

Line 700: If (p_rec.grade_step_id = hr_api.g_number) then

696: If (p_rec.grade_ladder_id = hr_api.g_number) then
697: p_rec.grade_ladder_id :=
698: per_sip_shd.g_old_rec.grade_ladder_id;
699: End If;
700: If (p_rec.grade_step_id = hr_api.g_number) then
701: p_rec.grade_step_id :=
702: per_sip_shd.g_old_rec.grade_step_id;
703: End If;
704: If (p_rec.grade_point_id = hr_api.g_number) then

Line 704: If (p_rec.grade_point_id = hr_api.g_number) then

700: If (p_rec.grade_step_id = hr_api.g_number) then
701: p_rec.grade_step_id :=
702: per_sip_shd.g_old_rec.grade_step_id;
703: End If;
704: If (p_rec.grade_point_id = hr_api.g_number) then
705: p_rec.grade_point_id :=
706: per_sip_shd.g_old_rec.grade_point_id;
707: End If;
708: If (p_rec.position_id = hr_api.g_number) then

Line 708: If (p_rec.position_id = hr_api.g_number) then

704: If (p_rec.grade_point_id = hr_api.g_number) then
705: p_rec.grade_point_id :=
706: per_sip_shd.g_old_rec.grade_point_id;
707: End If;
708: If (p_rec.position_id = hr_api.g_number) then
709: p_rec.position_id :=
710: per_sip_shd.g_old_rec.position_id;
711: End If;
712: If (p_rec.job_id = hr_api.g_number) then

Line 712: If (p_rec.job_id = hr_api.g_number) then

708: If (p_rec.position_id = hr_api.g_number) then
709: p_rec.position_id :=
710: per_sip_shd.g_old_rec.position_id;
711: End If;
712: If (p_rec.job_id = hr_api.g_number) then
713: p_rec.job_id :=
714: per_sip_shd.g_old_rec.job_id;
715: End If;
716: If (p_rec.assignment_status_type_id = hr_api.g_number) then

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

712: If (p_rec.job_id = hr_api.g_number) then
713: p_rec.job_id :=
714: per_sip_shd.g_old_rec.job_id;
715: End If;
716: If (p_rec.assignment_status_type_id = hr_api.g_number) then
717: p_rec.assignment_status_type_id :=
718: per_sip_shd.g_old_rec.assignment_status_type_id;
719: End If;
720: If (p_rec.organization_id = hr_api.g_number) then

Line 720: If (p_rec.organization_id = hr_api.g_number) then

716: If (p_rec.assignment_status_type_id = hr_api.g_number) then
717: p_rec.assignment_status_type_id :=
718: per_sip_shd.g_old_rec.assignment_status_type_id;
719: End If;
720: If (p_rec.organization_id = hr_api.g_number) then
721: p_rec.organization_id :=
722: per_sip_shd.g_old_rec.organization_id;
723: End If;
724: If (p_rec.people_group_id = hr_api.g_number) then

Line 724: If (p_rec.people_group_id = hr_api.g_number) then

720: If (p_rec.organization_id = hr_api.g_number) then
721: p_rec.organization_id :=
722: per_sip_shd.g_old_rec.organization_id;
723: End If;
724: If (p_rec.people_group_id = hr_api.g_number) then
725: p_rec.people_group_id :=
726: per_sip_shd.g_old_rec.people_group_id;
727: End If;
728: If (p_rec.pay_basis_id = hr_api.g_number) then

Line 728: If (p_rec.pay_basis_id = hr_api.g_number) then

724: If (p_rec.people_group_id = hr_api.g_number) then
725: p_rec.people_group_id :=
726: per_sip_shd.g_old_rec.people_group_id;
727: End If;
728: If (p_rec.pay_basis_id = hr_api.g_number) then
729: p_rec.pay_basis_id :=
730: per_sip_shd.g_old_rec.pay_basis_id;
731: End If;
732: If (p_rec.employee_category = hr_api.g_varchar2) then

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

728: If (p_rec.pay_basis_id = hr_api.g_number) then
729: p_rec.pay_basis_id :=
730: per_sip_shd.g_old_rec.pay_basis_id;
731: End If;
732: If (p_rec.employee_category = hr_api.g_varchar2) then
733: p_rec.employee_category :=
734: per_sip_shd.g_old_rec.employee_category;
735: End If;
736: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then

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

732: If (p_rec.employee_category = hr_api.g_varchar2) then
733: p_rec.employee_category :=
734: per_sip_shd.g_old_rec.employee_category;
735: End If;
736: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
737: p_rec.bargaining_unit_code :=
738: per_sip_shd.g_old_rec.bargaining_unit_code;
739: End If;
740: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then

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

736: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
737: p_rec.bargaining_unit_code :=
738: per_sip_shd.g_old_rec.bargaining_unit_code;
739: End If;
740: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
741: p_rec.labour_union_member_flag :=
742: per_sip_shd.g_old_rec.labour_union_member_flag;
743: End If;
744: If (p_rec.collective_agreement_id = hr_api.g_number) then

Line 744: If (p_rec.collective_agreement_id = hr_api.g_number) then

740: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
741: p_rec.labour_union_member_flag :=
742: per_sip_shd.g_old_rec.labour_union_member_flag;
743: End If;
744: If (p_rec.collective_agreement_id = hr_api.g_number) then
745: p_rec.collective_agreement_id :=
746: per_sip_shd.g_old_rec.collective_agreement_id;
747: End If;
748: If (p_rec.assignment_category = hr_api.g_varchar2) then

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

744: If (p_rec.collective_agreement_id = hr_api.g_number) then
745: p_rec.collective_agreement_id :=
746: per_sip_shd.g_old_rec.collective_agreement_id;
747: End If;
748: If (p_rec.assignment_category = hr_api.g_varchar2) then
749: p_rec.assignment_category :=
750: per_sip_shd.g_old_rec.assignment_category;
751: End If;
752: If (p_rec.location_id = hr_api.g_number) then

Line 752: If (p_rec.location_id = hr_api.g_number) then

748: If (p_rec.assignment_category = hr_api.g_varchar2) then
749: p_rec.assignment_category :=
750: per_sip_shd.g_old_rec.assignment_category;
751: End If;
752: If (p_rec.location_id = hr_api.g_number) then
753: p_rec.location_id :=
754: per_sip_shd.g_old_rec.location_id;
755: End If;
756: If (p_rec.contract_id = hr_api.g_number) then

Line 756: If (p_rec.contract_id = hr_api.g_number) then

752: If (p_rec.location_id = hr_api.g_number) then
753: p_rec.location_id :=
754: per_sip_shd.g_old_rec.location_id;
755: End If;
756: If (p_rec.contract_id = hr_api.g_number) then
757: p_rec.contract_id :=
758: per_sip_shd.g_old_rec.contract_id;
759: End If;
760: --

Line 824: ,p_plan_id in number default hr_api.g_number

820: Procedure upd
821: (p_effective_date in date
822: ,p_successor_in_plan_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_plan_id in number default hr_api.g_number
825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number

Line 825: ,p_successor_id in number default hr_api.g_number

821: (p_effective_date in date
822: ,p_successor_in_plan_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_plan_id in number default hr_api.g_number
825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2

Line 826: ,p_business_group_id in number default hr_api.g_number

822: ,p_successor_in_plan_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_plan_id in number default hr_api.g_number
825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2

Line 827: ,p_status in varchar2 default hr_api.g_varchar2

823: ,p_object_version_number in out nocopy number
824: ,p_plan_id in number default hr_api.g_number
825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2

Line 828: ,p_rank in number default hr_api.g_number

824: ,p_plan_id in number default hr_api.g_number
825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2

Line 829: ,p_potential in varchar2 default hr_api.g_varchar2

825: ,p_successor_id in number default hr_api.g_number
826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number

Line 830: ,p_performance_rating in varchar2 default hr_api.g_varchar2

826: ,p_business_group_id in number default hr_api.g_number
827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2

Line 831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2

827: ,p_status in varchar2 default hr_api.g_varchar2
828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date

Line 832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2

828: ,p_rank in number default hr_api.g_number
829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date

Line 833: ,p_readiness_pct in number default hr_api.g_number

829: ,p_potential in varchar2 default hr_api.g_varchar2
830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2

Line 834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2

830: ,p_performance_rating in varchar2 default hr_api.g_varchar2
831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 835: ,p_earliest_succession_date in date default hr_api.g_date

831: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category in varchar2 default hr_api.g_varchar2
839: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 836: ,p_latest_succession_date in date default hr_api.g_date

832: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_comments in varchar2 default hr_api.g_varchar2

833: ,p_readiness_pct in number default hr_api.g_number
834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_attribute_category in varchar2 default hr_api.g_varchar2

834: ,p_eligible_for_promotion in varchar2 default hr_api.g_varchar2
835: ,p_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_earliest_succession_date in date default hr_api.g_date
836: ,p_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_latest_succession_date in date default hr_api.g_date
837: ,p_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_comments in varchar2 default hr_api.g_varchar2
838: ,p_attribute_category 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_attribute_category 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_planned_date in date default hr_api.g_date

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_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number

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_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number

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_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number

Line 859: ,p_planned_date in date default hr_api.g_date

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_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number

Line 860: ,p_assignment_id in number default hr_api.g_number

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_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number

Line 861: ,p_supervisor_id in number default hr_api.g_number

857: ,p_attribute19 in varchar2 default hr_api.g_varchar2
858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number

Line 862: ,p_grade_id in number default hr_api.g_number

858: ,p_attribute20 in varchar2 default hr_api.g_varchar2
859: ,p_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number

Line 863: ,p_grade_ladder_id in number default hr_api.g_number

859: ,p_planned_date in date default hr_api.g_date
860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number

Line 864: ,p_grade_step_id in number default hr_api.g_number

860: ,p_assignment_id in number default hr_api.g_number
861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number

Line 865: ,p_grade_point_id in number default hr_api.g_number

861: ,p_supervisor_id in number default hr_api.g_number
862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number

Line 866: ,p_position_id in number default hr_api.g_number

862: ,p_grade_id in number default hr_api.g_number
863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number

Line 867: ,p_job_id in number default hr_api.g_number

863: ,p_grade_ladder_id in number default hr_api.g_number
864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number

Line 868: ,p_assignment_status_type_id in number default hr_api.g_number

864: ,p_grade_step_id in number default hr_api.g_number
865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 869: ,p_organization_id in number default hr_api.g_number

865: ,p_grade_point_id in number default hr_api.g_number
866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 870: ,p_people_group_id in number default hr_api.g_number

866: ,p_position_id in number default hr_api.g_number
867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 871: ,p_pay_basis_id in number default hr_api.g_number

867: ,p_job_id in number default hr_api.g_number
868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number

Line 872: ,p_employee_category in varchar2 default hr_api.g_varchar2

868: ,p_assignment_status_type_id in number default hr_api.g_number
869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

869: ,p_organization_id in number default hr_api.g_number
870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number

Line 874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

870: ,p_people_group_id in number default hr_api.g_number
871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number

Line 875: ,p_collective_agreement_id in number default hr_api.g_number

871: ,p_pay_basis_id in number default hr_api.g_number
872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number
879: ) is

Line 876: ,p_assignment_category in varchar2 default hr_api.g_varchar2

872: ,p_employee_category in varchar2 default hr_api.g_varchar2
873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number
879: ) is
880: --

Line 877: ,p_location_id in number default hr_api.g_number

873: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number
879: ) is
880: --
881: l_rec per_sip_shd.g_rec_type;

Line 878: ,p_contract_id in number default hr_api.g_number

874: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
875: ,p_collective_agreement_id in number default hr_api.g_number
876: ,p_assignment_category in varchar2 default hr_api.g_varchar2
877: ,p_location_id in number default hr_api.g_number
878: ,p_contract_id in number default hr_api.g_number
879: ) is
880: --
881: l_rec per_sip_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'upd';