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

APPS.PQP_HROSS_INTEGRATION dependencies on HR_API

Line 735: ,p_contract_id IN NUMBER DEFAULT Hr_Api.g_number

731: ,p_segment29 => l_ppl_grp_rec.segment29
732: ,p_segment30 => l_ppl_grp_rec.segment30
733: ,p_concat_segments => l_ppl_grp_rec.group_name
734: /*
735: ,p_contract_id IN NUMBER DEFAULT Hr_Api.g_number
736: ,p_establishment_id IN NUMBER DEFAULT Hr_Api.g_number
737: ,p_grade_ladder_pgm_id IN NUMBER DEFAULT Hr_Api.g_number
738: ,p_supervisor_assignment_id IN NUMBER DEFAULT Hr_Api.g_number
739: */

Line 736: ,p_establishment_id IN NUMBER DEFAULT Hr_Api.g_number

732: ,p_segment30 => l_ppl_grp_rec.segment30
733: ,p_concat_segments => l_ppl_grp_rec.group_name
734: /*
735: ,p_contract_id IN NUMBER DEFAULT Hr_Api.g_number
736: ,p_establishment_id IN NUMBER DEFAULT Hr_Api.g_number
737: ,p_grade_ladder_pgm_id IN NUMBER DEFAULT Hr_Api.g_number
738: ,p_supervisor_assignment_id IN NUMBER DEFAULT Hr_Api.g_number
739: */
740: ,p_scl_segment1 => l_hr_soft_rec.segment1

Line 737: ,p_grade_ladder_pgm_id IN NUMBER DEFAULT Hr_Api.g_number

733: ,p_concat_segments => l_ppl_grp_rec.group_name
734: /*
735: ,p_contract_id IN NUMBER DEFAULT Hr_Api.g_number
736: ,p_establishment_id IN NUMBER DEFAULT Hr_Api.g_number
737: ,p_grade_ladder_pgm_id IN NUMBER DEFAULT Hr_Api.g_number
738: ,p_supervisor_assignment_id IN NUMBER DEFAULT Hr_Api.g_number
739: */
740: ,p_scl_segment1 => l_hr_soft_rec.segment1
741: ,p_object_version_number => l_cur_asg_rec.object_version_number

Line 738: ,p_supervisor_assignment_id IN NUMBER DEFAULT Hr_Api.g_number

734: /*
735: ,p_contract_id IN NUMBER DEFAULT Hr_Api.g_number
736: ,p_establishment_id IN NUMBER DEFAULT Hr_Api.g_number
737: ,p_grade_ladder_pgm_id IN NUMBER DEFAULT Hr_Api.g_number
738: ,p_supervisor_assignment_id IN NUMBER DEFAULT Hr_Api.g_number
739: */
740: ,p_scl_segment1 => l_hr_soft_rec.segment1
741: ,p_object_version_number => l_cur_asg_rec.object_version_number
742: ,p_special_ceiling_step_id => p_asg_crit_out.special_ceiling_step_id

