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