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: );
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;
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: );
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;
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
666: ,p_assignment_attribute_id =>p_assignment_attribute_id
667: ,p_object_version_number => p_object_version_number
668: );
669: exception
670: when hr_api.cannot_find_prog_unit then
671: hr_api.cannot_find_prog_unit_error
672: (p_module_name => 'update_assignment_attribute'
673: ,p_hook_type => 'BP'
674: );
667: ,p_object_version_number => p_object_version_number
668: );
669: exception
670: when hr_api.cannot_find_prog_unit then
671: hr_api.cannot_find_prog_unit_error
672: (p_module_name => 'update_assignment_attribute'
673: ,p_hook_type => 'BP'
674: );
675: end;
863: ,p_assignment_attribute_id =>p_assignment_attribute_id
864: ,p_object_version_number => l_object_version_number
865: );
866: exception
867: when hr_api.cannot_find_prog_unit then
868: hr_api.cannot_find_prog_unit_error
869: (p_module_name => 'update_assignment_attribute'
870: ,p_hook_type => 'AP'
871: );
864: ,p_object_version_number => l_object_version_number
865: );
866: exception
867: when hr_api.cannot_find_prog_unit then
868: hr_api.cannot_find_prog_unit_error
869: (p_module_name => 'update_assignment_attribute'
870: ,p_hook_type => 'AP'
871: );
872: end;
873: --
874: -- When in validation only mode raise the Validate_Enabled exception
875: --
876: if p_validate then
877: raise hr_api.validate_enabled;
878: end if;
879: --
880: -- Set all output arguments
881: --
885:
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 70);
888: exception
889: when hr_api.validate_enabled then
890: --
891: -- As the Validate_Enabled exception has been raised
892: -- we must rollback to the savepoint
893: --
965: ,p_effective_end_date => l_effective_end_date
966: ,p_object_version_number => p_object_version_number
967: );
968: exception
969: when hr_api.cannot_find_prog_unit then
970: hr_api.cannot_find_prog_unit_error
971: (p_module_name => 'delete_assignment_attribute'
972: ,p_hook_type => 'BP'
973: );
966: ,p_object_version_number => p_object_version_number
967: );
968: exception
969: when hr_api.cannot_find_prog_unit then
970: hr_api.cannot_find_prog_unit_error
971: (p_module_name => 'delete_assignment_attribute'
972: ,p_hook_type => 'BP'
973: );
974: end;
1005: ,p_effective_end_date => l_effective_end_date
1006: ,p_object_version_number => l_object_version_number
1007: );
1008: exception
1009: when hr_api.cannot_find_prog_unit then
1010: hr_api.cannot_find_prog_unit_error
1011: (p_module_name => 'delete_assignment_attribute'
1012: ,p_hook_type => 'AP'
1013: );
1006: ,p_object_version_number => l_object_version_number
1007: );
1008: exception
1009: when hr_api.cannot_find_prog_unit then
1010: hr_api.cannot_find_prog_unit_error
1011: (p_module_name => 'delete_assignment_attribute'
1012: ,p_hook_type => 'AP'
1013: );
1014: end;
1015: --
1016: -- When in validation only mode raise the Validate_Enabled exception
1017: --
1018: if p_validate then
1019: raise hr_api.validate_enabled;
1020: end if;
1021: --
1022: -- Set all output arguments
1023: --
1026: p_effective_end_date := l_effective_end_date;
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 70);
1029: exception
1030: when hr_api.validate_enabled then
1031: --
1032: -- As the Validate_Enabled exception has been raised
1033: -- we must rollback to the savepoint
1034: --