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_API dependencies on HR_API

Line 180: when hr_api.cannot_find_prog_unit then

176: ,p_per_information29 => p_per_information29
177: ,p_per_information30 => p_per_information30
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'CREATE_PERSON_DEPLOYMENT'
183: ,p_hook_type => 'BP'
184: );

Line 181: hr_api.cannot_find_prog_unit_error

177: ,p_per_information30 => p_per_information30
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'CREATE_PERSON_DEPLOYMENT'
183: ,p_hook_type => 'BP'
184: );
185: end;

Line 332: when hr_api.cannot_find_prog_unit then

328: ,p_object_version_number => l_object_version_number
329: ,p_policy_duration_warning => l_policy_duration_warning
330: );
331: exception
332: when hr_api.cannot_find_prog_unit then
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'CREATE_PERSON_DEPLOYMENT'
335: ,p_hook_type => 'AP'
336: );

Line 333: hr_api.cannot_find_prog_unit_error

329: ,p_policy_duration_warning => l_policy_duration_warning
330: );
331: exception
332: when hr_api.cannot_find_prog_unit then
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'CREATE_PERSON_DEPLOYMENT'
335: ,p_hook_type => 'AP'
336: );
337: end;

Line 342: raise hr_api.validate_enabled;

338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: if p_validate then
342: raise hr_api.validate_enabled;
343: end if;
344: --
345: -- Set all IN OUT and OUT parameters with out values
346: --

Line 353: when hr_api.validate_enabled then

349: p_policy_duration_warning := l_policy_duration_warning;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: exception
353: when hr_api.validate_enabled then
354: --
355: -- As the Validate_Enabled exception has been raised
356: -- we must rollback to the savepoint
357: --

Line 393: ,p_to_person_id in number default hr_api.g_number

389: procedure update_person_deployment
390: (p_validate in boolean default false
391: ,p_person_deployment_id in number
392: ,p_object_version_number in out nocopy number
393: ,p_to_person_id in number default hr_api.g_number
394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2

Line 394: ,p_person_type_id in number default hr_api.g_number

390: (p_validate in boolean default false
391: ,p_person_deployment_id in number
392: ,p_object_version_number in out nocopy number
393: ,p_to_person_id in number default hr_api.g_number
394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2

Line 395: ,p_start_date in date default hr_api.g_date

391: ,p_person_deployment_id in number
392: ,p_object_version_number in out nocopy number
393: ,p_to_person_id in number default hr_api.g_number
394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

Line 396: ,p_end_date in date default hr_api.g_date

392: ,p_object_version_number in out nocopy number
393: ,p_to_person_id in number default hr_api.g_number
394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number

Line 397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2

393: ,p_to_person_id in number default hr_api.g_number
394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2

Line 398: ,p_employee_number in varchar2 default hr_api.g_varchar2

394: ,p_person_type_id in number default hr_api.g_number
395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

Line 399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

395: ,p_start_date in date default hr_api.g_date
396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number

Line 400: ,p_leaving_person_type_id in number default hr_api.g_number

396: ,p_end_date in date default hr_api.g_date
397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number

Line 401: ,p_status in varchar2 default hr_api.g_varchar2

397: ,p_deployment_reason in varchar2 default hr_api.g_varchar2
398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number

Line 402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2

398: ,p_employee_number in varchar2 default hr_api.g_varchar2
399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number

Line 403: ,p_deplymt_policy_id in number default hr_api.g_number

399: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number

Line 404: ,p_organization_id in number default hr_api.g_number

400: ,p_leaving_person_type_id in number default hr_api.g_number
401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number

Line 405: ,p_location_id in number default hr_api.g_number

401: ,p_status in varchar2 default hr_api.g_varchar2
402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number

Line 406: ,p_job_id in number default hr_api.g_number

402: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 407: ,p_position_id in number default hr_api.g_number

403: ,p_deplymt_policy_id in number default hr_api.g_number
404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2

Line 408: ,p_grade_id in number default hr_api.g_number

404: ,p_organization_id in number default hr_api.g_number
405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number

Line 409: ,p_supervisor_id in number default hr_api.g_number

405: ,p_location_id in number default hr_api.g_number
406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number

Line 410: ,p_supervisor_assignment_id in number default hr_api.g_number

406: ,p_job_id in number default hr_api.g_number
407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2

Line 411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2

407: ,p_position_id in number default hr_api.g_number
408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number

Line 412: ,p_payroll_id in number default hr_api.g_number

408: ,p_grade_id in number default hr_api.g_number
409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 413: ,p_pay_basis_id in number default hr_api.g_number

409: ,p_supervisor_id in number default hr_api.g_number
410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number

Line 414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2

410: ,p_supervisor_assignment_id in number default hr_api.g_number
411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2

Line 415: ,p_people_group_id in number default hr_api.g_number

411: ,p_retain_direct_reports in varchar2 default hr_api.g_varchar2
412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 416: ,p_soft_coding_keyflex_id in number default hr_api.g_number

412: ,p_payroll_id in number default hr_api.g_number
413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 417: ,p_assignment_status_type_id in number default hr_api.g_number

413: ,p_pay_basis_id in number default hr_api.g_number
414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2

414: ,p_proposed_salary in varchar2 default hr_api.g_varchar2
415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 419: ,p_assignment_category in varchar2 default hr_api.g_varchar2

415: ,p_people_group_id in number default hr_api.g_number
416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 420: ,p_per_information1 in varchar2 default hr_api.g_varchar2

416: ,p_soft_coding_keyflex_id in number default hr_api.g_number
417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 421: ,p_per_information2 in varchar2 default hr_api.g_varchar2

417: ,p_assignment_status_type_id in number default hr_api.g_number
418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 422: ,p_per_information3 in varchar2 default hr_api.g_varchar2

418: ,p_ass_status_change_reason in varchar2 default hr_api.g_varchar2
419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 423: ,p_per_information4 in varchar2 default hr_api.g_varchar2

419: ,p_assignment_category in varchar2 default hr_api.g_varchar2
420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 424: ,p_per_information5 in varchar2 default hr_api.g_varchar2

420: ,p_per_information1 in varchar2 default hr_api.g_varchar2
421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 425: ,p_per_information6 in varchar2 default hr_api.g_varchar2

421: ,p_per_information2 in varchar2 default hr_api.g_varchar2
422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 426: ,p_per_information7 in varchar2 default hr_api.g_varchar2

422: ,p_per_information3 in varchar2 default hr_api.g_varchar2
423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 427: ,p_per_information8 in varchar2 default hr_api.g_varchar2

423: ,p_per_information4 in varchar2 default hr_api.g_varchar2
424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 428: ,p_per_information9 in varchar2 default hr_api.g_varchar2

424: ,p_per_information5 in varchar2 default hr_api.g_varchar2
425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 429: ,p_per_information10 in varchar2 default hr_api.g_varchar2

425: ,p_per_information6 in varchar2 default hr_api.g_varchar2
426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 430: ,p_per_information11 in varchar2 default hr_api.g_varchar2

426: ,p_per_information7 in varchar2 default hr_api.g_varchar2
427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 431: ,p_per_information12 in varchar2 default hr_api.g_varchar2

427: ,p_per_information8 in varchar2 default hr_api.g_varchar2
428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 432: ,p_per_information13 in varchar2 default hr_api.g_varchar2

428: ,p_per_information9 in varchar2 default hr_api.g_varchar2
429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 433: ,p_per_information14 in varchar2 default hr_api.g_varchar2

429: ,p_per_information10 in varchar2 default hr_api.g_varchar2
430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 434: ,p_per_information15 in varchar2 default hr_api.g_varchar2

430: ,p_per_information11 in varchar2 default hr_api.g_varchar2
431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 435: ,p_per_information16 in varchar2 default hr_api.g_varchar2

431: ,p_per_information12 in varchar2 default hr_api.g_varchar2
432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 436: ,p_per_information17 in varchar2 default hr_api.g_varchar2

432: ,p_per_information13 in varchar2 default hr_api.g_varchar2
433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 437: ,p_per_information18 in varchar2 default hr_api.g_varchar2

433: ,p_per_information14 in varchar2 default hr_api.g_varchar2
434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 438: ,p_per_information19 in varchar2 default hr_api.g_varchar2

434: ,p_per_information15 in varchar2 default hr_api.g_varchar2
435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 439: ,p_per_information20 in varchar2 default hr_api.g_varchar2

435: ,p_per_information16 in varchar2 default hr_api.g_varchar2
436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 440: ,p_per_information21 in varchar2 default hr_api.g_varchar2

436: ,p_per_information17 in varchar2 default hr_api.g_varchar2
437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 441: ,p_per_information22 in varchar2 default hr_api.g_varchar2

437: ,p_per_information18 in varchar2 default hr_api.g_varchar2
438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 442: ,p_per_information23 in varchar2 default hr_api.g_varchar2

438: ,p_per_information19 in varchar2 default hr_api.g_varchar2
439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 443: ,p_per_information24 in varchar2 default hr_api.g_varchar2

439: ,p_per_information20 in varchar2 default hr_api.g_varchar2
440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 444: ,p_per_information25 in varchar2 default hr_api.g_varchar2

440: ,p_per_information21 in varchar2 default hr_api.g_varchar2
441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 445: ,p_per_information26 in varchar2 default hr_api.g_varchar2

441: ,p_per_information22 in varchar2 default hr_api.g_varchar2
442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2
449: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 446: ,p_per_information27 in varchar2 default hr_api.g_varchar2

442: ,p_per_information23 in varchar2 default hr_api.g_varchar2
443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2
449: ,p_per_information30 in varchar2 default hr_api.g_varchar2
450: ,p_policy_duration_warning out nocopy boolean

Line 447: ,p_per_information28 in varchar2 default hr_api.g_varchar2

443: ,p_per_information24 in varchar2 default hr_api.g_varchar2
444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2
449: ,p_per_information30 in varchar2 default hr_api.g_varchar2
450: ,p_policy_duration_warning out nocopy boolean
451: ) is

Line 448: ,p_per_information29 in varchar2 default hr_api.g_varchar2

444: ,p_per_information25 in varchar2 default hr_api.g_varchar2
445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2
449: ,p_per_information30 in varchar2 default hr_api.g_varchar2
450: ,p_policy_duration_warning out nocopy boolean
451: ) is
452: --

