64: ,p_value_style_cd => p_value_style_cd
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_TXN_CAT_ATTRIBUTE'
72: ,p_hook_type => 'BP'
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_TXN_CAT_ATTRIBUTE'
72: ,p_hook_type => 'BP'
73: );
115: ,p_value_style_cd => p_value_style_cd
116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_TXN_CAT_ATTRIBUTE'
122: ,p_hook_type => 'AP'
123: );
116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_TXN_CAT_ATTRIBUTE'
122: ,p_hook_type => 'AP'
123: );
124: --
130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then
134: raise hr_api.validate_enabled;
135: end if;
136: --
137: -- Set all output arguments
138: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --
174: --
175: procedure update_TXN_CAT_ATTRIBUTE
176: (p_validate in boolean default false
177: ,p_txn_category_attribute_id in number
178: ,p_attribute_id in number default hr_api.g_number
179: ,p_transaction_category_id in number default hr_api.g_number
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
175: procedure update_TXN_CAT_ATTRIBUTE
176: (p_validate in boolean default false
177: ,p_txn_category_attribute_id in number
178: ,p_attribute_id in number default hr_api.g_number
179: ,p_transaction_category_id in number default hr_api.g_number
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
176: (p_validate in boolean default false
177: ,p_txn_category_attribute_id in number
178: ,p_attribute_id in number default hr_api.g_number
179: ,p_transaction_category_id in number default hr_api.g_number
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
178: ,p_attribute_id in number default hr_api.g_number
179: ,p_transaction_category_id in number default hr_api.g_number
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
179: ,p_transaction_category_id in number default hr_api.g_number
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
180: ,p_value_set_id in number default hr_api.g_number
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
181: ,p_object_version_number in out nocopy number
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
189: ,p_value_style_cd in varchar2
182: ,p_transaction_table_route_id in number default hr_api.g_number
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
189: ,p_value_style_cd in varchar2
190: ,p_effective_date in date
183: ,p_form_column_name in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
189: ,p_value_style_cd in varchar2
190: ,p_effective_date in date
191: ,p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
184: ,p_identifier_flag in varchar2 default hr_api.g_varchar2
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
189: ,p_value_style_cd in varchar2
190: ,p_effective_date in date
191: ,p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
192: ) is
187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2
188: ,p_select_flag in varchar2 default hr_api.g_varchar2
189: ,p_value_style_cd in varchar2
190: ,p_effective_date in date
191: ,p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
192: ) is
193: --
194: -- Declare cursors and local variables
195: --
231: ,p_value_style_cd => p_value_style_cd
232: ,p_effective_date => trunc(p_effective_date)
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'UPDATE_TXN_CAT_ATTRIBUTE'
238: ,p_hook_type => 'BP'
239: );
232: ,p_effective_date => trunc(p_effective_date)
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'UPDATE_TXN_CAT_ATTRIBUTE'
238: ,p_hook_type => 'BP'
239: );
240: --
282: ,p_value_style_cd => p_value_style_cd
283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'UPDATE_TXN_CAT_ATTRIBUTE'
289: ,p_hook_type => 'AP'
290: );
283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'UPDATE_TXN_CAT_ATTRIBUTE'
289: ,p_hook_type => 'AP'
290: );
291: --
297: --
298: -- When in validation only mode raise the Validate_Enabled exception
299: --
300: if p_validate then
301: raise hr_api.validate_enabled;
302: end if;
303: --
304: -- Set all output arguments
305: --
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: --
310: exception
311: --
312: when hr_api.validate_enabled then
313: --
314: -- As the Validate_Enabled exception has been raised
315: -- we must rollback to the savepoint
316: --
373: ,p_object_version_number => p_object_version_number
374: ,p_effective_date => trunc(p_effective_date)
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'DELETE_TXN_CAT_ATTRIBUTE'
380: ,p_hook_type => 'BP'
381: );
374: ,p_effective_date => trunc(p_effective_date)
375: );
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'DELETE_TXN_CAT_ATTRIBUTE'
380: ,p_hook_type => 'BP'
381: );
382: --
401: ,p_object_version_number => l_object_version_number
402: ,p_effective_date => trunc(p_effective_date)
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'DELETE_TXN_CAT_ATTRIBUTE'
408: ,p_hook_type => 'AP'
409: );
402: ,p_effective_date => trunc(p_effective_date)
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'DELETE_TXN_CAT_ATTRIBUTE'
408: ,p_hook_type => 'AP'
409: );
410: --
416: --
417: -- When in validation only mode raise the Validate_Enabled exception
418: --
419: if p_validate then
420: raise hr_api.validate_enabled;
421: end if;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
425: exception
426: --
427: when hr_api.validate_enabled then
428: --
429: -- As the Validate_Enabled exception has been raised
430: -- we must rollback to the savepoint
431: --