4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_retrieval_rules_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_retrieval_rules >-----------------------|
12: -- ----------------------------------------------------------------------------
27: l_object_version_number hxc_retrieval_rules.object_version_number%TYPE;
28: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
29: --
30: Begin
31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||'create_retrieval_rules ';
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_retrieval_rules ';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
37: --
38: -- Issue a savepoint
39: --
39: --
40: savepoint create_retrieval_rules;
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: --
65: );
66: end;
67: --
68: if g_debug then
69: hr_utility.set_location(l_proc, 30);
70: end if;
71: --
72:
73: --
79: --
80: -- Process Logic
81: --
82: if g_debug then
83: hr_utility.set_location(l_proc, 40);
84: end if;
85: --
86: -- call row handler
87: --
93: ,p_object_version_number => l_object_version_number
94: );
95: --
96: if g_debug then
97: hr_utility.set_location(l_proc, 50);
98: end if;
99: --
100: -- Call After Process User Hook
101: --
115: );
116: end;
117: --
118: if g_debug then
119: hr_utility.set_location(l_proc, 60);
120: end if;
121: --
122: --
123: -- When in validation only mode raise the Validate_Enabled exception
126: raise hr_api.validate_enabled;
127: end if;
128: --
129: --if g_debug then
130: --hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --end if;
132: --
133: --
134: -- Set all output arguments
136: p_retrieval_rule_id := l_retrieval_rule_id;
137: p_object_version_number := l_object_version_number;
138: --
139: if g_debug then
140: hr_utility.set_location(' Leaving:'||l_proc, 70);
141: end if;
142: exception
143: when hr_api.validate_enabled then
144: --
153: --
154: p_retrieval_rule_id := null;
155: p_object_version_number := null;
156: if g_debug then
157: hr_utility.set_location(' Leaving:'||l_proc, 80);
158: end if;
159: when others then
160: --
161: -- A validation or unexpected error has occured
161: -- A validation or unexpected error has occured
162: --
163: rollback to create_retrieval_rules;
164: if g_debug then
165: hr_utility.set_location(' Leaving:'||l_proc, 90);
166: end if;
167: raise;
168: --
169: end create_retrieval_rules;
187: l_proc varchar2(72);
188: l_object_version_number hxc_retrieval_rules.object_version_number%TYPE := p_object_version_number;
189: --
190: Begin
191: g_debug := hr_utility.debug_enabled;
192: --
193: if g_debug then
194: l_proc := g_package||' update_retrieval_rules';
195: hr_utility.set_location('Entering:'|| l_proc, 10);
191: g_debug := hr_utility.debug_enabled;
192: --
193: if g_debug then
194: l_proc := g_package||' update_retrieval_rules';
195: hr_utility.set_location('Entering:'|| l_proc, 10);
196: end if;
197: --
198: -- Issue a savepoint if operating in validation only mode
199: --
199: --
200: savepoint update_retrieval_rules;
201: --
202: if g_debug then
203: hr_utility.set_location(l_proc, 20);
204: end if;
205: --
206: -- Call Before Process User Hook
207: --
221: );
222: end;
223: --
224: --if g_debug then
225: --hr_utility.set_location(l_proc, 30);
226: --end if;
227: --
228: -- Process Logic
229: --
237: ,p_name => p_name
238: );
239: --
240: if g_debug then
241: hr_utility.set_location(l_proc, 40);
242: end if;
243: --
244: -- Call After Process User Hook
245: --
259: );
260: end;
261: --
262: if g_debug then
263: hr_utility.set_location(l_proc, 50);
264: end if;
265: --
266: -- When in validation only mode raise the Validate_Enabled exception
267: --
269: raise hr_api.validate_enabled;
270: end if;
271: --
272: if g_debug then
273: hr_utility.set_location(' Leaving:'||l_proc, 60);
274: end if;
275: --
276: -- Set all output arguments
277: --
293: --
294: p_object_version_number := null;
295: --
296: if g_debug then
297: hr_utility.set_location(' Leaving:'||l_proc, 60);
298: end if;
299: --
300: when others then
301: --
302: -- A validation or unexpected error has occured
303: --
304: ROLLBACK TO update_retrieval_rules;
305: if g_debug then
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: end if;
308: raise;
309: --
310: END update_retrieval_rules;
323: --
324: l_proc varchar2(72);
325: --
326: begin
327: g_debug := hr_utility.debug_enabled;
328: --
329: if g_debug then
330: l_proc := g_package||'delete_retrieval_rules';
331: hr_utility.set_location('Entering:'|| l_proc, 10);
327: g_debug := hr_utility.debug_enabled;
328: --
329: if g_debug then
330: l_proc := g_package||'delete_retrieval_rules';
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: end if;
333: --
334: -- Issue a savepoint if operating in validation only mode
335: --
335: --
336: savepoint delete_retrieval_rules;
337: --
338: if g_debug then
339: hr_utility.set_location(l_proc, 20);
340: end if;
341: --
342: -- Call Before Process User Hook
343: --
355: );
356: end;
357: --
358: if g_debug then
359: hr_utility.set_location(l_proc, 30);
360: end if;
361: --
362: -- Process Logic
363: --
367: ,p_object_version_number => p_object_version_number
368: );
369: --
370: if g_debug then
371: hr_utility.set_location(l_proc, 40);
372: end if;
373: --
374: -- Call After Process User Hook
375: --
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: if g_debug then
397: hr_utility.set_location(' Leaving:'||l_proc, 50);
398: end if;
399: --
400: exception
401: --