3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_source_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_time_source >----------------------------|
11: -- ----------------------------------------------------------------------------
23: l_object_version_number hxc_time_sources.object_version_number%TYPE;
24: l_time_source_id hxc_time_sources.time_source_id%TYPE;
25: --
26: begin
27: g_debug := hr_utility.debug_enabled;
28: --
29: --
30: if g_debug then
31: l_proc := g_package||' create_time_source';
28: --
29: --
30: if g_debug then
31: l_proc := g_package||' create_time_source';
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: end if;
34: --
35: -- Issue a savepoint if operating in validation only mode
36: --
36: --
37: savepoint create_time_source;
38: --
39: if g_debug then
40: hr_utility.set_location(l_proc, 20);
41: end if;
42: --
43: -- Call Before Process User Hook
44: --
56: );
57: end;
58: --
59: if g_debug then
60: hr_utility.set_location(l_proc, 30);
61: end if;
62: --
63: -- Process Logic
64: --
63: -- Process Logic
64: --
65: --
66: if g_debug then
67: hr_utility.set_location(l_proc, 40);
68: end if;
69: --
70: -- call row handler
71: --
75: ,p_time_source_id => l_time_source_id
76: ,p_object_version_number => l_object_version_number );
77: --
78: if g_debug then
79: hr_utility.set_location(l_proc, 50);
80: end if;
81: --
82: -- Call After Process User Hook
83: --
95: );
96: end;
97: --
98: if g_debug then
99: hr_utility.set_location(l_proc, 60);
100: end if;
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
105: raise hr_api.validate_enabled;
106: end if;
107: --
108: if g_debug then
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
110: end if;
111: --
112: -- Set all output arguments
113: --
130: p_time_source_id := null;
131: p_object_version_number := null;
132: --
133: if g_debug then
134: hr_utility.set_location(' Leaving:'||l_proc, 80);
135: end if;
136: --
137: when others then
138: --
138: --
139: -- A validation or unexpected error has occured
140: --
141: if g_debug then
142: hr_utility.trace('In exeception');
143: end if;
144: ROLLBACK TO create_time_source;
145: raise;
146: --
162: l_proc varchar2(72);
163: l_object_version_number hxc_time_sources.object_version_number%TYPE := p_object_version_number;
164: --
165: begin
166: g_debug := hr_utility.debug_enabled;
167: --
168: if g_debug then
169: l_proc := g_package||' update_time_source';
170: hr_utility.set_location('Entering:'|| l_proc, 10);
166: g_debug := hr_utility.debug_enabled;
167: --
168: if g_debug then
169: l_proc := g_package||' update_time_source';
170: hr_utility.set_location('Entering:'|| l_proc, 10);
171: end if;
172: --
173: -- Issue a savepoint if operating in validation only mode
174: --
174: --
175: savepoint update_time_source;
176: --
177: if g_debug then
178: hr_utility.set_location(l_proc, 20);
179: end if;
180: --
181: -- Call Before Process User Hook
182: --
194: );
195: end;
196: --
197: if g_debug then
198: hr_utility.set_location(l_proc, 30);
199: end if;
200: --
201: -- Process Logic
202: --
209: ,p_object_version_number => l_object_version_number );
210: --
211: --
212: if g_debug then
213: hr_utility.set_location(l_proc, 40);
214: end if;
215: --
216: -- Call After Process User Hook
217: --
229: );
230: end;
231: --
232: if g_debug then
233: hr_utility.set_location(l_proc, 50);
234: end if;
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: if g_debug then
243: hr_utility.set_location(' Leaving:'||l_proc, 60);
244: end if;
245: --
246: -- Set all output arguments
247: --
262: --
263: p_object_version_number := null;
264: --
265: if g_debug then
266: hr_utility.set_location(' Leaving:'||l_proc, 60);
267: end if;
268: --
269: when others then
270: --
270: --
271: -- A validation or unexpected error has occured
272: --
273: if g_debug then
274: hr_utility.trace('In exeception');
275: end if;
276: ROLLBACK TO update_time_source;
277: raise;
278: --
292: --
293: l_proc varchar2(72);
294: --
295: begin
296: g_debug := hr_utility.debug_enabled;
297: --
298: if g_debug then
299: l_proc := g_package||'delete_time_source';
300: hr_utility.set_location('Entering:'|| l_proc, 10);
296: g_debug := hr_utility.debug_enabled;
297: --
298: if g_debug then
299: l_proc := g_package||'delete_time_source';
300: hr_utility.set_location('Entering:'|| l_proc, 10);
301: end if;
302: --
303: -- Issue a savepoint if operating in validation only mode
304: --
304: --
305: savepoint delete_time_source;
306: --
307: if g_debug then
308: hr_utility.set_location(l_proc, 20);
309: end if;
310: --
311: -- Call Before Process User Hook
312: --
324: );
325: end;
326: --
327: if g_debug then
328: hr_utility.set_location(l_proc, 30);
329: end if;
330: --
331: -- Process Logic
332: --
336: ,p_object_version_number => p_object_version_number
337: );
338: --
339: if g_debug then
340: hr_utility.set_location(l_proc, 40);
341: end if;
342: --
343: -- Call After Process User Hook
344: --
362: raise hr_api.validate_enabled;
363: end if;
364: --
365: if g_debug then
366: hr_utility.set_location(' Leaving:'||l_proc, 50);
367: end if;
368: --
369: exception
370: --