32: l_proc varchar2(72) := g_package||'create_compl_claim';
33: l_compl_claim_id number;
34: l_object_version_number number;
35: begin
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- Issue a savepoint
39: --
40: savepoint create_compl_claim;
37: --
38: -- Issue a savepoint
39: --
40: savepoint create_compl_claim;
41: hr_utility.set_location(l_proc, 20);
42: --
43: -- Truncate the time portion from all IN date parameters
44: --
45: -- Call Before Process User Hook
69: --
70: -- Validation in addition to Row Handlers
71: --
72:
73: hr_utility.set_location(l_proc, 40);
74: --
75: -- Process Logic
76: --
77: ghr_ccl_ins.ins
88: ,p_agency_appeal => p_agency_appeal
89: ,p_compl_claim_id => l_compl_claim_id
90: ,p_object_version_number => l_object_version_number
91: );
92: hr_utility.set_location(l_proc, 50);
93: --
94: -- Call After Process User Hook
95: --
96: begin
126: --
127: p_compl_claim_id := l_compl_claim_id;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: exception
132: when hr_api.validate_enabled then
133: --
134: -- As the Validate_Enabled exception has been raised
141: -- when validation only mode is being used.)
142: --
143: p_compl_claim_id := null;
144: p_object_version_number := null;
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: when others then
147: --
148: -- A validation or unexpected error has occured
149: --
150: rollback to create_compl_claim;
151: --RESET In/Out Params and SET Out Params
152: p_compl_claim_id := null;
153: p_object_version_number := null;
154: hr_utility.set_location(' Leaving:'||l_proc, 90);
155: raise;
156: end create_compl_claim;
157: --
158:
175: is
176: l_proc varchar2(72) := g_package||'update_compl_claim';
177: l_object_version_number number;
178: begin
179: hr_utility.set_location('Entering:'|| l_proc, 5);
180: --
181: savepoint update_compl_claim;
182:
183: --
218: -- Store the original ovn in case we rollback when p_validate is true
219: --
220: l_object_version_number := p_object_version_number;
221:
222: hr_utility.set_location(l_proc, 6);
223:
224: ghr_ccl_upd.upd
225: (p_effective_date => p_effective_date
226: ,p_compl_claim_id => p_compl_claim_id
270: -- Set all output arguments
271: --
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: exception
276: when hr_api.validate_enabled then
277: --
278: -- As the Validate_Enabled exception has been raised
284: -- (Any key or derived arguments must be set to null
285: -- when validation only mode is being used.)
286: --
287: p_object_version_number := l_object_version_number;
288: hr_utility.set_location(' Leaving:'||l_proc, 80);
289: when others then
290: --
291: -- A validation or unexpected error has occured
292: --
292: --
293: rollback to update_compl_claim;
294: --RESET In/Out Params and SET Out Params
295: p_object_version_number := l_object_version_number;
296: hr_utility.set_location(' Leaving:'||l_proc, 90);
297: raise;
298:
299: end update_compl_claim;
300:
313: l_proc varchar2(72) := g_package||'delete_compl_claim';
314: l_exists boolean := false;
315:
316: begin
317: hr_utility.set_location('Entering:'|| l_proc, 5);
318: --
319: --
320: savepoint delete_compl_claim;
321: --
345: (p_compl_claim_id => p_compl_claim_id
346: ,p_object_version_number => p_object_version_number
347: );
348: --
349: hr_utility.set_location(l_proc, 8);
350: --
351: -- Call After Process User Hook
352: --
353: begin
371: if p_validate then
372: raise hr_api.validate_enabled;
373: end if;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 11);
376: exception
377: when hr_api.validate_enabled then
378: -- we must rollback to the savepoint
379: --
382: When Others then
383: ROLLBACK TO delete_compl_claim;
384: raise;
385:
386: hr_utility.set_location(' Leaving:'||l_proc, 12);
387: end delete_compl_claim;
388: end ghr_complaint_claims_api;
389: