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

Line 214: when hr_api.cannot_find_prog_unit then

210: ,p_lgps_trans_arrang_flag => p_lgps_trans_arrang_flag
211: ,p_lgps_membership_number => p_lgps_membership_number
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'create_assignment_attribute'
217: ,p_hook_type => 'BP'
218: );

Line 215: hr_api.cannot_find_prog_unit_error

211: ,p_lgps_membership_number => p_lgps_membership_number
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'create_assignment_attribute'
217: ,p_hook_type => 'BP'
218: );
219: end;

Line 409: when hr_api.cannot_find_prog_unit then

405: ,p_assignment_attribute_id =>l_assignment_attribute_id
406: ,p_object_version_number => l_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'create_assignment_attribute'
412: ,p_hook_type => 'AP'
413: );

Line 410: hr_api.cannot_find_prog_unit_error

406: ,p_object_version_number => l_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'create_assignment_attribute'
412: ,p_hook_type => 'AP'
413: );
414: end;

Line 419: raise hr_api.validate_enabled;

415: --
416: -- When in validation only mode raise the Validate_Enabled exception
417: --
418: if p_validate then
419: raise hr_api.validate_enabled;
420: end if;
421: --
422: -- Set all output arguments
423: --

Line 432: when hr_api.validate_enabled then

428:
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 70);
431: exception
432: when hr_api.validate_enabled then
433: --
434: -- As the Validate_Enabled exception has been raised
435: -- we must rollback to the savepoint
436: --

Line 475: ,p_assignment_id in number default hr_api.g_number

471: ,p_assignment_attribute_id in number
472: ,p_business_group_id in number
473: ,p_effective_start_date out nocopy date
474: ,p_effective_end_date out nocopy date
475: ,p_assignment_id in number default hr_api.g_number
476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number

Line 476: ,p_contract_type in varchar2 default hr_api.g_varchar2

472: ,p_business_group_id in number
473: ,p_effective_start_date out nocopy date
474: ,p_effective_end_date out nocopy date
475: ,p_assignment_id in number default hr_api.g_number
476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 477: ,p_work_pattern in varchar2 default hr_api.g_varchar2

473: ,p_effective_start_date out nocopy date
474: ,p_effective_end_date out nocopy date
475: ,p_assignment_id in number default hr_api.g_number
476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number

Line 478: ,p_start_day in varchar2 default hr_api.g_varchar2

474: ,p_effective_end_date out nocopy date
475: ,p_assignment_id in number default hr_api.g_number
476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2

Line 479: ,p_primary_company_car in number default hr_api.g_number

475: ,p_assignment_id in number default hr_api.g_number
476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number

Line 480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

476: ,p_contract_type in varchar2 default hr_api.g_varchar2
477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

Line 481: ,p_primary_capital_contribution in number default hr_api.g_number

477: ,p_work_pattern in varchar2 default hr_api.g_varchar2
478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number

Line 482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2

478: ,p_start_day in varchar2 default hr_api.g_varchar2
479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2

Line 483: ,p_secondary_company_car in number default hr_api.g_number

479: ,p_primary_company_car in number default hr_api.g_number
480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2

Line 484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2

480: ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number

Line 485: ,p_secondary_capital_contributi in number default hr_api.g_number

481: ,p_primary_capital_contribution in number default hr_api.g_number
482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number

Line 486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2

482: ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number

Line 487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2

483: ,p_secondary_company_car in number default hr_api.g_number
484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2

Line 488: ,p_company_car_rates_table_id in number default hr_api.g_number

484: ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number

Line 489: ,p_company_car_secondary_table in number default hr_api.g_number

485: ,p_secondary_capital_contributi in number default hr_api.g_number
486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number

Line 490: ,p_private_car in number default hr_api.g_number

486: ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number

Line 491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2

487: ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number

Line 492: ,p_private_car_rates_table_id in number default hr_api.g_number

488: ,p_company_car_rates_table_id in number default hr_api.g_number
489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2

Line 493: ,p_private_car_essential_table in number default hr_api.g_number

489: ,p_company_car_secondary_table in number default hr_api.g_number
490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation

Line 494: ,p_primary_private_contribution in number default hr_api.g_number

490: ,p_private_car in number default hr_api.g_number
491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number

Line 495: ,p_secondary_private_contributi in number default hr_api.g_number

491: ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2

Line 496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2

492: ,p_private_car_rates_table_id in number default hr_api.g_number
493: ,p_private_car_essential_table in number default hr_api.g_number
494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number

Line 498: ,p_tp_headteacher_grp_code in number default hr_api.g_number

494: ,p_primary_private_contribution in number default hr_api.g_number
495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number

Line 499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2

495: ,p_secondary_private_contributi in number default hr_api.g_number
496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number

Line 500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number

496: ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2

Line 501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2

497: --added for head Teacher seconded location for salary scale calculation
498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2

Line 502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number

498: ,p_tp_headteacher_grp_code in number default hr_api.g_number
499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2

Line 503: ,p_tp_spinal_point_id in number default hr_api.g_number

499: ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2