Line 449: ,p_per_information30 in varchar2 default hr_api.g_varchar2

445: ,p_per_information26 in varchar2 default hr_api.g_varchar2
446: ,p_per_information27 in varchar2 default hr_api.g_varchar2
447: ,p_per_information28 in varchar2 default hr_api.g_varchar2
448: ,p_per_information29 in varchar2 default hr_api.g_varchar2
449: ,p_per_information30 in varchar2 default hr_api.g_varchar2
450: ,p_policy_duration_warning out nocopy boolean
451: ) is
452: --
453: -- Declare cursors and local variables

Line 544: when hr_api.cannot_find_prog_unit then

540: ,p_per_information29 => p_per_information29
541: ,p_per_information30 => p_per_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PERSON_DEPLOYMENT'
547: ,p_hook_type => 'BP'
548: );

Line 545: hr_api.cannot_find_prog_unit_error

541: ,p_per_information30 => p_per_information30
542: );
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'UPDATE_PERSON_DEPLOYMENT'
547: ,p_hook_type => 'BP'
548: );
549: end;

Line 688: when hr_api.cannot_find_prog_unit then

684: ,p_per_information30 => p_per_information30
685: ,p_policy_duration_warning => l_policy_duration_warning
686: );
687: exception
688: when hr_api.cannot_find_prog_unit then
689: hr_api.cannot_find_prog_unit_error
690: (p_module_name => 'UPDATE_PERSON_DEPLOYMENT'
691: ,p_hook_type => 'AP'
692: );

Line 689: hr_api.cannot_find_prog_unit_error

685: ,p_policy_duration_warning => l_policy_duration_warning
686: );
687: exception
688: when hr_api.cannot_find_prog_unit then
689: hr_api.cannot_find_prog_unit_error
690: (p_module_name => 'UPDATE_PERSON_DEPLOYMENT'
691: ,p_hook_type => 'AP'
692: );
693: end;

Line 698: raise hr_api.validate_enabled;

