DBA Data[Home] [Help]

APPS.PQH_ROUTING_HISTORY_API dependencies on HR_API

Line 139: ,p_approval_cd in varchar2 default hr_api.g_varchar2

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

Line 140: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 141: ,p_forwarded_by_assignment_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

Line 142: ,p_forwarded_by_member_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

Line 143: ,p_forwarded_by_position_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

Line 144: ,p_forwarded_by_user_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

Line 145: ,p_forwarded_by_role_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

Line 146: ,p_forwarded_to_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
150: ,p_forwarded_to_role_id in number default hr_api.g_number

Line 147: ,p_forwarded_to_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
151: ,p_notification_date in date default hr_api.g_date

Line 148: ,p_forwarded_to_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
152: ,p_pos_structure_version_id in number default hr_api.g_number

Line 149: ,p_forwarded_to_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
153: ,p_routing_category_id in number default hr_api.g_number

Line 150: ,p_forwarded_to_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
154: ,p_transaction_category_id in number default hr_api.g_number

Line 151: ,p_notification_date in date default hr_api.g_date

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

Line 152: ,p_pos_structure_version_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

Line 153: ,p_routing_category_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
157: ,p_object_version_number in out nocopy number

Line 154: ,p_transaction_category_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
158: ,p_from_range_name in varchar2 default hr_api.g_varchar2

Line 155: ,p_transaction_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
159: ,p_to_range_name in varchar2 default hr_api.g_varchar2

Line 156: ,p_user_action_cd 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

Line 158: ,p_from_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: );

Line 159: ,p_to_range_name in varchar2 default hr_api.g_varchar2

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: --

Line 160: ,p_list_range_name in varchar2 default hr_api.g_varchar2

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: -- ----------------------------------------------------------------------------