DBA Data[Home] [Help]

APPS.PQH_ROUTING_HIST_ATTRIB_API dependencies on HR_API

Line 70: when hr_api.cannot_find_prog_unit then

66: ,p_value_char => p_value_char
67: ,p_effective_date => trunc(p_effective_date)
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (
73: p_module_name => 'CREATE_ROUTING_HIST_ATTRIB'
74: ,p_hook_type => 'BP'

Line 71: hr_api.cannot_find_prog_unit_error

67: ,p_effective_date => trunc(p_effective_date)
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (
73: p_module_name => 'CREATE_ROUTING_HIST_ATTRIB'
74: ,p_hook_type => 'BP'
75: );

Line 123: when hr_api.cannot_find_prog_unit then

119: ,p_value_char => p_value_char
120: ,p_effective_date => trunc(p_effective_date)
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_ROUTING_HIST_ATTRIB'
126: ,p_hook_type => 'AP'
127: );

Line 124: hr_api.cannot_find_prog_unit_error

120: ,p_effective_date => trunc(p_effective_date)
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_ROUTING_HIST_ATTRIB'
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_routing_history_id in number default hr_api.g_number

178: --
179: procedure update_routing_hist_attrib
180: (p_validate in boolean default false
181: ,p_routing_hist_attrib_id in number
182: ,p_routing_history_id in number default hr_api.g_number
183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number

Line 183: ,p_attribute_id in number default hr_api.g_number

179: procedure update_routing_hist_attrib
180: (p_validate in boolean default false
181: ,p_routing_hist_attrib_id in number
182: ,p_routing_history_id in number default hr_api.g_number
183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2

Line 184: ,p_from_char in varchar2 default hr_api.g_varchar2

180: (p_validate in boolean default false
181: ,p_routing_hist_attrib_id in number
182: ,p_routing_history_id in number default hr_api.g_number
183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date

Line 185: ,p_from_date in date default hr_api.g_date

181: ,p_routing_hist_attrib_id in number
182: ,p_routing_history_id in number default hr_api.g_number
183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number

Line 186: ,p_from_number in number default hr_api.g_number

182: ,p_routing_history_id in number default hr_api.g_number
183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number

Line 187: ,p_to_char in varchar2 default hr_api.g_varchar2

183: ,p_attribute_id in number default hr_api.g_number
184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2

Line 188: ,p_to_date in date default hr_api.g_date

184: ,p_from_char in varchar2 default hr_api.g_varchar2
185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date

Line 189: ,p_to_number in number default hr_api.g_number

185: ,p_from_date in date default hr_api.g_date
186: ,p_from_number in number default hr_api.g_number
187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date
193: ,p_value_number in number default hr_api.g_number

Line 191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2

187: ,p_to_char in varchar2 default hr_api.g_varchar2
188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date
193: ,p_value_number in number default hr_api.g_number
194: ,p_value_char in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date

Line 192: ,p_value_date in date default hr_api.g_date

188: ,p_to_date in date default hr_api.g_date
189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date
193: ,p_value_number in number default hr_api.g_number
194: ,p_value_char in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ) is

Line 193: ,p_value_number in number default hr_api.g_number

189: ,p_to_number in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date
193: ,p_value_number in number default hr_api.g_number
194: ,p_value_char in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ) is
197: --

Line 194: ,p_value_char in varchar2 default hr_api.g_varchar2

190: ,p_object_version_number in out nocopy number
191: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
192: ,p_value_date in date default hr_api.g_date
193: ,p_value_number in number default hr_api.g_number
194: ,p_value_char in varchar2 default hr_api.g_varchar2
195: ,p_effective_date in date
196: ) is
197: --
198: -- Declare cursors and local variables

Line 240: when hr_api.cannot_find_prog_unit then

236: ,p_value_char => p_value_char
237: ,p_effective_date => trunc(p_effective_date)
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'UPDATE_ROUTING_HIST_ATTRIB'
243: ,p_hook_type => 'BP'
244: );

Line 241: hr_api.cannot_find_prog_unit_error

237: ,p_effective_date => trunc(p_effective_date)
238: );
239: exception
240: when hr_api.cannot_find_prog_unit then
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'UPDATE_ROUTING_HIST_ATTRIB'
243: ,p_hook_type => 'BP'
244: );
245: --

Line 292: when hr_api.cannot_find_prog_unit then

288: ,p_value_char => p_value_char
289: ,p_effective_date => trunc(p_effective_date)
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_ROUTING_HIST_ATTRIB'
295: ,p_hook_type => 'AP'
296: );

Line 293: hr_api.cannot_find_prog_unit_error

289: ,p_effective_date => trunc(p_effective_date)
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_ROUTING_HIST_ATTRIB'
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_ROUTING_HIST_ATTRIB'
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_ROUTING_HIST_ATTRIB'
385: ,p_hook_type => 'BP'
386: );
387: --

Line 409: when hr_api.cannot_find_prog_unit then

405: ,p_object_version_number => l_object_version_number
406: ,p_effective_date => trunc(p_effective_date)
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'DELETE_ROUTING_HIST_ATTRIB'
412: ,p_hook_type => 'AP'
413: );

Line 410: hr_api.cannot_find_prog_unit_error

406: ,p_effective_date => trunc(p_effective_date)
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'DELETE_ROUTING_HIST_ATTRIB'
412: ,p_hook_type => 'AP'
413: );
414: --

Line 424: raise hr_api.validate_enabled;

420: --
421: -- When in validation only mode raise the Validate_Enabled exception
422: --
423: if p_validate then
424: raise hr_api.validate_enabled;
425: end if;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 70);
428: --

Line 431: when hr_api.validate_enabled then

427: hr_utility.set_location(' Leaving:'||l_proc, 70);
428: --
429: exception
430: --
431: when hr_api.validate_enabled then
432: --
433: -- As the Validate_Enabled exception has been raised
434: -- we must rollback to the savepoint
435: --