[Home] [Help]
PACKAGE BODY: APPS.PQP_GENERIC_EIT_SS
Source
4 -- Package Variables
1 PACKAGE BODY PQP_GENERIC_EIT_SS as
2 /* $Header: pqpexssvehinfo.pkb 120.0 2005/05/29 02:23:01 appldev noship $ */
3 --
5 --
6 -- Package scope global variables.
7 l_transaction_table hr_transaction_ss.transaction_table;
8 l_count INTEGER := 0;
9 l_praddr_ovrlap VARCHAR2(2);
10 l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
11 l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
12 g_package varchar2(31) := 'PQP_GENERIC_EIT_SS';
13 g_data_error exception;
14 l_message_number VARCHAR2(10);
15 g_trans_rec_count integer;
16
17
18 --
19 --
20 FUNCTION get_ovn ( p_eit_type in varchar2
21 ,p_extra_info_id in number
22 ,p_key_id in number
23 )
24 RETURN number IS
25 CURSOR c_get_ovn_rep
26 IS
27 SELECT pvrei.object_version_number
28 FROM pqp_veh_repos_extra_info pvrei
29 WHERE pvrei.veh_repos_extra_info_id = p_extra_info_id
30 AND pvrei.vehicle_repository_id=p_key_id;
31
32 CURSOR c_get_ovn_alloc
33 IS
34 SELECT pvaei.object_version_number
35 FROM pqp_veh_alloc_extra_info pvaei
36 WHERE pvaei.veh_alloc_extra_info_id = p_extra_info_id
37 AND pvaei.vehicle_allocation_id=p_key_id;
38
39 l_ovn pqp_veh_alloc_extra_info.object_version_number%TYPE;
40 BEGIN
41 IF p_eit_type='REPOSITORY' THEN
42 OPEN c_get_ovn_rep;
43 FETCH c_get_ovn_rep INTO l_ovn;
44 CLOSE c_get_ovn_rep;
45 ELSIF p_eit_type='ALLOCATION' THEN
46 OPEN c_get_ovn_alloc;
47 FETCH c_get_ovn_alloc INTO l_ovn;
48 CLOSE c_get_ovn_alloc;
49 END IF;
50 RETURN l_ovn;
51 END;
52
53 --This procedure clears delete row data that is just
54 --created in rthe transaction table and not present
55 --in the actual tables.
56 PROCEDURE clear_delete_trans (p_item_type in varchar2,
57 p_item_key in varchar2,
58 p_transaction_step_id in number
59 )
60 IS
61 BEGIN
62 DELETE from hr_api_transaction_values
63 WHERE transaction_step_id = p_transaction_step_id;
64
65 DELETE from hr_api_transaction_steps
66 WHERE transaction_step_id = p_transaction_step_id;
67
68 EXCEPTION
69 ---------
70 WHEn OTHERS THEN
71 NULL;
72 END;
73
74
75 --This procedure is called to create vehicle information in both
76 --allocation and repository.
77 PROCEDURE create_generic_eit
78 (
79 p_validate in boolean default false
80 ,p_effective_date in date
81 ,p_login_person_id in number
82 ,p_person_id in number
83 ,p_assignment_id in number
84 ,p_business_group_id in number
85 ,p_action in varchar2
86 ,p_eit_type in varchar2
87 ,p_eit_type_id in number
88 ,p_information_type in varchar2
89 ,p_attribute_category in varchar2
90 ,p_attribute1 in varchar2
91 ,p_attribute2 in varchar2
92 ,p_attribute3 in varchar2
93 ,p_attribute4 in varchar2
94 ,p_attribute5 in varchar2
95 ,p_attribute6 in varchar2
96 ,p_attribute7 in varchar2
97 ,p_attribute8 in varchar2
98 ,p_attribute9 in varchar2
99 ,p_attribute10 in varchar2
100 ,p_attribute11 in varchar2
101 ,p_attribute12 in varchar2
102 ,p_attribute13 in varchar2
103 ,p_attribute14 in varchar2
104 ,p_attribute15 in varchar2
105 ,p_attribute16 in varchar2
106 ,p_attribute17 in varchar2
107 ,p_attribute18 in varchar2
108 ,p_attribute19 in varchar2
109 ,p_attribute20 in varchar2
110 ,p_information_category in varchar2
111 ,p_information1 in varchar2
112 ,p_information2 in varchar2
113 ,p_information3 in varchar2
114 ,p_information4 in varchar2
115 ,p_information5 in varchar2
116 ,p_information6 in varchar2
117 ,p_information7 in varchar2
118 ,p_information8 in varchar2
119 ,p_information9 in varchar2
120 ,p_information10 in varchar2
121 ,p_information11 in varchar2
122 ,p_information12 in varchar2
123 ,p_information13 in varchar2
124 ,p_information14 in varchar2
125 ,p_information15 in varchar2
126 ,p_information16 in varchar2
127 ,p_information17 in varchar2
128 ,p_information18 in varchar2
129 ,p_information19 in varchar2
130 ,p_information20 in varchar2
131 ,p_information21 in varchar2
135 ,p_information25 in varchar2
132 ,p_information22 in varchar2
133 ,p_information23 in varchar2
134 ,p_information24 in varchar2
136 ,p_information26 in varchar2
137 ,p_information27 in varchar2
138 ,p_information28 in varchar2
139 ,p_information29 in varchar2
140 ,p_information30 in varchar2
141 ,p_object_version_number in out nocopy number
142 ,p_extra_info_id in out nocopy number
143 ,p_error_message out nocopy varchar2
144 ,p_error_status out nocopy varchar2
145 )
146 IS
147
148
149 l_object_version_number1 NUMBER;
150 l_object_version_number NUMBER;
151 l_vehicle_allocation_id pqp_vehicle_allocations_f.vehicle_allocation_id%TYPE;
152 l_lookup_code hr_lookups.lookup_code%TYPE;
153 l_leg_code pqp_configuration_values.legislation_code%TYPE;
154 l_assignment_id per_all_assignments_f.assignment_id%TYPE;
155 l_correction NUMBER;
156 l_update NUMBER;
157 l_update_override NUMBER;
158 l_update_change_insert NUMBER;
159 l_datetrack_mode VARCHAR2(30);
160 l_cnt NUMBER :=0;
161 l_effective_start_date DATE;
162 l_effective_end_date DATE;
166 e_exist_other_asg EXCEPTION;
163 l_cnt1 NUMBER;
164 l_chk NUMBER:=0;
165 l_dt_adj number:=0;
167 BEGIN
168 IF p_action = 'NEW_ROW' THEN
169 IF p_eit_type ='REPOSITORY' THEN
170
171 pqp_veh_repos_extra_info_api.create_veh_repos_extra_info
172 (p_validate => false
173 ,p_vehicle_repository_id => p_eit_type_id
174 ,p_information_type => p_information_type
175 ,p_vrei_attribute_category => p_attribute_category
176 ,p_vrei_attribute1 => p_attribute1
177 ,p_vrei_attribute2 => p_attribute2
178 ,p_vrei_attribute3 => p_attribute3
179 ,p_vrei_attribute4 => p_attribute4
180 ,p_vrei_attribute5 => p_attribute5
181 ,p_vrei_attribute6 => p_attribute6
182 ,p_vrei_attribute7 => p_attribute7
183 ,p_vrei_attribute8 => p_attribute8
184 ,p_vrei_attribute9 => p_attribute9
185 ,p_vrei_attribute10 => p_attribute10
186 ,p_vrei_attribute11 => p_attribute11
187 ,p_vrei_attribute12 => p_attribute12
188 ,p_vrei_attribute13 => p_attribute13
189 ,p_vrei_attribute14 => p_attribute14
190 ,p_vrei_attribute15 => p_attribute15
191 ,p_vrei_attribute16 => p_attribute16
192 ,p_vrei_attribute17 => p_attribute17
193 ,p_vrei_attribute18 => p_attribute18
194 ,p_vrei_attribute19 => p_attribute19
195 ,p_vrei_attribute20 => p_attribute20
196 ,p_vrei_information_category => p_information_category
197 ,p_vrei_information1 => p_information1
198 ,p_vrei_information2 => p_information2
199 ,p_vrei_information3 => p_information3
200 ,p_vrei_information4 => p_information4
201 ,p_vrei_information5 => p_information5
202 ,p_vrei_information6 => p_information6
203 ,p_vrei_information7 => p_information7
204 ,p_vrei_information8 => p_information8
205 ,p_vrei_information9 => p_information9
206 ,p_vrei_information10 => p_information10
207 ,p_vrei_information11 => p_information11
208 ,p_vrei_information12 => p_information12
209 ,p_vrei_information13 => p_information13
210 ,p_vrei_information14 => p_information14
211 ,p_vrei_information15 => p_information15
212 ,p_vrei_information16 => p_information16
213 ,p_vrei_information17 => p_information17
214 ,p_vrei_information18 => p_information18
215 ,p_vrei_information19 => p_information19
216 ,p_vrei_information20 => p_information20
217 ,p_vrei_information21 => p_information21
218 ,p_vrei_information22 => p_information22
219 ,p_vrei_information23 => p_information23
220 ,p_vrei_information24 => p_information24
221 ,p_vrei_information25 => p_information25
222 ,p_vrei_information26 => p_information26
223 ,p_vrei_information27 => p_information27
224 ,p_vrei_information28 => p_information28
225 ,p_vrei_information29 => p_information29
226 ,p_vrei_information30 => p_information30
227 ,p_veh_repos_extra_info_id => p_extra_info_id
228 ,p_object_version_number => p_object_version_number
229 );
230
231 ELSIF p_eit_type= 'ALLOCATION' THEN
232 pqp_veh_alloc_extra_info_api.create_veh_alloc_extra_info
233 (p_validate => false
234 ,p_vehicle_allocation_id => p_eit_type_id
235 ,p_information_type => p_information_type
236 ,p_vaei_attribute_category => p_attribute_category
237 ,p_vaei_attribute1 => p_attribute1
238 ,p_vaei_attribute2 => p_attribute2
239 ,p_vaei_attribute3 => p_attribute3
240 ,p_vaei_attribute4 => p_attribute4
241 ,p_vaei_attribute5 => p_attribute5
242 ,p_vaei_attribute6 => p_attribute6
243 ,p_vaei_attribute7 => p_attribute7
244 ,p_vaei_attribute8 => p_attribute8
245 ,p_vaei_attribute9 => p_attribute9
246 ,p_vaei_attribute10 => p_attribute10
247 ,p_vaei_attribute11 => p_attribute11
248 ,p_vaei_attribute12 => p_attribute12
249 ,p_vaei_attribute13 => p_attribute13
253 ,p_vaei_attribute17 => p_attribute17
250 ,p_vaei_attribute14 => p_attribute14
251 ,p_vaei_attribute15 => p_attribute15
252 ,p_vaei_attribute16 => p_attribute16
254 ,p_vaei_attribute18 => p_attribute18
255 ,p_vaei_attribute19 => p_attribute19
256 ,p_vaei_attribute20 => p_attribute20
257 ,p_vaei_information_category => p_information_category
258 ,p_vaei_information1 => p_information1
259 ,p_vaei_information2 => p_information2
260 ,p_vaei_information3 => p_information3
261 ,p_vaei_information4 => p_information4
262 ,p_vaei_information5 => p_information5
263 ,p_vaei_information6 => p_information6
264 ,p_vaei_information7 => p_information7
265 ,p_vaei_information8 => p_information8
266 ,p_vaei_information9 => p_information9
267 ,p_vaei_information10 => p_information10
268 ,p_vaei_information11 => p_information11
269 ,p_vaei_information12 => p_information12
270 ,p_vaei_information13 => p_information13
271 ,p_vaei_information14 => p_information14
272 ,p_vaei_information15 => p_information15
273 ,p_vaei_information16 => p_information16
274 ,p_vaei_information17 => p_information17
275 ,p_vaei_information18 => p_information18
276 ,p_vaei_information19 => p_information19
277 ,p_vaei_information20 => p_information20
278 ,p_vaei_information21 => p_information21
279 ,p_vaei_information22 => p_information22
280 ,p_vaei_information23 => p_information23
281 ,p_vaei_information24 => p_information24
282 ,p_vaei_information25 => p_information25
283 ,p_vaei_information26 => p_information26
284 ,p_vaei_information27 => p_information27
285 ,p_vaei_information28 => p_information28
286 ,p_vaei_information29 => p_information29
287 ,p_vaei_information30 => p_information30
288 ,p_veh_alloc_extra_info_id => p_extra_info_id
289 ,p_object_version_number => p_object_version_number
290 );
291
292 END IF;
293 ELSIF p_action = 'UPDATE_ROW' THEN
294 IF p_eit_type= 'REPOSITORY' THEN
295 l_object_version_number:=get_ovn
296 ( p_eit_type => p_eit_type
297 ,p_extra_info_id => p_extra_info_id
298 ,p_key_id => p_eit_type_id
299 );
300
301 pqp_veh_repos_extra_info_api.update_veh_repos_extra_info
302 (p_validate => false
303 ,p_veh_repos_extra_info_id => p_extra_info_id
304 ,p_object_version_number => l_object_version_number
305 ,p_vehicle_repository_id => p_eit_type_id
306 ,p_information_type => p_information_type
307 ,p_vrei_attribute_category => p_attribute_category
308 ,p_vrei_attribute1 => p_attribute1
309 ,p_vrei_attribute2 => p_attribute2
310 ,p_vrei_attribute3 => p_attribute3
311 ,p_vrei_attribute4 => p_attribute4
312 ,p_vrei_attribute5 => p_attribute5
313 ,p_vrei_attribute6 => p_attribute6
314 ,p_vrei_attribute7 => p_attribute7
315 ,p_vrei_attribute8 => p_attribute8
316 ,p_vrei_attribute9 => p_attribute9
317 ,p_vrei_attribute10 => p_attribute10
318 ,p_vrei_attribute11 => p_attribute11
319 ,p_vrei_attribute12 => p_attribute12
320 ,p_vrei_attribute13 => p_attribute13
321 ,p_vrei_attribute14 => p_attribute14
322 ,p_vrei_attribute15 => p_attribute15
323 ,p_vrei_attribute16 => p_attribute16
324 ,p_vrei_attribute17 => p_attribute17
325 ,p_vrei_attribute18 => p_attribute18
326 ,p_vrei_attribute19 => p_attribute19
327 ,p_vrei_attribute20 => p_attribute20
328 ,p_vrei_information_category => p_information_category
329 ,p_vrei_information1 => p_information1
330 ,p_vrei_information2 => p_information2
331 ,p_vrei_information3 => p_information3
332 ,p_vrei_information4 => p_information4
333 ,p_vrei_information5 => p_information5
334 ,p_vrei_information6 => p_information6
335 ,p_vrei_information7 => p_information7
336 ,p_vrei_information8 => p_information8
337 ,p_vrei_information9 => p_information9
338 ,p_vrei_information10 => p_information10
339 ,p_vrei_information11 => p_information11
340 ,p_vrei_information12 => p_information12
341 ,p_vrei_information13 => p_information13
342 ,p_vrei_information14 => p_information14
343 ,p_vrei_information15 => p_information15
344 ,p_vrei_information16 => p_information16
345 ,p_vrei_information17 => p_information17
346 ,p_vrei_information18 => p_information18
347 ,p_vrei_information19 => p_information19
348 ,p_vrei_information20 => p_information20
349 ,p_vrei_information21 => p_information21
350 ,p_vrei_information22 => p_information22
351 ,p_vrei_information23 => p_information23
352 ,p_vrei_information24 => p_information24
353 ,p_vrei_information25 => p_information25
354 ,p_vrei_information26 => p_information26
355 ,p_vrei_information27 => p_information27
356 ,p_vrei_information28 => p_information28
360
357 ,p_vrei_information29 => p_information29
358 ,p_vrei_information30 => p_information30
359 );
361 ELSIF p_eit_type = 'ALLOCATION' THEN
362 l_object_version_number:=get_ovn
363 ( p_eit_type => p_eit_type
364 ,p_extra_info_id => p_extra_info_id
365 ,p_key_id => p_eit_type_id
366 );
367 pqp_veh_alloc_extra_info_api.update_veh_alloc_extra_info
368 (p_validate => false
369 ,p_veh_alloc_extra_info_id => p_extra_info_id
370 ,p_object_version_number => l_object_version_number
371 ,p_vehicle_allocation_id => p_eit_type_id
372 ,p_information_type => p_information_type
373 ,p_vaei_attribute_category => p_attribute_category
374 ,p_vaei_attribute1 => p_attribute1
375 ,p_vaei_attribute2 => p_attribute2
376 ,p_vaei_attribute3 => p_attribute3
377 ,p_vaei_attribute4 => p_attribute4
378 ,p_vaei_attribute5 => p_attribute5
379 ,p_vaei_attribute6 => p_attribute6
380 ,p_vaei_attribute7 => p_attribute7
381 ,p_vaei_attribute8 => p_attribute8
382 ,p_vaei_attribute9 => p_attribute9
383 ,p_vaei_attribute10 => p_attribute10
384 ,p_vaei_attribute11 => p_attribute11
385 ,p_vaei_attribute12 => p_attribute12
386 ,p_vaei_attribute13 => p_attribute13
387 ,p_vaei_attribute14 => p_attribute14
388 ,p_vaei_attribute15 => p_attribute15
389 ,p_vaei_attribute16 => p_attribute16
390 ,p_vaei_attribute17 => p_attribute17
391 ,p_vaei_attribute18 => p_attribute18
392 ,p_vaei_attribute19 => p_attribute19
393 ,p_vaei_attribute20 => p_attribute20
394 ,p_vaei_information_category => p_information_category
395 ,p_vaei_information1 => p_information1
396 ,p_vaei_information2 => p_information2
397 ,p_vaei_information3 => p_information3
398 ,p_vaei_information4 => p_information4
399 ,p_vaei_information5 => p_information5
400 ,p_vaei_information6 => p_information6
401 ,p_vaei_information7 => p_information7
402 ,p_vaei_information8 => p_information8
403 ,p_vaei_information9 => p_information9
404 ,p_vaei_information10 => p_information10
405 ,p_vaei_information11 => p_information11
406 ,p_vaei_information12 => p_information12
407 ,p_vaei_information13 => p_information13
408 ,p_vaei_information14 => p_information14
409 ,p_vaei_information15 => p_information15
410 ,p_vaei_information16 => p_information16
411 ,p_vaei_information17 => p_information17
412 ,p_vaei_information18 => p_information18
413 ,p_vaei_information19 => p_information19
414 ,p_vaei_information20 => p_information20
415 ,p_vaei_information21 => p_information21
416 ,p_vaei_information22 => p_information22
417 ,p_vaei_information23 => p_information23
418 ,p_vaei_information24 => p_information24
419 ,p_vaei_information25 => p_information25
420 ,p_vaei_information26 => p_information26
421 ,p_vaei_information27 => p_information27
422 ,p_vaei_information28 => p_information28
423 ,p_vaei_information29 => p_information29
424 ,p_vaei_information30 => p_information30
425 );
426 END IF;
427 ELSIF p_action= 'DELETE_ROW' THEN
428
429 IF p_eit_type='REPOSITORY' THEN
430 l_object_version_number:=get_ovn
431 ( p_eit_type => p_eit_type
432 ,p_extra_info_id => p_extra_info_id
433 ,p_key_id => p_eit_type_id
434 );
435 pqp_veh_repos_extra_info_api.delete_veh_repos_extra_info
436 (p_validate => false
437 ,p_veh_repos_extra_info_id => p_extra_info_id
438 ,p_object_version_number => l_object_version_number
439 );
440
441 ELSIF p_eit_type = 'ALLOCATION' THEN
442 l_object_version_number:=get_ovn
443 ( p_eit_type => p_eit_type
444 ,p_extra_info_id => p_extra_info_id
445 ,p_key_id => p_eit_type_id
446 );
447 pqp_veh_alloc_extra_info_api.delete_veh_alloc_extra_info
448 (p_validate => false
449 ,p_veh_alloc_extra_info_id => p_extra_info_id
450 ,p_object_version_number => l_object_version_number
451 );
452
453 END IF;
454
455 END IF;
456 EXCEPTION
457 WHEN hr_utility.hr_error THEN
458 hr_utility.raise_error;
459 WHEN OTHERS THEN
460 RAISE; -- Raise error here relevant to the new tech stack.
461 END;
462
463
464
465 PROCEDURE set_extra_info
466 (p_effective_date in DATE
467 ,p_person_id in number
468 ,p_login_person_id in number
469 ,p_assignment_id in number
470 ,p_business_group_id in number
471 ,p_eit_type in varchar2
472 ,p_eit_type_id in number
473 ,p_eit_number in number
474 ,p_eit_table in HR_EIT_STRUCTURE_TABLE
475 ,p_item_type in varchar2
476 ,p_item_key in varchar2
477 ,p_activity_id in number
478 ,p_transaction_step_id in out nocopy number
482 ,p_status in varchar2
479 ,p_error_message out nocopy varchar2
480 ,p_active_view in varchar2
481 ,p_active_row_id in number
483 ,p_key_id in VARCHAR2 --this is registration_number
484 ,p_flow_mode in varchar2 default null
485 ) is
486 l_transaction_id NUMBER DEFAULT NULL;
487 l_trans_obj_vers_num NUMBER DEFAULT NULL;
488 l_trans_step_rows NUMBER DEFAULT NULL;
489 l_result VARCHAR2(100) DEFAULT NULL;
490 l_count NUMBER DEFAULT 0;
491 l_transaction_table hr_transaction_ss.transaction_table;
492 l_review_item_name VARCHAR2(50);
493 l_eit_number NUMBER := 0;
494 l_object_version_number NUMBER:=1;
495 l_api_name hr_api_transaction_steps.api_name%TYPE
496 := 'PQP_GENERIC_EIT_SS.PROCESS_API';
497 l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';
498 l_get_action VARCHAR2(30);
499 l_extra_info_id NUMBER;
500
501 BEGIN
502 -- First, check if transaction id exists or not
503 l_transaction_id := hr_transaction_ss.get_transaction_id
504 (p_item_type => p_item_type
505 ,p_item_key => p_item_key);
506 hr_utility.set_location(' l_transaction_id: '||l_transaction_id,5 );
507 --
508
509
510 --
511 -- Create a transaction step
512 --
513
514 l_count := 1;
515 l_transaction_table(l_count).param_name := 'P_PERSON_ID';
516 l_transaction_table(l_count).param_value := p_person_id;
517 l_transaction_table(l_count).param_data_type := 'NUMBER';
518
519 l_count := l_count +1;
520 l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
521 l_transaction_table(l_count).param_value :=fnd_date.displaydate_to_date( p_effective_date);
522 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
523
524 l_count := l_count + 1;
525 l_transaction_table(l_count).param_name := 'P_LOGIN_PERSON_ID';
526 l_transaction_table(l_count).param_value := p_login_person_id;
527 l_transaction_table(l_count).param_data_type := 'NUMBER';
528
529 l_count := l_count + 1;
530 l_transaction_table(l_count).param_name := 'P_ASSIGNMENT_ID';
531 l_transaction_table(l_count).param_value := p_assignment_id;
532 l_transaction_table(l_count).param_data_type := 'NUMBER';
533
534 l_count := l_count + 1;
535 l_transaction_table(l_count).param_name := 'P_BUSINESS_GROUP_ID';
536 l_transaction_table(l_count).param_value := p_business_group_id;
537 l_transaction_table(l_count).param_data_type := 'NUMBER';
538
539 l_count := l_count + 1;
540 l_transaction_table(l_count).param_name := 'P_EIT_TYPE';
541 l_transaction_table(l_count).param_value := p_eit_type;
542 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
543
544 l_count := l_count + 1;
545 l_transaction_table(l_count).param_name := 'P_EIT_TYPE_ID';
546 l_transaction_table(l_count).param_value := p_eit_type_id;
547 l_transaction_table(l_count).param_data_type := 'NUMBER';
548
549 l_count := l_count + 1;
550 l_transaction_table(l_count).param_name := 'P_EIT_NUMBER';
551 l_transaction_table(l_count).param_value := p_eit_number;
552 l_transaction_table(l_count).param_data_type := 'NUMBER';
553
554 l_count := l_count + 1;
555 l_transaction_table(l_count).param_name := 'P_KEY_ID';
556 l_transaction_table(l_count).param_value := p_key_id;
557 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
558
559 hr_utility.set_location('..p_login_person_id'||p_login_person_id, 6);
560 hr_utility.set_location('..p_assignment_id'||p_assignment_id, 6);
561 hr_utility.set_location('..p_eit_type'||p_eit_type, 6);
562 hr_utility.set_location('..p_eit_number'||p_eit_number, 6);
563 hr_utility.set_location('..p_business_group_id'||p_business_group_id, 6);
564 hr_utility.set_location('..p_eit_type_id'||p_eit_type_id, 6);
565 hr_utility.set_location('..p_item_type'||p_item_type, 6);
566 hr_utility.set_location('..p_item_key'||p_item_key, 6);
567 hr_utility.set_location('..p_activity_id'||p_activity_id, 6);
568
569
570 l_review_item_name :=
571 wf_engine.GetActivityAttrText(itemtype => p_item_type,
572 itemkey => p_item_key,
573 actid => p_activity_id,
574 aname => gv_wf_review_region_item);
575
576
577 l_count := l_count + 1;
578 l_transaction_table(l_count).param_name := 'P_REVIEW_PROC_CALL';
579 l_transaction_table(l_count).param_value := l_review_proc_call;
580 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
581
582 hr_utility.set_location('..l_review_item_name'||l_review_item_name, 6);
583 hr_utility.set_location('..p_active_view'||p_active_view, 6);
584 hr_utility.set_location('..p_active_row_id'||p_active_row_id, 6);
585
586
587 l_count := l_count + 1;
588 l_transaction_table(l_count).param_name := 'P_REVIEW_ACTID';
589 l_transaction_table(l_count).param_value := p_activity_id;
590 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
591
592 -- for the update page when we rebuild the page after a
593 -- save for later
594 l_count := l_count + 1;
595 l_transaction_table(l_count).param_name := 'P_ACTIVE_VIEW';
596 l_transaction_table(l_count).param_value := p_active_view;
597 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
598
599 l_count := l_count + 1;
600 l_transaction_table(l_count).param_name := 'P_ACTIVE_ROW_ID';
601 l_transaction_table(l_count).param_value := p_active_row_id;
602 l_transaction_table(l_count).param_data_type := 'NUMBER';
606 l_eit_number := p_eit_number;
603
604
605
607
608 FOR i in 1..l_eit_number
609 LOOP
610
611 hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).action, 6);
612 hr_utility.set_location('..p_eit_table(i).action'||p_eit_table(i).extra_info_id, 6);
613 hr_utility.set_location('..p_eit_table(i).object_version_number'||p_eit_table(i).object_version_number, 6);
614 hr_utility.set_location('..p_eit_table(i).information_type'||p_eit_table(i).information_type, 6);
615
616 l_count := l_count + 1;
617 l_transaction_table(l_count).param_name := 'P_ACTION_'||i;
618 l_transaction_table(l_count).param_value := p_eit_table(i).action;
619 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
620 l_get_action:=p_eit_table(i).action;
621 l_count := l_count + 1;
622 l_transaction_table(l_count).param_name := 'P_EXTRA_INFO_ID_'||i;
623 l_transaction_table(l_count).param_value := p_eit_table(i).extra_info_id;
624 l_transaction_table(l_count).param_data_type := 'NUMBER';
625 l_extra_info_id := p_eit_table(i).extra_info_id;
626 l_count := l_count + 1;
627 l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER_'||i;
628 l_transaction_table(l_count).param_value := p_eit_table(i).object_version_number;
629 l_transaction_table(l_count).param_data_type := 'NUMBER';
630
631 l_count := l_count + 1;
632 l_transaction_table(l_count).param_name := 'P_INFORMATION_TYPE_'||i;
633 l_transaction_table(l_count).param_value := p_eit_table(i).information_type;
634 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
635
636 -- Now add all the Descriptive flex fields into transactions tables
637
638 l_count := l_count + 1; -- CONTEXT
639 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_CATEGORY_'||i;
640 l_transaction_table(l_count).param_value := p_eit_table(i).attribute_category;
641 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
642
643 l_count := l_count + 1;
644 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE1_'||i;
645 l_transaction_table(l_count).param_value := p_eit_table(i).attribute1;
646 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
647
648 l_count := l_count + 1;
649 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE2_'||i;
650 l_transaction_table(l_count).param_value := p_eit_table(i).attribute2;
651 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
652
653 l_count := l_count + 1;
654 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE3_'||i;
655 l_transaction_table(l_count).param_value := p_eit_table(i).attribute3;
656 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
657
658 l_count := l_count + 1;
659 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE4_'||i;
660 l_transaction_table(l_count).param_value := p_eit_table(i).attribute4;
661 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
662
663 l_count := l_count + 1;
664 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE5_'||i;
665 l_transaction_table(l_count).param_value := p_eit_table(i).attribute5;
666 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
667
668 l_count := l_count + 1;
669 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE6_'||i;
670 l_transaction_table(l_count).param_value := p_eit_table(i).attribute6;
671 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
672
673 l_count := l_count + 1;
674 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE7_'||i;
675 l_transaction_table(l_count).param_value := p_eit_table(i).attribute7;
676 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
677
678 l_count := l_count + 1;
679 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE8_'||i;
680 l_transaction_table(l_count).param_value := p_eit_table(i).attribute8;
681 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
682
683 l_count := l_count + 1;
684 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE9_'||i;
685 l_transaction_table(l_count).param_value := p_eit_table(i).attribute9;
686 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
687
688 l_count := l_count + 1;
689 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE10_'||i;
690 l_transaction_table(l_count).param_value := p_eit_table(i).attribute10;
691 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
692
693 l_count := l_count + 1;
694 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE11_'||i;
695 l_transaction_table(l_count).param_value := p_eit_table(i).attribute11;
696 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
697
698 l_count := l_count + 1;
699 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE12_'||i;
700 l_transaction_table(l_count).param_value := p_eit_table(i).attribute12;
701 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
702
703 l_count := l_count + 1;
704 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE13_'||i;
705 l_transaction_table(l_count).param_value := p_eit_table(i).attribute13;
706 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
707
708 l_count := l_count + 1;
709 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE14_'||i;
710 l_transaction_table(l_count).param_value := p_eit_table(i).attribute14;
711 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
712
713 l_count := l_count + 1;
714 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE15_'||i;
715 l_transaction_table(l_count).param_value := p_eit_table(i).attribute15;
716 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
717
718 l_count := l_count + 1;
719 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE16_'||i;
723 l_count := l_count + 1;
720 l_transaction_table(l_count).param_value := p_eit_table(i).attribute16;
721 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
722
724 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE17_'||i;
725 l_transaction_table(l_count).param_value := p_eit_table(i).attribute17;
726 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
727
728 l_count := l_count + 1;
729 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE18_'||i;
730 l_transaction_table(l_count).param_value := p_eit_table(i).attribute18;
731 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
732
733 l_count := l_count + 1;
734 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE19_'||i;
735 l_transaction_table(l_count).param_value := p_eit_table(i).attribute19;
736 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
737
738 l_count := l_count + 1;
739 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE20_'||i;
740 l_transaction_table(l_count).param_value := p_eit_table(i).attribute20;
741 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
742
743 ---Information Category Context
744 hr_utility.set_location('.inside loop '||p_eit_table(i).information_category, 6);
745 hr_utility.set_location('.inside loop information1'||p_eit_table(i).information1, 6);
746 hr_utility.set_location('.inside loop information1'||p_eit_table(i).information2, 6);
747
748 l_count := l_count + 1;
749 l_transaction_table(l_count).param_name := 'P_INFORMATION_CATEGORY_'||i;
750 l_transaction_table(l_count).param_value := p_eit_table(i).information_category;
751 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
752
753 l_count := l_count + 1;
754 l_transaction_table(l_count).param_name := 'P_INFORMATION1_'||i;
755 l_transaction_table(l_count).param_value := p_eit_table(i).information1;
756 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
757
758 l_count := l_count + 1;
759 l_transaction_table(l_count).param_name := 'P_INFORMATION2_'||i;
760 l_transaction_table(l_count).param_value := p_eit_table(i).information2;
761 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
762
763 l_count := l_count + 1;
764 l_transaction_table(l_count).param_name := 'P_INFORMATION3_'||i;
765 l_transaction_table(l_count).param_value := p_eit_table(i).information3;
766 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
767
768 l_count := l_count + 1;
769 l_transaction_table(l_count).param_name := 'P_INFORMATION4_'||i;
770 l_transaction_table(l_count).param_value := p_eit_table(i).information4;
771 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
772
773 l_count := l_count + 1;
774 l_transaction_table(l_count).param_name := 'P_INFORMATION5_'||i;
775 l_transaction_table(l_count).param_value := p_eit_table(i).information5;
776 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
777
778 l_count := l_count + 1;
779 l_transaction_table(l_count).param_name := 'P_INFORMATION6_'||i;
780 l_transaction_table(l_count).param_value := p_eit_table(i).information6;
781 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
782
783 l_count := l_count + 1;
784 l_transaction_table(l_count).param_name := 'P_INFORMATION7_'||i;
785 l_transaction_table(l_count).param_value := p_eit_table(i).information7;
786 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
787
788 l_count := l_count + 1;
789 l_transaction_table(l_count).param_name := 'P_INFORMATION8_'||i;
790 l_transaction_table(l_count).param_value := p_eit_table(i).information8;
791 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
792
793 l_count := l_count + 1;
794 l_transaction_table(l_count).param_name := 'P_INFORMATION9_'||i;
795 l_transaction_table(l_count).param_value := p_eit_table(i).information9;
796 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
797
798 l_count := l_count + 1;
799 l_transaction_table(l_count).param_name := 'P_INFORMATION10_'||i;
800 l_transaction_table(l_count).param_value := p_eit_table(i).information10;
801 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
802
803 l_count := l_count + 1;
804 l_transaction_table(l_count).param_name := 'P_INFORMATION11_'||i;
805 l_transaction_table(l_count).param_value := p_eit_table(i).information11;
806 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
807
808 l_count := l_count + 1;
809 l_transaction_table(l_count).param_name := 'P_INFORMATION12_'||i;
810 l_transaction_table(l_count).param_value := p_eit_table(i).information12;
811 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
812
813 l_count := l_count + 1;
814 l_transaction_table(l_count).param_name := 'P_INFORMATION13_'||i;
815 l_transaction_table(l_count).param_value := p_eit_table(i).information13;
816 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
817
818 l_count := l_count + 1;
819 l_transaction_table(l_count).param_name := 'P_INFORMATION14_'||i;
820 l_transaction_table(l_count).param_value := p_eit_table(i).information14;
821 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
822
823 l_count := l_count + 1;
824 l_transaction_table(l_count).param_name := 'P_INFORMATION15_'||i;
825 l_transaction_table(l_count).param_value := p_eit_table(i).information15;
826 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
827
828 l_count := l_count + 1;
829 l_transaction_table(l_count).param_name := 'P_INFORMATION16_'||i;
830 l_transaction_table(l_count).param_value := p_eit_table(i).information16;
831 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
832
833 l_count := l_count + 1;
834 l_transaction_table(l_count).param_name := 'P_INFORMATION17_'||i;
838 l_count := l_count + 1;
835 l_transaction_table(l_count).param_value := p_eit_table(i).information17;
836 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
837
839 l_transaction_table(l_count).param_name := 'P_INFORMATION18_'||i;
840 l_transaction_table(l_count).param_value := p_eit_table(i).information18;
841 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
842
843 l_count := l_count + 1;
844 l_transaction_table(l_count).param_name := 'P_INFORMATION19_'||i;
845 l_transaction_table(l_count).param_value := p_eit_table(i).information19;
846 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
847
848 l_count := l_count + 1;
849 l_transaction_table(l_count).param_name := 'P_INFORMATION20_'||i;
850 l_transaction_table(l_count).param_value := p_eit_table(i).information20;
851 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
852
853 l_count := l_count + 1;
854 l_transaction_table(l_count).param_name := 'P_INFORMATION21_'||i;
855 l_transaction_table(l_count).param_value := p_eit_table(i).information11;
856 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
857
858 l_count := l_count + 1;
859 l_transaction_table(l_count).param_name := 'P_INFORMATION22_'||i;
860 l_transaction_table(l_count).param_value := p_eit_table(i).information12;
861 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
862
863 l_count := l_count + 1;
864 l_transaction_table(l_count).param_name := 'P_INFORMATION23_'||i;
865 l_transaction_table(l_count).param_value := p_eit_table(i).information13;
866 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
867
868 l_count := l_count + 1;
869 l_transaction_table(l_count).param_name := 'P_INFORMATION24_'||i;
870 l_transaction_table(l_count).param_value := p_eit_table(i).information14;
871 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
872
873 l_count := l_count + 1;
874 l_transaction_table(l_count).param_name := 'P_INFORMATION25_'||i;
875 l_transaction_table(l_count).param_value := p_eit_table(i).information15;
876 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
877
878 l_count := l_count + 1;
879 l_transaction_table(l_count).param_name := 'P_INFORMATION26_'||i;
880 l_transaction_table(l_count).param_value := p_eit_table(i).information16;
881 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
882
883 l_count := l_count + 1;
884 l_transaction_table(l_count).param_name := 'P_INFORMATION27_'||i;
885 l_transaction_table(l_count).param_value := p_eit_table(i).information17;
886 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
887
888 l_count := l_count + 1;
889 l_transaction_table(l_count).param_name := 'P_INFORMATION28_'||i;
890 l_transaction_table(l_count).param_value := p_eit_table(i).information18;
891 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
892
893 l_count := l_count + 1;
894 l_transaction_table(l_count).param_name := 'P_INFORMATION29_'||i;
895 l_transaction_table(l_count).param_value := p_eit_table(i).information19;
896 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
897
898 l_count := l_count + 1;
899 l_transaction_table(l_count).param_name := 'P_INFORMATION30_'||i;
900 l_transaction_table(l_count).param_value := p_eit_table(i).information20;
901 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
902 -- EndRegistration
903 --
904 END LOOP;
905
906 IF l_transaction_id is NULL THEN
907 hr_transaction_api.create_transaction(
908 p_validate =>false
909 ,p_creator_person_id =>p_login_person_id
910 ,p_transaction_privilege =>'PRIVATE'
911 ,p_product_code =>'PQP'
912 ,p_url =>NULL
913 ,p_status =>p_status
914 ,p_section_display_name =>NULL
915 ,p_function_id =>NULL
916 ,p_transaction_ref_table =>NULL
917 ,p_transaction_ref_id =>NULL
918 ,p_transaction_type =>NULL
919 ,p_assignment_id =>p_assignment_id
920 ,p_selected_person_id =>p_person_id
921 ,p_item_type =>p_item_type
922 ,p_item_key =>p_item_key
923 ,p_transaction_effective_date =>p_effective_date
924 ,p_process_name =>NULL
925 ,p_plan_id =>NULL
926 ,p_rptg_grp_id =>NULL
927 ,p_effective_date_option =>p_effective_date
928 ,p_transaction_id => l_transaction_id
929 );
930
931 wf_engine.setitemattrnumber
932 (itemtype => p_item_type
933 ,itemkey => p_item_key
934 ,aname => 'TRANSACTION_ID'
935 ,avalue => l_transaction_id);
936 -- x_transaction_id := l_transaction_id;
937 --Create transaction steps
938 hr_transaction_api.create_transaction_step
939 (p_validate =>false
940 ,p_creator_person_id =>p_login_person_id
941 ,p_transaction_id =>l_transaction_id
942 ,p_api_name =>l_api_name
943 ,p_api_display_name =>l_api_name
944 ,p_item_type =>p_item_type
945 ,p_item_key =>p_item_key
946 ,p_activity_id =>p_activity_id
947 ,p_transaction_step_id =>l_transaction_step_id
951 IF p_transaction_step_id IS NOT NULL AND
948 ,p_object_version_number =>l_object_version_number
949 );
950 ELSE
952 p_transaction_step_id <>0 THEN
953 hr_transaction_api.update_transaction
954 (p_transaction_id =>l_transaction_id
955 ,p_status =>p_status
956 );
957 DELETE from hr_api_transaction_values
958 WHERE transaction_step_id = p_transaction_step_id;
959 l_transaction_step_id := p_transaction_step_id;
960 ELSE
961 --l_transaction_step_id := p_transaction_step_id;
962
963 --l_transaction_step_id := p_transaction_step_id;
964 l_transaction_step_id:=NULL;
965
966 hr_transaction_api.create_transaction_step
967 (p_validate =>false
968 ,p_creator_person_id =>p_login_person_id
969 ,p_transaction_id =>l_transaction_id
970 ,p_api_name =>l_api_name
971 ,p_api_display_name =>l_api_name
972 ,p_item_type =>p_item_type
973 ,p_item_key =>p_item_key
974 ,p_activity_id =>p_activity_id
975 -- ,p_processing_order =>2
976 ,p_transaction_step_id =>l_transaction_step_id
977 ,p_object_version_number =>l_object_version_number
978 );
979
980 END IF;
981 END IF;
982 FOR i in 1..l_transaction_table.count
983 LOOP
984 IF l_transaction_table(i).param_data_type ='VARCHAR2' THEN
985 hr_transaction_api.set_varchar2_value
986 (p_transaction_step_id => l_transaction_step_id
987 ,p_person_id => p_person_id
988 ,p_name => l_transaction_table(i).param_name
989 ,p_value => l_transaction_table(i).param_value
990 );
991
992 ELSIF l_transaction_table(i).param_data_type ='DATE' THEN
993 hr_transaction_api.set_date_value
994 (
995 p_transaction_step_id => l_transaction_step_id
996 ,p_person_id => p_person_id
997 ,p_name => l_transaction_table (i).param_name
998 ,p_value =>fnd_date.displaydate_to_date
999 (l_transaction_table (i).param_value) );
1000 -- ,p_original_value );
1001
1002
1003 ELSIF l_transaction_table(i).param_data_type ='NUMBER' THEN
1004 hr_transaction_api.set_number_value
1005 (
1006 p_transaction_step_id => l_transaction_step_id
1007 ,p_person_id => p_person_id
1008 ,p_name =>l_transaction_table (i).param_name
1009 ,p_value =>TO_NUMBER(l_transaction_table (i).param_value ));
1010 END IF;
1011 END LOOP;
1012
1013 Commit;
1014
1015
1016 --hr_utility.trace_off;
1017 EXCEPTION
1018 -- Catch any exception thrown while storing transaction data
1019 WHEN OTHERS THEN
1020 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1021 p_error_message => p_error_message);
1022
1023
1024
1025
1026 END set_extra_info;
1027
1028
1029
1030
1031
1032
1033 -- ---------------------------------------------------------------------------
1034 -- ---------------------- < get_eit_data_from_tt> -------------------------
1035 -- ---------------------------------------------------------------------------
1036 -- Purpose: This procedure will get transaction data which are pending for
1037 -- approval in workflow for a given person id, workflow process name
1038 -- and workflow activity name. This is the overloaded version.
1039 -- ---------------------------------------------------------------------------
1040 PROCEDURE get_eit_data_from_tt
1041 (p_item_type in varchar2
1042 ,p_item_key in varchar2
1043 ,p_activity_id in number
1044 ,p_effective_date out nocopy date
1045 ,p_person_id out nocopy number
1046 ,p_login_person_id out nocopy number
1047 ,p_assignment_id out nocopy number
1048 ,p_business_group_id out nocopy number
1049 ,p_eit_type out nocopy varchar2
1050 ,p_eit_type_id out nocopy number
1051 ,p_eit_number out nocopy number
1052 ,p_key_id out nocopy varchar2
1053 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
1054 ,p_error_message out nocopy long
1055 ,p_active_view out nocopy varchar2
1056 ,p_active_row_id out nocopy number
1057 )
1058 IS
1059
1060 l_transaction_id number;
1061 l_trans_step_id number;
1062 l_trans_obj_vers_num number;
1063 l_count number default 0;
1064 l_trans_rec_count number;
1065 l_effective_date date;
1066
1067 BEGIN
1068
1069 -- ------------------------------------------------------------------
1070 -- Check if there are any transaction rec already saved for the current
1071 -- transaction. This is used for re-display the Update page when a user
1072 -- clicks the Back button on the Review page to go back to the Update page
1073 -- to make further changes or to correct errors.
1074 -----------------------------------------------------------------------------
1075
1079 ,p_activity_id => p_activity_id
1076 hr_transaction_api.get_transaction_step_info
1077 (p_item_type => p_item_type
1078 ,p_item_key => p_item_key
1080 ,p_transaction_step_id => l_trans_step_id
1081 ,p_object_version_number => l_trans_obj_vers_num);
1082
1083
1084 IF l_trans_step_id IS NOT NULL OR
1085 l_trans_step_id > 0
1086 THEN
1087 l_trans_rec_count := 1;
1088 ELSE
1089 l_trans_rec_count := 0;
1090 return;
1091 END IF;
1092
1093 --
1094 -- -------------------------------------------------------------------
1095 -- There are some changes made earlier in the transaction.
1096 -- Retrieve the data and return to caller.
1097 -- -------------------------------------------------------------------
1098
1099 -- Now get the transaction data for the given step
1100 get_eit_data_from_tt
1101 (p_transaction_step_id => l_trans_step_id
1102 ,p_effective_date => l_effective_date
1103 ,p_person_id => p_person_id
1104 ,p_login_person_id => p_login_person_id
1105 ,p_assignment_id => p_assignment_id
1106 ,p_business_group_id => p_business_group_id
1107 ,p_eit_type => p_eit_type
1108 ,p_eit_type_id => p_eit_type_id
1109 ,p_eit_number => p_eit_number
1110 ,p_key_id =>p_key_id
1111 ,p_eit_table => p_eit_table
1112 ,p_error_message => p_error_message
1113 ,p_active_view => p_active_view
1114 ,p_active_row_id => p_active_row_id
1115 );
1116
1117 g_trans_rec_count := l_trans_rec_count;
1118
1119 EXCEPTION
1120 -- Catch any exception thrown while storing transaction data
1121 WHEN OTHERS THEN
1122 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1123 p_error_message => p_error_message);
1124
1125
1126 END get_eit_data_from_tt;
1127
1128
1129 -- ---------------------------------------------------------------------------
1130 -- ---------------------- < get_eit_data_from_tt> -------------------------
1131 -- ---------------------------------------------------------------------------
1132 -- Purpose: This procedure will get transaction data which are pending for
1133 -- approval in workflow for a transaction step id.
1134 -- ---------------------------------------------------------------------------
1135 PROCEDURE get_eit_data_from_tt
1136 (p_transaction_step_id in number
1137 ,p_effective_date out nocopy date
1138 ,p_person_id out nocopy number
1139 ,p_login_person_id out nocopy number
1140 ,p_assignment_id out nocopy number
1141 ,p_business_group_id out nocopy number
1142 ,p_eit_type out nocopy varchar2
1143 ,p_eit_type_id out nocopy number
1144 ,p_eit_number out nocopy number
1145 ,p_key_id out nocopy varchar2
1146 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
1147 ,p_error_message out nocopy long
1148 ,p_active_view out nocopy varchar2
1149 ,p_active_row_id out nocopy number
1150 )IS
1151
1152 l_number_eit NUMBER := 0;
1153 l_eit_table HR_EIT_STRUCTURE_TABLE;
1154
1155 BEGIN
1156
1157
1158 p_effective_date := hr_transaction_api.get_date_value
1159 (p_transaction_step_id => p_transaction_step_id
1160 ,p_name => 'P_EFFECTIVE_DATE');
1161
1162 p_person_id := hr_transaction_api.get_number_value
1163 (p_transaction_step_id => p_transaction_step_id
1164 ,p_name => 'P_PERSON_ID');
1165
1166 p_login_person_id := hr_transaction_api.get_number_value
1167 (p_transaction_step_id => p_transaction_step_id
1168 ,p_name => 'P_LOGIN_PERSON_ID');
1169
1170 p_assignment_id := hr_transaction_api.get_number_value
1171 (p_transaction_step_id => p_transaction_step_id
1172 ,p_name => 'P_ASSIGNMENT_ID');
1173
1174 p_business_group_id := hr_transaction_api.get_number_value
1175 (p_transaction_step_id => p_transaction_step_id
1176 ,p_name => 'P_BUSINESS_GROUP_ID');
1177
1178 p_eit_type := hr_transaction_api.get_varchar2_value
1179 (p_transaction_step_id => p_transaction_step_id
1180 ,p_name => 'P_EIT_TYPE');
1181
1182 p_eit_type_id := hr_transaction_api.get_number_value
1183 (p_transaction_step_id => p_transaction_step_id
1184 ,p_name => 'P_EIT_TYPE_ID');
1185
1186 p_key_id := hr_transaction_api.get_varchar2_value
1187 (p_transaction_step_id => p_transaction_step_id
1188 ,p_name => 'P_KEY_ID');
1189
1190 p_eit_number := hr_transaction_api.get_number_value
1191 (p_transaction_step_id => p_transaction_step_id
1192 ,p_name => 'P_EIT_NUMBER');
1193
1194 p_active_view := hr_transaction_api.get_varchar2_value
1195 (p_transaction_step_id => p_transaction_step_id
1196 ,p_name => 'P_ACTIVE_VIEW');
1197
1198 p_active_row_id := hr_transaction_api.get_number_value
1199 (p_transaction_step_id => p_transaction_step_id
1200 ,p_name => 'P_ACTIVE_ROW_ID');
1201
1202
1203 l_number_eit := p_eit_number;
1204
1205 l_eit_table := HR_EIT_STRUCTURE_TABLE();
1206
1207
1208 FOR i in 1 ..l_number_eit LOOP
1209 --
1210 l_eit_table.extend;
1211
1212 --
1213 l_eit_table(i) := HR_EIT_STRUCTURE_TYPE
1214 (
1215 -- action
1219
1216 hr_transaction_api.get_varchar2_value
1217 (p_transaction_step_id => p_transaction_step_id
1218 ,p_name => 'P_ACTION_'||i)
1220 -- extra info id
1221 ,hr_transaction_api.get_number_value
1222 (p_transaction_step_id => p_transaction_step_id
1223 ,p_name => 'P_EXTRA_INFO_ID_'||i)
1224
1225 --object_version_number
1226 ,hr_transaction_api.get_number_value
1227 (p_transaction_step_id => p_transaction_step_id
1228 ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
1229
1230 --information_type
1231 ,hr_transaction_api.get_varchar2_value
1232 (p_transaction_step_id => p_transaction_step_id
1233 ,p_name => 'P_INFORMATION_TYPE_'||i)
1234
1235 --attribute_category
1236 ,hr_transaction_api.get_varchar2_value
1237 (p_transaction_step_id => p_transaction_step_id
1238 ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
1239
1240 --attribute1
1241 ,hr_transaction_api.get_varchar2_value
1242 (p_transaction_step_id => p_transaction_step_id
1243 ,p_name => 'P_ATTRIBUTE1_'||i)
1244
1245 --attribute2
1246 ,hr_transaction_api.get_varchar2_value
1247 (p_transaction_step_id => p_transaction_step_id
1248 ,p_name => 'P_ATTRIBUTE2_'||i)
1249
1250 --attribute3
1251 ,hr_transaction_api.get_varchar2_value
1252 (p_transaction_step_id => p_transaction_step_id
1253 ,p_name => 'P_ATTRIBUTE3_'||i)
1254
1255 --attribute4
1256 ,hr_transaction_api.get_varchar2_value
1257 (p_transaction_step_id => p_transaction_step_id
1258 ,p_name => 'P_ATTRIBUTE4_'||i)
1259
1260 --attribute5
1261 ,hr_transaction_api.get_varchar2_value
1262 (p_transaction_step_id => p_transaction_step_id
1263 ,p_name => 'P_ATTRIBUTE5_'||i)
1264
1265 --attribute6
1266 ,hr_transaction_api.get_varchar2_value
1267 (p_transaction_step_id => p_transaction_step_id
1268 ,p_name => 'P_ATTRIBUTE6_'||i)
1269
1270 --attribute7
1271 ,hr_transaction_api.get_varchar2_value
1272 (p_transaction_step_id => p_transaction_step_id
1273 ,p_name => 'P_ATTRIBUTE7_'||i)
1274
1275 --attribute8
1276 ,hr_transaction_api.get_varchar2_value
1277 (p_transaction_step_id => p_transaction_step_id
1278 ,p_name => 'P_ATTRIBUTE8_'||i)
1279
1280 --attribute9
1281 ,hr_transaction_api.get_varchar2_value
1282 (p_transaction_step_id => p_transaction_step_id
1283 ,p_name => 'P_ATTRIBUTE9_'||i)
1284
1285 --attribute10
1286 ,hr_transaction_api.get_varchar2_value
1287 (p_transaction_step_id => p_transaction_step_id
1288 ,p_name => 'P_ATTRIBUTE10_'||i)
1289
1290 --attribute11
1291 ,hr_transaction_api.get_varchar2_value
1292 (p_transaction_step_id => p_transaction_step_id
1293 ,p_name => 'P_ATTRIBUTE11_'||i)
1294
1295 --attribute12
1296 ,hr_transaction_api.get_varchar2_value
1297 (p_transaction_step_id => p_transaction_step_id
1298 ,p_name => 'P_ATTRIBUTE12_'||i)
1299
1300 --attribute13
1301 ,hr_transaction_api.get_varchar2_value
1302 (p_transaction_step_id => p_transaction_step_id
1303 ,p_name => 'P_ATTRIBUTE13_'||i)
1304
1305 --attribute14
1306 ,hr_transaction_api.get_varchar2_value
1307 (p_transaction_step_id => p_transaction_step_id
1308 ,p_name => 'P_ATTRIBUTE14_'||i)
1309
1310 --attribute15
1311 ,hr_transaction_api.get_varchar2_value
1312 (p_transaction_step_id => p_transaction_step_id
1313 ,p_name => 'P_ATTRIBUTE15_'||i)
1314
1315 --attribute16
1316 ,hr_transaction_api.get_varchar2_value
1317 (p_transaction_step_id => p_transaction_step_id
1318 ,p_name => 'P_ATTRIBUTE16_'||i)
1319
1320 --attribute17
1321 ,hr_transaction_api.get_varchar2_value
1322 (p_transaction_step_id => p_transaction_step_id
1323 ,p_name => 'P_ATTRIBUTE17_'||i)
1324
1325 --attribute18
1326 ,hr_transaction_api.get_varchar2_value
1327 (p_transaction_step_id => p_transaction_step_id
1328 ,p_name => 'P_ATTRIBUTE18_'||i)
1329
1330 --attribute19
1331 ,hr_transaction_api.get_varchar2_value
1332 (p_transaction_step_id => p_transaction_step_id
1333 ,p_name => 'P_ATTRIBUTE19_'||i)
1334
1335 --attribute20
1336 ,hr_transaction_api.get_varchar2_value
1337 (p_transaction_step_id => p_transaction_step_id
1338 ,p_name => 'P_ATTRIBUTE20_'||i)
1339
1340 --information_category
1341 ,hr_transaction_api.get_varchar2_value
1342 (p_transaction_step_id => p_transaction_step_id
1343 ,p_name => 'P_INFORMATION_CATEGORY_'||i)
1344
1345 --information1
1346 ,hr_transaction_api.get_varchar2_value
1347 (p_transaction_step_id => p_transaction_step_id
1348 ,p_name => 'P_INFORMATION1_'||i)
1349
1350 --information2
1351 ,hr_transaction_api.get_varchar2_value
1352 (p_transaction_step_id => p_transaction_step_id
1353 ,p_name => 'P_INFORMATION2_'||i)
1354
1355 --information3
1356 ,hr_transaction_api.get_varchar2_value
1357 (p_transaction_step_id => p_transaction_step_id
1358 ,p_name => 'P_INFORMATION3_'||i)
1359
1360 --information4
1361 ,hr_transaction_api.get_varchar2_value
1362 (p_transaction_step_id => p_transaction_step_id
1363 ,p_name => 'P_INFORMATION4_'||i)
1364
1365 --information5
1369
1366 ,hr_transaction_api.get_varchar2_value
1367 (p_transaction_step_id => p_transaction_step_id
1368 ,p_name => 'P_INFORMATION5_'||i)
1370 --information6
1371 ,hr_transaction_api.get_varchar2_value
1372 (p_transaction_step_id => p_transaction_step_id
1373 ,p_name => 'P_INFORMATION6_'||i)
1374
1375 --information7
1376 ,hr_transaction_api.get_varchar2_value
1377 (p_transaction_step_id => p_transaction_step_id
1378 ,p_name => 'P_INFORMATION7_'||i)
1379
1380 --information8
1381 ,hr_transaction_api.get_varchar2_value
1382 (p_transaction_step_id => p_transaction_step_id
1383 ,p_name => 'P_INFORMATION8_'||i)
1384
1385 --information9
1386 ,hr_transaction_api.get_varchar2_value
1387 (p_transaction_step_id => p_transaction_step_id
1388 ,p_name => 'P_INFORMATION9_'||i)
1389
1390 --information10
1391 ,hr_transaction_api.get_varchar2_value
1392 (p_transaction_step_id => p_transaction_step_id
1393 ,p_name => 'P_INFORMATION10_'||i)
1394
1395 --information11
1396 ,hr_transaction_api.get_varchar2_value
1397 (p_transaction_step_id => p_transaction_step_id
1398 ,p_name => 'P_INFORMATION11_'||i)
1399
1400 --information12
1401 ,hr_transaction_api.get_varchar2_value
1402 (p_transaction_step_id => p_transaction_step_id
1403 ,p_name => 'P_INFORMATION12_'||i)
1404
1405 --information13
1406 ,hr_transaction_api.get_varchar2_value
1407 (p_transaction_step_id => p_transaction_step_id
1408 ,p_name => 'P_INFORMATION13_'||i)
1409
1410 --information14
1411 ,hr_transaction_api.get_varchar2_value
1412 (p_transaction_step_id => p_transaction_step_id
1413 ,p_name => 'P_INFORMATION14_'||i)
1414
1415 --information15
1416 ,hr_transaction_api.get_varchar2_value
1417 (p_transaction_step_id => p_transaction_step_id
1418 ,p_name => 'P_INFORMATION15_'||i)
1419
1420 --information16
1421 ,hr_transaction_api.get_varchar2_value
1422 (p_transaction_step_id => p_transaction_step_id
1423 ,p_name => 'P_INFORMATION16_'||i)
1424
1425 --information17
1426 ,hr_transaction_api.get_varchar2_value
1427 (p_transaction_step_id => p_transaction_step_id
1428 ,p_name => 'P_INFORMATION17_'||i)
1429
1430 --information18
1431 ,hr_transaction_api.get_varchar2_value
1432 (p_transaction_step_id => p_transaction_step_id
1433 ,p_name => 'P_INFORMATION18_'||i)
1434
1435 --information19
1436 ,hr_transaction_api.get_varchar2_value
1437 (p_transaction_step_id => p_transaction_step_id
1438 ,p_name => 'P_INFORMATION19_'||i)
1439
1440 --information20
1441 ,hr_transaction_api.get_varchar2_value
1442 (p_transaction_step_id => p_transaction_step_id
1443 ,p_name => 'P_INFORMATION20_'||i)
1444
1445 --information21
1446 ,hr_transaction_api.get_varchar2_value
1447 (p_transaction_step_id => p_transaction_step_id
1448 ,p_name => 'P_INFORMATION21_'||i)
1449
1450 --information22
1451 ,hr_transaction_api.get_varchar2_value
1452 (p_transaction_step_id => p_transaction_step_id
1453 ,p_name => 'P_INFORMATION22_'||i)
1454
1455 --information23
1456 ,hr_transaction_api.get_varchar2_value
1457 (p_transaction_step_id => p_transaction_step_id
1458 ,p_name => 'P_INFORMATION23_'||i)
1459
1460 --information24
1461 ,hr_transaction_api.get_varchar2_value
1462 (p_transaction_step_id => p_transaction_step_id
1463 ,p_name => 'P_INFORMATION24_'||i)
1464
1465 --information25
1466 ,hr_transaction_api.get_varchar2_value
1467 (p_transaction_step_id => p_transaction_step_id
1468 ,p_name => 'P_INFORMATION25_'||i)
1469
1470 --information26
1471 ,hr_transaction_api.get_varchar2_value
1472 (p_transaction_step_id => p_transaction_step_id
1473 ,p_name => 'P_INFORMATION26_'||i)
1474
1475 --information27
1476 ,hr_transaction_api.get_varchar2_value
1477 (p_transaction_step_id => p_transaction_step_id
1478 ,p_name => 'P_INFORMATION27_'||i)
1479
1480 --information28
1481 ,hr_transaction_api.get_varchar2_value
1482 (p_transaction_step_id => p_transaction_step_id
1483 ,p_name => 'P_INFORMATION28_'||i)
1484
1485 --information29
1486 ,hr_transaction_api.get_varchar2_value
1487 (p_transaction_step_id => p_transaction_step_id
1488 ,p_name => 'P_INFORMATION29_'||i)
1489
1490 --information30
1491 ,hr_transaction_api.get_varchar2_value
1492 (p_transaction_step_id => p_transaction_step_id
1493 ,p_name => 'P_INFORMATION30_'||i));
1494
1495 END LOOP;
1496 p_eit_table := l_eit_table;
1497 --dump_eit_table(p_eit_table);
1498
1499 EXCEPTION
1500 -- Catch any exception thrown while storing transaction data
1501 WHEN OTHERS THEN
1502 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1503 p_error_message => p_error_message);
1504
1505 END get_eit_data_from_tt;
1506
1507 PROCEDURE del_transaction_data
1508 (p_item_type in varchar2
1509 ,p_item_key in varchar2
1510 ,p_activity_id in varchar2
1511 ,p_login_person_id in varchar2
1512 ,p_flow_mode in varchar2 default null
1513 ) IS
1514
1518 hr_transaction_ss.delete_transaction_steps(
1515 BEGIN
1516
1517
1519 p_item_type => p_item_type
1520 ,p_item_key => p_item_key
1521 ,p_actid => p_activity_id
1522 ,p_login_person_id => p_login_person_id
1523 );
1524
1525 END del_transaction_data;
1526
1527 -- ----------------------------------------------------------------------------
1528 -- |----------------------------< process_api >-------------------------------|
1529 -- ----------------------------------------------------------------------------
1530 PROCEDURE PROCESS_API
1531 (p_validate IN BOOLEAN DEFAULT FALSE
1532 ,p_transaction_step_id IN NUMBER DEFAULT NULL
1533 ,p_effective_date IN VARCHAR2 default null
1534 )IS
1535
1536 l_person_id NUMBER;
1537 l_assignment_id NUMBER;
1538 l_business_group_id NUMBER;
1539 l_login_person_id NUMBER;
1540 l_eit_type VARCHAR2(80);
1541 l_eit_type_id NUMBER;
1542 l_eit_number NUMBER;
1543 l_eit_table HR_EIT_STRUCTURE_TABLE;
1544 l_extra_info_id NUMBER;
1545 l_object_version_number NUMBER;
1546 l_error_message LONG;
1547 l_active_view VARCHAR2(200);
1548 l_active_row_id NUMBER;
1549 l_index NUMBER;
1550 l_effective_date DATE;
1551 l_key_id VARCHAR2(80);
1552 l_error_status VARCHAR2(100);
1553 l_ignore BOOLEAN;
1554 CURSOR c_get_other_tstep
1555 IS
1556 SELECT hats.item_type,hats.item_key
1557 FROM hr_api_transaction_steps hats
1558 WHERE hats.transaction_step_id =p_transaction_step_id;
1559 l_get_other_tstep c_get_other_tstep%ROWTYPE;
1560 CURSOR c_get_details IS
1561 SELECT pvr.vehicle_repository_id
1562 ,pva.vehicle_allocation_id
1563 FROM pqp_vehicle_repository_f pvr
1564 ,pqp_vehicle_allocations_f pva
1565 WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
1566 AND pva.assignment_id =l_assignment_id
1567 AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
1568 AND pvr.effective_end_date
1569 AND NVL(l_effective_date,sysdate) BETWEEN pva.effective_start_date
1570 AND pva.effective_end_date
1571 AND pvr.registration_number=l_key_id;
1572 l_get_details c_get_details%ROWTYPE;
1573 BEGIN
1574 --insert session because some flex uses the session effective date.
1575 IF p_effective_date is not null then
1576 hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1577 ELSE
1578 hr_util_misc_web.insert_session_row(SYSDATE);
1579 END IF;
1580
1581 get_eit_data_from_tt
1582 (p_transaction_step_id => p_transaction_step_id
1583 ,p_effective_date => l_effective_date
1584 ,p_person_id => l_person_id
1585 ,p_login_person_id => l_login_person_id
1586 ,p_assignment_id => l_assignment_id
1587 ,p_business_group_id => l_business_group_id
1588 ,p_eit_type => l_eit_type
1589 ,p_eit_type_id => l_eit_type_id
1590 ,p_eit_number => l_eit_number
1591 ,p_key_id => l_key_id
1592 ,p_eit_table => l_eit_table
1593 ,p_error_message => l_error_message
1594 ,p_active_view => l_active_view
1595 ,p_active_row_id => l_active_row_id
1596 );
1597
1598 IF l_eit_type_id =0 OR l_eit_type_id=-1 THEN
1599 OPEN c_get_other_tstep;
1600 FETCH c_get_other_tstep INTO l_get_other_tstep;
1601 CLOSE c_get_other_tstep;
1602 ---dbms_output.put_line('zero'||l_eit_type_id);
1603 OPEN c_get_details;
1604 FETCH c_get_details INTO l_get_details;
1605 IF l_eit_type='REPOSITORY' THEN
1606 -- l_eit_type_id :=l_get_details.vehicle_repository_id;
1607 l_eit_type_id :=wf_engine.GetItemAttrNumber(
1608 itemtype =>l_get_other_tstep.item_type,
1609 itemkey =>l_get_other_tstep.item_key,
1610 aname =>'PQP_VEH_REPOSITORY_ID_ATTR',
1611 ignore_notfound =>l_ignore);
1612
1613 ELSIF l_eit_type='ALLOCATION' THEN
1614 l_eit_type_id :=wf_engine.GetItemAttrNumber(
1615 itemtype =>l_get_other_tstep.item_type,
1616 itemkey =>l_get_other_tstep.item_key,
1617 aname =>'PQP_VEH_ALLOCATION_ID_ATTR',
1618 ignore_notfound =>l_ignore);
1619 END IF;
1620 CLOSE c_get_details;
1621 END IF;
1622 --debug
1623
1624
1625 -- FOR j IN 1..l_eit_table.count LOOP
1626 l_index := l_eit_table.first;
1627 -- LOOP
1628 -- EXIT WHEN
1629 -- (NOT l_eit_table.exists(l_index));
1630
1631
1632 l_extra_info_id :=l_eit_table(l_index).extra_info_id;
1633
1634 create_generic_eit
1635 (p_validate => false
1636 ,p_effective_date => l_effective_date
1640 ,p_business_group_id => l_business_group_id
1637 ,p_login_person_id => l_login_person_id
1638 ,p_person_id => l_person_id
1639 ,p_assignment_id => l_assignment_id
1641 ,p_action => l_eit_table(l_index).action
1642 ,p_eit_type => l_eit_type
1643 ,p_eit_type_id => l_eit_type_id
1644 ,p_information_type => l_eit_table(l_index).information_type
1645 ,p_attribute_category => l_eit_table(l_index).attribute_category
1646 ,p_attribute1 => l_eit_table(l_index).attribute1
1647 ,p_attribute2 => l_eit_table(l_index).attribute2
1648 ,p_attribute3 => l_eit_table(l_index).attribute3
1649 ,p_attribute4 => l_eit_table(l_index).attribute4
1650 ,p_attribute5 => l_eit_table(l_index).attribute5
1651 ,p_attribute6 => l_eit_table(l_index).attribute6
1652 ,p_attribute7 => l_eit_table(l_index).attribute7
1653 ,p_attribute8 => l_eit_table(l_index).attribute8
1654 ,p_attribute9 => l_eit_table(l_index).attribute9
1655 ,p_attribute10 => l_eit_table(l_index).attribute10
1656 ,p_attribute11 => l_eit_table(l_index).attribute11
1657 ,p_attribute12 => l_eit_table(l_index).attribute12
1658 ,p_attribute13 => l_eit_table(l_index).attribute13
1659 ,p_attribute14 => l_eit_table(l_index).attribute14
1660 ,p_attribute15 => l_eit_table(l_index).attribute15
1661 ,p_attribute16 => l_eit_table(l_index).attribute16
1662 ,p_attribute17 => l_eit_table(l_index).attribute17
1663 ,p_attribute18 => l_eit_table(l_index).attribute18
1664 ,p_attribute19 => l_eit_table(l_index).attribute19
1665 ,p_attribute20 => l_eit_table(l_index).attribute20
1666 ,p_information_category => l_eit_table(l_index).information_category
1667 ,p_information1 => l_eit_table(l_index).information1
1668 ,p_information2 => l_eit_table(l_index).information2
1669 ,p_information3 => l_eit_table(l_index).information3
1670 ,p_information4 => l_eit_table(l_index).information4
1671 ,p_information5 => l_eit_table(l_index).information5
1672 ,p_information6 => l_eit_table(l_index).information6
1673 ,p_information7 => l_eit_table(l_index).information7
1674 ,p_information8 => l_eit_table(l_index).information8
1675 ,p_information9 => l_eit_table(l_index).information9
1676 ,p_information10 => l_eit_table(l_index).information10
1677 ,p_information11 => l_eit_table(l_index).information11
1678 ,p_information12 => l_eit_table(l_index).information12
1679 ,p_information13 => l_eit_table(l_index).information13
1680 ,p_information14 => l_eit_table(l_index).information14
1681 ,p_information15 => l_eit_table(l_index).information15
1682 ,p_information16 => l_eit_table(l_index).information16
1683 ,p_information17 => l_eit_table(l_index).information17
1684 ,p_information18 => l_eit_table(l_index).information18
1685 ,p_information19 => l_eit_table(l_index).information19
1686 ,p_information20 => l_eit_table(l_index).information20
1687 ,p_information21 => l_eit_table(l_index).information21
1688 ,p_information22 => l_eit_table(l_index).information22
1689 ,p_information23 => l_eit_table(l_index).information23
1690 ,p_information24 => l_eit_table(l_index).information24
1691 ,p_information25 => l_eit_table(l_index).information25
1692 ,p_information26 => l_eit_table(l_index).information26
1693 ,p_information27 => l_eit_table(l_index).information27
1694 ,p_information28 => l_eit_table(l_index).information28
1695 ,p_information29 => l_eit_table(l_index).information29
1696 ,p_information30 => l_eit_table(l_index).information30
1697 ,p_object_version_number => l_object_version_number
1698 -- EndRegistration
1699 ,p_extra_info_id =>l_extra_info_id
1700 ,p_error_message => l_error_message
1701 ,p_error_status =>l_error_status
1702 );
1703
1704 l_index := l_eit_table.next(l_index);
1705
1706 -- END LOOP;
1707 -- END LOOP;
1708
1709 --remove session
1710 hr_util_misc_web.remove_session_row();
1711
1712 IF l_error_message is not null then
1713 hr_utility.raise_error;
1714 END IF;
1715
1716 EXCEPTION
1717 WHEN OTHERS THEN
1718 RAISE;
1719
1720 END process_api;
1721
1722
1723
1724
1725 END;
1726
1727