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 992: and pdt1.start_date <= nvl(pdt2.end_date,hr_api.g_eot));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1450: --Check for the update mode
1451: if l_dpl_rec.start_date=l_reports.effective_start_date then
1452: l_datetrack_update_mode:='CORRECTION';
1453:
1454: elsif ((l_reports.effective_end_date <> hr_api.g_eot)and
1455: (l_reports.effective_end_date >l_dpl_rec.start_date) ) then
1456: --l_datetrack_update_mode:='UPDATE_CHANGE_INSERT'; /*Commented for bug#16461888*/
1457:
1458: /*Start of code for bug#16461888*/

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

1473: end if;
1474:
1475: /*End of code for bug#16461888*/
1476:
1477: elsif (l_reports.effective_end_date= hr_api.g_eot) then
1478: l_datetrack_update_mode:='UPDATE';
1479:
1480: end if;
1481:

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

1576: ,p_assignment_number => l_host_asg_number
1577: ,p_change_reason => l_dpl_rec.ass_status_change_reason
1578: -- ,p_assignment_status_type_id => l_dpl_rec.assignment_status_type_id
1579: ,p_assignment_status_type_id =>
1580: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1581: ,p_comments => null
1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2

Line 1582: ,p_date_probation_end => hr_api.g_date

1578: -- ,p_assignment_status_type_id => l_dpl_rec.assignment_status_type_id
1579: ,p_assignment_status_type_id =>
1580: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1581: ,p_comments => null
1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2

Line 1583: ,p_default_code_comb_id => hr_api.g_number

1579: ,p_assignment_status_type_id =>
1580: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1581: ,p_comments => null
1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number

Line 1584: ,p_frequency => hr_api.g_varchar2

1580: nvl(l_dpl_rec.assignment_status_type_id,hr_api.g_number)
1581: ,p_comments => null
1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number

Line 1585: ,p_internal_address_line => hr_api.g_varchar2

1581: ,p_comments => null
1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2

Line 1586: ,p_manager_flag => hr_api.g_varchar2

1582: ,p_date_probation_end => hr_api.g_date
1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date

Line 1587: ,p_normal_hours => hr_api.g_number

1583: ,p_default_code_comb_id => hr_api.g_number
1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number

Line 1588: ,p_perf_review_period => hr_api.g_number

1584: ,p_frequency => hr_api.g_varchar2
1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2

Line 1589: ,p_perf_review_period_frequency => hr_api.g_varchar2

1585: ,p_internal_address_line => hr_api.g_varchar2
1586: ,p_manager_flag => hr_api.g_varchar2
1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number

Line 1591: ,p_probation_period => hr_api.g_number

1587: ,p_normal_hours => hr_api.g_number
1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number

Line 1592: ,p_probation_unit => hr_api.g_varchar2

1588: ,p_perf_review_period => hr_api.g_number
1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2

Line 1593: ,p_sal_review_period => hr_api.g_number

1589: ,p_perf_review_period_frequency => hr_api.g_varchar2
1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2

Line 1594: ,p_sal_review_period_frequency => hr_api.g_varchar2

1590: ,p_projected_assignment_end => l_dpl_rec.end_date
1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2

Line 1595: ,p_set_of_books_id => hr_api.g_number

1591: ,p_probation_period => hr_api.g_number
1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2

Line 1596: ,p_source_type => hr_api.g_varchar2

1592: ,p_probation_unit => hr_api.g_varchar2
1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2

Line 1597: ,p_time_normal_finish => hr_api.g_varchar2

1593: ,p_sal_review_period => hr_api.g_number
1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2

Line 1598: ,p_time_normal_start => hr_api.g_varchar2

1594: ,p_sal_review_period_frequency => hr_api.g_varchar2
1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2

Line 1599: ,p_bargaining_unit_code => hr_api.g_varchar2

1595: ,p_set_of_books_id => hr_api.g_number
1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2

Line 1600: ,p_labour_union_member_flag => hr_api.g_varchar2