Line 2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2085: ,p_expense_check_send_to_addres => NVL(l_per_rec.expense_check_send_to_address
2086: ,l_cur_per_rec.expense_check_send_to_address)
2087: -- Person DDF
2088: /*
2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2086: ,l_cur_per_rec.expense_check_send_to_address)
2087: -- Person DDF
2088: /*
2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2087: -- Person DDF
2088: /*
2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2088: /*
2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2089: ,p_per_information_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2090: ,p_per_information1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2091: ,p_per_information2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2092: ,p_per_information3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2093: ,p_per_information4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2094: ,p_per_information5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2095: ,p_per_information6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2096: ,p_per_information7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2097: ,p_per_information8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2098: ,p_per_information9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2099: ,p_per_information10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2100: ,p_per_information11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2101: ,p_per_information12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2102: ,p_per_information13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2103: ,p_per_information14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2104: ,p_per_information15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2105: ,p_per_information16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2106: ,p_per_information17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2107: ,p_per_information18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2108: ,p_per_information19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2109: ,p_per_information20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2110: ,p_per_information21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2111: ,p_per_information22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2112: ,p_per_information23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF

Line 2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2113: ,p_per_information24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2114: ,p_per_information25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2115: ,p_per_information26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2116: ,p_per_information27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2117: ,p_per_information28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2118: ,p_per_information29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2119: ,p_per_information30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2120: -- Person DF
2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2121: ,p_attribute_category IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2122: ,p_attribute1 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2123: ,p_attribute2 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2124: ,p_attribute3 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2125: ,p_attribute4 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2126: ,p_attribute5 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2127: ,p_attribute6 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2128: ,p_attribute7 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2129: ,p_attribute8 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2130: ,p_attribute9 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2131: ,p_attribute10 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2132: ,p_attribute11 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2133: ,p_attribute12 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2134: ,p_attribute13 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2135: ,p_attribute14 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2136: ,p_attribute15 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2137: ,p_attribute16 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2138: ,p_attribute17 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2139: ,p_attribute18 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2140: ,p_attribute19 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2141: ,p_attribute20 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2142: ,p_attribute21 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2143: ,p_attribute22 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2144: ,p_attribute23 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:

Line 2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2145: ,p_attribute24 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number

Line 2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2146: ,p_attribute25 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2147: ,p_attribute26 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2148: ,p_attribute27 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date

Line 2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number

2149: ,p_attribute28 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date

Line 2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2150: ,p_attribute29 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date

2151: ,p_attribute30 IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2152:
2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date

2153: ,p_vendor_id IN NUMBER DEFAULT Hr_Api.g_number
2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number

Line 2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2154: ,p_work_telephone IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date

Line 2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2155: ,p_date_of_death IN DATE DEFAULT Hr_Api.g_date
2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2156: ,p_background_check_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number

2157: ,p_background_date_check IN DATE DEFAULT Hr_Api.g_date
2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date

2158: ,p_blood_type IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date

Line 2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2159: ,p_correspondence_language IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2160: ,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2161: ,p_fte_capacity IN NUMBER DEFAULT Hr_Api.g_number
2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date

2162: ,p_hold_applicant_date_until IN DATE DEFAULT Hr_Api.g_date
2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2163: ,p_honors IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date

Line 2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2164: ,p_internal_location IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2165: ,p_last_medical_test_by IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2166: ,p_last_medical_test_date IN DATE DEFAULT Hr_Api.g_date
2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date

2167: ,p_mailstop IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date

Line 2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2168: ,p_office_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2169: ,p_on_military_service IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2170: ,p_pre_name_adjunct IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date

2171: ,p_projected_start_date IN DATE DEFAULT Hr_Api.g_date
2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2172: ,p_rehire_authorizor IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2173: ,p_rehire_recommendation IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number

Line 2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2174: ,p_resume_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date

Line 2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2175: ,p_resume_last_updated IN DATE DEFAULT Hr_Api.g_date
2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2176: ,p_second_passport_exists IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number

2177: ,p_student_status IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date

2178: ,p_work_schedule IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2179: ,p_rehire_reason IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2180: ,p_suffix IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2181: ,p_benefit_group_id IN NUMBER DEFAULT Hr_Api.g_number
2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date

Line 2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2182: ,p_receipt_of_death_cert_date IN DATE DEFAULT Hr_Api.g_date
2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date

Line 2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2183: ,p_coord_ben_med_pln_no IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2184: ,p_coord_ben_no_cvg_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date

Line 2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date

2185: ,p_coord_ben_med_ext_er IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date

2186: ,p_coord_ben_med_pl_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date

Line 2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2187: ,p_coord_ben_med_insr_crr_name IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date

Line 2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date

2188: ,p_coord_ben_med_insr_crr_ident IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2189: ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT Hr_Api.g_date
2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date

2190: ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT Hr_Api.g_date
2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date

2191: ,p_uses_tobacco_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2192: ,p_dpdnt_adoption_date IN DATE DEFAULT Hr_Api.g_date
2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2

Line 2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2193: ,p_dpdnt_vlntry_svce_flag IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2201: */

Line 2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2194: ,p_original_date_of_hire IN DATE DEFAULT Hr_Api.g_date
2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2201: */
2202: ,p_effective_start_date => p_updper_api_out.effective_start_date

