eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_ROUTING_HISTORY_API dependencies on HR_API

Line 88: when hr_api.cannot_find_prog_unit then

84: ,p_list_range_name => p_list_range_name
85: ,p_effective_date => trunc(p_effective_date)
86: );
87: exception
88: when hr_api.cannot_find_prog_unit then
89: hr_api.cannot_find_prog_unit_error
90: (
91: p_module_name => 'CREATE_ROUTING_HISTORY'
92: ,p_hook_type => 'BP'

Line 89: hr_api.cannot_find_prog_unit_error

85: ,p_effective_date => trunc(p_effective_date)
86: );
87: exception
88: when hr_api.cannot_find_prog_unit then
89: hr_api.cannot_find_prog_unit_error
90: (
91: p_module_name => 'CREATE_ROUTING_HISTORY'
92: ,p_hook_type => 'BP'
93: );

Line 159: when hr_api.cannot_find_prog_unit then

155: ,p_list_range_name => p_list_range_name
156: ,p_effective_date => trunc(p_effective_date)
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'CREATE_ROUTING_HISTORY'
162: ,p_hook_type => 'AP'
163: );

Line 160: hr_api.cannot_find_prog_unit_error

156: ,p_effective_date => trunc(p_effective_date)
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'CREATE_ROUTING_HISTORY'
162: ,p_hook_type => 'AP'
163: );
164: --

Line 174: raise hr_api.validate_enabled;

170: --
171: -- When in validation only mode raise the Validate_Enabled exception
172: --
173: if p_validate then
174: raise hr_api.validate_enabled;
175: end if;
176: --
177: -- Set all output arguments
178: --

Line 186: when hr_api.validate_enabled then

182: hr_utility.set_location(' Leaving:'||l_proc, 70);
183: --
184: exception
185: --
186: when hr_api.validate_enabled then
187: --
188: -- As the Validate_Enabled exception has been raised
189: -- we must rollback to the savepoint
190: --

Line 218: ,p_approval_cd in varchar2 default hr_api.g_varchar2

214: --
215: procedure update_routing_history
216: (p_validate in boolean default false
217: ,p_routing_history_id in number
218: ,p_approval_cd in varchar2 default hr_api.g_varchar2
219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number

Line 219: ,p_comments in varchar2 default hr_api.g_varchar2

215: procedure update_routing_history
216: (p_validate in boolean default false
217: ,p_routing_history_id in number
218: ,p_approval_cd in varchar2 default hr_api.g_varchar2
219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number

Line 220: ,p_forwarded_by_assignment_id in number default hr_api.g_number

216: (p_validate in boolean default false
217: ,p_routing_history_id in number
218: ,p_approval_cd in varchar2 default hr_api.g_varchar2
219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number

Line 221: ,p_forwarded_by_member_id in number default hr_api.g_number

217: ,p_routing_history_id in number
218: ,p_approval_cd in varchar2 default hr_api.g_varchar2
219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number

Line 222: ,p_forwarded_by_position_id in number default hr_api.g_number

218: ,p_approval_cd in varchar2 default hr_api.g_varchar2
219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number

Line 223: ,p_forwarded_by_user_id in number default hr_api.g_number

219: ,p_comments in varchar2 default hr_api.g_varchar2
220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number

Line 224: ,p_forwarded_by_role_id in number default hr_api.g_number

220: ,p_forwarded_by_assignment_id in number default hr_api.g_number
221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number

Line 225: ,p_forwarded_to_assignment_id in number default hr_api.g_number

221: ,p_forwarded_by_member_id in number default hr_api.g_number
222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number

Line 226: ,p_forwarded_to_member_id in number default hr_api.g_number

222: ,p_forwarded_by_position_id in number default hr_api.g_number
223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date

Line 227: ,p_forwarded_to_position_id in number default hr_api.g_number

223: ,p_forwarded_by_user_id in number default hr_api.g_number
224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number

Line 228: ,p_forwarded_to_user_id in number default hr_api.g_number

224: ,p_forwarded_by_role_id in number default hr_api.g_number
225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number

Line 229: ,p_forwarded_to_role_id in number default hr_api.g_number

225: ,p_forwarded_to_assignment_id in number default hr_api.g_number
226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number

Line 230: ,p_notification_date in date default hr_api.g_date

226: ,p_forwarded_to_member_id in number default hr_api.g_number
227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number

Line 231: ,p_pos_structure_version_id in number default hr_api.g_number

227: ,p_forwarded_to_position_id in number default hr_api.g_number
228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2

Line 232: ,p_routing_category_id in number default hr_api.g_number

228: ,p_forwarded_to_user_id in number default hr_api.g_number
229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number

Line 233: ,p_transaction_category_id in number default hr_api.g_number

229: ,p_forwarded_to_role_id in number default hr_api.g_number
230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2

Line 234: ,p_transaction_id in number default hr_api.g_number

230: ,p_notification_date in date default hr_api.g_date
231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2
238: ,p_to_range_name in varchar2 default hr_api.g_varchar2

Line 235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2

231: ,p_pos_structure_version_id in number default hr_api.g_number
232: ,p_routing_category_id in number default hr_api.g_number
233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2
238: ,p_to_range_name in varchar2 default hr_api.g_varchar2
239: ,p_list_range_name in varchar2 default hr_api.g_varchar2

Line 237: ,p_from_range_name in varchar2 default hr_api.g_varchar2

233: ,p_transaction_category_id in number default hr_api.g_number
234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2
238: ,p_to_range_name in varchar2 default hr_api.g_varchar2
239: ,p_list_range_name in varchar2 default hr_api.g_varchar2
240: ,p_effective_date in date
241: ) is

Line 238: ,p_to_range_name in varchar2 default hr_api.g_varchar2

234: ,p_transaction_id in number default hr_api.g_number
235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2
238: ,p_to_range_name in varchar2 default hr_api.g_varchar2
239: ,p_list_range_name in varchar2 default hr_api.g_varchar2
240: ,p_effective_date in date
241: ) is
242: --

Line 239: ,p_list_range_name in varchar2 default hr_api.g_varchar2

235: ,p_user_action_cd in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_from_range_name in varchar2 default hr_api.g_varchar2
238: ,p_to_range_name in varchar2 default hr_api.g_varchar2
239: ,p_list_range_name in varchar2 default hr_api.g_varchar2
240: ,p_effective_date in date
241: ) is
242: --
243: -- Declare cursors and local variables