694: --
695: -- When in validation only mode raise the Validate_Enabled exception
696: --
697: if p_validate then
698: raise hr_api.validate_enabled;
699: end if;
700: --
701: -- Set all IN OUT and OUT parameters with out values
702: --

Line 707: when hr_api.validate_enabled then

703: p_policy_duration_warning := l_policy_duration_warning;
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 70);
706: exception
707: when hr_api.validate_enabled then
708: --
709: -- As the Validate_Enabled exception has been raised
710: -- we must rollback to the savepoint
711: --

Line 773: when hr_api.cannot_find_prog_unit then

769: (p_person_deployment_id => p_person_deployment_id
770: ,p_object_version_number => p_object_version_number
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_PERSON_DEPLOYMENT'
776: ,p_hook_type => 'BP'
777: );

Line 774: hr_api.cannot_find_prog_unit_error

770: ,p_object_version_number => p_object_version_number
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_PERSON_DEPLOYMENT'
776: ,p_hook_type => 'BP'
777: );
778: end;

Line 800: when hr_api.cannot_find_prog_unit then

796: (p_person_deployment_id => p_person_deployment_id
797: ,p_object_version_number => p_object_version_number
798: );
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'DELETE_PERSON_DEPLOYMENT'
803: ,p_hook_type => 'AP'
804: );

Line 801: hr_api.cannot_find_prog_unit_error

797: ,p_object_version_number => p_object_version_number
798: );
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'DELETE_PERSON_DEPLOYMENT'
803: ,p_hook_type => 'AP'
804: );
805: end;

Line 810: raise hr_api.validate_enabled;

806: --
807: -- When in validation only mode raise the Validate_Enabled exception
808: --
809: if p_validate then
810: raise hr_api.validate_enabled;
811: end if;
812: --
813: -- Set all IN OUT and OUT parameters with out values
814: --

Line 818: when hr_api.validate_enabled then

814: --
815: --
816: hr_utility.set_location(' Leaving:'||l_proc, 70);
817: exception
818: when hr_api.validate_enabled then
819: --
820: -- As the Validate_Enabled exception has been raised
821: -- we must rollback to the savepoint
822: --

Line 990: and pdt1.start_date <= nvl(pdt2.end_date,hr_api.g_eot));

986: from hr_person_deployments pdt2
987: where pdt2.person_deployment_id <> pdt1.person_deployment_id
988: and pdt2.from_person_id = pdt1.from_person_id
989: and pdt2.status in ('ACTIVE','COMPLETE')
990: and pdt1.start_date <= nvl(pdt2.end_date,hr_api.g_eot));
991: --
992: cursor csr_home_per_values(p_person_id number) is
993: select papf.last_name, papf.sex, papf.party_id, papf.original_date_of_hire
994: from per_all_people_f papf

Line 1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;

1088: -----
1089:
1090: -- local variables for people group
1091: l_group_id number :=null;
1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;
1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;

Line 1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;

1089:
1090: -- local variables for people group
1091: l_group_id number :=null;
1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;
1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;

Line 1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;

1090: -- local variables for people group
1091: l_group_id number :=null;
1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;
1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;

Line 1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;

1091: l_group_id number :=null;
1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;
1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;

Line 1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;

1092: l_pgp_segment1 varchar2(60):=hr_api.g_varchar2;
1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;

Line 1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;

1093: l_pgp_segment2 varchar2(60):=hr_api.g_varchar2;
1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;

Line 1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;

1094: l_pgp_segment3 varchar2(60):=hr_api.g_varchar2;
1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;

Line 1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;

1095: l_pgp_segment4 varchar2(60):=hr_api.g_varchar2;
1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;

Line 1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;

1096: l_pgp_segment5 varchar2(60):=hr_api.g_varchar2;
1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;

Line 1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;

1097: l_pgp_segment6 varchar2(60):=hr_api.g_varchar2;
1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;

Line 1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;

1098: l_pgp_segment7 varchar2(60):=hr_api.g_varchar2;
1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;

Line 1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;

1099: l_pgp_segment8 varchar2(60):=hr_api.g_varchar2;
1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;

Line 1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;

1100: l_pgp_segment9 varchar2(60):=hr_api.g_varchar2;
1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;

Line 1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;

1101: l_pgp_segment10 varchar2(60):=hr_api.g_varchar2;
1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;

Line 1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;

1102: l_pgp_segment11 varchar2(60):=hr_api.g_varchar2;
1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;

Line 1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;

1103: l_pgp_segment12 varchar2(60):=hr_api.g_varchar2;
1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;

Line 1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;

1104: l_pgp_segment13 varchar2(60):=hr_api.g_varchar2;
1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;

Line 1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;

1105: l_pgp_segment14 varchar2(60):=hr_api.g_varchar2;
1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;

Line 1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;

1106: l_pgp_segment15 varchar2(60):=hr_api.g_varchar2;
1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;

Line 1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;

1107: l_pgp_segment16 varchar2(60):=hr_api.g_varchar2;
1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;

Line 1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;

1108: l_pgp_segment17 varchar2(60):=hr_api.g_varchar2;
1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;

Line 1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;

1109: l_pgp_segment18 varchar2(60):=hr_api.g_varchar2;
1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;

Line 1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;

1110: l_pgp_segment19 varchar2(60):=hr_api.g_varchar2;
1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;

Line 1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;

1111: l_pgp_segment20 varchar2(60):=hr_api.g_varchar2;
1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;

Line 1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;

1112: l_pgp_segment21 varchar2(60):=hr_api.g_varchar2;
1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;

Line 1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;

1113: l_pgp_segment22 varchar2(60):=hr_api.g_varchar2;
1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;
1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;

Line 1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;

1114: l_pgp_segment23 varchar2(60):=hr_api.g_varchar2;
1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;
1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;
1122:

Line 1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;

1115: l_pgp_segment24 varchar2(60):=hr_api.g_varchar2;
1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;
1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;
1122:
1123: cursor c_pgp_segments (cur_p_people_group_id number) is

Line 1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;

1116: l_pgp_segment25 varchar2(60):=hr_api.g_varchar2;
1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;
1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;
1122:
1123: cursor c_pgp_segments (cur_p_people_group_id number) is
1124: select segment1,

