[Home] [Help]
27: l_object_version_number number;
28: l_net_calculation_rule_id number;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_pay_net_calc_rule;
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_pay_net_calc_rule;
36: hr_utility.set_location(l_proc, 20);
37:
38: --
39: -- Call Before Process User Hook
40: --
52: (p_module_name => 'create_pay_net_calc_rule'
53: ,p_hook_type => 'BP'
54: );
55: end;
56: hr_utility.set_location(l_proc, 30);
57: --
58: -- Validation in addition to Row Handlers
59: --
60:
59: --
60:
61:
62:
63: hr_utility.set_location(l_proc, 40);
64: --
65: -- Process Logic
66: --
67:
75: p_object_version_number => l_object_version_number
76: );
77:
78:
79: hr_utility.set_location(l_proc, 50);
80: --
81: -- Call After Process User Hook
82: --
83: begin
96: (p_module_name => 'create_pay_net_calc_rule'
97: ,p_hook_type => 'AP'
98: );
99: end;
100: hr_utility.set_location(l_proc, 60);
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
110: p_net_calculation_rule_id := l_net_calculation_rule_id;
111: p_object_version_number := l_object_version_number;
112:
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: exception
116: when hr_api.validate_enabled then
117: --
118: -- As the Validate_Enabled exception has been raised
126: --
127: p_net_calculation_rule_id := null;
128: p_object_version_number := null;
129:
130: hr_utility.set_location(' Leaving:'||l_proc, 80);
131: when others then
132: --
133: -- A validation or unexpected error has occured
134: --
132: --
133: -- A validation or unexpected error has occured
134: --
135: rollback to create_pay_net_calc_rule;
136: hr_utility.set_location(' Leaving:'||l_proc, 90);
137: raise;
138: end create_pay_net_calc_rule;
139: --
140: -- ----------------------------------------------------------------------------
157: l_proc varchar2(72) := g_package||'update_pay_net_calc_rule';
158: l_object_version_number number;
159:
160: begin
161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: --
163: -- Issue a savepoint
164: --
165: savepoint update_pay_net_calc_rule;
162: --
163: -- Issue a savepoint
164: --
165: savepoint update_pay_net_calc_rule;
166: hr_utility.set_location(l_proc, 20);
167:
168: --
169: -- Call Before Process User Hook
170: --
183: (p_module_name => 'update_pay_net_calc_rule'
184: ,p_hook_type => 'BP'
185: );
186: end;
187: hr_utility.set_location(l_proc, 30);
188: --
189: -- Validation in addition to Row Handlers
190: --
191:
190: --
191:
192:
193:
194: hr_utility.set_location(l_proc, 40);
195: --
196: -- Process Logic
197: --
198: l_object_version_number := p_object_version_number;
206: p_object_version_number => l_object_version_number
207: );
208:
209:
210: hr_utility.set_location(l_proc, 50);
211: --
212: -- Call After Process User Hook
213: --
214: begin
226: (p_module_name => 'update_pay_net_calc_rule'
227: ,p_hook_type => 'AP'
228: );
229: end;
230: hr_utility.set_location(l_proc, 60);
231: --
232: -- When in validation only mode raise the Validate_Enabled exception
233: --
234: if p_validate then
240:
241: p_object_version_number := l_object_version_number;
242:
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: exception
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
256: --
257:
258: p_object_version_number := null;
259:
260: hr_utility.set_location(' Leaving:'||l_proc, 80);
261: when others then
262: --
263: -- A validation or unexpected error has occured
264: --
262: --
263: -- A validation or unexpected error has occured
264: --
265: rollback to update_pay_net_calc_rule;
266: hr_utility.set_location(' Leaving:'||l_proc, 90);
267: raise;
268: end update_pay_net_calc_rule;
269: --
270:
283:
284: l_proc varchar2(72) := g_package||'delete_pay_net_calc_rule';
285:
286: begin
287: hr_utility.set_location('Entering:'|| l_proc, 10);
288: --
289: -- Issue a savepoint
290: --
291: savepoint delete_pay_net_calc_rule;
288: --
289: -- Issue a savepoint
290: --
291: savepoint delete_pay_net_calc_rule;
292: hr_utility.set_location(l_proc, 20);
293:
294: --
295: -- Call Before Process User Hook
296: --
305: (p_module_name => 'delete_pay_net_calc_rule'
306: ,p_hook_type => 'BP'
307: );
308: end;
309: hr_utility.set_location(l_proc, 30);
310: --
311: -- Validation in addition to Row Handlers
312: --
313:
312: --
313:
314:
315:
316: hr_utility.set_location(l_proc, 40);
317: --
318: -- Process Logic
319: --
320:
323: p_object_version_number => p_object_version_number
324: );
325:
326:
327: hr_utility.set_location(l_proc, 50);
328: --
329: -- Call After Process User Hook
330: --
331: begin
339: (p_module_name => 'delete_pay_net_calc_rule'
340: ,p_hook_type => 'AP'
341: );
342: end;
343: hr_utility.set_location(l_proc, 60);
344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then
351: -- Set all output arguments
352: --
353:
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: exception
357: when hr_api.validate_enabled then
358: --
359: -- As the Validate_Enabled exception has been raised
366: -- when validation only mode is being used.)
367: --
368:
369:
370: hr_utility.set_location(' Leaving:'||l_proc, 80);
371: when others then
372: --
373: -- A validation or unexpected error has occured
374: --
372: --
373: -- A validation or unexpected error has occured
374: --
375: rollback to delete_pay_net_calc_rule;
376: hr_utility.set_location(' Leaving:'||l_proc, 90);
377: raise;
378: end delete_pay_net_calc_rule;
379: --
380: end pay_ncr_api;