1596: ,p_source_type => hr_api.g_varchar2
1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2

Line 1601: ,p_hourly_salaried_code => hr_api.g_varchar2

1597: ,p_time_normal_finish => hr_api.g_varchar2
1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2

Line 1602: ,p_ass_attribute_category => hr_api.g_varchar2

1598: ,p_time_normal_start => hr_api.g_varchar2
1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2

Line 1603: ,p_ass_attribute1 => hr_api.g_varchar2

1599: ,p_bargaining_unit_code => hr_api.g_varchar2
1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2

Line 1604: ,p_ass_attribute2 => hr_api.g_varchar2

1600: ,p_labour_union_member_flag => hr_api.g_varchar2
1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2

Line 1605: ,p_ass_attribute3 => hr_api.g_varchar2

1601: ,p_hourly_salaried_code => hr_api.g_varchar2
1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2

Line 1606: ,p_ass_attribute4 => hr_api.g_varchar2

1602: ,p_ass_attribute_category => hr_api.g_varchar2
1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2

Line 1607: ,p_ass_attribute5 => hr_api.g_varchar2

1603: ,p_ass_attribute1 => hr_api.g_varchar2
1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2

Line 1608: ,p_ass_attribute6 => hr_api.g_varchar2

1604: ,p_ass_attribute2 => hr_api.g_varchar2
1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2

Line 1609: ,p_ass_attribute7 => hr_api.g_varchar2

1605: ,p_ass_attribute3 => hr_api.g_varchar2
1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2

Line 1610: ,p_ass_attribute8 => hr_api.g_varchar2

1606: ,p_ass_attribute4 => hr_api.g_varchar2
1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2

Line 1611: ,p_ass_attribute9 => hr_api.g_varchar2

1607: ,p_ass_attribute5 => hr_api.g_varchar2
1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2

Line 1612: ,p_ass_attribute10 => hr_api.g_varchar2

1608: ,p_ass_attribute6 => hr_api.g_varchar2
1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2

Line 1613: ,p_ass_attribute11 => hr_api.g_varchar2

1609: ,p_ass_attribute7 => hr_api.g_varchar2
1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2

Line 1614: ,p_ass_attribute12 => hr_api.g_varchar2

1610: ,p_ass_attribute8 => hr_api.g_varchar2
1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2

Line 1615: ,p_ass_attribute13 => hr_api.g_varchar2

1611: ,p_ass_attribute9 => hr_api.g_varchar2
1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2

Line 1616: ,p_ass_attribute14 => hr_api.g_varchar2

1612: ,p_ass_attribute10 => hr_api.g_varchar2
1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2

Line 1617: ,p_ass_attribute15 => hr_api.g_varchar2

1613: ,p_ass_attribute11 => hr_api.g_varchar2
1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2

Line 1618: ,p_ass_attribute16 => hr_api.g_varchar2

1614: ,p_ass_attribute12 => hr_api.g_varchar2
1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2

Line 1619: ,p_ass_attribute17 => hr_api.g_varchar2

1615: ,p_ass_attribute13 => hr_api.g_varchar2
1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2

Line 1620: ,p_ass_attribute18 => hr_api.g_varchar2

1616: ,p_ass_attribute14 => hr_api.g_varchar2
1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2

Line 1621: ,p_ass_attribute19 => hr_api.g_varchar2

1617: ,p_ass_attribute15 => hr_api.g_varchar2
1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2

Line 1622: ,p_ass_attribute20 => hr_api.g_varchar2

1618: ,p_ass_attribute16 => hr_api.g_varchar2
1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2

Line 1623: ,p_ass_attribute21 => hr_api.g_varchar2

1619: ,p_ass_attribute17 => hr_api.g_varchar2
1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2

Line 1624: ,p_ass_attribute22 => hr_api.g_varchar2

1620: ,p_ass_attribute18 => hr_api.g_varchar2
1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2

Line 1625: ,p_ass_attribute23 => hr_api.g_varchar2

1621: ,p_ass_attribute19 => hr_api.g_varchar2
1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2

