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.HR_PERSON_DEPLOYMENT_SWI dependencies on HR_API

Line 13: (p_validate in number default hr_api.g_false_num

9: -- ----------------------------------------------------------------------------
10: -- |-----------------------< create_person_deployment >-----------------------|
11: -- ----------------------------------------------------------------------------
12: PROCEDURE create_person_deployment
13: (p_validate in number default hr_api.g_false_num
14: ,p_from_business_group_id in number
15: ,p_to_business_group_id in number
16: ,p_from_person_id in number
17: ,p_to_person_id in number default null

Line 104: hr_api.constant_to_boolean

100: --
101: -- Convert constant values to their corresponding boolean value
102: --
103: l_validate :=
104: hr_api.constant_to_boolean
105: (p_constant_value => p_validate);
106: --
107: -- Register Surrogate ID or user key values
108: --

Line 241: (p_validate in number default hr_api.g_false_num

237: -- ----------------------------------------------------------------------------
238: -- |-----------------------< update_person_deployment >-----------------------|
239: -- ----------------------------------------------------------------------------
240: PROCEDURE update_person_deployment
241: (p_validate in number default hr_api.g_false_num
242: ,p_person_deployment_id in number
243: ,p_object_version_number in out nocopy number
244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date

Line 244: ,p_person_type_id in number default hr_api.g_number

240: PROCEDURE update_person_deployment
241: (p_validate in number default hr_api.g_false_num
242: ,p_person_deployment_id in number
243: ,p_object_version_number in out nocopy number
244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 245: ,p_start_date in date default hr_api.g_date

241: (p_validate in number default hr_api.g_false_num
242: ,p_person_deployment_id in number
243: ,p_object_version_number in out nocopy number
244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number

Line 246: ,p_end_date in date default hr_api.g_date

242: ,p_person_deployment_id in number
243: ,p_object_version_number in out nocopy number
244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2

Line 247: ,p_employee_number in varchar2 default hr_api.g_varchar2

243: ,p_object_version_number in out nocopy number
244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

Line 248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

244: ,p_person_type_id in number default hr_api.g_number
245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number

Line 249: ,p_leaving_person_type_id in number default hr_api.g_number

245: ,p_start_date in date default hr_api.g_date
246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number

Line 250: ,p_status in varchar2 default hr_api.g_varchar2

246: ,p_end_date in date default hr_api.g_date
247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number

Line 251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

247: ,p_employee_number in varchar2 default hr_api.g_varchar2
248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number

Line 252: ,p_deplymt_policy_id in number default hr_api.g_number

248: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number

Line 253: ,p_organization_id in number default hr_api.g_number

249: ,p_leaving_person_type_id in number default hr_api.g_number
250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number

Line 254: ,p_location_id in number default hr_api.g_number

250: ,p_status in varchar2 default hr_api.g_varchar2
251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number

Line 255: ,p_job_id in number default hr_api.g_number

251: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 256: ,p_position_id in number default hr_api.g_number

252: ,p_deplymt_policy_id in number default hr_api.g_number
253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2

Line 257: ,p_grade_id in number default hr_api.g_number

253: ,p_organization_id in number default hr_api.g_number
254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number

Line 258: ,p_supervisor_id in number default hr_api.g_number

254: ,p_location_id in number default hr_api.g_number
255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number

Line 259: ,p_supervisor_assignment_id in number default hr_api.g_number

255: ,p_job_id in number default hr_api.g_number
256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2

Line 260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2

256: ,p_position_id in number default hr_api.g_number
257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number

Line 261: ,p_payroll_id in number default hr_api.g_number

257: ,p_grade_id in number default hr_api.g_number
258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 262: ,p_pay_basis_id in number default hr_api.g_number

258: ,p_supervisor_id in number default hr_api.g_number
259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number

Line 263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2

259: ,p_supervisor_assignment_id in number default hr_api.g_number
260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2

Line 264: ,p_people_group_id in number default hr_api.g_number

260: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 265: ,p_soft_coding_keyflex_id in number default hr_api.g_number

261: ,p_payroll_id in number default hr_api.g_number
262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 266: ,p_assignment_status_type_id in number default hr_api.g_number

262: ,p_pay_basis_id in number default hr_api.g_number
263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2

263: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 268: ,p_assignment_category in varchar2 default hr_api.g_varchar2

264: ,p_people_group_id in number default hr_api.g_number
265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 269: ,p_per_information1 in varchar2 default hr_api.g_varchar2

265: ,p_soft_coding_keyflex_id in number default hr_api.g_number
266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 270: ,p_per_information2 in varchar2 default hr_api.g_varchar2

266: ,p_assignment_status_type_id in number default hr_api.g_number
267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 271: ,p_per_information3 in varchar2 default hr_api.g_varchar2

267: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 272: ,p_per_information4 in varchar2 default hr_api.g_varchar2

268: ,p_assignment_category in varchar2 default hr_api.g_varchar2
269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 273: ,p_per_information5 in varchar2 default hr_api.g_varchar2

269: ,p_per_information1 in varchar2 default hr_api.g_varchar2
270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 274: ,p_per_information6 in varchar2 default hr_api.g_varchar2

270: ,p_per_information2 in varchar2 default hr_api.g_varchar2
271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 275: ,p_per_information7 in varchar2 default hr_api.g_varchar2

271: ,p_per_information3 in varchar2 default hr_api.g_varchar2
272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 276: ,p_per_information8 in varchar2 default hr_api.g_varchar2

272: ,p_per_information4 in varchar2 default hr_api.g_varchar2
273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 277: ,p_per_information9 in varchar2 default hr_api.g_varchar2

273: ,p_per_information5 in varchar2 default hr_api.g_varchar2
274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 278: ,p_per_information10 in varchar2 default hr_api.g_varchar2

274: ,p_per_information6 in varchar2 default hr_api.g_varchar2
275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 279: ,p_per_information11 in varchar2 default hr_api.g_varchar2

275: ,p_per_information7 in varchar2 default hr_api.g_varchar2
276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 280: ,p_per_information12 in varchar2 default hr_api.g_varchar2

276: ,p_per_information8 in varchar2 default hr_api.g_varchar2
277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 281: ,p_per_information13 in varchar2 default hr_api.g_varchar2

277: ,p_per_information9 in varchar2 default hr_api.g_varchar2
278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 282: ,p_per_information14 in varchar2 default hr_api.g_varchar2

278: ,p_per_information10 in varchar2 default hr_api.g_varchar2
279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 283: ,p_per_information15 in varchar2 default hr_api.g_varchar2

279: ,p_per_information11 in varchar2 default hr_api.g_varchar2
280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 284: ,p_per_information16 in varchar2 default hr_api.g_varchar2

280: ,p_per_information12 in varchar2 default hr_api.g_varchar2
281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 285: ,p_per_information17 in varchar2 default hr_api.g_varchar2

281: ,p_per_information13 in varchar2 default hr_api.g_varchar2
282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 286: ,p_per_information18 in varchar2 default hr_api.g_varchar2

282: ,p_per_information14 in varchar2 default hr_api.g_varchar2
283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 287: ,p_per_information19 in varchar2 default hr_api.g_varchar2

283: ,p_per_information15 in varchar2 default hr_api.g_varchar2
284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 288: ,p_per_information20 in varchar2 default hr_api.g_varchar2

284: ,p_per_information16 in varchar2 default hr_api.g_varchar2
285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 289: ,p_per_information21 in varchar2 default hr_api.g_varchar2

285: ,p_per_information17 in varchar2 default hr_api.g_varchar2
286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 290: ,p_per_information22 in varchar2 default hr_api.g_varchar2

286: ,p_per_information18 in varchar2 default hr_api.g_varchar2
287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 291: ,p_per_information23 in varchar2 default hr_api.g_varchar2

287: ,p_per_information19 in varchar2 default hr_api.g_varchar2
288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 292: ,p_per_information24 in varchar2 default hr_api.g_varchar2

288: ,p_per_information20 in varchar2 default hr_api.g_varchar2
289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 293: ,p_per_information25 in varchar2 default hr_api.g_varchar2

289: ,p_per_information21 in varchar2 default hr_api.g_varchar2
290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 294: ,p_per_information26 in varchar2 default hr_api.g_varchar2

290: ,p_per_information22 in varchar2 default hr_api.g_varchar2
291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 295: ,p_per_information27 in varchar2 default hr_api.g_varchar2

291: ,p_per_information23 in varchar2 default hr_api.g_varchar2
292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2
299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2

Line 296: ,p_per_information28 in varchar2 default hr_api.g_varchar2

292: ,p_per_information24 in varchar2 default hr_api.g_varchar2
293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2
299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2

Line 297: ,p_per_information29 in varchar2 default hr_api.g_varchar2

293: ,p_per_information25 in varchar2 default hr_api.g_varchar2
294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2
299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is

Line 298: ,p_per_information30 in varchar2 default hr_api.g_varchar2

294: ,p_per_information26 in varchar2 default hr_api.g_varchar2
295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2
299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is
302: --

Line 299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2

295: ,p_per_information27 in varchar2 default hr_api.g_varchar2
296: ,p_per_information28 in varchar2 default hr_api.g_varchar2
297: ,p_per_information29 in varchar2 default hr_api.g_varchar2
298: ,p_per_information30 in varchar2 default hr_api.g_varchar2
299: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is
302: --
303: -- Variables for API Boolean parameters

Line 330: hr_api.constant_to_boolean

326: --
327: -- Convert constant values to their corresponding boolean value
328: --
329: l_validate :=
330: hr_api.constant_to_boolean
331: (p_constant_value => p_validate);
332: --
333: -- Register Surrogate ID or user key values
334: --

Line 461: (p_validate in number default hr_api.g_false_num

457: -- ----------------------------------------------------------------------------
458: -- |-----------------------< delete_person_deployment >-----------------------|
459: -- ----------------------------------------------------------------------------
460: PROCEDURE delete_person_deployment
461: (p_validate in number default hr_api.g_false_num
462: ,p_person_deployment_id in number
463: ,p_object_version_number in number
464: ,p_return_status out nocopy varchar2
465: ) is

Line 478: from hr_api_transactions hat,

474:
475: cursor c_del_trans is
476: select hat.transaction_id transaction_id,
477: hats.transaction_step_id transaction_step_id
478: from hr_api_transactions hat,
479: hr_api_transaction_steps hats
480: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
481: and hat.transaction_id = hats.transaction_id
482: and hats.information1 = to_char(p_person_deployment_id);

Line 479: hr_api_transaction_steps hats

475: cursor c_del_trans is
476: select hat.transaction_id transaction_id,
477: hats.transaction_step_id transaction_step_id
478: from hr_api_transactions hat,
479: hr_api_transaction_steps hats
480: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
481: and hat.transaction_id = hats.transaction_id
482: and hats.information1 = to_char(p_person_deployment_id);
483:

Line 501: hr_api.constant_to_boolean

497: --
498: -- Convert constant values to their corresponding boolean value
499: --
500: l_validate :=
501: hr_api.constant_to_boolean
502: (p_constant_value => p_validate);
503: --
504: -- Register Surrogate ID or user key values
505: --

Line 572: (p_validate in number default hr_api.g_false_num

568: -- ----------------------------------------------------------------------------
569: -- |-----------------------< initiate_deployment >----------------------------|
570: -- ----------------------------------------------------------------------------
571: PROCEDURE initiate_deployment
572: (p_validate in number default hr_api.g_false_num
573: ,p_person_deployment_id in number
574: ,p_object_version_number in out nocopy number
575: ,p_host_person_id out nocopy number
576: ,p_host_per_ovn out nocopy number

Line 609: hr_api.constant_to_boolean

605: --
606: -- Convert constant values to their corresponding boolean value
607: --
608: l_validate :=
609: hr_api.constant_to_boolean
610: (p_constant_value => p_validate);
611: --
612: -- Register Surrogate ID or user key values
613: --

Line 694: (p_validate in number default hr_api.g_false_num

690: -- ----------------------------------------------------------------------------
691: -- |-----------------------< change_deployment_dates >------------------------|
692: -- ----------------------------------------------------------------------------
693: PROCEDURE change_deployment_dates
694: (p_validate in number default hr_api.g_false_num
695: ,p_person_deployment_id in number
696: ,p_object_version_number in out nocopy number
697: ,p_start_date in date default hr_api.g_date
698: ,p_end_date in date default hr_api.g_date

Line 697: ,p_start_date in date default hr_api.g_date

693: PROCEDURE change_deployment_dates
694: (p_validate in number default hr_api.g_false_num
695: ,p_person_deployment_id in number
696: ,p_object_version_number in out nocopy number
697: ,p_start_date in date default hr_api.g_date
698: ,p_end_date in date default hr_api.g_date
699: ,p_deplymt_policy_id in number default hr_api.g_number
700: ,p_return_status out nocopy varchar2
701: ) IS

Line 698: ,p_end_date in date default hr_api.g_date

694: (p_validate in number default hr_api.g_false_num
695: ,p_person_deployment_id in number
696: ,p_object_version_number in out nocopy number
697: ,p_start_date in date default hr_api.g_date
698: ,p_end_date in date default hr_api.g_date
699: ,p_deplymt_policy_id in number default hr_api.g_number
700: ,p_return_status out nocopy varchar2
701: ) IS
702: --

Line 699: ,p_deplymt_policy_id in number default hr_api.g_number

695: ,p_person_deployment_id in number
696: ,p_object_version_number in out nocopy number
697: ,p_start_date in date default hr_api.g_date
698: ,p_end_date in date default hr_api.g_date
699: ,p_deplymt_policy_id in number default hr_api.g_number
700: ,p_return_status out nocopy varchar2
701: ) IS
702: --
703: -- Variables for API Boolean parameters

Line 730: hr_api.constant_to_boolean

726: --
727: -- Convert constant values to their corresponding boolean value
728: --
729: l_validate :=
730: hr_api.constant_to_boolean
731: (p_constant_value => p_validate);
732: --
733: -- Register Surrogate ID or user key values
734: --

Line 799: (p_validate in number default hr_api.g_false_num

795: -- ----------------------------------------------------------------------------
796: -- |-----------------------< return_from_deployment >-------------------------|
797: -- ----------------------------------------------------------------------------
798: PROCEDURE return_from_deployment
799: (p_validate in number default hr_api.g_false_num
800: ,p_person_deployment_id in number
801: ,p_object_version_number in out nocopy number
802: ,p_end_date in date default hr_api.g_date
803: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 802: ,p_end_date in date default hr_api.g_date

798: PROCEDURE return_from_deployment
799: (p_validate in number default hr_api.g_false_num
800: ,p_person_deployment_id in number
801: ,p_object_version_number in out nocopy number
802: ,p_end_date in date default hr_api.g_date
803: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
804: ,p_leaving_person_type_id in number default hr_api.g_number
805: ,p_return_status out nocopy varchar2
806: ) IS

Line 803: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

799: (p_validate in number default hr_api.g_false_num
800: ,p_person_deployment_id in number
801: ,p_object_version_number in out nocopy number
802: ,p_end_date in date default hr_api.g_date
803: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
804: ,p_leaving_person_type_id in number default hr_api.g_number
805: ,p_return_status out nocopy varchar2
806: ) IS
807: --

Line 804: ,p_leaving_person_type_id in number default hr_api.g_number

800: ,p_person_deployment_id in number
801: ,p_object_version_number in out nocopy number
802: ,p_end_date in date default hr_api.g_date
803: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
804: ,p_leaving_person_type_id in number default hr_api.g_number
805: ,p_return_status out nocopy varchar2
806: ) IS
807: --
808: -- Variables for API Boolean parameters

Line 835: hr_api.constant_to_boolean

831: --
832: -- Convert constant values to their corresponding boolean value
833: --
834: l_validate :=
835: hr_api.constant_to_boolean
836: (p_constant_value => p_validate);
837: --
838: -- Register Surrogate ID or user key values
839: --

Line 1208: ,p_validate in number default hr_api.g_false_num

1204:
1205: Procedure process_api
1206: ( p_document in CLOB
1207: ,p_return_status out nocopy VARCHAR2
1208: ,p_validate in number default hr_api.g_false_num
1209: ,p_effective_date in date default null
1210: )
1211: IS
1212: l_postState VARCHAR2(2);

Line 1347: from hr_api_transactions hat,hr_api_transaction_steps hats

1343: l_person_deployment_id := hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null);
1344: begin
1345: select max(hat.transaction_id)
1346: into l_transaction_id
1347: from hr_api_transactions hat,hr_api_transaction_steps hats
1348: where hat.transaction_id = hats.transaction_id
1349: and hats.information1 = l_person_deployment_id
1350: and hats.information12 = 'CreateMode';
1351: exception

Line 1475: lv_permanent hr_api_transaction_steps.Information8%type;

1471: p_person_deployment_id in number) return varchar2
1472:
1473: IS
1474: c_proc constant varchar2(30) := 'getDeploymentType';
1475: lv_permanent hr_api_transaction_steps.Information8%type;
1476: begin
1477: g_debug := hr_utility.debug_enabled;
1478: if g_debug then
1479: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1486: from hr_api_transaction_steps

1482: if(p_transaction_id is not null) then
1483: begin
1484: select Information8
1485: into lv_permanent
1486: from hr_api_transaction_steps
1487: where transaction_id=p_transaction_id;
1488: exception
1489: when others then
1490: lv_permanent:=null;

Line 1527: lv_deployment_id hr_api_transaction_steps.Information1%type;

1523: p_person_deployment_id in number) return number
1524:
1525: IS
1526: c_proc constant varchar2(30) := 'getPersonDeploymentId';
1527: lv_deployment_id hr_api_transaction_steps.Information1%type;
1528: begin
1529: g_debug := hr_utility.debug_enabled;
1530: if g_debug then
1531: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1538: from hr_api_transaction_steps

1534: if(p_transaction_id is not null) then
1535: begin
1536: select Information1
1537: into lv_deployment_id
1538: from hr_api_transaction_steps
1539: where transaction_id=p_transaction_id;
1540: exception
1541: when others then
1542: lv_deployment_id:=null;

Line 1572: lv_from_person_id hr_api_transaction_steps.Information2%type;

1568: p_person_deployment_id in number) return number
1569:
1570: IS
1571: c_proc constant varchar2(30) := 'getFromPersonId';
1572: lv_from_person_id hr_api_transaction_steps.Information2%type;
1573: begin
1574: g_debug := hr_utility.debug_enabled;
1575: if g_debug then
1576: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1583: from hr_api_transaction_steps

1579: if(p_transaction_id is not null) then
1580: begin
1581: select Information2
1582: into lv_from_person_id
1583: from hr_api_transaction_steps
1584: where transaction_id=p_transaction_id;
1585: exception
1586: when others then
1587: lv_from_person_id:=null;

Line 1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;

1610: p_person_deployment_id in number) return number
1611:
1612: IS
1613: c_proc constant varchar2(30) := 'getToBgId';
1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;
1615: begin
1616: g_debug := hr_utility.debug_enabled;
1617: if g_debug then
1618: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1625: from hr_api_transaction_steps

1621: if(p_transaction_id is not null) then
1622: begin
1623: select Information3
1624: into lv_to_bg_id
1625: from hr_api_transaction_steps
1626: where transaction_id=p_transaction_id;
1627: exception
1628: when others then
1629: lv_to_bg_id:=null;

Line 1656: lv_person_type_id hr_api_transaction_steps.Information4%type;

1652: p_person_deployment_id in number) return number
1653:
1654: IS
1655: c_proc constant varchar2(30) := 'getPersonTypeId';
1656: lv_person_type_id hr_api_transaction_steps.Information4%type;
1657: begin
1658: g_debug := hr_utility.debug_enabled;
1659: if g_debug then
1660: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1667: from hr_api_transaction_steps

1663: if(p_transaction_id is not null) then
1664: begin
1665: select Information4
1666: into lv_person_type_id
1667: from hr_api_transaction_steps
1668: where transaction_id=p_transaction_id;
1669: exception
1670: when others then
1671: lv_person_type_id:=null;

Line 1700: lv_start_date hr_api_transaction_steps.Information5%type;

1696: p_person_deployment_id in number) return date
1697:
1698: IS
1699: c_proc constant varchar2(30) := 'getStartDate';
1700: lv_start_date hr_api_transaction_steps.Information5%type;
1701: begin
1702: g_debug := hr_utility.debug_enabled;
1703: if g_debug then
1704: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1711: from hr_api_transaction_steps

1707: if(p_transaction_id is not null) then
1708: begin
1709: select to_date(Information5,'YYYY-MM-DD')
1710: into lv_start_date
1711: from hr_api_transaction_steps
1712: where transaction_id=p_transaction_id;
1713: exception
1714: when others then
1715: lv_start_date:=null;

Line 1743: lv_end_date hr_api_transaction_steps.Information6%type;

1739: p_person_deployment_id in number) return date
1740:
1741: IS
1742: c_proc constant varchar2(30) := 'getEndDate';
1743: lv_end_date hr_api_transaction_steps.Information6%type;
1744:
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747: if g_debug then

Line 1755: from hr_api_transaction_steps

1751: if(p_transaction_id is not null) then
1752: begin
1753: select to_date(Information6,'YYYY-MM-DD')
1754: into lv_end_date
1755: from hr_api_transaction_steps
1756: where transaction_id=p_transaction_id;
1757: exception
1758: when others then
1759: lv_end_date:=null;

Line 1789: lv_employee_number hr_api_transaction_steps.Information7%type;

1785: p_person_deployment_id in number) return varchar2
1786:
1787: IS
1788: c_proc constant varchar2(30) := 'getEmployeeNumber';
1789: lv_employee_number hr_api_transaction_steps.Information7%type;
1790:
1791: begin
1792: g_debug := hr_utility.debug_enabled;
1793: if g_debug then

Line 1801: from hr_api_transaction_steps

1797: if(p_transaction_id is not null) then
1798: begin
1799: select Information7
1800: into lv_employee_number
1801: from hr_api_transaction_steps
1802: where transaction_id=p_transaction_id;
1803: exception
1804: when others then
1805: lv_employee_number:=null;

Line 1834: lv_to_bg_id hr_api_transaction_steps.Information9%type;

1830: p_person_deployment_id in number) return number
1831:
1832: IS
1833: c_proc constant varchar2(30) := 'getFromBgId';
1834: lv_to_bg_id hr_api_transaction_steps.Information9%type;
1835:
1836: begin
1837: g_debug := hr_utility.debug_enabled;
1838: if g_debug then

Line 1846: from hr_api_transaction_steps

1842: if(p_transaction_id is not null) then
1843: begin
1844: select Information9
1845: into lv_to_bg_id
1846: from hr_api_transaction_steps
1847: where transaction_id=p_transaction_id;
1848: exception
1849: when others then
1850: lv_to_bg_id:=null;

Line 1879: lv_organization_id hr_api_transaction_steps.Information10%type;

1875: p_person_deployment_id in number) return number
1876:
1877: IS
1878: c_proc constant varchar2(30) := 'getOrganizationId';
1879: lv_organization_id hr_api_transaction_steps.Information10%type;
1880:
1881: begin
1882: g_debug := hr_utility.debug_enabled;
1883: if g_debug then

