[Home] [Help]
PACKAGE BODY: APPS.GHR_ASSIGNMENT_EXTRA_INFO_API
Source
1 Package Body ghr_assignment_extra_info_api as
2 /* $Header: ghaeiapi.pkb 115.1 1999/11/09 16:02:39 pkm ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ghr_assignment_extra_info_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |---------------------< create_assignment_extra_info >---------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_assignment_extra_info
13 (p_validate in boolean default false
14 ,p_assignment_id in number
15 ,p_information_type in varchar2
16 ,p_effective_date in date
17 ,p_aei_attribute_category in varchar2 default null
18 ,p_aei_attribute1 in varchar2 default null
19 ,p_aei_attribute2 in varchar2 default null
20 ,p_aei_attribute3 in varchar2 default null
21 ,p_aei_attribute4 in varchar2 default null
22 ,p_aei_attribute5 in varchar2 default null
23 ,p_aei_attribute6 in varchar2 default null
24 ,p_aei_attribute7 in varchar2 default null
25 ,p_aei_attribute8 in varchar2 default null
26 ,p_aei_attribute9 in varchar2 default null
27 ,p_aei_attribute10 in varchar2 default null
28 ,p_aei_attribute11 in varchar2 default null
29 ,p_aei_attribute12 in varchar2 default null
30 ,p_aei_attribute13 in varchar2 default null
31 ,p_aei_attribute14 in varchar2 default null
32 ,p_aei_attribute15 in varchar2 default null
33 ,p_aei_attribute16 in varchar2 default null
34 ,p_aei_attribute17 in varchar2 default null
35 ,p_aei_attribute18 in varchar2 default null
36 ,p_aei_attribute19 in varchar2 default null
37 ,p_aei_attribute20 in varchar2 default null
38 ,p_aei_information_category in varchar2 default null
39 ,p_aei_information1 in varchar2 default null
40 ,p_aei_information2 in varchar2 default null
41 ,p_aei_information3 in varchar2 default null
42 ,p_aei_information4 in varchar2 default null
43 ,p_aei_information5 in varchar2 default null
44 ,p_aei_information6 in varchar2 default null
45 ,p_aei_information7 in varchar2 default null
46 ,p_aei_information8 in varchar2 default null
47 ,p_aei_information9 in varchar2 default null
48 ,p_aei_information10 in varchar2 default null
49 ,p_aei_information11 in varchar2 default null
50 ,p_aei_information12 in varchar2 default null
51 ,p_aei_information13 in varchar2 default null
52 ,p_aei_information14 in varchar2 default null
53 ,p_aei_information15 in varchar2 default null
54 ,p_aei_information16 in varchar2 default null
55 ,p_aei_information17 in varchar2 default null
56 ,p_aei_information18 in varchar2 default null
57 ,p_aei_information19 in varchar2 default null
58 ,p_aei_information20 in varchar2 default null
59 ,p_aei_information21 in varchar2 default null
60 ,p_aei_information22 in varchar2 default null
61 ,p_aei_information23 in varchar2 default null
62 ,p_aei_information24 in varchar2 default null
63 ,p_aei_information25 in varchar2 default null
64 ,p_aei_information26 in varchar2 default null
65 ,p_aei_information27 in varchar2 default null
66 ,p_aei_information28 in varchar2 default null
67 ,p_aei_information29 in varchar2 default null
68 ,p_aei_information30 in varchar2 default null
69 ,p_assignment_extra_info_id out number
70 ,p_object_version_number out number
71 ) is
72 --
73 -- Declare cursors and local variables
74 --
75 l_proc varchar2(72) := g_package||'create_assignment_extra_info';
76 l_object_version_number per_assignment_extra_info.object_version_number%type;
77 l_assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
78 --
79 begin
80 hr_utility.set_location('Entering:'|| l_proc, 5);
81 --
82 -- Issue a savepoint if operating in validation only mode.
83 --
84 savepoint ghr_create_asg_extra_info;
85 --
86 --
87 --
88 -- set session variables
89 ghr_session.set_session_var_for_core
90 (p_effective_date => p_effective_date
91 );
92
93 hr_assignment_extra_info_api.create_assignment_extra_info
94 (
95 p_assignment_id => p_assignment_id ,
96 p_information_type => p_information_type ,
97 p_aei_attribute_category => p_aei_attribute_category ,
98 p_aei_attribute1 => p_aei_attribute1 ,
99 p_aei_attribute2 => p_aei_attribute2 ,
100 p_aei_attribute3 => p_aei_attribute3 ,
101 p_aei_attribute4 => p_aei_attribute4 ,
102 p_aei_attribute5 => p_aei_attribute5 ,
103 p_aei_attribute6 => p_aei_attribute6 ,
104 p_aei_attribute7 => p_aei_attribute7 ,
105 p_aei_attribute8 => p_aei_attribute8 ,
106 p_aei_attribute9 => p_aei_attribute9 ,
107 p_aei_attribute10 => p_aei_attribute10 ,
108 p_aei_attribute11 => p_aei_attribute11 ,
109 p_aei_attribute12 => p_aei_attribute12 ,
110 p_aei_attribute13 => p_aei_attribute13 ,
111 p_aei_attribute14 => p_aei_attribute14 ,
112 p_aei_attribute15 => p_aei_attribute15 ,
113 p_aei_attribute16 => p_aei_attribute16 ,
114 p_aei_attribute17 => p_aei_attribute17 ,
115 p_aei_attribute18 => p_aei_attribute18 ,
116 p_aei_attribute19 => p_aei_attribute19 ,
117 p_aei_attribute20 => p_aei_attribute20 ,
118 p_aei_information_category => p_aei_information_category ,
119 p_aei_information1 => p_aei_information1 ,
120 p_aei_information2 => p_aei_information2 ,
121 p_aei_information3 => p_aei_information3 ,
122 p_aei_information4 => p_aei_information4 ,
123 p_aei_information5 => p_aei_information5 ,
124 p_aei_information6 => p_aei_information6 ,
125 p_aei_information7 => p_aei_information7 ,
126 p_aei_information8 => p_aei_information8 ,
127 p_aei_information9 => p_aei_information9 ,
128 p_aei_information10 => p_aei_information10 ,
129 p_aei_information11 => p_aei_information11 ,
130 p_aei_information12 => p_aei_information12 ,
131 p_aei_information13 => p_aei_information13 ,
132 p_aei_information14 => p_aei_information14 ,
133 p_aei_information15 => p_aei_information15 ,
134 p_aei_information16 => p_aei_information16 ,
135 p_aei_information17 => p_aei_information17 ,
136 p_aei_information18 => p_aei_information18 ,
137 p_aei_information19 => p_aei_information19 ,
138 p_aei_information20 => p_aei_information20 ,
139 p_aei_information21 => p_aei_information21 ,
140 p_aei_information22 => p_aei_information22 ,
141 p_aei_information23 => p_aei_information23 ,
142 p_aei_information24 => p_aei_information24 ,
143 p_aei_information25 => p_aei_information25 ,
144 p_aei_information26 => p_aei_information26 ,
145 p_aei_information27 => p_aei_information27 ,
146 p_aei_information28 => p_aei_information28 ,
147 p_aei_information29 => p_aei_information29 ,
148 p_aei_information30 => p_aei_information30 ,
149 p_assignment_extra_info_id => l_assignment_extra_info_id ,
150 p_object_version_number => l_object_version_number
151 );
152 --
153
154 hr_utility.set_location(l_proc, 7);
155 --
156 ghr_history_api.post_update_process;
157 -- When in validation only mode raise the Validate_Enabled exception
158 --
159 if p_validate then
160 raise hr_api.validate_enabled;
161 end if;
162 --
163 p_object_version_number := l_object_version_number;
164 p_assignment_extra_info_id := l_assignment_extra_info_id;
165
166 hr_utility.set_location(' Leaving:'||l_proc, 11);
167 exception
168 when hr_api.validate_enabled then
169 --
170 -- As the Validate_Enabled exception has been raised
171 -- we must rollback to the savepoint
172 --
173 ROLLBACK TO ghr_create_asg_extra_info;
174 --
175 -- Only set output warning arguments
176 -- (Any key or derived arguments must be set to null
177 -- when validation only mode is being used.)
178 --
179 p_assignment_extra_info_id := null;
180 p_object_version_number := null;
181 --
182
183 when others then
184 ROLLBACK TO ghr_create_asg_extra_info;
185 raise;
186
187 hr_utility.set_location(' Leaving:'||l_proc, 12);
188 end create_assignment_extra_info;
189 --
190 -- ----------------------------------------------------------------------------
191 -- |---------------------< update_assignment_extra_info >---------------------|
192 -- ----------------------------------------------------------------------------
193 --
194 procedure update_assignment_extra_info
195 (p_validate in boolean default false
196 ,p_assignment_extra_info_id in number
197 ,p_object_version_number in out number
198 ,p_effective_date in date
199 ,p_aei_attribute_category in varchar2 default hr_api.g_varchar2
200 ,p_aei_attribute1 in varchar2 default hr_api.g_varchar2
201 ,p_aei_attribute2 in varchar2 default hr_api.g_varchar2
202 ,p_aei_attribute3 in varchar2 default hr_api.g_varchar2
203 ,p_aei_attribute4 in varchar2 default hr_api.g_varchar2
204 ,p_aei_attribute5 in varchar2 default hr_api.g_varchar2
205 ,p_aei_attribute6 in varchar2 default hr_api.g_varchar2
206 ,p_aei_attribute7 in varchar2 default hr_api.g_varchar2
207 ,p_aei_attribute8 in varchar2 default hr_api.g_varchar2
208 ,p_aei_attribute9 in varchar2 default hr_api.g_varchar2
209 ,p_aei_attribute10 in varchar2 default hr_api.g_varchar2
210 ,p_aei_attribute11 in varchar2 default hr_api.g_varchar2
211 ,p_aei_attribute12 in varchar2 default hr_api.g_varchar2
212 ,p_aei_attribute13 in varchar2 default hr_api.g_varchar2
213 ,p_aei_attribute14 in varchar2 default hr_api.g_varchar2
214 ,p_aei_attribute15 in varchar2 default hr_api.g_varchar2
215 ,p_aei_attribute16 in varchar2 default hr_api.g_varchar2
216 ,p_aei_attribute17 in varchar2 default hr_api.g_varchar2
217 ,p_aei_attribute18 in varchar2 default hr_api.g_varchar2
218 ,p_aei_attribute19 in varchar2 default hr_api.g_varchar2
219 ,p_aei_attribute20 in varchar2 default hr_api.g_varchar2
220 ,p_aei_information_category in varchar2 default hr_api.g_varchar2
221 ,p_aei_information1 in varchar2 default hr_api.g_varchar2
222 ,p_aei_information2 in varchar2 default hr_api.g_varchar2
223 ,p_aei_information3 in varchar2 default hr_api.g_varchar2
224 ,p_aei_information4 in varchar2 default hr_api.g_varchar2
225 ,p_aei_information5 in varchar2 default hr_api.g_varchar2
226 ,p_aei_information6 in varchar2 default hr_api.g_varchar2
227 ,p_aei_information7 in varchar2 default hr_api.g_varchar2
228 ,p_aei_information8 in varchar2 default hr_api.g_varchar2
229 ,p_aei_information9 in varchar2 default hr_api.g_varchar2
230 ,p_aei_information10 in varchar2 default hr_api.g_varchar2
231 ,p_aei_information11 in varchar2 default hr_api.g_varchar2
232 ,p_aei_information12 in varchar2 default hr_api.g_varchar2
233 ,p_aei_information13 in varchar2 default hr_api.g_varchar2
234 ,p_aei_information14 in varchar2 default hr_api.g_varchar2
235 ,p_aei_information15 in varchar2 default hr_api.g_varchar2
236 ,p_aei_information16 in varchar2 default hr_api.g_varchar2
237 ,p_aei_information17 in varchar2 default hr_api.g_varchar2
238 ,p_aei_information18 in varchar2 default hr_api.g_varchar2
239 ,p_aei_information19 in varchar2 default hr_api.g_varchar2
240 ,p_aei_information20 in varchar2 default hr_api.g_varchar2
241 ,p_aei_information21 in varchar2 default hr_api.g_varchar2
242 ,p_aei_information22 in varchar2 default hr_api.g_varchar2
243 ,p_aei_information23 in varchar2 default hr_api.g_varchar2
244 ,p_aei_information24 in varchar2 default hr_api.g_varchar2
245 ,p_aei_information25 in varchar2 default hr_api.g_varchar2
246 ,p_aei_information26 in varchar2 default hr_api.g_varchar2
247 ,p_aei_information27 in varchar2 default hr_api.g_varchar2
248 ,p_aei_information28 in varchar2 default hr_api.g_varchar2
249 ,p_aei_information29 in varchar2 default hr_api.g_varchar2
250 ,p_aei_information30 in varchar2 default hr_api.g_varchar2
251 ) is
252 --
253 -- Declare cursors and local variables
254 --
255 l_proc varchar2(72) := g_package||'update_assignment_extra_info';
256 l_object_version_number per_assignment_extra_info.object_version_number%TYPE;
257 --
258 begin
259 hr_utility.set_location('Entering:'|| l_proc, 5);
260 --
261 -- Issue a savepoint if operating in validation only mode.
262 --
263 savepoint ghr_update_asg_extra_info;
264 --
265
266
267 l_object_version_number := p_object_version_number;
268
269 ghr_session.set_session_var_for_core
270 (p_effective_date => p_effective_date
271 );
272
273 hr_assignment_extra_info_api.update_assignment_extra_info
274 (
275 p_assignment_extra_info_id => p_assignment_extra_info_id ,
276 p_aei_attribute_category => p_aei_attribute_category ,
277 p_aei_attribute1 => p_aei_attribute1 ,
278 p_aei_attribute2 => p_aei_attribute2 ,
279 p_aei_attribute3 => p_aei_attribute3 ,
280 p_aei_attribute4 => p_aei_attribute4 ,
281 p_aei_attribute5 => p_aei_attribute5 ,
282 p_aei_attribute6 => p_aei_attribute6 ,
283 p_aei_attribute7 => p_aei_attribute7 ,
284 p_aei_attribute8 => p_aei_attribute8 ,
285 p_aei_attribute9 => p_aei_attribute9 ,
286 p_aei_attribute10 => p_aei_attribute10 ,
287 p_aei_attribute11 => p_aei_attribute11 ,
288 p_aei_attribute12 => p_aei_attribute12 ,
289 p_aei_attribute13 => p_aei_attribute13 ,
290 p_aei_attribute14 => p_aei_attribute14 ,
291 p_aei_attribute15 => p_aei_attribute15 ,
292 p_aei_attribute16 => p_aei_attribute16 ,
293 p_aei_attribute17 => p_aei_attribute17 ,
294 p_aei_attribute18 => p_aei_attribute18 ,
295 p_aei_attribute19 => p_aei_attribute19 ,
299 p_aei_information2 => p_aei_information2 ,
296 p_aei_attribute20 => p_aei_attribute20 ,
297 p_aei_information_category => p_aei_information_category ,
298 p_aei_information1 => p_aei_information1 ,
300 p_aei_information3 => p_aei_information3 ,
301 p_aei_information4 => p_aei_information4 ,
302 p_aei_information5 => p_aei_information5 ,
303 p_aei_information6 => p_aei_information6 ,
304 p_aei_information7 => p_aei_information7 ,
305 p_aei_information8 => p_aei_information8 ,
306 p_aei_information9 => p_aei_information9 ,
307 p_aei_information10 => p_aei_information10 ,
308 p_aei_information11 => p_aei_information11 ,
309 p_aei_information12 => p_aei_information12 ,
310 p_aei_information13 => p_aei_information13 ,
311 p_aei_information14 => p_aei_information14 ,
312 p_aei_information15 => p_aei_information15 ,
313 p_aei_information16 => p_aei_information16 ,
314 p_aei_information17 => p_aei_information17 ,
315 p_aei_information18 => p_aei_information18 ,
316 p_aei_information19 => p_aei_information19 ,
317 p_aei_information20 => p_aei_information20 ,
318 p_aei_information21 => p_aei_information21 ,
319 p_aei_information22 => p_aei_information22 ,
320 p_aei_information23 => p_aei_information23 ,
321 p_aei_information24 => p_aei_information24 ,
322 p_aei_information25 => p_aei_information25 ,
323 p_aei_information26 => p_aei_information26 ,
324 p_aei_information27 => p_aei_information27 ,
325 p_aei_information28 => p_aei_information28 ,
326 p_aei_information29 => p_aei_information29 ,
327 p_aei_information30 => p_aei_information30 ,
328 p_object_version_number => p_object_version_number
329 );
330 --
331 hr_utility.set_location(l_proc, 7);
332 --
333 --
334 --
335 ghr_history_api.post_update_process;
336
337 if p_validate then
338 raise hr_api.validate_enabled;
339 end if;
340
341 --
342 hr_utility.set_location(' Leaving:'||l_proc, 11);
343 exception
344 when hr_api.validate_enabled then
345 --
346 -- As the Validate_Enabled exception has been raised
347 -- we must rollback to the savepoint
348 --
349 ROLLBACK TO ghr_update_asg_extra_info;
350 --
351 -- Only set output warning arguments
352 -- (Any key or derived arguments must be set to null
353 -- when validation only mode is being used.)
354 --
355 p_object_version_number := l_object_version_number;
356 --
357 hr_utility.set_location(' Leaving:'||l_proc, 12);
358 when others then
359 ROLLBACK TO ghr_update_asg_extra_info;
360 raise;
361 end update_assignment_extra_info;
362 --
363 --
364 end ghr_assignment_extra_info_api;