[Home] [Help]
PACKAGE BODY: APPS.HRDPP_CREATE_ELEMENT_ENTRY
Source
1 package body hrdpp_CREATE_ELEMENT_ENTRY as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2007/01/04 02:01:29
4 * Generated for API: PY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY
5 */
6 --
7 dh constant date := hr_api.g_date;
8 nh constant number := hr_api.g_number;
9 vh constant varchar2(64) := hr_api.g_varchar2;
10 c_sot constant date := to_date('01010001','DDMMYYYY');
11 cn constant varchar2(32) := '<NULL>';
12 dn constant date := null;
13 nn constant number := null;
14 vn constant varchar2(1) := null;
15 --
16 function dc(p in date) return varchar2 is
17 begin
18 if p<c_sot then
19 if p<>trunc(p) then
20 return to_char(p,'SYYYY/MM/DD HH24:MI:SS');
21 end if;
22 return to_char(p,'SYYYY/MM/DD');
23 elsif p<>trunc(p) then
24 return to_char(p,'YYYY/MM/DD HH24:MI:SS');
25 end if;
26 return to_char(p,'YYYY/MM/DD');
27 end dc;
28 function d(p in varchar2) return date is
29 begin
30 if length(p)=10 then
31 return to_date(p,'YYYY/MM/DD');
32 elsif length(p)=19 then
33 return to_date(p,'YYYY/MM/DD HH24:MI:SS');
34 elsif length(p)=11 then
35 return to_date(p,'SYYYY/MM/DD');
36 elsif length(p)=20 then
37 return to_date(p,'SYYYY/MM/DD HH24:MI:SS');
38 end if;
39 -- Try default format as last resort.
40 return to_date(p,'YYYY/MM/DD');
41 end d;
42 function n(p in varchar2) return number is
43 begin
44 return to_number(p);
45 end n;
46 function dd(p in date,i in varchar2)
47 return varchar2 is
48 begin
49 if upper(i) = 'N' then return dc(p);
50 else return cn; end if;
51 end dd;
52 function nd(p in number,i in varchar2)
53 return varchar2 is
54 begin
55 if upper(i) = 'N' then return to_char(p);
56 else return cn; end if;
57 end nd;
58 --
59 procedure iuk
60 (p_batch_line_id in number,
61 p_user_key_value in varchar2,
62 p_unique_key_id in number)
63 is
64 begin
65 hr_data_pump.entry('ins_user_key');
66 insert into hr_pump_batch_line_user_keys
67 (user_key_id, batch_line_id,user_key_value,unique_key_id)
68 values
69 (hr_pump_batch_line_user_keys_s.nextval,
70 p_batch_line_id,
71 p_user_key_value,
72 p_unique_key_id);
73 hr_data_pump.exit('ins_user_key');
74 end iuk;
75 --
76 procedure insert_batch_lines
77 (p_batch_id in number
78 ,p_data_pump_batch_line_id in number default null
79 ,p_data_pump_business_grp_name in varchar2 default null
80 ,p_user_sequence in number default null
81 ,p_link_value in number default null
82 ,P_EFFECTIVE_DATE in date
83 ,P_ENTRY_TYPE in varchar2
84 ,P_CREATOR_TYPE in varchar2 default null
85 ,P_UPDATING_ACTION_TYPE in varchar2 default null
86 ,P_REASON in varchar2 default null
87 ,P_SUBPRIORITY in number default null
88 ,P_DATE_EARNED in date default null
89 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
90 ,P_ATTRIBUTE1 in varchar2 default null
91 ,P_ATTRIBUTE2 in varchar2 default null
92 ,P_ATTRIBUTE3 in varchar2 default null
93 ,P_ATTRIBUTE4 in varchar2 default null
94 ,P_ATTRIBUTE5 in varchar2 default null
95 ,P_ATTRIBUTE6 in varchar2 default null
96 ,P_ATTRIBUTE7 in varchar2 default null
97 ,P_ATTRIBUTE8 in varchar2 default null
98 ,P_ATTRIBUTE9 in varchar2 default null
99 ,P_ATTRIBUTE10 in varchar2 default null
100 ,P_ATTRIBUTE11 in varchar2 default null
101 ,P_ATTRIBUTE12 in varchar2 default null
102 ,P_ATTRIBUTE13 in varchar2 default null
103 ,P_ATTRIBUTE14 in varchar2 default null
104 ,P_ATTRIBUTE15 in varchar2 default null
105 ,P_ATTRIBUTE16 in varchar2 default null
106 ,P_ATTRIBUTE17 in varchar2 default null
107 ,P_ATTRIBUTE18 in varchar2 default null
108 ,P_ATTRIBUTE19 in varchar2 default null
109 ,P_ATTRIBUTE20 in varchar2 default null
110 ,P_ENTRY_VALUE1 in varchar2 default null
111 ,P_ENTRY_VALUE2 in varchar2 default null
112 ,P_ENTRY_VALUE3 in varchar2 default null
113 ,P_ENTRY_VALUE4 in varchar2 default null
114 ,P_ENTRY_VALUE5 in varchar2 default null
115 ,P_ENTRY_VALUE6 in varchar2 default null
116 ,P_ENTRY_VALUE7 in varchar2 default null
117 ,P_ENTRY_VALUE8 in varchar2 default null
118 ,P_ENTRY_VALUE9 in varchar2 default null
119 ,P_ENTRY_VALUE10 in varchar2 default null
120 ,P_ENTRY_VALUE11 in varchar2 default null
121 ,P_ENTRY_VALUE12 in varchar2 default null
122 ,P_ENTRY_VALUE13 in varchar2 default null
123 ,P_ENTRY_VALUE14 in varchar2 default null
124 ,P_ENTRY_VALUE15 in varchar2 default null
125 ,P_ENTRY_INFORMATION_CATEGORY in varchar2 default null
126 ,P_ENTRY_INFORMATION1 in varchar2 default null
127 ,P_ENTRY_INFORMATION2 in varchar2 default null
128 ,P_ENTRY_INFORMATION3 in varchar2 default null
129 ,P_ENTRY_INFORMATION4 in varchar2 default null
130 ,P_ENTRY_INFORMATION5 in varchar2 default null
131 ,P_ENTRY_INFORMATION6 in varchar2 default null
132 ,P_ENTRY_INFORMATION7 in varchar2 default null
133 ,P_ENTRY_INFORMATION8 in varchar2 default null
134 ,P_ENTRY_INFORMATION9 in varchar2 default null
135 ,P_ENTRY_INFORMATION10 in varchar2 default null
136 ,P_ENTRY_INFORMATION11 in varchar2 default null
137 ,P_ENTRY_INFORMATION12 in varchar2 default null
138 ,P_ENTRY_INFORMATION13 in varchar2 default null
139 ,P_ENTRY_INFORMATION14 in varchar2 default null
140 ,P_ENTRY_INFORMATION15 in varchar2 default null
141 ,P_ENTRY_INFORMATION16 in varchar2 default null
142 ,P_ENTRY_INFORMATION17 in varchar2 default null
143 ,P_ENTRY_INFORMATION18 in varchar2 default null
144 ,P_ENTRY_INFORMATION19 in varchar2 default null
145 ,P_ENTRY_INFORMATION20 in varchar2 default null
146 ,P_ENTRY_INFORMATION21 in varchar2 default null
147 ,P_ENTRY_INFORMATION22 in varchar2 default null
148 ,P_ENTRY_INFORMATION23 in varchar2 default null
149 ,P_ENTRY_INFORMATION24 in varchar2 default null
150 ,P_ENTRY_INFORMATION25 in varchar2 default null
151 ,P_ENTRY_INFORMATION26 in varchar2 default null
152 ,P_ENTRY_INFORMATION27 in varchar2 default null
153 ,P_ENTRY_INFORMATION28 in varchar2 default null
154 ,P_ENTRY_INFORMATION29 in varchar2 default null
155 ,P_ENTRY_INFORMATION30 in varchar2 default null
156 ,P_OVERRIDE_USER_ENT_CHK in varchar2 default null
157 ,P_ELEMENT_ENTRY_USER_KEY in varchar2
158 ,P_ORIGINAL_ENTRY_USER_KEY in varchar2 default null
159 ,P_ASSIGNMENT_USER_KEY in varchar2
160 ,P_ELEMENT_LINK_USER_KEY in varchar2
161 ,P_COST_ALLOC_KEYFLEX_USER_KEY in varchar2 default null
162 ,P_UPDATING_ACTION_USER_KEY in varchar2 default null
163 ,P_COMMENT_USER_KEY in varchar2 default null
164 ,P_TARGET_ENTRY_USER_KEY in varchar2 default null
165 ,P_PERSONAL_PAY_METHOD_USER_KEY in varchar2 default null
166 ,P_INPUT_VALUE_NAME1 in varchar2 default null
167 ,P_ELEMENT_NAME in varchar2 default null
168 ,P_LANGUAGE_CODE in varchar2 default null
169 ,P_INPUT_VALUE_NAME2 in varchar2 default null
170 ,P_INPUT_VALUE_NAME3 in varchar2 default null
171 ,P_INPUT_VALUE_NAME4 in varchar2 default null
172 ,P_INPUT_VALUE_NAME5 in varchar2 default null
173 ,P_INPUT_VALUE_NAME6 in varchar2 default null
174 ,P_INPUT_VALUE_NAME7 in varchar2 default null
175 ,P_INPUT_VALUE_NAME8 in varchar2 default null
176 ,P_INPUT_VALUE_NAME9 in varchar2 default null
177 ,P_INPUT_VALUE_NAME10 in varchar2 default null
178 ,P_INPUT_VALUE_NAME11 in varchar2 default null
179 ,P_INPUT_VALUE_NAME12 in varchar2 default null
180 ,P_INPUT_VALUE_NAME13 in varchar2 default null
181 ,P_INPUT_VALUE_NAME14 in varchar2 default null
182 ,P_INPUT_VALUE_NAME15 in varchar2 default null) is
183 blid number := p_data_pump_batch_line_id;
184 begin
185 if blid is not null then
186 delete from hr_pump_batch_lines where batch_line_id = blid;
187 delete from hr_pump_batch_exceptions
188 where source_type = 'BATCH_LINE' and source_id = blid;
189 end if;
190 insert into hr_pump_batch_lines
191 (batch_id
192 ,batch_line_id
193 ,business_group_name
194 ,api_module_id
195 ,line_status
196 ,user_sequence
197 ,link_value
198 ,pval001
199 ,pval002
200 ,pval003
201 ,pval004
202 ,pval005
203 ,pval006
204 ,pval007
205 ,pval008
206 ,pval009
207 ,pval010
208 ,pval011
209 ,pval012
210 ,pval013
211 ,pval014
212 ,pval015
213 ,pval016
214 ,pval017
215 ,pval018
216 ,pval019
217 ,pval020
218 ,pval021
219 ,pval022
220 ,pval023
221 ,pval024
222 ,pval025
223 ,pval026
224 ,pval027
225 ,pval028
226 ,pval029
227 ,pval030
228 ,pval031
229 ,pval032
230 ,pval033
231 ,pval034
232 ,pval035
233 ,pval036
234 ,pval037
235 ,pval038
236 ,pval039
237 ,pval040
238 ,pval041
239 ,pval042
240 ,pval043
241 ,pval044
242 ,pval045
243 ,pval046
244 ,pval047
245 ,pval048
246 ,pval049
247 ,pval050
248 ,pval051
249 ,pval052
250 ,pval053
251 ,pval054
252 ,pval055
253 ,pval056
254 ,pval057
255 ,pval058
256 ,pval059
257 ,pval060
258 ,pval061
259 ,pval062
260 ,pval063
261 ,pval064
262 ,pval065
263 ,pval066
264 ,pval067
265 ,pval068
266 ,pval069
267 ,pval070
268 ,pval071
269 ,pval072
270 ,pval073
271 ,pval074
272 ,pval075
273 ,pval078
274 ,pval081
275 ,pval082
276 ,pval083
277 ,pval084
278 ,pval085
279 ,pval086
280 ,pval087
281 ,pval088
282 ,pval089
283 ,pval090
284 ,pval091
285 ,pval092
286 ,pval093
287 ,pval094
288 ,pval095
289 ,pval096
290 ,pval097
291 ,pval098
292 ,pval099
293 ,pval100
294 ,pval101
295 ,pval102
296 ,pval103
297 ,pval104
298 ,pval105)
299 values
300 (p_batch_id
301 ,nvl(blid,hr_pump_batch_lines_s.nextval)
302 ,p_data_pump_business_grp_name
303 ,1382
304 ,'U'
305 ,p_user_sequence
306 ,p_link_value
307 ,dc(P_EFFECTIVE_DATE)
308 ,P_ENTRY_TYPE
309 ,P_CREATOR_TYPE
310 ,P_UPDATING_ACTION_TYPE
311 ,P_REASON
312 ,P_SUBPRIORITY
313 ,dc(P_DATE_EARNED)
314 ,P_ATTRIBUTE_CATEGORY
315 ,P_ATTRIBUTE1
316 ,P_ATTRIBUTE2
317 ,P_ATTRIBUTE3
318 ,P_ATTRIBUTE4
319 ,P_ATTRIBUTE5
320 ,P_ATTRIBUTE6
321 ,P_ATTRIBUTE7
322 ,P_ATTRIBUTE8
323 ,P_ATTRIBUTE9
324 ,P_ATTRIBUTE10
325 ,P_ATTRIBUTE11
326 ,P_ATTRIBUTE12
327 ,P_ATTRIBUTE13
328 ,P_ATTRIBUTE14
329 ,P_ATTRIBUTE15
330 ,P_ATTRIBUTE16
331 ,P_ATTRIBUTE17
332 ,P_ATTRIBUTE18
333 ,P_ATTRIBUTE19
334 ,P_ATTRIBUTE20
335 ,P_ENTRY_VALUE1
336 ,P_ENTRY_VALUE2
337 ,P_ENTRY_VALUE3
338 ,P_ENTRY_VALUE4
339 ,P_ENTRY_VALUE5
340 ,P_ENTRY_VALUE6
341 ,P_ENTRY_VALUE7
342 ,P_ENTRY_VALUE8
343 ,P_ENTRY_VALUE9
344 ,P_ENTRY_VALUE10
345 ,P_ENTRY_VALUE11
346 ,P_ENTRY_VALUE12
347 ,P_ENTRY_VALUE13
348 ,P_ENTRY_VALUE14
349 ,P_ENTRY_VALUE15
350 ,P_ENTRY_INFORMATION_CATEGORY
351 ,P_ENTRY_INFORMATION1
352 ,P_ENTRY_INFORMATION2
353 ,P_ENTRY_INFORMATION3
354 ,P_ENTRY_INFORMATION4
355 ,P_ENTRY_INFORMATION5
356 ,P_ENTRY_INFORMATION6
357 ,P_ENTRY_INFORMATION7
358 ,P_ENTRY_INFORMATION8
359 ,P_ENTRY_INFORMATION9
360 ,P_ENTRY_INFORMATION10
361 ,P_ENTRY_INFORMATION11
362 ,P_ENTRY_INFORMATION12
363 ,P_ENTRY_INFORMATION13
364 ,P_ENTRY_INFORMATION14
365 ,P_ENTRY_INFORMATION15
366 ,P_ENTRY_INFORMATION16
367 ,P_ENTRY_INFORMATION17
368 ,P_ENTRY_INFORMATION18
369 ,P_ENTRY_INFORMATION19
370 ,P_ENTRY_INFORMATION20
371 ,P_ENTRY_INFORMATION21
372 ,P_ENTRY_INFORMATION22
373 ,P_ENTRY_INFORMATION23
374 ,P_ENTRY_INFORMATION24
375 ,P_ENTRY_INFORMATION25
376 ,P_ENTRY_INFORMATION26
377 ,P_ENTRY_INFORMATION27
378 ,P_ENTRY_INFORMATION28
379 ,P_ENTRY_INFORMATION29
380 ,P_ENTRY_INFORMATION30
381 ,P_OVERRIDE_USER_ENT_CHK
382 ,P_ELEMENT_ENTRY_USER_KEY
383 ,P_ORIGINAL_ENTRY_USER_KEY
384 ,P_ASSIGNMENT_USER_KEY
385 ,P_ELEMENT_LINK_USER_KEY
386 ,P_COST_ALLOC_KEYFLEX_USER_KEY
387 ,P_UPDATING_ACTION_USER_KEY
388 ,P_COMMENT_USER_KEY
389 ,P_TARGET_ENTRY_USER_KEY
390 ,P_PERSONAL_PAY_METHOD_USER_KEY
391 ,P_INPUT_VALUE_NAME1
392 ,P_ELEMENT_NAME
393 ,P_LANGUAGE_CODE
394 ,P_INPUT_VALUE_NAME2
395 ,P_INPUT_VALUE_NAME3
396 ,P_INPUT_VALUE_NAME4
397 ,P_INPUT_VALUE_NAME5
398 ,P_INPUT_VALUE_NAME6
399 ,P_INPUT_VALUE_NAME7
403 ,P_INPUT_VALUE_NAME11
400 ,P_INPUT_VALUE_NAME8
401 ,P_INPUT_VALUE_NAME9
402 ,P_INPUT_VALUE_NAME10
404 ,P_INPUT_VALUE_NAME12
405 ,P_INPUT_VALUE_NAME13
406 ,P_INPUT_VALUE_NAME14
407 ,P_INPUT_VALUE_NAME15);
408 end insert_batch_lines;
409 --
410 procedure call
411 (p_business_group_id in number,
412 p_batch_line_id in number) is
413 cursor cr is
414 select l.rowid myrowid,
415 decode(l.pval001,cn,dn,d(l.pval001)) p1,
416 decode(l.pval002,cn,vn,
417 hr_pump_get.gl(l.pval002,'ENTRY_TYPE',d(l.pval001),l.pval091)) p2,
418 decode(l.pval003,cn,vn,vn,'F',l.pval003) p3,
419 l.pval003 d3,
420 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
421 l.pval004 d4,
422 decode(l.pval005,cn,vn,vn,vn,
423 hr_pump_get.gl(l.pval005,'ELE_ENTRY_REASON',d(l.pval001),l.pval091)) p5,
424 l.pval005 d5,
425 decode(l.pval006,cn,nn,vn,nn,n(l.pval006)) p6,
426 l.pval006 d6,
427 decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,
428 l.pval007 d7,
429 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
430 l.pval008 d8,
431 decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
432 l.pval009 d9,
433 decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
434 l.pval010 d10,
435 decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
436 l.pval011 d11,
437 decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
438 l.pval012 d12,
439 decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
440 l.pval013 d13,
441 decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
442 l.pval014 d14,
443 decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
444 l.pval015 d15,
445 decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
446 l.pval016 d16,
447 decode(l.pval017,cn,vn,vn,vn,l.pval017) p17,
448 l.pval017 d17,
449 decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
450 l.pval018 d18,
451 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
452 l.pval019 d19,
453 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
454 l.pval020 d20,
455 decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
456 l.pval021 d21,
457 decode(l.pval022,cn,vn,vn,vn,l.pval022) p22,
458 l.pval022 d22,
459 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
460 l.pval023 d23,
461 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
462 l.pval024 d24,
463 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
464 l.pval025 d25,
465 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
466 l.pval026 d26,
467 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
468 l.pval027 d27,
469 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
470 l.pval028 d28,
471 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
472 l.pval029 d29,
473 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
474 l.pval030 d30,
475 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
476 l.pval031 d31,
477 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
478 l.pval032 d32,
479 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
480 l.pval033 d33,
481 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
482 l.pval034 d34,
483 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
484 l.pval035 d35,
485 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
486 l.pval036 d36,
487 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
488 l.pval037 d37,
489 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
490 l.pval038 d38,
491 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
492 l.pval039 d39,
493 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
494 l.pval040 d40,
495 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
496 l.pval041 d41,
497 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
498 l.pval042 d42,
499 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
500 l.pval043 d43,
501 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
502 l.pval044 d44,
503 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
504 l.pval045 d45,
505 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
506 l.pval046 d46,
507 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
508 l.pval047 d47,
509 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
510 l.pval048 d48,
511 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
512 l.pval049 d49,
513 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
514 l.pval050 d50,
515 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
516 l.pval051 d51,
517 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
518 l.pval052 d52,
519 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
520 l.pval053 d53,
521 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
522 l.pval054 d54,
523 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
524 l.pval055 d55,
525 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
526 l.pval056 d56,
527 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
528 l.pval057 d57,
529 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
530 l.pval058 d58,
531 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
532 l.pval059 d59,
533 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
534 l.pval060 d60,
535 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
536 l.pval061 d61,
537 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
538 l.pval062 d62,
539 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
540 l.pval063 d63,
541 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
542 l.pval064 d64,
543 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
544 l.pval065 d65,
545 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
546 l.pval066 d66,
547 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
548 l.pval067 d67,
549 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
550 l.pval068 d68,
551 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
555 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
552 l.pval069 d69,
553 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
554 l.pval070 d70,
556 l.pval071 d71,
557 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
558 l.pval072 d72,
559 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
560 l.pval073 d73,
561 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
562 l.pval074 d74,
563 decode(l.pval075,cn,vn,vn,'N',l.pval075) p75,
564 l.pval075 d75,
565 decode(l.pval076,cn,dn,d(l.pval076)) p76,
566 decode(l.pval077,cn,dn,d(l.pval077)) p77,
567 l.pval078 p78,
568 l.pval079 p79,
569 l.pval080 p80,
570 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
571 l.pval081 d81,
572 decode(l.pval082,cn,vn,l.pval082) p82,
573 decode(l.pval083,cn,vn,l.pval083) p83,
574 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
575 l.pval084 d84,
576 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
577 l.pval085 d85,
578 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
579 l.pval086 d86,
580 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
581 l.pval087 d87,
582 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
583 l.pval088 d88,
584 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
585 l.pval089 d89,
586 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
587 l.pval090 d90,
588 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
589 l.pval091 d91,
590 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
591 l.pval092 d92,
592 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
593 l.pval093 d93,
594 decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
595 l.pval094 d94,
596 decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
597 l.pval095 d95,
598 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
599 l.pval096 d96,
600 decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
601 l.pval097 d97,
602 decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
603 l.pval098 d98,
604 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
605 l.pval099 d99,
606 decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
607 l.pval100 d100,
608 decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
609 l.pval101 d101,
610 decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
611 l.pval102 d102,
612 decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
613 l.pval103 d103,
614 decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
615 l.pval104 d104,
616 decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
617 l.pval105 d105
618 from hr_pump_batch_lines l
619 where l.batch_line_id = p_batch_line_id;
620 --
621 c cr%rowtype;
622 l_validate boolean := false;
623 L_ELEMENT_ENTRY_ID number;
624 L_CREATE_WARNING boolean;
625 L_ORIGINAL_ENTRY_ID number;
626 L_ASSIGNMENT_ID number;
627 L_ELEMENT_LINK_ID number;
628 L_COST_ALLOCATION_KEYFLEX_ID number;
629 L_UPDATING_ACTION_ID number;
630 L_COMMENT_ID number;
631 L_TARGET_ENTRY_ID number;
632 L_PERSONAL_PAYMENT_METHOD_ID number;
633 L_INPUT_VALUE_ID1 number;
634 L_INPUT_VALUE_ID2 number;
635 L_INPUT_VALUE_ID3 number;
636 L_INPUT_VALUE_ID4 number;
637 L_INPUT_VALUE_ID5 number;
638 L_INPUT_VALUE_ID6 number;
639 L_INPUT_VALUE_ID7 number;
640 L_INPUT_VALUE_ID8 number;
641 L_INPUT_VALUE_ID9 number;
642 L_INPUT_VALUE_ID10 number;
643 L_INPUT_VALUE_ID11 number;
644 L_INPUT_VALUE_ID12 number;
645 L_INPUT_VALUE_ID13 number;
646 L_INPUT_VALUE_ID14 number;
647 L_INPUT_VALUE_ID15 number;
648 --
649 begin
650 hr_data_pump.entry('call');
651 open cr;
652 fetch cr into c;
653 if cr%notfound then
654 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
655 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
656 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
657 hr_utility.set_message_token('VALUE',p_batch_line_id);
658 hr_utility.raise_error;
659 end if;
660 --
661 if c.p81 is null then
662 L_ORIGINAL_ENTRY_ID:=nn;
663 else
664 L_ORIGINAL_ENTRY_ID :=
665 hr_pump_get.get_original_entry_id
666 (P_ORIGINAL_ENTRY_USER_KEY => c.p81);
667 end if;
668 --
669 if c.p82 is null then
670 L_ASSIGNMENT_ID:=nn;
671 else
672 L_ASSIGNMENT_ID :=
673 hr_pump_get.get_assignment_id
674 (P_ASSIGNMENT_USER_KEY => c.p82);
675 end if;
676 --
677 if c.p83 is null then
678 L_ELEMENT_LINK_ID:=nn;
679 else
680 L_ELEMENT_LINK_ID :=
681 hr_pump_get.get_element_link_id
682 (P_ELEMENT_LINK_USER_KEY => c.p83);
683 end if;
684 --
685 if c.p84 is null then
686 L_COST_ALLOCATION_KEYFLEX_ID:=nn;
687 else
688 L_COST_ALLOCATION_KEYFLEX_ID :=
689 hr_pump_get.get_cost_allocation_keyflex_id
690 (P_COST_ALLOC_KEYFLEX_USER_KEY => c.p84);
691 end if;
692 --
693 if c.p85 is null then
694 L_UPDATING_ACTION_ID:=nn;
695 else
696 L_UPDATING_ACTION_ID :=
697 hr_pump_get.get_updating_action_id
698 (P_UPDATING_ACTION_USER_KEY => c.p85);
699 end if;
700 --
701 if c.p86 is null then
702 L_COMMENT_ID:=nn;
703 else
704 L_COMMENT_ID :=
705 hr_pump_get.get_comment_id
706 (P_COMMENT_USER_KEY => c.p86);
707 end if;
708 --
709 if c.p87 is null then
710 L_TARGET_ENTRY_ID:=nn;
711 else
712 L_TARGET_ENTRY_ID :=
713 hr_pump_get.get_target_entry_id
714 (P_TARGET_ENTRY_USER_KEY => c.p87);
715 end if;
716 --
717 if c.p88 is null then
718 L_PERSONAL_PAYMENT_METHOD_ID:=nn;
719 else
720 L_PERSONAL_PAYMENT_METHOD_ID :=
721 hr_pump_get.get_personal_payment_method_id
722 (P_PERSONAL_PAY_METHOD_USER_KEY => c.p88);
723 end if;
724 --
725 if c.p89 is null or
726 c.p90 is null or
727 c.p1 is null or
728 c.p91 is null then
729 L_INPUT_VALUE_ID1:=nn;
730 else
731 L_INPUT_VALUE_ID1 :=
732 hr_pump_get.GET_INPUT_VALUE_ID1
733 (P_INPUT_VALUE_NAME1 => c.p89
734 ,P_ELEMENT_NAME => c.p90
735 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
736 ,P_EFFECTIVE_DATE => c.p1
737 ,P_LANGUAGE_CODE => c.p91);
738 end if;
739 --
740 if c.p92 is null or
741 c.p90 is null or
742 c.p1 is null or
743 c.p91 is null then
744 L_INPUT_VALUE_ID2:=nn;
745 else
746 L_INPUT_VALUE_ID2 :=
747 hr_pump_get.GET_INPUT_VALUE_ID2
748 (P_INPUT_VALUE_NAME2 => c.p92
749 ,P_ELEMENT_NAME => c.p90
750 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
751 ,P_EFFECTIVE_DATE => c.p1
752 ,P_LANGUAGE_CODE => c.p91);
753 end if;
754 --
755 if c.p93 is null or
756 c.p90 is null or
757 c.p1 is null or
758 c.p91 is null then
759 L_INPUT_VALUE_ID3:=nn;
760 else
761 L_INPUT_VALUE_ID3 :=
762 hr_pump_get.GET_INPUT_VALUE_ID3
763 (P_INPUT_VALUE_NAME3 => c.p93
764 ,P_ELEMENT_NAME => c.p90
765 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
766 ,P_EFFECTIVE_DATE => c.p1
767 ,P_LANGUAGE_CODE => c.p91);
768 end if;
769 --
770 if c.p94 is null or
771 c.p90 is null or
772 c.p1 is null or
773 c.p91 is null then
774 L_INPUT_VALUE_ID4:=nn;
775 else
776 L_INPUT_VALUE_ID4 :=
777 hr_pump_get.GET_INPUT_VALUE_ID4
778 (P_INPUT_VALUE_NAME4 => c.p94
779 ,P_ELEMENT_NAME => c.p90
780 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
781 ,P_EFFECTIVE_DATE => c.p1
782 ,P_LANGUAGE_CODE => c.p91);
783 end if;
784 --
785 if c.p95 is null or
786 c.p90 is null or
787 c.p1 is null or
788 c.p91 is null then
789 L_INPUT_VALUE_ID5:=nn;
790 else
791 L_INPUT_VALUE_ID5 :=
792 hr_pump_get.GET_INPUT_VALUE_ID5
793 (P_INPUT_VALUE_NAME5 => c.p95
794 ,P_ELEMENT_NAME => c.p90
795 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
796 ,P_EFFECTIVE_DATE => c.p1
797 ,P_LANGUAGE_CODE => c.p91);
798 end if;
799 --
800 if c.p96 is null or
801 c.p90 is null or
802 c.p1 is null or
803 c.p91 is null then
804 L_INPUT_VALUE_ID6:=nn;
805 else
806 L_INPUT_VALUE_ID6 :=
807 hr_pump_get.GET_INPUT_VALUE_ID6
808 (P_INPUT_VALUE_NAME6 => c.p96
809 ,P_ELEMENT_NAME => c.p90
810 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
811 ,P_EFFECTIVE_DATE => c.p1
812 ,P_LANGUAGE_CODE => c.p91);
813 end if;
814 --
815 if c.p97 is null or
816 c.p90 is null or
817 c.p1 is null or
818 c.p91 is null then
819 L_INPUT_VALUE_ID7:=nn;
820 else
821 L_INPUT_VALUE_ID7 :=
822 hr_pump_get.GET_INPUT_VALUE_ID7
823 (P_INPUT_VALUE_NAME7 => c.p97
824 ,P_ELEMENT_NAME => c.p90
825 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
826 ,P_EFFECTIVE_DATE => c.p1
827 ,P_LANGUAGE_CODE => c.p91);
828 end if;
829 --
830 if c.p98 is null or
831 c.p90 is null or
832 c.p1 is null or
833 c.p91 is null then
834 L_INPUT_VALUE_ID8:=nn;
835 else
836 L_INPUT_VALUE_ID8 :=
837 hr_pump_get.GET_INPUT_VALUE_ID8
838 (P_INPUT_VALUE_NAME8 => c.p98
839 ,P_ELEMENT_NAME => c.p90
840 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
841 ,P_EFFECTIVE_DATE => c.p1
842 ,P_LANGUAGE_CODE => c.p91);
843 end if;
844 --
845 if c.p99 is null or
846 c.p90 is null or
847 c.p1 is null or
848 c.p91 is null then
849 L_INPUT_VALUE_ID9:=nn;
850 else
851 L_INPUT_VALUE_ID9 :=
852 hr_pump_get.GET_INPUT_VALUE_ID9
853 (P_INPUT_VALUE_NAME9 => c.p99
854 ,P_ELEMENT_NAME => c.p90
855 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
856 ,P_EFFECTIVE_DATE => c.p1
857 ,P_LANGUAGE_CODE => c.p91);
858 end if;
859 --
860 if c.p100 is null or
861 c.p90 is null or
862 c.p1 is null or
863 c.p91 is null then
864 L_INPUT_VALUE_ID10:=nn;
865 else
866 L_INPUT_VALUE_ID10 :=
867 hr_pump_get.GET_INPUT_VALUE_ID10
868 (P_INPUT_VALUE_NAME10 => c.p100
869 ,P_ELEMENT_NAME => c.p90
870 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
871 ,P_EFFECTIVE_DATE => c.p1
872 ,P_LANGUAGE_CODE => c.p91);
873 end if;
874 --
875 if c.p101 is null or
876 c.p90 is null or
877 c.p1 is null or
878 c.p91 is null then
879 L_INPUT_VALUE_ID11:=nn;
880 else
881 L_INPUT_VALUE_ID11 :=
882 hr_pump_get.GET_INPUT_VALUE_ID11
883 (P_INPUT_VALUE_NAME11 => c.p101
884 ,P_ELEMENT_NAME => c.p90
885 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
886 ,P_EFFECTIVE_DATE => c.p1
890 if c.p102 is null or
887 ,P_LANGUAGE_CODE => c.p91);
888 end if;
889 --
891 c.p90 is null or
892 c.p1 is null or
893 c.p91 is null then
894 L_INPUT_VALUE_ID12:=nn;
895 else
896 L_INPUT_VALUE_ID12 :=
897 hr_pump_get.GET_INPUT_VALUE_ID12
898 (P_INPUT_VALUE_NAME12 => c.p102
899 ,P_ELEMENT_NAME => c.p90
900 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
901 ,P_EFFECTIVE_DATE => c.p1
902 ,P_LANGUAGE_CODE => c.p91);
903 end if;
904 --
905 if c.p103 is null or
906 c.p90 is null or
907 c.p1 is null or
908 c.p91 is null then
909 L_INPUT_VALUE_ID13:=nn;
910 else
911 L_INPUT_VALUE_ID13 :=
912 hr_pump_get.GET_INPUT_VALUE_ID13
913 (P_INPUT_VALUE_NAME13 => c.p103
914 ,P_ELEMENT_NAME => c.p90
915 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
916 ,P_EFFECTIVE_DATE => c.p1
917 ,P_LANGUAGE_CODE => c.p91);
918 end if;
919 --
920 if c.p104 is null or
921 c.p90 is null or
922 c.p1 is null or
923 c.p91 is null then
924 L_INPUT_VALUE_ID14:=nn;
925 else
926 L_INPUT_VALUE_ID14 :=
927 hr_pump_get.GET_INPUT_VALUE_ID14
928 (P_INPUT_VALUE_NAME14 => c.p104
929 ,P_ELEMENT_NAME => c.p90
930 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
931 ,P_EFFECTIVE_DATE => c.p1
932 ,P_LANGUAGE_CODE => c.p91);
933 end if;
934 --
935 if c.p105 is null or
936 c.p90 is null or
937 c.p1 is null or
938 c.p91 is null then
939 L_INPUT_VALUE_ID15:=nn;
940 else
941 L_INPUT_VALUE_ID15 :=
942 hr_pump_get.GET_INPUT_VALUE_ID15
943 (P_INPUT_VALUE_NAME15 => c.p105
944 ,P_ELEMENT_NAME => c.p90
945 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
946 ,P_EFFECTIVE_DATE => c.p1
947 ,P_LANGUAGE_CODE => c.p91);
948 end if;
949 --
950 hr_data_pump.api_trc_on;
951 PY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY
952 (p_validate => l_validate
953 ,P_EFFECTIVE_DATE => c.p1
954 ,p_business_group_id => p_business_group_id
955 ,P_ORIGINAL_ENTRY_ID => L_ORIGINAL_ENTRY_ID
956 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
957 ,P_ELEMENT_LINK_ID => L_ELEMENT_LINK_ID
958 ,P_ENTRY_TYPE => c.p2
959 ,P_CREATOR_TYPE => c.p3
960 ,P_COST_ALLOCATION_KEYFLEX_ID => L_COST_ALLOCATION_KEYFLEX_ID
961 ,P_UPDATING_ACTION_ID => L_UPDATING_ACTION_ID
962 ,P_UPDATING_ACTION_TYPE => c.p4
963 ,P_COMMENT_ID => L_COMMENT_ID
964 ,P_REASON => c.p5
965 ,P_TARGET_ENTRY_ID => L_TARGET_ENTRY_ID
966 ,P_SUBPRIORITY => c.p6
967 ,P_DATE_EARNED => c.p7
968 ,P_PERSONAL_PAYMENT_METHOD_ID => L_PERSONAL_PAYMENT_METHOD_ID
969 ,P_ATTRIBUTE_CATEGORY => c.p8
970 ,P_ATTRIBUTE1 => c.p9
971 ,P_ATTRIBUTE2 => c.p10
972 ,P_ATTRIBUTE3 => c.p11
973 ,P_ATTRIBUTE4 => c.p12
974 ,P_ATTRIBUTE5 => c.p13
975 ,P_ATTRIBUTE6 => c.p14
976 ,P_ATTRIBUTE7 => c.p15
977 ,P_ATTRIBUTE8 => c.p16
978 ,P_ATTRIBUTE9 => c.p17
979 ,P_ATTRIBUTE10 => c.p18
980 ,P_ATTRIBUTE11 => c.p19
981 ,P_ATTRIBUTE12 => c.p20
982 ,P_ATTRIBUTE13 => c.p21
983 ,P_ATTRIBUTE14 => c.p22
984 ,P_ATTRIBUTE15 => c.p23
985 ,P_ATTRIBUTE16 => c.p24
986 ,P_ATTRIBUTE17 => c.p25
987 ,P_ATTRIBUTE18 => c.p26
988 ,P_ATTRIBUTE19 => c.p27
989 ,P_ATTRIBUTE20 => c.p28
990 ,P_INPUT_VALUE_ID1 => L_INPUT_VALUE_ID1
991 ,P_INPUT_VALUE_ID2 => L_INPUT_VALUE_ID2
992 ,P_INPUT_VALUE_ID3 => L_INPUT_VALUE_ID3
993 ,P_INPUT_VALUE_ID4 => L_INPUT_VALUE_ID4
994 ,P_INPUT_VALUE_ID5 => L_INPUT_VALUE_ID5
995 ,P_INPUT_VALUE_ID6 => L_INPUT_VALUE_ID6
996 ,P_INPUT_VALUE_ID7 => L_INPUT_VALUE_ID7
997 ,P_INPUT_VALUE_ID8 => L_INPUT_VALUE_ID8
998 ,P_INPUT_VALUE_ID9 => L_INPUT_VALUE_ID9
999 ,P_INPUT_VALUE_ID10 => L_INPUT_VALUE_ID10
1000 ,P_INPUT_VALUE_ID11 => L_INPUT_VALUE_ID11
1001 ,P_INPUT_VALUE_ID12 => L_INPUT_VALUE_ID12
1002 ,P_INPUT_VALUE_ID13 => L_INPUT_VALUE_ID13
1003 ,P_INPUT_VALUE_ID14 => L_INPUT_VALUE_ID14
1004 ,P_INPUT_VALUE_ID15 => L_INPUT_VALUE_ID15
1005 ,P_ENTRY_VALUE1 => c.p29
1006 ,P_ENTRY_VALUE2 => c.p30
1007 ,P_ENTRY_VALUE3 => c.p31
1008 ,P_ENTRY_VALUE4 => c.p32
1009 ,P_ENTRY_VALUE5 => c.p33
1010 ,P_ENTRY_VALUE6 => c.p34
1011 ,P_ENTRY_VALUE7 => c.p35
1012 ,P_ENTRY_VALUE8 => c.p36
1013 ,P_ENTRY_VALUE9 => c.p37
1014 ,P_ENTRY_VALUE10 => c.p38
1015 ,P_ENTRY_VALUE11 => c.p39
1016 ,P_ENTRY_VALUE12 => c.p40
1017 ,P_ENTRY_VALUE13 => c.p41
1018 ,P_ENTRY_VALUE14 => c.p42
1019 ,P_ENTRY_VALUE15 => c.p43
1020 ,P_ENTRY_INFORMATION_CATEGORY => c.p44
1021 ,P_ENTRY_INFORMATION1 => c.p45
1022 ,P_ENTRY_INFORMATION2 => c.p46
1023 ,P_ENTRY_INFORMATION3 => c.p47
1024 ,P_ENTRY_INFORMATION4 => c.p48
1025 ,P_ENTRY_INFORMATION5 => c.p49
1026 ,P_ENTRY_INFORMATION6 => c.p50
1027 ,P_ENTRY_INFORMATION7 => c.p51
1028 ,P_ENTRY_INFORMATION8 => c.p52
1029 ,P_ENTRY_INFORMATION9 => c.p53
1030 ,P_ENTRY_INFORMATION10 => c.p54
1031 ,P_ENTRY_INFORMATION11 => c.p55
1032 ,P_ENTRY_INFORMATION12 => c.p56
1033 ,P_ENTRY_INFORMATION13 => c.p57
1034 ,P_ENTRY_INFORMATION14 => c.p58
1035 ,P_ENTRY_INFORMATION15 => c.p59
1036 ,P_ENTRY_INFORMATION16 => c.p60
1037 ,P_ENTRY_INFORMATION17 => c.p61
1038 ,P_ENTRY_INFORMATION18 => c.p62
1039 ,P_ENTRY_INFORMATION19 => c.p63
1040 ,P_ENTRY_INFORMATION20 => c.p64
1041 ,P_ENTRY_INFORMATION21 => c.p65
1042 ,P_ENTRY_INFORMATION22 => c.p66
1043 ,P_ENTRY_INFORMATION23 => c.p67
1044 ,P_ENTRY_INFORMATION24 => c.p68
1045 ,P_ENTRY_INFORMATION25 => c.p69
1046 ,P_ENTRY_INFORMATION26 => c.p70
1047 ,P_ENTRY_INFORMATION27 => c.p71
1048 ,P_ENTRY_INFORMATION28 => c.p72
1049 ,P_ENTRY_INFORMATION29 => c.p73
1050 ,P_ENTRY_INFORMATION30 => c.p74
1051 ,P_OVERRIDE_USER_ENT_CHK => c.p75
1052 ,P_EFFECTIVE_START_DATE => c.p76
1053 ,P_EFFECTIVE_END_DATE => c.p77
1054 ,P_ELEMENT_ENTRY_ID => L_ELEMENT_ENTRY_ID
1055 ,P_OBJECT_VERSION_NUMBER => c.p79
1059 iuk(p_batch_line_id,c.p78,L_ELEMENT_ENTRY_ID);
1056 ,P_CREATE_WARNING => L_CREATE_WARNING);
1057 hr_data_pump.api_trc_off;
1058 --
1060 --
1061 if L_CREATE_WARNING then
1062 c.p80 := 'TRUE';
1063 else
1064 c.p80 := 'FALSE';
1065 end if;
1066 --
1067 update hr_pump_batch_lines l set
1068 l.pval076 = decode(c.p76,null,cn,dc(c.p76)),
1069 l.pval077 = decode(c.p77,null,cn,dc(c.p77)),
1070 l.pval078 = decode(c.p78,null,cn,c.p78),
1071 l.pval079 = decode(c.p79,null,cn,c.p79),
1072 l.pval080 = decode(c.p80,null,cn,c.p80)
1073 where l.rowid = c.myrowid;
1074 --
1075 close cr;
1076 --
1077 hr_data_pump.exit('call');
1078 exception
1079 when hr_multi_message.error_message_exist then
1080 if cr%isopen then
1081 close cr;
1082 end if;
1083 hr_pump_utils.set_multi_msg_error_flag(true);
1084 when others then
1085 if cr%isopen then
1086 close cr;
1087 end if;
1088 raise;
1089 end call;
1090 end hrdpp_CREATE_ELEMENT_ENTRY;