DBA Data[Home] [Help]

APPS.HR_PERSON_DEPLOYMENT_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 103: hr_api.constant_to_boolean

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: --

Line 240: (p_validate in number default hr_api.g_false_num

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

Line 243: ,p_person_type_id in number default hr_api.g_number

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

Line 244: ,p_start_date in date default hr_api.g_date

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

Line 245: ,p_end_date in date default hr_api.g_date

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

Line 246: ,p_employee_number 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

Line 247: ,p_leaving_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

Line 248: ,p_leaving_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
252: ,p_organization_id in number default hr_api.g_number

Line 249: ,p_status in varchar2 default hr_api.g_varchar2

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

Line 250: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

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

Line 251: ,p_deplymt_policy_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

Line 252: ,p_organization_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

Line 253: ,p_location_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

Line 254: ,p_job_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

Line 255: ,p_position_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

Line 256: ,p_grade_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
260: ,p_payroll_id in number default hr_api.g_number

Line 257: ,p_supervisor_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

Line 258: ,p_supervisor_assignment_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

Line 259: ,p_retain_direct_reports 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

Line 260: ,p_payroll_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

Line 261: ,p_pay_basis_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

Line 262: ,p_proposed_salary in varchar2 default hr_api.g_varchar2

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

Line 263: ,p_people_group_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
267: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 264: ,p_soft_coding_keyflex_id in number default hr_api.g_number

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

Line 265: ,p_assignment_status_type_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
269: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 266: ,p_ass_status_change_reason 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

Line 267: ,p_assignment_category 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

Line 268: ,p_per_information1 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

Line 269: ,p_per_information2 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

Line 270: ,p_per_information3 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

Line 271: ,p_per_information4 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

Line 272: ,p_per_information5 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

Line 273: ,p_per_information6 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

Line 274: ,p_per_information7 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

Line 275: ,p_per_information8 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

Line 276: ,p_per_information9 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

Line 277: ,p_per_information10 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

Line 278: ,p_per_information11 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

Line 279: ,p_per_information12 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

Line 280: ,p_per_information13 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

Line 281: ,p_per_information14 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

Line 282: ,p_per_information15 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

Line 283: ,p_per_information16 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

Line 284: ,p_per_information17 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

Line 285: ,p_per_information18 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

Line 286: ,p_per_information19 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

Line 287: ,p_per_information20 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

Line 288: ,p_per_information21 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

Line 289: ,p_per_information22 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

Line 290: ,p_per_information23 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

Line 291: ,p_per_information24 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

Line 292: ,p_per_information25 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

Line 293: ,p_per_information26 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

Line 294: ,p_per_information27 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

Line 295: ,p_per_information28 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

Line 296: ,p_per_information29 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
300: ) is

Line 297: ,p_per_information30 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
301: --

Line 298: ,p_deployment_reason 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: --
302: -- Variables for API Boolean parameters

Line 329: hr_api.constant_to_boolean

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: --

Line 460: (p_validate in number default hr_api.g_false_num

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

Line 490: hr_api.constant_to_boolean

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: --

Line 554: (p_validate in number default hr_api.g_false_num

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

Line 591: hr_api.constant_to_boolean

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: --

Line 676: (p_validate in number default hr_api.g_false_num

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

Line 679: ,p_start_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

Line 680: ,p_end_date in date default hr_api.g_date

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: --

Line 681: ,p_deplymt_policy_id in number default hr_api.g_number

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

Line 712: hr_api.constant_to_boolean

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: --

Line 781: (p_validate in number default hr_api.g_false_num

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

Line 784: ,p_end_date in date default hr_api.g_date

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

Line 785: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

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: --

Line 786: ,p_leaving_person_type_id in number default hr_api.g_number

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

Line 817: hr_api.constant_to_boolean

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: --