3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_approval_period_sets_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_period_sets >-----------------|
11: -- ----------------------------------------------------------------------------
26: l_approval_period_set_id hxc_approval_period_sets.approval_period_set_id%TYPE;
27: --
28: Begin
29: --
30: g_debug:=hr_utility.debug_enabled;
31: if g_debug then
32: l_proc := g_package||'create_approval_period_sets';
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: end if;--
29: --
30: g_debug:=hr_utility.debug_enabled;
31: if g_debug then
32: l_proc := g_package||'create_approval_period_sets';
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: end if;--
35: -- Issue a savepoint
36: --
37: savepoint create_approval_period_sets;
36: --
37: savepoint create_approval_period_sets;
38: --
39: if g_debug then
40: hr_utility.set_location(l_proc, 20);
41: end if;
42: --
43: -- Truncate the time portion from all IN date parameters
44: --
61: );
62: end;
63: --
64: if g_debug then
65: hr_utility.set_location(l_proc, 30);
66: end if;
67: --
68:
69: --
75: --
76: -- Process Logic
77: --
78: if g_debug then
79: hr_utility.set_location(l_proc, 40);
80: end if;
81: --
82: -- call row handler
83: --
87: ,p_object_version_number => l_object_version_number
88: );
89: --
90: if g_debug then
91: hr_utility.set_location(l_proc, 50);
92: end if;
93: --
94: -- Call After Process User Hook
95: --
108: );
109: end;
110: --
111: if g_debug then
112: hr_utility.set_location(l_proc, 60);
113: end if;
114: --
115: --
116: -- When in validation only mode raise the Validate_Enabled exception
119: raise hr_api.validate_enabled;
120: end if;
121: --
122: --if g_debug then
123: --hr_utility.set_location(' Leaving:'||l_proc, 70);
124: --end if;
125: --
126: --
127: -- Set all output arguments
129: p_approval_period_set_id := l_approval_period_set_id;
130: p_object_version_number := l_object_version_number;
131: --
132: if g_debug then
133: hr_utility.set_location(' Leaving:'||l_proc, 70);
134: end if;
135: exception
136: when hr_api.validate_enabled then
137: --
146: --
147: p_approval_period_set_id := null;
148: p_object_version_number := null;
149: if g_debug then
150: hr_utility.set_location(' Leaving:'||l_proc, 80);
151: end if;
152: when others then
153: --
154: -- A validation or unexpected error has occured
154: -- A validation or unexpected error has occured
155: --
156: rollback to create_approval_period_sets;
157: if g_debug then
158: hr_utility.set_location(' Leaving:'||l_proc, 90);
159: end if;
160: raise;
161: --
162: end create_approval_period_sets;
179: l_proc varchar2(72);
180: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE := p_object_version_number;
181: --
182: Begin
183: g_debug:=hr_utility.debug_enabled;
184: --
185: if g_debug then
186: l_proc := g_package||' update_approval_period_sets';
187: hr_utility.set_location('Entering:'|| l_proc, 10);
183: g_debug:=hr_utility.debug_enabled;
184: --
185: if g_debug then
186: l_proc := g_package||' update_approval_period_sets';
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: end if;
189: --
190: -- Issue a savepoint if operating in validation only mode
191: --
191: --
192: savepoint update_approval_period_sets;
193: --
194: if g_debug then
195: hr_utility.set_location(l_proc, 20);
196: end if;
197: --
198: -- Call Before Process User Hook
199: --
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: --
227: );
228: --
229: --
230: if g_debug then
231: hr_utility.set_location(l_proc, 40);
232: end if;
233: --
234: -- Call After Process User Hook
235: --
248: );
249: end;
250: --
251: if g_debug then
252: hr_utility.set_location(l_proc, 50);
253: end if;
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
258: raise hr_api.validate_enabled;
259: end if;
260: --
261: if g_debug then
262: hr_utility.set_location(' Leaving:'||l_proc, 60);
263: end if;
264: --
265: -- Set all output arguments
266: --
281: --
282: p_object_version_number := null;
283: --
284: if g_debug then
285: hr_utility.set_location(' Leaving:'||l_proc, 60);
286: end if;
287: --
288: when others then
289: --
290: -- A validation or unexpected error has occured
291: --
292: ROLLBACK TO update_approval_period_sets;
293: if g_debug then
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: end if;
296: raise;
297: --
298: END update_approval_period_sets;
311: --
312: l_proc varchar2(72);
313: --
314: begin
315: g_debug:=hr_utility.debug_enabled;
316: --
317: if g_debug then
318: l_proc := g_package||'delete_approval_period_sets';
319: hr_utility.set_location('Entering:'|| l_proc, 10);
315: g_debug:=hr_utility.debug_enabled;
316: --
317: if g_debug then
318: l_proc := g_package||'delete_approval_period_sets';
319: hr_utility.set_location('Entering:'|| l_proc, 10);
320: end if;
321: --
322: -- Issue a savepoint if operating in validation only mode
323: --
323: --
324: savepoint delete_approval_period_sets;
325: --
326: if g_debug then
327: hr_utility.set_location(l_proc, 20);
328: end if;
329: --
330: -- Call Before Process User Hook
331: --
343: );
344: end;
345: --
346: if g_debug then
347: hr_utility.set_location(l_proc, 30);
348: end if;
349: --
350: -- Process Logic
351: --
355: ,p_object_version_number => p_object_version_number
356: );
357: --
358: if g_debug then
359: hr_utility.set_location(l_proc, 40);
360: end if;
361: --
362: -- Call After Process User Hook
363: --
381: raise hr_api.validate_enabled;
382: end if;
383: --
384: if g_debug then
385: hr_utility.set_location(' Leaving:'||l_proc, 50);
386: end if;
387: --
388: exception
389: --