Line 1891: from hr_api_transaction_steps

1887: if(p_transaction_id is not null) then
1888: begin
1889: select Information10
1890: into lv_organization_id
1891: from hr_api_transaction_steps
1892: where transaction_id=p_transaction_id;
1893: exception
1894: when others then
1895: lv_organization_id:=null;

Line 1922: lv_job_id hr_api_transaction_steps.Information11%type;

1918: p_person_deployment_id in number) return number
1919:
1920: IS
1921: c_proc constant varchar2(30) := 'getJobId';
1922: lv_job_id hr_api_transaction_steps.Information11%type;
1923:
1924: begin
1925: g_debug := hr_utility.debug_enabled;
1926: if g_debug then

Line 1934: from hr_api_transaction_steps

1930: if(p_transaction_id is not null) then
1931: begin
1932: select Information11
1933: into lv_job_id
1934: from hr_api_transaction_steps
1935: where transaction_id=p_transaction_id;
1936: exception
1937: when others then
1938: lv_job_id:=null;

Line 2214: lv_action_mode hr_api_transaction_steps.Information12%type;

2210: p_person_deployment_id in number) return varchar2
2211:
2212: IS
2213: c_proc constant varchar2(30) := 'getActionMode';
2214: lv_action_mode hr_api_transaction_steps.Information12%type;
2215: begin
2216: g_debug := hr_utility.debug_enabled;
2217: if g_debug then
2218: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2225: from hr_api_transaction_steps

