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: --
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'
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: );
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: );
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: --
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: --
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: --
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
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
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
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
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
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
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
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
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: --
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: --
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: );
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: --
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: );
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: --
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: --
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: --
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: );
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: --
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: );
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: --
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: --
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: --