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_SECONDARY_EMP_ASG

Source


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