58: ,p_business_group_id => p_business_group_id
59: ,p_legislation_code => p_legislation_code
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_run_type_usage'
65: ,p_hook_type => 'BP'
66: );
59: ,p_legislation_code => p_legislation_code
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'create_run_type_usage'
65: ,p_hook_type => 'BP'
66: );
67: end;
105: ,p_effective_end_date => l_effective_end_date
106: ,p_object_version_number => l_object_version_number
107: );
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'create_run_type_usage'
112: ,p_hook_type => 'AP'
113: );
106: ,p_object_version_number => l_object_version_number
107: );
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'create_run_type_usage'
112: ,p_hook_type => 'AP'
113: );
114: end;
116: --
117: -- When in validation only mode raise the Validate_Enabled exception
118: --
119: if p_validate then
120: raise hr_api.validate_enabled;
121: end if;
122: --
123: -- Set all output arguments
124: --
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: exception
132: when hr_api.validate_enabled then
133: --
134: -- As the Validate_Enabled exception has been raised
135: -- we must rollback to the savepoint
136: --
171: ,p_effective_date in date
172: ,p_datetrack_update_mode in varchar2
173: ,p_run_type_usage_id in number
174: ,p_object_version_number in out nocopy number
175: ,p_sequence in number default hr_api.g_number
176: ,p_business_group_id in number default hr_api.g_number
177: ,p_legislation_code in varchar2 default hr_api.g_varchar2
178: ,p_effective_start_date out nocopy date
179: ,p_effective_end_date out nocopy date
172: ,p_datetrack_update_mode in varchar2
173: ,p_run_type_usage_id in number
174: ,p_object_version_number in out nocopy number
175: ,p_sequence in number default hr_api.g_number
176: ,p_business_group_id in number default hr_api.g_number
177: ,p_legislation_code in varchar2 default hr_api.g_varchar2
178: ,p_effective_start_date out nocopy date
179: ,p_effective_end_date out nocopy date
180: ) is
173: ,p_run_type_usage_id in number
174: ,p_object_version_number in out nocopy number
175: ,p_sequence in number default hr_api.g_number
176: ,p_business_group_id in number default hr_api.g_number
177: ,p_legislation_code in varchar2 default hr_api.g_varchar2
178: ,p_effective_start_date out nocopy date
179: ,p_effective_end_date out nocopy date
180: ) is
181: --
218: ,p_business_group_id => p_business_group_id
219: ,p_legislation_code => p_legislation_code
220: );
221: exception
222: when hr_api.cannot_find_prog_unit then
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'update_run_type_usage'
225: ,p_hook_type => 'BP'
226: );
219: ,p_legislation_code => p_legislation_code
220: );
221: exception
222: when hr_api.cannot_find_prog_unit then
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'update_run_type_usage'
225: ,p_hook_type => 'BP'
226: );
227: end;
259: ,p_effective_start_date => l_effective_start_date
260: ,p_effective_end_date => l_effective_end_date
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'update_run_type_usage'
266: ,p_hook_type => 'AP'
267: );
260: ,p_effective_end_date => l_effective_end_date
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'update_run_type_usage'
266: ,p_hook_type => 'AP'
267: );
268: end;
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then
274: raise hr_api.validate_enabled;
275: end if;
276: --
277: -- Set all output arguments
278: --
281: p_object_version_number := p_object_version_number;
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 70);
284: exception
285: when hr_api.validate_enabled then
286: --
287: -- As the Validate_Enabled exception has been raised
288: -- we must rollback to the savepoint
289: --
321: ,p_effective_date in date
322: ,p_datetrack_delete_mode in varchar2
323: ,p_run_type_usage_id in number
324: ,p_object_version_number in out nocopy number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_legislation_code in varchar2 default hr_api.g_varchar2
327: ,p_effective_start_date out nocopy date
328: ,p_effective_end_date out nocopy date
329: ) is
322: ,p_datetrack_delete_mode in varchar2
323: ,p_run_type_usage_id in number
324: ,p_object_version_number in out nocopy number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_legislation_code in varchar2 default hr_api.g_varchar2
327: ,p_effective_start_date out nocopy date
328: ,p_effective_end_date out nocopy date
329: ) is
330: --
363: ,p_business_group_id => p_business_group_id
364: ,p_legislation_code => p_legislation_code
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_run_type_usage'
370: ,p_hook_type => 'BP'
371: );
364: ,p_legislation_code => p_legislation_code
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: (p_module_name => 'delete_run_type_usage'
370: ,p_hook_type => 'BP'
371: );
372: end;
404: ,p_effective_start_date => l_effective_start_date
405: ,p_effective_end_date => l_effective_end_date
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'delete_run_type_usage'
411: ,p_hook_type => 'AP'
412: );
405: ,p_effective_end_date => l_effective_end_date
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'delete_run_type_usage'
411: ,p_hook_type => 'AP'
412: );
413: end;
415: --
416: -- When in validation only mode raise the Validate_Enabled exception
417: --
418: if p_validate then
419: raise hr_api.validate_enabled;
420: end if;
421: --
422: -- Set out parameters
423: --
426: p_effective_end_date := l_effective_end_date;
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 70);
429: exception
430: when hr_api.validate_enabled then
431: --
432: -- As the Validate_Enabled exception has been raised
433: -- we must rollback to the savepoint
434: --