[Home] [Help]
29: l_proc varchar2(72) := g_package||'create_compl_basis';
30: l_compl_basis_id number;
31: l_object_version_number number;
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_compl_basis;
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_compl_basis;
38: hr_utility.set_location(l_proc, 20);
39: --
40: -- Truncate the time portion from all IN date parameters
41: --
42: -- Call Before Process User Hook
61: --
62: -- Validation in addition to Row Handlers
63: --
64:
65: hr_utility.set_location(l_proc, 40);
66: --
67: -- Process Logic
68: --
69: ghr_cba_ins.ins
76: ,p_aj_finding => p_aj_finding
77: ,p_compl_basis_id => l_compl_basis_id
78: ,p_object_version_number => l_object_version_number
79: );
80: hr_utility.set_location(l_proc, 50);
81: --
82: -- Call After Process User Hook
83: --
84: begin
111: --
112: p_compl_basis_id := l_compl_basis_id;
113: p_object_version_number := l_object_version_number;
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 70);
116: exception
117: when hr_api.validate_enabled then
118: --
119: -- As the Validate_Enabled exception has been raised
126: -- when validation only mode is being used.)
127: --
128: p_compl_basis_id := null;
129: p_object_version_number := null;
130: hr_utility.set_location(' Leaving:'||l_proc, 80);
131: when others then
132: --
133: -- A validation or unexpected error has occured
134: --
135: rollback to create_compl_basis;
136: -- Reset In/Out Params and SET Out Params.
137: p_compl_basis_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 90);
140: raise;
141: end create_compl_basis;
142: --
143: -- ----------------------------------------------------------------------------
160: is
161: l_proc varchar2(72) := g_package||'update_compl_basis';
162: l_object_version_number number;
163: begin
164: hr_utility.set_location('Entering:'|| l_proc, 5);
165: --
166: savepoint update_compl_basis;
167: --
168: -- Initialise Local Variables
196: -- Store the original ovn in case we rollback when p_validate is true
197: --
198: l_object_version_number := p_object_version_number;
199:
200: hr_utility.set_location(l_proc, 6);
201:
202: ghr_cba_upd.upd
203: (p_effective_date => p_effective_date
204: ,p_compl_claim_id => p_compl_claim_id
242: -- Set all output arguments
243: --
244: p_object_version_number := l_object_version_number;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
257: -- when validation only mode is being used.)
258: --
259: -- Reset In/Out Params and SET Out Params
260: p_object_version_number := l_object_version_number;
261: hr_utility.set_location(' Leaving:'||l_proc, 80);
262: when others then
263: --
264: -- A validation or unexpected error has occured
265: --
265: --
266: rollback to update_compl_basis;
267: -- Reset In/Out Params and SET Out Params
268: p_object_version_number := l_object_version_number;
269: hr_utility.set_location(' Leaving:'||l_proc, 90);
270: raise;
271:
272: end update_compl_basis;
273:
286: l_proc varchar2(72) := g_package||'delete_compl_basis';
287: l_exists boolean := false;
288:
289: begin
290: hr_utility.set_location('Entering:'|| l_proc, 5);
291: --
292: --
293: savepoint delete_compl_basis;
294: --
317: (p_compl_basis_id => p_compl_basis_id
318: ,p_object_version_number => p_object_version_number
319: );
320: --
321: hr_utility.set_location(l_proc, 8);
322: --
323: -- Call After Process User Hook
324: --
325: begin
340: if p_validate then
341: raise hr_api.validate_enabled;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 11);
345: exception
346: when hr_api.validate_enabled then
347: -- we must rollback to the savepoint
348: --
351: When Others then
352: ROLLBACK TO delete_compl_basis;
353: raise;
354:
355: hr_utility.set_location(' Leaving:'||l_proc, 12);
356: end delete_compl_basis;
357: end ghr_complaint_bases_api;