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_UPDATE_POSITION

Source


1 package body hrdpp_UPDATE_POSITION as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2009/03/30 04:03:15
4  * Generated for API: HR_POSITION_API.UPDATE_POSITION
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_POSITION_DEFINITION_ID in number
83 ,P_NAME in varchar2
84 ,P_LANGUAGE_CODE in varchar2 default null
85 ,P_POSITION_TRANSACTION_ID in number default null
86 ,I_POSITION_TRANSACTION_ID in varchar2 default 'N'
87 ,P_AMENDMENT_DATE in date default null
88 ,I_AMENDMENT_DATE in varchar2 default 'N'
89 ,P_AMENDMENT_RECOMMENDATION in varchar2 default null
90 ,P_AMENDMENT_REF_NUMBER in varchar2 default null
91 ,P_BARGAINING_UNIT_CD in varchar2 default null
92 ,P_COMMENTS in long default null
93 ,P_CURRENT_JOB_PROP_END_DATE in date default null
94 ,I_CURRENT_JOB_PROP_END_DATE in varchar2 default 'N'
95 ,P_CURRENT_ORG_PROP_END_DATE in date default null
96 ,I_CURRENT_ORG_PROP_END_DATE in varchar2 default 'N'
97 ,P_AVAIL_STATUS_PROP_END_DATE in date default null
98 ,I_AVAIL_STATUS_PROP_END_DATE in varchar2 default 'N'
99 ,P_DATE_EFFECTIVE in date default null
100 ,I_DATE_EFFECTIVE in varchar2 default 'N'
101 ,P_DATE_END in date default null
102 ,I_DATE_END in varchar2 default 'N'
103 ,P_EARLIEST_HIRE_DATE in date default null
104 ,I_EARLIEST_HIRE_DATE in varchar2 default 'N'
105 ,P_FILL_BY_DATE in date default null
106 ,I_FILL_BY_DATE in varchar2 default 'N'
107 ,P_FREQUENCY in varchar2 default null
108 ,P_FTE in number default null
109 ,I_FTE in varchar2 default 'N'
110 ,P_MAX_PERSONS in number default null
111 ,I_MAX_PERSONS in varchar2 default 'N'
112 ,P_OVERLAP_PERIOD in number default null
113 ,I_OVERLAP_PERIOD in varchar2 default 'N'
114 ,P_OVERLAP_UNIT_CD in varchar2 default null
115 ,P_PAY_TERM_END_DAY_CD in varchar2 default null
116 ,P_PAY_TERM_END_MONTH_CD in varchar2 default null
117 ,P_PERMANENT_TEMPORARY_FLAG in varchar2 default null
118 ,P_PERMIT_RECRUITMENT_FLAG in varchar2 default null
119 ,P_POSITION_TYPE in varchar2 default null
120 ,P_POSTING_DESCRIPTION in varchar2 default null
121 ,P_PROBATION_PERIOD in number default null
122 ,I_PROBATION_PERIOD in varchar2 default 'N'
123 ,P_PROBATION_PERIOD_UNIT_CD in varchar2 default null
124 ,P_REPLACEMENT_REQUIRED_FLAG in varchar2 default null
125 ,P_REVIEW_FLAG in varchar2 default null
126 ,P_SEASONAL_FLAG in varchar2 default null
127 ,P_SECURITY_REQUIREMENTS in varchar2 default null
128 ,P_STATUS in varchar2 default null
129 ,P_TERM_START_DAY_CD in varchar2 default null
130 ,P_TERM_START_MONTH_CD in varchar2 default null
131 ,P_TIME_NORMAL_FINISH in varchar2 default null
132 ,P_TIME_NORMAL_START in varchar2 default null
133 ,P_UPDATE_SOURCE_CD in varchar2 default null
134 ,P_WORKING_HOURS in number default null
135 ,I_WORKING_HOURS in varchar2 default 'N'
136 ,P_WORKS_COUNCIL_APPROVAL_FLAG in varchar2 default null
137 ,P_WORK_PERIOD_TYPE_CD in varchar2 default null
138 ,P_WORK_TERM_END_DAY_CD in varchar2 default null
139 ,P_WORK_TERM_END_MONTH_CD in varchar2 default null
140 ,P_PROPOSED_FTE_FOR_LAYOFF in number default null
141 ,I_PROPOSED_FTE_FOR_LAYOFF in varchar2 default 'N'
142 ,P_PROPOSED_DATE_FOR_LAYOFF in date default null
143 ,I_PROPOSED_DATE_FOR_LAYOFF in varchar2 default 'N'
144 ,P_INFORMATION1 in varchar2 default null
145 ,P_INFORMATION2 in varchar2 default null
146 ,P_INFORMATION3 in varchar2 default null
147 ,P_INFORMATION4 in varchar2 default null
148 ,P_INFORMATION5 in varchar2 default null
149 ,P_INFORMATION6 in varchar2 default null
150 ,P_INFORMATION7 in varchar2 default null
151 ,P_INFORMATION8 in varchar2 default null
152 ,P_INFORMATION9 in varchar2 default null
153 ,P_INFORMATION10 in varchar2 default null
154 ,P_INFORMATION11 in varchar2 default null
155 ,P_INFORMATION12 in varchar2 default null
156 ,P_INFORMATION13 in varchar2 default null
157 ,P_INFORMATION14 in varchar2 default null
158 ,P_INFORMATION15 in varchar2 default null
159 ,P_INFORMATION16 in varchar2 default null
160 ,P_INFORMATION17 in varchar2 default null
161 ,P_INFORMATION18 in varchar2 default null
162 ,P_INFORMATION19 in varchar2 default null
163 ,P_INFORMATION20 in varchar2 default null
164 ,P_INFORMATION21 in varchar2 default null
165 ,P_INFORMATION22 in varchar2 default null
166 ,P_INFORMATION23 in varchar2 default null
167 ,P_INFORMATION24 in varchar2 default null
168 ,P_INFORMATION25 in varchar2 default null
169 ,P_INFORMATION26 in varchar2 default null
170 ,P_INFORMATION27 in varchar2 default null
171 ,P_INFORMATION28 in varchar2 default null
172 ,P_INFORMATION29 in varchar2 default null
173 ,P_INFORMATION30 in varchar2 default null
174 ,P_INFORMATION_CATEGORY in varchar2 default null
175 ,P_ATTRIBUTE1 in varchar2 default null
176 ,P_ATTRIBUTE2 in varchar2 default null
177 ,P_ATTRIBUTE3 in varchar2 default null
178 ,P_ATTRIBUTE4 in varchar2 default null
179 ,P_ATTRIBUTE5 in varchar2 default null
180 ,P_ATTRIBUTE6 in varchar2 default null
181 ,P_ATTRIBUTE7 in varchar2 default null
182 ,P_ATTRIBUTE8 in varchar2 default null
183 ,P_ATTRIBUTE9 in varchar2 default null
184 ,P_ATTRIBUTE10 in varchar2 default null
185 ,P_ATTRIBUTE11 in varchar2 default null
186 ,P_ATTRIBUTE12 in varchar2 default null
187 ,P_ATTRIBUTE13 in varchar2 default null
188 ,P_ATTRIBUTE14 in varchar2 default null
189 ,P_ATTRIBUTE15 in varchar2 default null
190 ,P_ATTRIBUTE16 in varchar2 default null
191 ,P_ATTRIBUTE17 in varchar2 default null
192 ,P_ATTRIBUTE18 in varchar2 default null
193 ,P_ATTRIBUTE19 in varchar2 default null
194 ,P_ATTRIBUTE20 in varchar2 default null
195 ,P_ATTRIBUTE21 in varchar2 default null
196 ,P_ATTRIBUTE22 in varchar2 default null
197 ,P_ATTRIBUTE23 in varchar2 default null
198 ,P_ATTRIBUTE24 in varchar2 default null
199 ,P_ATTRIBUTE25 in varchar2 default null
200 ,P_ATTRIBUTE26 in varchar2 default null
201 ,P_ATTRIBUTE27 in varchar2 default null
202 ,P_ATTRIBUTE28 in varchar2 default null
203 ,P_ATTRIBUTE29 in varchar2 default null
204 ,P_ATTRIBUTE30 in varchar2 default null
205 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
206 ,P_SEGMENT1 in varchar2 default null
207 ,P_SEGMENT2 in varchar2 default null
208 ,P_SEGMENT3 in varchar2 default null
209 ,P_SEGMENT4 in varchar2 default null
210 ,P_SEGMENT5 in varchar2 default null
211 ,P_SEGMENT6 in varchar2 default null
212 ,P_SEGMENT7 in varchar2 default null
213 ,P_SEGMENT8 in varchar2 default null
214 ,P_SEGMENT9 in varchar2 default null
215 ,P_SEGMENT10 in varchar2 default null
216 ,P_SEGMENT11 in varchar2 default null
217 ,P_SEGMENT12 in varchar2 default null
218 ,P_SEGMENT13 in varchar2 default null
219 ,P_SEGMENT14 in varchar2 default null
220 ,P_SEGMENT15 in varchar2 default null
221 ,P_SEGMENT16 in varchar2 default null
222 ,P_SEGMENT17 in varchar2 default null
223 ,P_SEGMENT18 in varchar2 default null
224 ,P_SEGMENT19 in varchar2 default null
225 ,P_SEGMENT20 in varchar2 default null
226 ,P_SEGMENT21 in varchar2 default null
227 ,P_SEGMENT22 in varchar2 default null
228 ,P_SEGMENT23 in varchar2 default null
229 ,P_SEGMENT24 in varchar2 default null
230 ,P_SEGMENT25 in varchar2 default null
231 ,P_SEGMENT26 in varchar2 default null
232 ,P_SEGMENT27 in varchar2 default null
233 ,P_SEGMENT28 in varchar2 default null
234 ,P_SEGMENT29 in varchar2 default null
235 ,P_SEGMENT30 in varchar2 default null
236 ,P_CONCAT_SEGMENTS in varchar2 default null
237 ,P_REQUEST_ID in number default null
238 ,I_REQUEST_ID in varchar2 default 'N'
239 ,P_PROGRAM_APPLICATION_ID in number default null
240 ,I_PROGRAM_APPLICATION_ID in varchar2 default 'N'
241 ,P_PROGRAM_UPDATE_DATE in date default null
242 ,I_PROGRAM_UPDATE_DATE in varchar2 default 'N'
243 ,P_EFFECTIVE_DATE in date
244 ,P_DATETRACK_MODE in varchar2
245 ,P_POSITION_NAME in varchar2
246 ,P_SHARED_TYPE_NAME in varchar2 default null
247 ,P_SYSTEM_TYPE_CD in varchar2 default null
248 ,P_ENTRY_STEP_USER_KEY in varchar2 default null
249 ,P_ENTRY_GRADE_RULE_USER_KEY in varchar2 default null
250 ,P_LOCATION_CODE in varchar2 default null
251 ,P_PAY_FREQ_PAYROLL_NAME in varchar2 default null
252 ,P_PRIOR_POSITION_NAME in varchar2 default null
253 ,P_RELIEF_POSITION_NAME in varchar2 default null
254 ,P_ENTRY_GRADE_NAME in varchar2 default null
255 ,P_SUCCESSOR_POSITION_NAME in varchar2 default null
256 ,P_SUPERVISOR_POSITION_NAME in varchar2 default null
257 ,P_PAY_BASIS_NAME in varchar2 default null
258 ,P_SUPERVISOR_USER_KEY in varchar2 default null) is
259 blid number := p_data_pump_batch_line_id;
260 begin
261 if blid is not null then
262 delete from hr_pump_batch_lines where batch_line_id = blid;
263 delete from hr_pump_batch_exceptions
264 where source_type = 'BATCH_LINE' and source_id = blid;
265 end if;
266 insert into hr_pump_batch_lines
267 (batch_id
268 ,batch_line_id
269 ,business_group_name
270 ,api_module_id
271 ,line_status
272 ,user_sequence
273 ,link_value
274 ,pval003
275 ,pval005
276 ,pval006
277 ,pval007
278 ,pval008
279 ,pval009
280 ,pval010
281 ,pval011
282 ,plongval
283 ,pval013
284 ,pval014
285 ,pval015
286 ,pval016
287 ,pval017
288 ,pval018
289 ,pval019
290 ,pval020
291 ,pval021
292 ,pval022
293 ,pval023
294 ,pval024
295 ,pval025
296 ,pval026
297 ,pval027
298 ,pval028
299 ,pval029
300 ,pval030
301 ,pval031
302 ,pval032
303 ,pval033
304 ,pval034
305 ,pval035
306 ,pval036
307 ,pval037
308 ,pval038
309 ,pval039
310 ,pval040
311 ,pval041
312 ,pval042
313 ,pval043
314 ,pval044
315 ,pval045
316 ,pval046
317 ,pval047
318 ,pval048
319 ,pval049
320 ,pval050
321 ,pval051
322 ,pval052
323 ,pval053
324 ,pval054
325 ,pval055
326 ,pval056
327 ,pval057
328 ,pval058
329 ,pval059
330 ,pval060
331 ,pval061
332 ,pval062
333 ,pval063
334 ,pval064
335 ,pval065
336 ,pval066
337 ,pval067
338 ,pval068
339 ,pval069
340 ,pval070
341 ,pval071
342 ,pval072
343 ,pval073
344 ,pval074
345 ,pval075
346 ,pval076
347 ,pval077
348 ,pval078
349 ,pval079
350 ,pval080
351 ,pval081
352 ,pval082
353 ,pval083
354 ,pval084
355 ,pval085
356 ,pval086
357 ,pval087
358 ,pval088
359 ,pval089
360 ,pval090
361 ,pval091
362 ,pval092
363 ,pval093
364 ,pval094
365 ,pval095
366 ,pval096
367 ,pval097
368 ,pval098
369 ,pval099
370 ,pval100
371 ,pval101
372 ,pval102
373 ,pval103
374 ,pval104
375 ,pval105
376 ,pval106
377 ,pval107
378 ,pval108
379 ,pval109
380 ,pval110
381 ,pval111
382 ,pval112
383 ,pval113
384 ,pval114
385 ,pval115
386 ,pval116
387 ,pval117
388 ,pval118
389 ,pval119
390 ,pval120
391 ,pval121
392 ,pval122
393 ,pval123
394 ,pval124
395 ,pval125
396 ,pval126
397 ,pval127
398 ,pval128
399 ,pval129
400 ,pval130
401 ,pval131
402 ,pval132
403 ,pval133
404 ,pval134
405 ,pval135
406 ,pval136
407 ,pval137
408 ,pval138
409 ,pval139
410 ,pval140
411 ,pval141
412 ,pval142
413 ,pval143
414 ,pval144
415 ,pval145
416 ,pval146
417 ,pval147
418 ,pval148
419 ,pval149
420 ,pval150
421 ,pval151
422 ,pval152
423 ,pval153
424 ,pval154
425 ,pval155
426 ,pval156
427 ,pval157
428 ,pval158
429 ,pval159
430 ,pval160
431 ,pval161)
432 values
433 (p_batch_id
434 ,nvl(blid,hr_pump_batch_lines_s.nextval)
435 ,p_data_pump_business_grp_name
436 ,1216
437 ,'U'
438 ,p_user_sequence
439 ,p_link_value
440 ,P_POSITION_DEFINITION_ID
441 ,P_NAME
445 ,P_AMENDMENT_RECOMMENDATION
442 ,P_LANGUAGE_CODE
443 ,nd(P_POSITION_TRANSACTION_ID,I_POSITION_TRANSACTION_ID)
444 ,dd(P_AMENDMENT_DATE,I_AMENDMENT_DATE)
446 ,P_AMENDMENT_REF_NUMBER
447 ,P_BARGAINING_UNIT_CD
448 ,P_COMMENTS
449 ,dd(P_CURRENT_JOB_PROP_END_DATE,I_CURRENT_JOB_PROP_END_DATE)
450 ,dd(P_CURRENT_ORG_PROP_END_DATE,I_CURRENT_ORG_PROP_END_DATE)
451 ,dd(P_AVAIL_STATUS_PROP_END_DATE,I_AVAIL_STATUS_PROP_END_DATE)
452 ,dd(P_DATE_EFFECTIVE,I_DATE_EFFECTIVE)
453 ,dd(P_DATE_END,I_DATE_END)
454 ,dd(P_EARLIEST_HIRE_DATE,I_EARLIEST_HIRE_DATE)
455 ,dd(P_FILL_BY_DATE,I_FILL_BY_DATE)
456 ,P_FREQUENCY
457 ,nd(P_FTE,I_FTE)
458 ,nd(P_MAX_PERSONS,I_MAX_PERSONS)
459 ,nd(P_OVERLAP_PERIOD,I_OVERLAP_PERIOD)
460 ,P_OVERLAP_UNIT_CD
461 ,P_PAY_TERM_END_DAY_CD
462 ,P_PAY_TERM_END_MONTH_CD
463 ,P_PERMANENT_TEMPORARY_FLAG
464 ,P_PERMIT_RECRUITMENT_FLAG
465 ,P_POSITION_TYPE
466 ,P_POSTING_DESCRIPTION
467 ,nd(P_PROBATION_PERIOD,I_PROBATION_PERIOD)
468 ,P_PROBATION_PERIOD_UNIT_CD
469 ,P_REPLACEMENT_REQUIRED_FLAG
470 ,P_REVIEW_FLAG
471 ,P_SEASONAL_FLAG
472 ,P_SECURITY_REQUIREMENTS
473 ,P_STATUS
474 ,P_TERM_START_DAY_CD
475 ,P_TERM_START_MONTH_CD
476 ,P_TIME_NORMAL_FINISH
477 ,P_TIME_NORMAL_START
478 ,P_UPDATE_SOURCE_CD
479 ,nd(P_WORKING_HOURS,I_WORKING_HOURS)
480 ,P_WORKS_COUNCIL_APPROVAL_FLAG
481 ,P_WORK_PERIOD_TYPE_CD
482 ,P_WORK_TERM_END_DAY_CD
483 ,P_WORK_TERM_END_MONTH_CD
484 ,nd(P_PROPOSED_FTE_FOR_LAYOFF,I_PROPOSED_FTE_FOR_LAYOFF)
485 ,dd(P_PROPOSED_DATE_FOR_LAYOFF,I_PROPOSED_DATE_FOR_LAYOFF)
486 ,P_INFORMATION1
487 ,P_INFORMATION2
488 ,P_INFORMATION3
489 ,P_INFORMATION4
490 ,P_INFORMATION5
491 ,P_INFORMATION6
492 ,P_INFORMATION7
493 ,P_INFORMATION8
494 ,P_INFORMATION9
495 ,P_INFORMATION10
496 ,P_INFORMATION11
497 ,P_INFORMATION12
498 ,P_INFORMATION13
499 ,P_INFORMATION14
500 ,P_INFORMATION15
501 ,P_INFORMATION16
502 ,P_INFORMATION17
503 ,P_INFORMATION18
504 ,P_INFORMATION19
505 ,P_INFORMATION20
506 ,P_INFORMATION21
507 ,P_INFORMATION22
508 ,P_INFORMATION23
509 ,P_INFORMATION24
510 ,P_INFORMATION25
511 ,P_INFORMATION26
512 ,P_INFORMATION27
513 ,P_INFORMATION28
514 ,P_INFORMATION29
515 ,P_INFORMATION30
516 ,P_INFORMATION_CATEGORY
517 ,P_ATTRIBUTE1
518 ,P_ATTRIBUTE2
519 ,P_ATTRIBUTE3
520 ,P_ATTRIBUTE4
521 ,P_ATTRIBUTE5
522 ,P_ATTRIBUTE6
523 ,P_ATTRIBUTE7
524 ,P_ATTRIBUTE8
525 ,P_ATTRIBUTE9
526 ,P_ATTRIBUTE10
527 ,P_ATTRIBUTE11
528 ,P_ATTRIBUTE12
529 ,P_ATTRIBUTE13
530 ,P_ATTRIBUTE14
531 ,P_ATTRIBUTE15
532 ,P_ATTRIBUTE16
533 ,P_ATTRIBUTE17
534 ,P_ATTRIBUTE18
535 ,P_ATTRIBUTE19
536 ,P_ATTRIBUTE20
537 ,P_ATTRIBUTE21
538 ,P_ATTRIBUTE22
539 ,P_ATTRIBUTE23
540 ,P_ATTRIBUTE24
541 ,P_ATTRIBUTE25
542 ,P_ATTRIBUTE26
543 ,P_ATTRIBUTE27
544 ,P_ATTRIBUTE28
545 ,P_ATTRIBUTE29
546 ,P_ATTRIBUTE30
547 ,P_ATTRIBUTE_CATEGORY
548 ,P_SEGMENT1
549 ,P_SEGMENT2
550 ,P_SEGMENT3
551 ,P_SEGMENT4
552 ,P_SEGMENT5
553 ,P_SEGMENT6
554 ,P_SEGMENT7
555 ,P_SEGMENT8
556 ,P_SEGMENT9
557 ,P_SEGMENT10
558 ,P_SEGMENT11
559 ,P_SEGMENT12
560 ,P_SEGMENT13
561 ,P_SEGMENT14
562 ,P_SEGMENT15
563 ,P_SEGMENT16
564 ,P_SEGMENT17
565 ,P_SEGMENT18
566 ,P_SEGMENT19
567 ,P_SEGMENT20
568 ,P_SEGMENT21
569 ,P_SEGMENT22
570 ,P_SEGMENT23
571 ,P_SEGMENT24
572 ,P_SEGMENT25
573 ,P_SEGMENT26
574 ,P_SEGMENT27
575 ,P_SEGMENT28
576 ,P_SEGMENT29
577 ,P_SEGMENT30
578 ,P_CONCAT_SEGMENTS
579 ,nd(P_REQUEST_ID,I_REQUEST_ID)
580 ,nd(P_PROGRAM_APPLICATION_ID,I_PROGRAM_APPLICATION_ID)
581 ,dd(P_PROGRAM_UPDATE_DATE,I_PROGRAM_UPDATE_DATE)
582 ,dc(P_EFFECTIVE_DATE)
583 ,P_DATETRACK_MODE
584 ,P_POSITION_NAME
585 ,P_SHARED_TYPE_NAME
586 ,P_SYSTEM_TYPE_CD
587 ,P_ENTRY_STEP_USER_KEY
588 ,P_ENTRY_GRADE_RULE_USER_KEY
589 ,P_LOCATION_CODE
590 ,P_PAY_FREQ_PAYROLL_NAME
591 ,P_PRIOR_POSITION_NAME
592 ,P_RELIEF_POSITION_NAME
593 ,P_ENTRY_GRADE_NAME
594 ,P_SUCCESSOR_POSITION_NAME
595 ,P_SUPERVISOR_POSITION_NAME
596 ,P_PAY_BASIS_NAME
597 ,P_SUPERVISOR_USER_KEY);
598 end insert_batch_lines;
599 --
600 procedure call
601 (p_business_group_id in number,
602 p_batch_line_id     in number) is
603 cursor cr is
604 select l.rowid myrowid,
605 decode(l.pval001,cn,dn,d(l.pval001)) p1,
606 decode(l.pval002,cn,dn,d(l.pval002)) p2,
607 decode(l.pval003,cn,nn,n(l.pval003)) p3,
608 l.pval004 p4,
609 decode(l.pval005,cn,vn,l.pval005) p5,
610 decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
611 l.pval006 d6,
612 decode(l.pval007,cn,nn,vn,nh,n(l.pval007)) p7,
613 l.pval007 d7,
614 decode(l.pval008,cn,dn,vn,dh,d(l.pval008)) p8,
615 l.pval008 d8,
616 decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
617 l.pval009 d9,
618 decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
619 l.pval010 d10,
620 decode(l.pval011,cn,vn,vn,vh,
621  hr_pump_get.gl(l.pval011,'BARGAINING_UNIT_CODE',d(l.pval146),l.pval006)) p11,
622 l.pval011 d11,
623 l.plongval plongval,
624 decode(l.pval013,cn,dn,vn,dh,d(l.pval013)) p13,
625 l.pval013 d13,
626 decode(l.pval014,cn,dn,vn,dh,d(l.pval014)) p14,
627 l.pval014 d14,
628 decode(l.pval015,cn,dn,vn,dh,d(l.pval015)) p15,
629 l.pval015 d15,
633 l.pval017 d17,
630 decode(l.pval016,cn,dn,vn,dh,d(l.pval016)) p16,
631 l.pval016 d16,
632 decode(l.pval017,cn,dn,vn,dh,d(l.pval017)) p17,
634 decode(l.pval018,cn,dn,vn,dh,d(l.pval018)) p18,
635 l.pval018 d18,
636 decode(l.pval019,cn,dn,vn,dh,d(l.pval019)) p19,
637 l.pval019 d19,
638 decode(l.pval020,cn,vn,vn,vh,
639  hr_pump_get.gl(l.pval020,'FREQUENCY',d(l.pval146),l.pval006)) p20,
640 l.pval020 d20,
641 decode(l.pval021,cn,nn,vn,nh,n(l.pval021)) p21,
642 l.pval021 d21,
643 decode(l.pval022,cn,nn,vn,nh,n(l.pval022)) p22,
644 l.pval022 d22,
645 decode(l.pval023,cn,nn,vn,nh,n(l.pval023)) p23,
646 l.pval023 d23,
647 decode(l.pval024,cn,vn,vn,vh,
648  hr_pump_get.gl(l.pval024,'FREQUENCY',d(l.pval146),l.pval006)) p24,
649 l.pval024 d24,
650 decode(l.pval025,cn,vn,vn,vh,
651  hr_pump_get.gl(l.pval025,'DAY_CODE',d(l.pval146),l.pval006)) p25,
652 l.pval025 d25,
653 decode(l.pval026,cn,vn,vn,vh,
654  hr_pump_get.gl(l.pval026,'MONTH_CODE',d(l.pval146),l.pval006)) p26,
655 l.pval026 d26,
656 decode(l.pval027,cn,vn,vn,vh,
657  hr_pump_get.gl(l.pval027,'YES_NO',d(l.pval146),l.pval006)) p27,
658 l.pval027 d27,
659 decode(l.pval028,cn,vn,vn,vh,
660  hr_pump_get.gl(l.pval028,'YES_NO',d(l.pval146),l.pval006)) p28,
661 l.pval028 d28,
662 decode(l.pval029,cn,vn,vn,vh,
663  hr_pump_get.gl(l.pval029,'POSITION_TYPE',d(l.pval146),l.pval006)) p29,
664 l.pval029 d29,
665 decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
666 l.pval030 d30,
667 decode(l.pval031,cn,nn,vn,nh,n(l.pval031)) p31,
668 l.pval031 d31,
669 decode(l.pval032,cn,vn,vn,vh,
670  hr_pump_get.gl(l.pval032,'QUALIFYING_UNITS',d(l.pval146),l.pval006)) p32,
671 l.pval032 d32,
672 decode(l.pval033,cn,vn,vn,vh,
673  hr_pump_get.gl(l.pval033,'YES_NO',d(l.pval146),l.pval006)) p33,
674 l.pval033 d33,
675 decode(l.pval034,cn,vn,vn,vh,
676  hr_pump_get.gl(l.pval034,'YES_NO',d(l.pval146),l.pval006)) p34,
677 l.pval034 d34,
678 decode(l.pval035,cn,vn,vn,vh,
679  hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval146),l.pval006)) p35,
680 l.pval035 d35,
681 decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
682 l.pval036 d36,
683 decode(l.pval037,cn,vn,vn,vh,
684  hr_pump_get.gl(l.pval037,'POSITION_STATUS',d(l.pval146),l.pval006)) p37,
685 l.pval037 d37,
686 decode(l.pval038,cn,vn,vn,vh,
687  hr_pump_get.gl(l.pval038,'DAY_CODE',d(l.pval146),l.pval006)) p38,
688 l.pval038 d38,
689 decode(l.pval039,cn,vn,vn,vh,
690  hr_pump_get.gl(l.pval039,'MONTH_CODE',d(l.pval146),l.pval006)) p39,
691 l.pval039 d39,
692 decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
693 l.pval040 d40,
694 decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
695 l.pval041 d41,
696 decode(l.pval042,cn,vn,vn,vh,l.pval042) p42,
697 l.pval042 d42,
698 decode(l.pval043,cn,nn,vn,nh,n(l.pval043)) p43,
699 l.pval043 d43,
700 decode(l.pval044,cn,vn,vn,vh,
701  hr_pump_get.gl(l.pval044,'YES_NO',d(l.pval146),l.pval006)) p44,
702 l.pval044 d44,
703 decode(l.pval045,cn,vn,vn,vh,
704  hr_pump_get.gl(l.pval045,'YES_NO',d(l.pval146),l.pval006)) p45,
705 l.pval045 d45,
706 decode(l.pval046,cn,vn,vn,vh,
707  hr_pump_get.gl(l.pval046,'DAY_CODE',d(l.pval146),l.pval006)) p46,
708 l.pval046 d46,
709 decode(l.pval047,cn,vn,vn,vh,
710  hr_pump_get.gl(l.pval047,'MONTH_CODE',d(l.pval146),l.pval006)) p47,
711 l.pval047 d47,
712 decode(l.pval048,cn,nn,vn,nh,n(l.pval048)) p48,
713 l.pval048 d48,
714 decode(l.pval049,cn,dn,vn,dh,d(l.pval049)) p49,
715 l.pval049 d49,
716 decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
717 l.pval050 d50,
718 decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
719 l.pval051 d51,
720 decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
721 l.pval052 d52,
722 decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
723 l.pval053 d53,
724 decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
725 l.pval054 d54,
726 decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
727 l.pval055 d55,
728 decode(l.pval056,cn,vn,vn,vh,l.pval056) p56,
729 l.pval056 d56,
730 decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
731 l.pval057 d57,
732 decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
733 l.pval058 d58,
734 decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
735 l.pval059 d59,
736 decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,
737 l.pval060 d60,
738 decode(l.pval061,cn,vn,vn,vh,l.pval061) p61,
739 l.pval061 d61,
740 decode(l.pval062,cn,vn,vn,vh,l.pval062) p62,
741 l.pval062 d62,
742 decode(l.pval063,cn,vn,vn,vh,l.pval063) p63,
743 l.pval063 d63,
744 decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
745 l.pval064 d64,
746 decode(l.pval065,cn,vn,vn,vh,l.pval065) p65,
747 l.pval065 d65,
748 decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
749 l.pval066 d66,
750 decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
751 l.pval067 d67,
752 decode(l.pval068,cn,vn,vn,vh,l.pval068) p68,
753 l.pval068 d68,
754 decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
755 l.pval069 d69,
756 decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
757 l.pval070 d70,
758 decode(l.pval071,cn,vn,vn,vh,l.pval071) p71,
759 l.pval071 d71,
760 decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
761 l.pval072 d72,
762 decode(l.pval073,cn,vn,vn,vh,l.pval073) p73,
763 l.pval073 d73,
764 decode(l.pval074,cn,vn,vn,vh,l.pval074) p74,
765 l.pval074 d74,
766 decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
767 l.pval075 d75,
768 decode(l.pval076,cn,vn,vn,vh,l.pval076) p76,
769 l.pval076 d76,
770 decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
771 l.pval077 d77,
772 decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,
773 l.pval078 d78,
774 decode(l.pval079,cn,vn,vn,vh,l.pval079) p79,
775 l.pval079 d79,
776 decode(l.pval080,cn,vn,vn,vh,l.pval080) p80,
777 l.pval080 d80,
778 decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
782 decode(l.pval083,cn,vn,vn,vh,l.pval083) p83,
779 l.pval081 d81,
780 decode(l.pval082,cn,vn,vn,vh,l.pval082) p82,
781 l.pval082 d82,
783 l.pval083 d83,
784 decode(l.pval084,cn,vn,vn,vh,l.pval084) p84,
785 l.pval084 d84,
786 decode(l.pval085,cn,vn,vn,vh,l.pval085) p85,
787 l.pval085 d85,
788 decode(l.pval086,cn,vn,vn,vh,l.pval086) p86,
789 l.pval086 d86,
790 decode(l.pval087,cn,vn,vn,vh,l.pval087) p87,
791 l.pval087 d87,
792 decode(l.pval088,cn,vn,vn,vh,l.pval088) p88,
793 l.pval088 d88,
794 decode(l.pval089,cn,vn,vn,vh,l.pval089) p89,
795 l.pval089 d89,
796 decode(l.pval090,cn,vn,vn,vh,l.pval090) p90,
797 l.pval090 d90,
798 decode(l.pval091,cn,vn,vn,vh,l.pval091) p91,
799 l.pval091 d91,
800 decode(l.pval092,cn,vn,vn,vh,l.pval092) p92,
801 l.pval092 d92,
802 decode(l.pval093,cn,vn,vn,vh,l.pval093) p93,
803 l.pval093 d93,
804 decode(l.pval094,cn,vn,vn,vh,l.pval094) p94,
805 l.pval094 d94,
806 decode(l.pval095,cn,vn,vn,vh,l.pval095) p95,
807 l.pval095 d95,
808 decode(l.pval096,cn,vn,vn,vh,l.pval096) p96,
809 l.pval096 d96,
810 decode(l.pval097,cn,vn,vn,vh,l.pval097) p97,
811 l.pval097 d97,
812 decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
813 l.pval098 d98,
814 decode(l.pval099,cn,vn,vn,vh,l.pval099) p99,
815 l.pval099 d99,
816 decode(l.pval100,cn,vn,vn,vh,l.pval100) p100,
817 l.pval100 d100,
818 decode(l.pval101,cn,vn,vn,vh,l.pval101) p101,
819 l.pval101 d101,
820 decode(l.pval102,cn,vn,vn,vh,l.pval102) p102,
821 l.pval102 d102,
822 decode(l.pval103,cn,vn,vn,vh,l.pval103) p103,
823 l.pval103 d103,
824 decode(l.pval104,cn,vn,vn,vh,l.pval104) p104,
825 l.pval104 d104,
826 decode(l.pval105,cn,vn,vn,vh,l.pval105) p105,
827 l.pval105 d105,
828 decode(l.pval106,cn,vn,vn,vh,l.pval106) p106,
829 l.pval106 d106,
830 decode(l.pval107,cn,vn,vn,vh,l.pval107) p107,
831 l.pval107 d107,
832 decode(l.pval108,cn,vn,vn,vh,l.pval108) p108,
833 l.pval108 d108,
834 decode(l.pval109,cn,vn,vn,vh,l.pval109) p109,
835 l.pval109 d109,
836 decode(l.pval110,cn,vn,vn,vh,l.pval110) p110,
837 l.pval110 d110,
838 decode(l.pval111,cn,vn,vn,vh,l.pval111) p111,
839 l.pval111 d111,
840 decode(l.pval112,cn,vn,vn,vh,l.pval112) p112,
841 l.pval112 d112,
842 decode(l.pval113,cn,vn,vn,vh,l.pval113) p113,
843 l.pval113 d113,
844 decode(l.pval114,cn,vn,vn,vh,l.pval114) p114,
845 l.pval114 d114,
846 decode(l.pval115,cn,vn,vn,vh,l.pval115) p115,
847 l.pval115 d115,
848 decode(l.pval116,cn,vn,vn,vh,l.pval116) p116,
849 l.pval116 d116,
850 decode(l.pval117,cn,vn,vn,vh,l.pval117) p117,
851 l.pval117 d117,
852 decode(l.pval118,cn,vn,vn,vh,l.pval118) p118,
853 l.pval118 d118,
854 decode(l.pval119,cn,vn,vn,vh,l.pval119) p119,
855 l.pval119 d119,
856 decode(l.pval120,cn,vn,vn,vh,l.pval120) p120,
857 l.pval120 d120,
858 decode(l.pval121,cn,vn,vn,vh,l.pval121) p121,
859 l.pval121 d121,
860 decode(l.pval122,cn,vn,vn,vh,l.pval122) p122,
861 l.pval122 d122,
862 decode(l.pval123,cn,vn,vn,vh,l.pval123) p123,
863 l.pval123 d123,
864 decode(l.pval124,cn,vn,vn,vh,l.pval124) p124,
865 l.pval124 d124,
866 decode(l.pval125,cn,vn,vn,vh,l.pval125) p125,
867 l.pval125 d125,
868 decode(l.pval126,cn,vn,vn,vh,l.pval126) p126,
869 l.pval126 d126,
870 decode(l.pval127,cn,vn,vn,vh,l.pval127) p127,
871 l.pval127 d127,
872 decode(l.pval128,cn,vn,vn,vh,l.pval128) p128,
873 l.pval128 d128,
874 decode(l.pval129,cn,vn,vn,vh,l.pval129) p129,
875 l.pval129 d129,
876 decode(l.pval130,cn,vn,vn,vh,l.pval130) p130,
877 l.pval130 d130,
878 decode(l.pval131,cn,vn,vn,vh,l.pval131) p131,
879 l.pval131 d131,
880 decode(l.pval132,cn,vn,vn,vh,l.pval132) p132,
881 l.pval132 d132,
882 decode(l.pval133,cn,vn,vn,vh,l.pval133) p133,
883 l.pval133 d133,
884 decode(l.pval134,cn,vn,vn,vh,l.pval134) p134,
885 l.pval134 d134,
886 decode(l.pval135,cn,vn,vn,vh,l.pval135) p135,
887 l.pval135 d135,
888 decode(l.pval136,cn,vn,vn,vh,l.pval136) p136,
889 l.pval136 d136,
890 decode(l.pval137,cn,vn,vn,vh,l.pval137) p137,
891 l.pval137 d137,
892 decode(l.pval138,cn,vn,vn,vh,l.pval138) p138,
893 l.pval138 d138,
894 decode(l.pval139,cn,vn,vn,vh,l.pval139) p139,
895 l.pval139 d139,
896 decode(l.pval140,cn,vn,vn,vh,l.pval140) p140,
897 l.pval140 d140,
898 decode(l.pval141,cn,vn,vn,vh,l.pval141) p141,
899 l.pval141 d141,
900 decode(l.pval142,cn,vn,vn,vh,l.pval142) p142,
901 l.pval142 d142,
902 decode(l.pval143,cn,nn,vn,nh,n(l.pval143)) p143,
903 l.pval143 d143,
904 decode(l.pval144,cn,nn,vn,nh,n(l.pval144)) p144,
905 l.pval144 d144,
906 decode(l.pval145,cn,dn,vn,dh,d(l.pval145)) p145,
907 l.pval145 d145,
908 decode(l.pval146,cn,dn,d(l.pval146)) p146,
909 decode(l.pval147,cn,vn,l.pval147) p147,
910 decode(l.pval148,cn,vn,l.pval148) p148,
911 decode(l.pval149,cn,vn,vn,vh,l.pval149) p149,
912 l.pval149 d149,
913 decode(l.pval150,cn,vn,vn,vh,l.pval150) p150,
914 l.pval150 d150,
915 decode(l.pval151,cn,vn,vn,vn,l.pval151) p151,
916 l.pval151 d151,
917 decode(l.pval152,cn,vn,vn,vn,l.pval152) p152,
918 l.pval152 d152,
919 decode(l.pval153,cn,vn,vn,vh,l.pval153) p153,
920 l.pval153 d153,
921 decode(l.pval154,cn,vn,vn,vh,l.pval154) p154,
922 l.pval154 d154,
923 decode(l.pval155,cn,vn,vn,vh,l.pval155) p155,
924 l.pval155 d155,
925 decode(l.pval156,cn,vn,vn,vh,l.pval156) p156,
926 l.pval156 d156,
927 decode(l.pval157,cn,vn,vn,vh,l.pval157) p157,
928 l.pval157 d157,
929 decode(l.pval158,cn,vn,vn,vh,l.pval158) p158,
930 l.pval158 d158,
931 decode(l.pval159,cn,vn,vn,vh,l.pval159) p159,
932 l.pval159 d159,
933 decode(l.pval160,cn,vn,vn,vh,l.pval160) p160,
934 l.pval160 d160,
935 decode(l.pval161,cn,vn,vn,vn,l.pval161) p161,
939 --
936 l.pval161 d161
937 from hr_pump_batch_lines l
938 where l.batch_line_id = p_batch_line_id;
940 c cr%rowtype;
941 l_validate boolean := false;
942 L_VALID_GRADES_CHANGED_WARNING boolean;
943 L_COMMENTS varchar2(32767);
944 L_POSITION_ID number;
945 L_AVAILABILITY_STATUS_ID number;
946 L_ENTRY_STEP_ID number;
947 L_ENTRY_GRADE_RULE_ID number;
948 L_LOCATION_ID number;
949 L_PAY_FREQ_PAYROLL_ID number;
950 L_PRIOR_POSITION_ID number;
951 L_RELIEF_POSITION_ID number;
952 L_ENTRY_GRADE_ID number;
953 L_SUCCESSOR_POSITION_ID number;
954 L_SUPERVISOR_POSITION_ID number;
955 L_PAY_BASIS_ID number;
956 L_SUPERVISOR_ID number;
957 L_PROGRAM_ID number;
958 L_OBJECT_VERSION_NUMBER number;
959 --
960 begin
961 hr_data_pump.entry('call');
962 open cr;
963 fetch cr into c;
964 if cr%notfound then
965 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
966 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
967 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
968 hr_utility.set_message_token('VALUE',p_batch_line_id);
969 hr_utility.raise_error;
970 end if;
971 --
972 L_COMMENTS := c.plongval;
973 if L_COMMENTS = cn then
974 L_COMMENTS := null;
975 end if;
976 --
977 if c.p148 is null or
978 c.p146 is null then
979 L_POSITION_ID:=nn;
980 else
981 L_POSITION_ID := 
982 hr_pump_get.get_position_id
983 (P_POSITION_NAME => c.p148
984 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
985 ,P_EFFECTIVE_DATE => c.p146);
986 end if;
987 --
988 if c.d149=cn or
989 c.d150=cn or
990 c.d6=cn then
991 L_AVAILABILITY_STATUS_ID:=nn;
992 elsif c.d149 is null or
993 c.d150 is null or
994 c.d6 is null then 
995 L_AVAILABILITY_STATUS_ID:=nh;
996 else
997 L_AVAILABILITY_STATUS_ID := 
998 hr_pump_get.get_availability_status_id
999 (P_SHARED_TYPE_NAME => c.p149
1000 ,P_SYSTEM_TYPE_CD => c.p150
1001 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1002 ,P_LANGUAGE_CODE => c.p6);
1003 end if;
1004 --
1005 if c.d151=cn then
1006 L_ENTRY_STEP_ID:=nn;
1007 elsif c.d151 is null then 
1008 L_ENTRY_STEP_ID:=nh;
1009 else
1010 L_ENTRY_STEP_ID := 
1011 hr_pump_get.get_entry_step_id
1012 (P_ENTRY_STEP_USER_KEY => c.p151);
1013 end if;
1014 --
1015 if c.d152=cn then
1016 L_ENTRY_GRADE_RULE_ID:=nn;
1017 elsif c.d152 is null then 
1018 L_ENTRY_GRADE_RULE_ID:=nh;
1019 else
1020 L_ENTRY_GRADE_RULE_ID := 
1021 hr_pump_get.get_entry_grade_rule_id
1022 (P_ENTRY_GRADE_RULE_USER_KEY => c.p152);
1023 end if;
1024 --
1025 if c.d153=cn or
1026 c.d6=cn then
1027 L_LOCATION_ID:=nn;
1028 elsif c.d153 is null or
1029 c.d6 is null then 
1030 L_LOCATION_ID:=nh;
1031 else
1032 L_LOCATION_ID := 
1033 hr_pump_get.get_location_id
1034 (P_LOCATION_CODE => c.p153
1035 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1036 ,P_LANGUAGE_CODE => c.p6);
1037 end if;
1038 --
1039 if c.d154=cn or
1040 c.p146 is null then
1041 L_PAY_FREQ_PAYROLL_ID:=nn;
1042 elsif c.d154 is null then 
1043 L_PAY_FREQ_PAYROLL_ID:=nh;
1044 else
1045 L_PAY_FREQ_PAYROLL_ID := 
1046 hr_pump_get.get_pay_freq_payroll_id
1047 (P_PAY_FREQ_PAYROLL_NAME => c.p154
1048 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1049 ,P_EFFECTIVE_DATE => c.p146);
1050 end if;
1051 --
1052 if c.d155=cn or
1053 c.p146 is null then
1054 L_PRIOR_POSITION_ID:=nn;
1055 elsif c.d155 is null then 
1056 L_PRIOR_POSITION_ID:=nh;
1057 else
1058 L_PRIOR_POSITION_ID := 
1059 hr_pump_get.get_prior_position_id
1060 (P_PRIOR_POSITION_NAME => c.p155
1061 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1062 ,P_EFFECTIVE_DATE => c.p146);
1063 end if;
1064 --
1065 if c.d156=cn or
1066 c.p146 is null then
1067 L_RELIEF_POSITION_ID:=nn;
1068 elsif c.d156 is null then 
1069 L_RELIEF_POSITION_ID:=nh;
1070 else
1071 L_RELIEF_POSITION_ID := 
1072 hr_pump_get.get_relief_position_id
1073 (P_RELIEF_POSITION_NAME => c.p156
1074 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1075 ,P_EFFECTIVE_DATE => c.p146);
1076 end if;
1077 --
1078 if c.d157=cn or
1079 c.p146 is null then
1080 L_ENTRY_GRADE_ID:=nn;
1081 elsif c.d157 is null then 
1082 L_ENTRY_GRADE_ID:=nh;
1083 else
1084 L_ENTRY_GRADE_ID := 
1085 hr_pump_get.get_entry_grade_id
1086 (P_ENTRY_GRADE_NAME => c.p157
1087 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1088 ,P_EFFECTIVE_DATE => c.p146);
1089 end if;
1090 --
1091 if c.d158=cn or
1092 c.p146 is null then
1093 L_SUCCESSOR_POSITION_ID:=nn;
1094 elsif c.d158 is null then 
1095 L_SUCCESSOR_POSITION_ID:=nh;
1096 else
1097 L_SUCCESSOR_POSITION_ID := 
1098 hr_pump_get.get_successor_position_id
1099 (P_SUCCESSOR_POSITION_NAME => c.p158
1100 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1101 ,P_EFFECTIVE_DATE => c.p146);
1102 end if;
1103 --
1104 if c.d159=cn or
1105 c.p146 is null then
1106 L_SUPERVISOR_POSITION_ID:=nn;
1107 elsif c.d159 is null then 
1108 L_SUPERVISOR_POSITION_ID:=nh;
1109 else
1110 L_SUPERVISOR_POSITION_ID := 
1111 hr_pump_get.get_supervisor_position_id
1112 (P_SUPERVISOR_POSITION_NAME => c.p159
1113 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1114 ,P_EFFECTIVE_DATE => c.p146);
1115 end if;
1116 --
1117 if c.d160=cn then
1118 L_PAY_BASIS_ID:=nn;
1119 elsif c.d160 is null then 
1120 L_PAY_BASIS_ID:=nh;
1121 else
1122 L_PAY_BASIS_ID := 
1123 hr_pump_get.get_pay_basis_id
1124 (P_PAY_BASIS_NAME => c.p160
1125 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1126 end if;
1127 --
1128 if c.d161=cn then
1132 else
1129 L_SUPERVISOR_ID:=nn;
1130 elsif c.d161 is null then 
1131 L_SUPERVISOR_ID:=nh;
1133 L_SUPERVISOR_ID := 
1134 hr_pump_get.get_supervisor_id
1135 (P_SUPERVISOR_USER_KEY => c.p161);
1136 end if;
1137 --
1138 L_PROGRAM_ID := 
1139 hr_pump_get.get_program_id;
1140 --
1141 if c.p148 is null or
1142 c.p146 is null then
1143 L_OBJECT_VERSION_NUMBER:=nn;
1144 else
1145 L_OBJECT_VERSION_NUMBER := 
1146 hr_pump_get.GET_POS_OVN
1147 (P_POSITION_NAME => c.p148
1148 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1149 ,P_EFFECTIVE_DATE => c.p146);
1150 end if;
1151 --
1152 hr_data_pump.api_trc_on;
1153 HR_POSITION_API.UPDATE_POSITION
1154 (p_validate => l_validate
1155 ,P_POSITION_ID => L_POSITION_ID
1156 ,P_EFFECTIVE_START_DATE => c.p1
1157 ,P_EFFECTIVE_END_DATE => c.p2
1158 ,P_POSITION_DEFINITION_ID => c.p3
1159 ,P_VALID_GRADES_CHANGED_WARNING => L_VALID_GRADES_CHANGED_WARNING
1160 ,P_NAME => c.p5
1161 ,P_LANGUAGE_CODE => c.p6
1162 ,P_AVAILABILITY_STATUS_ID => L_AVAILABILITY_STATUS_ID
1163 ,P_ENTRY_STEP_ID => L_ENTRY_STEP_ID
1164 ,P_ENTRY_GRADE_RULE_ID => L_ENTRY_GRADE_RULE_ID
1165 ,P_LOCATION_ID => L_LOCATION_ID
1166 ,P_PAY_FREQ_PAYROLL_ID => L_PAY_FREQ_PAYROLL_ID
1167 ,P_POSITION_TRANSACTION_ID => c.p7
1168 ,P_PRIOR_POSITION_ID => L_PRIOR_POSITION_ID
1169 ,P_RELIEF_POSITION_ID => L_RELIEF_POSITION_ID
1170 ,P_ENTRY_GRADE_ID => L_ENTRY_GRADE_ID
1171 ,P_SUCCESSOR_POSITION_ID => L_SUCCESSOR_POSITION_ID
1172 ,P_SUPERVISOR_POSITION_ID => L_SUPERVISOR_POSITION_ID
1173 ,P_AMENDMENT_DATE => c.p8
1174 ,P_AMENDMENT_RECOMMENDATION => c.p9
1175 ,P_AMENDMENT_REF_NUMBER => c.p10
1176 ,P_BARGAINING_UNIT_CD => c.p11
1177 ,P_COMMENTS => L_COMMENTS
1178 ,P_CURRENT_JOB_PROP_END_DATE => c.p13
1179 ,P_CURRENT_ORG_PROP_END_DATE => c.p14
1180 ,P_AVAIL_STATUS_PROP_END_DATE => c.p15
1181 ,P_DATE_EFFECTIVE => c.p16
1182 ,P_DATE_END => c.p17
1183 ,P_EARLIEST_HIRE_DATE => c.p18
1184 ,P_FILL_BY_DATE => c.p19
1185 ,P_FREQUENCY => c.p20
1186 ,P_FTE => c.p21
1187 ,P_MAX_PERSONS => c.p22
1188 ,P_OVERLAP_PERIOD => c.p23
1189 ,P_OVERLAP_UNIT_CD => c.p24
1190 ,P_PAY_TERM_END_DAY_CD => c.p25
1191 ,P_PAY_TERM_END_MONTH_CD => c.p26
1192 ,P_PERMANENT_TEMPORARY_FLAG => c.p27
1193 ,P_PERMIT_RECRUITMENT_FLAG => c.p28
1194 ,P_POSITION_TYPE => c.p29
1195 ,P_POSTING_DESCRIPTION => c.p30
1196 ,P_PROBATION_PERIOD => c.p31
1197 ,P_PROBATION_PERIOD_UNIT_CD => c.p32
1198 ,P_REPLACEMENT_REQUIRED_FLAG => c.p33
1199 ,P_REVIEW_FLAG => c.p34
1200 ,P_SEASONAL_FLAG => c.p35
1201 ,P_SECURITY_REQUIREMENTS => c.p36
1202 ,P_STATUS => c.p37
1203 ,P_TERM_START_DAY_CD => c.p38
1204 ,P_TERM_START_MONTH_CD => c.p39
1205 ,P_TIME_NORMAL_FINISH => c.p40
1206 ,P_TIME_NORMAL_START => c.p41
1207 ,P_UPDATE_SOURCE_CD => c.p42
1208 ,P_WORKING_HOURS => c.p43
1209 ,P_WORKS_COUNCIL_APPROVAL_FLAG => c.p44
1210 ,P_WORK_PERIOD_TYPE_CD => c.p45
1211 ,P_WORK_TERM_END_DAY_CD => c.p46
1212 ,P_WORK_TERM_END_MONTH_CD => c.p47
1213 ,P_PROPOSED_FTE_FOR_LAYOFF => c.p48
1214 ,P_PROPOSED_DATE_FOR_LAYOFF => c.p49
1215 ,P_PAY_BASIS_ID => L_PAY_BASIS_ID
1216 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
1217 ,P_INFORMATION1 => c.p50
1218 ,P_INFORMATION2 => c.p51
1219 ,P_INFORMATION3 => c.p52
1220 ,P_INFORMATION4 => c.p53
1221 ,P_INFORMATION5 => c.p54
1222 ,P_INFORMATION6 => c.p55
1223 ,P_INFORMATION7 => c.p56
1224 ,P_INFORMATION8 => c.p57
1225 ,P_INFORMATION9 => c.p58
1226 ,P_INFORMATION10 => c.p59
1227 ,P_INFORMATION11 => c.p60
1228 ,P_INFORMATION12 => c.p61
1229 ,P_INFORMATION13 => c.p62
1230 ,P_INFORMATION14 => c.p63
1231 ,P_INFORMATION15 => c.p64
1232 ,P_INFORMATION16 => c.p65
1233 ,P_INFORMATION17 => c.p66
1234 ,P_INFORMATION18 => c.p67
1235 ,P_INFORMATION19 => c.p68
1236 ,P_INFORMATION20 => c.p69
1237 ,P_INFORMATION21 => c.p70
1238 ,P_INFORMATION22 => c.p71
1239 ,P_INFORMATION23 => c.p72
1240 ,P_INFORMATION24 => c.p73
1241 ,P_INFORMATION25 => c.p74
1242 ,P_INFORMATION26 => c.p75
1243 ,P_INFORMATION27 => c.p76
1244 ,P_INFORMATION28 => c.p77
1245 ,P_INFORMATION29 => c.p78
1246 ,P_INFORMATION30 => c.p79
1247 ,P_INFORMATION_CATEGORY => c.p80
1248 ,P_ATTRIBUTE1 => c.p81
1249 ,P_ATTRIBUTE2 => c.p82
1250 ,P_ATTRIBUTE3 => c.p83
1251 ,P_ATTRIBUTE4 => c.p84
1252 ,P_ATTRIBUTE5 => c.p85
1253 ,P_ATTRIBUTE6 => c.p86
1254 ,P_ATTRIBUTE7 => c.p87
1255 ,P_ATTRIBUTE8 => c.p88
1256 ,P_ATTRIBUTE9 => c.p89
1257 ,P_ATTRIBUTE10 => c.p90
1258 ,P_ATTRIBUTE11 => c.p91
1259 ,P_ATTRIBUTE12 => c.p92
1260 ,P_ATTRIBUTE13 => c.p93
1261 ,P_ATTRIBUTE14 => c.p94
1262 ,P_ATTRIBUTE15 => c.p95
1263 ,P_ATTRIBUTE16 => c.p96
1264 ,P_ATTRIBUTE17 => c.p97
1265 ,P_ATTRIBUTE18 => c.p98
1266 ,P_ATTRIBUTE19 => c.p99
1267 ,P_ATTRIBUTE20 => c.p100
1268 ,P_ATTRIBUTE21 => c.p101
1269 ,P_ATTRIBUTE22 => c.p102
1270 ,P_ATTRIBUTE23 => c.p103
1271 ,P_ATTRIBUTE24 => c.p104
1272 ,P_ATTRIBUTE25 => c.p105
1273 ,P_ATTRIBUTE26 => c.p106
1274 ,P_ATTRIBUTE27 => c.p107
1275 ,P_ATTRIBUTE28 => c.p108
1276 ,P_ATTRIBUTE29 => c.p109
1277 ,P_ATTRIBUTE30 => c.p110
1278 ,P_ATTRIBUTE_CATEGORY => c.p111
1279 ,P_SEGMENT1 => c.p112
1280 ,P_SEGMENT2 => c.p113
1281 ,P_SEGMENT3 => c.p114
1282 ,P_SEGMENT4 => c.p115
1283 ,P_SEGMENT5 => c.p116
1284 ,P_SEGMENT6 => c.p117
1285 ,P_SEGMENT7 => c.p118
1286 ,P_SEGMENT8 => c.p119
1287 ,P_SEGMENT9 => c.p120
1288 ,P_SEGMENT10 => c.p121
1289 ,P_SEGMENT11 => c.p122
1290 ,P_SEGMENT12 => c.p123
1291 ,P_SEGMENT13 => c.p124
1292 ,P_SEGMENT14 => c.p125
1293 ,P_SEGMENT15 => c.p126
1294 ,P_SEGMENT16 => c.p127
1295 ,P_SEGMENT17 => c.p128
1296 ,P_SEGMENT18 => c.p129
1297 ,P_SEGMENT19 => c.p130
1298 ,P_SEGMENT20 => c.p131
1299 ,P_SEGMENT21 => c.p132
1300 ,P_SEGMENT22 => c.p133
1301 ,P_SEGMENT23 => c.p134
1302 ,P_SEGMENT24 => c.p135
1303 ,P_SEGMENT25 => c.p136
1304 ,P_SEGMENT26 => c.p137
1305 ,P_SEGMENT27 => c.p138
1306 ,P_SEGMENT28 => c.p139
1307 ,P_SEGMENT29 => c.p140
1308 ,P_SEGMENT30 => c.p141
1309 ,P_CONCAT_SEGMENTS => c.p142
1310 ,P_REQUEST_ID => c.p143
1311 ,P_PROGRAM_APPLICATION_ID => c.p144
1312 ,P_PROGRAM_ID => L_PROGRAM_ID
1313 ,P_PROGRAM_UPDATE_DATE => c.p145
1314 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
1315 ,P_EFFECTIVE_DATE => c.p146
1316 ,P_DATETRACK_MODE => c.p147);
1317 hr_data_pump.api_trc_off;
1318 --
1319 if L_VALID_GRADES_CHANGED_WARNING then
1320 c.p4 := 'TRUE';
1321 else
1322 c.p4 := 'FALSE';
1323 end if;
1324 --
1325 update hr_pump_batch_lines l set
1326 l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
1327 l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
1328 l.pval003 = decode(c.p3,null,cn,c.p3),
1329 l.pval004 = decode(c.p4,null,cn,c.p4),
1330 l.pval005 = decode(c.p5,null,cn,c.p5)
1331 where l.rowid = c.myrowid;
1332 --
1333 close cr;
1334 --
1335 hr_data_pump.exit('call');
1336 exception
1337  when hr_multi_message.error_message_exist then
1338    if cr%isopen then
1339     close cr;
1340    end if;
1341    hr_pump_utils.set_multi_msg_error_flag(true);
1342  when others then
1343  if cr%isopen then
1344   close cr;
1345  end if;
1346  raise;
1347 end call;
1348 end hrdpp_UPDATE_POSITION;