60: ,p_legislation_code => p_legislation_code
61: ,p_usage_type => p_usage_type
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'create_element_type_usage_b'
67: ,p_hook_type => 'BP'
68: );
61: ,p_usage_type => p_usage_type
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'create_element_type_usage_b'
67: ,p_hook_type => 'BP'
68: );
69: end;
109: ,p_effective_start_date => l_effective_start_date
110: ,p_effective_end_date => l_effective_end_date
111: );
112: exception
113: when hr_api.cannot_find_prog_unit then
114: hr_api.cannot_find_prog_unit_error
115: (p_module_name => 'create_element_type_usage_a'
116: ,p_hook_type => 'AP'
117: );
110: ,p_effective_end_date => l_effective_end_date
111: );
112: exception
113: when hr_api.cannot_find_prog_unit then
114: hr_api.cannot_find_prog_unit_error
115: (p_module_name => 'create_element_type_usage_a'
116: ,p_hook_type => 'AP'
117: );
118: end;
120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: if p_validate then
124: raise hr_api.validate_enabled;
125: end if;
126: --
127: -- Set all output arguments
128: --
132: p_effective_end_date := l_effective_end_date;
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 70);
135: exception
136: when hr_api.validate_enabled then
137: --
138: -- As the Validate_Enabled exception has been raised
139: -- we must rollback to the savepoint
140: --
169: procedure update_element_type_usage
170: (p_validate in boolean default false
171: ,p_effective_date in date
172: ,p_datetrack_update_mode in varchar2
173: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
174: ,p_element_type_usage_id in number
175: ,p_object_version_number in out nocopy number
176: ,p_business_group_id in number default hr_api.g_number
177: ,p_legislation_code in varchar2 default hr_api.g_varchar2
172: ,p_datetrack_update_mode in varchar2
173: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
174: ,p_element_type_usage_id in number
175: ,p_object_version_number in out nocopy 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_usage_type in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date
173: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
174: ,p_element_type_usage_id in number
175: ,p_object_version_number in out nocopy 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_usage_type in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date
181: ) is
174: ,p_element_type_usage_id in number
175: ,p_object_version_number in out nocopy 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_usage_type in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date
181: ) is
182: --
220: ,p_legislation_code => p_legislation_code
221: ,p_usage_type => p_usage_type
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'update_element_type_usage_b'
227: ,p_hook_type => 'BP'
228: );
221: ,p_usage_type => p_usage_type
222: );
223: exception
224: when hr_api.cannot_find_prog_unit then
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'update_element_type_usage_b'
227: ,p_hook_type => 'BP'
228: );
229: end;
265: ,p_effective_start_date => l_effective_start_date
266: ,p_effective_end_date => l_effective_end_date
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'update_element_type_usage_a'
272: ,p_hook_type => 'AP'
273: );
266: ,p_effective_end_date => l_effective_end_date
267: );
268: exception
269: when hr_api.cannot_find_prog_unit then
270: hr_api.cannot_find_prog_unit_error
271: (p_module_name => 'update_element_type_usage_a'
272: ,p_hook_type => 'AP'
273: );
274: end;
276: --
277: -- When in validation only mode raise the Validate_Enabled exception
278: --
279: if p_validate then
280: raise hr_api.validate_enabled;
281: end if;
282: --
283: -- Set all output arguments
284: --
287: p_effective_end_date := l_effective_end_date;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 70);
290: exception
291: when hr_api.validate_enabled then
292: --
293: -- As the Validate_Enabled exception has been raised
294: -- we must rollback to the savepoint
295: --
321: ,p_effective_date in date
322: ,p_datetrack_delete_mode in varchar2
323: ,p_element_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_element_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: --
366: ,p_business_group_id => p_business_group_id
367: ,p_legislation_code => p_legislation_code
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'delete_element_type_usage_b'
373: ,p_hook_type => 'BP'
374: );
367: ,p_legislation_code => p_legislation_code
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'delete_element_type_usage_b'
373: ,p_hook_type => 'BP'
374: );
375: end;
407: ,p_effective_start_date => l_effective_start_date
408: ,p_effective_end_date => l_effective_end_date
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'delete_element_type_usage_a'
414: ,p_hook_type => 'AP'
415: );
408: ,p_effective_end_date => l_effective_end_date
409: );
410: exception
411: when hr_api.cannot_find_prog_unit then
412: hr_api.cannot_find_prog_unit_error
413: (p_module_name => 'delete_element_type_usage_a'
414: ,p_hook_type => 'AP'
415: );
416: end;
418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then
422: raise hr_api.validate_enabled;
423: end if;
424: --
425: -- Set all output arguments
426: --
429: p_effective_end_date := l_effective_end_date;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 70);
432: exception
433: when hr_api.validate_enabled then
434: --
435: -- As the Validate_Enabled exception has been raised
436: -- we must rollback to the savepoint
437: --