DBA Data[Home] [Help]

APPS.PQH_PTX_UPD dependencies on HR_API

Line 212: When hr_api.check_integrity_violated Then

208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: --
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: pqh_ptx_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then

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

211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: pqh_ptx_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 216: When hr_api.parent_integrity_violated Then

212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: pqh_ptx_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then

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

215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: pqh_ptx_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 220: When hr_api.unique_integrity_violated Then

216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: pqh_ptx_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then

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

219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: pqh_ptx_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then
225: Raise;
226: End update_dml;
227: --

Line 658: when hr_api.cannot_find_prog_unit then

654: );
655: --
656: exception
657: --
658: when hr_api.cannot_find_prog_unit then
659: --
660: hr_api.cannot_find_prog_unit_error
661: (p_module_name => 'pqh_position_transactions'
662: ,p_hook_type => 'AU');

Line 660: hr_api.cannot_find_prog_unit_error

656: exception
657: --
658: when hr_api.cannot_find_prog_unit then
659: --
660: hr_api.cannot_find_prog_unit_error
661: (p_module_name => 'pqh_position_transactions'
662: ,p_hook_type => 'AU');
663: --
664: end;

Line 728: If (p_rec.action_date = hr_api.g_date) then

724: -- p_rec plsql record structure
725: -- to see if a system default is being used. If a system default
726: -- is being used then we must set to the 'current' argument value.
727: --
728: If (p_rec.action_date = hr_api.g_date) then
729: p_rec.action_date :=
730: pqh_ptx_shd.g_old_rec.action_date;
731: End If;
732: If (p_rec.position_id = hr_api.g_number) then

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

728: If (p_rec.action_date = hr_api.g_date) then
729: p_rec.action_date :=
730: pqh_ptx_shd.g_old_rec.action_date;
731: End If;
732: If (p_rec.position_id = hr_api.g_number) then
733: p_rec.position_id :=
734: pqh_ptx_shd.g_old_rec.position_id;
735: End If;
736: If (p_rec.availability_status_id = hr_api.g_number) then

Line 736: If (p_rec.availability_status_id = hr_api.g_number) then

732: If (p_rec.position_id = hr_api.g_number) then
733: p_rec.position_id :=
734: pqh_ptx_shd.g_old_rec.position_id;
735: End If;
736: If (p_rec.availability_status_id = hr_api.g_number) then
737: p_rec.availability_status_id :=
738: pqh_ptx_shd.g_old_rec.availability_status_id;
739: End If;
740: If (p_rec.business_group_id = hr_api.g_number) then

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

736: If (p_rec.availability_status_id = hr_api.g_number) then
737: p_rec.availability_status_id :=
738: pqh_ptx_shd.g_old_rec.availability_status_id;
739: End If;
740: If (p_rec.business_group_id = hr_api.g_number) then
741: p_rec.business_group_id :=
742: pqh_ptx_shd.g_old_rec.business_group_id;
743: End If;
744: If (p_rec.entry_step_id = hr_api.g_number) then

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

740: If (p_rec.business_group_id = hr_api.g_number) then
741: p_rec.business_group_id :=
742: pqh_ptx_shd.g_old_rec.business_group_id;
743: End If;
744: If (p_rec.entry_step_id = hr_api.g_number) then
745: p_rec.entry_step_id :=
746: pqh_ptx_shd.g_old_rec.entry_step_id;
747: End If;
748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then

Line 748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then

744: If (p_rec.entry_step_id = hr_api.g_number) then
745: p_rec.entry_step_id :=
746: pqh_ptx_shd.g_old_rec.entry_step_id;
747: End If;
748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
749: p_rec.entry_grade_rule_id :=
750: pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
751: End If;
752: If (p_rec.job_id = hr_api.g_number) then

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

748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
749: p_rec.entry_grade_rule_id :=
750: pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
751: End If;
752: If (p_rec.job_id = hr_api.g_number) then
753: p_rec.job_id :=
754: pqh_ptx_shd.g_old_rec.job_id;
755: End If;
756: If (p_rec.location_id = hr_api.g_number) then

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

752: If (p_rec.job_id = hr_api.g_number) then
753: p_rec.job_id :=
754: pqh_ptx_shd.g_old_rec.job_id;
755: End If;
756: If (p_rec.location_id = hr_api.g_number) then
757: p_rec.location_id :=
758: pqh_ptx_shd.g_old_rec.location_id;
759: End If;
760: If (p_rec.organization_id = hr_api.g_number) then

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

756: If (p_rec.location_id = hr_api.g_number) then
757: p_rec.location_id :=
758: pqh_ptx_shd.g_old_rec.location_id;
759: End If;
760: If (p_rec.organization_id = hr_api.g_number) then
761: p_rec.organization_id :=
762: pqh_ptx_shd.g_old_rec.organization_id;
763: End If;
764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then

Line 764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then

760: If (p_rec.organization_id = hr_api.g_number) then
761: p_rec.organization_id :=
762: pqh_ptx_shd.g_old_rec.organization_id;
763: End If;
764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
765: p_rec.pay_freq_payroll_id :=
766: pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
767: End If;
768: If (p_rec.position_definition_id = hr_api.g_number) then

Line 768: If (p_rec.position_definition_id = hr_api.g_number) then

764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
765: p_rec.pay_freq_payroll_id :=
766: pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
767: End If;
768: If (p_rec.position_definition_id = hr_api.g_number) then
769: p_rec.position_definition_id :=
770: pqh_ptx_shd.g_old_rec.position_definition_id;
771: End If;
772: If (p_rec.prior_position_id = hr_api.g_number) then

Line 772: If (p_rec.prior_position_id = hr_api.g_number) then

768: If (p_rec.position_definition_id = hr_api.g_number) then
769: p_rec.position_definition_id :=
770: pqh_ptx_shd.g_old_rec.position_definition_id;
771: End If;
772: If (p_rec.prior_position_id = hr_api.g_number) then
773: p_rec.prior_position_id :=
774: pqh_ptx_shd.g_old_rec.prior_position_id;
775: End If;
776: If (p_rec.relief_position_id = hr_api.g_number) then

Line 776: If (p_rec.relief_position_id = hr_api.g_number) then

772: If (p_rec.prior_position_id = hr_api.g_number) then
773: p_rec.prior_position_id :=
774: pqh_ptx_shd.g_old_rec.prior_position_id;
775: End If;
776: If (p_rec.relief_position_id = hr_api.g_number) then
777: p_rec.relief_position_id :=
778: pqh_ptx_shd.g_old_rec.relief_position_id;
779: End If;
780: If (p_rec.entry_grade_id = hr_api.g_number) then

Line 780: If (p_rec.entry_grade_id = hr_api.g_number) then

776: If (p_rec.relief_position_id = hr_api.g_number) then
777: p_rec.relief_position_id :=
778: pqh_ptx_shd.g_old_rec.relief_position_id;
779: End If;
780: If (p_rec.entry_grade_id = hr_api.g_number) then
781: p_rec.entry_grade_id :=
782: pqh_ptx_shd.g_old_rec.entry_grade_id;
783: End If;
784: If (p_rec.successor_position_id = hr_api.g_number) then

Line 784: If (p_rec.successor_position_id = hr_api.g_number) then

780: If (p_rec.entry_grade_id = hr_api.g_number) then
781: p_rec.entry_grade_id :=
782: pqh_ptx_shd.g_old_rec.entry_grade_id;
783: End If;
784: If (p_rec.successor_position_id = hr_api.g_number) then
785: p_rec.successor_position_id :=
786: pqh_ptx_shd.g_old_rec.successor_position_id;
787: End If;
788: If (p_rec.supervisor_position_id = hr_api.g_number) then

Line 788: If (p_rec.supervisor_position_id = hr_api.g_number) then

784: If (p_rec.successor_position_id = hr_api.g_number) then
785: p_rec.successor_position_id :=
786: pqh_ptx_shd.g_old_rec.successor_position_id;
787: End If;
788: If (p_rec.supervisor_position_id = hr_api.g_number) then
789: p_rec.supervisor_position_id :=
790: pqh_ptx_shd.g_old_rec.supervisor_position_id;
791: End If;
792: If (p_rec.amendment_date = hr_api.g_date) then

Line 792: If (p_rec.amendment_date = hr_api.g_date) then

788: If (p_rec.supervisor_position_id = hr_api.g_number) then
789: p_rec.supervisor_position_id :=
790: pqh_ptx_shd.g_old_rec.supervisor_position_id;
791: End If;
792: If (p_rec.amendment_date = hr_api.g_date) then
793: p_rec.amendment_date :=
794: pqh_ptx_shd.g_old_rec.amendment_date;
795: End If;
796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then

Line 796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then

792: If (p_rec.amendment_date = hr_api.g_date) then
793: p_rec.amendment_date :=
794: pqh_ptx_shd.g_old_rec.amendment_date;
795: End If;
796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
797: p_rec.amendment_recommendation :=
798: pqh_ptx_shd.g_old_rec.amendment_recommendation;
799: End If;
800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then

Line 800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then

796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
797: p_rec.amendment_recommendation :=
798: pqh_ptx_shd.g_old_rec.amendment_recommendation;
799: End If;
800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
801: p_rec.amendment_ref_number :=
802: pqh_ptx_shd.g_old_rec.amendment_ref_number;
803: End If;
804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then

Line 804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then

800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
801: p_rec.amendment_ref_number :=
802: pqh_ptx_shd.g_old_rec.amendment_ref_number;
803: End If;
804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
805: p_rec.avail_status_prop_end_date :=
806: pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
807: End If;
808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then

Line 808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then

804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
805: p_rec.avail_status_prop_end_date :=
806: pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
807: End If;
808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
809: p_rec.bargaining_unit_cd :=
810: pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
811: End If;
812: If (p_rec.comments = hr_api.g_varchar2) then

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

808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
809: p_rec.bargaining_unit_cd :=
810: pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
811: End If;
812: If (p_rec.comments = hr_api.g_varchar2) then
813: p_rec.comments :=
814: pqh_ptx_shd.g_old_rec.comments;
815: End If;
816: If (p_rec.country1 = hr_api.g_varchar2) then