Line 2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2195: ,p_adjusted_svc_date IN DATE DEFAULT Hr_Api.g_date
2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2201: */
2202: ,p_effective_start_date => p_updper_api_out.effective_start_date
2203: ,p_effective_end_date => p_updper_api_out.effective_end_date

Line 2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2

2196: ,p_town_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2197: ,p_region_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2198: ,p_country_of_birth IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2199: ,p_global_person_id IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2200: ,p_npw_number IN Varchar2 DEFAULT Hr_Api.g_Varchar2
2201: */
2202: ,p_effective_start_date => p_updper_api_out.effective_start_date
2203: ,p_effective_end_date => p_updper_api_out.effective_end_date
2204: ,p_full_name => p_updper_api_out.full_name

Line 3106: --,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2

3102: ,p_blood_type => NVL(l_per_rec.blood_type
3103: ,l_cur_per_rec.blood_type)
3104: ,p_correspondence_language => NVL(l_per_rec.correspondence_language
3105: ,l_cur_per_rec.correspondence_language)
3106: --,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
3107: ,p_fte_capacity => NVL(l_per_rec.fte_capacity
3108: ,l_cur_per_rec.fte_capacity)
3109: ,p_hold_applicant_date_until => NVL(l_per_rec.hold_applicant_date_until
3110: ,l_cur_per_rec.hold_applicant_date_until)

Line 3795: FROM hr_api_modules

3791: -- DP interface tables
3792: CURSOR csr_get_dp_mode (c_batch_id IN Number
3793: ,c_link_value IN Number) IS
3794: SELECT 'CREATE'
3795: FROM hr_api_modules
3796: WHERE module_name = 'CREATE_EMPLOYEE'
3797: AND module_package = 'HR_EMPLOYEE_API'
3798: AND api_module_id IN (SELECT api_module_id
3799: FROM hr_pump_batch_lines

Line 3807: FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3803: -- Cursor to get all the api_ids which have LINE_STATUS in status 'C' or 'U'
3804: CURSOR csr_get_api_names (c_batch_id IN Number
3805: ,c_link_value IN Number) IS
3806: SELECT module_name
3807: FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3808: WHERE batch_id = c_batch_id
3809: AND link_value = c_link_value
3810: AND line_status IN ('U', 'E')
3811: AND hpbl.api_module_id = ham.api_module_id;

Line 3822: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3818: -- FROM dual
3819: -- WHERE
3820: -- 'UPDATE_PERSON_ADDRESS' IN
3821: -- (SELECT module_name
3822: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3823: -- WHERE batch_id = c_batch_id
3824: -- AND link_value = c_link_value
3825: -- AND hpbl.api_module_id = ham.api_module_id
3826: -- AND line_status IN ('U', 'E'))

Line 3829: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3825: -- AND hpbl.api_module_id = ham.api_module_id
3826: -- AND line_status IN ('U', 'E'))
3827: -- AND 'CREATE_PERSON_ADDRESS' IN
3828: -- (SELECT module_name
3829: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3830: -- WHERE batch_id = c_batch_id
3831: -- AND link_value = c_link_value
3832: -- AND hpbl.api_module_id = ham.api_module_id
3833: -- AND line_status IN ('U', 'E'));

Line 3929: l_api_name hr_api_modules.module_name%TYPE;

3925: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'HR_DataPumpErr';
3926:
3927: l_dp_mode Varchar2(10);
3928: l_if_end_dated Varchar2(20);
3929: l_api_name hr_api_modules.module_name%TYPE;
3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;

Line 4279: --,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2

4275: ,p_background_check_status => l_per_rec.background_check_status
4276: ,p_background_date_check => l_per_rec.background_date_check
4277: ,p_blood_type => l_per_rec.blood_type
4278: ,p_correspondence_language => l_per_rec.correspondence_language
4279: --,p_fast_path_employee IN Varchar2 DEFAULT Hr_Api.g_Varchar2
4280: ,p_fte_capacity => l_per_rec.fte_capacity
4281: ,p_hold_applicant_date_until => l_per_rec.hold_applicant_date_until
4282: ,p_honors => l_per_rec.honors
4283: ,p_internal_location => l_per_rec.internal_location