[Home] [Help]
36: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
37: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
38: --
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Issue a savepoint
43: --
44: savepoint create_element_type_usage;
45: --
46: -- Truncate the time portion from all IN date parameters
47: --
48: l_effective_date := trunc(p_effective_date);
49: hr_utility.set_location(l_proc, 20);
50: --
51: -- Call Before Process User Hook
52: --
53: begin
66: (p_module_name => 'create_element_type_usage_b'
67: ,p_hook_type => 'BP'
68: );
69: end;
70: hr_utility.set_location(l_proc, 30);
71: --
72: -- Validation in addition to Row Handlers
73: --
74: hr_utility.set_location(l_proc, 40);
70: hr_utility.set_location(l_proc, 30);
71: --
72: -- Validation in addition to Row Handlers
73: --
74: hr_utility.set_location(l_proc, 40);
75: --
76: -- Process Logic
77: --
78: -- Call the row handler
90: ,p_effective_start_date => l_effective_start_date
91: ,p_effective_end_date => l_effective_end_date
92: );
93: --
94: hr_utility.set_location(l_proc, 50);
95: --
96: -- Call After Process User Hook
97: --
98: begin
115: (p_module_name => 'create_element_type_usage_a'
116: ,p_hook_type => 'AP'
117: );
118: end;
119: hr_utility.set_location(l_proc, 60);
120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: if p_validate then
130: p_object_version_number := l_object_version_number;
131: p_effective_start_date := l_effective_start_date;
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
147: p_element_type_usage_id := null;
148: p_object_version_number := null;
149: p_effective_start_date := null;
150: p_effective_end_date := null;
151: hr_utility.set_location(' Leaving:'||l_proc, 80);
152: when others then
153: --
154: -- A validation or unexpected error has occured
155: --
157: p_element_type_usage_id := null;
158: p_object_version_number := null;
159: p_effective_start_date := null;
160: p_effective_end_date := null;
161: hr_utility.set_location(' Leaving:'||l_proc, 90);
162: raise;
163: end create_element_type_usage;
164: --
165: -- ----------------------------------------------------------------------------
194: --
195: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
196: --
197: begin
198: hr_utility.set_location('Entering:'|| l_proc, 10);
199: --
200: -- Issue a savepoint and assign IN OUT parameters to local variables
201: --
202: l_object_version_number := p_object_version_number;
204: --
205: -- Truncate the time portion from all IN date parameters
206: --
207: l_effective_date := trunc(p_effective_date);
208: hr_utility.set_location(l_proc, 20);
209: --
210: -- Call Before Process User Hook
211: --
212: begin
226: (p_module_name => 'update_element_type_usage_b'
227: ,p_hook_type => 'BP'
228: );
229: end;
230: hr_utility.set_location(l_proc, 30);
231: --
232: -- Validation in addition to Row Handlers
233: --
234: hr_utility.set_location(l_proc, 40);
230: hr_utility.set_location(l_proc, 30);
231: --
232: -- Validation in addition to Row Handlers
233: --
234: hr_utility.set_location(l_proc, 40);
235: --
236: -- Process Logic
237: --
238: -- Call the row handler
247: ,p_effective_start_date => l_effective_start_date
248: ,p_effective_end_date => l_effective_end_date
249: );
250: --
251: hr_utility.set_location(l_proc, 50);
252: --
253: -- Call After Process User Hook
254: --
255: begin
271: (p_module_name => 'update_element_type_usage_a'
272: ,p_hook_type => 'AP'
273: );
274: end;
275: hr_utility.set_location(l_proc, 60);
276: --
277: -- When in validation only mode raise the Validate_Enabled exception
278: --
279: if p_validate then
285: p_object_version_number := p_object_version_number;
286: p_effective_start_date := l_effective_start_date;
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
301: --
302: p_object_version_number := l_object_version_number;
303: p_effective_start_date := null;
304: p_effective_end_date := null;
305: hr_utility.set_location(' Leaving:'||l_proc, 80);
306: when others then
307: --
308: -- A validation or unexpected error has occured
309: --
307: --
308: -- A validation or unexpected error has occured
309: --
310: rollback to update_element_type_usage;
311: hr_utility.set_location(' Leaving:'||l_proc, 90);
312: raise;
313: end update_element_type_usage;
314: --
315: -- ----------------------------------------------------------------------------
342: --
343: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
344: --
345: begin
346: hr_utility.set_location('Entering:'|| l_proc, 10);
347: --
348: -- Issue a savepoint and assign IN OUT parameters to local variables
349: --
350: l_object_version_number := p_object_version_number;
352: --
353: -- Truncate the time portion from all IN date parameters
354: --
355: l_effective_date := trunc(p_effective_date);
356: hr_utility.set_location(l_proc, 20);
357: --
358: -- Call Before Process User Hook
359: --
360: begin
372: (p_module_name => 'delete_element_type_usage_b'
373: ,p_hook_type => 'BP'
374: );
375: end;
376: hr_utility.set_location(l_proc, 30);
377: --
378: -- Validation in addition to Row Handlers
379: --
380: hr_utility.set_location(l_proc, 40);
376: hr_utility.set_location(l_proc, 30);
377: --
378: -- Validation in addition to Row Handlers
379: --
380: hr_utility.set_location(l_proc, 40);
381: --
382: -- Process Logic
383: --
384: -- Call the row handler
391: ,p_effective_start_date => l_effective_start_date
392: ,p_effective_end_date => l_effective_end_date
393: );
394: --
395: hr_utility.set_location(l_proc, 50);
396: --
397: -- Call After Process User Hook
398: --
399: begin
413: (p_module_name => 'delete_element_type_usage_a'
414: ,p_hook_type => 'AP'
415: );
416: end;
417: hr_utility.set_location(l_proc, 60);
418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then
427: p_object_version_number := p_object_version_number;
428: p_effective_start_date := l_effective_start_date;
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
443: --
444: p_object_version_number := l_object_version_number;
445: p_effective_start_date := null;
446: p_effective_end_date := null;
447: hr_utility.set_location(' Leaving:'||l_proc, 80);
448: when others then
449: --
450: -- A validation or unexpected error has occured
451: --
449: --
450: -- A validation or unexpected error has occured
451: --
452: rollback to delete_element_type_usage;
453: hr_utility.set_location(' Leaving:'||l_proc, 90);
454: raise;
455: end delete_element_type_usage;
456: --
457: end pay_element_type_usage_api;