DBA Data[Home] [Help]

APPS.PQH_TXN_CAT_ATTRIBUTES_API dependencies on HR_API

Line 68: when hr_api.cannot_find_prog_unit then

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'

Line 69: hr_api.cannot_find_prog_unit_error

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

Line 119: when hr_api.cannot_find_prog_unit then

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

Line 120: hr_api.cannot_find_prog_unit_error

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: --

Line 134: raise hr_api.validate_enabled;

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: --

Line 146: when hr_api.validate_enabled then

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: --

Line 178: ,p_attribute_id in number default hr_api.g_number

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

Line 179: ,p_transaction_category_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

Line 180: ,p_value_set_id in number default hr_api.g_number

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

Line 182: ,p_transaction_table_route_id in number default hr_api.g_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
185: ,p_list_identifying_flag in varchar2 default hr_api.g_varchar2
186: ,p_member_identifying_flag in varchar2 default hr_api.g_varchar2

Line 183: ,p_form_column_name 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

Line 184: ,p_identifier_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

Line 185: ,p_list_identifying_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

Line 186: ,p_member_identifying_flag in varchar2 default hr_api.g_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

Line 187: ,p_refresh_flag in varchar2 default hr_api.g_varchar2

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

Line 188: ,p_select_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

Line 191: ,p_delete_attr_ranges_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
193: --
194: -- Declare cursors and local variables
195: --

Line 235: when hr_api.cannot_find_prog_unit then

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

Line 236: hr_api.cannot_find_prog_unit_error

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: --

Line 286: when hr_api.cannot_find_prog_unit then

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

Line 287: hr_api.cannot_find_prog_unit_error

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: --

Line 301: raise hr_api.validate_enabled;

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: --

Line 312: when hr_api.validate_enabled then

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: --

Line 377: when hr_api.cannot_find_prog_unit then

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

Line 378: hr_api.cannot_find_prog_unit_error

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: --

Line 405: when hr_api.cannot_find_prog_unit then

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

Line 406: hr_api.cannot_find_prog_unit_error

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: --

Line 420: raise hr_api.validate_enabled;

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: --

Line 427: when hr_api.validate_enabled then

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: --