Line 816: If (p_rec.country1 = hr_api.g_varchar2) then

812: If (p_rec.comments = hr_api.g_varchar2) then
813: p_rec.comments :=
814: pqh_ptx_shd.g_old_rec.comments;
815: End If;
816: If (p_rec.country1 = hr_api.g_varchar2) then
817: p_rec.country1 :=
818: pqh_ptx_shd.g_old_rec.country1;
819: End If;
820: If (p_rec.country2 = hr_api.g_varchar2) then

Line 820: If (p_rec.country2 = hr_api.g_varchar2) then

816: If (p_rec.country1 = hr_api.g_varchar2) then
817: p_rec.country1 :=
818: pqh_ptx_shd.g_old_rec.country1;
819: End If;
820: If (p_rec.country2 = hr_api.g_varchar2) then
821: p_rec.country2 :=
822: pqh_ptx_shd.g_old_rec.country2;
823: End If;
824: If (p_rec.country3 = hr_api.g_varchar2) then

Line 824: If (p_rec.country3 = hr_api.g_varchar2) then

820: If (p_rec.country2 = hr_api.g_varchar2) then
821: p_rec.country2 :=
822: pqh_ptx_shd.g_old_rec.country2;
823: End If;
824: If (p_rec.country3 = hr_api.g_varchar2) then
825: p_rec.country3 :=
826: pqh_ptx_shd.g_old_rec.country3;
827: End If;
828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then

Line 828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then

824: If (p_rec.country3 = hr_api.g_varchar2) then
825: p_rec.country3 :=
826: pqh_ptx_shd.g_old_rec.country3;
827: End If;
828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
829: p_rec.current_job_prop_end_date :=
830: pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
831: End If;
832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then

Line 832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then

828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
829: p_rec.current_job_prop_end_date :=
830: pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
831: End If;
832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
833: p_rec.current_org_prop_end_date :=
834: pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
835: End If;
836: If (p_rec.date_effective = hr_api.g_date) then

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

832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
833: p_rec.current_org_prop_end_date :=
834: pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
835: End If;
836: If (p_rec.date_effective = hr_api.g_date) then
837: p_rec.date_effective :=
838: pqh_ptx_shd.g_old_rec.date_effective;
839: End If;
840: If (p_rec.date_end = hr_api.g_date) then

Line 840: If (p_rec.date_end = hr_api.g_date) then

836: If (p_rec.date_effective = hr_api.g_date) then
837: p_rec.date_effective :=
838: pqh_ptx_shd.g_old_rec.date_effective;
839: End If;
840: If (p_rec.date_end = hr_api.g_date) then
841: p_rec.date_end :=
842: pqh_ptx_shd.g_old_rec.date_end;
843: End If;
844: If (p_rec.earliest_hire_date = hr_api.g_date) then

Line 844: If (p_rec.earliest_hire_date = hr_api.g_date) then

840: If (p_rec.date_end = hr_api.g_date) then
841: p_rec.date_end :=
842: pqh_ptx_shd.g_old_rec.date_end;
843: End If;
844: If (p_rec.earliest_hire_date = hr_api.g_date) then
845: p_rec.earliest_hire_date :=
846: pqh_ptx_shd.g_old_rec.earliest_hire_date;
847: End If;
848: If (p_rec.fill_by_date = hr_api.g_date) then

Line 848: If (p_rec.fill_by_date = hr_api.g_date) then

844: If (p_rec.earliest_hire_date = hr_api.g_date) then
845: p_rec.earliest_hire_date :=
846: pqh_ptx_shd.g_old_rec.earliest_hire_date;
847: End If;
848: If (p_rec.fill_by_date = hr_api.g_date) then
849: p_rec.fill_by_date :=
850: pqh_ptx_shd.g_old_rec.fill_by_date;
851: End If;
852: If (p_rec.frequency = hr_api.g_varchar2) then

Line 852: If (p_rec.frequency = hr_api.g_varchar2) then

848: If (p_rec.fill_by_date = hr_api.g_date) then
849: p_rec.fill_by_date :=
850: pqh_ptx_shd.g_old_rec.fill_by_date;
851: End If;
852: If (p_rec.frequency = hr_api.g_varchar2) then
853: p_rec.frequency :=
854: pqh_ptx_shd.g_old_rec.frequency;
855: End If;
856: If (p_rec.fte = hr_api.g_number) then

Line 856: If (p_rec.fte = hr_api.g_number) then

852: If (p_rec.frequency = hr_api.g_varchar2) then
853: p_rec.frequency :=
854: pqh_ptx_shd.g_old_rec.frequency;
855: End If;
856: If (p_rec.fte = hr_api.g_number) then
857: p_rec.fte :=
858: pqh_ptx_shd.g_old_rec.fte;
859: End If;
860: If (p_rec.fte_capacity = hr_api.g_varchar2) then

Line 860: If (p_rec.fte_capacity = hr_api.g_varchar2) then

856: If (p_rec.fte = hr_api.g_number) then
857: p_rec.fte :=
858: pqh_ptx_shd.g_old_rec.fte;
859: End If;
860: If (p_rec.fte_capacity = hr_api.g_varchar2) then
861: p_rec.fte_capacity :=
862: pqh_ptx_shd.g_old_rec.fte_capacity;
863: End If;
864: If (p_rec.location1 = hr_api.g_varchar2) then

Line 864: If (p_rec.location1 = hr_api.g_varchar2) then

860: If (p_rec.fte_capacity = hr_api.g_varchar2) then
861: p_rec.fte_capacity :=
862: pqh_ptx_shd.g_old_rec.fte_capacity;
863: End If;
864: If (p_rec.location1 = hr_api.g_varchar2) then
865: p_rec.location1 :=
866: pqh_ptx_shd.g_old_rec.location1;
867: End If;
868: If (p_rec.location2 = hr_api.g_varchar2) then

Line 868: If (p_rec.location2 = hr_api.g_varchar2) then

864: If (p_rec.location1 = hr_api.g_varchar2) then
865: p_rec.location1 :=
866: pqh_ptx_shd.g_old_rec.location1;
867: End If;
868: If (p_rec.location2 = hr_api.g_varchar2) then
869: p_rec.location2 :=
870: pqh_ptx_shd.g_old_rec.location2;
871: End If;
872: If (p_rec.location3 = hr_api.g_varchar2) then

Line 872: If (p_rec.location3 = hr_api.g_varchar2) then

868: If (p_rec.location2 = hr_api.g_varchar2) then
869: p_rec.location2 :=
870: pqh_ptx_shd.g_old_rec.location2;
871: End If;
872: If (p_rec.location3 = hr_api.g_varchar2) then
873: p_rec.location3 :=
874: pqh_ptx_shd.g_old_rec.location3;
875: End If;
876: If (p_rec.max_persons = hr_api.g_number) then

Line 876: If (p_rec.max_persons = hr_api.g_number) then

872: If (p_rec.location3 = hr_api.g_varchar2) then
873: p_rec.location3 :=
874: pqh_ptx_shd.g_old_rec.location3;
875: End If;
876: If (p_rec.max_persons = hr_api.g_number) then
877: p_rec.max_persons :=
878: pqh_ptx_shd.g_old_rec.max_persons;
879: End If;
880: If (p_rec.name = hr_api.g_varchar2) then

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

876: If (p_rec.max_persons = hr_api.g_number) then
877: p_rec.max_persons :=
878: pqh_ptx_shd.g_old_rec.max_persons;
879: End If;
880: If (p_rec.name = hr_api.g_varchar2) then
881: p_rec.name :=
882: pqh_ptx_shd.g_old_rec.name;
883: End If;
884: If (p_rec.other_requirements = hr_api.g_varchar2) then

Line 884: If (p_rec.other_requirements = hr_api.g_varchar2) then

880: If (p_rec.name = hr_api.g_varchar2) then
881: p_rec.name :=
882: pqh_ptx_shd.g_old_rec.name;
883: End If;
884: If (p_rec.other_requirements = hr_api.g_varchar2) then
885: p_rec.other_requirements :=
886: pqh_ptx_shd.g_old_rec.other_requirements;
887: End If;
888: If (p_rec.overlap_period = hr_api.g_number) then

Line 888: If (p_rec.overlap_period = hr_api.g_number) then

884: If (p_rec.other_requirements = hr_api.g_varchar2) then
885: p_rec.other_requirements :=
886: pqh_ptx_shd.g_old_rec.other_requirements;
887: End If;
888: If (p_rec.overlap_period = hr_api.g_number) then
889: p_rec.overlap_period :=
890: pqh_ptx_shd.g_old_rec.overlap_period;
891: End If;
892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then

Line 892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then

888: If (p_rec.overlap_period = hr_api.g_number) then
889: p_rec.overlap_period :=
890: pqh_ptx_shd.g_old_rec.overlap_period;
891: End If;
892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
893: p_rec.overlap_unit_cd :=
894: pqh_ptx_shd.g_old_rec.overlap_unit_cd;
895: End If;
896: If (p_rec.passport_required = hr_api.g_varchar2) then

Line 896: If (p_rec.passport_required = hr_api.g_varchar2) then

892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
893: p_rec.overlap_unit_cd :=
894: pqh_ptx_shd.g_old_rec.overlap_unit_cd;
895: End If;
896: If (p_rec.passport_required = hr_api.g_varchar2) then
897: p_rec.passport_required :=
898: pqh_ptx_shd.g_old_rec.passport_required;
899: End If;
900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then

Line 900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then

896: If (p_rec.passport_required = hr_api.g_varchar2) then
897: p_rec.passport_required :=
898: pqh_ptx_shd.g_old_rec.passport_required;
899: End If;
900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
901: p_rec.pay_term_end_day_cd :=
902: pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
903: End If;
904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then

Line 904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then

900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
901: p_rec.pay_term_end_day_cd :=
902: pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
903: End If;
904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
905: p_rec.pay_term_end_month_cd :=
906: pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
907: End If;
908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then

Line 908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then

904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
905: p_rec.pay_term_end_month_cd :=
906: pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
907: End If;
908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
909: p_rec.permanent_temporary_flag :=
910: pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
911: End If;
912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then

