[Home] [Help]
322: ,p_supervisor_id => p_supervisor_id
323: ,p_wf_transaction_category_id => p_wf_transaction_category_id
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (
329: p_module_name => 'CREATE_POSITION_TRANSACTION'
330: ,p_hook_type => 'BP'
323: ,p_wf_transaction_category_id => p_wf_transaction_category_id
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (
329: p_module_name => 'CREATE_POSITION_TRANSACTION'
330: ,p_hook_type => 'BP'
331: );
631: ,p_supervisor_id => p_supervisor_id
632: ,p_wf_transaction_category_id => p_wf_transaction_category_id
633: );
634: exception
635: when hr_api.cannot_find_prog_unit then
636: hr_api.cannot_find_prog_unit_error
637: (p_module_name => 'CREATE_POSITION_TRANSACTION'
638: ,p_hook_type => 'AP'
639: );
632: ,p_wf_transaction_category_id => p_wf_transaction_category_id
633: );
634: exception
635: when hr_api.cannot_find_prog_unit then
636: hr_api.cannot_find_prog_unit_error
637: (p_module_name => 'CREATE_POSITION_TRANSACTION'
638: ,p_hook_type => 'AP'
639: );
640: --
646: --
647: -- When in validation only mode raise the Validate_Enabled exception
648: --
649: if p_validate then
650: raise hr_api.validate_enabled;
651: end if;
652: --
653: -- Set all output arguments
654: --
658: hr_utility.set_location(' Leaving:'||l_proc, 70);
659: --
660: exception
661: --
662: when hr_api.validate_enabled then
663: --
664: -- As the Validate_Enabled exception has been raised
665: -- we must rollback to the savepoint
666: --
690: --
691: procedure update_position_transaction
692: (p_validate in boolean default false
693: ,p_position_transaction_id in number
694: ,p_action_date in date default hr_api.g_date
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
691: procedure update_position_transaction
692: (p_validate in boolean default false
693: ,p_position_transaction_id in number
694: ,p_action_date in date default hr_api.g_date
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
692: (p_validate in boolean default false
693: ,p_position_transaction_id in number
694: ,p_action_date in date default hr_api.g_date
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
693: ,p_position_transaction_id in number
694: ,p_action_date in date default hr_api.g_date
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
694: ,p_action_date in date default hr_api.g_date
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
695: ,p_position_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
696: ,p_availability_status_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
697: ,p_business_group_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
698: ,p_entry_step_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
699: ,p_entry_grade_rule_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
700: ,p_job_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
701: ,p_location_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
702: ,p_organization_id in number default hr_api.g_number
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
703: ,p_pay_freq_payroll_id in number default hr_api.g_number
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
704: ,p_position_definition_id in number default hr_api.g_number
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
705: ,p_prior_position_id in number default hr_api.g_number
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
706: ,p_relief_position_id in number default hr_api.g_number
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
707: ,p_entry_grade_id in number default hr_api.g_number
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
708: ,p_successor_position_id in number default hr_api.g_number
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
709: ,p_supervisor_position_id in number default hr_api.g_number
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
710: ,p_amendment_date in date default hr_api.g_date
711: ,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
712: ,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
713: ,p_avail_status_prop_end_date in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
714: ,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
715: ,p_comments in clob default null
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
716: ,p_country1 in varchar2 default hr_api.g_varchar2
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
717: ,p_country2 in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
718: ,p_country3 in varchar2 default hr_api.g_varchar2
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
719: ,p_current_job_prop_end_date in date default hr_api.g_date
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
720: ,p_current_org_prop_end_date in date default hr_api.g_date
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
721: ,p_date_effective in date default hr_api.g_date
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
722: ,p_date_end in date default hr_api.g_date
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
723: ,p_earliest_hire_date in date default hr_api.g_date
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
724: ,p_fill_by_date in date default hr_api.g_date
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
725: ,p_frequency in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
726: ,p_fte in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
727: ,p_fte_capacity in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
728: ,p_location1 in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
729: ,p_location2 in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
730: ,p_location3 in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
731: ,p_max_persons in number default hr_api.g_number
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
732: ,p_name in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
733: ,p_other_requirements in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
734: ,p_overlap_period in number default hr_api.g_number
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
735: ,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
736: ,p_passport_required in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
737: ,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
738: ,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
739: ,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
740: ,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
741: ,p_position_type in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
742: ,p_posting_description in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
743: ,p_probation_period in number default hr_api.g_number
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
744: ,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
745: ,p_relocate_domestically in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
746: ,p_relocate_internationally in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
747: ,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
748: ,p_review_flag in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
749: ,p_seasonal_flag in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
750: ,p_security_requirements in varchar2 default hr_api.g_varchar2
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
751: ,p_service_minimum in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
752: ,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
753: ,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
754: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
755: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
756: ,p_transaction_status in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
757: ,p_travel_required in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
758: ,p_working_hours in number default hr_api.g_number
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
759: ,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
760: ,p_work_any_country in varchar2 default hr_api.g_varchar2
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
761: ,p_work_any_location in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
762: ,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
763: ,p_work_schedule in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
764: ,p_work_duration in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
765: ,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
766: ,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
767: ,p_proposed_fte_for_layoff in number default hr_api.g_number
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
768: ,p_proposed_date_for_layoff in date default hr_api.g_date
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
789: ,p_information21 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
790: ,p_information22 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
791: ,p_information23 in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
792: ,p_information24 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
793: ,p_information25 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
794: ,p_information26 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
795: ,p_information27 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
796: ,p_information28 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
797: ,p_information29 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
798: ,p_information30 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
799: ,p_information_category in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
800: ,p_attribute1 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
801: ,p_attribute2 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
802: ,p_attribute3 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
803: ,p_attribute4 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
804: ,p_attribute5 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
805: ,p_attribute6 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
806: ,p_attribute7 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
807: ,p_attribute8 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
808: ,p_attribute9 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
809: ,p_attribute10 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
810: ,p_attribute11 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
811: ,p_attribute12 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
812: ,p_attribute13 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
813: ,p_attribute14 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
814: ,p_attribute15 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
815: ,p_attribute16 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
816: ,p_attribute17 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
817: ,p_attribute18 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
818: ,p_attribute19 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
819: ,p_attribute20 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
820: ,p_attribute21 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
821: ,p_attribute22 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
822: ,p_attribute23 in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
823: ,p_attribute24 in varchar2 default hr_api.g_varchar2
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
824: ,p_attribute25 in varchar2 default hr_api.g_varchar2
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
825: ,p_attribute26 in varchar2 default hr_api.g_varchar2
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
833: ,p_pay_basis_id in number default hr_api.g_number
826: ,p_attribute27 in varchar2 default hr_api.g_varchar2
827: ,p_attribute28 in varchar2 default hr_api.g_varchar2
828: ,p_attribute29 in varchar2 default hr_api.g_varchar2
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
833: ,p_pay_basis_id in number default hr_api.g_number
834: ,p_supervisor_id in number default hr_api.g_number
829: ,p_attribute30 in varchar2 default hr_api.g_varchar2
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
833: ,p_pay_basis_id in number default hr_api.g_number
834: ,p_supervisor_id in number default hr_api.g_number
835: ,p_wf_transaction_category_id in number default hr_api.g_number
836: ) is
837: --
830: ,p_attribute_category in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
833: ,p_pay_basis_id in number default hr_api.g_number
834: ,p_supervisor_id in number default hr_api.g_number
835: ,p_wf_transaction_category_id in number default hr_api.g_number
836: ) is
837: --
838: -- Declare cursors and local variables
831: ,p_object_version_number in out nocopy number
832: ,p_effective_date in date
833: ,p_pay_basis_id in number default hr_api.g_number
834: ,p_supervisor_id in number default hr_api.g_number
835: ,p_wf_transaction_category_id in number default hr_api.g_number
836: ) is
837: --
838: -- Declare cursors and local variables
839: --
1004: ,p_supervisor_id => p_supervisor_id
1005: ,p_wf_transaction_category_id => p_wf_transaction_category_id
1006: );
1007: exception
1008: when hr_api.cannot_find_prog_unit then
1009: hr_api.cannot_find_prog_unit_error
1010: (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1011: ,p_hook_type => 'BP'
1012: );
1005: ,p_wf_transaction_category_id => p_wf_transaction_category_id
1006: );
1007: exception
1008: when hr_api.cannot_find_prog_unit then
1009: hr_api.cannot_find_prog_unit_error
1010: (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1011: ,p_hook_type => 'BP'
1012: );
1013: --
1312: ,p_supervisor_id => p_supervisor_id
1313: ,p_wf_transaction_category_id => p_wf_transaction_category_id
1314: );
1315: exception
1316: when hr_api.cannot_find_prog_unit then
1317: hr_api.cannot_find_prog_unit_error
1318: (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1319: ,p_hook_type => 'AP'
1320: );
1313: ,p_wf_transaction_category_id => p_wf_transaction_category_id
1314: );
1315: exception
1316: when hr_api.cannot_find_prog_unit then
1317: hr_api.cannot_find_prog_unit_error
1318: (p_module_name => 'UPDATE_POSITION_TRANSACTION'
1319: ,p_hook_type => 'AP'
1320: );
1321: --
1327: --
1328: -- When in validation only mode raise the Validate_Enabled exception
1329: --
1330: if p_validate then
1331: raise hr_api.validate_enabled;
1332: end if;
1333: --
1334: -- Set all output arguments
1335: --
1338: hr_utility.set_location(' Leaving:'||l_proc, 70);
1339: --
1340: exception
1341: --
1342: when hr_api.validate_enabled then
1343: --
1344: -- As the Validate_Enabled exception has been raised
1345: -- we must rollback to the savepoint
1346: --
1402: ,p_object_version_number => p_object_version_number
1403: ,p_effective_date => trunc(p_effective_date)
1404: );
1405: exception
1406: when hr_api.cannot_find_prog_unit then
1407: hr_api.cannot_find_prog_unit_error
1408: (p_module_name => 'DELETE_POSITION_TRANSACTION'
1409: ,p_hook_type => 'BP'
1410: );
1403: ,p_effective_date => trunc(p_effective_date)
1404: );
1405: exception
1406: when hr_api.cannot_find_prog_unit then
1407: hr_api.cannot_find_prog_unit_error
1408: (p_module_name => 'DELETE_POSITION_TRANSACTION'
1409: ,p_hook_type => 'BP'
1410: );
1411: --
1430: ,p_object_version_number => l_object_version_number
1431: ,p_effective_date => trunc(p_effective_date)
1432: );
1433: exception
1434: when hr_api.cannot_find_prog_unit then
1435: hr_api.cannot_find_prog_unit_error
1436: (p_module_name => 'DELETE_POSITION_TRANSACTION'
1437: ,p_hook_type => 'AP'
1438: );
1431: ,p_effective_date => trunc(p_effective_date)
1432: );
1433: exception
1434: when hr_api.cannot_find_prog_unit then
1435: hr_api.cannot_find_prog_unit_error
1436: (p_module_name => 'DELETE_POSITION_TRANSACTION'
1437: ,p_hook_type => 'AP'
1438: );
1439: --
1445: --
1446: -- When in validation only mode raise the Validate_Enabled exception
1447: --
1448: if p_validate then
1449: raise hr_api.validate_enabled;
1450: end if;
1451: --
1452: hr_utility.set_location(' Leaving:'||l_proc, 70);
1453: --
1452: hr_utility.set_location(' Leaving:'||l_proc, 70);
1453: --
1454: exception
1455: --
1456: when hr_api.validate_enabled then
1457: --
1458: -- As the Validate_Enabled exception has been raised
1459: -- we must rollback to the savepoint
1460: --