[Home] [Help]
PACKAGE BODY: APPS.GHR_SIT_API
Source
1 Package Body GHR_SIT_API as
2 /* $Header: ghsitapi.pkb 115.3 2003/01/30 16:32:17 asubrahm ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' HR_SIT_API.';
7
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------------< create_sit >-------------------------------|
10 -- ----------------------------------------------------------------------------
11 procedure create_sit
12 (p_validate in boolean default false
13 ,p_person_id in number
14 ,p_business_group_id in number
15 ,p_id_flex_num in number
16 ,p_effective_date in date
17 ,p_comments in varchar2 default null
18 ,p_date_from in date default null
19 ,p_date_to in date default null
20 ,p_request_id in number default null
21 ,p_program_application_id in number default null
22 ,p_program_id in number default null
23 ,p_program_update_date in date default null
24 ,p_attribute_category in varchar2 default null
25 ,p_attribute1 in varchar2 default null
26 ,p_attribute2 in varchar2 default null
27 ,p_attribute3 in varchar2 default null
28 ,p_attribute4 in varchar2 default null
29 ,p_attribute5 in varchar2 default null
30 ,p_attribute6 in varchar2 default null
31 ,p_attribute7 in varchar2 default null
32 ,p_attribute8 in varchar2 default null
33 ,p_attribute9 in varchar2 default null
34 ,p_attribute10 in varchar2 default null
35 ,p_attribute11 in varchar2 default null
36 ,p_attribute12 in varchar2 default null
37 ,p_attribute13 in varchar2 default null
38 ,p_attribute14 in varchar2 default null
39 ,p_attribute15 in varchar2 default null
40 ,p_attribute16 in varchar2 default null
41 ,p_attribute17 in varchar2 default null
42 ,p_attribute18 in varchar2 default null
43 ,p_attribute19 in varchar2 default null
44 ,p_attribute20 in varchar2 default null
45 ,p_segment1 in varchar2 default null
46 ,p_segment2 in varchar2 default null
47 ,p_segment3 in varchar2 default null
48 ,p_segment4 in varchar2 default null
49 ,p_segment5 in varchar2 default null
50 ,p_segment6 in varchar2 default null
51 ,p_segment7 in varchar2 default null
52 ,p_segment8 in varchar2 default null
53 ,p_segment9 in varchar2 default null
54 ,p_segment10 in varchar2 default null
55 ,p_segment11 in varchar2 default null
56 ,p_segment12 in varchar2 default null
57 ,p_segment13 in varchar2 default null
58 ,p_segment14 in varchar2 default null
59 ,p_segment15 in varchar2 default null
60 ,p_segment16 in varchar2 default null
61 ,p_segment17 in varchar2 default null
62 ,p_segment18 in varchar2 default null
63 ,p_segment19 in varchar2 default null
64 ,p_segment20 in varchar2 default null
65 ,p_segment21 in varchar2 default null
66 ,p_segment22 in varchar2 default null
67 ,p_segment23 in varchar2 default null
68 ,p_segment24 in varchar2 default null
69 ,p_segment25 in varchar2 default null
70 ,p_segment26 in varchar2 default null
71 ,p_segment27 in varchar2 default null
72 ,p_segment28 in varchar2 default null
73 ,p_segment29 in varchar2 default null
74 ,p_segment30 in varchar2 default null
75 ,p_analysis_criteria_id out nocopy number
76 ,p_person_analysis_id out nocopy number
77 ,p_pea_object_version_number out nocopy number
78 ) is
79
80 l_proc varchar2(72) := g_package||'create_sit';
81 l_analysis_criteria_id number;
82 l_person_analysis_id number;
83 l_pea_object_version_number number;
84 l_exists varchar2(2);
85 --
86 --
87 --
88 begin
89 hr_utility.set_location('Entering:'|| l_proc, 5);
90 --
91 -- Issue a savepoint if operating in validation only mode.
92 --
93 savepoint ghr_create_sit;
94 --
95 --
96 ghr_session.set_session_var_for_core
97 (p_effective_date => p_effective_date
98 );
99
100 hr_sit_api.create_sit
101 (p_business_group_id => p_business_group_id
102 ,p_person_id => p_person_id
103 ,p_id_flex_num => p_id_flex_num
104 ,p_effective_date => trunc(p_effective_date)
105 ,p_comments => p_comments
106 ,p_date_from => trunc(p_date_from)
107 ,p_date_to => trunc(p_date_to)
108 ,p_request_id => p_request_id
109 ,p_program_application_id => p_program_application_id
110 ,p_program_id => p_program_id
111 ,p_program_update_date => trunc(p_program_update_date)
112 ,p_attribute_category => p_attribute_category
113 ,p_attribute1 => p_attribute1
114 ,p_attribute2 => p_attribute2
115 ,p_attribute3 => p_attribute3
116 ,p_attribute4 => p_attribute4
117 ,p_attribute5 => p_attribute5
118 ,p_attribute6 => p_attribute6
119 ,p_attribute7 => p_attribute7
120 ,p_attribute8 => p_attribute8
121 ,p_attribute9 => p_attribute9
122 ,p_attribute10 => p_attribute10
123 ,p_attribute11 => p_attribute11
124 ,p_attribute12 => p_attribute12
125 ,p_attribute13 => p_attribute13
126 ,p_attribute14 => p_attribute14
127 ,p_attribute15 => p_attribute15
128 ,p_attribute16 => p_attribute16
129 ,p_attribute17 => p_attribute17
130 ,p_attribute18 => p_attribute18
131 ,p_attribute19 => p_attribute19
132 ,p_attribute20 => p_attribute20
133 ,p_segment1 => p_segment1
134 ,p_segment2 => p_segment2
135 ,p_segment3 => p_segment3
136 ,p_segment4 => p_segment4
137 ,p_segment5 => p_segment5
138 ,p_segment6 => p_segment6
139 ,p_segment7 => p_segment7
140 ,p_segment8 => p_segment8
141 ,p_segment9 => p_segment9
142 ,p_segment10 => p_segment10
143 ,p_segment11 => p_segment11
144 ,p_segment12 => p_segment12
145 ,p_segment13 => p_segment13
146 ,p_segment14 => p_segment14
147 ,p_segment15 => p_segment15
148 ,p_segment16 => p_segment16
149 ,p_segment17 => p_segment17
150 ,p_segment18 => p_segment18
151 ,p_segment19 => p_segment19
152 ,p_segment20 => p_segment20
153 ,p_segment21 => p_segment21
154 ,p_segment22 => p_segment22
155 ,p_segment23 => p_segment23
156 ,p_segment24 => p_segment24
157 ,p_segment25 => p_segment25
158 ,p_segment26 => p_segment26
159 ,p_segment27 => p_segment27
160 ,p_segment28 => p_segment28
161 ,p_segment29 => p_segment29
162 ,p_segment30 => p_segment30
163 ,p_analysis_criteria_id => l_analysis_criteria_id
164 ,p_person_analysis_id => l_person_analysis_id
165 ,p_pea_object_version_number => l_pea_object_version_number
166 );
167 hr_utility.set_location(l_proc,25);
168 ghr_history_api.post_update_process;
169 --Set OUT parameters
170 --
171 --
172 if p_validate then
173 raise hr_api.validate_enabled;
174 end if;
175 --
176 p_analysis_criteria_id := l_analysis_criteria_id;
177 p_person_analysis_id := l_person_analysis_id;
178 p_pea_object_version_number := l_pea_object_version_number;
179
180 hr_utility.set_location(' Leaving:'||l_proc, 20);
181 exception
182 when hr_api.validate_enabled then
183 --
184 -- As the Validate_Enabled exception has been raised
185 -- we must rollback to the savepoint
186 --
187 ROLLBACK TO ghr_create_sit;
188 --
189 -- Set OUT parameters to null
190 --
191 p_analysis_criteria_id := null;
192 p_person_analysis_id := null;
193 p_pea_object_version_number := null;
194
195 when others then
196 ROLLBACK TO ghr_create_sit;
197 --
198 -- Reset IN OUT parameters and set OUT parameters
199 --
200 p_analysis_criteria_id := null;
201 p_person_analysis_id := null;
202 p_pea_object_version_number := null;
203 raise;
204
205 hr_utility.set_location('Leaving:'|| l_proc, 54);
206 end create_sit;
207 --
208 -- ----------------------------------------------------------------------------
209 -- |-----------------------------< update_sit >-------------------------------|
210 -- ----------------------------------------------------------------------------
211 procedure update_sit
212 (p_validate in boolean default false
213 ,p_person_analysis_id in number
214 ,p_pea_object_version_number in out nocopy number
215 ,p_effective_date in date
216 ,p_comments in varchar2 default null
217 ,p_date_from in date default null
218 ,p_date_to in date default null
219 ,p_request_id in number default null
220 ,p_program_application_id in number default null
221 ,p_program_id in number default null
222 ,p_program_update_date in date default null
223 ,p_attribute_category in varchar2 default null
224 ,p_attribute1 in varchar2 default null
225 ,p_attribute2 in varchar2 default null
226 ,p_attribute3 in varchar2 default null
227 ,p_attribute4 in varchar2 default null
228 ,p_attribute5 in varchar2 default null
229 ,p_attribute6 in varchar2 default null
230 ,p_attribute7 in varchar2 default null
231 ,p_attribute8 in varchar2 default null
232 ,p_attribute9 in varchar2 default null
233 ,p_attribute10 in varchar2 default null
234 ,p_attribute11 in varchar2 default null
235 ,p_attribute12 in varchar2 default null
236 ,p_attribute13 in varchar2 default null
237 ,p_attribute14 in varchar2 default null
238 ,p_attribute15 in varchar2 default null
239 ,p_attribute16 in varchar2 default null
240 ,p_attribute17 in varchar2 default null
241 ,p_attribute18 in varchar2 default null
242 ,p_attribute19 in varchar2 default null
243 ,p_attribute20 in varchar2 default null
244 ,p_segment1 in varchar2 default null
245 ,p_segment2 in varchar2 default null
246 ,p_segment3 in varchar2 default null
247 ,p_segment4 in varchar2 default null
248 ,p_segment5 in varchar2 default null
249 ,p_segment6 in varchar2 default null
250 ,p_segment7 in varchar2 default null
251 ,p_segment8 in varchar2 default null
252 ,p_segment9 in varchar2 default null
253 ,p_segment10 in varchar2 default null
254 ,p_segment11 in varchar2 default null
255 ,p_segment12 in varchar2 default null
256 ,p_segment13 in varchar2 default null
257 ,p_segment14 in varchar2 default null
258 ,p_segment15 in varchar2 default null
259 ,p_segment16 in varchar2 default null
260 ,p_segment17 in varchar2 default null
261 ,p_segment18 in varchar2 default null
262 ,p_segment19 in varchar2 default null
263 ,p_segment20 in varchar2 default null
264 ,p_segment21 in varchar2 default null
265 ,p_segment22 in varchar2 default null
266 ,p_segment23 in varchar2 default null
267 ,p_segment24 in varchar2 default null
268 ,p_segment25 in varchar2 default null
269 ,p_segment26 in varchar2 default null
270 ,p_segment27 in varchar2 default null
271 ,p_segment28 in varchar2 default null
272 ,p_segment29 in varchar2 default null
273 ,p_segment30 in varchar2 default null
274 ,p_analysis_criteria_id out nocopy number
275 ) is
276
277 l_proc varchar2(72) := g_package||'update_sit';
278 l_analysis_criteria_id number;
279 l_person_analysis_id number;
280 l_pea_object_version_number number;
281 l_id_flex_num number;
282 l_business_group_id number;
283 l_api_updating boolean;
284 l_exists varchar2(2);
285 --
286 --
287 begin
288 hr_utility.set_location('Entering:'|| l_proc, 5);
289 --
290 -- Issue a savepoint if operating in validation only mode.
291 --
292 savepoint ghr_update_sit;
293
294 ghr_session.set_session_var_for_core
295 (p_effective_date => p_effective_date);
296
297 l_pea_object_version_number := p_pea_object_version_number;
298
299 hr_sit_api.update_sit
300 (
301 p_person_analysis_id => p_person_analysis_id
302 ,p_pea_object_version_number => p_pea_object_version_number
303 ,p_comments => p_comments
304 ,p_date_from => trunc(p_date_from)
305 ,p_date_to => trunc(p_date_to)
306 ,p_request_id => p_request_id
307 ,p_program_application_id => p_program_application_id
308 ,p_program_id => p_program_id
309 ,p_program_update_date => trunc(p_program_update_date)
310 ,p_attribute_category => p_attribute_category
311 ,p_attribute1 => p_attribute1
312 ,p_attribute2 => p_attribute2
316 ,p_attribute6 => p_attribute6
313 ,p_attribute3 => p_attribute3
314 ,p_attribute4 => p_attribute4
315 ,p_attribute5 => p_attribute5
317 ,p_attribute7 => p_attribute7
318 ,p_attribute8 => p_attribute8
319 ,p_attribute9 => p_attribute9
320 ,p_attribute10 => p_attribute10
321 ,p_attribute11 => p_attribute11
322 ,p_attribute12 => p_attribute12
323 ,p_attribute13 => p_attribute13
324 ,p_attribute14 => p_attribute14
325 ,p_attribute15 => p_attribute15
326 ,p_attribute16 => p_attribute16
327 ,p_attribute17 => p_attribute17
328 ,p_attribute18 => p_attribute18
329 ,p_attribute19 => p_attribute19
330 ,p_attribute20 => p_attribute20
331 ,p_segment1 => p_segment1
332 ,p_segment2 => p_segment2
333 ,p_segment3 => p_segment3
334 ,p_segment4 => p_segment4
335 ,p_segment5 => p_segment5
336 ,p_segment6 => p_segment6
337 ,p_segment7 => p_segment7
338 ,p_segment8 => p_segment8
339 ,p_segment9 => p_segment9
340 ,p_segment10 => p_segment10
341 ,p_segment11 => p_segment11
342 ,p_segment12 => p_segment12
343 ,p_segment13 => p_segment13
344 ,p_segment14 => p_segment14
345 ,p_segment15 => p_segment15
346 ,p_segment16 => p_segment16
347 ,p_segment17 => p_segment17
348 ,p_segment18 => p_segment18
349 ,p_segment19 => p_segment19
350 ,p_segment20 => p_segment20
351 ,p_segment21 => p_segment21
352 ,p_segment22 => p_segment22
353 ,p_segment23 => p_segment23
354 ,p_segment24 => p_segment24
355 ,p_segment25 => p_segment25
356 ,p_segment26 => p_segment26
357 ,p_segment27 => p_segment27
358 ,p_segment28 => p_segment28
359 ,p_segment29 => p_segment29
360 ,p_segment30 => p_segment30
361 ,p_analysis_criteria_id => l_analysis_criteria_id
362 );
363 hr_utility.set_location(l_proc, 10);
364 --
365 ghr_history_api.post_update_process;
366 --
367 --
368 --Set OUT parameters
369 --
370 p_analysis_criteria_id := l_analysis_criteria_id;
371 --
372 if p_validate then
373 raise hr_api.validate_enabled;
374 end if;
375 --
376 hr_utility.set_location(' Leaving:'||l_proc, 50);
377 exception
378 when hr_api.validate_enabled then
379 --
380 -- As the Validate_Enabled exception has been raised
381 -- we must rollback to the savepoint
382 --
383 ROLLBACK TO ghr_update_sit;
384 --
385 -- Set OUT parameters to null
386 --
387 p_analysis_criteria_id := null;
388 p_pea_object_version_number := l_pea_object_version_number;
389
390 when others then
391 ROLLBACK TO ghr_update_sit;
392 --
393 -- Reset IN OUT parameters and set OUT parameters
394 --
395 p_analysis_criteria_id := null;
396 p_pea_object_version_number := l_pea_object_version_number;
397 raise;
398
399 end update_sit;
400
401 end GHR_SIT_API;