Line 1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;

1117: l_pgp_segment26 varchar2(60):=hr_api.g_varchar2;
1118: l_pgp_segment27 varchar2(60):=hr_api.g_varchar2;
1119: l_pgp_segment28 varchar2(60):=hr_api.g_varchar2;
1120: l_pgp_segment29 varchar2(60):=hr_api.g_varchar2;
1121: l_pgp_segment30 varchar2(60):=hr_api.g_varchar2;
1122:
1123: cursor c_pgp_segments (cur_p_people_group_id number) is
1124: select segment1,
1125: segment2,

Line 1448: elsif ((l_reports.effective_end_date <> hr_api.g_eot)and

1444: --Check for the update mode
1445: if l_dpl_rec.start_date=l_reports.effective_start_date then
1446: l_datetrack_update_mode:='CORRECTION';
1447:
1448: elsif ((l_reports.effective_end_date <> hr_api.g_eot)and
1449: (l_reports.effective_end_date >l_dpl_rec.start_date) ) then
1450: l_datetrack_update_mode:='UPDATE_CHANGE_INSERT';
1451:
1452: elsif (l_reports.effective_end_date= hr_api.g_eot) then

Line 1452: elsif (l_reports.effective_end_date= hr_api.g_eot) then

1448: elsif ((l_reports.effective_end_date <> hr_api.g_eot)and
1449: (l_reports.effective_end_date >l_dpl_rec.start_date) ) then
1450: l_datetrack_update_mode:='UPDATE_CHANGE_INSERT';
1451:
1452: elsif (l_reports.effective_end_date= hr_api.g_eot) then
1453: l_datetrack_update_mode:='UPDATE';
1454:
1455: end if;
1456:

Line 1555: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)

1551: ,p_assignment_number => l_host_asg_number
1552: ,p_change_reason => l_dpl_rec.ass_status_change_reason
1553: -- ,p_assignment_status_type_id => l_dpl_rec.assignment_status_type_id
1554: ,p_assignment_status_type_id =>
1555: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1556: ,p_comments => null
1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2

Line 1557: ,p_date_probation_end => hr_api.g_date

1553: -- ,p_assignment_status_type_id => l_dpl_rec.assignment_status_type_id
1554: ,p_assignment_status_type_id =>
1555: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1556: ,p_comments => null
1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2

Line 1558: ,p_default_code_comb_id => hr_api.g_number

1554: ,p_assignment_status_type_id =>
1555: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1556: ,p_comments => null
1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number

Line 1559: ,p_frequency => hr_api.g_varchar2

1555: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1556: ,p_comments => null
1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number

Line 1560: ,p_internal_address_line => hr_api.g_varchar2

1556: ,p_comments => null
1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2

Line 1561: ,p_manager_flag => hr_api.g_varchar2

1557: ,p_date_probation_end => hr_api.g_date
1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date

Line 1562: ,p_normal_hours => hr_api.g_number

1558: ,p_default_code_comb_id => hr_api.g_number
1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number

Line 1563: ,p_perf_review_period => hr_api.g_number

1559: ,p_frequency => hr_api.g_varchar2
1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2

Line 1564: ,p_perf_review_period_frequency => hr_api.g_varchar2

1560: ,p_internal_address_line => hr_api.g_varchar2
1561: ,p_manager_flag => hr_api.g_varchar2
1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number

Line 1566: ,p_probation_period => hr_api.g_number

1562: ,p_normal_hours => hr_api.g_number
1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number

Line 1567: ,p_probation_unit => hr_api.g_varchar2

1563: ,p_perf_review_period => hr_api.g_number
1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2

Line 1568: ,p_sal_review_period => hr_api.g_number

1564: ,p_perf_review_period_frequency => hr_api.g_varchar2
1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2

Line 1569: ,p_sal_review_period_frequency => hr_api.g_varchar2

1565: ,p_projected_assignment_end => l_dpl_rec.end_date
1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2

Line 1570: ,p_set_of_books_id => hr_api.g_number

1566: ,p_probation_period => hr_api.g_number
1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2

Line 1571: ,p_source_type => hr_api.g_varchar2

1567: ,p_probation_unit => hr_api.g_varchar2
1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2

Line 1572: ,p_time_normal_finish => hr_api.g_varchar2

1568: ,p_sal_review_period => hr_api.g_number
1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2

Line 1573: ,p_time_normal_start => hr_api.g_varchar2

1569: ,p_sal_review_period_frequency => hr_api.g_varchar2
1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2

Line 1574: ,p_bargaining_unit_code => hr_api.g_varchar2

1570: ,p_set_of_books_id => hr_api.g_number
1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2

Line 1575: ,p_labour_union_member_flag => hr_api.g_varchar2

1571: ,p_source_type => hr_api.g_varchar2
1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2

Line 1576: ,p_hourly_salaried_code => hr_api.g_varchar2

1572: ,p_time_normal_finish => hr_api.g_varchar2
1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2

Line 1577: ,p_ass_attribute_category => hr_api.g_varchar2

1573: ,p_time_normal_start => hr_api.g_varchar2
1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2

Line 1578: ,p_ass_attribute1 => hr_api.g_varchar2

1574: ,p_bargaining_unit_code => hr_api.g_varchar2
1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2

Line 1579: ,p_ass_attribute2 => hr_api.g_varchar2

1575: ,p_labour_union_member_flag => hr_api.g_varchar2
1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2

Line 1580: ,p_ass_attribute3 => hr_api.g_varchar2

1576: ,p_hourly_salaried_code => hr_api.g_varchar2
1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2

Line 1581: ,p_ass_attribute4 => hr_api.g_varchar2

1577: ,p_ass_attribute_category => hr_api.g_varchar2
1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2

Line 1582: ,p_ass_attribute5 => hr_api.g_varchar2

1578: ,p_ass_attribute1 => hr_api.g_varchar2
1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2

Line 1583: ,p_ass_attribute6 => hr_api.g_varchar2

1579: ,p_ass_attribute2 => hr_api.g_varchar2
1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2

Line 1584: ,p_ass_attribute7 => hr_api.g_varchar2