Line 1626: ,p_ass_attribute24 => hr_api.g_varchar2

1622: ,p_ass_attribute20 => hr_api.g_varchar2
1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2

Line 1627: ,p_ass_attribute25 => hr_api.g_varchar2

1623: ,p_ass_attribute21 => hr_api.g_varchar2
1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2

Line 1628: ,p_ass_attribute26 => hr_api.g_varchar2

1624: ,p_ass_attribute22 => hr_api.g_varchar2
1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2

Line 1629: ,p_ass_attribute27 => hr_api.g_varchar2

1625: ,p_ass_attribute23 => hr_api.g_varchar2
1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2

Line 1630: ,p_ass_attribute28 => hr_api.g_varchar2

1626: ,p_ass_attribute24 => hr_api.g_varchar2
1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2

Line 1631: ,p_ass_attribute29 => hr_api.g_varchar2

1627: ,p_ass_attribute25 => hr_api.g_varchar2
1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2

Line 1632: ,p_ass_attribute30 => hr_api.g_varchar2

1628: ,p_ass_attribute26 => hr_api.g_varchar2
1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2

Line 1633: ,p_title => hr_api.g_varchar2

1629: ,p_ass_attribute27 => hr_api.g_varchar2
1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2

Line 1634: ,p_segment1 => hr_api.g_varchar2

1630: ,p_ass_attribute28 => hr_api.g_varchar2
1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2

Line 1635: ,p_segment2 => hr_api.g_varchar2

1631: ,p_ass_attribute29 => hr_api.g_varchar2
1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2

Line 1636: ,p_segment3 => hr_api.g_varchar2

1632: ,p_ass_attribute30 => hr_api.g_varchar2
1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2

Line 1637: ,p_segment4 => hr_api.g_varchar2

1633: ,p_title => hr_api.g_varchar2
1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2

Line 1638: ,p_segment5 => hr_api.g_varchar2

1634: ,p_segment1 => hr_api.g_varchar2
1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2

Line 1639: ,p_segment6 => hr_api.g_varchar2

1635: ,p_segment2 => hr_api.g_varchar2
1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2

Line 1640: ,p_segment7 => hr_api.g_varchar2

1636: ,p_segment3 => hr_api.g_varchar2
1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2

Line 1641: ,p_segment8 => hr_api.g_varchar2

1637: ,p_segment4 => hr_api.g_varchar2
1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2

Line 1642: ,p_segment9 => hr_api.g_varchar2

1638: ,p_segment5 => hr_api.g_varchar2
1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2

Line 1643: ,p_segment10 => hr_api.g_varchar2

1639: ,p_segment6 => hr_api.g_varchar2
1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2

Line 1644: ,p_segment11 => hr_api.g_varchar2

1640: ,p_segment7 => hr_api.g_varchar2
1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2

Line 1645: ,p_segment12 => hr_api.g_varchar2

1641: ,p_segment8 => hr_api.g_varchar2
1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2

Line 1646: ,p_segment13 => hr_api.g_varchar2

1642: ,p_segment9 => hr_api.g_varchar2
1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2

Line 1647: ,p_segment14 => hr_api.g_varchar2

1643: ,p_segment10 => hr_api.g_varchar2
1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2

Line 1648: ,p_segment15 => hr_api.g_varchar2

1644: ,p_segment11 => hr_api.g_varchar2
1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2

Line 1649: ,p_segment16 => hr_api.g_varchar2

1645: ,p_segment12 => hr_api.g_varchar2
1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2

Line 1650: ,p_segment17 => hr_api.g_varchar2

1646: ,p_segment13 => hr_api.g_varchar2
1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2

Line 1651: ,p_segment18 => hr_api.g_varchar2

1647: ,p_segment14 => hr_api.g_varchar2
1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2

Line 1652: ,p_segment19 => hr_api.g_varchar2

1648: ,p_segment15 => hr_api.g_varchar2
1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2

Line 1653: ,p_segment20 => hr_api.g_varchar2

