135: procedure update_routing_history
136: (
137: p_validate in boolean default false
138: ,p_routing_history_id in number
139: ,p_approval_cd in varchar2 default hr_api.g_varchar2
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
136: (
137: p_validate in boolean default false
138: ,p_routing_history_id in number
139: ,p_approval_cd in varchar2 default hr_api.g_varchar2
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
137: p_validate in boolean default false
138: ,p_routing_history_id in number
139: ,p_approval_cd in varchar2 default hr_api.g_varchar2
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
138: ,p_routing_history_id in number
139: ,p_approval_cd in varchar2 default hr_api.g_varchar2
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
139: ,p_approval_cd in varchar2 default hr_api.g_varchar2
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
140: ,p_comments in varchar2 default hr_api.g_varchar2
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
141: ,p_forwarded_by_assignment_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
142: ,p_forwarded_by_member_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
143: ,p_forwarded_by_position_id in number default hr_api.g_number
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
144: ,p_forwarded_by_user_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
145: ,p_forwarded_by_role_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
146: ,p_forwarded_to_assignment_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
147: ,p_forwarded_to_member_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
148: ,p_forwarded_to_position_id in number default hr_api.g_number
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
149: ,p_forwarded_to_user_id in number default hr_api.g_number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
150: ,p_forwarded_to_role_id in number default hr_api.g_number
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
151: ,p_notification_date in date default hr_api.g_date
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2
152: ,p_pos_structure_version_id in number default hr_api.g_number
153: ,p_routing_category_id in number default hr_api.g_number
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2
160: ,p_list_range_name in varchar2 default hr_api.g_varchar2
154: ,p_transaction_category_id in number default hr_api.g_number
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2
160: ,p_list_range_name in varchar2 default hr_api.g_varchar2
161: ,p_effective_date in date
162: );
155: ,p_transaction_id in number default hr_api.g_number
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2
160: ,p_list_range_name in varchar2 default hr_api.g_varchar2
161: ,p_effective_date in date
162: );
163: --
156: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2
160: ,p_list_range_name in varchar2 default hr_api.g_varchar2
161: ,p_effective_date in date
162: );
163: --
164: -- ----------------------------------------------------------------------------