Line 504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2

500: ,p_tp_safeguarded_grade_id in number default hr_api.g_number
501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2

Line 505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2

501: ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2

Line 506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2

502: ,p_tp_safeguarded_rate_id in number default hr_api.g_number
503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2

Line 507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2

503: ,p_tp_spinal_point_id in number default hr_api.g_number
504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2

Line 508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2

504: ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2

Line 509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2

505: ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2

Line 510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2

506: ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2

Line 511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2

507: ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2

Line 512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2

508: ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2

Line 513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2

509: ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2

Line 514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2

510: ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2

Line 515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2

511: ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2

Line 516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2

512: ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2

Line 517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2

513: ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2

Line 518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2

514: ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2

Line 519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2

515: ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2

Line 520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2

516: ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2

Line 521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2

517: ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2

Line 522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2

518: ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2

Line 523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2

519: ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2

Line 524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2

520: ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2

Line 525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2

521: ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2

Line 526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2

522: ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2

Line 527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2

523: ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2

Line 528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2

524: ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2

Line 529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2

525: ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2

Line 530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2

526: ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2

Line 531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2

527: ,p_aat_information_category in varchar2 default hr_api.g_varchar2
528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2

Line 532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2

528: ,p_aat_information1 in varchar2 default hr_api.g_varchar2
529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2

Line 533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2

529: ,p_aat_information2 in varchar2 default hr_api.g_varchar2
530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2

Line 534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2

530: ,p_aat_information3 in varchar2 default hr_api.g_varchar2
531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2

Line 535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2

531: ,p_aat_information4 in varchar2 default hr_api.g_varchar2
532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2

Line 536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2

532: ,p_aat_information5 in varchar2 default hr_api.g_varchar2
533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2

Line 537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2

533: ,p_aat_information6 in varchar2 default hr_api.g_varchar2
534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2

Line 538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2

534: ,p_aat_information7 in varchar2 default hr_api.g_varchar2
535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2

Line 539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2

535: ,p_aat_information8 in varchar2 default hr_api.g_varchar2
536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2

Line 540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2

536: ,p_aat_information9 in varchar2 default hr_api.g_varchar2
537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2

Line 541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2

537: ,p_aat_information10 in varchar2 default hr_api.g_varchar2
538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2

Line 542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2

538: ,p_aat_information11 in varchar2 default hr_api.g_varchar2
539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2

Line 543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2

539: ,p_aat_information12 in varchar2 default hr_api.g_varchar2
540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2

Line 544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2

540: ,p_aat_information13 in varchar2 default hr_api.g_varchar2
541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2

Line 545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2

541: ,p_aat_information14 in varchar2 default hr_api.g_varchar2
542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2

Line 546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2

542: ,p_aat_information15 in varchar2 default hr_api.g_varchar2
543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2

Line 547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2

543: ,p_aat_information16 in varchar2 default hr_api.g_varchar2
544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2

Line 548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2

544: ,p_aat_information17 in varchar2 default hr_api.g_varchar2
545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2

Line 549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2

545: ,p_aat_information18 in varchar2 default hr_api.g_varchar2
546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
553: ,p_object_version_number in out nocopy number

Line 550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2

546: ,p_aat_information19 in varchar2 default hr_api.g_varchar2
547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
553: ,p_object_version_number in out nocopy number
554: ) is

Line 551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2

547: ,p_aat_information20 in varchar2 default hr_api.g_varchar2
548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
553: ,p_object_version_number in out nocopy number
554: ) is
555: --

Line 552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2

548: ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
549: ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
550: ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
551: ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
552: ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
553: ,p_object_version_number in out nocopy number
554: ) is
555: --
556: -- Declaring cursors and local variables

Line 650: if (l_contract_workpattern.contract_type = p_contract_type or p_contract_type = hr_api.g_varchar2) and

646: close c_contract_workpattern;
647:
648: --If the call is from forms the below condition will fail
649: --hence the below logic will not be fired.
650: if (l_contract_workpattern.contract_type = p_contract_type or p_contract_type = hr_api.g_varchar2) and
651: (l_contract_workpattern.work_pattern = p_work_pattern or p_work_pattern = hr_api.g_varchar2) and
652: (l_contract_workpattern.start_day = p_start_day or p_start_day = hr_api.g_varchar2) then
653:
654: if p_datetrack_mode <> 'CORRECTION' then

Line 651: (l_contract_workpattern.work_pattern = p_work_pattern or p_work_pattern = hr_api.g_varchar2) and

647:
648: --If the call is from forms the below condition will fail
649: --hence the below logic will not be fired.
650: if (l_contract_workpattern.contract_type = p_contract_type or p_contract_type = hr_api.g_varchar2) and
651: (l_contract_workpattern.work_pattern = p_work_pattern or p_work_pattern = hr_api.g_varchar2) and
652: (l_contract_workpattern.start_day = p_start_day or p_start_day = hr_api.g_varchar2) then
653:
654: if p_datetrack_mode <> 'CORRECTION' then
655:

Line 652: (l_contract_workpattern.start_day = p_start_day or p_start_day = hr_api.g_varchar2) then