1649: ,p_segment16 => hr_api.g_varchar2
1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2

Line 1654: ,p_segment21 => hr_api.g_varchar2

1650: ,p_segment17 => hr_api.g_varchar2
1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2

Line 1655: ,p_segment22 => hr_api.g_varchar2

1651: ,p_segment18 => hr_api.g_varchar2
1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2

Line 1656: ,p_segment23 => hr_api.g_varchar2

1652: ,p_segment19 => hr_api.g_varchar2
1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2

Line 1657: ,p_segment24 => hr_api.g_varchar2

1653: ,p_segment20 => hr_api.g_varchar2
1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2

Line 1658: ,p_segment25 => hr_api.g_varchar2

1654: ,p_segment21 => hr_api.g_varchar2
1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2

Line 1659: ,p_segment26 => hr_api.g_varchar2

1655: ,p_segment22 => hr_api.g_varchar2
1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2

Line 1660: ,p_segment27 => hr_api.g_varchar2

1656: ,p_segment23 => hr_api.g_varchar2
1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2

Line 1661: ,p_segment28 => hr_api.g_varchar2

1657: ,p_segment24 => hr_api.g_varchar2
1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number

Line 1662: ,p_segment29 => hr_api.g_varchar2

1658: ,p_segment25 => hr_api.g_varchar2
1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number

Line 1663: ,p_segment30 => hr_api.g_varchar2

1659: ,p_segment26 => hr_api.g_varchar2
1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number

Line 1664: ,p_concat_segments => hr_api.g_varchar2

1660: ,p_segment27 => hr_api.g_varchar2
1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number

Line 1665: ,p_contract_id => hr_api.g_number

1661: ,p_segment28 => hr_api.g_varchar2
1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2

Line 1666: ,p_establishment_id => hr_api.g_number

1662: ,p_segment29 => hr_api.g_varchar2
1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2

Line 1667: ,p_collective_agreement_id => hr_api.g_number

1663: ,p_segment30 => hr_api.g_varchar2
1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2

Line 1668: ,p_cagr_id_flex_num => hr_api.g_number

1664: ,p_concat_segments => hr_api.g_varchar2
1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2

Line 1669: ,p_cag_segment1 => hr_api.g_varchar2

1665: ,p_contract_id => hr_api.g_number
1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2

Line 1670: ,p_cag_segment2 => hr_api.g_varchar2

1666: ,p_establishment_id => hr_api.g_number
1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2

Line 1671: ,p_cag_segment3 => hr_api.g_varchar2

1667: ,p_collective_agreement_id => hr_api.g_number
1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2

Line 1672: ,p_cag_segment4 => hr_api.g_varchar2

1668: ,p_cagr_id_flex_num => hr_api.g_number
1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2

Line 1673: ,p_cag_segment5 => hr_api.g_varchar2

1669: ,p_cag_segment1 => hr_api.g_varchar2
1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2

Line 1674: ,p_cag_segment6 => hr_api.g_varchar2

1670: ,p_cag_segment2 => hr_api.g_varchar2
1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2

Line 1675: ,p_cag_segment7 => hr_api.g_varchar2

1671: ,p_cag_segment3 => hr_api.g_varchar2
1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2

Line 1676: ,p_cag_segment8 => hr_api.g_varchar2

1672: ,p_cag_segment4 => hr_api.g_varchar2
1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2

Line 1677: ,p_cag_segment9 => hr_api.g_varchar2

1673: ,p_cag_segment5 => hr_api.g_varchar2
1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2

Line 1678: ,p_cag_segment10 => hr_api.g_varchar2

1674: ,p_cag_segment6 => hr_api.g_varchar2
1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2

Line 1679: ,p_cag_segment11 => hr_api.g_varchar2

1675: ,p_cag_segment7 => hr_api.g_varchar2
1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2

Line 1680: ,p_cag_segment12 => hr_api.g_varchar2

1676: ,p_cag_segment8 => hr_api.g_varchar2
1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2

Line 1681: ,p_cag_segment13 => hr_api.g_varchar2