1580: ,p_ass_attribute3 => hr_api.g_varchar2
1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2

Line 1585: ,p_ass_attribute8 => hr_api.g_varchar2

1581: ,p_ass_attribute4 => hr_api.g_varchar2
1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2

Line 1586: ,p_ass_attribute9 => hr_api.g_varchar2

1582: ,p_ass_attribute5 => hr_api.g_varchar2
1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2

Line 1587: ,p_ass_attribute10 => hr_api.g_varchar2

1583: ,p_ass_attribute6 => hr_api.g_varchar2
1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2

Line 1588: ,p_ass_attribute11 => hr_api.g_varchar2

1584: ,p_ass_attribute7 => hr_api.g_varchar2
1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2

Line 1589: ,p_ass_attribute12 => hr_api.g_varchar2

1585: ,p_ass_attribute8 => hr_api.g_varchar2
1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2

Line 1590: ,p_ass_attribute13 => hr_api.g_varchar2

1586: ,p_ass_attribute9 => hr_api.g_varchar2
1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2

Line 1591: ,p_ass_attribute14 => hr_api.g_varchar2

1587: ,p_ass_attribute10 => hr_api.g_varchar2
1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2

Line 1592: ,p_ass_attribute15 => hr_api.g_varchar2

1588: ,p_ass_attribute11 => hr_api.g_varchar2
1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2

Line 1593: ,p_ass_attribute16 => hr_api.g_varchar2

1589: ,p_ass_attribute12 => hr_api.g_varchar2
1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2

Line 1594: ,p_ass_attribute17 => hr_api.g_varchar2

1590: ,p_ass_attribute13 => hr_api.g_varchar2
1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2

Line 1595: ,p_ass_attribute18 => hr_api.g_varchar2

1591: ,p_ass_attribute14 => hr_api.g_varchar2
1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2

Line 1596: ,p_ass_attribute19 => hr_api.g_varchar2

1592: ,p_ass_attribute15 => hr_api.g_varchar2
1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2

Line 1597: ,p_ass_attribute20 => hr_api.g_varchar2

1593: ,p_ass_attribute16 => hr_api.g_varchar2
1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2

Line 1598: ,p_ass_attribute21 => hr_api.g_varchar2

1594: ,p_ass_attribute17 => hr_api.g_varchar2
1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2

Line 1599: ,p_ass_attribute22 => hr_api.g_varchar2

1595: ,p_ass_attribute18 => hr_api.g_varchar2
1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2

Line 1600: ,p_ass_attribute23 => hr_api.g_varchar2

1596: ,p_ass_attribute19 => hr_api.g_varchar2
1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2

Line 1601: ,p_ass_attribute24 => hr_api.g_varchar2

1597: ,p_ass_attribute20 => hr_api.g_varchar2
1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2

Line 1602: ,p_ass_attribute25 => hr_api.g_varchar2

1598: ,p_ass_attribute21 => hr_api.g_varchar2
1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2

Line 1603: ,p_ass_attribute26 => hr_api.g_varchar2

1599: ,p_ass_attribute22 => hr_api.g_varchar2
1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2

Line 1604: ,p_ass_attribute27 => hr_api.g_varchar2

1600: ,p_ass_attribute23 => hr_api.g_varchar2
1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2

Line 1605: ,p_ass_attribute28 => hr_api.g_varchar2

1601: ,p_ass_attribute24 => hr_api.g_varchar2
1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2

Line 1606: ,p_ass_attribute29 => hr_api.g_varchar2

1602: ,p_ass_attribute25 => hr_api.g_varchar2
1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2

Line 1607: ,p_ass_attribute30 => hr_api.g_varchar2

1603: ,p_ass_attribute26 => hr_api.g_varchar2
1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2

Line 1608: ,p_title => hr_api.g_varchar2

1604: ,p_ass_attribute27 => hr_api.g_varchar2
1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2

Line 1609: ,p_segment1 => hr_api.g_varchar2

1605: ,p_ass_attribute28 => hr_api.g_varchar2
1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2

Line 1610: ,p_segment2 => hr_api.g_varchar2

1606: ,p_ass_attribute29 => hr_api.g_varchar2
1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2

Line 1611: ,p_segment3 => hr_api.g_varchar2

1607: ,p_ass_attribute30 => hr_api.g_varchar2
1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2

Line 1612: ,p_segment4 => hr_api.g_varchar2

1608: ,p_title => hr_api.g_varchar2
1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2

Line 1613: ,p_segment5 => hr_api.g_varchar2

1609: ,p_segment1 => hr_api.g_varchar2
1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2

Line 1614: ,p_segment6 => hr_api.g_varchar2

1610: ,p_segment2 => hr_api.g_varchar2
1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2

Line 1615: ,p_segment7 => hr_api.g_varchar2

1611: ,p_segment3 => hr_api.g_varchar2
1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2

Line 1616: ,p_segment8 => hr_api.g_varchar2

1612: ,p_segment4 => hr_api.g_varchar2
1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2

Line 1617: ,p_segment9 => hr_api.g_varchar2

1613: ,p_segment5 => hr_api.g_varchar2
1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2

Line 1618: ,p_segment10 => hr_api.g_varchar2

1614: ,p_segment6 => hr_api.g_varchar2
1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2

Line 1619: ,p_segment11 => hr_api.g_varchar2

1615: ,p_segment7 => hr_api.g_varchar2
1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2

Line 1620: ,p_segment12 => hr_api.g_varchar2

1616: ,p_segment8 => hr_api.g_varchar2
1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2

Line 1621: ,p_segment13 => hr_api.g_varchar2

1617: ,p_segment9 => hr_api.g_varchar2
1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2

Line 1622: ,p_segment14 => hr_api.g_varchar2

1618: ,p_segment10 => hr_api.g_varchar2
1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2

Line 1623: ,p_segment15 => hr_api.g_varchar2

1619: ,p_segment11 => hr_api.g_varchar2
1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2

Line 1624: ,p_segment16 => hr_api.g_varchar2

1620: ,p_segment12 => hr_api.g_varchar2
1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2

Line 1625: ,p_segment17 => hr_api.g_varchar2

1621: ,p_segment13 => hr_api.g_varchar2
1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2