2221: if(p_transaction_id is not null) then
2222: begin
2223: select Information12
2224: into lv_action_mode
2225: from hr_api_transaction_steps
2226: where transaction_id=p_transaction_id;
2227: exception
2228: when others then
2229: lv_action_mode:=null;

Line 2257: lv_action_mode hr_api_transaction_steps.Information12%type;

2253: p_transaction_status in varchar2) return varchar2
2254:
2255: IS
2256: c_proc constant varchar2(30) := 'getStatus';
2257: lv_action_mode hr_api_transaction_steps.Information12%type;
2258: lv_status Varchar2(40);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;

Line 2273: from hr_api_transaction_steps

2269: if(p_transaction_id is not null) then
2270: begin
2271: select Information12
2272: into lv_action_mode
2273: from hr_api_transaction_steps
2274: where transaction_id=p_transaction_id;
2275: exception
2276: when others then
2277: lv_action_mode:=null;

Line 2331: lv_from_person_id hr_api_transaction_steps.Information13%type;

2327: p_person_deployment_id in number) return number
2328:
2329: IS
2330: c_proc constant varchar2(30) := 'getToPersonId';
2331: lv_from_person_id hr_api_transaction_steps.Information13%type;
2332: begin
2333: g_debug := hr_utility.debug_enabled;
2334: if g_debug then
2335: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2342: from hr_api_transaction_steps