1677: ,p_cag_segment9 => hr_api.g_varchar2
1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2

Line 1682: ,p_cag_segment14 => hr_api.g_varchar2

1678: ,p_cag_segment10 => hr_api.g_varchar2
1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2

Line 1683: ,p_cag_segment15 => hr_api.g_varchar2

1679: ,p_cag_segment11 => hr_api.g_varchar2
1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2

Line 1684: ,p_cag_segment16 => hr_api.g_varchar2

1680: ,p_cag_segment12 => hr_api.g_varchar2
1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2

Line 1685: ,p_cag_segment17 => hr_api.g_varchar2

1681: ,p_cag_segment13 => hr_api.g_varchar2
1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number

Line 1686: ,p_cag_segment18 => hr_api.g_varchar2

1682: ,p_cag_segment14 => hr_api.g_varchar2
1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2

Line 1687: ,p_cag_segment19 => hr_api.g_varchar2

1683: ,p_cag_segment15 => hr_api.g_varchar2
1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2

Line 1688: ,p_cag_segment20 => hr_api.g_varchar2

1684: ,p_cag_segment16 => hr_api.g_varchar2
1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2

Line 1689: ,p_notice_period => hr_api.g_number

1685: ,p_cag_segment17 => hr_api.g_varchar2
1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2
1693: ,p_job_post_source_name => hr_api.g_varchar2

Line 1690: ,p_notice_period_uom => hr_api.g_varchar2

1686: ,p_cag_segment18 => hr_api.g_varchar2
1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2
1693: ,p_job_post_source_name => hr_api.g_varchar2
1694: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id

Line 1691: ,p_employee_category => hr_api.g_varchar2

1687: ,p_cag_segment19 => hr_api.g_varchar2
1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2
1693: ,p_job_post_source_name => hr_api.g_varchar2
1694: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1695: ,p_cagr_grade_def_id => l_cagr_grade_def_id

Line 1692: ,p_work_at_home => hr_api.g_varchar2

1688: ,p_cag_segment20 => hr_api.g_varchar2
1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2
1693: ,p_job_post_source_name => hr_api.g_varchar2
1694: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1695: ,p_cagr_grade_def_id => l_cagr_grade_def_id
1696: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments

Line 1693: ,p_job_post_source_name => hr_api.g_varchar2

1689: ,p_notice_period => hr_api.g_number
1690: ,p_notice_period_uom => hr_api.g_varchar2
1691: ,p_employee_category => hr_api.g_varchar2
1692: ,p_work_at_home => hr_api.g_varchar2
1693: ,p_job_post_source_name => hr_api.g_varchar2
1694: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1695: ,p_cagr_grade_def_id => l_cagr_grade_def_id
1696: ,p_cagr_concatenated_segments => l_cagr_concatenated_segments
1697: ,p_concatenated_segments => l_concatenated_segments

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

1763: ,p_payroll_id => l_dpl_rec.payroll_id
1764: ,p_location_id => l_dpl_rec.location_id
1765: ,p_organization_id => l_dpl_rec.organization_id
1766: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1767: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2

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

1764: ,p_location_id => l_dpl_rec.location_id
1765: ,p_organization_id => l_dpl_rec.organization_id
1766: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1767: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2

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

1765: ,p_organization_id => l_dpl_rec.organization_id
1766: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1767: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2

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

1766: ,p_pay_basis_id => l_dpl_rec.pay_basis_id
1767: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2

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

1767: ,p_segment1 => l_pgp_segment1 --hr_api.g_varchar2
1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2

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

1768: ,p_segment2 => l_pgp_segment2 --hr_api.g_varchar2
1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2

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

1769: ,p_segment3 => l_pgp_segment3 --hr_api.g_varchar2
1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2

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

1770: ,p_segment4 => l_pgp_segment4 --hr_api.g_varchar2
1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2

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

1771: ,p_segment5 => l_pgp_segment5 --hr_api.g_varchar2
1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2

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

