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