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