2338: if(p_transaction_id is not null) then
2339: begin
2340: select Information13
2341: into lv_from_person_id
2342: from hr_api_transaction_steps
2343: where transaction_id=p_transaction_id;
2344: exception
2345: when others then
2346: lv_from_person_id:=null;

Line 2374: lv_ovn hr_api_transaction_steps.Information14%type;

2370: p_person_deployment_id in number) return number
2371:
2372: IS
2373: c_proc constant varchar2(30) := 'getOvn';
2374: lv_ovn hr_api_transaction_steps.Information14%type;
2375: begin
2376: g_debug := hr_utility.debug_enabled;
2377: if g_debug then
2378: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2385: from hr_api_transaction_steps

2381: if(p_transaction_id is not null) then
2382: begin
2383: select Information14
2384: into lv_ovn
2385: from hr_api_transaction_steps
2386: where transaction_id=p_transaction_id;
2387: exception
2388: when others then
2389: lv_ovn:=null;

Line 2435: from hr_api_transactions hat,

2431: if upper(p_deployment_status) = 'DRAFT'
2432: then
2433: select count(hat.transaction_id)
2434: into lv_transaction_count
2435: from hr_api_transactions hat,
2436: hr_api_transaction_steps hats
2437: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2438: and hats.transaction_id = hat.transaction_id
2439: and hats.information1 = to_char(p_deployment_id)

