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