8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_person_deployment >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_person_deployment
12: (p_validate in number default hr_api.g_false_num
13: ,p_from_business_group_id in number
14: ,p_to_business_group_id in number
15: ,p_from_person_id in number
16: ,p_to_person_id in number default null
99: --
100: -- Convert constant values to their corresponding boolean value
101: --
102: l_validate :=
103: hr_api.constant_to_boolean
104: (p_constant_value => p_validate);
105: --
106: -- Register Surrogate ID or user key values
107: --
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------< update_person_deployment >-----------------------|
238: -- ----------------------------------------------------------------------------
239: PROCEDURE update_person_deployment
240: (p_validate in number default hr_api.g_false_num
241: ,p_person_deployment_id in number
242: ,p_object_version_number in out nocopy number
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
239: PROCEDURE update_person_deployment
240: (p_validate in number default hr_api.g_false_num
241: ,p_person_deployment_id in number
242: ,p_object_version_number in out nocopy number
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
240: (p_validate in number default hr_api.g_false_num
241: ,p_person_deployment_id in number
242: ,p_object_version_number in out nocopy number
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
241: ,p_person_deployment_id in number
242: ,p_object_version_number in out nocopy number
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
242: ,p_object_version_number in out nocopy number
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
243: ,p_person_type_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
244: ,p_start_date in date default hr_api.g_date
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
245: ,p_end_date in date default hr_api.g_date
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
246: ,p_employee_number in varchar2 default hr_api.g_varchar2
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
247: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
248: ,p_leaving_person_type_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
249: ,p_status in varchar2 default hr_api.g_varchar2
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
251: ,p_deplymt_policy_id in number default hr_api.g_number
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
252: ,p_organization_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
253: ,p_location_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
254: ,p_job_id in number default hr_api.g_number
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
255: ,p_position_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
256: ,p_grade_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
257: ,p_supervisor_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
258: ,p_supervisor_assignment_id in number default hr_api.g_number
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
259: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
260: ,p_payroll_id in number default hr_api.g_number
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
261: ,p_pay_basis_id in number default hr_api.g_number
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
263: ,p_people_group_id in number default hr_api.g_number
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
264: ,p_soft_coding_keyflex_id in number default hr_api.g_number
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
265: ,p_assignment_status_type_id in number default hr_api.g_number
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
266: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
268: ,p_per_information1 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
270: ,p_per_information3 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
271: ,p_per_information4 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
272: ,p_per_information5 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
273: ,p_per_information6 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
274: ,p_per_information7 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
275: ,p_per_information8 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
276: ,p_per_information9 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
277: ,p_per_information10 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
278: ,p_per_information11 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
279: ,p_per_information12 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
280: ,p_per_information13 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
281: ,p_per_information14 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
282: ,p_per_information15 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
283: ,p_per_information16 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
284: ,p_per_information17 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
285: ,p_per_information18 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
286: ,p_per_information19 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
287: ,p_per_information20 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
288: ,p_per_information21 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
289: ,p_per_information22 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
290: ,p_per_information23 in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
298: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
291: ,p_per_information24 in varchar2 default hr_api.g_varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
298: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
299: ,p_return_status out nocopy varchar2
292: ,p_per_information25 in varchar2 default hr_api.g_varchar2
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
298: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
299: ,p_return_status out nocopy varchar2
300: ) is
293: ,p_per_information26 in varchar2 default hr_api.g_varchar2
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
298: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
299: ,p_return_status out nocopy varchar2
300: ) is
301: --
294: ,p_per_information27 in varchar2 default hr_api.g_varchar2
295: ,p_per_information28 in varchar2 default hr_api.g_varchar2
296: ,p_per_information29 in varchar2 default hr_api.g_varchar2
297: ,p_per_information30 in varchar2 default hr_api.g_varchar2
298: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
299: ,p_return_status out nocopy varchar2
300: ) is
301: --
302: -- Variables for API Boolean parameters
325: --
326: -- Convert constant values to their corresponding boolean value
327: --
328: l_validate :=
329: hr_api.constant_to_boolean
330: (p_constant_value => p_validate);
331: --
332: -- Register Surrogate ID or user key values
333: --
456: -- ----------------------------------------------------------------------------
457: -- |-----------------------< delete_person_deployment >-----------------------|
458: -- ----------------------------------------------------------------------------
459: PROCEDURE delete_person_deployment
460: (p_validate in number default hr_api.g_false_num
461: ,p_person_deployment_id in number
462: ,p_object_version_number in number
463: ,p_return_status out nocopy varchar2
464: ) is
486: --
487: -- Convert constant values to their corresponding boolean value
488: --
489: l_validate :=
490: hr_api.constant_to_boolean
491: (p_constant_value => p_validate);
492: --
493: -- Register Surrogate ID or user key values
494: --
550: -- ----------------------------------------------------------------------------
551: -- |-----------------------< initiate_deployment >----------------------------|
552: -- ----------------------------------------------------------------------------
553: PROCEDURE initiate_deployment
554: (p_validate in number default hr_api.g_false_num
555: ,p_person_deployment_id in number
556: ,p_object_version_number in out nocopy number
557: ,p_host_person_id out nocopy number
558: ,p_host_per_ovn out nocopy number
587: --
588: -- Convert constant values to their corresponding boolean value
589: --
590: l_validate :=
591: hr_api.constant_to_boolean
592: (p_constant_value => p_validate);
593: --
594: -- Register Surrogate ID or user key values
595: --
672: -- ----------------------------------------------------------------------------
673: -- |-----------------------< change_deployment_dates >------------------------|
674: -- ----------------------------------------------------------------------------
675: PROCEDURE change_deployment_dates
676: (p_validate in number default hr_api.g_false_num
677: ,p_person_deployment_id in number
678: ,p_object_version_number in out nocopy number
679: ,p_start_date in date default hr_api.g_date
680: ,p_end_date in date default hr_api.g_date
675: PROCEDURE change_deployment_dates
676: (p_validate in number default hr_api.g_false_num
677: ,p_person_deployment_id in number
678: ,p_object_version_number in out nocopy number
679: ,p_start_date in date default hr_api.g_date
680: ,p_end_date in date default hr_api.g_date
681: ,p_deplymt_policy_id in number default hr_api.g_number
682: ,p_return_status out nocopy varchar2
683: ) IS
676: (p_validate in number default hr_api.g_false_num
677: ,p_person_deployment_id in number
678: ,p_object_version_number in out nocopy number
679: ,p_start_date in date default hr_api.g_date
680: ,p_end_date in date default hr_api.g_date
681: ,p_deplymt_policy_id in number default hr_api.g_number
682: ,p_return_status out nocopy varchar2
683: ) IS
684: --
677: ,p_person_deployment_id in number
678: ,p_object_version_number in out nocopy number
679: ,p_start_date in date default hr_api.g_date
680: ,p_end_date in date default hr_api.g_date
681: ,p_deplymt_policy_id in number default hr_api.g_number
682: ,p_return_status out nocopy varchar2
683: ) IS
684: --
685: -- Variables for API Boolean parameters
708: --
709: -- Convert constant values to their corresponding boolean value
710: --
711: l_validate :=
712: hr_api.constant_to_boolean
713: (p_constant_value => p_validate);
714: --
715: -- Register Surrogate ID or user key values
716: --
777: -- ----------------------------------------------------------------------------
778: -- |-----------------------< return_from_deployment >-------------------------|
779: -- ----------------------------------------------------------------------------
780: PROCEDURE return_from_deployment
781: (p_validate in number default hr_api.g_false_num
782: ,p_person_deployment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_end_date in date default hr_api.g_date
785: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
780: PROCEDURE return_from_deployment
781: (p_validate in number default hr_api.g_false_num
782: ,p_person_deployment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_end_date in date default hr_api.g_date
785: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
786: ,p_leaving_person_type_id in number default hr_api.g_number
787: ,p_return_status out nocopy varchar2
788: ) IS
781: (p_validate in number default hr_api.g_false_num
782: ,p_person_deployment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_end_date in date default hr_api.g_date
785: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
786: ,p_leaving_person_type_id in number default hr_api.g_number
787: ,p_return_status out nocopy varchar2
788: ) IS
789: --
782: ,p_person_deployment_id in number
783: ,p_object_version_number in out nocopy number
784: ,p_end_date in date default hr_api.g_date
785: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
786: ,p_leaving_person_type_id in number default hr_api.g_number
787: ,p_return_status out nocopy varchar2
788: ) IS
789: --
790: -- Variables for API Boolean parameters
813: --
814: -- Convert constant values to their corresponding boolean value
815: --
816: l_validate :=
817: hr_api.constant_to_boolean
818: (p_constant_value => p_validate);
819: --
820: -- Register Surrogate ID or user key values
821: --