Line 2436: hr_api_transaction_steps hats

2432: then
2433: select count(hat.transaction_id)
2434: into lv_transaction_count
2435: from hr_api_transactions hat,
2436: hr_api_transaction_steps hats
2437: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2438: and hats.transaction_id = hat.transaction_id
2439: and hats.information1 = to_char(p_deployment_id)
2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2443: from hr_api_transactions t,

2439: and hats.information1 = to_char(p_deployment_id)
2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2441: and hat.status in ('AC')
2442: and not exists ( select 'e'
2443: from hr_api_transactions t,
2444: hr_api_transaction_steps hat
2445: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2446: and hat.transaction_id = t.transaction_id
2447: and hat.information1 = to_char(p_deployment_id)

Line 2444: hr_api_transaction_steps hat

2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2441: and hat.status in ('AC')
2442: and not exists ( select 'e'
2443: from hr_api_transactions t,
2444: hr_api_transaction_steps hat
2445: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2446: and hat.transaction_id = t.transaction_id
2447: and hat.information1 = to_char(p_deployment_id)
2448: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2460: from hr_api_transactions hat, hr_api_transaction_steps hats

2456: select ACTION
2457: into lv_action
2458: from PQH_SS_APPROVAL_HISTORY
2459: where transaction_history_id in (select hat.transaction_id
2460: from hr_api_transactions hat, hr_api_transaction_steps hats
2461: where hat.transaction_id = hats.transaction_id
2462: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2463: and hats.information1 = to_char(p_deployment_id)
2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2468: from hr_api_transactions hat, hr_api_transaction_steps hats

2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2465: and creation_date = (select max(CREATION_DATE)
2466: from PQH_SS_APPROVAL_HISTORY
2467: where transaction_history_id in (select hat.transaction_id
2468: from hr_api_transactions hat, hr_api_transaction_steps hats
2469: where hat.transaction_id = hats.transaction_id
2470: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2471: and hats.information1 = to_char(p_deployment_id)
2472: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2497: from hr_api_transactions hat,

2493: then
2494:
2495: select count(hat.transaction_id)
2496: into lv_transaction_count
2497: from hr_api_transactions hat,
2498: hr_api_transaction_steps hats
2499: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2500: and hats.transaction_id = hat.transaction_id
2501: and hats.information1 = to_char(p_deployment_id)

Line 2498: hr_api_transaction_steps hats

2494:
2495: select count(hat.transaction_id)
2496: into lv_transaction_count
2497: from hr_api_transactions hat,
2498: hr_api_transaction_steps hats
2499: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2500: and hats.transaction_id = hat.transaction_id
2501: and hats.information1 = to_char(p_deployment_id)
2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2505: from hr_api_transactions t,

2501: and hats.information1 = to_char(p_deployment_id)
2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2503: and hat.status in ('AC')
2504: and not exists ( select 'e'
2505: from hr_api_transactions t,
2506: hr_api_transaction_steps hat
2507: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2508: and hat.transaction_id = t.transaction_id
2509: and hat.information1 = to_char(p_deployment_id)

Line 2506: hr_api_transaction_steps hat

2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2503: and hat.status in ('AC')
2504: and not exists ( select 'e'
2505: from hr_api_transactions t,
2506: hr_api_transaction_steps hat
2507: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2508: and hat.transaction_id = t.transaction_id
2509: and hat.information1 = to_char(p_deployment_id)
2510: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2524: from hr_api_transactions hat, hr_api_transaction_steps hats

2520: select ACTION
2521: into lv_action
2522: from PQH_SS_APPROVAL_HISTORY
2523: where transaction_history_id in (select hat.transaction_id
2524: from hr_api_transactions hat, hr_api_transaction_steps hats
2525: where hat.transaction_id = hats.transaction_id
2526: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2527: and hats.information1 = to_char(p_deployment_id)
2528: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2533: from hr_api_transactions hat, hr_api_transaction_steps hats

2529: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2530: and creation_date = (select max(CREATION_DATE)
2531: from PQH_SS_APPROVAL_HISTORY
2532: where transaction_history_id in (select hat.transaction_id
2533: from hr_api_transactions hat, hr_api_transaction_steps hats
2534: where hat.transaction_id = hats.transaction_id
2535: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2536: and hats.information1 = to_char(p_deployment_id)
2537: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2565: from hr_api_transactions hat,

2561: then
2562:
2563: select count(hat.transaction_id)
2564: into lv_transaction_count
2565: from hr_api_transactions hat,
2566: hr_api_transaction_steps hats
2567: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2568: and hats.transaction_id = hat.transaction_id
2569: and hats.information1 = to_char(p_deployment_id)

Line 2566: hr_api_transaction_steps hats

2562:
2563: select count(hat.transaction_id)
2564: into lv_transaction_count
2565: from hr_api_transactions hat,
2566: hr_api_transaction_steps hats
2567: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2568: and hats.transaction_id = hat.transaction_id
2569: and hats.information1 = to_char(p_deployment_id)
2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2573: from hr_api_transactions t,

2569: and hats.information1 = to_char(p_deployment_id)
2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2571: and hat.status in ('AC')
2572: and not exists ( select 'e'
2573: from hr_api_transactions t,
2574: hr_api_transaction_steps hat
2575: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2576: and hat.transaction_id = t.transaction_id
2577: and hat.information1 = to_char(p_deployment_id)

Line 2574: hr_api_transaction_steps hat

2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2571: and hat.status in ('AC')
2572: and not exists ( select 'e'
2573: from hr_api_transactions t,
2574: hr_api_transaction_steps hat
2575: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2576: and hat.transaction_id = t.transaction_id
2577: and hat.information1 = to_char(p_deployment_id)
2578: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2592: from hr_api_transactions hat, hr_api_transaction_steps hats

2588: select ACTION
2589: into lv_action
2590: from PQH_SS_APPROVAL_HISTORY
2591: where transaction_history_id in (select hat.transaction_id
2592: from hr_api_transactions hat, hr_api_transaction_steps hats
2593: where hat.transaction_id = hats.transaction_id
2594: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2595: and hats.information1 = to_char(p_deployment_id)
2596: and upper(hats.information12) = 'RETURNMODE'

Line 2601: from hr_api_transactions hat, hr_api_transaction_steps hats

2597: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2598: and creation_date = (select max(CREATION_DATE)
2599: from PQH_SS_APPROVAL_HISTORY
2600: where transaction_history_id in (select hat.transaction_id
2601: from hr_api_transactions hat, hr_api_transaction_steps hats
2602: where hat.transaction_id = hats.transaction_id
2603: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2604: and hats.information1 = to_char(p_deployment_id)
2605: and upper(hats.information12) = 'RETURNMODE'

Line 2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2668: where transaction_history_id = p_transaction_id
2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:

Line 2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception

Line 2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception
2678: when others then lv_action := null;

Line 2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');

2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception
2678: when others then lv_action := null;
2679: end;

Line 2916: from hr_api_transactions

2912:
2913: begin
2914: select item_type,item_key
2915: into l_item_type,l_item_key
2916: from hr_api_transactions
2917: where transaction_id = p_transaction_id;
2918:
2919: hr_utility.set_location(l_proc||'l_item_key='||l_item_key,41);
2920: Exception