Line 912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then

908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
909: p_rec.permanent_temporary_flag :=
910: pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
911: End If;
912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
913: p_rec.permit_recruitment_flag :=
914: pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
915: End If;
916: If (p_rec.position_type = hr_api.g_varchar2) then

Line 916: If (p_rec.position_type = hr_api.g_varchar2) then

912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
913: p_rec.permit_recruitment_flag :=
914: pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
915: End If;
916: If (p_rec.position_type = hr_api.g_varchar2) then
917: p_rec.position_type :=
918: pqh_ptx_shd.g_old_rec.position_type;
919: End If;
920: If (p_rec.posting_description = hr_api.g_varchar2) then

Line 920: If (p_rec.posting_description = hr_api.g_varchar2) then

916: If (p_rec.position_type = hr_api.g_varchar2) then
917: p_rec.position_type :=
918: pqh_ptx_shd.g_old_rec.position_type;
919: End If;
920: If (p_rec.posting_description = hr_api.g_varchar2) then
921: p_rec.posting_description :=
922: pqh_ptx_shd.g_old_rec.posting_description;
923: End If;
924: If (p_rec.probation_period = hr_api.g_number) then

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

920: If (p_rec.posting_description = hr_api.g_varchar2) then
921: p_rec.posting_description :=
922: pqh_ptx_shd.g_old_rec.posting_description;
923: End If;
924: If (p_rec.probation_period = hr_api.g_number) then
925: p_rec.probation_period :=
926: pqh_ptx_shd.g_old_rec.probation_period;
927: End If;
928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then

Line 928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then

924: If (p_rec.probation_period = hr_api.g_number) then
925: p_rec.probation_period :=
926: pqh_ptx_shd.g_old_rec.probation_period;
927: End If;
928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
929: p_rec.probation_period_unit_cd :=
930: pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
931: End If;
932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then

Line 932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then

928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
929: p_rec.probation_period_unit_cd :=
930: pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
931: End If;
932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
933: p_rec.relocate_domestically :=
934: pqh_ptx_shd.g_old_rec.relocate_domestically;
935: End If;
936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then

Line 936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then

932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
933: p_rec.relocate_domestically :=
934: pqh_ptx_shd.g_old_rec.relocate_domestically;
935: End If;
936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
937: p_rec.relocate_internationally :=
938: pqh_ptx_shd.g_old_rec.relocate_internationally;
939: End If;
940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then

Line 940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then

936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
937: p_rec.relocate_internationally :=
938: pqh_ptx_shd.g_old_rec.relocate_internationally;
939: End If;
940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
941: p_rec.replacement_required_flag :=
942: pqh_ptx_shd.g_old_rec.replacement_required_flag;
943: End If;
944: If (p_rec.review_flag = hr_api.g_varchar2) then

Line 944: If (p_rec.review_flag = hr_api.g_varchar2) then

940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
941: p_rec.replacement_required_flag :=
942: pqh_ptx_shd.g_old_rec.replacement_required_flag;
943: End If;
944: If (p_rec.review_flag = hr_api.g_varchar2) then
945: p_rec.review_flag :=
946: pqh_ptx_shd.g_old_rec.review_flag;
947: End If;
948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then

Line 948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then

944: If (p_rec.review_flag = hr_api.g_varchar2) then
945: p_rec.review_flag :=
946: pqh_ptx_shd.g_old_rec.review_flag;
947: End If;
948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
949: p_rec.seasonal_flag :=
950: pqh_ptx_shd.g_old_rec.seasonal_flag;
951: End If;
952: If (p_rec.security_requirements = hr_api.g_varchar2) then

Line 952: If (p_rec.security_requirements = hr_api.g_varchar2) then

948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
949: p_rec.seasonal_flag :=
950: pqh_ptx_shd.g_old_rec.seasonal_flag;
951: End If;
952: If (p_rec.security_requirements = hr_api.g_varchar2) then
953: p_rec.security_requirements :=
954: pqh_ptx_shd.g_old_rec.security_requirements;
955: End If;
956: If (p_rec.service_minimum = hr_api.g_varchar2) then

Line 956: If (p_rec.service_minimum = hr_api.g_varchar2) then

952: If (p_rec.security_requirements = hr_api.g_varchar2) then
953: p_rec.security_requirements :=
954: pqh_ptx_shd.g_old_rec.security_requirements;
955: End If;
956: If (p_rec.service_minimum = hr_api.g_varchar2) then
957: p_rec.service_minimum :=
958: pqh_ptx_shd.g_old_rec.service_minimum;
959: End If;
960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then

Line 960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then

956: If (p_rec.service_minimum = hr_api.g_varchar2) then
957: p_rec.service_minimum :=
958: pqh_ptx_shd.g_old_rec.service_minimum;
959: End If;
960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
961: p_rec.term_start_day_cd :=
962: pqh_ptx_shd.g_old_rec.term_start_day_cd;
963: End If;
964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then

Line 964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then

960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
961: p_rec.term_start_day_cd :=
962: pqh_ptx_shd.g_old_rec.term_start_day_cd;
963: End If;
964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
965: p_rec.term_start_month_cd :=
966: pqh_ptx_shd.g_old_rec.term_start_month_cd;
967: End If;
968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then

Line 968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then

964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
965: p_rec.term_start_month_cd :=
966: pqh_ptx_shd.g_old_rec.term_start_month_cd;
967: End If;
968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
969: p_rec.time_normal_finish :=
970: pqh_ptx_shd.g_old_rec.time_normal_finish;
971: End If;
972: If (p_rec.time_normal_start = hr_api.g_varchar2) then

Line 972: If (p_rec.time_normal_start = hr_api.g_varchar2) then

968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
969: p_rec.time_normal_finish :=
970: pqh_ptx_shd.g_old_rec.time_normal_finish;
971: End If;
972: If (p_rec.time_normal_start = hr_api.g_varchar2) then
973: p_rec.time_normal_start :=
974: pqh_ptx_shd.g_old_rec.time_normal_start;
975: End If;
976: If (p_rec.transaction_status = hr_api.g_varchar2) then

Line 976: If (p_rec.transaction_status = hr_api.g_varchar2) then

972: If (p_rec.time_normal_start = hr_api.g_varchar2) then
973: p_rec.time_normal_start :=
974: pqh_ptx_shd.g_old_rec.time_normal_start;
975: End If;
976: If (p_rec.transaction_status = hr_api.g_varchar2) then
977: p_rec.transaction_status :=
978: pqh_ptx_shd.g_old_rec.transaction_status;
979: End If;
980: If (p_rec.travel_required = hr_api.g_varchar2) then

Line 980: If (p_rec.travel_required = hr_api.g_varchar2) then

976: If (p_rec.transaction_status = hr_api.g_varchar2) then
977: p_rec.transaction_status :=
978: pqh_ptx_shd.g_old_rec.transaction_status;
979: End If;
980: If (p_rec.travel_required = hr_api.g_varchar2) then
981: p_rec.travel_required :=
982: pqh_ptx_shd.g_old_rec.travel_required;
983: End If;
984: If (p_rec.working_hours = hr_api.g_number) then

Line 984: If (p_rec.working_hours = hr_api.g_number) then

980: If (p_rec.travel_required = hr_api.g_varchar2) then
981: p_rec.travel_required :=
982: pqh_ptx_shd.g_old_rec.travel_required;
983: End If;
984: If (p_rec.working_hours = hr_api.g_number) then
985: p_rec.working_hours :=
986: pqh_ptx_shd.g_old_rec.working_hours;
987: End If;
988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then

Line 988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then

984: If (p_rec.working_hours = hr_api.g_number) then
985: p_rec.working_hours :=
986: pqh_ptx_shd.g_old_rec.working_hours;
987: End If;
988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
989: p_rec.works_council_approval_flag :=
990: pqh_ptx_shd.g_old_rec.works_council_approval_flag;
991: End If;
992: If (p_rec.work_any_country = hr_api.g_varchar2) then

Line 992: If (p_rec.work_any_country = hr_api.g_varchar2) then

988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
989: p_rec.works_council_approval_flag :=
990: pqh_ptx_shd.g_old_rec.works_council_approval_flag;
991: End If;
992: If (p_rec.work_any_country = hr_api.g_varchar2) then
993: p_rec.work_any_country :=
994: pqh_ptx_shd.g_old_rec.work_any_country;
995: End If;
996: If (p_rec.work_any_location = hr_api.g_varchar2) then

Line 996: If (p_rec.work_any_location = hr_api.g_varchar2) then

992: If (p_rec.work_any_country = hr_api.g_varchar2) then
993: p_rec.work_any_country :=
994: pqh_ptx_shd.g_old_rec.work_any_country;
995: End If;
996: If (p_rec.work_any_location = hr_api.g_varchar2) then
997: p_rec.work_any_location :=
998: pqh_ptx_shd.g_old_rec.work_any_location;
999: End If;
1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then

Line 1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then

996: If (p_rec.work_any_location = hr_api.g_varchar2) then
997: p_rec.work_any_location :=
998: pqh_ptx_shd.g_old_rec.work_any_location;
999: End If;
1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1001: p_rec.work_period_type_cd :=
1002: pqh_ptx_shd.g_old_rec.work_period_type_cd;
1003: End If;
1004: If (p_rec.work_schedule = hr_api.g_varchar2) then

Line 1004: If (p_rec.work_schedule = hr_api.g_varchar2) then

1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1001: p_rec.work_period_type_cd :=
1002: pqh_ptx_shd.g_old_rec.work_period_type_cd;
1003: End If;
1004: If (p_rec.work_schedule = hr_api.g_varchar2) then
1005: p_rec.work_schedule :=
1006: pqh_ptx_shd.g_old_rec.work_schedule;
1007: End If;
1008: If (p_rec.work_duration = hr_api.g_varchar2) then

Line 1008: If (p_rec.work_duration = hr_api.g_varchar2) then

