50: ,p_transaction_category_id => p_transaction_category_id
51: ,p_effective_date => trunc(p_effective_date)
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_TRANSACTION_TEMPLATE'
58: ,p_hook_type => 'BP'
51: ,p_effective_date => trunc(p_effective_date)
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_TRANSACTION_TEMPLATE'
58: ,p_hook_type => 'BP'
59: );
87: ,p_object_version_number => l_object_version_number
88: ,p_effective_date => trunc(p_effective_date)
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_TRANSACTION_TEMPLATE'
94: ,p_hook_type => 'AP'
95: );
88: ,p_effective_date => trunc(p_effective_date)
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_TRANSACTION_TEMPLATE'
94: ,p_hook_type => 'AP'
95: );
96: --
102: --
103: -- When in validation only mode raise the Validate_Enabled exception
104: --
105: if p_validate then
106: raise hr_api.validate_enabled;
107: end if;
108: --
109: -- Set all output arguments
110: --
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: --
116: exception
117: --
118: when hr_api.validate_enabled then
119: --
120: -- As the Validate_Enabled exception has been raised
121: -- we must rollback to the savepoint
122: --
146: --
147: procedure update_transaction_template
148: (p_validate in boolean default false
149: ,p_transaction_template_id in number
150: ,p_enable_flag in varchar2 default hr_api.g_varchar2
151: ,p_template_id in number default hr_api.g_number
152: ,p_transaction_id in number default hr_api.g_number
153: ,p_transaction_category_id in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
147: procedure update_transaction_template
148: (p_validate in boolean default false
149: ,p_transaction_template_id in number
150: ,p_enable_flag in varchar2 default hr_api.g_varchar2
151: ,p_template_id in number default hr_api.g_number
152: ,p_transaction_id in number default hr_api.g_number
153: ,p_transaction_category_id in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: ,p_effective_date in date
148: (p_validate in boolean default false
149: ,p_transaction_template_id in number
150: ,p_enable_flag in varchar2 default hr_api.g_varchar2
151: ,p_template_id in number default hr_api.g_number
152: ,p_transaction_id in number default hr_api.g_number
153: ,p_transaction_category_id in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: ,p_effective_date in date
156: ) is
149: ,p_transaction_template_id in number
150: ,p_enable_flag in varchar2 default hr_api.g_varchar2
151: ,p_template_id in number default hr_api.g_number
152: ,p_transaction_id in number default hr_api.g_number
153: ,p_transaction_category_id in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: ,p_effective_date in date
156: ) is
157: --
188: ,p_object_version_number => p_object_version_number
189: ,p_effective_date => trunc(p_effective_date)
190: );
191: exception
192: when hr_api.cannot_find_prog_unit then
193: hr_api.cannot_find_prog_unit_error
194: (p_module_name => 'UPDATE_TRANSACTION_TEMPLATE'
195: ,p_hook_type => 'BP'
196: );
189: ,p_effective_date => trunc(p_effective_date)
190: );
191: exception
192: when hr_api.cannot_find_prog_unit then
193: hr_api.cannot_find_prog_unit_error
194: (p_module_name => 'UPDATE_TRANSACTION_TEMPLATE'
195: ,p_hook_type => 'BP'
196: );
197: --
224: ,p_object_version_number => l_object_version_number
225: ,p_effective_date => trunc(p_effective_date)
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_TRANSACTION_TEMPLATE'
231: ,p_hook_type => 'AP'
232: );
225: ,p_effective_date => trunc(p_effective_date)
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_TRANSACTION_TEMPLATE'
231: ,p_hook_type => 'AP'
232: );
233: --
239: --
240: -- When in validation only mode raise the Validate_Enabled exception
241: --
242: if p_validate then
243: raise hr_api.validate_enabled;
244: end if;
245: --
246: -- Set all output arguments
247: --
250: hr_utility.set_location(' Leaving:'||l_proc, 70);
251: --
252: exception
253: --
254: when hr_api.validate_enabled then
255: --
256: -- As the Validate_Enabled exception has been raised
257: -- we must rollback to the savepoint
258: --
314: ,p_object_version_number => p_object_version_number
315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'DELETE_TRANSACTION_TEMPLATE'
321: ,p_hook_type => 'BP'
322: );
315: ,p_effective_date => trunc(p_effective_date)
316: );
317: exception
318: when hr_api.cannot_find_prog_unit then
319: hr_api.cannot_find_prog_unit_error
320: (p_module_name => 'DELETE_TRANSACTION_TEMPLATE'
321: ,p_hook_type => 'BP'
322: );
323: --
342: ,p_object_version_number => l_object_version_number
343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_TRANSACTION_TEMPLATE'
349: ,p_hook_type => 'AP'
350: );
343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_TRANSACTION_TEMPLATE'
349: ,p_hook_type => 'AP'
350: );
351: --
357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: --
366: exception
367: --
368: when hr_api.validate_enabled then
369: --
370: -- As the Validate_Enabled exception has been raised
371: -- we must rollback to the savepoint
372: --