1772: ,p_segment6 => l_pgp_segment6 --hr_api.g_varchar2
1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2

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

1773: ,p_segment7 => l_pgp_segment7 --hr_api.g_varchar2
1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2

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

1774: ,p_segment8 => l_pgp_segment8 --hr_api.g_varchar2
1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2

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

1775: ,p_segment9 => l_pgp_segment9 --hr_api.g_varchar2
1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2

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

1776: ,p_segment10 => l_pgp_segment10 --hr_api.g_varchar2
1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2

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

1777: ,p_segment11 => l_pgp_segment11 --hr_api.g_varchar2
1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2

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

1778: ,p_segment12 => l_pgp_segment12 --hr_api.g_varchar2
1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2

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

1779: ,p_segment13 => l_pgp_segment13 --hr_api.g_varchar2
1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2

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

1780: ,p_segment14 => l_pgp_segment14 --hr_api.g_varchar2
1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2

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

1781: ,p_segment15 => l_pgp_segment15 --hr_api.g_varchar2
1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2

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

1782: ,p_segment16 => l_pgp_segment16 --hr_api.g_varchar2
1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2

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

1783: ,p_segment17 => l_pgp_segment17 --hr_api.g_varchar2
1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2

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

1784: ,p_segment18 => l_pgp_segment18 --hr_api.g_varchar2
1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2

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

1785: ,p_segment19 => l_pgp_segment19 --hr_api.g_varchar2
1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2

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

1786: ,p_segment20 => l_pgp_segment20 --hr_api.g_varchar2
1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2

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

1787: ,p_segment21 => l_pgp_segment21 --hr_api.g_varchar2
1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2

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

1788: ,p_segment22 => l_pgp_segment22 --hr_api.g_varchar2
1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2

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

1789: ,p_segment23 => l_pgp_segment23 --hr_api.g_varchar2
1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category

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

1790: ,p_segment24 => l_pgp_segment24 --hr_api.g_varchar2
1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2

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

1791: ,p_segment25 => l_pgp_segment25 --hr_api.g_varchar2
1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number

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

1792: ,p_segment26 => l_pgp_segment26 --hr_api.g_varchar2
1793: ,p_segment27 => l_pgp_segment27 --hr_api.g_varchar2
1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number

Line 1798: ,p_concat_segments => hr_api.g_varchar2

1794: ,p_segment28 => l_pgp_segment28 --hr_api.g_varchar2
1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number
1801: ,p_scl_segment1 => hr_api.g_varchar2
1802: ,p_grade_ladder_pgm_id => hr_api.g_number

Line 1799: ,p_contract_id => hr_api.g_number

1795: ,p_segment29 => l_pgp_segment29 --hr_api.g_varchar2
1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number
1801: ,p_scl_segment1 => hr_api.g_varchar2
1802: ,p_grade_ladder_pgm_id => hr_api.g_number
1803: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id

Line 1800: ,p_establishment_id => hr_api.g_number

1796: ,p_segment30 => l_pgp_segment30 --hr_api.g_varchar2
1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number
1801: ,p_scl_segment1 => hr_api.g_varchar2
1802: ,p_grade_ladder_pgm_id => hr_api.g_number
1803: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1804: ,p_object_version_number => l_host_asg_ovn

Line 1801: ,p_scl_segment1 => hr_api.g_varchar2

1797: ,p_employment_category => l_dpl_rec.assignment_category
1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number
1801: ,p_scl_segment1 => hr_api.g_varchar2
1802: ,p_grade_ladder_pgm_id => hr_api.g_number
1803: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1804: ,p_object_version_number => l_host_asg_ovn
1805: ,p_special_ceiling_step_id => l_special_ceiling_step_id

Line 1802: ,p_grade_ladder_pgm_id => hr_api.g_number

