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

Line 27: ,p_language_code in varchar2 default hr_api.userenv_lang

23: ,p_freeze_status_cd in varchar2 default null
24: ,p_template_type_cd in varchar2
25: ,p_legislation_code in varchar2 default null
26: ,p_effective_date in date
27: ,p_language_code in varchar2 default hr_api.userenv_lang
28: ) is
29: --
30: -- Declare cursors and local variables
31: --

Line 67: when hr_api.cannot_find_prog_unit then

63: ,p_legislation_code => p_legislation_code
64: ,p_effective_date => trunc(p_effective_date)
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (
70: p_module_name => 'CREATE_GENERIC_TEMPLATE'
71: ,p_hook_type => 'BP'

Line 68: hr_api.cannot_find_prog_unit_error

64: ,p_effective_date => trunc(p_effective_date)
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (
70: p_module_name => 'CREATE_GENERIC_TEMPLATE'
71: ,p_hook_type => 'BP'
72: );

Line 125: when hr_api.cannot_find_prog_unit then

121: ,p_legislation_code => p_legislation_code
122: ,p_effective_date => trunc(p_effective_date)
123: );
124: exception
125: when hr_api.cannot_find_prog_unit then
126: hr_api.cannot_find_prog_unit_error
127: (p_module_name => 'CREATE_GENERIC_TEMPLATE'
128: ,p_hook_type => 'AP'
129: );

Line 126: hr_api.cannot_find_prog_unit_error

122: ,p_effective_date => trunc(p_effective_date)
123: );
124: exception
125: when hr_api.cannot_find_prog_unit then
126: hr_api.cannot_find_prog_unit_error
127: (p_module_name => 'CREATE_GENERIC_TEMPLATE'
128: ,p_hook_type => 'AP'
129: );
130: --

Line 140: raise hr_api.validate_enabled;

136: --
137: -- When in validation only mode raise the Validate_Enabled exception
138: --
139: if p_validate then
140: raise hr_api.validate_enabled;
141: end if;
142: --
143: -- Set all output arguments
144: --

Line 152: when hr_api.validate_enabled then

148: hr_utility.set_location(' Leaving:'||l_proc, 70);
149: --
150: exception
151: --
152: when hr_api.validate_enabled then
153: --
154: -- As the Validate_Enabled exception has been raised
155: -- we must rollback to the savepoint
156: --

Line 183: ,p_template_name in varchar2 default hr_api.g_varchar2

179: -- ----------------------------------------------------------------------------
180: --
181: procedure update_GENERIC_TEMPLATE
182: (p_validate in boolean default false
183: ,p_template_name in varchar2 default hr_api.g_varchar2
184: ,p_short_name in varchar2 default hr_api.g_varchar2
185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2

Line 184: ,p_short_name in varchar2 default hr_api.g_varchar2

180: --
181: procedure update_GENERIC_TEMPLATE
182: (p_validate in boolean default false
183: ,p_template_name in varchar2 default hr_api.g_varchar2
184: ,p_short_name in varchar2 default hr_api.g_varchar2
185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2

Line 186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2

182: (p_validate in boolean default false
183: ,p_template_name in varchar2 default hr_api.g_varchar2
184: ,p_short_name in varchar2 default hr_api.g_varchar2
185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2

Line 187: ,p_enable_flag in varchar2 default hr_api.g_varchar2

183: ,p_template_name in varchar2 default hr_api.g_varchar2
184: ,p_short_name in varchar2 default hr_api.g_varchar2
185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number

Line 188: ,p_create_flag in varchar2 default hr_api.g_varchar2

184: ,p_short_name in varchar2 default hr_api.g_varchar2
185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number
192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2

Line 189: ,p_transaction_category_id in number default hr_api.g_number

185: ,p_template_id in number
186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number
192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
193: ,p_template_type_cd in varchar2

Line 190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2

186: ,p_attribute_only_flag in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number
192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
193: ,p_template_type_cd in varchar2
194: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2

188: ,p_create_flag in varchar2 default hr_api.g_varchar2
189: ,p_transaction_category_id in number default hr_api.g_number
190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number
192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
193: ,p_template_type_cd in varchar2
194: ,p_legislation_code in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 194: ,p_legislation_code in varchar2 default hr_api.g_varchar2

190: ,p_under_review_flag in varchar2 default hr_api.g_varchar2
191: ,p_object_version_number in out nocopy number
192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
193: ,p_template_type_cd in varchar2
194: ,p_legislation_code in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
197: ) is
198: --

Line 196: ,p_language_code in varchar2 default hr_api.userenv_lang

192: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
193: ,p_template_type_cd in varchar2
194: ,p_legislation_code in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
197: ) is
198: --
199: -- Declare cursors and local variables
200: --

Line 239: when hr_api.cannot_find_prog_unit then

235: ,p_legislation_code => p_legislation_code
236: ,p_effective_date => trunc(p_effective_date)
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'UPDATE_GENERIC_TEMPLATE'
242: ,p_hook_type => 'BP'
243: );

Line 240: hr_api.cannot_find_prog_unit_error

236: ,p_effective_date => trunc(p_effective_date)
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'UPDATE_GENERIC_TEMPLATE'
242: ,p_hook_type => 'BP'
243: );
244: --

Line 294: when hr_api.cannot_find_prog_unit then

290: ,p_legislation_code => p_legislation_code
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_GENERIC_TEMPLATE'
297: ,p_hook_type => 'AP'
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_GENERIC_TEMPLATE'
297: ,p_hook_type => 'AP'
298: );
299: --

Line 309: raise hr_api.validate_enabled;

305: --
306: -- When in validation only mode raise the Validate_Enabled exception
307: --
308: if p_validate then
309: raise hr_api.validate_enabled;
310: end if;
311: --
312: -- Set all output arguments
313: --

Line 320: when hr_api.validate_enabled then

316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: --
318: exception
319: --
320: when hr_api.validate_enabled then
321: --
322: -- As the Validate_Enabled exception has been raised
323: -- we must rollback to the savepoint
324: --

Line 384: when hr_api.cannot_find_prog_unit then

380: ,p_object_version_number => p_object_version_number
381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'DELETE_GENERIC_TEMPLATE'
387: ,p_hook_type => 'BP'
388: );

Line 385: hr_api.cannot_find_prog_unit_error

381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'DELETE_GENERIC_TEMPLATE'
387: ,p_hook_type => 'BP'
388: );
389: --

Line 429: when hr_api.cannot_find_prog_unit then

425: ,p_object_version_number => l_object_version_number
426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_GENERIC_TEMPLATE'
432: ,p_hook_type => 'AP'
433: );

Line 430: hr_api.cannot_find_prog_unit_error

426: ,p_effective_date => trunc(p_effective_date)
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_GENERIC_TEMPLATE'
432: ,p_hook_type => 'AP'
433: );
434: --

Line 444: raise hr_api.validate_enabled;

440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: --

Line 451: when hr_api.validate_enabled then

447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: --
449: exception
450: --
451: when hr_api.validate_enabled then
452: --
453: -- As the Validate_Enabled exception has been raised
454: -- we must rollback to the savepoint
455: --