[Home] [Help]
28: l_proc varchar2(72) := g_package||'create_compl_person';
29: l_compl_person_id number;
30: l_object_version_number number;
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Issue a savepoint
35: --
36: savepoint create_compl_person;
33: --
34: -- Issue a savepoint
35: --
36: savepoint create_compl_person;
37: hr_utility.set_location(l_proc, 20);
38: --
39: -- Truncate the time portion from all IN date parameters
40: --
41: --
62: --
63: -- Validation in addition to Row Handlers
64: --
65:
66: hr_utility.set_location(l_proc, 40);
67: --
68: -- Process Logic
69: --
70: ghr_cpl_ins.ins
76: ,p_end_date => p_end_date
77: ,p_compl_person_id => l_compl_person_id
78: ,p_object_version_number => l_object_version_number
79: );
80: hr_utility.set_location(l_proc, 50);
81: --
82: --
83: -- Call After Process User Hook
84: --
111: --
112: p_compl_person_id := l_compl_person_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_person_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: --
137: -- Reset IN OUT parameters and set OUT parameters
138: --
139: p_compl_person_id := null;
140: p_object_version_number := null;
141: hr_utility.set_location(' Leaving:'||l_proc, 90);
142: raise;
143: end create_compl_person;
144: --
145:
161: l_object_version_number number;
162: -- Initial OVN.
163: l_i_object_version_number number;
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 5);
166: --
167: savepoint update_compl_person;
168: --
169: -- Remember IN OUT parameter IN values
199: -- Store the original ovn in case we rollback when p_validate is true
200: --
201: l_object_version_number := p_object_version_number;
202:
203: hr_utility.set_location(l_proc, 6);
204:
205: ghr_cpl_upd.upd
206: (p_effective_date => p_effective_date
207: ,p_complaint_id => p_complaint_id
243: -- Set all output arguments
244: --
245: p_object_version_number := l_object_version_number;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 70);
248: exception
249: when hr_api.validate_enabled then
250: --
251: -- As the Validate_Enabled exception has been raised
257: -- (Any key or derived arguments must be set to null
258: -- when validation only mode is being used.)
259: --
260: p_object_version_number := l_i_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: --
267: --
268: -- Reset IN OUT parameters and set OUT parameters
269: --
270: p_object_version_number := l_i_object_version_number;
271: hr_utility.set_location(' Leaving:'||l_proc, 90);
272: raise;
273:
274: end update_compl_person;
275:
288: l_proc varchar2(72) := g_package||'delete_compl_person';
289: l_exists boolean := false;
290:
291: begin
292: hr_utility.set_location('Entering:'|| l_proc, 5);
293: --
294: --
295: savepoint delete_compl_person;
296: --
320: (p_compl_person_id => p_compl_person_id
321: ,p_object_version_number => p_object_version_number
322: );
323: --
324: hr_utility.set_location(l_proc, 8);
325: --
326: -- Call After Process User Hook
327: --
328: begin
343: if p_validate then
344: raise hr_api.validate_enabled;
345: end if;
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 11);
348: exception
349: when hr_api.validate_enabled then
350: -- we must rollback to the savepoint
351: --
354: When Others then
355: ROLLBACK TO delete_compl_person;
356: raise;
357:
358: hr_utility.set_location(' Leaving:'||l_proc, 12);
359: end delete_compl_person;
360: end ghr_complaint_people_api;
361: