[Home] [Help]
PACKAGE BODY: APPS.HRDPP_UPDATE_IN_EMP_ASG
Source
1 package body hrdpp_update_in_emp_asg as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:15
4 * Generated for API: hr_in_assignment_api.update_in_emp_asg
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_DATETRACK_UPDATE_MODE in varchar2
84 ,P_ASSIGNMENT_NUMBER in varchar2 default null
85 ,P_CHANGE_REASON in varchar2 default null
86 ,P_COMMENTS in varchar2 default null
87 ,P_DATE_PROBATION_END in date default null
88 ,I_DATE_PROBATION_END in varchar2 default 'N'
89 ,P_FREQUENCY in varchar2 default null
90 ,P_INTERNAL_ADDRESS_LINE in varchar2 default null
91 ,P_MANAGER_FLAG in varchar2 default null
92 ,P_NORMAL_HOURS in number default null
93 ,I_NORMAL_HOURS in varchar2 default 'N'
94 ,P_PERF_REVIEW_PERIOD in number default null
95 ,I_PERF_REVIEW_PERIOD in varchar2 default 'N'
96 ,P_PERF_REVIEW_PERIOD_FREQUENCY in varchar2 default null
97 ,P_PROBATION_PERIOD in number default null
98 ,I_PROBATION_PERIOD in varchar2 default 'N'
99 ,P_PROBATION_UNIT in varchar2 default null
100 ,P_SAL_REVIEW_PERIOD in number default null
101 ,I_SAL_REVIEW_PERIOD in varchar2 default 'N'
102 ,P_SAL_REVIEW_PERIOD_FREQUENCY in varchar2 default null
103 ,P_SOURCE_TYPE in varchar2 default null
104 ,P_TIME_NORMAL_FINISH in varchar2 default null
105 ,P_TIME_NORMAL_START in varchar2 default null
106 ,P_BARGAINING_UNIT_CODE in varchar2 default null
107 ,P_LABOUR_UNION_MEMBER_FLAG in varchar2 default null
108 ,P_HOURLY_SALARIED_CODE in varchar2 default null
109 ,P_ASS_ATTRIBUTE_CATEGORY in varchar2 default null
110 ,P_ASS_ATTRIBUTE1 in varchar2 default null
111 ,P_ASS_ATTRIBUTE2 in varchar2 default null
112 ,P_ASS_ATTRIBUTE3 in varchar2 default null
113 ,P_ASS_ATTRIBUTE4 in varchar2 default null
114 ,P_ASS_ATTRIBUTE5 in varchar2 default null
115 ,P_ASS_ATTRIBUTE6 in varchar2 default null
116 ,P_ASS_ATTRIBUTE7 in varchar2 default null
117 ,P_ASS_ATTRIBUTE8 in varchar2 default null
118 ,P_ASS_ATTRIBUTE9 in varchar2 default null
119 ,P_ASS_ATTRIBUTE10 in varchar2 default null
120 ,P_ASS_ATTRIBUTE11 in varchar2 default null
121 ,P_ASS_ATTRIBUTE12 in varchar2 default null
122 ,P_ASS_ATTRIBUTE13 in varchar2 default null
123 ,P_ASS_ATTRIBUTE14 in varchar2 default null
124 ,P_ASS_ATTRIBUTE15 in varchar2 default null
125 ,P_ASS_ATTRIBUTE16 in varchar2 default null
126 ,P_ASS_ATTRIBUTE17 in varchar2 default null
127 ,P_ASS_ATTRIBUTE18 in varchar2 default null
128 ,P_ASS_ATTRIBUTE19 in varchar2 default null
129 ,P_ASS_ATTRIBUTE20 in varchar2 default null
130 ,P_ASS_ATTRIBUTE21 in varchar2 default null
131 ,P_ASS_ATTRIBUTE22 in varchar2 default null
132 ,P_ASS_ATTRIBUTE23 in varchar2 default null
133 ,P_ASS_ATTRIBUTE24 in varchar2 default null
134 ,P_ASS_ATTRIBUTE25 in varchar2 default null
135 ,P_ASS_ATTRIBUTE26 in varchar2 default null
136 ,P_ASS_ATTRIBUTE27 in varchar2 default null
137 ,P_ASS_ATTRIBUTE28 in varchar2 default null
138 ,P_ASS_ATTRIBUTE29 in varchar2 default null
139 ,P_ASS_ATTRIBUTE30 in varchar2 default null
140 ,P_TITLE in varchar2 default null
141 ,P_COVERED_BY_GRATUITY_ACT in varchar2 default null
142 ,P_HAVING_SUBSTANTIAL_INTEREST in varchar2 default null
143 ,P_DIRECTOR in varchar2 default null
144 ,P_SPECIFIED in varchar2 default null
145 ,P_CONCAT_SEGMENTS in varchar2 default null
146 ,P_CAG_SEGMENT1 in varchar2 default null
147 ,P_CAG_SEGMENT2 in varchar2 default null
148 ,P_CAG_SEGMENT3 in varchar2 default null
149 ,P_CAG_SEGMENT4 in varchar2 default null
150 ,P_CAG_SEGMENT5 in varchar2 default null
151 ,P_CAG_SEGMENT6 in varchar2 default null
152 ,P_CAG_SEGMENT7 in varchar2 default null
153 ,P_CAG_SEGMENT8 in varchar2 default null
154 ,P_CAG_SEGMENT9 in varchar2 default null
155 ,P_CAG_SEGMENT10 in varchar2 default null
156 ,P_CAG_SEGMENT11 in varchar2 default null
157 ,P_CAG_SEGMENT12 in varchar2 default null
158 ,P_CAG_SEGMENT13 in varchar2 default null
159 ,P_CAG_SEGMENT14 in varchar2 default null
160 ,P_CAG_SEGMENT15 in varchar2 default null
161 ,P_CAG_SEGMENT16 in varchar2 default null
162 ,P_CAG_SEGMENT17 in varchar2 default null
163 ,P_CAG_SEGMENT18 in varchar2 default null
164 ,P_CAG_SEGMENT19 in varchar2 default null
165 ,P_CAG_SEGMENT20 in varchar2 default null
166 ,P_NOTICE_PERIOD in number default null
167 ,I_NOTICE_PERIOD in varchar2 default 'N'
168 ,P_NOTICE_PERIOD_UOM in varchar2 default null
169 ,P_EMPLOYEE_CATEGORY in varchar2 default null
170 ,P_WORK_AT_HOME in varchar2 default null
171 ,P_JOB_POST_SOURCE_NAME in varchar2 default null
172 ,P_CAGR_GRADE_DEF_ID in number
173 ,P_ASSIGNMENT_USER_KEY in varchar2
174 ,P_SUPERVISOR_USER_KEY in varchar2 default null
175 ,P_USER_STATUS in varchar2 default null
176 ,P_LANGUAGE_CODE in varchar2 default null
177 ,P_DEFAULT_CODE_COMB_USER_KEY in varchar2 default null
178 ,P_SET_OF_BOOKS_NAME in varchar2 default null
179 ,P_GRE_LEGAL_ENTITY in varchar2 default null
180 ,P_PF_ORGANIZATION in varchar2 default null
181 ,P_PROF_TAX_ORGANIZATION in varchar2 default null
182 ,P_ESI_ORGANIZATION in varchar2 default null
183 ,P_FACTORY in varchar2 default null
184 ,P_ESTABLISHMENT in varchar2 default null
185 ,P_CONTRACT_USER_KEY in varchar2 default null
186 ,P_ESTABLISHMENT_ORG_NAME in varchar2 default null
187 ,P_CAGR_NAME in varchar2 default null
188 ,P_CAGR_ID_FLEX_NUM_USER_KEY in varchar2 default null
189 ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null
190 ,P_CON_SEG_USER_NAME in varchar2) is
191 blid number := p_data_pump_batch_line_id;
192 begin
193 if blid is not null then
194 delete from hr_pump_batch_lines where batch_line_id = blid;
195 delete from hr_pump_batch_exceptions
196 where source_type = 'BATCH_LINE' and source_id = blid;
197 end if;
198 insert into hr_pump_batch_lines
199 (batch_id
200 ,batch_line_id
201 ,business_group_name
202 ,api_module_id
203 ,line_status
204 ,user_sequence
205 ,link_value
206 ,pval001
207 ,pval002
208 ,pval003
209 ,pval004
210 ,pval005
211 ,pval006
212 ,pval007
213 ,pval008
214 ,pval009
215 ,pval010
216 ,pval011
217 ,pval012
218 ,pval013
219 ,pval014
220 ,pval015
221 ,pval016
222 ,pval017
223 ,pval018
224 ,pval019
225 ,pval020
226 ,pval021
227 ,pval022
228 ,pval023
229 ,pval024
230 ,pval025
231 ,pval026
232 ,pval027
233 ,pval028
234 ,pval029
235 ,pval030
236 ,pval031
237 ,pval032
238 ,pval033
239 ,pval034
240 ,pval035
241 ,pval036
242 ,pval037
243 ,pval038
244 ,pval039
245 ,pval040
246 ,pval041
247 ,pval042
248 ,pval043
249 ,pval044
250 ,pval045
251 ,pval046
252 ,pval047
253 ,pval048
254 ,pval049
255 ,pval050
256 ,pval051
257 ,pval052
258 ,pval053
259 ,pval054
260 ,pval055
261 ,pval056
262 ,pval057
263 ,pval058
264 ,pval059
265 ,pval060
266 ,pval061
267 ,pval062
268 ,pval063
269 ,pval064
270 ,pval065
271 ,pval066
272 ,pval067
273 ,pval068
274 ,pval069
275 ,pval070
276 ,pval071
277 ,pval072
278 ,pval073
279 ,pval074
280 ,pval075
281 ,pval076
282 ,pval077
283 ,pval078
284 ,pval079
285 ,pval080
286 ,pval081
287 ,pval082
288 ,pval083
289 ,pval084
290 ,pval085
291 ,pval095
292 ,pval096
293 ,pval097
294 ,pval098
295 ,pval099
296 ,pval100
297 ,pval101
298 ,pval102
299 ,pval103
300 ,pval104
301 ,pval105
302 ,pval106
303 ,pval107
304 ,pval108
305 ,pval109
306 ,pval110
307 ,pval111
308 ,pval112)
309 values
310 (p_batch_id
311 ,nvl(blid,hr_pump_batch_lines_s.nextval)
312 ,p_data_pump_business_grp_name
313 ,3214
314 ,'U'
315 ,p_user_sequence
316 ,p_link_value
317 ,dc(P_EFFECTIVE_DATE)
318 ,P_DATETRACK_UPDATE_MODE
319 ,P_ASSIGNMENT_NUMBER
320 ,P_CHANGE_REASON
321 ,P_COMMENTS
322 ,dd(P_DATE_PROBATION_END,I_DATE_PROBATION_END)
323 ,P_FREQUENCY
324 ,P_INTERNAL_ADDRESS_LINE
325 ,P_MANAGER_FLAG
326 ,nd(P_NORMAL_HOURS,I_NORMAL_HOURS)
327 ,nd(P_PERF_REVIEW_PERIOD,I_PERF_REVIEW_PERIOD)
328 ,P_PERF_REVIEW_PERIOD_FREQUENCY
329 ,nd(P_PROBATION_PERIOD,I_PROBATION_PERIOD)
330 ,P_PROBATION_UNIT
331 ,nd(P_SAL_REVIEW_PERIOD,I_SAL_REVIEW_PERIOD)
332 ,P_SAL_REVIEW_PERIOD_FREQUENCY
333 ,P_SOURCE_TYPE
334 ,P_TIME_NORMAL_FINISH
335 ,P_TIME_NORMAL_START
336 ,P_BARGAINING_UNIT_CODE
337 ,P_LABOUR_UNION_MEMBER_FLAG
338 ,P_HOURLY_SALARIED_CODE
339 ,P_ASS_ATTRIBUTE_CATEGORY
340 ,P_ASS_ATTRIBUTE1
341 ,P_ASS_ATTRIBUTE2
342 ,P_ASS_ATTRIBUTE3
343 ,P_ASS_ATTRIBUTE4
344 ,P_ASS_ATTRIBUTE5
345 ,P_ASS_ATTRIBUTE6
346 ,P_ASS_ATTRIBUTE7
347 ,P_ASS_ATTRIBUTE8
348 ,P_ASS_ATTRIBUTE9
349 ,P_ASS_ATTRIBUTE10
350 ,P_ASS_ATTRIBUTE11
351 ,P_ASS_ATTRIBUTE12
352 ,P_ASS_ATTRIBUTE13
353 ,P_ASS_ATTRIBUTE14
354 ,P_ASS_ATTRIBUTE15
355 ,P_ASS_ATTRIBUTE16
356 ,P_ASS_ATTRIBUTE17
357 ,P_ASS_ATTRIBUTE18
358 ,P_ASS_ATTRIBUTE19
359 ,P_ASS_ATTRIBUTE20
360 ,P_ASS_ATTRIBUTE21
361 ,P_ASS_ATTRIBUTE22
362 ,P_ASS_ATTRIBUTE23
363 ,P_ASS_ATTRIBUTE24
364 ,P_ASS_ATTRIBUTE25
365 ,P_ASS_ATTRIBUTE26
366 ,P_ASS_ATTRIBUTE27
367 ,P_ASS_ATTRIBUTE28
368 ,P_ASS_ATTRIBUTE29
369 ,P_ASS_ATTRIBUTE30
370 ,P_TITLE
371 ,P_COVERED_BY_GRATUITY_ACT
372 ,P_HAVING_SUBSTANTIAL_INTEREST
373 ,P_DIRECTOR
374 ,P_SPECIFIED
375 ,P_CONCAT_SEGMENTS
376 ,P_CAG_SEGMENT1
377 ,P_CAG_SEGMENT2
378 ,P_CAG_SEGMENT3
379 ,P_CAG_SEGMENT4
380 ,P_CAG_SEGMENT5
381 ,P_CAG_SEGMENT6
382 ,P_CAG_SEGMENT7
383 ,P_CAG_SEGMENT8
384 ,P_CAG_SEGMENT9
385 ,P_CAG_SEGMENT10
386 ,P_CAG_SEGMENT11
387 ,P_CAG_SEGMENT12
388 ,P_CAG_SEGMENT13
389 ,P_CAG_SEGMENT14
390 ,P_CAG_SEGMENT15
391 ,P_CAG_SEGMENT16
392 ,P_CAG_SEGMENT17
393 ,P_CAG_SEGMENT18
394 ,P_CAG_SEGMENT19
395 ,P_CAG_SEGMENT20
396 ,nd(P_NOTICE_PERIOD,I_NOTICE_PERIOD)
397 ,P_NOTICE_PERIOD_UOM
398 ,P_EMPLOYEE_CATEGORY
399 ,P_WORK_AT_HOME
400 ,P_JOB_POST_SOURCE_NAME
401 ,P_CAGR_GRADE_DEF_ID
402 ,P_ASSIGNMENT_USER_KEY
403 ,P_SUPERVISOR_USER_KEY
404 ,P_USER_STATUS
405 ,P_LANGUAGE_CODE
409 ,P_PF_ORGANIZATION
406 ,P_DEFAULT_CODE_COMB_USER_KEY
407 ,P_SET_OF_BOOKS_NAME
408 ,P_GRE_LEGAL_ENTITY
410 ,P_PROF_TAX_ORGANIZATION
411 ,P_ESI_ORGANIZATION
412 ,P_FACTORY
413 ,P_ESTABLISHMENT
414 ,P_CONTRACT_USER_KEY
415 ,P_ESTABLISHMENT_ORG_NAME
416 ,P_CAGR_NAME
417 ,P_CAGR_ID_FLEX_NUM_USER_KEY
418 ,P_SVR_ASSIGNMENT_USER_KEY
419 ,P_CON_SEG_USER_NAME);
420 end insert_batch_lines;
421 --
422 procedure call
423 (p_business_group_id in number,
424 p_batch_line_id in number) is
425 cursor cr is
426 select l.rowid myrowid,
427 decode(l.pval001,cn,dn,d(l.pval001)) p1,
428 decode(l.pval002,cn,vn,l.pval002) p2,
429 decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
430 l.pval003 d3,
431 decode(l.pval004,cn,vn,vn,vh,
432 hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),l.pval098)) p4,
433 l.pval004 d4,
434 decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
435 l.pval005 d5,
436 decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
437 l.pval006 d6,
438 decode(l.pval007,cn,vn,vn,vh,
439 hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval098)) p7,
440 l.pval007 d7,
441 decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
442 l.pval008 d8,
443 decode(l.pval009,cn,vn,vn,vh,
444 hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval098)) p9,
445 l.pval009 d9,
446 decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
447 l.pval010 d10,
448 decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
449 l.pval011 d11,
450 decode(l.pval012,cn,vn,vn,vh,
451 hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval098)) p12,
452 l.pval012 d12,
453 decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
454 l.pval013 d13,
455 decode(l.pval014,cn,vn,vn,vh,
456 hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval098)) p14,
457 l.pval014 d14,
458 decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
459 l.pval015 d15,
460 decode(l.pval016,cn,vn,vn,vh,
461 hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval098)) p16,
462 l.pval016 d16,
463 decode(l.pval017,cn,vn,vn,vh,
464 hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval098)) p17,
465 l.pval017 d17,
466 decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
467 l.pval018 d18,
468 decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
469 l.pval019 d19,
470 decode(l.pval020,cn,vn,vn,vh,
471 hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval098)) p20,
472 l.pval020 d20,
473 decode(l.pval021,cn,vn,vn,vh,
474 hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval098)) p21,
475 l.pval021 d21,
476 decode(l.pval022,cn,vn,vn,vh,
477 hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval098)) p22,
478 l.pval022 d22,
479 decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
480 l.pval023 d23,
481 decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
482 l.pval024 d24,
483 decode(l.pval025,cn,vn,vn,vh,l.pval025) p25,
484 l.pval025 d25,
485 decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
486 l.pval026 d26,
487 decode(l.pval027,cn,vn,vn,vh,l.pval027) p27,
488 l.pval027 d27,
489 decode(l.pval028,cn,vn,vn,vh,l.pval028) p28,
490 l.pval028 d28,
491 decode(l.pval029,cn,vn,vn,vh,l.pval029) p29,
492 l.pval029 d29,
493 decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
494 l.pval030 d30,
495 decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
496 l.pval031 d31,
497 decode(l.pval032,cn,vn,vn,vh,l.pval032) p32,
498 l.pval032 d32,
499 decode(l.pval033,cn,vn,vn,vh,l.pval033) p33,
500 l.pval033 d33,
501 decode(l.pval034,cn,vn,vn,vh,l.pval034) p34,
502 l.pval034 d34,
503 decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
504 l.pval035 d35,
505 decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
506 l.pval036 d36,
507 decode(l.pval037,cn,vn,vn,vh,l.pval037) p37,
508 l.pval037 d37,
509 decode(l.pval038,cn,vn,vn,vh,l.pval038) p38,
510 l.pval038 d38,
511 decode(l.pval039,cn,vn,vn,vh,l.pval039) p39,
512 l.pval039 d39,
513 decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
514 l.pval040 d40,
515 decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
516 l.pval041 d41,
517 decode(l.pval042,cn,vn,vn,vh,l.pval042) p42,
518 l.pval042 d42,
519 decode(l.pval043,cn,vn,vn,vh,l.pval043) p43,
520 l.pval043 d43,
521 decode(l.pval044,cn,vn,vn,vh,l.pval044) p44,
522 l.pval044 d44,
523 decode(l.pval045,cn,vn,vn,vh,l.pval045) p45,
524 l.pval045 d45,
525 decode(l.pval046,cn,vn,vn,vh,l.pval046) p46,
526 l.pval046 d46,
527 decode(l.pval047,cn,vn,vn,vh,l.pval047) p47,
528 l.pval047 d47,
529 decode(l.pval048,cn,vn,vn,vh,l.pval048) p48,
530 l.pval048 d48,
531 decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
532 l.pval049 d49,
533 decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
534 l.pval050 d50,
535 decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
536 l.pval051 d51,
537 decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
538 l.pval052 d52,
539 decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
540 l.pval053 d53,
541 decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
542 l.pval054 d54,
543 decode(l.pval055,cn,vn,vn,'N',
544 hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval098)) p55,
545 l.pval055 d55,
546 decode(l.pval056,cn,vn,vn,'N',
547 hr_pump_get.gl(l.pval056,'YES_NO',d(l.pval001),l.pval098)) p56,
548 l.pval056 d56,
549 decode(l.pval057,cn,vn,vn,'N',
550 hr_pump_get.gl(l.pval057,'YES_NO',d(l.pval001),l.pval098)) p57,
551 l.pval057 d57,
552 decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
553 l.pval058 d58,
554 decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
555 l.pval059 d59,
556 decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,
557 l.pval060 d60,
558 decode(l.pval061,cn,vn,vn,vh,l.pval061) p61,
559 l.pval061 d61,
560 decode(l.pval062,cn,vn,vn,vh,l.pval062) p62,
561 l.pval062 d62,
562 decode(l.pval063,cn,vn,vn,vh,l.pval063) p63,
563 l.pval063 d63,
567 l.pval065 d65,
564 decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
565 l.pval064 d64,
566 decode(l.pval065,cn,vn,vn,vh,l.pval065) p65,
568 decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
569 l.pval066 d66,
570 decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
571 l.pval067 d67,
572 decode(l.pval068,cn,vn,vn,vh,l.pval068) p68,
573 l.pval068 d68,
574 decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
575 l.pval069 d69,
576 decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
577 l.pval070 d70,
578 decode(l.pval071,cn,vn,vn,vh,l.pval071) p71,
579 l.pval071 d71,
580 decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
581 l.pval072 d72,
582 decode(l.pval073,cn,vn,vn,vh,l.pval073) p73,
583 l.pval073 d73,
584 decode(l.pval074,cn,vn,vn,vh,l.pval074) p74,
585 l.pval074 d74,
586 decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
587 l.pval075 d75,
588 decode(l.pval076,cn,vn,vn,vh,l.pval076) p76,
589 l.pval076 d76,
590 decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
591 l.pval077 d77,
592 decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,
593 l.pval078 d78,
594 decode(l.pval079,cn,vn,vn,vh,l.pval079) p79,
595 l.pval079 d79,
596 decode(l.pval080,cn,nn,vn,nh,n(l.pval080)) p80,
597 l.pval080 d80,
598 decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
599 l.pval081 d81,
600 decode(l.pval082,cn,vn,vn,vh,
601 hr_pump_get.gl(l.pval082,'EMPLOYEE_CATG',d(l.pval001),l.pval098)) p82,
602 l.pval082 d82,
603 decode(l.pval083,cn,vn,vn,vh,l.pval083) p83,
604 l.pval083 d83,
605 decode(l.pval084,cn,vn,vn,vh,l.pval084) p84,
606 l.pval084 d84,
607 decode(l.pval085,cn,nn,n(l.pval085)) p85,
608 l.pval086 p86,
609 l.pval087 p87,
610 l.pval088 p88,
611 decode(l.pval089,cn,dn,d(l.pval089)) p89,
612 decode(l.pval090,cn,dn,d(l.pval090)) p90,
613 l.pval091 p91,
614 l.pval092 p92,
615 l.pval093 p93,
616 l.pval094 p94,
617 decode(l.pval095,cn,vn,l.pval095) p95,
618 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
619 l.pval096 d96,
620 decode(l.pval097,cn,vn,vn,vh,l.pval097) p97,
621 l.pval097 d97,
622 decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
623 l.pval098 d98,
624 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
625 l.pval099 d99,
626 decode(l.pval100,cn,vn,vn,vh,l.pval100) p100,
627 l.pval100 d100,
628 decode(l.pval101,cn,vn,vn,vh,l.pval101) p101,
629 l.pval101 d101,
630 decode(l.pval102,cn,vn,vn,vh,l.pval102) p102,
631 l.pval102 d102,
632 decode(l.pval103,cn,vn,vn,vh,l.pval103) p103,
633 l.pval103 d103,
634 decode(l.pval104,cn,vn,vn,vh,l.pval104) p104,
635 l.pval104 d104,
636 decode(l.pval105,cn,vn,vn,vh,l.pval105) p105,
637 l.pval105 d105,
638 decode(l.pval106,cn,vn,vn,vh,l.pval106) p106,
639 l.pval106 d106,
640 decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
641 l.pval107 d107,
642 decode(l.pval108,cn,vn,vn,vh,l.pval108) p108,
643 l.pval108 d108,
644 decode(l.pval109,cn,vn,vn,vh,l.pval109) p109,
645 l.pval109 d109,
646 decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
647 l.pval110 d110,
648 decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
649 l.pval111 d111,
650 decode(l.pval112,cn,vn,l.pval112) p112
651 from hr_pump_batch_lines l
652 where l.batch_line_id = p_batch_line_id;
653 --
654 c cr%rowtype;
655 l_validate boolean := false;
656 L_NO_MANAGERS_WARNING boolean;
657 L_OTHER_MANAGER_WARNING boolean;
658 L_HOURLY_SALARIED_WARNING boolean;
659 L_ASSIGNMENT_ID number;
663 L_DEFAULT_CODE_COMB_ID number;
660 L_OBJECT_VERSION_NUMBER number;
661 L_SUPERVISOR_ID number;
662 L_ASSIGNMENT_STATUS_TYPE_ID number;
664 L_SET_OF_BOOKS_ID number;
665 L_GRE_LEGAL_ENTITY varchar2(2000);
666 L_PF_ORGANIZATION varchar2(2000);
667 L_PROF_TAX_ORGANIZATION varchar2(2000);
668 L_ESI_ORGANIZATION varchar2(2000);
669 L_FACTORY varchar2(2000);
670 L_ESTABLISHMENT varchar2(2000);
671 L_CONTRACT_ID number;
672 L_ESTABLISHMENT_ID number;
673 L_COLLECTIVE_AGREEMENT_ID number;
674 L_CAGR_ID_FLEX_NUM number;
675 L_SUPERVISOR_ASSIGNMENT_ID number;
676 L_SOFT_CODING_KEYFLEX_ID number;
677 --
678 begin
679 hr_data_pump.entry('call');
680 open cr;
681 fetch cr into c;
682 if cr%notfound then
683 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
684 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
685 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
686 hr_utility.set_message_token('VALUE',p_batch_line_id);
687 hr_utility.raise_error;
688 end if;
689 --
690 if c.p95 is null then
691 L_ASSIGNMENT_ID:=nn;
692 else
693 L_ASSIGNMENT_ID :=
694 hr_pump_get.get_assignment_id
695 (P_ASSIGNMENT_USER_KEY => c.p95);
696 end if;
697 --
698 if c.p95 is null or
699 c.p1 is null then
700 L_OBJECT_VERSION_NUMBER:=nn;
701 else
702 L_OBJECT_VERSION_NUMBER :=
703 hr_pump_get.GET_ASG_OVN
704 (P_ASSIGNMENT_USER_KEY => c.p95
705 ,P_EFFECTIVE_DATE => c.p1);
706 end if;
707 --
708 if c.d96=cn then
709 L_SUPERVISOR_ID:=nn;
710 elsif c.d96 is null then
711 L_SUPERVISOR_ID:=nh;
712 else
713 L_SUPERVISOR_ID :=
714 hr_pump_get.get_supervisor_id
715 (P_SUPERVISOR_USER_KEY => c.p96);
716 end if;
717 --
718 if c.d97=cn or
719 c.d98=cn then
720 L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
721 elsif c.d97 is null or
722 c.d98 is null then
723 L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
724 else
725 L_ASSIGNMENT_STATUS_TYPE_ID :=
726 hr_pump_get.get_assignment_status_type_id
727 (P_USER_STATUS => c.p97
728 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
729 ,P_LANGUAGE_CODE => c.p98);
730 end if;
731 --
732 if c.d99=cn then
733 L_DEFAULT_CODE_COMB_ID:=nn;
734 elsif c.d99 is null then
735 L_DEFAULT_CODE_COMB_ID:=nh;
736 else
737 L_DEFAULT_CODE_COMB_ID :=
738 hr_pump_get.get_default_code_comb_id
739 (P_DEFAULT_CODE_COMB_USER_KEY => c.p99);
740 end if;
741 --
742 if c.d100=cn then
743 L_SET_OF_BOOKS_ID:=nn;
744 elsif c.d100 is null then
745 L_SET_OF_BOOKS_ID:=nh;
746 else
747 L_SET_OF_BOOKS_ID :=
748 hr_pump_get.get_set_of_books_id
749 (P_SET_OF_BOOKS_NAME => c.p100);
750 end if;
751 --
752 if c.d101=cn then
753 L_GRE_LEGAL_ENTITY:=vn;
754 elsif c.d101 is null then
755 L_GRE_LEGAL_ENTITY:=vh;
756 else
757 L_GRE_LEGAL_ENTITY :=
758 PER_IN_DATA_PUMP.GET_GRE_ID
759 (P_GRE_LEGAL_ENTITY => c.p101);
760 end if;
761 --
762 if c.d102=cn then
763 L_PF_ORGANIZATION:=vn;
764 elsif c.d102 is null then
765 L_PF_ORGANIZATION:=vh;
766 else
767 L_PF_ORGANIZATION :=
768 PER_IN_DATA_PUMP.GET_PF_ORG_ID
769 (P_PF_ORGANIZATION => c.p102);
770 end if;
771 --
772 if c.d103=cn then
773 L_PROF_TAX_ORGANIZATION:=vn;
774 elsif c.d103 is null then
775 L_PROF_TAX_ORGANIZATION:=vh;
776 else
777 L_PROF_TAX_ORGANIZATION :=
778 PER_IN_DATA_PUMP.GET_PROF_TAX_ORG_ID
779 (P_PROF_TAX_ORGANIZATION => c.p103);
780 end if;
781 --
782 if c.d104=cn then
783 L_ESI_ORGANIZATION:=vn;
784 elsif c.d104 is null then
785 L_ESI_ORGANIZATION:=vh;
786 else
787 L_ESI_ORGANIZATION :=
788 PER_IN_DATA_PUMP.GET_ESI_ID
789 (P_ESI_ORGANIZATION => c.p104);
790 end if;
791 --
792 if c.d105=cn then
793 L_FACTORY:=vn;
794 elsif c.d105 is null then
795 L_FACTORY:=vh;
796 else
797 L_FACTORY :=
798 PER_IN_DATA_PUMP.GET_FACTORY_ID
799 (P_FACTORY => c.p105);
800 end if;
801 --
802 if c.d106=cn then
803 L_ESTABLISHMENT:=vn;
804 elsif c.d106 is null then
805 L_ESTABLISHMENT:=vh;
806 else
807 L_ESTABLISHMENT :=
808 PER_IN_DATA_PUMP.GET_EST_ID
809 (P_ESTABLISHMENT => c.p106);
810 end if;
811 --
812 if c.d107=cn then
813 L_CONTRACT_ID:=nn;
814 elsif c.d107 is null then
815 L_CONTRACT_ID:=nh;
816 else
817 L_CONTRACT_ID :=
818 hr_pump_get.get_contract_id
819 (P_CONTRACT_USER_KEY => c.p107);
820 end if;
821 --
822 if c.d108=cn or
823 c.p1 is null or
824 c.d98=cn then
825 L_ESTABLISHMENT_ID:=nn;
826 elsif c.d108 is null or
827 c.d98 is null then
828 L_ESTABLISHMENT_ID:=nh;
829 else
830 L_ESTABLISHMENT_ID :=
831 hr_pump_get.GET_ESTABLISHMENT_ORG_ID
832 (P_ESTABLISHMENT_ORG_NAME => c.p108
833 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
834 ,P_EFFECTIVE_DATE => c.p1
835 ,P_LANGUAGE_CODE => c.p98);
836 end if;
837 --
838 if c.d109=cn or
839 c.p1 is null then
840 L_COLLECTIVE_AGREEMENT_ID:=nn;
841 elsif c.d109 is null then
842 L_COLLECTIVE_AGREEMENT_ID:=nh;
843 else
844 L_COLLECTIVE_AGREEMENT_ID :=
845 hr_pump_get.get_collective_agreement_id
846 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
847 ,P_CAGR_NAME => c.p109
851 if c.d110=cn then
848 ,P_EFFECTIVE_DATE => c.p1);
849 end if;
850 --
852 L_CAGR_ID_FLEX_NUM:=nn;
853 elsif c.d110 is null then
854 L_CAGR_ID_FLEX_NUM:=nh;
855 else
856 L_CAGR_ID_FLEX_NUM :=
857 hr_pump_get.GET_CAGR_ID_FLEX_NUM
858 (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p110);
859 end if;
860 --
861 if c.d111=cn then
862 L_SUPERVISOR_ASSIGNMENT_ID:=nn;
863 elsif c.d111 is null then
864 L_SUPERVISOR_ASSIGNMENT_ID:=nh;
865 else
866 L_SUPERVISOR_ASSIGNMENT_ID :=
867 hr_pump_get.get_supervisor_assignment_id
868 (P_SVR_ASSIGNMENT_USER_KEY => c.p111);
869 end if;
870 --
871 if c.p112 is null or
872 c.p1 is null then
873 L_SOFT_CODING_KEYFLEX_ID:=nn;
874 else
875 L_SOFT_CODING_KEYFLEX_ID :=
876 hr_pump_get.get_soft_coding_keyflex_id
877 (P_CON_SEG_USER_NAME => c.p112
878 ,P_EFFECTIVE_DATE => c.p1);
879 end if;
880 --
881 hr_data_pump.api_trc_on;
882 hr_in_assignment_api.update_in_emp_asg
883 (p_validate => l_validate
884 ,P_EFFECTIVE_DATE => c.p1
885 ,P_DATETRACK_UPDATE_MODE => c.p2
886 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
887 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
888 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
889 ,P_ASSIGNMENT_NUMBER => c.p3
890 ,P_CHANGE_REASON => c.p4
891 ,P_ASSIGNMENT_STATUS_TYPE_ID => L_ASSIGNMENT_STATUS_TYPE_ID
892 ,P_COMMENTS => c.p5
893 ,P_DATE_PROBATION_END => c.p6
894 ,P_DEFAULT_CODE_COMB_ID => L_DEFAULT_CODE_COMB_ID
895 ,P_FREQUENCY => c.p7
896 ,P_INTERNAL_ADDRESS_LINE => c.p8
897 ,P_MANAGER_FLAG => c.p9
898 ,P_NORMAL_HOURS => c.p10
899 ,P_PERF_REVIEW_PERIOD => c.p11
900 ,P_PERF_REVIEW_PERIOD_FREQUENCY => c.p12
901 ,P_PROBATION_PERIOD => c.p13
902 ,P_PROBATION_UNIT => c.p14
903 ,P_SAL_REVIEW_PERIOD => c.p15
904 ,P_SAL_REVIEW_PERIOD_FREQUENCY => c.p16
905 ,P_SET_OF_BOOKS_ID => L_SET_OF_BOOKS_ID
906 ,P_SOURCE_TYPE => c.p17
907 ,P_TIME_NORMAL_FINISH => c.p18
908 ,P_TIME_NORMAL_START => c.p19
909 ,P_BARGAINING_UNIT_CODE => c.p20
910 ,P_LABOUR_UNION_MEMBER_FLAG => c.p21
911 ,P_HOURLY_SALARIED_CODE => c.p22
912 ,P_ASS_ATTRIBUTE_CATEGORY => c.p23
913 ,P_ASS_ATTRIBUTE1 => c.p24
914 ,P_ASS_ATTRIBUTE2 => c.p25
915 ,P_ASS_ATTRIBUTE3 => c.p26
916 ,P_ASS_ATTRIBUTE4 => c.p27
917 ,P_ASS_ATTRIBUTE5 => c.p28
918 ,P_ASS_ATTRIBUTE6 => c.p29
919 ,P_ASS_ATTRIBUTE7 => c.p30
920 ,P_ASS_ATTRIBUTE8 => c.p31
921 ,P_ASS_ATTRIBUTE9 => c.p32
922 ,P_ASS_ATTRIBUTE10 => c.p33
923 ,P_ASS_ATTRIBUTE11 => c.p34
924 ,P_ASS_ATTRIBUTE12 => c.p35
925 ,P_ASS_ATTRIBUTE13 => c.p36
926 ,P_ASS_ATTRIBUTE14 => c.p37
927 ,P_ASS_ATTRIBUTE15 => c.p38
928 ,P_ASS_ATTRIBUTE16 => c.p39
929 ,P_ASS_ATTRIBUTE17 => c.p40
930 ,P_ASS_ATTRIBUTE18 => c.p41
931 ,P_ASS_ATTRIBUTE19 => c.p42
932 ,P_ASS_ATTRIBUTE20 => c.p43
933 ,P_ASS_ATTRIBUTE21 => c.p44
934 ,P_ASS_ATTRIBUTE22 => c.p45
935 ,P_ASS_ATTRIBUTE23 => c.p46
936 ,P_ASS_ATTRIBUTE24 => c.p47
937 ,P_ASS_ATTRIBUTE25 => c.p48
938 ,P_ASS_ATTRIBUTE26 => c.p49
939 ,P_ASS_ATTRIBUTE27 => c.p50
940 ,P_ASS_ATTRIBUTE28 => c.p51
941 ,P_ASS_ATTRIBUTE29 => c.p52
942 ,P_ASS_ATTRIBUTE30 => c.p53
943 ,P_TITLE => c.p54
944 ,P_GRE_LEGAL_ENTITY => L_GRE_LEGAL_ENTITY
945 ,P_PF_ORGANIZATION => L_PF_ORGANIZATION
946 ,P_PROF_TAX_ORGANIZATION => L_PROF_TAX_ORGANIZATION
947 ,P_ESI_ORGANIZATION => L_ESI_ORGANIZATION
948 ,P_FACTORY => L_FACTORY
949 ,P_ESTABLISHMENT => L_ESTABLISHMENT
950 ,P_COVERED_BY_GRATUITY_ACT => c.p55
951 ,P_HAVING_SUBSTANTIAL_INTEREST => c.p56
952 ,P_DIRECTOR => c.p57
953 ,P_SPECIFIED => c.p58
954 ,P_CONCAT_SEGMENTS => c.p59
955 ,P_CONTRACT_ID => L_CONTRACT_ID
956 ,P_ESTABLISHMENT_ID => L_ESTABLISHMENT_ID
957 ,P_COLLECTIVE_AGREEMENT_ID => L_COLLECTIVE_AGREEMENT_ID
958 ,P_CAGR_ID_FLEX_NUM => L_CAGR_ID_FLEX_NUM
959 ,P_CAG_SEGMENT1 => c.p60
960 ,P_CAG_SEGMENT2 => c.p61
961 ,P_CAG_SEGMENT3 => c.p62
962 ,P_CAG_SEGMENT4 => c.p63
963 ,P_CAG_SEGMENT5 => c.p64
964 ,P_CAG_SEGMENT6 => c.p65
965 ,P_CAG_SEGMENT7 => c.p66
966 ,P_CAG_SEGMENT8 => c.p67
967 ,P_CAG_SEGMENT9 => c.p68
968 ,P_CAG_SEGMENT10 => c.p69
969 ,P_CAG_SEGMENT11 => c.p70
970 ,P_CAG_SEGMENT12 => c.p71
971 ,P_CAG_SEGMENT13 => c.p72
972 ,P_CAG_SEGMENT14 => c.p73
973 ,P_CAG_SEGMENT15 => c.p74
974 ,P_CAG_SEGMENT16 => c.p75
975 ,P_CAG_SEGMENT17 => c.p76
976 ,P_CAG_SEGMENT18 => c.p77
977 ,P_CAG_SEGMENT19 => c.p78
978 ,P_CAG_SEGMENT20 => c.p79
979 ,P_NOTICE_PERIOD => c.p80
980 ,P_NOTICE_PERIOD_UOM => c.p81
981 ,P_EMPLOYEE_CATEGORY => c.p82
982 ,P_WORK_AT_HOME => c.p83
983 ,P_JOB_POST_SOURCE_NAME => c.p84
984 ,P_SUPERVISOR_ASSIGNMENT_ID => L_SUPERVISOR_ASSIGNMENT_ID
985 ,P_CAGR_GRADE_DEF_ID => c.p85
986 ,P_CAGR_CONCATENATED_SEGMENTS => c.p86
987 ,P_CONCATENATED_SEGMENTS => c.p87
988 ,P_SOFT_CODING_KEYFLEX_ID => L_SOFT_CODING_KEYFLEX_ID
989 ,P_COMMENT_ID => c.p88
990 ,P_EFFECTIVE_START_DATE => c.p89
991 ,P_EFFECTIVE_END_DATE => c.p90
992 ,P_NO_MANAGERS_WARNING => L_NO_MANAGERS_WARNING
993 ,P_OTHER_MANAGER_WARNING => L_OTHER_MANAGER_WARNING
994 ,P_HOURLY_SALARIED_WARNING => L_HOURLY_SALARIED_WARNING
995 ,P_GSP_POST_PROCESS_WARNING => c.p94);
996 hr_data_pump.api_trc_off;
997 --
998 if L_NO_MANAGERS_WARNING then
999 c.p91 := 'TRUE';
1000 else
1001 c.p91 := 'FALSE';
1002 end if;
1003 --
1004 if L_OTHER_MANAGER_WARNING then
1005 c.p92 := 'TRUE';
1006 else
1007 c.p92 := 'FALSE';
1008 end if;
1009 --
1010 if L_HOURLY_SALARIED_WARNING then
1014 end if;
1011 c.p93 := 'TRUE';
1012 else
1013 c.p93 := 'FALSE';
1015 --
1016 update hr_pump_batch_lines l set
1017 l.pval085 = decode(c.p85,null,cn,c.p85),
1018 l.pval086 = decode(c.p86,null,cn,c.p86),
1019 l.pval087 = decode(c.p87,null,cn,c.p87),
1020 l.pval088 = decode(c.p88,null,cn,c.p88),
1021 l.pval089 = decode(c.p89,null,cn,dc(c.p89)),
1022 l.pval090 = decode(c.p90,null,cn,dc(c.p90)),
1023 l.pval091 = decode(c.p91,null,cn,c.p91),
1024 l.pval092 = decode(c.p92,null,cn,c.p92),
1025 l.pval093 = decode(c.p93,null,cn,c.p93),
1026 l.pval094 = decode(c.p94,null,cn,c.p94)
1027 where l.rowid = c.myrowid;
1028 --
1029 close cr;
1030 --
1031 hr_data_pump.exit('call');
1032 exception
1033 when hr_multi_message.error_message_exist then
1034 if cr%isopen then
1035 close cr;
1036 end if;
1037 hr_pump_utils.set_multi_msg_error_flag(true);
1038 when others then
1039 if cr%isopen then
1040 close cr;
1041 end if;
1042 raise;
1043 end call;
1044 end hrdpp_update_in_emp_asg;