4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_category_comp_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_time_category_comp>----------------------|
12: -- ----------------------------------------------------------------------------
34:
35: l_validation_type varchar2(5) := NULL;
36:
37: begin
38: g_debug := hr_utility.debug_enabled;
39: --
40: if g_debug then
41: l_proc := g_package||' create_time_category_comp';
42: hr_utility.set_location('Entering:'|| l_proc, 10);
38: g_debug := hr_utility.debug_enabled;
39: --
40: if g_debug then
41: l_proc := g_package||' create_time_category_comp';
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: end if;
44: --
45: -- Issue a savepoint if operating in validation only mode
46: --
46: --
47: savepoint create_time_category_comp;
48: --
49: if g_debug then
50: hr_utility.set_location(l_proc, 20);
51: end if;
52:
53: --Changes for bug 14524515 start
54: /*
52:
53: --Changes for bug 14524515 start
54: /*
55: if g_debug then
56: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
57: end if;
58:
59: if (p_type = 'MC' and nvl(p_flex_value_set_id,0) > 0 )
60: then
85:
86: -- Bug 16002606 start
87:
88: if g_debug then
89: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
90: end if;
91:
92:
93: /* IF p_type = 'MC'
144: );
145: end;
146: --
147: if g_debug then
148: hr_utility.set_location(l_proc, 30);
149: end if;
150: --
151: -- Process Logic
152: --
151: -- Process Logic
152: --
153: --
154: if g_debug then
155: hr_utility.set_location(l_proc, 40);
156: end if;
157: --
158: -- call row handler
159: --
170: ,p_object_version_number => l_object_version_number
171: );
172: --
173: if g_debug then
174: hr_utility.set_location(l_proc, 50);
175: end if;
176:
177:
178: -- Bug 13817976
210: );
211: end;
212: --
213: if g_debug then
214: hr_utility.set_location(l_proc, 60);
215: end if;
216: --
217: -- When in validation only mode raise the Validate_Enabled exception
218: --
220: raise hr_api.validate_enabled;
221: end if;
222: --
223: if g_debug then
224: hr_utility.set_location(' Leaving:'||l_proc, 70);
225: end if;
226: --
227: -- Set all output arguments
228: --
245: p_time_category_comp_id := null;
246: p_object_version_number := null;
247: --
248: if g_debug then
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: end if;
251: --
252: when others then
253: --
253: --
254: -- A validation or unexpected error has occured
255: --
256: if g_debug then
257: hr_utility.trace('In exeception');
258: end if;
259: ROLLBACK TO create_time_category_comp;
260: raise;
261: --
285: l_object_version_number hxc_time_category_comps.object_version_number%TYPE := p_object_version_number;
286: --
287: l_validation_type varchar2(5) := NULL;
288: begin
289: g_debug := hr_utility.debug_enabled;
290:
291: if g_debug then
292: l_proc := g_package||' update_time_category_comp';
293: hr_utility.set_location('Entering:'|| l_proc, 10);
289: g_debug := hr_utility.debug_enabled;
290:
291: if g_debug then
292: l_proc := g_package||' update_time_category_comp';
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: end if;
295: --
296: -- Issue a savepoint if operating in validation only mode
297: --
297: --
298: savepoint update_time_category_comp;
299: --
300: if g_debug then
301: hr_utility.set_location(l_proc, 20);
302: end if;
303:
304: -- Bug 16002606 start
305:
303:
304: -- Bug 16002606 start
305:
306: if g_debug then
307: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
308: end if;
309:
310:
311: /* IF p_type = 'MC'
363: );
364: end;
365: --
366: if g_debug then
367: hr_utility.set_location(l_proc, 30);
368: end if;
369: --
370: -- Process Logic
371: --
385: );
386: --
387: --
388: if g_debug then
389: hr_utility.set_location(l_proc, 40);
390: end if;
391:
392: -- Bug 13817976
393: IF p_type IN ('AN','MC')
425: );
426: end;
427: --
428: if g_debug then
429: hr_utility.set_location(l_proc, 50);
430: end if;
431: --
432: -- When in validation only mode raise the Validate_Enabled exception
433: --
435: raise hr_api.validate_enabled;
436: end if;
437: --
438: if g_debug then
439: hr_utility.set_location(' Leaving:'||l_proc, 60);
440: end if;
441: --
442: -- Set all output arguments
443: --
458: --
459: p_object_version_number := null;
460: --
461: if g_debug then
462: hr_utility.set_location(' Leaving:'||l_proc, 60);
463: end if;
464: --
465: when others then
466: --
466: --
467: -- A validation or unexpected error has occured
468: --
469: if g_debug then
470: hr_utility.trace('In exeception');
471: end if;
472: ROLLBACK TO update_time_category_comp;
473: raise;
474: --
488: --
489: l_proc varchar2(72);
490: --
491: begin
492: g_debug := hr_utility.debug_enabled;
493: --
494: if g_debug then
495: l_proc := g_package||'delete_time_category_comp';
496: hr_utility.set_location('Entering:'|| l_proc, 10);
492: g_debug := hr_utility.debug_enabled;
493: --
494: if g_debug then
495: l_proc := g_package||'delete_time_category_comp';
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497: end if;
498: --
499: -- Issue a savepoint if operating in validation only mode
500: --
500: --
501: savepoint delete_time_category_comp;
502: --
503: if g_debug then
504: hr_utility.set_location(l_proc, 20);
505: end if;
506: --
507: -- Call Before Process User Hook
508: --
520: );
521: end;
522: --
523: if g_debug then
524: hr_utility.set_location(l_proc, 30);
525: end if;
526: --
527: -- Process Logic
528: --
532: ,p_object_version_number => p_object_version_number
533: );
534: --
535: if g_debug then
536: hr_utility.set_location(l_proc, 40);
537: end if;
538:
539: -- Bug 13817976
540: hxc_time_category_utils_pkg.delete_tc_comps2(p_time_category_comp_id);
562: raise hr_api.validate_enabled;
563: end if;
564: --
565: if g_debug then
566: hr_utility.set_location(' Leaving:'||l_proc, 50);
567: end if;
568: --
569: exception
570: --