eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HRDPP_CREATE_RU_SECONDARY_EMP_

Source


1 package body hrdpp_CREATE_RU_SECONDARY_EMP_ as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:54
4  * Generated for API: HR_RU_ASSIGNMENT_API.CREATE_RU_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_START_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
113 ,P_ASS_ATTRIBUTE9 in varchar2 default null
114 ,P_ASS_ATTRIBUTE10 in varchar2 default null
115 ,P_ASS_ATTRIBUTE11 in varchar2 default null
116 ,P_ASS_ATTRIBUTE12 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_SEC_EMP in varchar2 default null
137 ,P_CONTRACT_NUMBER in varchar2 default null
138 ,P_ISSUE_DATE in date default null
139 ,P_CONT_END_DATE in date default null
140 ,P_LIMIT_REASON in varchar2 default null
141 ,P_END_REASON in varchar2 default null
142 ,P_TERRITORY_COND in varchar2 default null
143 ,P_SPL_WORK_COND in varchar2 default null
144 ,P_CSR in varchar2 default null
145 ,P_CSR_ADD_INFO in varchar2 default null
146 ,P_LSR in varchar2 default null
147 ,P_LSR_ADD_INFO in varchar2 default null
148 ,P_UNINT_SERVICE_REC in varchar2 default null
149 ,P_TOTAL_SERVICE_REC in varchar2 default null
150 ,P_PENSION_YEARS in varchar2 default null
151 ,P_PENSION_MONTHS in varchar2 default null
152 ,P_PENSION_DAYS in varchar2 default null
153 ,P_SCL_CONCAT_SEGMENTS in varchar2 default null
154 ,P_PGP_SEGMENT1 in varchar2 default null
155 ,P_PGP_SEGMENT2 in varchar2 default null
156 ,P_PGP_SEGMENT3 in varchar2 default null
157 ,P_PGP_SEGMENT4 in varchar2 default null
158 ,P_PGP_SEGMENT5 in varchar2 default null
159 ,P_PGP_SEGMENT6 in varchar2 default null
160 ,P_PGP_SEGMENT7 in varchar2 default null
161 ,P_PGP_SEGMENT8 in varchar2 default null
162 ,P_PGP_SEGMENT9 in varchar2 default null
163 ,P_PGP_SEGMENT10 in varchar2 default null
164 ,P_PGP_SEGMENT11 in varchar2 default null
165 ,P_PGP_SEGMENT12 in varchar2 default null
166 ,P_PGP_SEGMENT13 in varchar2 default null
167 ,P_PGP_SEGMENT14 in varchar2 default null
168 ,P_PGP_SEGMENT15 in varchar2 default null
169 ,P_PGP_SEGMENT16 in varchar2 default null
170 ,P_PGP_SEGMENT17 in varchar2 default null
171 ,P_PGP_SEGMENT18 in varchar2 default null
172 ,P_PGP_SEGMENT19 in varchar2 default null
173 ,P_PGP_SEGMENT20 in varchar2 default null
174 ,P_PGP_SEGMENT21 in varchar2 default null
175 ,P_PGP_SEGMENT22 in varchar2 default null
176 ,P_PGP_SEGMENT23 in varchar2 default null
177 ,P_PGP_SEGMENT24 in varchar2 default null
178 ,P_PGP_SEGMENT25 in varchar2 default null
179 ,P_PGP_SEGMENT26 in varchar2 default null
180 ,P_PGP_SEGMENT27 in varchar2 default null
181 ,P_PGP_SEGMENT28 in varchar2 default null
182 ,P_PGP_SEGMENT29 in varchar2 default null
183 ,P_PGP_SEGMENT30 in varchar2 default null
184 ,P_PGP_CONCAT_SEGMENTS in varchar2 default null
185 ,P_CAG_SEGMENT1 in varchar2 default null
186 ,P_CAG_SEGMENT2 in varchar2 default null
187 ,P_CAG_SEGMENT3 in varchar2 default null
188 ,P_CAG_SEGMENT4 in varchar2 default null
189 ,P_CAG_SEGMENT5 in varchar2 default null
190 ,P_CAG_SEGMENT6 in varchar2 default null
191 ,P_CAG_SEGMENT7 in varchar2 default null
192 ,P_CAG_SEGMENT8 in varchar2 default null
193 ,P_CAG_SEGMENT9 in varchar2 default null
194 ,P_CAG_SEGMENT10 in varchar2 default null
195 ,P_CAG_SEGMENT11 in varchar2 default null
196 ,P_CAG_SEGMENT12 in varchar2 default null
197 ,P_CAG_SEGMENT13 in varchar2 default null
198 ,P_CAG_SEGMENT14 in varchar2 default null
199 ,P_CAG_SEGMENT15 in varchar2 default null
200 ,P_CAG_SEGMENT16 in varchar2 default null
201 ,P_CAG_SEGMENT17 in varchar2 default null
202 ,P_CAG_SEGMENT18 in varchar2 default null
203 ,P_CAG_SEGMENT19 in varchar2 default null
204 ,P_CAG_SEGMENT20 in varchar2 default null
205 ,P_NOTICE_PERIOD in number default null
206 ,P_NOTICE_PERIOD_UOM in varchar2 default null
207 ,P_EMPLOYEE_CATEGORY in varchar2 default null
208 ,P_WORK_AT_HOME in varchar2 default null
209 ,P_JOB_POST_SOURCE_NAME in varchar2 default null
210 ,P_CAGR_GRADE_DEF_ID in number
211 ,P_ASSIGNMENT_USER_KEY in varchar2
212 ,P_PERSON_USER_KEY in varchar2
213 ,P_ORGANIZATION_NAME in varchar2
214 ,P_LANGUAGE_CODE in varchar2
215 ,P_GRADE_NAME in varchar2 default null
216 ,P_POSITION_NAME in varchar2 default null
217 ,P_JOB_NAME in varchar2 default null
218 ,P_USER_STATUS in varchar2 default null
219 ,P_PAYROLL_NAME in varchar2 default null
220 ,P_LOCATION_CODE in varchar2 default null
221 ,P_SUPERVISOR_USER_KEY in varchar2 default null
222 ,P_SPECIAL_CEILIN_STEP_USER_KEY in varchar2 default null
223 ,P_PAY_BASIS_NAME in varchar2 default null
224 ,P_DEFAULT_CODE_COMB_USER_KEY in varchar2 default null
225 ,P_SET_OF_BOOKS_NAME in varchar2 default null
226 ,P_EMPLOYER_NAME in varchar2 default null
227 ,P_CONTRACT_USER_KEY in varchar2 default null
228 ,P_ESTABLISHMENT_ORG_NAME in varchar2 default null
229 ,P_CAGR_NAME in varchar2 default null
230 ,P_CAGR_ID_FLEX_NUM_USER_KEY in varchar2 default null
231 ,P_GRADE_LADDER_NAME in varchar2 default null
232 ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
233 blid number := p_data_pump_batch_line_id;
234 begin
235 if blid is not null then
236 delete from hr_pump_batch_lines where batch_line_id = blid;
237 delete from hr_pump_batch_exceptions
238 where source_type = 'BATCH_LINE' and source_id = blid;
239 end if;
240 insert into hr_pump_batch_lines
241 (batch_id
242 ,batch_line_id
243 ,business_group_name
244 ,api_module_id
245 ,line_status
246 ,user_sequence
247 ,link_value
248 ,pval001
249 ,pval002
250 ,pval003
251 ,pval004
252 ,pval005
253 ,pval006
254 ,pval007
255 ,pval008
256 ,pval009
257 ,pval010
258 ,pval011
259 ,pval012
260 ,pval013
261 ,pval014
262 ,pval015
263 ,pval016
264 ,pval017
265 ,pval018
266 ,pval019
267 ,pval020
268 ,pval021
269 ,pval022
270 ,pval023
271 ,pval024
272 ,pval025
273 ,pval026
274 ,pval027
275 ,pval028
276 ,pval029
277 ,pval030
278 ,pval031
279 ,pval032
280 ,pval033
281 ,pval034
282 ,pval035
283 ,pval036
284 ,pval037
285 ,pval038
286 ,pval039
287 ,pval040
288 ,pval041
289 ,pval042
290 ,pval043
291 ,pval044
292 ,pval045
293 ,pval046
294 ,pval047
295 ,pval048
296 ,pval049
297 ,pval050
298 ,pval051
299 ,pval052
300 ,pval053
301 ,pval054
302 ,pval055
303 ,pval056
304 ,pval057
305 ,pval058
306 ,pval059
307 ,pval060
308 ,pval061
309 ,pval062
310 ,pval063
311 ,pval064
312 ,pval065
313 ,pval066
314 ,pval067
315 ,pval068
316 ,pval069
317 ,pval070
318 ,pval071
319 ,pval072
320 ,pval073
321 ,pval074
322 ,pval075
323 ,pval076
324 ,pval077
325 ,pval078
326 ,pval079
327 ,pval080
328 ,pval081
329 ,pval082
330 ,pval083
331 ,pval084
332 ,pval085
333 ,pval086
334 ,pval087
335 ,pval088
336 ,pval089
337 ,pval090
338 ,pval091
339 ,pval092
340 ,pval093
341 ,pval094
342 ,pval095
343 ,pval096
344 ,pval097
345 ,pval098
346 ,pval099
347 ,pval100
348 ,pval101
349 ,pval102
350 ,pval103
351 ,pval104
352 ,pval105
353 ,pval106
354 ,pval107
355 ,pval108
356 ,pval109
357 ,pval110
358 ,pval111
359 ,pval112
360 ,pval113
361 ,pval114
362 ,pval115
363 ,pval116
364 ,pval117
365 ,pval118
366 ,pval119
367 ,pval120
368 ,pval121
369 ,pval122
370 ,pval123
371 ,pval124
372 ,pval125
373 ,pval126
374 ,pval127
375 ,pval128
376 ,pval129
377 ,pval131
378 ,pval144
379 ,pval145
380 ,pval146
381 ,pval147
382 ,pval148
383 ,pval149
384 ,pval150
385 ,pval151
386 ,pval152
387 ,pval153
388 ,pval154
389 ,pval155
390 ,pval156
391 ,pval157
392 ,pval158
393 ,pval159
394 ,pval160
395 ,pval161
396 ,pval162
397 ,pval163
398 ,pval164)
399 values
400 (p_batch_id
401 ,nvl(blid,hr_pump_batch_lines_s.nextval)
402 ,p_data_pump_business_grp_name
403 ,3869
404 ,'U'
405 ,p_user_sequence
406 ,p_link_value
407 ,dc(P_EFFECTIVE_DATE)
408 ,P_ASSIGNMENT_NUMBER
409 ,P_START_REASON
410 ,P_COMMENTS
411 ,dc(P_DATE_PROBATION_END)
412 ,P_EMPLOYMENT_CATEGORY
413 ,P_FREQUENCY
414 ,P_INTERNAL_ADDRESS_LINE
415 ,P_MANAGER_FLAG
416 ,P_NORMAL_HOURS
417 ,P_PERF_REVIEW_PERIOD
418 ,P_PERF_REVIEW_PERIOD_FREQUENCY
419 ,P_PROBATION_PERIOD
420 ,P_PROBATION_UNIT
421 ,P_SAL_REVIEW_PERIOD
422 ,P_SAL_REVIEW_PERIOD_FREQUENCY
423 ,P_SOURCE_TYPE
424 ,P_TIME_NORMAL_FINISH
425 ,P_TIME_NORMAL_START
426 ,P_BARGAINING_UNIT_CODE
427 ,P_LABOUR_UNION_MEMBER_FLAG
428 ,P_HOURLY_SALARIED_CODE
429 ,P_ASS_ATTRIBUTE_CATEGORY
430 ,P_ASS_ATTRIBUTE1
431 ,P_ASS_ATTRIBUTE2
432 ,P_ASS_ATTRIBUTE3
433 ,P_ASS_ATTRIBUTE4
434 ,P_ASS_ATTRIBUTE5
435 ,P_ASS_ATTRIBUTE6
436 ,P_ASS_ATTRIBUTE7
437 ,P_ASS_ATTRIBUTE8
438 ,P_ASS_ATTRIBUTE9
439 ,P_ASS_ATTRIBUTE10
440 ,P_ASS_ATTRIBUTE11
441 ,P_ASS_ATTRIBUTE12
442 ,P_ASS_ATTRIBUTE13
443 ,P_ASS_ATTRIBUTE14
444 ,P_ASS_ATTRIBUTE15
445 ,P_ASS_ATTRIBUTE16
446 ,P_ASS_ATTRIBUTE17
447 ,P_ASS_ATTRIBUTE18
448 ,P_ASS_ATTRIBUTE19
449 ,P_ASS_ATTRIBUTE20
450 ,P_ASS_ATTRIBUTE21
451 ,P_ASS_ATTRIBUTE22
452 ,P_ASS_ATTRIBUTE23
453 ,P_ASS_ATTRIBUTE24
454 ,P_ASS_ATTRIBUTE25
455 ,P_ASS_ATTRIBUTE26
456 ,P_ASS_ATTRIBUTE27
457 ,P_ASS_ATTRIBUTE28
458 ,P_ASS_ATTRIBUTE29
459 ,P_ASS_ATTRIBUTE30
460 ,P_TITLE
461 ,P_SEC_EMP
462 ,P_CONTRACT_NUMBER
463 ,dc(P_ISSUE_DATE)
464 ,dc(P_CONT_END_DATE)
465 ,P_LIMIT_REASON
466 ,P_END_REASON
467 ,P_TERRITORY_COND
468 ,P_SPL_WORK_COND
469 ,P_CSR
470 ,P_CSR_ADD_INFO
471 ,P_LSR
472 ,P_LSR_ADD_INFO
473 ,P_UNINT_SERVICE_REC
474 ,P_TOTAL_SERVICE_REC
475 ,P_PENSION_YEARS
476 ,P_PENSION_MONTHS
477 ,P_PENSION_DAYS
478 ,P_SCL_CONCAT_SEGMENTS
479 ,P_PGP_SEGMENT1
480 ,P_PGP_SEGMENT2
481 ,P_PGP_SEGMENT3
482 ,P_PGP_SEGMENT4
483 ,P_PGP_SEGMENT5
484 ,P_PGP_SEGMENT6
485 ,P_PGP_SEGMENT7
486 ,P_PGP_SEGMENT8
487 ,P_PGP_SEGMENT9
488 ,P_PGP_SEGMENT10
489 ,P_PGP_SEGMENT11
490 ,P_PGP_SEGMENT12
491 ,P_PGP_SEGMENT13
492 ,P_PGP_SEGMENT14
493 ,P_PGP_SEGMENT15
494 ,P_PGP_SEGMENT16
495 ,P_PGP_SEGMENT17
496 ,P_PGP_SEGMENT18
497 ,P_PGP_SEGMENT19
498 ,P_PGP_SEGMENT20
499 ,P_PGP_SEGMENT21
500 ,P_PGP_SEGMENT22
501 ,P_PGP_SEGMENT23
502 ,P_PGP_SEGMENT24
503 ,P_PGP_SEGMENT25
504 ,P_PGP_SEGMENT26
505 ,P_PGP_SEGMENT27
506 ,P_PGP_SEGMENT28
507 ,P_PGP_SEGMENT29
508 ,P_PGP_SEGMENT30
509 ,P_PGP_CONCAT_SEGMENTS
510 ,P_CAG_SEGMENT1
511 ,P_CAG_SEGMENT2
512 ,P_CAG_SEGMENT3
513 ,P_CAG_SEGMENT4
514 ,P_CAG_SEGMENT5
515 ,P_CAG_SEGMENT6
516 ,P_CAG_SEGMENT7
517 ,P_CAG_SEGMENT8
518 ,P_CAG_SEGMENT9
519 ,P_CAG_SEGMENT10
520 ,P_CAG_SEGMENT11
521 ,P_CAG_SEGMENT12
522 ,P_CAG_SEGMENT13
523 ,P_CAG_SEGMENT14
524 ,P_CAG_SEGMENT15
525 ,P_CAG_SEGMENT16
526 ,P_CAG_SEGMENT17
527 ,P_CAG_SEGMENT18
528 ,P_CAG_SEGMENT19
529 ,P_CAG_SEGMENT20
530 ,P_NOTICE_PERIOD
531 ,P_NOTICE_PERIOD_UOM
535 ,P_CAGR_GRADE_DEF_ID
532 ,P_EMPLOYEE_CATEGORY
533 ,P_WORK_AT_HOME
534 ,P_JOB_POST_SOURCE_NAME
536 ,P_ASSIGNMENT_USER_KEY
537 ,P_PERSON_USER_KEY
538 ,P_ORGANIZATION_NAME
539 ,P_LANGUAGE_CODE
540 ,P_GRADE_NAME
541 ,P_POSITION_NAME
542 ,P_JOB_NAME
543 ,P_USER_STATUS
544 ,P_PAYROLL_NAME
545 ,P_LOCATION_CODE
546 ,P_SUPERVISOR_USER_KEY
547 ,P_SPECIAL_CEILIN_STEP_USER_KEY
548 ,P_PAY_BASIS_NAME
549 ,P_DEFAULT_CODE_COMB_USER_KEY
550 ,P_SET_OF_BOOKS_NAME
551 ,P_EMPLOYER_NAME
552 ,P_CONTRACT_USER_KEY
553 ,P_ESTABLISHMENT_ORG_NAME
554 ,P_CAGR_NAME
555 ,P_CAGR_ID_FLEX_NUM_USER_KEY
556 ,P_GRADE_LADDER_NAME
557 ,P_SVR_ASSIGNMENT_USER_KEY);
558 end insert_batch_lines;
559 --
560 procedure call
561 (p_business_group_id in number,
562 p_batch_line_id     in number) is
563 cursor cr is
564 select l.rowid myrowid,
565 decode(l.pval001,cn,dn,d(l.pval001)) p1,
566 decode(l.pval002,cn,vn,l.pval002) p2,
567 decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
568 l.pval003 d3,
569 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
570 l.pval004 d4,
571 decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
572 l.pval005 d5,
573 decode(l.pval006,cn,vn,vn,vn,
574  hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval146)) p6,
575 l.pval006 d6,
576 decode(l.pval007,cn,vn,vn,vn,
577  hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval146)) p7,
578 l.pval007 d7,
579 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
580 l.pval008 d8,
581 decode(l.pval009,cn,vn,vn,vn,
582  hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval146)) p9,
583 l.pval009 d9,
584 decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
585 l.pval010 d10,
586 decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
587 l.pval011 d11,
588 decode(l.pval012,cn,vn,vn,vn,
589  hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval146)) p12,
590 l.pval012 d12,
591 decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
592 l.pval013 d13,
593 decode(l.pval014,cn,vn,vn,vn,
594  hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval146)) p14,
595 l.pval014 d14,
596 decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
597 l.pval015 d15,
598 decode(l.pval016,cn,vn,vn,vn,
599  hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval146)) p16,
600 l.pval016 d16,
601 decode(l.pval017,cn,vn,vn,vn,
602  hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval146)) p17,
603 l.pval017 d17,
604 decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
605 l.pval018 d18,
606 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
607 l.pval019 d19,
608 decode(l.pval020,cn,vn,vn,vn,
609  hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval146)) p20,
610 l.pval020 d20,
611 decode(l.pval021,cn,vn,vn,'N',
612  hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval146)) p21,
613 l.pval021 d21,
614 decode(l.pval022,cn,vn,vn,vn,
615  hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval146)) p22,
616 l.pval022 d22,
617 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
618 l.pval023 d23,
619 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
620 l.pval024 d24,
621 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
622 l.pval025 d25,
623 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
624 l.pval026 d26,
625 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
626 l.pval027 d27,
627 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
628 l.pval028 d28,
629 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
630 l.pval029 d29,
631 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
632 l.pval030 d30,
633 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
634 l.pval031 d31,
635 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
636 l.pval032 d32,
637 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
638 l.pval033 d33,
639 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
640 l.pval034 d34,
641 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
642 l.pval035 d35,
643 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
644 l.pval036 d36,
645 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
646 l.pval037 d37,
647 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
648 l.pval038 d38,
649 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
650 l.pval039 d39,
651 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
652 l.pval040 d40,
653 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
654 l.pval041 d41,
655 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
656 l.pval042 d42,
657 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
658 l.pval043 d43,
659 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
660 l.pval044 d44,
661 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
662 l.pval045 d45,
663 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
664 l.pval046 d46,
665 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
666 l.pval047 d47,
667 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
668 l.pval048 d48,
669 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
670 l.pval049 d49,
671 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
672 l.pval050 d50,
673 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
674 l.pval051 d51,
675 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
676 l.pval052 d52,
677 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
678 l.pval053 d53,
679 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
680 l.pval054 d54,
681 decode(l.pval055,cn,vn,vn,vn,
682  hr_pump_get.gl(l.pval055,'YES_NO',d(l.pval001),l.pval146)) p55,
683 l.pval055 d55,
684 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
685 l.pval056 d56,
686 decode(l.pval057,cn,dn,vn,dn,d(l.pval057)) p57,
687 l.pval057 d57,
688 decode(l.pval058,cn,dn,vn,dn,d(l.pval058)) p58,
689 l.pval058 d58,
690 decode(l.pval059,cn,vn,vn,vn,
691  hr_pump_get.gl(l.pval059,'RU_LIMITED_CONTRACT_REASON',d(l.pval001),l.pval146)) p59,
692 l.pval059 d59,
696 decode(l.pval061,cn,vn,vn,vn,
693 decode(l.pval060,cn,vn,vn,vn,
694  hr_pump_get.gl(l.pval060,'LEAV_REAS',d(l.pval001),l.pval146)) p60,
695 l.pval060 d60,
697  hr_pump_get.gl(l.pval061,'RU_TERRITORY_CONDITIONS',d(l.pval001),l.pval146)) p61,
698 l.pval061 d61,
699 decode(l.pval062,cn,vn,vn,vn,
700  hr_pump_get.gl(l.pval062,'RU_SPECIAL_WORK_CONDITIONS',d(l.pval001),l.pval146)) p62,
701 l.pval062 d62,
702 decode(l.pval063,cn,vn,vn,vn,
703  hr_pump_get.gl(l.pval063,'RU_CALC_RECORD_SERVICE',d(l.pval001),l.pval146)) p63,
704 l.pval063 d63,
705 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
706 l.pval064 d64,
707 decode(l.pval065,cn,vn,vn,vn,
708  hr_pump_get.gl(l.pval065,'RU_LONG_SERVICE',d(l.pval001),l.pval146)) p65,
709 l.pval065 d65,
710 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
711 l.pval066 d66,
712 decode(l.pval067,cn,vn,vn,vn,
713  hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval146)) p67,
714 l.pval067 d67,
715 decode(l.pval068,cn,vn,vn,vn,
716  hr_pump_get.gl(l.pval068,'YES_NO',d(l.pval001),l.pval146)) p68,
717 l.pval068 d68,
718 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
719 l.pval069 d69,
720 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
721 l.pval070 d70,
722 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
723 l.pval071 d71,
724 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
725 l.pval072 d72,
726 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
727 l.pval073 d73,
728 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
729 l.pval074 d74,
730 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
731 l.pval075 d75,
732 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
733 l.pval076 d76,
734 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
735 l.pval077 d77,
736 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
737 l.pval078 d78,
738 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
739 l.pval079 d79,
740 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
741 l.pval080 d80,
742 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
743 l.pval081 d81,
744 decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
745 l.pval082 d82,
746 decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
747 l.pval083 d83,
748 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
749 l.pval084 d84,
750 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
751 l.pval085 d85,
752 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
753 l.pval086 d86,
754 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
755 l.pval087 d87,
756 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
757 l.pval088 d88,
758 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
759 l.pval089 d89,
760 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
761 l.pval090 d90,
762 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
763 l.pval091 d91,
764 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
765 l.pval092 d92,
766 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
767 l.pval093 d93,
768 decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
769 l.pval094 d94,
770 decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
771 l.pval095 d95,
772 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
773 l.pval096 d96,
774 decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
775 l.pval097 d97,
776 decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
777 l.pval098 d98,
778 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
779 l.pval099 d99,
780 decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
781 l.pval100 d100,
782 decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
783 l.pval101 d101,
784 decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
785 l.pval102 d102,
786 decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
787 l.pval103 d103,
788 decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
789 l.pval104 d104,
790 decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
791 l.pval105 d105,
792 decode(l.pval106,cn,vn,vn,vn,l.pval106) p106,
793 l.pval106 d106,
794 decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
795 l.pval107 d107,
796 decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
797 l.pval108 d108,
798 decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
799 l.pval109 d109,
800 decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
801 l.pval110 d110,
802 decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
803 l.pval111 d111,
804 decode(l.pval112,cn,vn,vn,vn,l.pval112) p112,
805 l.pval112 d112,
806 decode(l.pval113,cn,vn,vn,vn,l.pval113) p113,
807 l.pval113 d113,
808 decode(l.pval114,cn,vn,vn,vn,l.pval114) p114,
809 l.pval114 d114,
810 decode(l.pval115,cn,vn,vn,vn,l.pval115) p115,
811 l.pval115 d115,
812 decode(l.pval116,cn,vn,vn,vn,l.pval116) p116,
813 l.pval116 d116,
814 decode(l.pval117,cn,vn,vn,vn,l.pval117) p117,
815 l.pval117 d117,
816 decode(l.pval118,cn,vn,vn,vn,l.pval118) p118,
817 l.pval118 d118,
818 decode(l.pval119,cn,vn,vn,vn,l.pval119) p119,
819 l.pval119 d119,
820 decode(l.pval120,cn,vn,vn,vn,l.pval120) p120,
821 l.pval120 d120,
822 decode(l.pval121,cn,vn,vn,vn,l.pval121) p121,
823 l.pval121 d121,
824 decode(l.pval122,cn,vn,vn,vn,l.pval122) p122,
825 l.pval122 d122,
826 decode(l.pval123,cn,vn,vn,vn,l.pval123) p123,
827 l.pval123 d123,
828 decode(l.pval124,cn,nn,vn,nn,n(l.pval124)) p124,
829 l.pval124 d124,
830 decode(l.pval125,cn,vn,vn,vn,l.pval125) p125,
831 l.pval125 d125,
832 decode(l.pval126,cn,vn,vn,vn,l.pval126) p126,
833 l.pval126 d126,
834 decode(l.pval127,cn,vn,vn,vn,l.pval127) p127,
835 l.pval127 d127,
836 decode(l.pval128,cn,vn,vn,vn,l.pval128) p128,
837 l.pval128 d128,
838 decode(l.pval129,cn,nn,n(l.pval129)) p129,
839 l.pval130 p130,
840 l.pval131 p131,
841 l.pval132 p132,
842 l.pval133 p133,
843 l.pval134 p134,
844 decode(l.pval135,cn,dn,d(l.pval135)) p135,
845 decode(l.pval136,cn,dn,d(l.pval136)) p136,
846 l.pval137 p137,
847 l.pval138 p138,
848 l.pval139 p139,
849 l.pval140 p140,
850 l.pval141 p141,
854 decode(l.pval145,cn,vn,l.pval145) p145,
851 l.pval142 p142,
852 l.pval143 p143,
853 decode(l.pval144,cn,vn,l.pval144) p144,
855 decode(l.pval146,cn,vn,l.pval146) p146,
856 decode(l.pval147,cn,vn,vn,vn,l.pval147) p147,
857 l.pval147 d147,
858 decode(l.pval148,cn,vn,vn,vn,l.pval148) p148,
859 l.pval148 d148,
860 decode(l.pval149,cn,vn,vn,vn,l.pval149) p149,
861 l.pval149 d149,
862 decode(l.pval150,cn,vn,vn,vn,l.pval150) p150,
863 l.pval150 d150,
864 decode(l.pval151,cn,vn,vn,vn,l.pval151) p151,
865 l.pval151 d151,
866 decode(l.pval152,cn,vn,vn,vn,l.pval152) p152,
867 l.pval152 d152,
868 decode(l.pval153,cn,vn,vn,vn,l.pval153) p153,
869 l.pval153 d153,
870 decode(l.pval154,cn,vn,vn,vn,l.pval154) p154,
871 l.pval154 d154,
872 decode(l.pval155,cn,vn,vn,vn,l.pval155) p155,
873 l.pval155 d155,
874 decode(l.pval156,cn,vn,vn,vn,l.pval156) p156,
875 l.pval156 d156,
876 decode(l.pval157,cn,vn,vn,vn,l.pval157) p157,
877 l.pval157 d157,
878 decode(l.pval158,cn,vn,vn,vn,l.pval158) p158,
879 l.pval158 d158,
880 decode(l.pval159,cn,vn,vn,vn,l.pval159) p159,
881 l.pval159 d159,
882 decode(l.pval160,cn,vn,vn,vn,l.pval160) p160,
883 l.pval160 d160,
884 decode(l.pval161,cn,vn,vn,vn,l.pval161) p161,
885 l.pval161 d161,
886 decode(l.pval162,cn,vn,vn,vn,l.pval162) p162,
887 l.pval162 d162,
888 decode(l.pval163,cn,vn,vn,vn,l.pval163) p163,
889 l.pval163 d163,
890 decode(l.pval164,cn,vn,vn,vn,l.pval164) p164,
891 l.pval164 d164
892 from hr_pump_batch_lines l
893 where l.batch_line_id = p_batch_line_id;
894 --
895 c cr%rowtype;
896 l_validate boolean := false;
897 L_ASSIGNMENT_ID number;
898 L_OTHER_MANAGER_WARNING boolean;
899 L_HOURLY_SALARIED_WARNING boolean;
900 L_PERSON_ID number;
901 L_ORGANIZATION_ID number;
902 L_GRADE_ID number;
903 L_POSITION_ID number;
904 L_JOB_ID number;
905 L_ASSIGNMENT_STATUS_TYPE_ID number;
906 L_PAYROLL_ID number;
907 L_LOCATION_ID number;
908 L_SUPERVISOR_ID number;
909 L_SPECIAL_CEILING_STEP_ID number;
910 L_PAY_BASIS_ID number;
911 L_DEFAULT_CODE_COMB_ID number;
912 L_SET_OF_BOOKS_ID number;
913 L_EMPLOYER varchar2(2000);
914 L_CONTRACT_ID number;
915 L_ESTABLISHMENT_ID number;
916 L_COLLECTIVE_AGREEMENT_ID number;
917 L_CAGR_ID_FLEX_NUM number;
918 L_GRADE_LADDER_PGM_ID number;
919 L_SUPERVISOR_ASSIGNMENT_ID number;
920 --
921 begin
922 hr_data_pump.entry('call');
923 open cr;
924 fetch cr into c;
925 if cr%notfound then
926 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
927 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
928 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
929 hr_utility.set_message_token('VALUE',p_batch_line_id);
930 hr_utility.raise_error;
931 end if;
932 --
933 if c.p144 is null then
934 L_PERSON_ID:=nn;
935 else
936 L_PERSON_ID := 
937 hr_pump_get.get_person_id
938 (P_PERSON_USER_KEY => c.p144);
939 end if;
940 --
941 if c.p145 is null or
942 c.p1 is null or
943 c.p146 is null then
944 L_ORGANIZATION_ID:=nn;
945 else
946 L_ORGANIZATION_ID := 
947 hr_pump_get.get_organization_id
948 (P_ORGANIZATION_NAME => c.p145
949 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
950 ,P_EFFECTIVE_DATE => c.p1
951 ,P_LANGUAGE_CODE => c.p146);
952 end if;
953 --
954 if c.p147 is null or
955 c.p1 is null then
956 L_GRADE_ID:=nn;
957 else
958 L_GRADE_ID := 
959 hr_pump_get.get_grade_id
960 (P_GRADE_NAME => c.p147
961 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
962 ,P_EFFECTIVE_DATE => c.p1);
963 end if;
964 --
965 if c.p148 is null or
966 c.p1 is null then
967 L_POSITION_ID:=nn;
968 else
969 L_POSITION_ID := 
970 hr_pump_get.get_position_id
971 (P_POSITION_NAME => c.p148
972 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
973 ,P_EFFECTIVE_DATE => c.p1);
974 end if;
975 --
976 if c.p149 is null or
977 c.p1 is null then
978 L_JOB_ID:=nn;
979 else
980 L_JOB_ID := 
981 hr_pump_get.get_job_id
982 (P_JOB_NAME => c.p149
983 ,P_EFFECTIVE_DATE => c.p1
984 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
985 end if;
986 --
987 if c.p150 is null or
988 c.p146 is null then
989 L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
990 else
991 L_ASSIGNMENT_STATUS_TYPE_ID := 
992 hr_pump_get.get_assignment_status_type_id
993 (P_USER_STATUS => c.p150
994 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
995 ,P_LANGUAGE_CODE => c.p146);
996 end if;
997 --
998 if c.p151 is null or
999 c.p1 is null then
1000 L_PAYROLL_ID:=nn;
1001 else
1002 L_PAYROLL_ID := 
1003 hr_pump_get.get_payroll_id
1004 (P_PAYROLL_NAME => c.p151
1005 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1006 ,P_EFFECTIVE_DATE => c.p1);
1007 end if;
1008 --
1009 if c.p152 is null or
1010 c.p146 is null then
1011 L_LOCATION_ID:=nn;
1012 else
1013 L_LOCATION_ID := 
1014 hr_pump_get.get_location_id
1015 (P_LOCATION_CODE => c.p152
1016 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1017 ,P_LANGUAGE_CODE => c.p146);
1018 end if;
1019 --
1020 if c.p153 is null then
1021 L_SUPERVISOR_ID:=nn;
1022 else
1023 L_SUPERVISOR_ID := 
1024 hr_pump_get.get_supervisor_id
1025 (P_SUPERVISOR_USER_KEY => c.p153);
1026 end if;
1027 --
1028 if c.p154 is null then
1029 L_SPECIAL_CEILING_STEP_ID:=nn;
1030 else
1031 L_SPECIAL_CEILING_STEP_ID := 
1032 hr_pump_get.get_special_ceiling_step_id
1033 (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p154);
1034 end if;
1035 --
1036 if c.p155 is null then
1037 L_PAY_BASIS_ID:=nn;
1038 else
1042 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1039 L_PAY_BASIS_ID := 
1040 hr_pump_get.get_pay_basis_id
1041 (P_PAY_BASIS_NAME => c.p155
1043 end if;
1044 --
1045 if c.p156 is null then
1046 L_DEFAULT_CODE_COMB_ID:=nn;
1047 else
1048 L_DEFAULT_CODE_COMB_ID := 
1049 hr_pump_get.get_default_code_comb_id
1050 (P_DEFAULT_CODE_COMB_USER_KEY => c.p156);
1051 end if;
1052 --
1053 if c.p157 is null then
1054 L_SET_OF_BOOKS_ID:=nn;
1055 else
1056 L_SET_OF_BOOKS_ID := 
1057 hr_pump_get.get_set_of_books_id
1058 (P_SET_OF_BOOKS_NAME => c.p157);
1059 end if;
1060 --
1061 if c.p158 is null or
1062 c.p1 is null or
1063 c.p146 is null then
1064 L_EMPLOYER:=vn;
1065 else
1066 L_EMPLOYER := 
1067 PER_RU_DATA_PUMP.GET_EMPLOYER_ID
1068 (P_EMPLOYER_NAME => c.p158
1069 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1070 ,P_EFFECTIVE_DATE => c.p1
1071 ,P_LANGUAGE_CODE => c.p146);
1072 end if;
1073 --
1074 if c.p159 is null then
1075 L_CONTRACT_ID:=nn;
1076 else
1077 L_CONTRACT_ID := 
1078 hr_pump_get.get_contract_id
1079 (P_CONTRACT_USER_KEY => c.p159);
1080 end if;
1081 --
1082 if c.p160 is null or
1083 c.p1 is null or
1084 c.p146 is null then
1085 L_ESTABLISHMENT_ID:=nn;
1086 else
1087 L_ESTABLISHMENT_ID := 
1088 hr_pump_get.GET_ESTABLISHMENT_ORG_ID
1089 (P_ESTABLISHMENT_ORG_NAME => c.p160
1090 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1091 ,P_EFFECTIVE_DATE => c.p1
1092 ,P_LANGUAGE_CODE => c.p146);
1093 end if;
1094 --
1095 if c.p161 is null or
1096 c.p1 is null then
1097 L_COLLECTIVE_AGREEMENT_ID:=nn;
1098 else
1099 L_COLLECTIVE_AGREEMENT_ID := 
1100 hr_pump_get.get_collective_agreement_id
1101 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1102 ,P_CAGR_NAME => c.p161
1103 ,P_EFFECTIVE_DATE => c.p1);
1104 end if;
1105 --
1106 if c.p162 is null then
1107 L_CAGR_ID_FLEX_NUM:=nn;
1108 else
1109 L_CAGR_ID_FLEX_NUM := 
1110 hr_pump_get.GET_CAGR_ID_FLEX_NUM
1111 (P_CAGR_ID_FLEX_NUM_USER_KEY => c.p162);
1112 end if;
1113 --
1114 if c.p163 is null or
1115 c.p1 is null then
1116 L_GRADE_LADDER_PGM_ID:=nn;
1117 else
1118 L_GRADE_LADDER_PGM_ID := 
1119 hr_pump_get.get_grade_ladder_pgm_id
1120 (P_GRADE_LADDER_NAME => c.p163
1121 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1122 ,P_EFFECTIVE_DATE => c.p1);
1123 end if;
1124 --
1125 if c.p164 is null then
1126 L_SUPERVISOR_ASSIGNMENT_ID:=nn;
1127 else
1128 L_SUPERVISOR_ASSIGNMENT_ID := 
1129 hr_pump_get.get_supervisor_assignment_id
1130 (P_SVR_ASSIGNMENT_USER_KEY => c.p164);
1131 end if;
1132 --
1133 hr_data_pump.api_trc_on;
1134 HR_RU_ASSIGNMENT_API.CREATE_RU_SECONDARY_EMP_ASG
1135 (p_validate => l_validate
1136 ,P_EFFECTIVE_DATE => c.p1
1137 ,P_PERSON_ID => L_PERSON_ID
1138 ,P_ORGANIZATION_ID => L_ORGANIZATION_ID
1139 ,P_GRADE_ID => L_GRADE_ID
1140 ,P_POSITION_ID => L_POSITION_ID
1141 ,P_JOB_ID => L_JOB_ID
1142 ,P_ASSIGNMENT_STATUS_TYPE_ID => L_ASSIGNMENT_STATUS_TYPE_ID
1143 ,P_PAYROLL_ID => L_PAYROLL_ID
1144 ,P_LOCATION_ID => L_LOCATION_ID
1145 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
1146 ,P_SPECIAL_CEILING_STEP_ID => L_SPECIAL_CEILING_STEP_ID
1147 ,P_PAY_BASIS_ID => L_PAY_BASIS_ID
1148 ,P_ASSIGNMENT_NUMBER => c.p2
1149 ,P_START_REASON => c.p3
1150 ,P_COMMENTS => c.p4
1151 ,P_DATE_PROBATION_END => c.p5
1152 ,P_DEFAULT_CODE_COMB_ID => L_DEFAULT_CODE_COMB_ID
1153 ,P_EMPLOYMENT_CATEGORY => c.p6
1154 ,P_FREQUENCY => c.p7
1155 ,P_INTERNAL_ADDRESS_LINE => c.p8
1156 ,P_MANAGER_FLAG => c.p9
1157 ,P_NORMAL_HOURS => c.p10
1158 ,P_PERF_REVIEW_PERIOD => c.p11
1159 ,P_PERF_REVIEW_PERIOD_FREQUENCY => c.p12
1160 ,P_PROBATION_PERIOD => c.p13
1161 ,P_PROBATION_UNIT => c.p14
1162 ,P_SAL_REVIEW_PERIOD => c.p15
1163 ,P_SAL_REVIEW_PERIOD_FREQUENCY => c.p16
1164 ,P_SET_OF_BOOKS_ID => L_SET_OF_BOOKS_ID
1165 ,P_SOURCE_TYPE => c.p17
1166 ,P_TIME_NORMAL_FINISH => c.p18
1167 ,P_TIME_NORMAL_START => c.p19
1168 ,P_BARGAINING_UNIT_CODE => c.p20
1169 ,P_LABOUR_UNION_MEMBER_FLAG => c.p21
1170 ,P_HOURLY_SALARIED_CODE => c.p22
1171 ,P_ASS_ATTRIBUTE_CATEGORY => c.p23
1172 ,P_ASS_ATTRIBUTE1 => c.p24
1173 ,P_ASS_ATTRIBUTE2 => c.p25
1174 ,P_ASS_ATTRIBUTE3 => c.p26
1175 ,P_ASS_ATTRIBUTE4 => c.p27
1176 ,P_ASS_ATTRIBUTE5 => c.p28
1177 ,P_ASS_ATTRIBUTE6 => c.p29
1178 ,P_ASS_ATTRIBUTE7 => c.p30
1179 ,P_ASS_ATTRIBUTE8 => c.p31
1180 ,P_ASS_ATTRIBUTE9 => c.p32
1181 ,P_ASS_ATTRIBUTE10 => c.p33
1182 ,P_ASS_ATTRIBUTE11 => c.p34
1183 ,P_ASS_ATTRIBUTE12 => c.p35
1184 ,P_ASS_ATTRIBUTE13 => c.p36
1185 ,P_ASS_ATTRIBUTE14 => c.p37
1186 ,P_ASS_ATTRIBUTE15 => c.p38
1187 ,P_ASS_ATTRIBUTE16 => c.p39
1188 ,P_ASS_ATTRIBUTE17 => c.p40
1189 ,P_ASS_ATTRIBUTE18 => c.p41
1190 ,P_ASS_ATTRIBUTE19 => c.p42
1191 ,P_ASS_ATTRIBUTE20 => c.p43
1192 ,P_ASS_ATTRIBUTE21 => c.p44
1193 ,P_ASS_ATTRIBUTE22 => c.p45
1194 ,P_ASS_ATTRIBUTE23 => c.p46
1195 ,P_ASS_ATTRIBUTE24 => c.p47
1196 ,P_ASS_ATTRIBUTE25 => c.p48
1197 ,P_ASS_ATTRIBUTE26 => c.p49
1198 ,P_ASS_ATTRIBUTE27 => c.p50
1199 ,P_ASS_ATTRIBUTE28 => c.p51
1200 ,P_ASS_ATTRIBUTE29 => c.p52
1201 ,P_ASS_ATTRIBUTE30 => c.p53
1202 ,P_TITLE => c.p54
1203 ,P_EMPLOYER => L_EMPLOYER
1204 ,P_SEC_EMP => c.p55
1205 ,P_CONTRACT_NUMBER => c.p56
1206 ,P_ISSUE_DATE => c.p57
1207 ,P_CONT_END_DATE => c.p58
1208 ,P_LIMIT_REASON => c.p59
1209 ,P_END_REASON => c.p60
1210 ,P_TERRITORY_COND => c.p61
1211 ,P_SPL_WORK_COND => c.p62
1212 ,P_CSR => c.p63
1213 ,P_CSR_ADD_INFO => c.p64
1214 ,P_LSR => c.p65
1215 ,P_LSR_ADD_INFO => c.p66
1216 ,P_UNINT_SERVICE_REC => c.p67
1217 ,P_TOTAL_SERVICE_REC => c.p68
1218 ,P_PENSION_YEARS => c.p69
1219 ,P_PENSION_MONTHS => c.p70
1220 ,P_PENSION_DAYS => c.p71
1224 ,P_PGP_SEGMENT3 => c.p75
1221 ,P_SCL_CONCAT_SEGMENTS => c.p72
1222 ,P_PGP_SEGMENT1 => c.p73
1223 ,P_PGP_SEGMENT2 => c.p74
1225 ,P_PGP_SEGMENT4 => c.p76
1226 ,P_PGP_SEGMENT5 => c.p77
1227 ,P_PGP_SEGMENT6 => c.p78
1228 ,P_PGP_SEGMENT7 => c.p79
1229 ,P_PGP_SEGMENT8 => c.p80
1230 ,P_PGP_SEGMENT9 => c.p81
1231 ,P_PGP_SEGMENT10 => c.p82
1232 ,P_PGP_SEGMENT11 => c.p83
1233 ,P_PGP_SEGMENT12 => c.p84
1234 ,P_PGP_SEGMENT13 => c.p85
1235 ,P_PGP_SEGMENT14 => c.p86
1236 ,P_PGP_SEGMENT15 => c.p87
1237 ,P_PGP_SEGMENT16 => c.p88
1238 ,P_PGP_SEGMENT17 => c.p89
1239 ,P_PGP_SEGMENT18 => c.p90
1240 ,P_PGP_SEGMENT19 => c.p91
1241 ,P_PGP_SEGMENT20 => c.p92
1242 ,P_PGP_SEGMENT21 => c.p93
1243 ,P_PGP_SEGMENT22 => c.p94
1244 ,P_PGP_SEGMENT23 => c.p95
1245 ,P_PGP_SEGMENT24 => c.p96
1246 ,P_PGP_SEGMENT25 => c.p97
1247 ,P_PGP_SEGMENT26 => c.p98
1248 ,P_PGP_SEGMENT27 => c.p99
1249 ,P_PGP_SEGMENT28 => c.p100
1250 ,P_PGP_SEGMENT29 => c.p101
1251 ,P_PGP_SEGMENT30 => c.p102
1252 ,P_PGP_CONCAT_SEGMENTS => c.p103
1253 ,P_CONTRACT_ID => L_CONTRACT_ID
1254 ,P_ESTABLISHMENT_ID => L_ESTABLISHMENT_ID
1255 ,P_COLLECTIVE_AGREEMENT_ID => L_COLLECTIVE_AGREEMENT_ID
1256 ,P_CAGR_ID_FLEX_NUM => L_CAGR_ID_FLEX_NUM
1257 ,P_CAG_SEGMENT1 => c.p104
1258 ,P_CAG_SEGMENT2 => c.p105
1259 ,P_CAG_SEGMENT3 => c.p106
1260 ,P_CAG_SEGMENT4 => c.p107
1261 ,P_CAG_SEGMENT5 => c.p108
1262 ,P_CAG_SEGMENT6 => c.p109
1263 ,P_CAG_SEGMENT7 => c.p110
1264 ,P_CAG_SEGMENT8 => c.p111
1265 ,P_CAG_SEGMENT9 => c.p112
1266 ,P_CAG_SEGMENT10 => c.p113
1267 ,P_CAG_SEGMENT11 => c.p114
1268 ,P_CAG_SEGMENT12 => c.p115
1269 ,P_CAG_SEGMENT13 => c.p116
1270 ,P_CAG_SEGMENT14 => c.p117
1271 ,P_CAG_SEGMENT15 => c.p118
1272 ,P_CAG_SEGMENT16 => c.p119
1273 ,P_CAG_SEGMENT17 => c.p120
1274 ,P_CAG_SEGMENT18 => c.p121
1275 ,P_CAG_SEGMENT19 => c.p122
1276 ,P_CAG_SEGMENT20 => c.p123
1277 ,P_NOTICE_PERIOD => c.p124
1278 ,P_NOTICE_PERIOD_UOM => c.p125
1279 ,P_EMPLOYEE_CATEGORY => c.p126
1280 ,P_WORK_AT_HOME => c.p127
1281 ,P_JOB_POST_SOURCE_NAME => c.p128
1282 ,P_GRADE_LADDER_PGM_ID => L_GRADE_LADDER_PGM_ID
1283 ,P_SUPERVISOR_ASSIGNMENT_ID => L_SUPERVISOR_ASSIGNMENT_ID
1284 ,P_CAGR_GRADE_DEF_ID => c.p129
1285 ,P_CAGR_CONCATENATED_SEGMENTS => c.p130
1286 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
1287 ,P_SOFT_CODING_KEYFLEX_ID => c.p132
1288 ,P_PEOPLE_GROUP_ID => c.p133
1289 ,P_OBJECT_VERSION_NUMBER => c.p134
1290 ,P_EFFECTIVE_START_DATE => c.p135
1291 ,P_EFFECTIVE_END_DATE => c.p136
1292 ,P_ASSIGNMENT_SEQUENCE => c.p137
1293 ,P_COMMENT_ID => c.p138
1294 ,P_CONCATENATED_SEGMENTS => c.p139
1295 ,P_GROUP_NAME => c.p140
1296 ,P_OTHER_MANAGER_WARNING => L_OTHER_MANAGER_WARNING
1297 ,P_HOURLY_SALARIED_WARNING => L_HOURLY_SALARIED_WARNING
1298 ,P_GSP_POST_PROCESS_WARNING => c.p143);
1299 hr_data_pump.api_trc_off;
1300 --
1301 iuk(p_batch_line_id,c.p131,L_ASSIGNMENT_ID);
1302 --
1303 if L_OTHER_MANAGER_WARNING then
1304 c.p141 := 'TRUE';
1305 else
1306 c.p141 := 'FALSE';
1307 end if;
1308 --
1309 if L_HOURLY_SALARIED_WARNING then
1310 c.p142 := 'TRUE';
1311 else
1312 c.p142 := 'FALSE';
1313 end if;
1314 --
1315 update hr_pump_batch_lines l set
1316 l.pval002 = decode(c.p2,null,cn,c.p2),
1317 l.pval129 = decode(c.p129,null,cn,c.p129),
1318 l.pval130 = decode(c.p130,null,cn,c.p130),
1319 l.pval131 = decode(c.p131,null,cn,c.p131),
1320 l.pval132 = decode(c.p132,null,cn,c.p132),
1321 l.pval133 = decode(c.p133,null,cn,c.p133),
1322 l.pval134 = decode(c.p134,null,cn,c.p134),
1323 l.pval135 = decode(c.p135,null,cn,dc(c.p135)),
1324 l.pval136 = decode(c.p136,null,cn,dc(c.p136)),
1325 l.pval137 = decode(c.p137,null,cn,c.p137),
1326 l.pval138 = decode(c.p138,null,cn,c.p138),
1327 l.pval139 = decode(c.p139,null,cn,c.p139),
1328 l.pval140 = decode(c.p140,null,cn,c.p140),
1329 l.pval141 = decode(c.p141,null,cn,c.p141),
1330 l.pval142 = decode(c.p142,null,cn,c.p142),
1331 l.pval143 = decode(c.p143,null,cn,c.p143)
1332 where l.rowid = c.myrowid;
1333 --
1334 close cr;
1335 --
1336 hr_data_pump.exit('call');
1337 exception
1338  when hr_multi_message.error_message_exist then
1339    if cr%isopen then
1340     close cr;
1341    end if;
1342    hr_pump_utils.set_multi_msg_error_flag(true);
1343  when others then
1344  if cr%isopen then
1345   close cr;
1346  end if;
1347  raise;
1348 end call;
1349 end hrdpp_CREATE_RU_SECONDARY_EMP_;