4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_category_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_time_category >---------------------------|
12: -- ----------------------------------------------------------------------------
27: l_object_version_number hxc_time_categories.object_version_number%TYPE;
28: l_time_category_id hxc_time_categories.time_category_id%TYPE;
29:
30: begin
31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||' create_time_category';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||' create_time_category';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
37: --
38: -- Issue a savepoint if operating in validation only mode
39: --
39: --
40: savepoint create_time_category;
41: --
42: if g_debug then
43: hr_utility.set_location(l_proc, 20);
44: end if;
45: --
46: -- Call Before Process User Hook
47: --
62: );
63: end;
64: --
65: if g_debug then
66: hr_utility.set_location(l_proc, 30);
67: end if;
68: --
69: -- Process Logic
70: --
69: -- Process Logic
70: --
71: --
72: if g_debug then
73: hr_utility.set_location(l_proc, 40);
74: end if;
75: --
76: -- call row handler
77: --
83: ,p_time_category_id => l_time_category_id
84: ,p_object_version_number => l_object_version_number );
85: --
86: if g_debug then
87: hr_utility.set_location(l_proc, 50);
88: end if;
89: --
90: -- Call After Process User Hook
91: --
106: );
107: end;
108: --
109: if g_debug then
110: hr_utility.set_location(l_proc, 60);
111: end if;
112: --
113: -- When in validation only mode raise the Validate_Enabled exception
114: --
116: raise hr_api.validate_enabled;
117: end if;
118: --
119: if g_debug then
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: end if;
122: --
123: -- Set all output arguments
124: --
141: p_time_category_id := null;
142: p_object_version_number := null;
143: --
144: if g_debug then
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: end if;
147: --
148: when others then
149: --
149: --
150: -- A validation or unexpected error has occured
151: --
152: if g_debug then
153: hr_utility.trace('In exeception');
154: end if;
155: ROLLBACK TO create_time_category;
156: raise;
157: --
177: l_proc varchar2(72) ;
178: l_object_version_number hxc_time_categories.object_version_number%TYPE := p_object_version_number;
179:
180: begin
181: g_debug := hr_utility.debug_enabled;
182: --
183: if g_debug then
184: l_proc := g_package||' update_time_category';
185: hr_utility.set_location('Entering:'|| l_proc, 10);
181: g_debug := hr_utility.debug_enabled;
182: --
183: if g_debug then
184: l_proc := g_package||' update_time_category';
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: end if;
187: --
188: -- Issue a savepoint if operating in validation only mode
189: --
189: --
190: savepoint update_time_category;
191: --
192: if g_debug then
193: hr_utility.set_location(l_proc, 20);
194: end if;
195: --
196: -- Call Before Process User Hook
197: --
212: );
213: end;
214: --
215: if g_debug then
216: hr_utility.set_location(l_proc, 30);
217: end if;
218: --
219: -- Process Logic
220: --
229: ,p_object_version_number => l_object_version_number );
230: --
231: --
232: if g_debug then
233: hr_utility.set_location(l_proc, 40);
234: end if;
235: --
236: -- Call After Process User Hook
237: --
251: );
252: end;
253: --
254: if g_debug then
255: hr_utility.set_location(l_proc, 50);
256: end if;
257: --
258: -- When in validation only mode raise the Validate_Enabled exception
259: --
261: raise hr_api.validate_enabled;
262: end if;
263: --
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc, 60);
266: end if;
267: --
268: -- Set all output arguments
269: --
284: --
285: p_object_version_number := null;
286: --
287: if g_debug then
288: hr_utility.set_location(' Leaving:'||l_proc, 60);
289: end if;
290: --
291: when others then
292: --
292: --
293: -- A validation or unexpected error has occured
294: --
295: if g_debug then
296: hr_utility.trace('In exeception');
297: end if;
298: ROLLBACK TO update_time_category;
299: raise;
300: --
315: --
316: l_proc varchar2(72) ;
317: --
318: begin
319: g_debug := hr_utility.debug_enabled;
320: --
321: if g_debug then
322: l_proc := g_package||'delete_time_category';
323: hr_utility.set_location('Entering:'|| l_proc, 10);
319: g_debug := hr_utility.debug_enabled;
320: --
321: if g_debug then
322: l_proc := g_package||'delete_time_category';
323: hr_utility.set_location('Entering:'|| l_proc, 10);
324: end if;
325: --
326: -- Issue a savepoint if operating in validation only mode
327: --
327: --
328: savepoint delete_time_category;
329: --
330: if g_debug then
331: hr_utility.set_location(l_proc, 20);
332: end if;
333: --
334: -- Call Before Process User Hook
335: --
348: );
349: end;
350: --
351: if g_debug then
352: hr_utility.set_location(l_proc, 30);
353: end if;
354: --
355: -- Process Logic
356: --
361: ,p_object_version_number => p_object_version_number
362: );
363: --
364: if g_debug then
365: hr_utility.set_location(l_proc, 40);
366: end if;
367: --
368: -- Call After Process User Hook
369: --
388: raise hr_api.validate_enabled;
389: end if;
390: --
391: if g_debug then
392: hr_utility.set_location(' Leaving:'||l_proc, 50);
393: end if;
394: --
395: exception
396: --
417: l_operator hxc_time_categories.operator%TYPE;
418:
419: BEGIN
420:
421: g_debug := hr_utility.debug_enabled;
422:
423: hxc_time_category_utils_pkg.mapping_component_string (
424: p_time_category_id => p_time_category_id
425: , p_time_sql => l_time_sql );
424: p_time_category_id => p_time_category_id
425: , p_time_sql => l_time_sql );
426:
427: if g_debug then
428: hr_utility.trace('set dyn sql string string is '||l_time_sql);
429: end if;
430:
431: UPDATE hxc_time_categories
432: SET time_sql = l_time_sql
434:
435: exception when others then
436:
437: if g_debug then
438: hr_utility.trace('exception is '||SQLERRM);
439: end if;
440:
441: raise;
442: