99: Procedure upd
100: (
101: p_effective_date in date,
102: p_routing_history_id in number,
103: p_approval_cd in varchar2 default hr_api.g_varchar2,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
100: (
101: p_effective_date in date,
102: p_routing_history_id in number,
103: p_approval_cd in varchar2 default hr_api.g_varchar2,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
101: p_effective_date in date,
102: p_routing_history_id in number,
103: p_approval_cd in varchar2 default hr_api.g_varchar2,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
102: p_routing_history_id in number,
103: p_approval_cd in varchar2 default hr_api.g_varchar2,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
103: p_approval_cd in varchar2 default hr_api.g_varchar2,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
104: p_comments in varchar2 default hr_api.g_varchar2,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
105: p_forwarded_by_assignment_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
106: p_forwarded_by_member_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
107: p_forwarded_by_position_id in number default hr_api.g_number,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
108: p_forwarded_by_user_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
109: p_forwarded_by_role_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
110: p_forwarded_to_assignment_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
111: p_forwarded_to_member_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
112: p_forwarded_to_position_id in number default hr_api.g_number,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
113: p_forwarded_to_user_id in number default hr_api.g_number,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
114: p_forwarded_to_role_id in number default hr_api.g_number,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
115: p_notification_date in date default hr_api.g_date,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
123: p_list_range_name in varchar2 default hr_api.g_varchar2,
116: p_pos_structure_version_id in number default hr_api.g_number,
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
123: p_list_range_name in varchar2 default hr_api.g_varchar2,
124: p_object_version_number in out nocopy number
117: p_routing_category_id in number default hr_api.g_number,
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
123: p_list_range_name in varchar2 default hr_api.g_varchar2,
124: p_object_version_number in out nocopy number
125: );
118: p_transaction_category_id in number default hr_api.g_number,
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
123: p_list_range_name in varchar2 default hr_api.g_varchar2,
124: p_object_version_number in out nocopy number
125: );
126: --
119: p_transaction_id in number default hr_api.g_number,
120: p_user_action_cd in varchar2 default hr_api.g_varchar2,
121: p_from_range_name in varchar2 default hr_api.g_varchar2,
122: p_to_range_name in varchar2 default hr_api.g_varchar2,
123: p_list_range_name in varchar2 default hr_api.g_varchar2,
124: p_object_version_number in out nocopy number
125: );
126: --
127: end pqh_rht_upd;