[Home] [Help]
PACKAGE BODY: APPS.HR_PROCESS_EIT_SS
Source
1 Package Body HR_PROCESS_EIT_SS as
2 /* $Header: hreitwrs.pkb 120.0 2005/05/31 00:05:15 appldev noship $ */
3 --
4 -- Package Variables
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) := 'HR_PROCESS_EIT_SS';
13 g_data_error exception;
14 l_message_number VARCHAR2(10);
15 p_trans_rec_count integer;
16
17
18 -- ----------------------------------------------------------------------------
19 -- |-----------------------< save_transaction_data >--------------------------|
20 -- ----------------------------------------------------------------------------
21
22 PROCEDURE save_transaction_data
23 (p_person_id in number
24 ,p_login_person_id in number
25 ,p_eit_type in varchar2
26 ,p_eit_type_id in number
27 ,p_eit_number in number
28 ,p_eit_table in HR_EIT_STRUCTURE_TABLE
29 ,p_item_type in varchar2
30 ,p_item_key in varchar2
31 ,p_activity_id in number
32 ,p_transaction_step_id out nocopy number
33 ,p_error_message out nocopy varchar2
34 ,p_active_view in varchar2
35 ,p_active_row_id in number
36 ,p_flow_mode in varchar2 default null
37 ) is
38 l_transaction_id number default null;
39 l_trans_obj_vers_num number default null;
40 l_trans_step_rows number default null;
41 l_result varchar2(100) default null;
42 l_count number default 0;
43 l_transaction_table hr_transaction_ss.transaction_table;
44 l_review_item_name varchar2(50);
45 l_eit_number number := 0;
46 l_proc varchar2(72) := g_package||'save_transaction_data';
47
48 BEGIN
49 hr_utility.set_location('Entering:'||l_proc, 5);
50 if p_flow_mode is not null and
51 p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
52 then
53 hr_utility.trace('Calling RollBack:'||l_proc);
54 rollback;
55 end if;
56 --
57 -- First, check if transaction id exists or not
58 l_transaction_id := hr_transaction_ss.get_transaction_id
59 (p_item_type => p_item_type
60 ,p_item_key => p_item_key);
61
62 hr_utility.trace( 'hr_process_eit_ss.save_transaction_data' ||
63 ' l_transaction_id: '|| l_transaction_id);
64
65 --
66 IF l_transaction_id is null THEN
67
68 -- Start a Transaction
69 hr_utility.trace('IF l_transaction_id is null THEN:'||l_proc);
70 hr_transaction_ss.start_transaction
71 (itemtype => p_item_type
72 ,itemkey => p_item_key
73 ,actid => p_activity_id
74 ,funmode => 'RUN'
75 ,p_login_person_id => p_login_person_id
76 ,result => l_result);
77
78 l_transaction_id := hr_transaction_ss.get_transaction_id
79 (p_item_type => p_item_type
80 ,p_item_key => p_item_key);
81 END IF;
82 --
83 -- Create a transaction step
84 --
85 hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
86 ' l_transaction_id: '||l_transaction_id);
87
88
89 hr_transaction_api.get_transaction_step_info
90 (p_Item_Type => p_item_type
91 ,p_Item_Key => p_item_key
92 ,p_activity_id => p_activity_id
93 ,p_transaction_step_id => l_transaction_step_id
94 ,p_object_version_number => l_trs_object_version_number);
95
96 if(hr_utility.debug_enabled) then
97
98 hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
99 ' l_transaction_id: '||l_transaction_id||
100 ' p_Item_Type: '||p_Item_Type||
101 ' p_Item_Key: '||p_Item_Key||
102 ' p_activity_id: '||p_activity_id||
103 ' l_transaction_step_id: '||l_transaction_step_id||
104 ' l_trs_object_version_number: '||l_trs_object_version_number
105 );
106 end if;
107
108 IF l_transaction_step_id < 1 THEN
109 hr_utility.trace('l_transaction_step_id < 1:'||l_proc);
110
111 --There is no transaction step for this transaction.
112 --Create a step within this new transaction
113 hr_transaction_api.create_transaction_step
114 (p_validate => false
115 ,p_creator_person_id => p_login_person_id
116 ,p_transaction_id => l_transaction_id
117 ,p_api_name => g_package || '.PROCESS_API'
118 ,p_item_type => p_item_type
119 ,p_item_key => p_item_key
120 ,p_activity_id => p_activity_id
121 ,p_transaction_step_id => l_transaction_step_id
122 ,p_object_version_number => l_trs_object_version_number);
123 END IF;
124
125 hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
126 ' l_transaction_step_id: '||l_transaction_step_id
127 );
128
129
130 l_count := 1;
131 l_transaction_table(l_count).param_name := 'P_PERSON_ID';
132 l_transaction_table(l_count).param_value := p_person_id;
133 l_transaction_table(l_count).param_data_type := 'NUMBER';
134
135 l_count := l_count + 1;
136 l_transaction_table(l_count).param_name := 'P_LOGIN_PERSON_ID';
137 l_transaction_table(l_count).param_value := p_login_person_id;
138 l_transaction_table(l_count).param_data_type := 'NUMBER';
139
140 l_count := l_count + 1;
141 l_transaction_table(l_count).param_name := 'P_EIT_TYPE';
142 l_transaction_table(l_count).param_value := p_eit_type;
143 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
144
145 l_count := l_count + 1;
146 l_transaction_table(l_count).param_name := 'P_EIT_TYPE_ID';
147 l_transaction_table(l_count).param_value := p_eit_type_id;
148 l_transaction_table(l_count).param_data_type := 'NUMBER';
149
150 l_count := l_count + 1;
151 l_transaction_table(l_count).param_name := 'P_EIT_NUMBER';
152 l_transaction_table(l_count).param_value := p_eit_number;
153 l_transaction_table(l_count).param_data_type := 'NUMBER';
154
155 l_review_item_name :=
156 wf_engine.GetActivityAttrText(itemtype => p_item_type,
157 itemkey => p_item_key,
158 actid => p_activity_id,
159 aname => gv_wf_review_region_item);
160
161
162 l_count := l_count + 1;
163 l_transaction_table(l_count).param_name := 'P_REVIEW_PROC_CALL';
164 l_transaction_table(l_count).param_value := l_review_item_name;
165 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
166
167 l_count := l_count + 1;
168 l_transaction_table(l_count).param_name := 'P_REVIEW_ACTID';
169 l_transaction_table(l_count).param_value := p_activity_id;
170 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
171
172 -- for the update page when we rebuild the page after a
173 -- save for later
174 l_count := l_count + 1;
175 l_transaction_table(l_count).param_name := 'P_ACTIVE_VIEW';
176 l_transaction_table(l_count).param_value := p_active_view;
177 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
178
179 l_count := l_count + 1;
180 l_transaction_table(l_count).param_name := 'P_ACTIVE_ROW_ID';
181 l_transaction_table(l_count).param_value := p_active_row_id;
182 l_transaction_table(l_count).param_data_type := 'NUMBER';
183
184 if(hr_utility.debug_enabled) then
185
186 hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
187 ' p_person_id: '||p_person_id||
188 ' p_login_person_id: '||p_login_person_id||
189 ' p_eit_type: '||p_eit_type||
190 ' p_eit_number: '||p_eit_number);
191 end if;
192
193 l_eit_number := p_eit_number;
194
195 hr_utility.trace('Entering For 1..l_eit_number:'||l_proc);
196 FOR i in 1..l_eit_number LOOP
197
198
199
200 l_count := l_count + 1;
201 l_transaction_table(l_count).param_name := 'P_ACTION_'||i;
202 l_transaction_table(l_count).param_value := p_eit_table(i).action;
203 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
204
205 l_count := l_count + 1;
206 l_transaction_table(l_count).param_name := 'P_EXTRA_INFO_ID_'||i;
207 l_transaction_table(l_count).param_value := p_eit_table(i).extra_info_id;
208 l_transaction_table(l_count).param_data_type := 'NUMBER';
209
210 l_count := l_count + 1;
211 l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER_'||i;
212 l_transaction_table(l_count).param_value := p_eit_table(i).object_version_number;
213 l_transaction_table(l_count).param_data_type := 'NUMBER';
214
215 l_count := l_count + 1;
216 l_transaction_table(l_count).param_name := 'P_INFORMATION_TYPE_'||i;
217 l_transaction_table(l_count).param_value := p_eit_table(i).information_type;
218 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
219
220 -- Now add all the Descriptive flex fields into transactions tables
221
222 l_count := l_count + 1; -- CONTEXT
223 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE_CATEGORY_'||i;
224 l_transaction_table(l_count).param_value := p_eit_table(i).attribute_category;
225 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
226
227 l_count := l_count + 1;
228 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE1_'||i;
229 l_transaction_table(l_count).param_value := p_eit_table(i).attribute1;
230 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
231
232 l_count := l_count + 1;
233 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE2_'||i;
234 l_transaction_table(l_count).param_value := p_eit_table(i).attribute2;
235 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
236
237 l_count := l_count + 1;
238 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE3_'||i;
239 l_transaction_table(l_count).param_value := p_eit_table(i).attribute3;
240 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
241
242 l_count := l_count + 1;
243 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE4_'||i;
244 l_transaction_table(l_count).param_value := p_eit_table(i).attribute4;
245 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
246
247 l_count := l_count + 1;
248 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE5_'||i;
249 l_transaction_table(l_count).param_value := p_eit_table(i).attribute5;
250 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
251
252 l_count := l_count + 1;
253 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE6_'||i;
254 l_transaction_table(l_count).param_value := p_eit_table(i).attribute6;
255 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
256
257 l_count := l_count + 1;
258 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE7_'||i;
259 l_transaction_table(l_count).param_value := p_eit_table(i).attribute7;
260 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
261
262 l_count := l_count + 1;
263 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE8_'||i;
264 l_transaction_table(l_count).param_value := p_eit_table(i).attribute8;
265 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
266
267 l_count := l_count + 1;
268 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE9_'||i;
269 l_transaction_table(l_count).param_value := p_eit_table(i).attribute9;
270 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
271
272 l_count := l_count + 1;
273 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE10_'||i;
274 l_transaction_table(l_count).param_value := p_eit_table(i).attribute10;
275 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
276
277 l_count := l_count + 1;
278 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE11_'||i;
279 l_transaction_table(l_count).param_value := p_eit_table(i).attribute11;
280 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
281
282 l_count := l_count + 1;
283 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE12_'||i;
284 l_transaction_table(l_count).param_value := p_eit_table(i).attribute12;
285 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
286
287 l_count := l_count + 1;
288 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE13_'||i;
289 l_transaction_table(l_count).param_value := p_eit_table(i).attribute13;
290 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
291
292 l_count := l_count + 1;
293 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE14_'||i;
294 l_transaction_table(l_count).param_value := p_eit_table(i).attribute14;
295 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
296
297 l_count := l_count + 1;
298 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE15_'||i;
299 l_transaction_table(l_count).param_value := p_eit_table(i).attribute15;
300 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
301
302 l_count := l_count + 1;
303 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE16_'||i;
304 l_transaction_table(l_count).param_value := p_eit_table(i).attribute16;
305 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
306
307 l_count := l_count + 1;
308 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE17_'||i;
309 l_transaction_table(l_count).param_value := p_eit_table(i).attribute17;
310 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
311
312 l_count := l_count + 1;
313 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE18_'||i;
314 l_transaction_table(l_count).param_value := p_eit_table(i).attribute18;
315 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
316
317 l_count := l_count + 1;
318 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE19_'||i;
319 l_transaction_table(l_count).param_value := p_eit_table(i).attribute19;
320 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
321
322 l_count := l_count + 1;
323 l_transaction_table(l_count).param_name := 'P_ATTRIBUTE20_'||i;
324 l_transaction_table(l_count).param_value := p_eit_table(i).attribute20;
325 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
326
327 l_count := l_count + 1;
328 l_transaction_table(l_count).param_name := 'P_INFORMATION_CATEGORY_'||i;
329 l_transaction_table(l_count).param_value := p_eit_table(i).information_category;
330 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
331
332 l_count := l_count + 1;
333 l_transaction_table(l_count).param_name := 'P_INFORMATION1_'||i;
334 l_transaction_table(l_count).param_value := p_eit_table(i).information1;
335 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
336
337 l_count := l_count + 1;
338 l_transaction_table(l_count).param_name := 'P_INFORMATION2_'||i;
339 l_transaction_table(l_count).param_value := p_eit_table(i).information2;
340 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
341
342 l_count := l_count + 1;
343 l_transaction_table(l_count).param_name := 'P_INFORMATION3_'||i;
344 l_transaction_table(l_count).param_value := p_eit_table(i).information3;
345 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
346
347 l_count := l_count + 1;
348 l_transaction_table(l_count).param_name := 'P_INFORMATION4_'||i;
349 l_transaction_table(l_count).param_value := p_eit_table(i).information4;
350 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
351
352 l_count := l_count + 1;
353 l_transaction_table(l_count).param_name := 'P_INFORMATION5_'||i;
354 l_transaction_table(l_count).param_value := p_eit_table(i).information5;
355 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
356
357 l_count := l_count + 1;
358 l_transaction_table(l_count).param_name := 'P_INFORMATION6_'||i;
359 l_transaction_table(l_count).param_value := p_eit_table(i).information6;
360 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
361
362 l_count := l_count + 1;
363 l_transaction_table(l_count).param_name := 'P_INFORMATION7_'||i;
364 l_transaction_table(l_count).param_value := p_eit_table(i).information7;
365 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
366
367 l_count := l_count + 1;
368 l_transaction_table(l_count).param_name := 'P_INFORMATION8_'||i;
369 l_transaction_table(l_count).param_value := p_eit_table(i).information8;
370 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
371
372 l_count := l_count + 1;
373 l_transaction_table(l_count).param_name := 'P_INFORMATION9_'||i;
374 l_transaction_table(l_count).param_value := p_eit_table(i).information9;
375 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
376
377 l_count := l_count + 1;
378 l_transaction_table(l_count).param_name := 'P_INFORMATION10_'||i;
379 l_transaction_table(l_count).param_value := p_eit_table(i).information10;
380 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
381
382 l_count := l_count + 1;
383 l_transaction_table(l_count).param_name := 'P_INFORMATION11_'||i;
384 l_transaction_table(l_count).param_value := p_eit_table(i).information11;
385 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
386
387 l_count := l_count + 1;
388 l_transaction_table(l_count).param_name := 'P_INFORMATION12_'||i;
389 l_transaction_table(l_count).param_value := p_eit_table(i).information12;
390 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
391
392 l_count := l_count + 1;
393 l_transaction_table(l_count).param_name := 'P_INFORMATION13_'||i;
394 l_transaction_table(l_count).param_value := p_eit_table(i).information13;
395 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
396
397 l_count := l_count + 1;
398 l_transaction_table(l_count).param_name := 'P_INFORMATION14_'||i;
399 l_transaction_table(l_count).param_value := p_eit_table(i).information14;
400 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
401
402 l_count := l_count + 1;
403 l_transaction_table(l_count).param_name := 'P_INFORMATION15_'||i;
404 l_transaction_table(l_count).param_value := p_eit_table(i).information15;
405 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
406
407 l_count := l_count + 1;
408 l_transaction_table(l_count).param_name := 'P_INFORMATION16_'||i;
409 l_transaction_table(l_count).param_value := p_eit_table(i).information16;
410 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
411
412 l_count := l_count + 1;
413 l_transaction_table(l_count).param_name := 'P_INFORMATION17_'||i;
414 l_transaction_table(l_count).param_value := p_eit_table(i).information17;
415 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
416
417 l_count := l_count + 1;
418 l_transaction_table(l_count).param_name := 'P_INFORMATION18_'||i;
419 l_transaction_table(l_count).param_value := p_eit_table(i).information18;
420 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
421
422 l_count := l_count + 1;
423 l_transaction_table(l_count).param_name := 'P_INFORMATION19_'||i;
424 l_transaction_table(l_count).param_value := p_eit_table(i).information19;
425 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
426
427 l_count := l_count + 1;
428 l_transaction_table(l_count).param_name := 'P_INFORMATION20_'||i;
429 l_transaction_table(l_count).param_value := p_eit_table(i).information20;
430 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
431
432 l_count := l_count + 1;
433 l_transaction_table(l_count).param_name := 'P_INFORMATION21_'||i;
434 l_transaction_table(l_count).param_value := p_eit_table(i).information21;
435 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
436
437 l_count := l_count + 1;
438 l_transaction_table(l_count).param_name := 'P_INFORMATION22_'||i;
439 l_transaction_table(l_count).param_value := p_eit_table(i).information22;
440 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
441
442 l_count := l_count + 1;
443 l_transaction_table(l_count).param_name := 'P_INFORMATION23_'||i;
444 l_transaction_table(l_count).param_value := p_eit_table(i).information23;
445 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
446
447 l_count := l_count + 1;
448 l_transaction_table(l_count).param_name := 'P_INFORMATION24_'||i;
449 l_transaction_table(l_count).param_value := p_eit_table(i).information24;
450 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
451
452 l_count := l_count + 1;
453 l_transaction_table(l_count).param_name := 'P_INFORMATION25_'||i;
454 l_transaction_table(l_count).param_value := p_eit_table(i).information25;
455 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
456
457 l_count := l_count + 1;
458 l_transaction_table(l_count).param_name := 'P_INFORMATION26_'||i;
459 l_transaction_table(l_count).param_value := p_eit_table(i).information26;
460 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
461
462 l_count := l_count + 1;
463 l_transaction_table(l_count).param_name := 'P_INFORMATION27_'||i;
464 l_transaction_table(l_count).param_value := p_eit_table(i).information27;
465 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
466
467 l_count := l_count + 1;
468 l_transaction_table(l_count).param_name := 'P_INFORMATION28_'||i;
469 l_transaction_table(l_count).param_value := p_eit_table(i).information28;
470 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
471
472 l_count := l_count + 1;
473 l_transaction_table(l_count).param_name := 'P_INFORMATION29_'||i;
474 l_transaction_table(l_count).param_value := p_eit_table(i).information29;
475 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
476
477 l_count := l_count + 1;
478 l_transaction_table(l_count).param_name := 'P_INFORMATION30_'||i;
479 l_transaction_table(l_count).param_value := p_eit_table(i).information30;
480 l_transaction_table(l_count).param_data_type := 'VARCHAR2';
481
482 -- EndRegistration
483 --
484 -- This is a marker for the contact person to be used to identify the Address
485 -- to be retrieved for the contact person in context in review page.
486 END LOOP;
487 hr_utility.trace('Exiting For Loop:'||l_proc);
488
489 dump_eit_table(p_eit_table);
490
491 hr_transaction_ss.save_transaction_step
492 (p_item_type => p_item_type
493 ,p_item_key => p_item_key
494 ,p_actid => p_activity_id
495 -- ,p_login_person_id => nvl(p_login_person_id, p_person_id) -- PB Modification
496 ,p_login_person_id => p_login_person_id -- PB Modification
497 ,p_transaction_step_id => l_transaction_step_id
498 ,p_api_name => g_package || '.PROCESS_API'
499 ,p_transaction_data => l_transaction_table);
500
501 hr_utility.set_location('Exiting:'||l_proc, 35);
502
503
504
505
506 EXCEPTION
507 -- Catch any exception thrown while storing transaction data
508 WHEN OTHERS THEN
509 hr_utility.set_location('Exception:Others'||l_proc,555);
510 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
511 p_error_message => p_error_message);
512
513 hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||
514 ' p_error_message: '||p_error_message);
515
516
517
518 END save_transaction_data;
519
520 -- ---------------------------------------------------------------------------
521 -- ---------------------- < get_eit_data_from_tt> -------------------------
522 -- ---------------------------------------------------------------------------
523 -- Purpose: This procedure will get transaction data which are pending for
524 -- approval in workflow for a given person id, workflow process name
525 -- and workflow activity name. This is the overloaded version.
526 -- ---------------------------------------------------------------------------
527 PROCEDURE get_eit_data_from_tt
528 (p_item_type in varchar2
529 ,p_item_key in varchar2
530 ,p_activity_id in number
531 ,p_person_id out nocopy number
532 ,p_login_person_id out nocopy number
533 ,p_eit_type out nocopy varchar2
534 ,p_eit_type_id out nocopy number
535 ,p_eit_number out nocopy number
536 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
537 ,p_error_message out nocopy long
538 ,p_active_view out nocopy varchar2
539 ,p_active_row_id out nocopy number
540 )
541 IS
542
543 l_transaction_id number;
544 l_trans_step_id number;
545 l_trans_obj_vers_num number;
546 l_count integer default 0;
547 l_trans_rec_count number;
548 l_proc varchar2(72) := g_package||'get_eit_data_from_tt';
549
550
551 begin
552
553 -- ------------------------------------------------------------------
554 -- Check if there are any transaction rec already saved for the current
555 -- transaction. This is used for re-display the Update page when a user
556 -- clicks the Back button on the Review page to go back to the Update page
557 -- to make further changes or to correct errors.
558 -----------------------------------------------------------------------------
559 hr_utility.set_location('Entering:'||l_proc, 5);
560 hr_utility.trace(
561 'hr_process_eit_ss.get_eit_data_from_tt' ||
562 ' p_item_type: '||p_item_type||
563 ' p_item_key: '||p_item_key||
564 ' p_activity_id: '||p_activity_id);
565
566 hr_transaction_api.get_transaction_step_info
567 (p_item_type => p_item_type
568 ,p_item_key => p_item_key
569 ,p_activity_id => p_activity_id
570 ,p_transaction_step_id => l_trans_step_id
571 ,p_object_version_number => l_trans_obj_vers_num);
572
573 hr_utility.trace(
574 'hr_process_eit_ss.get_eit_data_from_tt' ||
575 ' l_trans_step_id: '||l_trans_step_id||
576 ' l_trans_obj_vers_num: '||l_trans_obj_vers_num);
577
578
579 IF l_trans_step_id IS NOT NULL OR
580 l_trans_step_id > 0
581 THEN
582 hr_utility.trace('l_trans_step_id IS NOT NULL stepid>0:'||l_proc);
583 l_trans_rec_count := 1;
584 ELSE
585 hr_utility.trace('l_trans_step_id IS NULL & l_trans_step_id <= 0'||l_proc);
586 l_trans_rec_count := 0;
587 hr_utility.trace('Exiting:From Else part'||l_proc);
588 return;
589 END IF;
590
591 --
592 -- -------------------------------------------------------------------
593 -- There are some changes made earlier in the transaction.
594 -- Retrieve the data and return to caller.
595 -- -------------------------------------------------------------------
596
597 -- Now get the transaction data for the given step
598 get_eit_data_from_tt
599 (p_transaction_step_id => l_trans_step_id
600 ,p_person_id => p_person_id
601 ,p_login_person_id => p_login_person_id
602 ,p_eit_type => p_eit_type
603 ,p_eit_type_id => p_eit_type_id
604 ,p_eit_number => p_eit_number
605 ,p_eit_table => p_eit_table
606 ,p_error_message => p_error_message
607 ,p_active_view => p_active_view
608 ,p_active_row_id => p_active_row_id
609 );
610
611 hr_utility.trace(
612 'hr_process_eit_ss.get_eit_data_from_tt' ||
613 ' p_error_message: '||p_error_message);
614
615 p_trans_rec_count := l_trans_rec_count;
616 hr_utility.set_location('Exiting:Funtion'||l_proc, 25);
617
618 EXCEPTION
619 -- Catch any exception thrown while storing transaction data
620 WHEN OTHERS THEN
621 hr_utility.set_location('Exception:Others'||l_proc,555);
622 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
623 p_error_message => p_error_message);
624 hr_utility.trace(
625 'hr_process_eit_ss.get_eit_data_from_tt' ||
626 ' p_error_message: '||p_error_message);
627
628
629 END get_eit_data_from_tt;
630
631 -- ---------------------------------------------------------------------------
632 -- ---------------------- < get_eit_data_from_tt> -------------------------
633 -- ---------------------------------------------------------------------------
634 -- Purpose: This procedure will get transaction data which are pending for
635 -- approval in workflow for a transaction step id.
636 -- ---------------------------------------------------------------------------
637 procedure get_eit_data_from_tt
638 (p_transaction_step_id in number
639 ,p_person_id out nocopy number
640 ,p_login_person_id out nocopy number
641 ,p_eit_type out nocopy varchar2
642 ,p_eit_type_id out nocopy number
643 ,p_eit_number out nocopy number
644 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
645 ,p_error_message out nocopy long
646 ,p_active_view out nocopy varchar2
647 ,p_active_row_id out nocopy number
648 )IS
649
650 l_number_eit number := 0;
651 l_eit_table HR_EIT_STRUCTURE_TABLE;
652 l_proc varchar2(72) := g_package||'get_eit_data_from_tt';
653
654 begin
655
656 hr_utility.set_location('Entering:'||l_proc, 5);
657 hr_utility.trace(
658 'hr_process_eit_ss.get_eit_data_from_tt' ||
659 ' p_transaction_step_id: '||p_transaction_step_id);
660
661
662 p_person_id := hr_transaction_api.get_number_value
663 (p_transaction_step_id => p_transaction_step_id
664 ,p_name => 'P_PERSON_ID');
665
666 p_login_person_id := hr_transaction_api.get_number_value
667 (p_transaction_step_id => p_transaction_step_id
668 ,p_name => 'P_LOGIN_PERSON_ID');
669
670 p_eit_type := hr_transaction_api.get_varchar2_value
671 (p_transaction_step_id => p_transaction_step_id
672 ,p_name => 'P_EIT_TYPE');
673
674 p_eit_type_id := hr_transaction_api.get_number_value
675 (p_transaction_step_id => p_transaction_step_id
676 ,p_name => 'P_EIT_TYPE_ID');
677
678 -- start registration
679 -- If its a new user registration flow then the assignmentId which is coming
680 -- from transaction table will not be valid because the person has just been
681 -- created by the process_api of the hr_process_person_ss.process_api.
682 -- We can get that person Id and assignment id by making a call
683 -- to the global parameters but we need to branch out the code.
684 -- We also need the latest Object version Number not the one on transaction tbl
685
686 -- adding the session id check to avoid connection pooling problems.
687 if (( hr_process_person_ss.g_assignment_id is not null
688 or hr_process_person_ss.g_person_id is not null) and
689 (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
690 then
691 hr_utility.trace('AsgId<>NULL or PID<>NULL AND SESSIONID=ICX_SEC.G_SESSION_ID:'||l_proc);
692 if p_eit_type = 'PERSON' then
693 p_eit_type_id := hr_process_person_ss.g_person_id;
694 else
695 p_eit_type_id := hr_process_person_ss.g_assignment_id;
696 end if;
697 p_person_id := hr_process_person_ss.g_person_id;
698 end if;
699
700 -- end registration
701 --
702
703 p_eit_number := hr_transaction_api.get_number_value
704 (p_transaction_step_id => p_transaction_step_id
705 ,p_name => 'P_EIT_NUMBER');
706
707 p_active_view := hr_transaction_api.get_varchar2_value
708 (p_transaction_step_id => p_transaction_step_id
709 ,p_name => 'P_ACTIVE_VIEW');
710
711 p_active_row_id := hr_transaction_api.get_number_value
712 (p_transaction_step_id => p_transaction_step_id
713 ,p_name => 'P_ACTIVE_ROW_ID');
714
715 if(hr_utility.debug_enabled) then
716
717 hr_utility.trace(
718 'hr_process_eit_ss.get_eit_data_from_tt' ||
719 ' p_person_id: '||p_person_id||
720 ' p_login_person_id: '||p_login_person_id||
721 ' p_eit_type: '||p_eit_type||
722 ' p_eit_type_id: '||p_eit_type_id||
723 ' p_eit_number: '||p_eit_number||
724 ' p_active_view: '||p_active_view||
725 ' p_active_row_id: '||p_active_row_id);
726 end if;
727
728 l_number_eit := p_eit_number;
729
730 l_eit_table := HR_EIT_STRUCTURE_TABLE();
731
732
733 hr_utility.trace('For :1 ..l_number_eit'||l_proc);
734 FOR i in 1 ..l_number_eit LOOP
735 --
736 l_eit_table.extend;
737
738 -- hr_utility.trace(
739 -- 'hr_process_eit_ss.get_eit_data_from_tt' ||
740 -- ' i : '||i);
741 --
742 l_eit_table(i) := HR_EIT_STRUCTURE_TYPE
743 (
744 -- action
745 hr_transaction_api.get_varchar2_value
746 (p_transaction_step_id => p_transaction_step_id
747 ,p_name => 'P_ACTION_'||i)
748
749 -- extra info id
750 ,hr_transaction_api.get_number_value
751 (p_transaction_step_id => p_transaction_step_id
752 ,p_name => 'P_EXTRA_INFO_ID_'||i)
753
754 --object_version_number
755 ,hr_transaction_api.get_number_value
756 (p_transaction_step_id => p_transaction_step_id
757 ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
758
759 --information_type
760 ,hr_transaction_api.get_varchar2_value
761 (p_transaction_step_id => p_transaction_step_id
762 ,p_name => 'P_INFORMATION_TYPE_'||i)
763
764 --attribute_category
765 ,hr_transaction_api.get_varchar2_value
766 (p_transaction_step_id => p_transaction_step_id
767 ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
768
769 --attribute1
770 ,hr_transaction_api.get_varchar2_value
771 (p_transaction_step_id => p_transaction_step_id
772 ,p_name => 'P_ATTRIBUTE1_'||i)
773
774 --attribute2
775 ,hr_transaction_api.get_varchar2_value
776 (p_transaction_step_id => p_transaction_step_id
777 ,p_name => 'P_ATTRIBUTE2_'||i)
778
779 --attribute3
780 ,hr_transaction_api.get_varchar2_value
781 (p_transaction_step_id => p_transaction_step_id
782 ,p_name => 'P_ATTRIBUTE3_'||i)
783
784 --attribute4
785 ,hr_transaction_api.get_varchar2_value
786 (p_transaction_step_id => p_transaction_step_id
787 ,p_name => 'P_ATTRIBUTE4_'||i)
788
789 --attribute5
790 ,hr_transaction_api.get_varchar2_value
791 (p_transaction_step_id => p_transaction_step_id
792 ,p_name => 'P_ATTRIBUTE5_'||i)
793
794 --attribute6
795 ,hr_transaction_api.get_varchar2_value
796 (p_transaction_step_id => p_transaction_step_id
797 ,p_name => 'P_ATTRIBUTE6_'||i)
798
799 --attribute7
800 ,hr_transaction_api.get_varchar2_value
801 (p_transaction_step_id => p_transaction_step_id
802 ,p_name => 'P_ATTRIBUTE7_'||i)
803
804 --attribute8
805 ,hr_transaction_api.get_varchar2_value
806 (p_transaction_step_id => p_transaction_step_id
807 ,p_name => 'P_ATTRIBUTE8_'||i)
808
809 --attribute9
810 ,hr_transaction_api.get_varchar2_value
811 (p_transaction_step_id => p_transaction_step_id
812 ,p_name => 'P_ATTRIBUTE9_'||i)
813
814 --attribute10
815 ,hr_transaction_api.get_varchar2_value
816 (p_transaction_step_id => p_transaction_step_id
817 ,p_name => 'P_ATTRIBUTE10_'||i)
818
819 --attribute11
820 ,hr_transaction_api.get_varchar2_value
821 (p_transaction_step_id => p_transaction_step_id
822 ,p_name => 'P_ATTRIBUTE11_'||i)
823
824 --attribute12
825 ,hr_transaction_api.get_varchar2_value
826 (p_transaction_step_id => p_transaction_step_id
827 ,p_name => 'P_ATTRIBUTE12_'||i)
828
829 --attribute13
830 ,hr_transaction_api.get_varchar2_value
831 (p_transaction_step_id => p_transaction_step_id
832 ,p_name => 'P_ATTRIBUTE13_'||i)
833
834 --attribute14
835 ,hr_transaction_api.get_varchar2_value
836 (p_transaction_step_id => p_transaction_step_id
837 ,p_name => 'P_ATTRIBUTE14_'||i)
838
839 --attribute15
840 ,hr_transaction_api.get_varchar2_value
841 (p_transaction_step_id => p_transaction_step_id
842 ,p_name => 'P_ATTRIBUTE15_'||i)
843
844 --attribute16
845 ,hr_transaction_api.get_varchar2_value
846 (p_transaction_step_id => p_transaction_step_id
847 ,p_name => 'P_ATTRIBUTE16_'||i)
848
849 --attribute17
850 ,hr_transaction_api.get_varchar2_value
851 (p_transaction_step_id => p_transaction_step_id
852 ,p_name => 'P_ATTRIBUTE17_'||i)
853
854 --attribute18
855 ,hr_transaction_api.get_varchar2_value
856 (p_transaction_step_id => p_transaction_step_id
857 ,p_name => 'P_ATTRIBUTE18_'||i)
858
859 --attribute19
860 ,hr_transaction_api.get_varchar2_value
861 (p_transaction_step_id => p_transaction_step_id
862 ,p_name => 'P_ATTRIBUTE19_'||i)
863
864 --attribute20
865 ,hr_transaction_api.get_varchar2_value
866 (p_transaction_step_id => p_transaction_step_id
867 ,p_name => 'P_ATTRIBUTE20_'||i)
868
869 --information_category
870 ,hr_transaction_api.get_varchar2_value
871 (p_transaction_step_id => p_transaction_step_id
872 ,p_name => 'P_INFORMATION_CATEGORY_'||i)
873
874 --information1
875 ,hr_transaction_api.get_varchar2_value
876 (p_transaction_step_id => p_transaction_step_id
877 ,p_name => 'P_INFORMATION1_'||i)
878
879 --information2
880 ,hr_transaction_api.get_varchar2_value
881 (p_transaction_step_id => p_transaction_step_id
882 ,p_name => 'P_INFORMATION2_'||i)
883
884 --information3
885 ,hr_transaction_api.get_varchar2_value
886 (p_transaction_step_id => p_transaction_step_id
887 ,p_name => 'P_INFORMATION3_'||i)
888
889 --information4
890 ,hr_transaction_api.get_varchar2_value
891 (p_transaction_step_id => p_transaction_step_id
892 ,p_name => 'P_INFORMATION4_'||i)
893
894 --information5
895 ,hr_transaction_api.get_varchar2_value
896 (p_transaction_step_id => p_transaction_step_id
897 ,p_name => 'P_INFORMATION5_'||i)
898
899 --information6
900 ,hr_transaction_api.get_varchar2_value
901 (p_transaction_step_id => p_transaction_step_id
902 ,p_name => 'P_INFORMATION6_'||i)
903
904 --information7
905 ,hr_transaction_api.get_varchar2_value
906 (p_transaction_step_id => p_transaction_step_id
907 ,p_name => 'P_INFORMATION7_'||i)
908
909 --information8
910 ,hr_transaction_api.get_varchar2_value
911 (p_transaction_step_id => p_transaction_step_id
912 ,p_name => 'P_INFORMATION8_'||i)
913
914 --information9
915 ,hr_transaction_api.get_varchar2_value
916 (p_transaction_step_id => p_transaction_step_id
917 ,p_name => 'P_INFORMATION9_'||i)
918
919 --information10
920 ,hr_transaction_api.get_varchar2_value
921 (p_transaction_step_id => p_transaction_step_id
922 ,p_name => 'P_INFORMATION10_'||i)
923
924 --information11
925 ,hr_transaction_api.get_varchar2_value
926 (p_transaction_step_id => p_transaction_step_id
927 ,p_name => 'P_INFORMATION11_'||i)
928
929 --information12
930 ,hr_transaction_api.get_varchar2_value
931 (p_transaction_step_id => p_transaction_step_id
932 ,p_name => 'P_INFORMATION12_'||i)
933
934 --information13
935 ,hr_transaction_api.get_varchar2_value
936 (p_transaction_step_id => p_transaction_step_id
937 ,p_name => 'P_INFORMATION13_'||i)
938
939 --information14
940 ,hr_transaction_api.get_varchar2_value
941 (p_transaction_step_id => p_transaction_step_id
942 ,p_name => 'P_INFORMATION14_'||i)
943
944 --information15
945 ,hr_transaction_api.get_varchar2_value
946 (p_transaction_step_id => p_transaction_step_id
947 ,p_name => 'P_INFORMATION15_'||i)
948
949 --information16
950 ,hr_transaction_api.get_varchar2_value
951 (p_transaction_step_id => p_transaction_step_id
952 ,p_name => 'P_INFORMATION16_'||i)
953
954 --information17
955 ,hr_transaction_api.get_varchar2_value
956 (p_transaction_step_id => p_transaction_step_id
957 ,p_name => 'P_INFORMATION17_'||i)
958
959 --information18
960 ,hr_transaction_api.get_varchar2_value
961 (p_transaction_step_id => p_transaction_step_id
962 ,p_name => 'P_INFORMATION18_'||i)
963
964 --information19
965 ,hr_transaction_api.get_varchar2_value
966 (p_transaction_step_id => p_transaction_step_id
967 ,p_name => 'P_INFORMATION19_'||i)
968
969 --information20
970 ,hr_transaction_api.get_varchar2_value
971 (p_transaction_step_id => p_transaction_step_id
972 ,p_name => 'P_INFORMATION20_'||i)
973
974 --information21
975 ,hr_transaction_api.get_varchar2_value
976 (p_transaction_step_id => p_transaction_step_id
977 ,p_name => 'P_INFORMATION21_'||i)
978
979 --information22
980 ,hr_transaction_api.get_varchar2_value
981 (p_transaction_step_id => p_transaction_step_id
982 ,p_name => 'P_INFORMATION22_'||i)
983
984 --information23
985 ,hr_transaction_api.get_varchar2_value
986 (p_transaction_step_id => p_transaction_step_id
987 ,p_name => 'P_INFORMATION23_'||i)
988
989 --information24
990 ,hr_transaction_api.get_varchar2_value
991 (p_transaction_step_id => p_transaction_step_id
992 ,p_name => 'P_INFORMATION24_'||i)
993
994 --information25
995 ,hr_transaction_api.get_varchar2_value
996 (p_transaction_step_id => p_transaction_step_id
997 ,p_name => 'P_INFORMATION25_'||i)
998
999 --information26
1000 ,hr_transaction_api.get_varchar2_value
1001 (p_transaction_step_id => p_transaction_step_id
1002 ,p_name => 'P_INFORMATION26_'||i)
1003
1004 --information27
1005 ,hr_transaction_api.get_varchar2_value
1006 (p_transaction_step_id => p_transaction_step_id
1007 ,p_name => 'P_INFORMATION27_'||i)
1008
1009 --information28
1010 ,hr_transaction_api.get_varchar2_value
1011 (p_transaction_step_id => p_transaction_step_id
1012 ,p_name => 'P_INFORMATION28_'||i)
1013
1014 --information29
1015 ,hr_transaction_api.get_varchar2_value
1016 (p_transaction_step_id => p_transaction_step_id
1017 ,p_name => 'P_INFORMATION29_'||i)
1018
1019 --information30
1020 ,hr_transaction_api.get_varchar2_value
1021 (p_transaction_step_id => p_transaction_step_id
1022 ,p_name => 'P_INFORMATION30_'||i));
1023
1024 END LOOP;
1025 hr_utility.trace('End of FOR:'||l_proc);
1026 p_eit_table := l_eit_table;
1027 dump_eit_table(p_eit_table);
1028 hr_utility.set_location('Exiting:'||l_proc, 30);
1029
1030 EXCEPTION
1031 -- Catch any exception thrown while storing transaction data
1032 WHEN OTHERS THEN
1033 hr_utility.set_location('Exception:Others'||l_proc,555);
1034 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1035 p_error_message => p_error_message);
1036
1037 END get_eit_data_from_tt;
1038
1039 -- ----------------------------------------------------------------------------
1040 -- |-----------------------< del_transaction_data >---------------------------|
1041 -- Wrapper Package for API hr_process_sit_ss.
1042 --
1043 -- Description:
1044 -- This Function dels the transaction data for the given item type, item key
1045 -- and activity id.
1046 -- ----------------------------------------------------------------------------
1047
1048 PROCEDURE del_transaction_data
1049 (p_item_type in varchar2
1050 ,p_item_key in varchar2
1051 ,p_activity_id in varchar2
1052 ,p_login_person_id in varchar2
1053 ,p_flow_mode in varchar2 default null
1054 ) IS
1055 --
1056 l_proc varchar2(72) := g_package||'del_transaction_data';
1057
1058 BEGIN
1059
1060 hr_utility.set_location('Entering:'||l_proc, 5);
1061 if p_flow_mode is not null and
1062 p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1063
1064 then
1065 hr_utility.trace('p_flow_mode is not null but is NewHireReg:'||l_proc);
1066 hr_utility.trace('Rolling back:'||l_proc);
1067 rollback;
1068 end if;
1069 if(hr_utility.debug_enabled) then
1070
1071 hr_utility.trace(
1072 'hr_process_eit_ss.del_transaction_data' ||
1073 ' p_item_type: '||p_item_type||
1074 ' p_item_key: '||p_item_key||
1075 ' p_activity_id: '||p_activity_id||
1076 ' p_login_person_id: '||p_login_person_id);
1077 end if;
1078
1079 hr_transaction_ss.delete_transaction_steps(
1080 p_item_type => p_item_type
1081 ,p_item_key => p_item_key
1082 ,p_actid => p_activity_id
1083 ,p_login_person_id => p_login_person_id
1084 );
1085
1086 hr_utility.set_location('Exiting:'||l_proc, 20);
1087 END del_transaction_data;
1088
1089 -- ----------------------------------------------------------------------------
1090 -- |----------------------------< process_api >-------------------------------|
1091 -- ----------------------------------------------------------------------------
1092 PROCEDURE PROCESS_API
1093 (p_validate IN BOOLEAN DEFAULT FALSE
1094 ,p_transaction_step_id IN NUMBER DEFAULT NULL
1095 ,p_effective_date IN VARCHAR2 default null
1096 )is
1097
1098 l_person_id number;
1099 l_login_person_id number;
1100 l_eit_type varchar2(80);
1101 l_eit_type_id number;
1102 l_eit_number number;
1103 l_eit_table HR_EIT_STRUCTURE_TABLE;
1104 l_extra_info_id number;
1105 l_object_version_number number;
1106 l_error_message long;
1107 l_active_view varchar2(200);
1108 l_active_row_id number;
1109 l_index NUMBER;
1110 l_proc varchar2(72) := g_package||'PROCESS_API';
1111
1112 BEGIN
1113
1114 hr_utility.set_location('Entering:'||l_proc, 5);
1115 hr_utility.trace(
1116 'hr_process_eit_ss.process_api' ||
1117 ' p_transaction_step_id: ');--||p_transaction_step_id);
1118
1119 --insert session because some flex uses the session effective date.
1120 if p_effective_date is not null then
1121 hr_utility.trace('EffDate!=Null:'||l_proc);
1122 hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
1123 else
1124 hr_utility.trace('EffDate==Null:'||l_proc);
1125 hr_util_misc_web.insert_session_row(SYSDATE);
1126 end if;
1127
1128 get_eit_data_from_tt
1129 (p_transaction_step_id => p_transaction_step_id
1130 ,p_person_id => l_person_id
1131 ,p_login_person_id => l_login_person_id
1132 ,p_eit_type => l_eit_type
1133 ,p_eit_type_id => l_eit_type_id
1134 ,p_eit_number => l_eit_number
1135 ,p_eit_table => l_eit_table
1136 ,p_error_message => l_error_message
1137 ,p_active_view => l_active_view
1138 ,p_active_row_id => l_active_row_id
1139 );
1140
1141 --debug
1142 if(hr_utility.debug_enabled)then
1143
1144 hr_utility.trace(
1145 'hr_process_eit_ss.process_api' ||
1146 ' p_person_id: '||l_person_id||
1147 ' p_login_person_id: '||l_login_person_id||
1148 ' p_eit_type: '||l_eit_type||
1149 ' p_eit_type_id: '||l_eit_type_id||
1150 ' p_eit_number: '||l_eit_number);
1151 end if;
1152
1153
1154 hr_utility.trace('Before DumpingEIT table:'||l_proc);
1155 dump_eit_table(l_eit_table);
1156
1157 hr_utility.trace('FOR j IN 1..2'||l_proc);
1158 FOR j IN 1..2 LOOP
1159 l_index := l_eit_table.first;
1160 LOOP
1161 EXIT WHEN
1162 (NOT l_eit_table.exists(l_index));
1163
1164 hr_utility.trace('End of FOR '||l_proc);
1165
1166 hr_utility.trace(
1167 'hr_process_eit_ss.process_api' ||
1168 ' l_index: '||l_index);
1169
1170 IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'
1171 OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN
1172
1173
1174 IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1175 -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1176
1177 -- hr_utility.trace(
1178 -- 'hr_process_eit_ss.process_api' ||
1179 -- ' create a row: ');
1180
1181 create_eit
1182 (p_validate => 0
1183 ,p_login_person_id => l_login_person_id
1184 ,p_eit_type => l_eit_type
1185 ,p_eit_type_id => l_eit_type_id
1186 ,p_person_id => l_person_id
1187 ,p_information_type => l_eit_table(l_index).information_type
1188 ,p_attribute_category => l_eit_table(l_index).attribute_category
1189 ,p_attribute1 => l_eit_table(l_index).attribute1
1190 ,p_attribute2 => l_eit_table(l_index).attribute2
1191 ,p_attribute3 => l_eit_table(l_index).attribute3
1192 ,p_attribute4 => l_eit_table(l_index).attribute4
1193 ,p_attribute5 => l_eit_table(l_index).attribute5
1194 ,p_attribute6 => l_eit_table(l_index).attribute6
1195 ,p_attribute7 => l_eit_table(l_index).attribute7
1196 ,p_attribute8 => l_eit_table(l_index).attribute8
1197 ,p_attribute9 => l_eit_table(l_index).attribute9
1198 ,p_attribute10 => l_eit_table(l_index).attribute10
1199 ,p_attribute11 => l_eit_table(l_index).attribute11
1200 ,p_attribute12 => l_eit_table(l_index).attribute12
1201 ,p_attribute13 => l_eit_table(l_index).attribute13
1202 ,p_attribute14 => l_eit_table(l_index).attribute14
1203 ,p_attribute15 => l_eit_table(l_index).attribute15
1204 ,p_attribute16 => l_eit_table(l_index).attribute16
1205 ,p_attribute17 => l_eit_table(l_index).attribute17
1206 ,p_attribute18 => l_eit_table(l_index).attribute18
1207 ,p_attribute19 => l_eit_table(l_index).attribute19
1208 ,p_attribute20 => l_eit_table(l_index).attribute20
1209 ,p_information_category => l_eit_table(l_index).information_category
1210 ,p_information1 => l_eit_table(l_index).information1
1211 ,p_information2 => l_eit_table(l_index).information2
1212 ,p_information3 => l_eit_table(l_index).information3
1213 ,p_information4 => l_eit_table(l_index).information4
1214 ,p_information5 => l_eit_table(l_index).information5
1215 ,p_information6 => l_eit_table(l_index).information6
1216 ,p_information7 => l_eit_table(l_index).information7
1217 ,p_information8 => l_eit_table(l_index).information8
1218 ,p_information9 => l_eit_table(l_index).information9
1219 ,p_information10 => l_eit_table(l_index).information10
1220 ,p_information11 => l_eit_table(l_index).information11
1221 ,p_information12 => l_eit_table(l_index).information12
1222 ,p_information13 => l_eit_table(l_index).information13
1223 ,p_information14 => l_eit_table(l_index).information14
1224 ,p_information15 => l_eit_table(l_index).information15
1225 ,p_information16 => l_eit_table(l_index).information16
1226 ,p_information17 => l_eit_table(l_index).information17
1227 ,p_information18 => l_eit_table(l_index).information18
1228 ,p_information19 => l_eit_table(l_index).information19
1229 ,p_information20 => l_eit_table(l_index).information20
1230 ,p_information21 => l_eit_table(l_index).information21
1231 ,p_information22 => l_eit_table(l_index).information22
1232 ,p_information23 => l_eit_table(l_index).information23
1233 ,p_information24 => l_eit_table(l_index).information24
1234 ,p_information25 => l_eit_table(l_index).information25
1235 ,p_information26 => l_eit_table(l_index).information26
1236 ,p_information27 => l_eit_table(l_index).information27
1237 ,p_information28 => l_eit_table(l_index).information28
1238 ,p_information29 => l_eit_table(l_index).information29
1239 ,p_information30 => l_eit_table(l_index).information30
1240 ,p_extra_info_id => l_extra_info_id
1241 ,p_object_version_number => l_object_version_number
1242 -- EndRegistration
1243 ,p_item_type => null
1244 ,p_item_key => null
1245 ,p_activity_id => null
1246 ,p_action => null
1247 ,p_old_extra_info_id => null
1248 ,p_old_object_version_number => null
1249 ,p_save_mode => null
1250 ,p_error_message => l_error_message
1251 );
1252
1253 -- hr_utility.trace(
1254 -- 'hr_process_eit_ss.process_api' ||
1255 -- ' create a row with extra info type id'||l_extra_info_id);
1256
1257
1258 ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1259 -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1260
1261 -- hr_utility.trace(
1262 -- 'hr_process_eit_ss.process_api' ||
1263 -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1264
1265 update_eit
1266 (p_validate => 0
1267 ,p_login_person_id => l_login_person_id
1268 ,p_eit_type => l_eit_type
1269 ,p_eit_type_id => l_eit_type_id
1270 ,p_person_id => l_person_id
1271 ,p_information_type => l_eit_table(l_index).information_type
1272 ,p_attribute_category => l_eit_table(l_index).attribute_category
1273 ,p_attribute1 => l_eit_table(l_index).attribute1
1274 ,p_attribute2 => l_eit_table(l_index).attribute2
1275 ,p_attribute3 => l_eit_table(l_index).attribute3
1276 ,p_attribute4 => l_eit_table(l_index).attribute4
1277 ,p_attribute5 => l_eit_table(l_index).attribute5
1278 ,p_attribute6 => l_eit_table(l_index).attribute6
1279 ,p_attribute7 => l_eit_table(l_index).attribute7
1280 ,p_attribute8 => l_eit_table(l_index).attribute8
1281 ,p_attribute9 => l_eit_table(l_index).attribute9
1282 ,p_attribute10 => l_eit_table(l_index).attribute10
1283 ,p_attribute11 => l_eit_table(l_index).attribute11
1284 ,p_attribute12 => l_eit_table(l_index).attribute12
1285 ,p_attribute13 => l_eit_table(l_index).attribute13
1286 ,p_attribute14 => l_eit_table(l_index).attribute14
1287 ,p_attribute15 => l_eit_table(l_index).attribute15
1288 ,p_attribute16 => l_eit_table(l_index).attribute16
1289 ,p_attribute17 => l_eit_table(l_index).attribute17
1290 ,p_attribute18 => l_eit_table(l_index).attribute18
1291 ,p_attribute19 => l_eit_table(l_index).attribute19
1292 ,p_attribute20 => l_eit_table(l_index).attribute20
1293 ,p_information_category => l_eit_table(l_index).information_category
1294 ,p_information1 => l_eit_table(l_index).information1
1295 ,p_information2 => l_eit_table(l_index).information2
1296 ,p_information3 => l_eit_table(l_index).information3
1297 ,p_information4 => l_eit_table(l_index).information4
1298 ,p_information5 => l_eit_table(l_index).information5
1299 ,p_information6 => l_eit_table(l_index).information6
1300 ,p_information7 => l_eit_table(l_index).information7
1301 ,p_information8 => l_eit_table(l_index).information8
1302 ,p_information9 => l_eit_table(l_index).information9
1303 ,p_information10 => l_eit_table(l_index).information10
1304 ,p_information11 => l_eit_table(l_index).information11
1305 ,p_information12 => l_eit_table(l_index).information12
1306 ,p_information13 => l_eit_table(l_index).information13
1307 ,p_information14 => l_eit_table(l_index).information14
1308 ,p_information15 => l_eit_table(l_index).information15
1309 ,p_information16 => l_eit_table(l_index).information16
1310 ,p_information17 => l_eit_table(l_index).information17
1311 ,p_information18 => l_eit_table(l_index).information18
1312 ,p_information19 => l_eit_table(l_index).information19
1313 ,p_information20 => l_eit_table(l_index).information20
1314 ,p_information21 => l_eit_table(l_index).information21
1315 ,p_information22 => l_eit_table(l_index).information22
1316 ,p_information23 => l_eit_table(l_index).information23
1317 ,p_information24 => l_eit_table(l_index).information24
1318 ,p_information25 => l_eit_table(l_index).information25
1319 ,p_information26 => l_eit_table(l_index).information26
1320 ,p_information27 => l_eit_table(l_index).information27
1321 ,p_information28 => l_eit_table(l_index).information28
1322 ,p_information29 => l_eit_table(l_index).information29
1323 ,p_information30 => l_eit_table(l_index).information30
1324 ,p_extra_info_id => l_eit_table(l_index).extra_info_id
1325 ,p_object_version_number => l_eit_table(l_index).object_version_number
1326 -- EndRegistration
1327 ,p_item_type => null
1328 ,p_item_key => null
1329 ,p_activity_id => null
1330 ,p_action => null
1331 ,p_old_extra_info_id => null
1332 ,p_old_object_version_number => null
1333 ,p_save_mode => null
1334 ,p_error_message => l_error_message
1335 );
1336
1337 ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1338
1339 -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1340 -- hr_utility.trace(
1341 -- 'hr_process_eit_ss.process_api' ||
1342 -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1343
1344 delete_eit
1345 (p_validate => 0
1346 ,p_login_person_id => l_login_person_id
1347 ,p_eit_type => l_eit_type
1348 ,p_eit_type_id => l_eit_type_id
1349 ,p_person_id => l_person_id
1350 ,p_information_type => l_eit_table(l_index).information_type
1351 ,p_extra_info_id => l_eit_table(l_index).extra_info_id
1352 ,p_object_version_number => l_eit_table(l_index).object_version_number
1353 -- EndRegistration
1354 ,p_item_type => null
1355 ,p_item_key => null
1356 ,p_activity_id => null
1357 ,p_action => null
1358 ,p_old_extra_info_id => null
1359 ,p_old_object_version_number => null
1360 ,p_save_mode => null
1361 ,p_error_message => l_error_message
1362 );
1363
1364 END IF;
1365 END IF;
1366
1367 -- hr_utility.trace(
1368 -- 'hr_process_eit_ss.process_api' ||
1369 -- ' l_error_message: '||l_error_message);
1370
1371 l_index := l_eit_table.next(l_index);
1372
1373 END LOOP;
1374 END LOOP;
1375
1376 --remove session
1377 hr_util_misc_web.remove_session_row();
1378
1379 if l_error_message is not null then
1380 hr_utility.raise_error;
1381 end if;
1382 hr_utility.set_location('Exiting:'||l_proc, 40);
1383
1384 EXCEPTION
1385 WHEN OTHERS THEN
1386 hr_utility.set_location('Exception:Others'||l_proc,555);
1387 raise;
1388
1389 END process_api;
1390
1391
1392 /*
1393 ||===========================================================================
1394 || PROCEDURE: create_eit
1395 ||---------------------------------------------------------------------------
1396 ||
1397 || Description:
1398 || This procedure will call the actual API -
1399 ||
1400 ||
1401 || Access Status:
1402 || Public.
1403 ||
1404 ||===========================================================================
1405 */
1406 PROCEDURE create_eit
1407 (p_validate in number default 0
1408 ,p_login_person_id in number default null
1409 ,p_eit_type in varchar2
1410 ,p_person_id in number
1411 ,p_information_type in varchar2
1412 ,p_attribute_category in varchar2 default null
1413 ,p_attribute1 in varchar2 default null
1414 ,p_attribute2 in varchar2 default null
1415 ,p_attribute3 in varchar2 default null
1416 ,p_attribute4 in varchar2 default null
1417 ,p_attribute5 in varchar2 default null
1418 ,p_attribute6 in varchar2 default null
1419 ,p_attribute7 in varchar2 default null
1420 ,p_attribute8 in varchar2 default null
1421 ,p_attribute9 in varchar2 default null
1422 ,p_attribute10 in varchar2 default null
1423 ,p_attribute11 in varchar2 default null
1424 ,p_attribute12 in varchar2 default null
1425 ,p_attribute13 in varchar2 default null
1426 ,p_attribute14 in varchar2 default null
1427 ,p_attribute15 in varchar2 default null
1428 ,p_attribute16 in varchar2 default null
1429 ,p_attribute17 in varchar2 default null
1430 ,p_attribute18 in varchar2 default null
1431 ,p_attribute19 in varchar2 default null
1432 ,p_attribute20 in varchar2 default null
1433 ,p_information_category in varchar2 default null
1434 ,p_information1 in varchar2 default null
1435 ,p_information2 in varchar2 default null
1436 ,p_information3 in varchar2 default null
1437 ,p_information4 in varchar2 default null
1438 ,p_information5 in varchar2 default null
1439 ,p_information6 in varchar2 default null
1440 ,p_information7 in varchar2 default null
1441 ,p_information8 in varchar2 default null
1442 ,p_information9 in varchar2 default null
1443 ,p_information10 in varchar2 default null
1444 ,p_information11 in varchar2 default null
1445 ,p_information12 in varchar2 default null
1446 ,p_information13 in varchar2 default null
1447 ,p_information14 in varchar2 default null
1448 ,p_information15 in varchar2 default null
1449 ,p_information16 in varchar2 default null
1450 ,p_information17 in varchar2 default null
1451 ,p_information18 in varchar2 default null
1452 ,p_information19 in varchar2 default null
1453 ,p_information20 in varchar2 default null
1454 ,p_information21 in varchar2 default null
1455 ,p_information22 in varchar2 default null
1456 ,p_information23 in varchar2 default null
1457 ,p_information24 in varchar2 default null
1458 ,p_information25 in varchar2 default null
1459 ,p_information26 in varchar2 default null
1460 ,p_information27 in varchar2 default null
1461 ,p_information28 in varchar2 default null
1462 ,p_information29 in varchar2 default null
1463 ,p_information30 in varchar2 default null
1464 ,p_extra_info_id out nocopy number
1465 ,p_object_version_number out nocopy number
1466 -- EndRegistration
1467 ,p_item_type in varchar2
1468 ,p_item_key in varchar2
1469 ,p_activity_id in number
1470 ,p_action in varchar2
1471 ,p_old_extra_info_id in number default null
1472 ,p_old_object_version_number in number default null
1473 ,p_save_mode in varchar2 default null
1474 ,p_error_message out nocopy long
1475 ,p_eit_type_id in number
1476 ,p_flow_mode in varchar2 default null
1477 )
1478 IS
1479 --
1480 -- Declare cursors and local variables
1481 --
1482 l_proc varchar2(72) := g_package||'create_eit';
1483 l_dummy_num number;
1484 l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1485 l_object_version_number per_people_extra_info.object_version_number%type;
1486 l_transaction_id number default null;
1487 l_result varchar2(100) default null;
1488 l_new_hire boolean default false;
1489 l_person_id number;
1490 l_assignment_id number;
1491 l_eit_type_id number;
1492
1493 BEGIN
1494 --
1495 -- Call the actual API.
1496 --
1497
1498 --
1499 -- if the extra info type is a PERSON
1500 --
1501 hr_utility.set_location('Entering:'||l_proc, 5);
1502 if(hr_utility.debug_enabled) then
1503
1504 hr_utility.trace(
1505 'hr_process_eit_ss.create_eit' ||
1506 ' arrive '||
1507 'p_validate '||p_validate||
1508 ' p_login_person_id '||p_login_person_id||
1509 ' p_eit_type '||p_eit_type||
1510 ' p_eit_type_id '||p_eit_type_id||
1511 ' p_person_id '||p_person_id||
1512 ' p_information_type '||p_information_type||
1513 ' p_attribute_category '||p_attribute_category||
1514 ' p_attribute1 '||p_attribute1||
1515 ' p_attribute2 '||p_attribute2||
1516 ' p_attribute3 '||p_attribute3||
1517 ' p_attribute4 '||p_attribute4||
1518 ' p_attribute5 '||p_attribute5||
1519 ' p_attribute6 '||p_attribute6||
1520 ' p_attribute7 '||p_attribute7||
1521 ' p_attribute8 '||p_attribute8||
1522 ' p_attribute9 '||p_attribute9||
1523 ' p_attribute10 '||p_attribute10||
1524 ' p_attribute11 '||p_attribute11||
1525 ' p_attribute12 '||p_attribute12||
1526 ' p_attribute13 '||p_attribute13||
1527 ' p_attribute14 '||p_attribute14||
1528 ' p_attribute15 '||p_attribute15||
1529 ' p_attribute16 '||p_attribute16||
1530 ' p_attribute17 '||p_attribute17||
1531 ' p_attribute18 '||p_attribute18||
1532 ' p_attribute19 '||p_attribute19||
1533 ' p_attribute20 '||p_attribute20||
1534 ' p_information_category '||p_information_category||
1535 ' p_information1 '||p_information1||
1536 ' p_information2 '||p_information2||
1537 ' p_information3 '||p_information3||
1538 ' p_information4 '||p_information4||
1539 ' p_information5 '||p_information5||
1540 ' p_information6 '||p_information6||
1541 ' p_information7 '||p_information7||
1542 ' p_information8 '||p_information8||
1543 ' p_information9 '||p_information9||
1544 ' p_information10 '||p_information10||
1545 ' p_information11 '||p_information11||
1546 ' p_information12 '||p_information12||
1547 ' p_information13 '||p_information13||
1548 ' p_information14 '||p_information14||
1549 ' p_information15 '||p_information15||
1550 ' p_information16 '||p_information16||
1551 ' p_information17 '||p_information17||
1552 ' p_information18 '||p_information18||
1553 ' p_information19 '||p_information19||
1554 ' p_information20 '||p_information20||
1555 ' p_information21 '||p_information21||
1556 ' p_information22 '||p_information22||
1557 ' p_information23 '||p_information23||
1558 ' p_information24 '||p_information24||
1559 ' p_information25 '||p_information25||
1560 ' p_information26 '||p_information26||
1561 ' p_information27 '||p_information27||
1562 ' p_information28 '||p_information28||
1563 ' p_information29 '||p_information29||
1564 ' p_information30 '||p_information30||
1565 ' p_item_type '||p_item_type||
1566 ' p_item_key '||p_item_key ||
1567 ' p_activity_id '||p_activity_id||
1568 ' p_action '||p_action||
1569 ' p_old_extra_info_id '||p_old_extra_info_id||
1570 ' p_old_object_version_number '||p_old_object_version_number||
1571 ' p_save_mode '||p_save_mode);
1572 end if;
1573 --l_eit_type_id := p_eit_type_id;
1574
1575 if p_flow_mode is not null and
1576 p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
1577 then
1578 hr_utility.trace('p_flow_mode!=null but NewHireReg:'||l_proc);
1579 l_new_hire := TRUE;
1580 end if;
1581
1582 l_eit_type_id := p_eit_type_id;
1583
1584 if l_new_hire then
1585 hr_utility.trace('if l_new_hire:'||l_proc);
1586 hr_new_user_reg_ss.processNewUserTransaction
1587 (WfItemType => p_item_type
1588 ,WfItemKey => p_item_key
1589 ,PersonId => l_person_id
1590 ,AssignmentId => l_assignment_id);
1591 if p_eit_type = 'PERSON' then
1592 l_eit_type_id := l_person_id;
1593 else
1594 l_eit_type_id := l_assignment_id;
1595 end if;
1596 end if;
1597
1598
1599 if p_eit_type = 'PERSON' then
1600 hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1601 hr_utility.trace(
1602 'hr_process_eit_ss.create_eit' ||
1603 ' p_eit_type '||p_eit_type);
1604
1605 hr_person_extra_info_api.create_person_extra_info
1606 (p_validate => hr_java_conv_util_ss.get_boolean (
1607 p_number => p_validate)
1608 ,p_person_id => l_eit_type_id
1609 ,p_information_type => p_information_type
1610 ,p_pei_attribute_category => p_attribute_category
1611 ,p_pei_attribute1 => p_attribute1
1612 ,p_pei_attribute2 => p_attribute2
1613 ,p_pei_attribute3 => p_attribute3
1614 ,p_pei_attribute4 => p_attribute4
1615 ,p_pei_attribute5 => p_attribute5
1616 ,p_pei_attribute6 => p_attribute6
1617 ,p_pei_attribute7 => p_attribute7
1618 ,p_pei_attribute8 => p_attribute8
1619 ,p_pei_attribute9 => p_attribute9
1620 ,p_pei_attribute10 => p_attribute10
1621 ,p_pei_attribute11 => p_attribute11
1622 ,p_pei_attribute12 => p_attribute12
1623 ,p_pei_attribute13 => p_attribute13
1624 ,p_pei_attribute14 => p_attribute14
1625 ,p_pei_attribute15 => p_attribute15
1626 ,p_pei_attribute16 => p_attribute16
1627 ,p_pei_attribute17 => p_attribute17
1628 ,p_pei_attribute18 => p_attribute18
1629 ,p_pei_attribute19 => p_attribute19
1630 ,p_pei_attribute20 => p_attribute20
1631 ,p_pei_information_category => p_information_category
1632 ,p_pei_information1 => p_information1
1633 ,p_pei_information2 => p_information2
1634 ,p_pei_information3 => p_information3
1635 ,p_pei_information4 => p_information4
1636 ,p_pei_information5 => p_information5
1637 ,p_pei_information6 => p_information6
1638 ,p_pei_information7 => p_information7
1639 ,p_pei_information8 => p_information8
1640 ,p_pei_information9 => p_information9
1641 ,p_pei_information10 => p_information10
1642 ,p_pei_information11 => p_information11
1643 ,p_pei_information12 => p_information12
1644 ,p_pei_information13 => p_information13
1645 ,p_pei_information14 => p_information14
1646 ,p_pei_information15 => p_information15
1647 ,p_pei_information16 => p_information16
1648 ,p_pei_information17 => p_information17
1649 ,p_pei_information18 => p_information18
1650 ,p_pei_information19 => p_information19
1651 ,p_pei_information20 => p_information20
1652 ,p_pei_information21 => p_information21
1653 ,p_pei_information22 => p_information22
1654 ,p_pei_information23 => p_information23
1655 ,p_pei_information24 => p_information24
1656 ,p_pei_information25 => p_information25
1657 ,p_pei_information26 => p_information26
1658 ,p_pei_information27 => p_information27
1659 ,p_pei_information28 => p_information28
1660 ,p_pei_information29 => p_information29
1661 ,p_pei_information30 => p_information30
1662 ,p_person_extra_info_id => l_extra_info_id
1663 ,p_object_version_number => l_object_version_number
1664 );
1665
1666
1667 p_object_version_number := l_object_version_number;
1668 p_extra_info_id := l_extra_info_id;
1669
1670 hr_utility.trace(
1671 'hr_process_eit_ss.create_eit' ||
1672 ' out nocopy create params '||
1673 ' p_person_extra_info_id '||l_extra_info_id||
1674 ' p_object_version_number '||l_object_version_number);
1675
1676 elsif p_eit_type = 'ASSIGNMENT' then
1677 hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1678 hr_utility.trace(
1679 'hr_process_eit_ss.create_eit' ||
1680 ' p_eit_type '||p_eit_type);
1681
1682 hr_assignment_extra_info_api.create_assignment_extra_info
1683 (p_validate => hr_java_conv_util_ss.get_boolean (
1684 p_number => p_validate)
1685 ,p_assignment_id => l_eit_type_id
1686 ,p_information_type => p_information_type
1687 ,p_aei_attribute_category => p_attribute_category
1688 ,p_aei_attribute1 => p_attribute1
1689 ,p_aei_attribute2 => p_attribute2
1690 ,p_aei_attribute3 => p_attribute3
1691 ,p_aei_attribute4 => p_attribute4
1692 ,p_aei_attribute5 => p_attribute5
1693 ,p_aei_attribute6 => p_attribute6
1694 ,p_aei_attribute7 => p_attribute7
1695 ,p_aei_attribute8 => p_attribute8
1696 ,p_aei_attribute9 => p_attribute9
1697 ,p_aei_attribute10 => p_attribute10
1698 ,p_aei_attribute11 => p_attribute11
1699 ,p_aei_attribute12 => p_attribute12
1700 ,p_aei_attribute13 => p_attribute13
1701 ,p_aei_attribute14 => p_attribute14
1702 ,p_aei_attribute15 => p_attribute15
1703 ,p_aei_attribute16 => p_attribute16
1704 ,p_aei_attribute17 => p_attribute17
1705 ,p_aei_attribute18 => p_attribute18
1706 ,p_aei_attribute19 => p_attribute19
1707 ,p_aei_attribute20 => p_attribute20
1708 ,p_aei_information_category => p_information_category
1709 ,p_aei_information1 => p_information1
1710 ,p_aei_information2 => p_information2
1711 ,p_aei_information3 => p_information3
1712 ,p_aei_information4 => p_information4
1713 ,p_aei_information5 => p_information5
1714 ,p_aei_information6 => p_information6
1715 ,p_aei_information7 => p_information7
1716 ,p_aei_information8 => p_information8
1717 ,p_aei_information9 => p_information9
1718 ,p_aei_information10 => p_information10
1719 ,p_aei_information11 => p_information11
1720 ,p_aei_information12 => p_information12
1721 ,p_aei_information13 => p_information13
1722 ,p_aei_information14 => p_information14
1723 ,p_aei_information15 => p_information15
1724 ,p_aei_information16 => p_information16
1725 ,p_aei_information17 => p_information17
1726 ,p_aei_information18 => p_information18
1727 ,p_aei_information19 => p_information19
1728 ,p_aei_information20 => p_information20
1729 ,p_aei_information21 => p_information21
1730 ,p_aei_information22 => p_information22
1731 ,p_aei_information23 => p_information23
1732 ,p_aei_information24 => p_information24
1733 ,p_aei_information25 => p_information25
1734 ,p_aei_information26 => p_information26
1735 ,p_aei_information27 => p_information27
1736 ,p_aei_information28 => p_information28
1737 ,p_aei_information29 => p_information29
1738 ,p_aei_information30 => p_information30
1739 ,p_assignment_extra_info_id => l_extra_info_id
1740 ,p_object_version_number => l_object_version_number
1741 );
1742
1743
1744 p_object_version_number := l_object_version_number;
1745 p_extra_info_id := l_extra_info_id;
1746
1747 if(hr_utility.debug_enabled) then
1748 hr_utility.trace(
1749 'hr_process_eit_ss.create_eit' ||
1750 ' out nocopy create params '||
1751 ' p_person_extra_info_id '||l_extra_info_id||
1752 ' p_object_version_number '||l_object_version_number);
1753 end if;
1754 end if;
1755
1756 --
1757 -- PB : Now rollback all the changes which are performed.
1758 --
1759 hr_utility.trace(l_proc);
1760
1761 -- first check if this is being called for registration.
1762 if l_new_hire then
1763 hr_utility.trace('if l_new_hire: then rollback'||l_proc);
1764 rollback;
1765 end if;
1766
1767 hr_utility.set_location('Exiting:'||l_proc, 35);
1768
1769 EXCEPTION
1770
1771 WHEN OTHERS THEN
1772 hr_utility.set_location('Exception:Others'||l_proc,555);
1773 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1774 p_error_message => p_error_message);
1775 hr_utility.trace(
1776 'hr_process_eit_ss.create_eit' ||
1777 ' l_error_message: '||p_error_message ||' '|| sqlerrm );
1778 --
1779 -- A validation or unexpected error has occurred
1780 --
1781 --
1782 if l_new_hire then
1783 rollback;
1784 end if;
1785 END create_eit;
1786
1787 /*
1788 ||===========================================================================
1789 || PROCEDURE: update_eit
1790 ||---------------------------------------------------------------------------
1791 ||
1792 || Description:
1793 || This procedure will call the actual API -
1794 ||
1795 ||
1796 || Access Status:
1797 || Public.
1798 ||
1799 ||===========================================================================
1800 */
1801 PROCEDURE update_eit
1802 (p_validate in number default 0
1803 ,p_login_person_id in number default null
1804 ,p_eit_type in varchar2
1805 ,p_person_id in number
1806 ,p_information_type in varchar2
1807 ,p_attribute_category in varchar2 default null
1808 ,p_attribute1 in varchar2 default null
1809 ,p_attribute2 in varchar2 default null
1810 ,p_attribute3 in varchar2 default null
1811 ,p_attribute4 in varchar2 default null
1812 ,p_attribute5 in varchar2 default null
1813 ,p_attribute6 in varchar2 default null
1814 ,p_attribute7 in varchar2 default null
1815 ,p_attribute8 in varchar2 default null
1816 ,p_attribute9 in varchar2 default null
1817 ,p_attribute10 in varchar2 default null
1818 ,p_attribute11 in varchar2 default null
1819 ,p_attribute12 in varchar2 default null
1820 ,p_attribute13 in varchar2 default null
1821 ,p_attribute14 in varchar2 default null
1822 ,p_attribute15 in varchar2 default null
1823 ,p_attribute16 in varchar2 default null
1824 ,p_attribute17 in varchar2 default null
1825 ,p_attribute18 in varchar2 default null
1826 ,p_attribute19 in varchar2 default null
1827 ,p_attribute20 in varchar2 default null
1828 ,p_information_category in varchar2 default null
1829 ,p_information1 in varchar2 default null
1830 ,p_information2 in varchar2 default null
1831 ,p_information3 in varchar2 default null
1832 ,p_information4 in varchar2 default null
1833 ,p_information5 in varchar2 default null
1834 ,p_information6 in varchar2 default null
1835 ,p_information7 in varchar2 default null
1836 ,p_information8 in varchar2 default null
1837 ,p_information9 in varchar2 default null
1838 ,p_information10 in varchar2 default null
1839 ,p_information11 in varchar2 default null
1840 ,p_information12 in varchar2 default null
1841 ,p_information13 in varchar2 default null
1842 ,p_information14 in varchar2 default null
1843 ,p_information15 in varchar2 default null
1844 ,p_information16 in varchar2 default null
1845 ,p_information17 in varchar2 default null
1846 ,p_information18 in varchar2 default null
1847 ,p_information19 in varchar2 default null
1848 ,p_information20 in varchar2 default null
1849 ,p_information21 in varchar2 default null
1850 ,p_information22 in varchar2 default null
1851 ,p_information23 in varchar2 default null
1852 ,p_information24 in varchar2 default null
1853 ,p_information25 in varchar2 default null
1854 ,p_information26 in varchar2 default null
1855 ,p_information27 in varchar2 default null
1856 ,p_information28 in varchar2 default null
1857 ,p_information29 in varchar2 default null
1858 ,p_information30 in varchar2 default null
1859 ,p_extra_info_id in number
1860 ,p_object_version_number in out nocopy number
1861 -- EndRegistration
1862 ,p_item_type in varchar2
1863 ,p_item_key in varchar2
1864 ,p_activity_id in number
1865 ,p_action in varchar2
1866 ,p_old_extra_info_id in number default null
1867 ,p_old_object_version_number in number default null
1868 ,p_save_mode in varchar2 default null
1869 ,p_error_message out nocopy long
1870 ,p_eit_type_id in number
1871 )
1872 IS
1873 --
1874 -- Declare cursors and local variables
1875 --
1876 l_proc varchar2(72) := g_package||'create_eit';
1877 l_dummy_num number;
1878 l_transaction_id number default null;
1879 l_result varchar2(100) default null;
1880
1881 BEGIN
1882 --
1883 -- Call the actual API.
1884 --
1885
1886 hr_utility.set_location('Entering:'||l_proc, 5);
1887
1888 if(hr_utility.debug_enabled) then
1889
1890 hr_utility.trace(
1891 'hr_process_eit_ss.create_eit' ||
1892 ' arrive '||
1893 'p_validate '||p_validate||
1894 ' p_login_person_id '||p_login_person_id||
1895 ' p_eit_type '||p_eit_type||
1896 ' p_eit_type_id '||p_eit_type_id||
1897 ' p_person_id '||p_person_id||
1898 ' p_information_type '||p_information_type||
1899 ' p_attribute_category '||p_attribute_category||
1900 ' p_attribute1 '||p_attribute1||
1901 ' p_attribute2 '||p_attribute2||
1902 ' p_attribute3 '||p_attribute3||
1903 ' p_attribute4 '||p_attribute4||
1904 ' p_attribute5 '||p_attribute5||
1905 ' p_attribute6 '||p_attribute6||
1906 ' p_attribute7 '||p_attribute7||
1907 ' p_attribute8 '||p_attribute8||
1908 ' p_attribute9 '||p_attribute9||
1909 ' p_attribute10 '||p_attribute10||
1910 ' p_attribute11 '||p_attribute11||
1911 ' p_attribute12 '||p_attribute12||
1912 ' p_attribute13 '||p_attribute13||
1913 ' p_attribute14 '||p_attribute14||
1914 ' p_attribute15 '||p_attribute15||
1915 ' p_attribute16 '||p_attribute16||
1916 ' p_attribute17 '||p_attribute17||
1917 ' p_attribute18 '||p_attribute18||
1918 ' p_attribute19 '||p_attribute19||
1919 ' p_attribute20 '||p_attribute20||
1920 ' p_information_category '||p_information_category||
1921 ' p_information1 '||p_information1||
1922 ' p_information2 '||p_information2||
1923 ' p_information3 '||p_information3||
1924 ' p_information4 '||p_information4||
1925 ' p_information5 '||p_information5||
1926 ' p_information6 '||p_information6||
1927 ' p_information7 '||p_information7||
1928 ' p_information8 '||p_information8||
1929 ' p_information9 '||p_information9||
1930 ' p_information10 '||p_information10||
1931 ' p_information11 '||p_information11||
1932 ' p_information12 '||p_information12||
1933 ' p_information13 '||p_information13||
1934 ' p_information14 '||p_information14||
1935 ' p_information15 '||p_information15||
1936 ' p_information16 '||p_information16||
1937 ' p_information17 '||p_information17||
1938 ' p_information18 '||p_information18||
1939 ' p_information19 '||p_information19||
1940 ' p_information20 '||p_information20||
1941 ' p_information21 '||p_information21||
1942 ' p_information22 '||p_information22||
1943 ' p_information23 '||p_information23||
1944 ' p_information24 '||p_information24||
1945 ' p_information25 '||p_information25||
1946 ' p_information26 '||p_information26||
1947 ' p_information27 '||p_information27||
1948 ' p_information28 '||p_information28||
1949 ' p_information29 '||p_information29||
1950 ' p_information30 '||p_information30||
1951 ' p_item_type '||p_item_type||
1952 ' p_item_key '||p_item_key ||
1953 ' p_activity_id '||p_activity_id||
1954 ' p_action '||p_action||
1955 ' p_old_extra_info_id '||p_old_extra_info_id||
1956 ' p_old_object_version_number '||p_old_object_version_number||
1957 ' p_save_mode '||p_save_mode);
1958
1959 end if;
1960 --
1961 -- if the extra info type is a PERSON
1962 --
1963 if p_eit_type = 'PERSON' then
1964
1965 hr_utility.trace('p_eit_type = PERSON:'||l_proc);
1966
1967 hr_person_extra_info_api.update_person_extra_info
1968 (p_validate => hr_java_conv_util_ss.get_boolean (
1969 p_number => p_validate)
1970 ,p_person_extra_info_id => p_extra_info_id
1971 ,p_object_version_number => p_object_version_number
1972 ,p_pei_attribute_category => p_attribute_category
1973 ,p_pei_attribute1 => p_attribute1
1974 ,p_pei_attribute2 => p_attribute2
1975 ,p_pei_attribute3 => p_attribute3
1976 ,p_pei_attribute4 => p_attribute4
1977 ,p_pei_attribute5 => p_attribute5
1978 ,p_pei_attribute6 => p_attribute6
1979 ,p_pei_attribute7 => p_attribute7
1980 ,p_pei_attribute8 => p_attribute8
1981 ,p_pei_attribute9 => p_attribute9
1982 ,p_pei_attribute10 => p_attribute10
1983 ,p_pei_attribute11 => p_attribute11
1984 ,p_pei_attribute12 => p_attribute12
1985 ,p_pei_attribute13 => p_attribute13
1986 ,p_pei_attribute14 => p_attribute14
1987 ,p_pei_attribute15 => p_attribute15
1988 ,p_pei_attribute16 => p_attribute16
1989 ,p_pei_attribute17 => p_attribute17
1990 ,p_pei_attribute18 => p_attribute18
1991 ,p_pei_attribute19 => p_attribute19
1992 ,p_pei_attribute20 => p_attribute20
1993 ,p_pei_information_category => p_information_category
1994 ,p_pei_information1 => p_information1
1995 ,p_pei_information2 => p_information2
1996 ,p_pei_information3 => p_information3
1997 ,p_pei_information4 => p_information4
1998 ,p_pei_information5 => p_information5
1999 ,p_pei_information6 => p_information6
2000 ,p_pei_information7 => p_information7
2001 ,p_pei_information8 => p_information8
2002 ,p_pei_information9 => p_information9
2003 ,p_pei_information10 => p_information10
2004 ,p_pei_information11 => p_information11
2005 ,p_pei_information12 => p_information12
2006 ,p_pei_information13 => p_information13
2007 ,p_pei_information14 => p_information14
2008 ,p_pei_information15 => p_information15
2009 ,p_pei_information16 => p_information16
2010 ,p_pei_information17 => p_information17
2011 ,p_pei_information18 => p_information18
2012 ,p_pei_information19 => p_information19
2013 ,p_pei_information20 => p_information20
2014 ,p_pei_information21 => p_information21
2015 ,p_pei_information22 => p_information22
2016 ,p_pei_information23 => p_information23
2017 ,p_pei_information24 => p_information24
2018 ,p_pei_information25 => p_information25
2019 ,p_pei_information26 => p_information26
2020 ,p_pei_information27 => p_information27
2021 ,p_pei_information28 => p_information28
2022 ,p_pei_information29 => p_information29
2023 ,p_pei_information30 => p_information30
2024 );
2025
2026 --
2027 -- if the extra info type is a PERSON
2028 --
2029 elsif p_eit_type = 'ASSIGNMENT' then
2030 hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2031
2032 hr_assignment_extra_info_api.update_assignment_extra_info
2033 (p_validate => hr_java_conv_util_ss.get_boolean (
2034 p_number => p_validate)
2035 ,p_assignment_extra_info_id => p_extra_info_id
2036 ,p_object_version_number => p_object_version_number
2037 ,p_aei_attribute_category => p_attribute_category
2038 ,p_aei_attribute1 => p_attribute1
2039 ,p_aei_attribute2 => p_attribute2
2040 ,p_aei_attribute3 => p_attribute3
2041 ,p_aei_attribute4 => p_attribute4
2042 ,p_aei_attribute5 => p_attribute5
2043 ,p_aei_attribute6 => p_attribute6
2044 ,p_aei_attribute7 => p_attribute7
2045 ,p_aei_attribute8 => p_attribute8
2046 ,p_aei_attribute9 => p_attribute9
2047 ,p_aei_attribute10 => p_attribute10
2048 ,p_aei_attribute11 => p_attribute11
2049 ,p_aei_attribute12 => p_attribute12
2050 ,p_aei_attribute13 => p_attribute13
2051 ,p_aei_attribute14 => p_attribute14
2052 ,p_aei_attribute15 => p_attribute15
2053 ,p_aei_attribute16 => p_attribute16
2054 ,p_aei_attribute17 => p_attribute17
2055 ,p_aei_attribute18 => p_attribute18
2056 ,p_aei_attribute19 => p_attribute19
2057 ,p_aei_attribute20 => p_attribute20
2058 ,p_aei_information_category => p_information_category
2059 ,p_aei_information1 => p_information1
2060 ,p_aei_information2 => p_information2
2061 ,p_aei_information3 => p_information3
2062 ,p_aei_information4 => p_information4
2063 ,p_aei_information5 => p_information5
2064 ,p_aei_information6 => p_information6
2065 ,p_aei_information7 => p_information7
2066 ,p_aei_information8 => p_information8
2067 ,p_aei_information9 => p_information9
2068 ,p_aei_information10 => p_information10
2069 ,p_aei_information11 => p_information11
2070 ,p_aei_information12 => p_information12
2071 ,p_aei_information13 => p_information13
2072 ,p_aei_information14 => p_information14
2073 ,p_aei_information15 => p_information15
2074 ,p_aei_information16 => p_information16
2075 ,p_aei_information17 => p_information17
2076 ,p_aei_information18 => p_information18
2077 ,p_aei_information19 => p_information19
2078 ,p_aei_information20 => p_information20
2079 ,p_aei_information21 => p_information21
2080 ,p_aei_information22 => p_information22
2081 ,p_aei_information23 => p_information23
2082 ,p_aei_information24 => p_information24
2083 ,p_aei_information25 => p_information25
2084 ,p_aei_information26 => p_information26
2085 ,p_aei_information27 => p_information27
2086 ,p_aei_information28 => p_information28
2087 ,p_aei_information29 => p_information29
2088 ,p_aei_information30 => p_information30
2089 );
2090
2091 end if;
2092 --
2093 -- PB : Now rollback all the changes which are performed.
2094 --
2095 hr_utility.set_location('Exiting:'||l_proc, 30);
2096
2097 EXCEPTION
2098 WHEN OTHERS THEN
2099 hr_utility.set_location('Exception:Others'||l_proc,555);
2100 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2101 p_error_message => p_error_message);
2102
2103 hr_utility.trace(
2104 'hr_process_eit_ss.create_eit' ||
2105 ' l_error_message: '||p_error_message ||' '|| sqlerrm );
2106
2107 --
2108 -- A validation or unexpected error has occurred
2109 --
2110 --
2111 END update_eit;
2112
2113
2114 -- ----------------------------------------------------------------------------
2115 -- |----------------------------< delete_eit >------------------------------|
2116 -- ----------------------------------------------------------------------------
2117 procedure delete_eit
2118 (p_validate in number default 0
2119 ,p_login_person_id in number default null
2120 ,p_eit_type in varchar2
2121 ,p_eit_type_id in number
2122 ,p_person_id in number
2123 ,p_information_type in varchar2
2124 ,p_extra_info_id in number
2125 ,p_object_version_number in number
2126 -- EndRegistration
2127 ,p_item_type in varchar2
2128 ,p_item_key in varchar2
2129 ,p_activity_id in number
2130 ,p_action in varchar2
2131 ,p_old_extra_info_id in number default null
2132 ,p_old_object_version_number in number default null
2133 ,p_save_mode in varchar2 default null
2134 ,p_error_message out nocopy long
2135 ) IS
2136 --
2137 l_error_message long default null;
2138 l_proc varchar2(72) := g_package||'delete_sit';
2139 --
2140 BEGIN
2141 --
2142 hr_utility.set_location('Entering:'|| l_proc,10);
2143 --
2144 -- Call the actual API.
2145 --
2146 --
2147 -- if the extra info type is a PERSON
2148 --
2149 IF p_eit_type = 'PERSON' THEN
2150 hr_utility.trace('p_eit_type = PERSON'||l_proc);
2151 hr_person_extra_info_api.delete_person_extra_info
2152 (p_validate => hr_java_conv_util_ss.get_boolean (
2153 p_number => p_validate)
2154 ,p_person_extra_info_id => p_extra_info_id
2155 ,p_object_version_number => p_object_version_number
2156 );
2157 ELSIF p_eit_type = 'ASSIGNMENT' THEN
2158
2159 hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
2160 hr_assignment_extra_info_api.DELETE_ASSIGNMENT_EXTRA_INFO
2161 (p_validate => hr_java_conv_util_ss.get_boolean (
2162 p_number => p_validate)
2163 ,p_assignment_extra_info_id => p_extra_info_id
2164 ,p_object_version_number => p_object_version_number
2165 );
2166
2167 END IF;
2168
2169 hr_utility.set_location('Exiting:'||l_proc, 25);
2170
2171 EXCEPTION
2172 WHEN OTHERS THEN
2173 hr_utility.set_location('Exception:Others'||l_proc,555);
2174 p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2175 p_error_message => p_error_message);
2176 --
2177 -- A validation or unexpected error has occurred
2178 --
2179 --
2180 END delete_eit;
2181
2182
2183
2184 /******************************************************************************/
2185 /* this procedure dump the eit table information */
2186 /******************************************************************************/
2187
2188 PROCEDURE dump_eit_table (p_eit_table in HR_EIT_STRUCTURE_TABLE ) IS
2189
2190 l_index NUMBER;
2191 l_proc varchar2(72) := g_package||'dump_eit_table';
2192
2193 BEGIN
2194
2195
2196 hr_utility.set_location('Entering:'||l_proc, 5);
2197 l_index := p_eit_table.first;
2198 hr_utility.trace('Entering LOOP:'||l_proc);
2199 LOOP
2200 EXIT WHEN
2201 (NOT p_eit_table.exists(l_index));
2202
2203 if(hr_utility.debug_enabled) then
2204
2205 hr_utility.trace(
2206 'hr_process_eit_ss.dump_eit_table' ||
2207 ' l_index :'||l_index||
2208 ' Action :'||p_eit_table(l_index).action||
2209 ' extra_info_id: '||p_eit_table(l_index).extra_info_id||
2210 ' object_version_number :'||p_eit_table(l_index).object_version_number||
2211 ' information_type :'||p_eit_table(l_index).information_type||
2212 ' attribute_category :'||p_eit_table(l_index).attribute_category||
2213 ' ATT1:'||p_eit_table(l_index).attribute1||
2214 ' ATT2:'||p_eit_table(l_index).attribute2||
2215 ' ATT3:'||p_eit_table(l_index).attribute3||
2216 ' ATT4:'||p_eit_table(l_index).attribute4||
2217 ' ATT5:'||p_eit_table(l_index).attribute5||
2218 ' ATT6:'||p_eit_table(l_index).attribute6||
2219 ' ATT7:'||p_eit_table(l_index).attribute7||
2220 ' ATT8:'||p_eit_table(l_index).attribute8||
2221 ' ATT9:'||p_eit_table(l_index).attribute9||
2222 ' ATT10:'||p_eit_table(l_index).attribute10||
2223 ' ATT11:'||p_eit_table(l_index).attribute11||
2224 ' ATT12:'||p_eit_table(l_index).attribute12||
2225 ' ATT13:'||p_eit_table(l_index).attribute13||
2226 ' ATT14:'||p_eit_table(l_index).attribute14||
2227 ' ATT15:'||p_eit_table(l_index).attribute15||
2228 ' ATT16:'||p_eit_table(l_index).attribute16||
2229 ' ATT17:'||p_eit_table(l_index).attribute17||
2230 ' ATT18:'||p_eit_table(l_index).attribute18||
2231 ' ATT19:'||p_eit_table(l_index).attribute19||
2232 ' ATT20:'||p_eit_table(l_index).attribute20||
2233 ' information_category :'||p_eit_table(l_index).information_category||
2234 ' information1 :'||p_eit_table(l_index).information1||
2235 ' information2 :'||p_eit_table(l_index).information2||
2236 ' information3 :'||p_eit_table(l_index).information3||
2237 ' information4 :'||p_eit_table(l_index).information4||
2238 ' information5 :'||p_eit_table(l_index).information5||
2239 ' information6 :'||p_eit_table(l_index).information6||
2240 ' information7 :'||p_eit_table(l_index).information7||
2241 ' information8 :'||p_eit_table(l_index).information8||
2242 ' information9 :'||p_eit_table(l_index).information9||
2243 ' information10:'||p_eit_table(l_index).information10||
2244 ' information11:'||p_eit_table(l_index).information11||
2245 ' information12:'||p_eit_table(l_index).information12||
2246 ' information13:'||p_eit_table(l_index).information13||
2247 ' information14:'||p_eit_table(l_index).information14||
2248 ' information15:'||p_eit_table(l_index).information15||
2249 ' information16:'||p_eit_table(l_index).information16||
2250 ' information17:'||p_eit_table(l_index).information17||
2251 ' information18:'||p_eit_table(l_index).information18||
2252 ' information19:'||p_eit_table(l_index).information19||
2253 ' information20:'||p_eit_table(l_index).information20||
2254 ' information21:'||p_eit_table(l_index).information21||
2255 ' information22:'||p_eit_table(l_index).information22||
2256 ' information23:'||p_eit_table(l_index).information23||
2257 ' information24:'||p_eit_table(l_index).information24||
2258 ' information25:'||p_eit_table(l_index).information25||
2259 ' information26:'||p_eit_table(l_index).information26||
2260 ' information27:'||p_eit_table(l_index).information27||
2261 ' information28:'||p_eit_table(l_index).information28||
2262 ' information29:'||p_eit_table(l_index).information29||
2263 ' information30:'||p_eit_table(l_index).information30);
2264
2265 end if;
2266
2267 l_index := p_eit_table.next(l_index);
2268 END LOOP;
2269 hr_utility.trace('End of LOOP:'||l_proc );
2270 hr_utility.set_location('Exiting:'||l_proc, 20);
2271
2272 END dump_eit_table;
2273
2274
2275 end hr_process_eit_ss;