Line 294: when hr_api.cannot_find_prog_unit then

290: ,p_list_range_name => p_list_range_name
291: ,p_effective_date => trunc(p_effective_date)
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'UPDATE_ROUTING_HISTORY'
297: ,p_hook_type => 'BP'
298: );

Line 295: hr_api.cannot_find_prog_unit_error

291: ,p_effective_date => trunc(p_effective_date)
292: );
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'UPDATE_ROUTING_HISTORY'
297: ,p_hook_type => 'BP'
298: );
299: --

Line 364: when hr_api.cannot_find_prog_unit then

360: ,p_list_range_name => p_list_range_name
361: ,p_effective_date => trunc(p_effective_date)
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_ROUTING_HISTORY'
367: ,p_hook_type => 'AP'
368: );

Line 365: hr_api.cannot_find_prog_unit_error

361: ,p_effective_date => trunc(p_effective_date)
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_ROUTING_HISTORY'
367: ,p_hook_type => 'AP'
368: );
369: --

Line 379: raise hr_api.validate_enabled;

375: --
376: -- When in validation only mode raise the Validate_Enabled exception
377: --
378: if p_validate then
379: raise hr_api.validate_enabled;
380: end if;
381: --
382: -- Set all output arguments
383: --

Line 390: when hr_api.validate_enabled then

386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
388: exception
389: --
390: when hr_api.validate_enabled then
391: --
392: -- As the Validate_Enabled exception has been raised
393: -- we must rollback to the savepoint
394: --

Line 454: when hr_api.cannot_find_prog_unit then

450: ,p_object_version_number => p_object_version_number
451: ,p_effective_date => trunc(p_effective_date)
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'DELETE_ROUTING_HISTORY'
457: ,p_hook_type => 'BP'
458: );

Line 455: hr_api.cannot_find_prog_unit_error

451: ,p_effective_date => trunc(p_effective_date)
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'DELETE_ROUTING_HISTORY'
457: ,p_hook_type => 'BP'
458: );
459: --

Line 491: when hr_api.cannot_find_prog_unit then

487: ,p_object_version_number => l_object_version_number
488: ,p_effective_date => trunc(p_effective_date)
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'DELETE_ROUTING_HISTORY'
494: ,p_hook_type => 'AP'
495: );

Line 492: hr_api.cannot_find_prog_unit_error

488: ,p_effective_date => trunc(p_effective_date)
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'DELETE_ROUTING_HISTORY'
494: ,p_hook_type => 'AP'
495: );
496: --

Line 506: raise hr_api.validate_enabled;

502: --
503: -- When in validation only mode raise the Validate_Enabled exception
504: --
505: if p_validate then
506: raise hr_api.validate_enabled;
507: end if;
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 70);
510: --

Line 513: when hr_api.validate_enabled then

509: hr_utility.set_location(' Leaving:'||l_proc, 70);
510: --
511: exception
512: --
513: when hr_api.validate_enabled then
514: --
515: -- As the Validate_Enabled exception has been raised
516: -- we must rollback to the savepoint
517: --