4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_entry_rule_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_time_entry_rule>----------------------|
12: -- ----------------------------------------------------------------------------
65: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;
66: --
67: begin
68:
69: g_debug := hr_utility.debug_enabled;
70: --
71:
72: --
73: if g_debug then
71:
72: --
73: if g_debug then
74: l_proc := g_package||' create_time_entry_rule';
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: end if;
77: --
78: -- Issue a savepoint if operating in validation only mode
79: --
79: --
80: savepoint create_time_entry_rule;
81: --
82: if g_debug then
83: hr_utility.set_location(l_proc, 20);
84: end if;
85: --
86: -- Call Before Process User Hook
87: --
138: );
139: end;
140: --
141: if g_debug then
142: hr_utility.set_location(l_proc, 30);
143: end if;
144: --
145: -- Process Logic
146: --
145: -- Process Logic
146: --
147: --
148: if g_debug then
149: hr_utility.set_location(l_proc, 40);
150: end if;
151: --
152: -- call row handler
153: --
196: ,p_time_entry_rule_id => l_time_entry_rule_id
197: ,p_object_version_number => l_object_version_number );
198: --
199: if g_debug then
200: hr_utility.set_location(l_proc, 50);
201: end if;
202: --
203: -- Call After Process User Hook
204: --
256: );
257: end;
258: --
259: if g_debug then
260: hr_utility.set_location(l_proc, 60);
261: end if;
262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: if g_debug then
270: hr_utility.set_location(' Leaving:'||l_proc, 70);
271: end if;
272: --
273: -- Set all output arguments
274: --
291: p_time_entry_rule_id := null;
292: p_object_version_number := null;
293: --
294: if g_debug then
295: hr_utility.set_location(' Leaving:'||l_proc, 80);
296: end if;
297: --
298: when others then
299: --
299: --
300: -- A validation or unexpected error has occured
301: --
302: if g_debug then
303: hr_utility.trace('In exeception');
304: end if;
305: ROLLBACK TO create_time_entry_rule;
306: raise;
307: --
364: l_object_version_number hxc_time_entry_rules.object_version_number%TYPE := p_object_version_number;
365: --
366: begin
367:
368: g_debug := hr_utility.debug_enabled;
369: --
370: if g_debug then
371: l_proc := g_package||' update_time_entry_rule';
372: hr_utility.set_location('Entering:'|| l_proc, 10);
368: g_debug := hr_utility.debug_enabled;
369: --
370: if g_debug then
371: l_proc := g_package||' update_time_entry_rule';
372: hr_utility.set_location('Entering:'|| l_proc, 10);
373: end if;
374:
375: --
376: -- Issue a savepoint if operating in validation only mode
377: --
378: savepoint update_time_entry_rule;
379: --
380: if g_debug then
381: hr_utility.set_location(l_proc, 20);
382: end if;
383: --
384: -- Call Before Process User Hook
385: --
437: );
438: end;
439: --
440: if g_debug then
441: hr_utility.set_location(l_proc, 30);
442: end if;
443: --
444: -- Process Logic
445: --
491: ,p_object_version_number => l_object_version_number );
492: --
493: --
494: if g_debug then
495: hr_utility.set_location(l_proc, 40);
496: end if;
497: --
498: -- Call After Process User Hook
499: --
551: );
552: end;
553: --
554: if g_debug then
555: hr_utility.set_location(l_proc, 50);
556: end if;
557: --
558: -- When in validation only mode raise the Validate_Enabled exception
559: --
561: raise hr_api.validate_enabled;
562: end if;
563: --
564: if g_debug then
565: hr_utility.set_location(' Leaving:'||l_proc, 60);
566: end if;
567: --
568: -- Set all output arguments
569: --
584: --
585: p_object_version_number := null;
586: --
587: if g_debug then
588: hr_utility.set_location(' Leaving:'||l_proc, 60);
589: end if;
590: --
591: when others then
592: --
592: --
593: -- A validation or unexpected error has occured
594: --
595: if g_debug then
596: hr_utility.trace('In exeception');
597: end if;
598: ROLLBACK TO update_time_entry_rule;
599: raise;
600: --
615: l_proc varchar2(72);
616: --
617: begin
618:
619: g_debug := hr_utility.debug_enabled;
620: --
621: if g_debug then
622: l_proc := g_package||'delete_time_entry_rule';
623: hr_utility.set_location('Entering:'|| l_proc, 10);
619: g_debug := hr_utility.debug_enabled;
620: --
621: if g_debug then
622: l_proc := g_package||'delete_time_entry_rule';
623: hr_utility.set_location('Entering:'|| l_proc, 10);
624: end if;
625: --
626: -- Issue a savepoint if operating in validation only mode
627: --
627: --
628: savepoint delete_time_entry_rule;
629: --
630: if g_debug then
631: hr_utility.set_location(l_proc, 20);
632: end if;
633: --
634: -- Call Before Process User Hook
635: --
647: );
648: end;
649: --
650: if g_debug then
651: hr_utility.set_location(l_proc, 30);
652: end if;
653: --
654: -- Process Logic
655: --
659: ,p_object_version_number => p_object_version_number
660: );
661: --
662: if g_debug then
663: hr_utility.set_location(l_proc, 40);
664: end if;
665: --
666: -- Call After Process User Hook
667: --
685: raise hr_api.validate_enabled;
686: end if;
687: --
688: if g_debug then
689: hr_utility.set_location(' Leaving:'||l_proc, 50);
690: end if;
691: --
692: exception
693: --