Line 1626: ,p_segment18 => hr_api.g_varchar2

1622: ,p_segment14 => hr_api.g_varchar2
1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2

Line 1627: ,p_segment19 => hr_api.g_varchar2

1623: ,p_segment15 => hr_api.g_varchar2
1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2

Line 1628: ,p_segment20 => hr_api.g_varchar2

1624: ,p_segment16 => hr_api.g_varchar2
1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2

Line 1629: ,p_segment21 => hr_api.g_varchar2

1625: ,p_segment17 => hr_api.g_varchar2
1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2

Line 1630: ,p_segment22 => hr_api.g_varchar2

1626: ,p_segment18 => hr_api.g_varchar2
1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2

Line 1631: ,p_segment23 => hr_api.g_varchar2

1627: ,p_segment19 => hr_api.g_varchar2
1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2

Line 1632: ,p_segment24 => hr_api.g_varchar2

1628: ,p_segment20 => hr_api.g_varchar2
1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2

Line 1633: ,p_segment25 => hr_api.g_varchar2

1629: ,p_segment21 => hr_api.g_varchar2
1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2

Line 1634: ,p_segment26 => hr_api.g_varchar2

1630: ,p_segment22 => hr_api.g_varchar2
1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2

Line 1635: ,p_segment27 => hr_api.g_varchar2

1631: ,p_segment23 => hr_api.g_varchar2
1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2

Line 1636: ,p_segment28 => hr_api.g_varchar2

1632: ,p_segment24 => hr_api.g_varchar2
1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number

Line 1637: ,p_segment29 => hr_api.g_varchar2

1633: ,p_segment25 => hr_api.g_varchar2
1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number

Line 1638: ,p_segment30 => hr_api.g_varchar2

1634: ,p_segment26 => hr_api.g_varchar2
1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number

Line 1639: ,p_concat_segments => hr_api.g_varchar2

1635: ,p_segment27 => hr_api.g_varchar2
1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number

Line 1640: ,p_contract_id => hr_api.g_number

1636: ,p_segment28 => hr_api.g_varchar2
1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2

Line 1641: ,p_establishment_id => hr_api.g_number

1637: ,p_segment29 => hr_api.g_varchar2
1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2

Line 1642: ,p_collective_agreement_id => hr_api.g_number

1638: ,p_segment30 => hr_api.g_varchar2
1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2

Line 1643: ,p_cagr_id_flex_num => hr_api.g_number

1639: ,p_concat_segments => hr_api.g_varchar2
1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2

Line 1644: ,p_cag_segment1 => hr_api.g_varchar2

1640: ,p_contract_id => hr_api.g_number
1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2

Line 1645: ,p_cag_segment2 => hr_api.g_varchar2

1641: ,p_establishment_id => hr_api.g_number
1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2

Line 1646: ,p_cag_segment3 => hr_api.g_varchar2

1642: ,p_collective_agreement_id => hr_api.g_number
1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2

Line 1647: ,p_cag_segment4 => hr_api.g_varchar2

1643: ,p_cagr_id_flex_num => hr_api.g_number
1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2

Line 1648: ,p_cag_segment5 => hr_api.g_varchar2

1644: ,p_cag_segment1 => hr_api.g_varchar2
1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2

Line 1649: ,p_cag_segment6 => hr_api.g_varchar2

1645: ,p_cag_segment2 => hr_api.g_varchar2
1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2

Line 1650: ,p_cag_segment7 => hr_api.g_varchar2

1646: ,p_cag_segment3 => hr_api.g_varchar2
1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2

Line 1651: ,p_cag_segment8 => hr_api.g_varchar2

1647: ,p_cag_segment4 => hr_api.g_varchar2
1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2

Line 1652: ,p_cag_segment9 => hr_api.g_varchar2

1648: ,p_cag_segment5 => hr_api.g_varchar2
1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2

Line 1653: ,p_cag_segment10 => hr_api.g_varchar2

1649: ,p_cag_segment6 => hr_api.g_varchar2
1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2

Line 1654: ,p_cag_segment11 => hr_api.g_varchar2

1650: ,p_cag_segment7 => hr_api.g_varchar2
1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2

Line 1655: ,p_cag_segment12 => hr_api.g_varchar2

1651: ,p_cag_segment8 => hr_api.g_varchar2
1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2

Line 1656: ,p_cag_segment13 => hr_api.g_varchar2

1652: ,p_cag_segment9 => hr_api.g_varchar2
1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2

Line 1657: ,p_cag_segment14 => hr_api.g_varchar2

1653: ,p_cag_segment10 => hr_api.g_varchar2
1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2

Line 1658: ,p_cag_segment15 => hr_api.g_varchar2

1654: ,p_cag_segment11 => hr_api.g_varchar2
1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2

Line 1659: ,p_cag_segment16 => hr_api.g_varchar2

1655: ,p_cag_segment12 => hr_api.g_varchar2
1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2

Line 1660: ,p_cag_segment17 => hr_api.g_varchar2

1656: ,p_cag_segment13 => hr_api.g_varchar2
1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number

Line 1661: ,p_cag_segment18 => hr_api.g_varchar2

1657: ,p_cag_segment14 => hr_api.g_varchar2
1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2

Line 1662: ,p_cag_segment19 => hr_api.g_varchar2

1658: ,p_cag_segment15 => hr_api.g_varchar2
1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2

Line 1663: ,p_cag_segment20 => hr_api.g_varchar2

1659: ,p_cag_segment16 => hr_api.g_varchar2
1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2

Line 1664: ,p_notice_period => hr_api.g_number

1660: ,p_cag_segment17 => hr_api.g_varchar2
1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2
1668: ,p_job_post_source_name => hr_api.g_varchar2

Line 1665: ,p_notice_period_uom => hr_api.g_varchar2

1661: ,p_cag_segment18 => hr_api.g_varchar2
1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2
1668: ,p_job_post_source_name => hr_api.g_varchar2
1669: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id

Line 1666: ,p_employee_category => hr_api.g_varchar2

1662: ,p_cag_segment19 => hr_api.g_varchar2
1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2
1668: ,p_job_post_source_name => hr_api.g_varchar2
1669: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1670: ,p_cagr_grade_def_id => l_cagr_grade_def_id

Line 1667: ,p_work_at_home => hr_api.g_varchar2

1663: ,p_cag_segment20 => hr_api.g_varchar2
1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2
1668: ,p_job_post_source_name => hr_api.g_varchar2
1669: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1670: ,p_cagr_grade_def_id => l_cagr_grade_def_id
1671: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments

Line 1668: ,p_job_post_source_name => hr_api.g_varchar2

1664: ,p_notice_period => hr_api.g_number
1665: ,p_notice_period_uom => hr_api.g_varchar2
1666: ,p_employee_category => hr_api.g_varchar2
1667: ,p_work_at_home => hr_api.g_varchar2
1668: ,p_job_post_source_name => hr_api.g_varchar2
1669: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1670: ,p_cagr_grade_def_id => l_cagr_grade_def_id
1671: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
1672: ,p_concatenated_segments => l_concatenated_segments

Line 1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2

1738: ,p_payroll_id => l_dpl_rec.payroll_id
1739: ,p_location_id => l_dpl_rec.location_id
1740: ,p_organization_id => l_dpl_rec.organization_id
1741: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2

Line 1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2

1739: ,p_location_id => l_dpl_rec.location_id
1740: ,p_organization_id => l_dpl_rec.organization_id
1741: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2

Line 1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2

1740: ,p_organization_id => l_dpl_rec.organization_id
1741: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2

Line 1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2

1741: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2

Line 1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2

1742: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2

Line 1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2

1743: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2

Line 1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2

1744: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2

Line 1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2

1745: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2

Line 1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2

1746: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2

Line 1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2

1747: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2

Line 1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2

1748: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2

Line 1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2

1749: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2

Line 1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2

1750: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2

Line 1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2

1751: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2

Line 1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2

1752: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2

Line 1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2

1753: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2

Line 1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2

1754: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2

Line 1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2

1755: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2

Line 1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2

1756: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2

Line 1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2

1757: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2

Line 1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2

1758: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2

Line 1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2

1759: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2

Line 1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2

1760: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2

Line 1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2

1761: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2

Line 1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2

1762: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2

Line 1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2

1763: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2

Line 1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2

1764: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category

Line 1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2

1765: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2

Line 1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2

1766: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number

Line 1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2

1767: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1768: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number

Line 1773: ,p_concat_segments => hr_api.g_varchar2

1769: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number
1776: ,p_scl_segment1 => hr_api.g_varchar2
1777: ,p_grade_ladder_pgm_id => hr_api.g_number

Line 1774: ,p_contract_id => hr_api.g_number

1770: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number
1776: ,p_scl_segment1 => hr_api.g_varchar2
1777: ,p_grade_ladder_pgm_id => hr_api.g_number
1778: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id

Line 1775: ,p_establishment_id => hr_api.g_number

1771: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number
1776: ,p_scl_segment1 => hr_api.g_varchar2
1777: ,p_grade_ladder_pgm_id => hr_api.g_number
1778: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1779: ,p_object_version_number => l_host_asg_ovn

Line 1776: ,p_scl_segment1 => hr_api.g_varchar2

1772: ,p_employment_category => l_dpl_rec.assignment_category
1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number
1776: ,p_scl_segment1 => hr_api.g_varchar2
1777: ,p_grade_ladder_pgm_id => hr_api.g_number
1778: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1779: ,p_object_version_number => l_host_asg_ovn
1780: ,p_special_ceiling_step_id => l_special_ceiling_step_id

Line 1777: ,p_grade_ladder_pgm_id => hr_api.g_number

1773: ,p_concat_segments => hr_api.g_varchar2
1774: ,p_contract_id => hr_api.g_number
1775: ,p_establishment_id => hr_api.g_number
1776: ,p_scl_segment1 => hr_api.g_varchar2
1777: ,p_grade_ladder_pgm_id => hr_api.g_number
1778: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1779: ,p_object_version_number => l_host_asg_ovn
1780: ,p_special_ceiling_step_id => l_special_ceiling_step_id
1781: ,p_people_group_id => l_group_id --l_dpl_rec.people_group_id -- sturlapa

Line 2040: raise hr_api.validate_enabled;

2036: --
2037: -- When in validation only mode raise the Validate_Enabled exception
2038: --
2039: if p_validate then
2040: raise hr_api.validate_enabled;
2041: end if;
2042: --
2043: -- Set all IN OUT and OUT parameters with out values
2044: --

Line 2075: when hr_api.validate_enabled then

2071: per_per_bus.g_global_transfer_in_process := false;
2072: --
2073: hr_utility.set_location(' Leaving:'||l_proc, 700);
2074: exception
2075: when hr_api.validate_enabled then
2076: --
2077: -- As the Validate_Enabled exception has been raised
2078: -- we must rollback to the savepoint
2079: --

Line 2133: ,p_start_date in date default hr_api.g_date

2129: procedure change_deployment_dates
2130: (p_validate in boolean default false
2131: ,p_person_deployment_id in number
2132: ,p_object_version_number in out nocopy number
2133: ,p_start_date in date default hr_api.g_date
2134: ,p_end_date in date default hr_api.g_date
2135: ,p_deplymt_policy_id in number default hr_api.g_number
2136: ) is
2137: --

Line 2134: ,p_end_date in date default hr_api.g_date

2130: (p_validate in boolean default false
2131: ,p_person_deployment_id in number
2132: ,p_object_version_number in out nocopy number
2133: ,p_start_date in date default hr_api.g_date
2134: ,p_end_date in date default hr_api.g_date
2135: ,p_deplymt_policy_id in number default hr_api.g_number
2136: ) is
2137: --
2138: -- Declare cursors and local variables

Line 2135: ,p_deplymt_policy_id in number default hr_api.g_number

2131: ,p_person_deployment_id in number
2132: ,p_object_version_number in out nocopy number
2133: ,p_start_date in date default hr_api.g_date
2134: ,p_end_date in date default hr_api.g_date
2135: ,p_deplymt_policy_id in number default hr_api.g_number
2136: ) is
2137: --
2138: -- Declare cursors and local variables
2139: --