1798: ,p_concat_segments => hr_api.g_varchar2
1799: ,p_contract_id => hr_api.g_number
1800: ,p_establishment_id => hr_api.g_number
1801: ,p_scl_segment1 => hr_api.g_varchar2
1802: ,p_grade_ladder_pgm_id => hr_api.g_number
1803: ,p_supervisor_assignment_id => l_dpl_rec.supervisor_assignment_id
1804: ,p_object_version_number => l_host_asg_ovn
1805: ,p_special_ceiling_step_id => l_special_ceiling_step_id
1806: ,p_people_group_id => l_group_id --l_dpl_rec.people_group_id -- sturlapa

Line 2065: raise hr_api.validate_enabled;

2061: --
2062: -- When in validation only mode raise the Validate_Enabled exception
2063: --
2064: if p_validate then
2065: raise hr_api.validate_enabled;
2066: end if;
2067: --
2068: -- Set all IN OUT and OUT parameters with out values
2069: --

Line 2100: when hr_api.validate_enabled then

2096: per_per_bus.g_global_transfer_in_process := false;
2097: --
2098: hr_utility.set_location(' Leaving:'||l_proc, 700);
2099: exception
2100: when hr_api.validate_enabled then
2101: --
2102: -- As the Validate_Enabled exception has been raised
2103: -- we must rollback to the savepoint
2104: --

Line 2158: ,p_start_date in date default hr_api.g_date

2154: procedure change_deployment_dates
2155: (p_validate in boolean default false
2156: ,p_person_deployment_id in number
2157: ,p_object_version_number in out nocopy number
2158: ,p_start_date in date default hr_api.g_date
2159: ,p_end_date in date default hr_api.g_date
2160: ,p_deplymt_policy_id in number default hr_api.g_number
2161: ) is
2162: --

Line 2159: ,p_end_date in date default hr_api.g_date

2155: (p_validate in boolean default false
2156: ,p_person_deployment_id in number
2157: ,p_object_version_number in out nocopy number
2158: ,p_start_date in date default hr_api.g_date
2159: ,p_end_date in date default hr_api.g_date
2160: ,p_deplymt_policy_id in number default hr_api.g_number
2161: ) is
2162: --
2163: -- Declare cursors and local variables

Line 2160: ,p_deplymt_policy_id in number default hr_api.g_number

2156: ,p_person_deployment_id in number
2157: ,p_object_version_number in out nocopy number
2158: ,p_start_date in date default hr_api.g_date
2159: ,p_end_date in date default hr_api.g_date
2160: ,p_deplymt_policy_id in number default hr_api.g_number
2161: ) is
2162: --
2163: -- Declare cursors and local variables
2164: --

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

2290: end if;
2291: --
2292: -- Process Logic
2293: --
2294: if ((nvl(l_start_date_in,hr_api.g_date) <> hr_api.g_date)
2295: OR (l_end_date_in is null and l_dpl_rec.end_date is not null)
2296: OR (l_end_date_in <> hr_api.g_date)) then
2297: --
2298: -- At least one date has changed, proceed according to which one changed

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

2292: -- Process Logic
2293: --
2294: if ((nvl(l_start_date_in,hr_api.g_date) <> hr_api.g_date)
2295: OR (l_end_date_in is null and l_dpl_rec.end_date is not null)
2296: OR (l_end_date_in <> hr_api.g_date)) then
2297: --
2298: -- At least one date has changed, proceed according to which one changed
2299: --
2300:

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

2297: --
2298: -- At least one date has changed, proceed according to which one changed
2299: --
2300:
2301: if nvl(l_start_date_in,hr_api.g_date) = hr_api.g_date then
2302: --
2303: hr_utility.set_location(l_proc,50);
2304: --
2305: --start date the same

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

2349: end loop;
2350: end if;
2351: --
2352: -- Bug 5635350 modified the following if condition
2353: -- if l_end_date_in = hr_api.g_date then
2354: if l_end_date_in = hr_api.g_date or l_end_date_in = l_dpl_rec.end_date then
2355: --
2356: hr_utility.set_location(l_proc,80);
2357: --

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

