DBA Data[Home] [Help]

APPS.PQH_ATTRIBUTES_API dependencies on HR_API

Line 24: ,p_language_code in varchar2 default hr_api.userenv_lang

20: ,p_enable_flag in varchar2 default null
21: ,p_width in number default null
22: ,p_object_version_number out nocopy number
23: ,p_effective_date in date
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_region_itemname in varchar2 default null
26: ,p_attribute_itemname in varchar2 default null
27: ,p_decode_function_name in varchar2 default null
28: ) is

Line 67: when hr_api.cannot_find_prog_unit then

63: ,p_attribute_itemname => p_attribute_itemname
64: ,p_decode_function_name => p_decode_function_name
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_ATTRIBUTE'
71: ,p_hook_type => 'BP'

Line 68: hr_api.cannot_find_prog_unit_error

64: ,p_decode_function_name => p_decode_function_name
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_ATTRIBUTE'
71: ,p_hook_type => 'BP'
72: );

Line 123: when hr_api.cannot_find_prog_unit then

119: ,p_attribute_itemname => p_attribute_itemname
120: ,p_decode_function_name => p_decode_function_name
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_ATTRIBUTE'
126: ,p_hook_type => 'AP'
127: );

Line 124: hr_api.cannot_find_prog_unit_error

120: ,p_decode_function_name => p_decode_function_name
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_ATTRIBUTE'
126: ,p_hook_type => 'AP'
127: );
128: --

Line 138: raise hr_api.validate_enabled;

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

Line 150: when hr_api.validate_enabled then

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

Line 182: ,p_attribute_name in varchar2 default hr_api.g_varchar2

178: --
179: procedure update_ATTRIBUTE
180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2

Line 183: ,p_master_attribute_id in number default hr_api.g_number

179: procedure update_ATTRIBUTE
180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2

Line 184: ,p_master_table_route_id in number default hr_api.g_number

180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number

Line 185: ,p_column_name in varchar2 default hr_api.g_varchar2

181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number

Line 186: ,p_column_type in varchar2 default hr_api.g_varchar2

182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date

Line 187: ,p_enable_flag in varchar2 default hr_api.g_varchar2

183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 188: ,p_width in number default hr_api.g_number

184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2

Line 191: ,p_language_code in varchar2 default hr_api.userenv_lang

187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is

Line 192: ,p_region_itemname in varchar2 default hr_api.g_varchar2

188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --

Line 193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2

189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --
197: -- Declare cursors and local variables

Line 194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2

190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --
197: -- Declare cursors and local variables
198: --

Line 237: when hr_api.cannot_find_prog_unit then

233: ,p_attribute_itemname => p_attribute_itemname
234: ,p_decode_function_name => p_decode_function_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_ATTRIBUTE'
240: ,p_hook_type => 'BP'
241: );

Line 238: hr_api.cannot_find_prog_unit_error

234: ,p_decode_function_name => p_decode_function_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_ATTRIBUTE'
240: ,p_hook_type => 'BP'
241: );
242: --

Line 292: when hr_api.cannot_find_prog_unit then

288: ,p_attribute_itemname => p_attribute_itemname
289: ,p_decode_function_name => p_decode_function_name
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ATTRIBUTE'
295: ,p_hook_type => 'AP'
296: );

Line 293: hr_api.cannot_find_prog_unit_error

289: ,p_decode_function_name => p_decode_function_name
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ATTRIBUTE'
295: ,p_hook_type => 'AP'
296: );
297: --

Line 307: raise hr_api.validate_enabled;

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

Line 318: when hr_api.validate_enabled then

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

Line 382: when hr_api.cannot_find_prog_unit then

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

Line 383: hr_api.cannot_find_prog_unit_error

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

Line 423: when hr_api.cannot_find_prog_unit then

419: ,p_object_version_number => l_object_version_number
420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_ATTRIBUTE'
426: ,p_hook_type => 'AP'
427: );

Line 424: hr_api.cannot_find_prog_unit_error

420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_ATTRIBUTE'
426: ,p_hook_type => 'AP'
427: );
428: --

Line 438: raise hr_api.validate_enabled;

434: --
435: -- When in validation only mode raise the Validate_Enabled exception
436: --
437: if p_validate then
438: raise hr_api.validate_enabled;
439: end if;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --

Line 445: when hr_api.validate_enabled then

441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --
443: exception
444: --
445: when hr_api.validate_enabled then
446: --
447: -- As the Validate_Enabled exception has been raised
448: -- we must rollback to the savepoint
449: --