1004: If (p_rec.work_schedule = hr_api.g_varchar2) then
1005: p_rec.work_schedule :=
1006: pqh_ptx_shd.g_old_rec.work_schedule;
1007: End If;
1008: If (p_rec.work_duration = hr_api.g_varchar2) then
1009: p_rec.work_duration :=
1010: pqh_ptx_shd.g_old_rec.work_duration;
1011: End If;
1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then

Line 1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then

1008: If (p_rec.work_duration = hr_api.g_varchar2) then
1009: p_rec.work_duration :=
1010: pqh_ptx_shd.g_old_rec.work_duration;
1011: End If;
1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1013: p_rec.work_term_end_day_cd :=
1014: pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1015: End If;
1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then

Line 1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then

1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1013: p_rec.work_term_end_day_cd :=
1014: pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1015: End If;
1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1017: p_rec.work_term_end_month_cd :=
1018: pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1019: End If;
1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then

Line 1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then

1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1017: p_rec.work_term_end_month_cd :=
1018: pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1019: End If;
1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1021: p_rec.proposed_fte_for_layoff :=
1022: pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1023: End If;
1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then

Line 1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then

1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1021: p_rec.proposed_fte_for_layoff :=
1022: pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1023: End If;
1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1025: p_rec.proposed_date_for_layoff :=
1026: pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1027: End If;
1028: If (p_rec.information1 = hr_api.g_varchar2) then

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

1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1025: p_rec.proposed_date_for_layoff :=
1026: pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1027: End If;
1028: If (p_rec.information1 = hr_api.g_varchar2) then
1029: p_rec.information1 :=
1030: pqh_ptx_shd.g_old_rec.information1;
1031: End If;
1032: If (p_rec.information2 = hr_api.g_varchar2) then

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

1028: If (p_rec.information1 = hr_api.g_varchar2) then
1029: p_rec.information1 :=
1030: pqh_ptx_shd.g_old_rec.information1;
1031: End If;
1032: If (p_rec.information2 = hr_api.g_varchar2) then
1033: p_rec.information2 :=
1034: pqh_ptx_shd.g_old_rec.information2;
1035: End If;
1036: If (p_rec.information3 = hr_api.g_varchar2) then

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

1032: If (p_rec.information2 = hr_api.g_varchar2) then
1033: p_rec.information2 :=
1034: pqh_ptx_shd.g_old_rec.information2;
1035: End If;
1036: If (p_rec.information3 = hr_api.g_varchar2) then
1037: p_rec.information3 :=
1038: pqh_ptx_shd.g_old_rec.information3;
1039: End If;
1040: If (p_rec.information4 = hr_api.g_varchar2) then

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

1036: If (p_rec.information3 = hr_api.g_varchar2) then
1037: p_rec.information3 :=
1038: pqh_ptx_shd.g_old_rec.information3;
1039: End If;
1040: If (p_rec.information4 = hr_api.g_varchar2) then
1041: p_rec.information4 :=
1042: pqh_ptx_shd.g_old_rec.information4;
1043: End If;
1044: If (p_rec.information5 = hr_api.g_varchar2) then

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

1040: If (p_rec.information4 = hr_api.g_varchar2) then
1041: p_rec.information4 :=
1042: pqh_ptx_shd.g_old_rec.information4;
1043: End If;
1044: If (p_rec.information5 = hr_api.g_varchar2) then
1045: p_rec.information5 :=
1046: pqh_ptx_shd.g_old_rec.information5;
1047: End If;
1048: If (p_rec.information6 = hr_api.g_varchar2) then

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

1044: If (p_rec.information5 = hr_api.g_varchar2) then
1045: p_rec.information5 :=
1046: pqh_ptx_shd.g_old_rec.information5;
1047: End If;
1048: If (p_rec.information6 = hr_api.g_varchar2) then
1049: p_rec.information6 :=
1050: pqh_ptx_shd.g_old_rec.information6;
1051: End If;
1052: If (p_rec.information7 = hr_api.g_varchar2) then

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

1048: If (p_rec.information6 = hr_api.g_varchar2) then
1049: p_rec.information6 :=
1050: pqh_ptx_shd.g_old_rec.information6;
1051: End If;
1052: If (p_rec.information7 = hr_api.g_varchar2) then
1053: p_rec.information7 :=
1054: pqh_ptx_shd.g_old_rec.information7;
1055: End If;
1056: If (p_rec.information8 = hr_api.g_varchar2) then

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

1052: If (p_rec.information7 = hr_api.g_varchar2) then
1053: p_rec.information7 :=
1054: pqh_ptx_shd.g_old_rec.information7;
1055: End If;
1056: If (p_rec.information8 = hr_api.g_varchar2) then
1057: p_rec.information8 :=
1058: pqh_ptx_shd.g_old_rec.information8;
1059: End If;
1060: If (p_rec.information9 = hr_api.g_varchar2) then

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

1056: If (p_rec.information8 = hr_api.g_varchar2) then
1057: p_rec.information8 :=
1058: pqh_ptx_shd.g_old_rec.information8;
1059: End If;
1060: If (p_rec.information9 = hr_api.g_varchar2) then
1061: p_rec.information9 :=
1062: pqh_ptx_shd.g_old_rec.information9;
1063: End If;
1064: If (p_rec.information10 = hr_api.g_varchar2) then

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

1060: If (p_rec.information9 = hr_api.g_varchar2) then
1061: p_rec.information9 :=
1062: pqh_ptx_shd.g_old_rec.information9;
1063: End If;
1064: If (p_rec.information10 = hr_api.g_varchar2) then
1065: p_rec.information10 :=
1066: pqh_ptx_shd.g_old_rec.information10;
1067: End If;
1068: If (p_rec.information11 = hr_api.g_varchar2) then

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

1064: If (p_rec.information10 = hr_api.g_varchar2) then
1065: p_rec.information10 :=
1066: pqh_ptx_shd.g_old_rec.information10;
1067: End If;
1068: If (p_rec.information11 = hr_api.g_varchar2) then
1069: p_rec.information11 :=
1070: pqh_ptx_shd.g_old_rec.information11;
1071: End If;
1072: If (p_rec.information12 = hr_api.g_varchar2) then

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

1068: If (p_rec.information11 = hr_api.g_varchar2) then
1069: p_rec.information11 :=
1070: pqh_ptx_shd.g_old_rec.information11;
1071: End If;
1072: If (p_rec.information12 = hr_api.g_varchar2) then
1073: p_rec.information12 :=
1074: pqh_ptx_shd.g_old_rec.information12;
1075: End If;
1076: If (p_rec.information13 = hr_api.g_varchar2) then

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

1072: If (p_rec.information12 = hr_api.g_varchar2) then
1073: p_rec.information12 :=
1074: pqh_ptx_shd.g_old_rec.information12;
1075: End If;
1076: If (p_rec.information13 = hr_api.g_varchar2) then
1077: p_rec.information13 :=
1078: pqh_ptx_shd.g_old_rec.information13;
1079: End If;
1080: If (p_rec.information14 = hr_api.g_varchar2) then

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

1076: If (p_rec.information13 = hr_api.g_varchar2) then
1077: p_rec.information13 :=
1078: pqh_ptx_shd.g_old_rec.information13;
1079: End If;
1080: If (p_rec.information14 = hr_api.g_varchar2) then
1081: p_rec.information14 :=
1082: pqh_ptx_shd.g_old_rec.information14;
1083: End If;
1084: If (p_rec.information15 = hr_api.g_varchar2) then

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

1080: If (p_rec.information14 = hr_api.g_varchar2) then
1081: p_rec.information14 :=
1082: pqh_ptx_shd.g_old_rec.information14;
1083: End If;
1084: If (p_rec.information15 = hr_api.g_varchar2) then
1085: p_rec.information15 :=
1086: pqh_ptx_shd.g_old_rec.information15;
1087: End If;
1088: If (p_rec.information16 = hr_api.g_varchar2) then

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

1084: If (p_rec.information15 = hr_api.g_varchar2) then
1085: p_rec.information15 :=
1086: pqh_ptx_shd.g_old_rec.information15;
1087: End If;
1088: If (p_rec.information16 = hr_api.g_varchar2) then
1089: p_rec.information16 :=
1090: pqh_ptx_shd.g_old_rec.information16;
1091: End If;
1092: If (p_rec.information17 = hr_api.g_varchar2) then

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

1088: If (p_rec.information16 = hr_api.g_varchar2) then
1089: p_rec.information16 :=
1090: pqh_ptx_shd.g_old_rec.information16;
1091: End If;
1092: If (p_rec.information17 = hr_api.g_varchar2) then
1093: p_rec.information17 :=
1094: pqh_ptx_shd.g_old_rec.information17;
1095: End If;
1096: If (p_rec.information18 = hr_api.g_varchar2) then

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

1092: If (p_rec.information17 = hr_api.g_varchar2) then
1093: p_rec.information17 :=
1094: pqh_ptx_shd.g_old_rec.information17;
1095: End If;
1096: If (p_rec.information18 = hr_api.g_varchar2) then
1097: p_rec.information18 :=
1098: pqh_ptx_shd.g_old_rec.information18;
1099: End If;
1100: If (p_rec.information19 = hr_api.g_varchar2) then

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

1096: If (p_rec.information18 = hr_api.g_varchar2) then
1097: p_rec.information18 :=
1098: pqh_ptx_shd.g_old_rec.information18;
1099: End If;
1100: If (p_rec.information19 = hr_api.g_varchar2) then
1101: p_rec.information19 :=
1102: pqh_ptx_shd.g_old_rec.information19;
1103: End If;
1104: If (p_rec.information20 = hr_api.g_varchar2) then

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

1100: If (p_rec.information19 = hr_api.g_varchar2) then
1101: p_rec.information19 :=
1102: pqh_ptx_shd.g_old_rec.information19;
1103: End If;
1104: If (p_rec.information20 = hr_api.g_varchar2) then
1105: p_rec.information20 :=
1106: pqh_ptx_shd.g_old_rec.information20;
1107: End If;
1108: If (p_rec.information21 = hr_api.g_varchar2) then

Line 1108: If (p_rec.information21 = hr_api.g_varchar2) then

