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