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_TRAN_CATEGORY_API dependencies on HR_API

Line 36: ,p_language_code in varchar2 default hr_api.userenv_lang

32: ,p_business_group_id in number default null
33: ,p_setup_type_cd in varchar2 default null
34: ,p_master_table_route_id in number default null
35: ,p_effective_date in date
36: ,p_language_code in varchar2 default hr_api.userenv_lang
37: ) is
38: --
39: -- Declare cursors and local variables
40: --

Line 85: when hr_api.cannot_find_prog_unit then

81: ,p_master_table_route_id => p_master_table_route_id
82: ,p_effective_date => trunc(p_effective_date)
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (
88: p_module_name => 'CREATE_TRAN_CATEGORY'
89: ,p_hook_type => 'BP'

Line 86: hr_api.cannot_find_prog_unit_error

82: ,p_effective_date => trunc(p_effective_date)
83: );
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (
88: p_module_name => 'CREATE_TRAN_CATEGORY'
89: ,p_hook_type => 'BP'
90: );

Line 160: when hr_api.cannot_find_prog_unit then

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

Line 161: hr_api.cannot_find_prog_unit_error

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

Line 175: raise hr_api.validate_enabled;

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

Line 187: when hr_api.validate_enabled then

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

Line 219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2

215: --
216: procedure update_TRAN_CATEGORY
217: (p_validate in boolean default false
218: ,p_transaction_category_id in number
219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2

Line 220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2

216: procedure update_TRAN_CATEGORY
217: (p_validate in boolean default false
218: ,p_transaction_category_id in number
219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2

Line 221: ,p_form_name in varchar2 default hr_api.g_varchar2

217: (p_validate in boolean default false
218: ,p_transaction_category_id in number
219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2

Line 222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2

218: ,p_transaction_category_id in number
219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2

219: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2

Line 224: ,p_member_cd in varchar2 default hr_api.g_varchar2

220: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2

Line 225: ,p_name in varchar2 default hr_api.g_varchar2

221: ,p_form_name in varchar2 default hr_api.g_varchar2
222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2

Line 226: ,p_short_name in varchar2 default hr_api.g_varchar2

222: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2

Line 227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2

223: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2

Line 228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2

224: ,p_member_cd in varchar2 default hr_api.g_varchar2
225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2

Line 229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2

225: ,p_name in varchar2 default hr_api.g_varchar2
226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number

Line 230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2

226: ,p_short_name in varchar2 default hr_api.g_varchar2
227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number

Line 231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2

227: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number

Line 232: ,p_enable_flag in varchar2 default hr_api.g_varchar2

228: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number

Line 233: ,p_timeout_days in number default hr_api.g_number

229: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
230: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2

Line 235: ,p_consolidated_table_route_id in number default hr_api.g_number

231: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
238: ,p_master_table_route_id in number default hr_api.g_number
239: ,p_effective_date in date

Line 236: ,p_business_group_id in number default hr_api.g_number

232: ,p_enable_flag in varchar2 default hr_api.g_varchar2
233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
238: ,p_master_table_route_id in number default hr_api.g_number
239: ,p_effective_date in date
240: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2

233: ,p_timeout_days in number default hr_api.g_number
234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
238: ,p_master_table_route_id in number default hr_api.g_number
239: ,p_effective_date in date
240: ,p_language_code in varchar2 default hr_api.userenv_lang
241: ) is

Line 238: ,p_master_table_route_id in number default hr_api.g_number

234: ,p_object_version_number in out nocopy number
235: ,p_consolidated_table_route_id in number default hr_api.g_number
236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
238: ,p_master_table_route_id in number default hr_api.g_number
239: ,p_effective_date in date
240: ,p_language_code in varchar2 default hr_api.userenv_lang
241: ) is
242: --

Line 240: ,p_language_code in varchar2 default hr_api.userenv_lang

236: ,p_business_group_id in number default hr_api.g_number
237: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
238: ,p_master_table_route_id in number default hr_api.g_number
239: ,p_effective_date in date
240: ,p_language_code in varchar2 default hr_api.userenv_lang
241: ) is
242: --
243: -- Declare cursors and local variables
244: --

Line 292: when hr_api.cannot_find_prog_unit then

288: ,p_master_table_route_id => p_master_table_route_id
289: ,p_effective_date => trunc(p_effective_date)
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_TRAN_CATEGORY'
295: ,p_hook_type => 'BP'
296: );

Line 293: hr_api.cannot_find_prog_unit_error

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

Line 364: when hr_api.cannot_find_prog_unit then

360: ,p_master_table_route_id => p_master_table_route_id
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_TRAN_CATEGORY'
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_TRAN_CATEGORY'
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_TRAN_CATEGORY'
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_TRAN_CATEGORY'
457: ,p_hook_type => 'BP'
458: );
459: --

Line 494: when hr_api.cannot_find_prog_unit then

490: ,p_object_version_number => l_object_version_number
491: ,p_effective_date => trunc(p_effective_date)
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'DELETE_TRAN_CATEGORY'
497: ,p_hook_type => 'AP'
498: );

Line 495: hr_api.cannot_find_prog_unit_error

491: ,p_effective_date => trunc(p_effective_date)
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'DELETE_TRAN_CATEGORY'
497: ,p_hook_type => 'AP'
498: );
499: --

Line 509: raise hr_api.validate_enabled;

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

Line 516: when hr_api.validate_enabled then

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