3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_approval_period_comps_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_period_comps >----------------|
11: -- ----------------------------------------------------------------------------
28: l_approval_period_comp_id hxc_approval_period_comps.approval_period_comp_id%TYPE;
29: --
30: Begin
31: --
32: g_debug:=hr_utility.debug_enabled;
33: if g_debug then
34: l_proc := g_package||'create_approval_period_comps';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
31: --
32: g_debug:=hr_utility.debug_enabled;
33: if g_debug then
34: l_proc := g_package||'create_approval_period_comps';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
37: --
38: -- Issue a savepoint
39: --
39: --
40: savepoint create_approval_period_comps;
41: --
42: if g_debug then
43: hr_utility.set_location(l_proc, 20);
44: end if;
45: --
46: -- Truncate the time portion from all IN date parameters
47: --
66: );
67: end;
68: --
69: if g_debug then
70: hr_utility.set_location(l_proc, 30);
71: end if;
72: --
73:
74: --
80: --
81: -- Process Logic
82: --
83: if g_debug then
84: hr_utility.set_location(l_proc, 40);
85: end if;
86: --
87: -- call row handler
88: --
95: ,p_object_version_number => l_object_version_number
96: );
97: --
98: if g_debug then
99: hr_utility.set_location(l_proc, 50);
100: end if;
101: --
102: -- Call After Process User Hook
103: --
118: );
119: end;
120: --
121: if g_debug then
122: hr_utility.set_location(l_proc, 60);
123: end if;
124: --
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: --if g_debug then
133: --hr_utility.set_location(' Leaving:'||l_proc, 70);
134: --end if;
135: --
136: --
137: -- Set all output arguments
139: p_approval_period_comp_id := l_approval_period_comp_id;
140: p_object_version_number := l_object_version_number;
141: --
142: if g_debug then
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: end if;
145: exception
146: when hr_api.validate_enabled then
147: --
156: --
157: p_approval_period_comp_id := null;
158: p_object_version_number := null;
159: if g_debug then
160: hr_utility.set_location(' Leaving:'||l_proc, 80);
161: end if;
162: when others then
163: --
164: -- A validation or unexpected error has occured
164: -- A validation or unexpected error has occured
165: --
166: rollback to create_approval_period_comps;
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 90);
169: end if;
170: raise;
171: --
172: end create_approval_period_comps;
192: l_object_version_number hxc_approval_period_comps.object_version_number%TYPE := p_object_version_number;
193: --
194: Begin
195: --
196: g_debug:=hr_utility.debug_enabled;
197: if g_debug then
198: l_proc := g_package||' update_approval_period_comps';
199: hr_utility.set_location('Entering:'|| l_proc, 10);
200: end if;
195: --
196: g_debug:=hr_utility.debug_enabled;
197: if g_debug then
198: l_proc := g_package||' update_approval_period_comps';
199: hr_utility.set_location('Entering:'|| l_proc, 10);
200: end if;
201: --
202: -- Issue a savepoint if operating in validation only mode
203: --
203: --
204: savepoint update_approval_period_comps;
205: --
206: if g_debug then
207: hr_utility.set_location(l_proc, 20);
208: end if;
209: --
210: -- Call Before Process User Hook
211: --
228: --
229: --insert into mtemp values('out of comp_b');
230: --commit;
231: --if g_debug then
232: --hr_utility.set_location(l_proc, 30);
233: --end if;
234: --
235: -- Process Logic
236: --
251: --insert into mtemp values('out of hax_hac_upd');
252: --commit;
253:
254: if g_debug then
255: hr_utility.set_location(l_proc, 40);
256: end if;
257: --
258: -- Call After Process User Hook
259: --
277: --insert into mtemp values('out of comp_a');
278: --commit;
279:
280: if g_debug then
281: hr_utility.set_location(l_proc, 50);
282: end if;
283: --
284: -- When in validation only mode raise the Validate_Enabled exception
285: --
287: raise hr_api.validate_enabled;
288: end if;
289: --
290: if g_debug then
291: hr_utility.set_location(' Leaving:'||l_proc, 60);
292: end if;
293: --
294: -- Set all output arguments
295: --
319: --insert into mtemp values('OVN set to null');
320: --commit;
321:
322: if g_debug then
323: hr_utility.set_location(' Leaving:'||l_proc, 60);
324: end if;
325: --
326: when others then
327: --
328: -- A validation or unexpected error has occured
329: --
330: ROLLBACK TO update_approval_period_comps;
331: if g_debug then
332: hr_utility.set_location(' Leaving:'||l_proc, 70);
333: end if;
334: raise;
335: --
336: END update_approval_period_comps;
350: l_proc varchar2(72);
351: --
352: begin
353: --
354: g_debug:=hr_utility.debug_enabled;
355: if g_debug then
356: l_proc := g_package||'delete_approval_period_comps';
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358: end if;--
353: --
354: g_debug:=hr_utility.debug_enabled;
355: if g_debug then
356: l_proc := g_package||'delete_approval_period_comps';
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358: end if;--
359: -- Issue a savepoint if operating in validation only mode
360: --
361: savepoint delete_approval_period_comps;
360: --
361: savepoint delete_approval_period_comps;
362: --
363: if g_debug then
364: hr_utility.set_location(l_proc, 20);
365: end if;
366: --
367: -- Call Before Process User Hook
368: --
380: );
381: end;
382: --
383: if g_debug then
384: hr_utility.set_location(l_proc, 30);
385: end if;
386: --
387: -- Process Logic
388: --
392: ,p_object_version_number => p_object_version_number
393: );
394: --
395: if g_debug then
396: hr_utility.set_location(l_proc, 40);
397: end if;
398: --
399: -- Call After Process User Hook
400: --
418: raise hr_api.validate_enabled;
419: end if;
420: --
421: if g_debug then
422: hr_utility.set_location(' Leaving:'||l_proc, 50);
423: end if;
424: --
425: exception
426: --