2350: end if;
2351: --
2352: -- Bug 5635350 modified the following if condition
2353: -- if l_end_date_in = hr_api.g_date then
2354: if l_end_date_in = hr_api.g_date or l_end_date_in = l_dpl_rec.end_date then
2355: --
2356: hr_utility.set_location(l_proc,80);
2357: --
2358: --end date the same

Line 2442: raise hr_api.validate_enabled;

2438: --
2439: -- When in validation only mode raise the Validate_Enabled exception
2440: --
2441: if p_validate then
2442: raise hr_api.validate_enabled;
2443: end if;
2444: --
2445: -- Set all IN OUT and OUT parameters with out values
2446: --

Line 2451: when hr_api.validate_enabled then

2447:
2448: --
2449: hr_utility.set_location(' Leaving:'||l_proc, 700);
2450: exception
2451: when hr_api.validate_enabled then
2452: --
2453: -- As the Validate_Enabled exception has been raised
2454: -- we must rollback to the savepoint
2455: --

Line 2489: ,p_end_date in date default hr_api.g_date

2485: procedure return_from_deployment
2486: (p_validate in boolean default false
2487: ,p_person_deployment_id in number
2488: ,p_object_version_number in out nocopy number
2489: ,p_end_date in date default hr_api.g_date
2490: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2491: ,p_leaving_person_type_id in number default hr_api.g_number
2492: ) is
2493: --

Line 2490: ,p_leaving_reason in varchar2 default hr_api.g_varchar2

2486: (p_validate in boolean default false
2487: ,p_person_deployment_id in number
2488: ,p_object_version_number in out nocopy number
2489: ,p_end_date in date default hr_api.g_date
2490: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2491: ,p_leaving_person_type_id in number default hr_api.g_number
2492: ) is
2493: --
2494: -- Declare cursors and local variables

Line 2491: ,p_leaving_person_type_id in number default hr_api.g_number

2487: ,p_person_deployment_id in number
2488: ,p_object_version_number in out nocopy number
2489: ,p_end_date in date default hr_api.g_date
2490: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
2491: ,p_leaving_person_type_id in number default hr_api.g_number
2492: ) is
2493: --
2494: -- Declare cursors and local variables
2495: --

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

2613: --
2614: l_leaving_reason := p_leaving_reason;
2615: l_leaving_person_type_id := p_leaving_person_type_id;
2616: --
2617: if nvl(l_end_date_in,hr_api.g_date) = hr_api.g_date then
2618: hr_utility.set_location(l_proc,30);
2619: l_end_date_in := l_dpl_rec.end_date;
2620: end if;
2621: --

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

2618: hr_utility.set_location(l_proc,30);
2619: l_end_date_in := l_dpl_rec.end_date;
2620: end if;
2621: --
2622: if nvl(l_leaving_reason,hr_api.g_varchar2) = hr_api.g_varchar2 then
2623: hr_utility.set_location(l_proc,40);
2624: l_leaving_reason := l_dpl_rec.leaving_reason;
2625: end if;
2626: --

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

2623: hr_utility.set_location(l_proc,40);
2624: l_leaving_reason := l_dpl_rec.leaving_reason;
2625: end if;
2626: --
2627: if nvl(l_leaving_person_type_id,hr_api.g_number) = hr_api.g_number then
2628: hr_utility.set_location(l_proc,50);
2629: l_leaving_person_type_id := l_dpl_rec.leaving_person_type_id;
2630: end if;
2631:

Line 2705: raise hr_api.validate_enabled;

2701: --
2702: -- When in validation only mode raise the Validate_Enabled exception
2703: --
2704: if p_validate then
2705: raise hr_api.validate_enabled;
2706: end if;
2707: --
2708: -- Set all IN OUT and OUT parameters with out values
2709: --

Line 2712: when hr_api.validate_enabled then

2708: -- Set all IN OUT and OUT parameters with out values
2709: --
2710: hr_utility.set_location(' Leaving:'||l_proc, 700);
2711: exception
2712: when hr_api.validate_enabled then
2713: --
2714: -- As the Validate_Enabled exception has been raised
2715: -- we must rollback to the savepoint
2716: --