Line 2269: if ((nvl(l_start_date_in,hr_api.g_date) <> hr_api.g_date)

2265: end if;
2266: --
2267: -- Process Logic
2268: --
2269: if ((nvl(l_start_date_in,hr_api.g_date) <> hr_api.g_date)
2270: OR (l_end_date_in is null and l_dpl_rec.end_date is not null)
2271: OR (l_end_date_in <> hr_api.g_date)) then
2272: --
2273: -- At least one date has changed, proceed according to which one changed

Line 2271: OR (l_end_date_in <> hr_api.g_date)) then

2267: -- Process Logic
2268: --
2269: if ((nvl(l_start_date_in,hr_api.g_date) <> hr_api.g_date)
2270: OR (l_end_date_in is null and l_dpl_rec.end_date is not null)
2271: OR (l_end_date_in <> hr_api.g_date)) then
2272: --
2273: -- At least one date has changed, proceed according to which one changed
2274: --
2275:

Line 2276: if nvl(l_start_date_in,hr_api.g_date) = hr_api.g_date then

2272: --
2273: -- At least one date has changed, proceed according to which one changed
2274: --
2275:
2276: if nvl(l_start_date_in,hr_api.g_date) = hr_api.g_date then
2277: --
2278: hr_utility.set_location(l_proc,50);
2279: --
2280: --start date the same

Line 2328: -- if l_end_date_in = hr_api.g_date then

2324: end loop;
2325: end if;
2326: --
2327: -- Bug 5635350 modified the following if condition
2328: -- if l_end_date_in = hr_api.g_date then
2329: if l_end_date_in = hr_api.g_date or l_end_date_in = l_dpl_rec.end_date then
2330: --
2331: hr_utility.set_location(l_proc,80);
2332: --

Line 2329: if l_end_date_in = hr_api.g_date or l_end_date_in = l_dpl_rec.end_date then

2325: end if;
2326: --
2327: -- Bug 5635350 modified the following if condition
2328: -- if l_end_date_in = hr_api.g_date then
2329: if l_end_date_in = hr_api.g_date or l_end_date_in = l_dpl_rec.end_date then
2330: --
2331: hr_utility.set_location(l_proc,80);
2332: --
2333: --end date the same

Line 2417: raise hr_api.validate_enabled;

2413: --
2414: -- When in validation only mode raise the Validate_Enabled exception
2415: --
2416: if p_validate then
2417: raise hr_api.validate_enabled;
2418: end if;
2419: --
2420: -- Set all IN OUT and OUT parameters with out values
2421: --

Line 2426: when hr_api.validate_enabled then

2422:
2423: --
2424: hr_utility.set_location(' Leaving:'||l_proc, 700);
2425: exception
2426: when hr_api.validate_enabled then
2427: --
2428: -- As the Validate_Enabled exception has been raised
2429: -- we must rollback to the savepoint
2430: --

Line 2464: ,p_end_date in date default hr_api.g_date

2460: procedure return_from_deployment
2461: (p_validate in boolean default false
2462: ,p_person_deployment_id in number
2463: ,p_object_version_number in out nocopy number
2464: ,p_end_date in date default hr_api.g_date
2465: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2466: ,p_leaving_person_type_id in number default hr_api.g_number
2467: ) is
2468: --

Line 2465: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

2461: (p_validate in boolean default false
2462: ,p_person_deployment_id in number
2463: ,p_object_version_number in out nocopy number
2464: ,p_end_date in date default hr_api.g_date
2465: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2466: ,p_leaving_person_type_id in number default hr_api.g_number
2467: ) is
2468: --
2469: -- Declare cursors and local variables

Line 2466: ,p_leaving_person_type_id in number default hr_api.g_number

2462: ,p_person_deployment_id in number
2463: ,p_object_version_number in out nocopy number
2464: ,p_end_date in date default hr_api.g_date
2465: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2466: ,p_leaving_person_type_id in number default hr_api.g_number
2467: ) is
2468: --
2469: -- Declare cursors and local variables
2470: --

Line 2592: if nvl(l_end_date_in,hr_api.g_date) = hr_api.g_date then

2588: --
2589: l_leaving_reason := p_leaving_reason;
2590: l_leaving_person_type_id := p_leaving_person_type_id;
2591: --
2592: if nvl(l_end_date_in,hr_api.g_date) = hr_api.g_date then
2593: hr_utility.set_location(l_proc,30);
2594: l_end_date_in := l_dpl_rec.end_date;
2595: end if;
2596: --

Line 2597: if nvl(l_leaving_reason,hr_api.g_varchar2) = hr_api.g_varchar2 then

2593: hr_utility.set_location(l_proc,30);
2594: l_end_date_in := l_dpl_rec.end_date;
2595: end if;
2596: --
2597: if nvl(l_leaving_reason,hr_api.g_varchar2) = hr_api.g_varchar2 then
2598: hr_utility.set_location(l_proc,40);
2599: l_leaving_reason := l_dpl_rec.leaving_reason;
2600: end if;
2601: --

Line 2602: if nvl(l_leaving_person_type_id,hr_api.g_number) = hr_api.g_number then

2598: hr_utility.set_location(l_proc,40);
2599: l_leaving_reason := l_dpl_rec.leaving_reason;
2600: end if;
2601: --
2602: if nvl(l_leaving_person_type_id,hr_api.g_number) = hr_api.g_number then
2603: hr_utility.set_location(l_proc,50);
2604: l_leaving_person_type_id := l_dpl_rec.leaving_person_type_id;
2605: end if;
2606:

Line 2680: raise hr_api.validate_enabled;

2676: --
2677: -- When in validation only mode raise the Validate_Enabled exception
2678: --
2679: if p_validate then
2680: raise hr_api.validate_enabled;
2681: end if;
2682: --
2683: -- Set all IN OUT and OUT parameters with out values
2684: --

Line 2687: when hr_api.validate_enabled then

2683: -- Set all IN OUT and OUT parameters with out values
2684: --
2685: hr_utility.set_location(' Leaving:'||l_proc, 700);
2686: exception
2687: when hr_api.validate_enabled then
2688: --
2689: -- As the Validate_Enabled exception has been raised
2690: -- we must rollback to the savepoint
2691: --