1104: If (p_rec.information20 = hr_api.g_varchar2) then
1105: p_rec.information20 :=
1106: pqh_ptx_shd.g_old_rec.information20;
1107: End If;
1108: If (p_rec.information21 = hr_api.g_varchar2) then
1109: p_rec.information21 :=
1110: pqh_ptx_shd.g_old_rec.information21;
1111: End If;
1112: If (p_rec.information22 = hr_api.g_varchar2) then

Line 1112: If (p_rec.information22 = hr_api.g_varchar2) then

1108: If (p_rec.information21 = hr_api.g_varchar2) then
1109: p_rec.information21 :=
1110: pqh_ptx_shd.g_old_rec.information21;
1111: End If;
1112: If (p_rec.information22 = hr_api.g_varchar2) then
1113: p_rec.information22 :=
1114: pqh_ptx_shd.g_old_rec.information22;
1115: End If;
1116: If (p_rec.information23 = hr_api.g_varchar2) then

Line 1116: If (p_rec.information23 = hr_api.g_varchar2) then

1112: If (p_rec.information22 = hr_api.g_varchar2) then
1113: p_rec.information22 :=
1114: pqh_ptx_shd.g_old_rec.information22;
1115: End If;
1116: If (p_rec.information23 = hr_api.g_varchar2) then
1117: p_rec.information23 :=
1118: pqh_ptx_shd.g_old_rec.information23;
1119: End If;
1120: If (p_rec.information24 = hr_api.g_varchar2) then

Line 1120: If (p_rec.information24 = hr_api.g_varchar2) then

1116: If (p_rec.information23 = hr_api.g_varchar2) then
1117: p_rec.information23 :=
1118: pqh_ptx_shd.g_old_rec.information23;
1119: End If;
1120: If (p_rec.information24 = hr_api.g_varchar2) then
1121: p_rec.information24 :=
1122: pqh_ptx_shd.g_old_rec.information24;
1123: End If;
1124: If (p_rec.information25 = hr_api.g_varchar2) then

Line 1124: If (p_rec.information25 = hr_api.g_varchar2) then

1120: If (p_rec.information24 = hr_api.g_varchar2) then
1121: p_rec.information24 :=
1122: pqh_ptx_shd.g_old_rec.information24;
1123: End If;
1124: If (p_rec.information25 = hr_api.g_varchar2) then
1125: p_rec.information25 :=
1126: pqh_ptx_shd.g_old_rec.information25;
1127: End If;
1128: If (p_rec.information26 = hr_api.g_varchar2) then

Line 1128: If (p_rec.information26 = hr_api.g_varchar2) then

1124: If (p_rec.information25 = hr_api.g_varchar2) then
1125: p_rec.information25 :=
1126: pqh_ptx_shd.g_old_rec.information25;
1127: End If;
1128: If (p_rec.information26 = hr_api.g_varchar2) then
1129: p_rec.information26 :=
1130: pqh_ptx_shd.g_old_rec.information26;
1131: End If;
1132: If (p_rec.information27 = hr_api.g_varchar2) then

Line 1132: If (p_rec.information27 = hr_api.g_varchar2) then

1128: If (p_rec.information26 = hr_api.g_varchar2) then
1129: p_rec.information26 :=
1130: pqh_ptx_shd.g_old_rec.information26;
1131: End If;
1132: If (p_rec.information27 = hr_api.g_varchar2) then
1133: p_rec.information27 :=
1134: pqh_ptx_shd.g_old_rec.information27;
1135: End If;
1136: If (p_rec.information28 = hr_api.g_varchar2) then

Line 1136: If (p_rec.information28 = hr_api.g_varchar2) then

1132: If (p_rec.information27 = hr_api.g_varchar2) then
1133: p_rec.information27 :=
1134: pqh_ptx_shd.g_old_rec.information27;
1135: End If;
1136: If (p_rec.information28 = hr_api.g_varchar2) then
1137: p_rec.information28 :=
1138: pqh_ptx_shd.g_old_rec.information28;
1139: End If;
1140: If (p_rec.information29 = hr_api.g_varchar2) then

Line 1140: If (p_rec.information29 = hr_api.g_varchar2) then

1136: If (p_rec.information28 = hr_api.g_varchar2) then
1137: p_rec.information28 :=
1138: pqh_ptx_shd.g_old_rec.information28;
1139: End If;
1140: If (p_rec.information29 = hr_api.g_varchar2) then
1141: p_rec.information29 :=
1142: pqh_ptx_shd.g_old_rec.information29;
1143: End If;
1144: If (p_rec.information30 = hr_api.g_varchar2) then

Line 1144: If (p_rec.information30 = hr_api.g_varchar2) then

1140: If (p_rec.information29 = hr_api.g_varchar2) then
1141: p_rec.information29 :=
1142: pqh_ptx_shd.g_old_rec.information29;
1143: End If;
1144: If (p_rec.information30 = hr_api.g_varchar2) then
1145: p_rec.information30 :=
1146: pqh_ptx_shd.g_old_rec.information30;
1147: End If;
1148: If (p_rec.information_category = hr_api.g_varchar2) then

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

1144: If (p_rec.information30 = hr_api.g_varchar2) then
1145: p_rec.information30 :=
1146: pqh_ptx_shd.g_old_rec.information30;
1147: End If;
1148: If (p_rec.information_category = hr_api.g_varchar2) then
1149: p_rec.information_category :=
1150: pqh_ptx_shd.g_old_rec.information_category;
1151: End If;
1152: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

1148: If (p_rec.information_category = hr_api.g_varchar2) then
1149: p_rec.information_category :=
1150: pqh_ptx_shd.g_old_rec.information_category;
1151: End If;
1152: If (p_rec.attribute1 = hr_api.g_varchar2) then
1153: p_rec.attribute1 :=
1154: pqh_ptx_shd.g_old_rec.attribute1;
1155: End If;
1156: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

1152: If (p_rec.attribute1 = hr_api.g_varchar2) then
1153: p_rec.attribute1 :=
1154: pqh_ptx_shd.g_old_rec.attribute1;
1155: End If;
1156: If (p_rec.attribute2 = hr_api.g_varchar2) then
1157: p_rec.attribute2 :=
1158: pqh_ptx_shd.g_old_rec.attribute2;
1159: End If;
1160: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

1156: If (p_rec.attribute2 = hr_api.g_varchar2) then
1157: p_rec.attribute2 :=
1158: pqh_ptx_shd.g_old_rec.attribute2;
1159: End If;
1160: If (p_rec.attribute3 = hr_api.g_varchar2) then
1161: p_rec.attribute3 :=
1162: pqh_ptx_shd.g_old_rec.attribute3;
1163: End If;
1164: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

1160: If (p_rec.attribute3 = hr_api.g_varchar2) then
1161: p_rec.attribute3 :=
1162: pqh_ptx_shd.g_old_rec.attribute3;
1163: End If;
1164: If (p_rec.attribute4 = hr_api.g_varchar2) then
1165: p_rec.attribute4 :=
1166: pqh_ptx_shd.g_old_rec.attribute4;
1167: End If;
1168: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

1164: If (p_rec.attribute4 = hr_api.g_varchar2) then
1165: p_rec.attribute4 :=
1166: pqh_ptx_shd.g_old_rec.attribute4;
1167: End If;
1168: If (p_rec.attribute5 = hr_api.g_varchar2) then
1169: p_rec.attribute5 :=
1170: pqh_ptx_shd.g_old_rec.attribute5;
1171: End If;
1172: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

1168: If (p_rec.attribute5 = hr_api.g_varchar2) then
1169: p_rec.attribute5 :=
1170: pqh_ptx_shd.g_old_rec.attribute5;
1171: End If;
1172: If (p_rec.attribute6 = hr_api.g_varchar2) then
1173: p_rec.attribute6 :=
1174: pqh_ptx_shd.g_old_rec.attribute6;
1175: End If;
1176: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

1172: If (p_rec.attribute6 = hr_api.g_varchar2) then
1173: p_rec.attribute6 :=
1174: pqh_ptx_shd.g_old_rec.attribute6;
1175: End If;
1176: If (p_rec.attribute7 = hr_api.g_varchar2) then
1177: p_rec.attribute7 :=
1178: pqh_ptx_shd.g_old_rec.attribute7;
1179: End If;
1180: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

1176: If (p_rec.attribute7 = hr_api.g_varchar2) then
1177: p_rec.attribute7 :=
1178: pqh_ptx_shd.g_old_rec.attribute7;
1179: End If;
1180: If (p_rec.attribute8 = hr_api.g_varchar2) then
1181: p_rec.attribute8 :=
1182: pqh_ptx_shd.g_old_rec.attribute8;
1183: End If;
1184: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

1180: If (p_rec.attribute8 = hr_api.g_varchar2) then
1181: p_rec.attribute8 :=
1182: pqh_ptx_shd.g_old_rec.attribute8;
1183: End If;
1184: If (p_rec.attribute9 = hr_api.g_varchar2) then
1185: p_rec.attribute9 :=
1186: pqh_ptx_shd.g_old_rec.attribute9;
1187: End If;
1188: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

1184: If (p_rec.attribute9 = hr_api.g_varchar2) then
1185: p_rec.attribute9 :=
1186: pqh_ptx_shd.g_old_rec.attribute9;
1187: End If;
1188: If (p_rec.attribute10 = hr_api.g_varchar2) then
1189: p_rec.attribute10 :=
1190: pqh_ptx_shd.g_old_rec.attribute10;
1191: End If;
1192: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

1188: If (p_rec.attribute10 = hr_api.g_varchar2) then
1189: p_rec.attribute10 :=
1190: pqh_ptx_shd.g_old_rec.attribute10;
1191: End If;
1192: If (p_rec.attribute11 = hr_api.g_varchar2) then
1193: p_rec.attribute11 :=
1194: pqh_ptx_shd.g_old_rec.attribute11;
1195: End If;
1196: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

1192: If (p_rec.attribute11 = hr_api.g_varchar2) then
1193: p_rec.attribute11 :=
1194: pqh_ptx_shd.g_old_rec.attribute11;
1195: End If;
1196: If (p_rec.attribute12 = hr_api.g_varchar2) then
1197: p_rec.attribute12 :=
1198: pqh_ptx_shd.g_old_rec.attribute12;
1199: End If;
1200: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