648: --If the call is from forms the below condition will fail
649: --hence the below logic will not be fired.
650: if (l_contract_workpattern.contract_type = p_contract_type or p_contract_type = hr_api.g_varchar2) and
651: (l_contract_workpattern.work_pattern = p_work_pattern or p_work_pattern = hr_api.g_varchar2) and
652: (l_contract_workpattern.start_day = p_start_day or p_start_day = hr_api.g_varchar2) then
653:
654: if p_datetrack_mode <> 'CORRECTION' then
655:
656: l_start_day := l_contract_workpattern.start_day;

Line 789: when hr_api.cannot_find_prog_unit then

785: ,p_assignment_attribute_id =>p_assignment_attribute_id
786: ,p_object_version_number => p_object_version_number
787: );
788: exception
789: when hr_api.cannot_find_prog_unit then
790: hr_api.cannot_find_prog_unit_error
791: (p_module_name => 'update_assignment_attribute'
792: ,p_hook_type => 'BP'
793: );

Line 790: hr_api.cannot_find_prog_unit_error

786: ,p_object_version_number => p_object_version_number
787: );
788: exception
789: when hr_api.cannot_find_prog_unit then
790: hr_api.cannot_find_prog_unit_error
791: (p_module_name => 'update_assignment_attribute'
792: ,p_hook_type => 'BP'
793: );
794: end;

Line 986: when hr_api.cannot_find_prog_unit then

982: ,p_assignment_attribute_id =>p_assignment_attribute_id
983: ,p_object_version_number => l_object_version_number
984: );
985: exception
986: when hr_api.cannot_find_prog_unit then
987: hr_api.cannot_find_prog_unit_error
988: (p_module_name => 'update_assignment_attribute'
989: ,p_hook_type => 'AP'
990: );

Line 987: hr_api.cannot_find_prog_unit_error

983: ,p_object_version_number => l_object_version_number
984: );
985: exception
986: when hr_api.cannot_find_prog_unit then
987: hr_api.cannot_find_prog_unit_error
988: (p_module_name => 'update_assignment_attribute'
989: ,p_hook_type => 'AP'
990: );
991: end;

Line 996: raise hr_api.validate_enabled;

992: --
993: -- When in validation only mode raise the Validate_Enabled exception
994: --
995: if p_validate then
996: raise hr_api.validate_enabled;
997: end if;
998: --
999: -- Set all output arguments
1000: --

Line 1008: when hr_api.validate_enabled then

1004:
1005: --
1006: hr_utility.set_location(' Leaving:'||l_proc, 70);
1007: exception
1008: when hr_api.validate_enabled then
1009: --
1010: -- As the Validate_Enabled exception has been raised
1011: -- we must rollback to the savepoint
1012: --

Line 1088: when hr_api.cannot_find_prog_unit then

1084: ,p_effective_end_date => l_effective_end_date
1085: ,p_object_version_number => p_object_version_number
1086: );
1087: exception
1088: when hr_api.cannot_find_prog_unit then
1089: hr_api.cannot_find_prog_unit_error
1090: (p_module_name => 'delete_assignment_attribute'
1091: ,p_hook_type => 'BP'
1092: );

Line 1089: hr_api.cannot_find_prog_unit_error

1085: ,p_object_version_number => p_object_version_number
1086: );
1087: exception
1088: when hr_api.cannot_find_prog_unit then
1089: hr_api.cannot_find_prog_unit_error
1090: (p_module_name => 'delete_assignment_attribute'
1091: ,p_hook_type => 'BP'
1092: );
1093: end;

Line 1128: when hr_api.cannot_find_prog_unit then

1124: ,p_effective_end_date => l_effective_end_date
1125: ,p_object_version_number => l_object_version_number
1126: );
1127: exception
1128: when hr_api.cannot_find_prog_unit then
1129: hr_api.cannot_find_prog_unit_error
1130: (p_module_name => 'delete_assignment_attribute'
1131: ,p_hook_type => 'AP'
1132: );

Line 1129: hr_api.cannot_find_prog_unit_error

1125: ,p_object_version_number => l_object_version_number
1126: );
1127: exception
1128: when hr_api.cannot_find_prog_unit then
1129: hr_api.cannot_find_prog_unit_error
1130: (p_module_name => 'delete_assignment_attribute'
1131: ,p_hook_type => 'AP'
1132: );
1133: end;

Line 1138: raise hr_api.validate_enabled;

1134: --
1135: -- When in validation only mode raise the Validate_Enabled exception
1136: --
1137: if p_validate then
1138: raise hr_api.validate_enabled;
1139: end if;
1140: --
1141: -- Set all output arguments
1142: --

Line 1149: when hr_api.validate_enabled then

1145: p_effective_end_date := l_effective_end_date;
1146: --
1147: hr_utility.set_location(' Leaving:'||l_proc, 70);
1148: exception
1149: when hr_api.validate_enabled then
1150: --
1151: -- As the Validate_Enabled exception has been raised
1152: -- we must rollback to the savepoint
1153: --