1196: If (p_rec.attribute12 = hr_api.g_varchar2) then
1197: p_rec.attribute12 :=
1198: pqh_ptx_shd.g_old_rec.attribute12;
1199: End If;
1200: If (p_rec.attribute13 = hr_api.g_varchar2) then
1201: p_rec.attribute13 :=
1202: pqh_ptx_shd.g_old_rec.attribute13;
1203: End If;
1204: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

1200: If (p_rec.attribute13 = hr_api.g_varchar2) then
1201: p_rec.attribute13 :=
1202: pqh_ptx_shd.g_old_rec.attribute13;
1203: End If;
1204: If (p_rec.attribute14 = hr_api.g_varchar2) then
1205: p_rec.attribute14 :=
1206: pqh_ptx_shd.g_old_rec.attribute14;
1207: End If;
1208: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

1204: If (p_rec.attribute14 = hr_api.g_varchar2) then
1205: p_rec.attribute14 :=
1206: pqh_ptx_shd.g_old_rec.attribute14;
1207: End If;
1208: If (p_rec.attribute15 = hr_api.g_varchar2) then
1209: p_rec.attribute15 :=
1210: pqh_ptx_shd.g_old_rec.attribute15;
1211: End If;
1212: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

1208: If (p_rec.attribute15 = hr_api.g_varchar2) then
1209: p_rec.attribute15 :=
1210: pqh_ptx_shd.g_old_rec.attribute15;
1211: End If;
1212: If (p_rec.attribute16 = hr_api.g_varchar2) then
1213: p_rec.attribute16 :=
1214: pqh_ptx_shd.g_old_rec.attribute16;
1215: End If;
1216: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

1212: If (p_rec.attribute16 = hr_api.g_varchar2) then
1213: p_rec.attribute16 :=
1214: pqh_ptx_shd.g_old_rec.attribute16;
1215: End If;
1216: If (p_rec.attribute17 = hr_api.g_varchar2) then
1217: p_rec.attribute17 :=
1218: pqh_ptx_shd.g_old_rec.attribute17;
1219: End If;
1220: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

1216: If (p_rec.attribute17 = hr_api.g_varchar2) then
1217: p_rec.attribute17 :=
1218: pqh_ptx_shd.g_old_rec.attribute17;
1219: End If;
1220: If (p_rec.attribute18 = hr_api.g_varchar2) then
1221: p_rec.attribute18 :=
1222: pqh_ptx_shd.g_old_rec.attribute18;
1223: End If;
1224: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

1220: If (p_rec.attribute18 = hr_api.g_varchar2) then
1221: p_rec.attribute18 :=
1222: pqh_ptx_shd.g_old_rec.attribute18;
1223: End If;
1224: If (p_rec.attribute19 = hr_api.g_varchar2) then
1225: p_rec.attribute19 :=
1226: pqh_ptx_shd.g_old_rec.attribute19;
1227: End If;
1228: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

1224: If (p_rec.attribute19 = hr_api.g_varchar2) then
1225: p_rec.attribute19 :=
1226: pqh_ptx_shd.g_old_rec.attribute19;
1227: End If;
1228: If (p_rec.attribute20 = hr_api.g_varchar2) then
1229: p_rec.attribute20 :=
1230: pqh_ptx_shd.g_old_rec.attribute20;
1231: End If;
1232: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

1228: If (p_rec.attribute20 = hr_api.g_varchar2) then
1229: p_rec.attribute20 :=
1230: pqh_ptx_shd.g_old_rec.attribute20;
1231: End If;
1232: If (p_rec.attribute21 = hr_api.g_varchar2) then
1233: p_rec.attribute21 :=
1234: pqh_ptx_shd.g_old_rec.attribute21;
1235: End If;
1236: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

1232: If (p_rec.attribute21 = hr_api.g_varchar2) then
1233: p_rec.attribute21 :=
1234: pqh_ptx_shd.g_old_rec.attribute21;
1235: End If;
1236: If (p_rec.attribute22 = hr_api.g_varchar2) then
1237: p_rec.attribute22 :=
1238: pqh_ptx_shd.g_old_rec.attribute22;
1239: End If;
1240: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

1236: If (p_rec.attribute22 = hr_api.g_varchar2) then
1237: p_rec.attribute22 :=
1238: pqh_ptx_shd.g_old_rec.attribute22;
1239: End If;
1240: If (p_rec.attribute23 = hr_api.g_varchar2) then
1241: p_rec.attribute23 :=
1242: pqh_ptx_shd.g_old_rec.attribute23;
1243: End If;
1244: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

1240: If (p_rec.attribute23 = hr_api.g_varchar2) then
1241: p_rec.attribute23 :=
1242: pqh_ptx_shd.g_old_rec.attribute23;
1243: End If;
1244: If (p_rec.attribute24 = hr_api.g_varchar2) then
1245: p_rec.attribute24 :=
1246: pqh_ptx_shd.g_old_rec.attribute24;
1247: End If;
1248: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

1244: If (p_rec.attribute24 = hr_api.g_varchar2) then
1245: p_rec.attribute24 :=
1246: pqh_ptx_shd.g_old_rec.attribute24;
1247: End If;
1248: If (p_rec.attribute25 = hr_api.g_varchar2) then
1249: p_rec.attribute25 :=
1250: pqh_ptx_shd.g_old_rec.attribute25;
1251: End If;
1252: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

1248: If (p_rec.attribute25 = hr_api.g_varchar2) then
1249: p_rec.attribute25 :=
1250: pqh_ptx_shd.g_old_rec.attribute25;
1251: End If;
1252: If (p_rec.attribute26 = hr_api.g_varchar2) then
1253: p_rec.attribute26 :=
1254: pqh_ptx_shd.g_old_rec.attribute26;
1255: End If;
1256: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

1252: If (p_rec.attribute26 = hr_api.g_varchar2) then
1253: p_rec.attribute26 :=
1254: pqh_ptx_shd.g_old_rec.attribute26;
1255: End If;
1256: If (p_rec.attribute27 = hr_api.g_varchar2) then
1257: p_rec.attribute27 :=
1258: pqh_ptx_shd.g_old_rec.attribute27;
1259: End If;
1260: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

1256: If (p_rec.attribute27 = hr_api.g_varchar2) then
1257: p_rec.attribute27 :=
1258: pqh_ptx_shd.g_old_rec.attribute27;
1259: End If;
1260: If (p_rec.attribute28 = hr_api.g_varchar2) then
1261: p_rec.attribute28 :=
1262: pqh_ptx_shd.g_old_rec.attribute28;
1263: End If;
1264: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

1260: If (p_rec.attribute28 = hr_api.g_varchar2) then
1261: p_rec.attribute28 :=
1262: pqh_ptx_shd.g_old_rec.attribute28;
1263: End If;
1264: If (p_rec.attribute29 = hr_api.g_varchar2) then
1265: p_rec.attribute29 :=
1266: pqh_ptx_shd.g_old_rec.attribute29;
1267: End If;
1268: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

1264: If (p_rec.attribute29 = hr_api.g_varchar2) then
1265: p_rec.attribute29 :=
1266: pqh_ptx_shd.g_old_rec.attribute29;
1267: End If;
1268: If (p_rec.attribute30 = hr_api.g_varchar2) then
1269: p_rec.attribute30 :=
1270: pqh_ptx_shd.g_old_rec.attribute30;
1271: End If;
1272: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

1268: If (p_rec.attribute30 = hr_api.g_varchar2) then
1269: p_rec.attribute30 :=
1270: pqh_ptx_shd.g_old_rec.attribute30;
1271: End If;
1272: If (p_rec.attribute_category = hr_api.g_varchar2) then
1273: p_rec.attribute_category :=
1274: pqh_ptx_shd.g_old_rec.attribute_category;
1275: End If;
1276: If (p_rec.pay_basis_id = hr_api.g_number) then

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

1272: If (p_rec.attribute_category = hr_api.g_varchar2) then
1273: p_rec.attribute_category :=
1274: pqh_ptx_shd.g_old_rec.attribute_category;
1275: End If;
1276: If (p_rec.pay_basis_id = hr_api.g_number) then
1277: p_rec.pay_basis_id :=
1278: pqh_ptx_shd.g_old_rec.pay_basis_id;
1279: End If;
1280: If (p_rec.supervisor_id = hr_api.g_number) then

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

1276: If (p_rec.pay_basis_id = hr_api.g_number) then
1277: p_rec.pay_basis_id :=
1278: pqh_ptx_shd.g_old_rec.pay_basis_id;
1279: End If;
1280: If (p_rec.supervisor_id = hr_api.g_number) then
1281: p_rec.supervisor_id :=
1282: pqh_ptx_shd.g_old_rec.supervisor_id;
1283: End If;
1284: If (p_rec.wf_transaction_category_id = hr_api.g_number) then

Line 1284: If (p_rec.wf_transaction_category_id = hr_api.g_number) then

1280: If (p_rec.supervisor_id = hr_api.g_number) then
1281: p_rec.supervisor_id :=
1282: pqh_ptx_shd.g_old_rec.supervisor_id;
1283: End If;
1284: If (p_rec.wf_transaction_category_id = hr_api.g_number) then
1285: p_rec.wf_transaction_category_id :=
1286: pqh_ptx_shd.g_old_rec.wf_transaction_category_id;
1287: End If;
1288:

Line 1347: p_action_date in date default hr_api.g_date,

1343: Procedure upd
1344: (
1345: p_effective_date in date,
1346: p_position_transaction_id in number,
1347: p_action_date in date default hr_api.g_date,
1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,

Line 1348: p_position_id in number default hr_api.g_number,

1344: (
1345: p_effective_date in date,
1346: p_position_transaction_id in number,
1347: p_action_date in date default hr_api.g_date,
1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,

Line 1349: p_availability_status_id in number default hr_api.g_number,

1345: p_effective_date in date,
1346: p_position_transaction_id in number,
1347: p_action_date in date default hr_api.g_date,
1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,

Line 1350: p_business_group_id in number default hr_api.g_number,

1346: p_position_transaction_id in number,
1347: p_action_date in date default hr_api.g_date,
1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,

Line 1351: p_entry_step_id in number default hr_api.g_number,

1347: p_action_date in date default hr_api.g_date,
1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,

Line 1352: p_entry_grade_rule_id in number default hr_api.g_number,

1348: p_position_id in number default hr_api.g_number,
1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,

Line 1353: p_job_id in number default hr_api.g_number,

1349: p_availability_status_id in number default hr_api.g_number,
1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,

Line 1354: p_location_id in number default hr_api.g_number,

1350: p_business_group_id in number default hr_api.g_number,
1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,

Line 1355: p_organization_id in number default hr_api.g_number,

1351: p_entry_step_id in number default hr_api.g_number,
1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,

Line 1356: p_pay_freq_payroll_id in number default hr_api.g_number,

1352: p_entry_grade_rule_id in number default hr_api.g_number,
1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,

Line 1357: p_position_definition_id in number default hr_api.g_number,

1353: p_job_id in number default hr_api.g_number,
1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,

Line 1358: p_prior_position_id in number default hr_api.g_number,

1354: p_location_id in number default hr_api.g_number,
1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,

Line 1359: p_relief_position_id in number default hr_api.g_number,

1355: p_organization_id in number default hr_api.g_number,
1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,

Line 1360: p_entry_grade_id in number default hr_api.g_number,

1356: p_pay_freq_payroll_id in number default hr_api.g_number,
1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,

Line 1361: p_successor_position_id in number default hr_api.g_number,

1357: p_position_definition_id in number default hr_api.g_number,
1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,

Line 1362: p_supervisor_position_id in number default hr_api.g_number,

1358: p_prior_position_id in number default hr_api.g_number,
1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,

Line 1363: p_amendment_date in date default hr_api.g_date,

1359: p_relief_position_id in number default hr_api.g_number,
1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,

Line 1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,

1360: p_entry_grade_id in number default hr_api.g_number,
1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,

Line 1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,

1361: p_successor_position_id in number default hr_api.g_number,
1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,

Line 1366: p_avail_status_prop_end_date in date default hr_api.g_date,

1362: p_supervisor_position_id in number default hr_api.g_number,
1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,

Line 1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,

1363: p_amendment_date in date default hr_api.g_date,
1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,

Line 1368: p_comments in varchar2 default hr_api.g_varchar2,

1364: p_amendment_recommendation in varchar2 default hr_api.g_varchar2,
1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,

Line 1369: p_country1 in varchar2 default hr_api.g_varchar2,

1365: p_amendment_ref_number in varchar2 default hr_api.g_varchar2,
1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,

Line 1370: p_country2 in varchar2 default hr_api.g_varchar2,

1366: p_avail_status_prop_end_date in date default hr_api.g_date,
1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,

Line 1371: p_country3 in varchar2 default hr_api.g_varchar2,

1367: p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2,
1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,

Line 1372: p_current_job_prop_end_date in date default hr_api.g_date,

1368: p_comments in varchar2 default hr_api.g_varchar2,
1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,

Line 1373: p_current_org_prop_end_date in date default hr_api.g_date,

1369: p_country1 in varchar2 default hr_api.g_varchar2,
1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,

Line 1374: p_date_effective in date default hr_api.g_date,

1370: p_country2 in varchar2 default hr_api.g_varchar2,
1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,

Line 1375: p_date_end in date default hr_api.g_date,

1371: p_country3 in varchar2 default hr_api.g_varchar2,
1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,

Line 1376: p_earliest_hire_date in date default hr_api.g_date,

1372: p_current_job_prop_end_date in date default hr_api.g_date,
1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,

Line 1377: p_fill_by_date in date default hr_api.g_date,

1373: p_current_org_prop_end_date in date default hr_api.g_date,
1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,

Line 1378: p_frequency in varchar2 default hr_api.g_varchar2,

1374: p_date_effective in date default hr_api.g_date,
1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,

Line 1379: p_fte in number default hr_api.g_number,

1375: p_date_end in date default hr_api.g_date,
1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,

Line 1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,

1376: p_earliest_hire_date in date default hr_api.g_date,
1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,

Line 1381: p_location1 in varchar2 default hr_api.g_varchar2,

1377: p_fill_by_date in date default hr_api.g_date,
1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,

Line 1382: p_location2 in varchar2 default hr_api.g_varchar2,

1378: p_frequency in varchar2 default hr_api.g_varchar2,
1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,

Line 1383: p_location3 in varchar2 default hr_api.g_varchar2,

1379: p_fte in number default hr_api.g_number,
1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,

Line 1384: p_max_persons in number default hr_api.g_number,

1380: p_fte_capacity in varchar2 default hr_api.g_varchar2,
1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,

Line 1385: p_name in varchar2 default hr_api.g_varchar2,

1381: p_location1 in varchar2 default hr_api.g_varchar2,
1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,

Line 1386: p_other_requirements in varchar2 default hr_api.g_varchar2,

1382: p_location2 in varchar2 default hr_api.g_varchar2,
1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,

Line 1387: p_overlap_period in number default hr_api.g_number,

1383: p_location3 in varchar2 default hr_api.g_varchar2,
1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,

Line 1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,

1384: p_max_persons in number default hr_api.g_number,
1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,

Line 1389: p_passport_required in varchar2 default hr_api.g_varchar2,

1385: p_name in varchar2 default hr_api.g_varchar2,
1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,

Line 1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,

1386: p_other_requirements in varchar2 default hr_api.g_varchar2,
1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,

Line 1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,

1387: p_overlap_period in number default hr_api.g_number,
1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,

Line 1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,

1388: p_overlap_unit_cd in varchar2 default hr_api.g_varchar2,
1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,

Line 1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,

1389: p_passport_required in varchar2 default hr_api.g_varchar2,
1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,

Line 1394: p_position_type in varchar2 default hr_api.g_varchar2,

1390: p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,

Line 1395: p_posting_description in varchar2 default hr_api.g_varchar2,

1391: p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,

Line 1396: p_probation_period in number default hr_api.g_number,

1392: p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2,
1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,

Line 1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,

1393: p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2,
1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,

Line 1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,

1394: p_position_type in varchar2 default hr_api.g_varchar2,
1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,

Line 1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,

1395: p_posting_description in varchar2 default hr_api.g_varchar2,
1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,

Line 1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,

1396: p_probation_period in number default hr_api.g_number,
1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,

Line 1401: p_review_flag in varchar2 default hr_api.g_varchar2,

1397: p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2,
1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,

Line 1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,

1398: p_relocate_domestically in varchar2 default hr_api.g_varchar2,
1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,

Line 1403: p_security_requirements in varchar2 default hr_api.g_varchar2,

1399: p_relocate_internationally in varchar2 default hr_api.g_varchar2,
1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

Line 1404: p_service_minimum in varchar2 default hr_api.g_varchar2,

1400: p_replacement_required_flag in varchar2 default hr_api.g_varchar2,
1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,

Line 1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,

1401: p_review_flag in varchar2 default hr_api.g_varchar2,
1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,

Line 1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,

1402: p_seasonal_flag in varchar2 default hr_api.g_varchar2,
1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,

Line 1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,

1403: p_security_requirements in varchar2 default hr_api.g_varchar2,
1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,

Line 1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,

1404: p_service_minimum in varchar2 default hr_api.g_varchar2,
1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,

Line 1409: p_transaction_status in varchar2 default hr_api.g_varchar2,

1405: p_term_start_day_cd in varchar2 default hr_api.g_varchar2,
1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,

Line 1410: p_travel_required in varchar2 default hr_api.g_varchar2,

1406: p_term_start_month_cd in varchar2 default hr_api.g_varchar2,
1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,

Line 1411: p_working_hours in number default hr_api.g_number,

1407: p_time_normal_finish in varchar2 default hr_api.g_varchar2,
1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,

Line 1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,

1408: p_time_normal_start in varchar2 default hr_api.g_varchar2,
1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,

Line 1413: p_work_any_country in varchar2 default hr_api.g_varchar2,

1409: p_transaction_status in varchar2 default hr_api.g_varchar2,
1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,

Line 1414: p_work_any_location in varchar2 default hr_api.g_varchar2,

1410: p_travel_required in varchar2 default hr_api.g_varchar2,
1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,

Line 1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,

1411: p_working_hours in number default hr_api.g_number,
1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,

Line 1416: p_work_schedule in varchar2 default hr_api.g_varchar2,

1412: p_works_council_approval_flag in varchar2 default hr_api.g_varchar2,
1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,

Line 1417: p_work_duration in varchar2 default hr_api.g_varchar2,

1413: p_work_any_country in varchar2 default hr_api.g_varchar2,
1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,

Line 1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,

1414: p_work_any_location in varchar2 default hr_api.g_varchar2,
1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,

Line 1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,

1415: p_work_period_type_cd in varchar2 default hr_api.g_varchar2,
1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,

Line 1420: p_proposed_fte_for_layoff in number default hr_api.g_number,

1416: p_work_schedule in varchar2 default hr_api.g_varchar2,
1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,

Line 1421: p_proposed_date_for_layoff in date default hr_api.g_date,

1417: p_work_duration in varchar2 default hr_api.g_varchar2,
1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,

Line 1422: p_information1 in varchar2 default hr_api.g_varchar2,

1418: p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2,
1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,

Line 1423: p_information2 in varchar2 default hr_api.g_varchar2,

1419: p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2,
1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,

Line 1424: p_information3 in varchar2 default hr_api.g_varchar2,

1420: p_proposed_fte_for_layoff in number default hr_api.g_number,
1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,

Line 1425: p_information4 in varchar2 default hr_api.g_varchar2,

1421: p_proposed_date_for_layoff in date default hr_api.g_date,
1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,

Line 1426: p_information5 in varchar2 default hr_api.g_varchar2,

1422: p_information1 in varchar2 default hr_api.g_varchar2,
1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,

Line 1427: p_information6 in varchar2 default hr_api.g_varchar2,

1423: p_information2 in varchar2 default hr_api.g_varchar2,
1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,

Line 1428: p_information7 in varchar2 default hr_api.g_varchar2,

1424: p_information3 in varchar2 default hr_api.g_varchar2,
1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,

Line 1429: p_information8 in varchar2 default hr_api.g_varchar2,

1425: p_information4 in varchar2 default hr_api.g_varchar2,
1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,

Line 1430: p_information9 in varchar2 default hr_api.g_varchar2,

1426: p_information5 in varchar2 default hr_api.g_varchar2,
1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,

Line 1431: p_information10 in varchar2 default hr_api.g_varchar2,

1427: p_information6 in varchar2 default hr_api.g_varchar2,
1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,

Line 1432: p_information11 in varchar2 default hr_api.g_varchar2,

1428: p_information7 in varchar2 default hr_api.g_varchar2,
1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,

Line 1433: p_information12 in varchar2 default hr_api.g_varchar2,

1429: p_information8 in varchar2 default hr_api.g_varchar2,
1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,

Line 1434: p_information13 in varchar2 default hr_api.g_varchar2,

1430: p_information9 in varchar2 default hr_api.g_varchar2,
1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,

Line 1435: p_information14 in varchar2 default hr_api.g_varchar2,

1431: p_information10 in varchar2 default hr_api.g_varchar2,
1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,

Line 1436: p_information15 in varchar2 default hr_api.g_varchar2,

1432: p_information11 in varchar2 default hr_api.g_varchar2,
1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,

Line 1437: p_information16 in varchar2 default hr_api.g_varchar2,

1433: p_information12 in varchar2 default hr_api.g_varchar2,
1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,

Line 1438: p_information17 in varchar2 default hr_api.g_varchar2,

1434: p_information13 in varchar2 default hr_api.g_varchar2,
1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,

Line 1439: p_information18 in varchar2 default hr_api.g_varchar2,

1435: p_information14 in varchar2 default hr_api.g_varchar2,
1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,

Line 1440: p_information19 in varchar2 default hr_api.g_varchar2,

1436: p_information15 in varchar2 default hr_api.g_varchar2,
1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,

Line 1441: p_information20 in varchar2 default hr_api.g_varchar2,

1437: p_information16 in varchar2 default hr_api.g_varchar2,
1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,

Line 1442: p_information21 in varchar2 default hr_api.g_varchar2,

1438: p_information17 in varchar2 default hr_api.g_varchar2,
1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,

Line 1443: p_information22 in varchar2 default hr_api.g_varchar2,

1439: p_information18 in varchar2 default hr_api.g_varchar2,
1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,

Line 1444: p_information23 in varchar2 default hr_api.g_varchar2,

1440: p_information19 in varchar2 default hr_api.g_varchar2,
1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,

Line 1445: p_information24 in varchar2 default hr_api.g_varchar2,

1441: p_information20 in varchar2 default hr_api.g_varchar2,
1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,

Line 1446: p_information25 in varchar2 default hr_api.g_varchar2,

1442: p_information21 in varchar2 default hr_api.g_varchar2,
1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,

Line 1447: p_information26 in varchar2 default hr_api.g_varchar2,

1443: p_information22 in varchar2 default hr_api.g_varchar2,
1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,

Line 1448: p_information27 in varchar2 default hr_api.g_varchar2,

1444: p_information23 in varchar2 default hr_api.g_varchar2,
1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,

Line 1449: p_information28 in varchar2 default hr_api.g_varchar2,

1445: p_information24 in varchar2 default hr_api.g_varchar2,
1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 1450: p_information29 in varchar2 default hr_api.g_varchar2,

1446: p_information25 in varchar2 default hr_api.g_varchar2,
1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 1451: p_information30 in varchar2 default hr_api.g_varchar2,

1447: p_information26 in varchar2 default hr_api.g_varchar2,
1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 1452: p_information_category in varchar2 default hr_api.g_varchar2,

1448: p_information27 in varchar2 default hr_api.g_varchar2,
1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 1453: p_attribute1 in varchar2 default hr_api.g_varchar2,

1449: p_information28 in varchar2 default hr_api.g_varchar2,
1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 1454: p_attribute2 in varchar2 default hr_api.g_varchar2,

1450: p_information29 in varchar2 default hr_api.g_varchar2,
1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 1455: p_attribute3 in varchar2 default hr_api.g_varchar2,

1451: p_information30 in varchar2 default hr_api.g_varchar2,
1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 1456: p_attribute4 in varchar2 default hr_api.g_varchar2,

1452: p_information_category in varchar2 default hr_api.g_varchar2,
1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 1457: p_attribute5 in varchar2 default hr_api.g_varchar2,

1453: p_attribute1 in varchar2 default hr_api.g_varchar2,
1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 1458: p_attribute6 in varchar2 default hr_api.g_varchar2,

1454: p_attribute2 in varchar2 default hr_api.g_varchar2,
1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 1459: p_attribute7 in varchar2 default hr_api.g_varchar2,

1455: p_attribute3 in varchar2 default hr_api.g_varchar2,
1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 1460: p_attribute8 in varchar2 default hr_api.g_varchar2,

1456: p_attribute4 in varchar2 default hr_api.g_varchar2,
1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 1461: p_attribute9 in varchar2 default hr_api.g_varchar2,

1457: p_attribute5 in varchar2 default hr_api.g_varchar2,
1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 1462: p_attribute10 in varchar2 default hr_api.g_varchar2,

1458: p_attribute6 in varchar2 default hr_api.g_varchar2,
1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 1463: p_attribute11 in varchar2 default hr_api.g_varchar2,

1459: p_attribute7 in varchar2 default hr_api.g_varchar2,
1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 1464: p_attribute12 in varchar2 default hr_api.g_varchar2,

1460: p_attribute8 in varchar2 default hr_api.g_varchar2,
1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 1465: p_attribute13 in varchar2 default hr_api.g_varchar2,

1461: p_attribute9 in varchar2 default hr_api.g_varchar2,
1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 1466: p_attribute14 in varchar2 default hr_api.g_varchar2,

1462: p_attribute10 in varchar2 default hr_api.g_varchar2,
1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 1467: p_attribute15 in varchar2 default hr_api.g_varchar2,

1463: p_attribute11 in varchar2 default hr_api.g_varchar2,
1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 1468: p_attribute16 in varchar2 default hr_api.g_varchar2,

1464: p_attribute12 in varchar2 default hr_api.g_varchar2,
1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 1469: p_attribute17 in varchar2 default hr_api.g_varchar2,

1465: p_attribute13 in varchar2 default hr_api.g_varchar2,
1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 1470: p_attribute18 in varchar2 default hr_api.g_varchar2,

1466: p_attribute14 in varchar2 default hr_api.g_varchar2,
1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 1471: p_attribute19 in varchar2 default hr_api.g_varchar2,

1467: p_attribute15 in varchar2 default hr_api.g_varchar2,
1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 1472: p_attribute20 in varchar2 default hr_api.g_varchar2,

1468: p_attribute16 in varchar2 default hr_api.g_varchar2,
1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 1473: p_attribute21 in varchar2 default hr_api.g_varchar2,

1469: p_attribute17 in varchar2 default hr_api.g_varchar2,
1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 1474: p_attribute22 in varchar2 default hr_api.g_varchar2,

1470: p_attribute18 in varchar2 default hr_api.g_varchar2,
1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 1475: p_attribute23 in varchar2 default hr_api.g_varchar2,

1471: p_attribute19 in varchar2 default hr_api.g_varchar2,
1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 1476: p_attribute24 in varchar2 default hr_api.g_varchar2,

1472: p_attribute20 in varchar2 default hr_api.g_varchar2,
1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 1477: p_attribute25 in varchar2 default hr_api.g_varchar2,

1473: p_attribute21 in varchar2 default hr_api.g_varchar2,
1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 1478: p_attribute26 in varchar2 default hr_api.g_varchar2,

1474: p_attribute22 in varchar2 default hr_api.g_varchar2,
1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 1479: p_attribute27 in varchar2 default hr_api.g_varchar2,

1475: p_attribute23 in varchar2 default hr_api.g_varchar2,
1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 1480: p_attribute28 in varchar2 default hr_api.g_varchar2,

1476: p_attribute24 in varchar2 default hr_api.g_varchar2,
1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,

Line 1481: p_attribute29 in varchar2 default hr_api.g_varchar2,

1477: p_attribute25 in varchar2 default hr_api.g_varchar2,
1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,

Line 1482: p_attribute30 in varchar2 default hr_api.g_varchar2,

1478: p_attribute26 in varchar2 default hr_api.g_varchar2,
1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,
1486: p_supervisor_id in number default hr_api.g_number,

Line 1483: p_attribute_category in varchar2 default hr_api.g_varchar2,

1479: p_attribute27 in varchar2 default hr_api.g_varchar2,
1480: p_attribute28 in varchar2 default hr_api.g_varchar2,
1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,
1486: p_supervisor_id in number default hr_api.g_number,
1487: p_wf_transaction_category_id in number default hr_api.g_number

Line 1485: p_pay_basis_id in number default hr_api.g_number,

1481: p_attribute29 in varchar2 default hr_api.g_varchar2,
1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,
1486: p_supervisor_id in number default hr_api.g_number,
1487: p_wf_transaction_category_id in number default hr_api.g_number
1488: ) is
1489: --

Line 1486: p_supervisor_id in number default hr_api.g_number,

1482: p_attribute30 in varchar2 default hr_api.g_varchar2,
1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,
1486: p_supervisor_id in number default hr_api.g_number,
1487: p_wf_transaction_category_id in number default hr_api.g_number
1488: ) is
1489: --
1490: l_rec pqh_ptx_shd.g_rec_type;

Line 1487: p_wf_transaction_category_id in number default hr_api.g_number

1483: p_attribute_category in varchar2 default hr_api.g_varchar2,
1484: p_object_version_number in out nocopy number ,
1485: p_pay_basis_id in number default hr_api.g_number,
1486: p_supervisor_id in number default hr_api.g_number,
1487: p_wf_transaction_category_id in number default hr_api.g_number
1488: ) is
1489: --
1490: l_rec pqh_ptx_shd.g_rec_type;
1491: l_proc varchar2(72) := g_package||'upd';