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_AU_EMP_ASG

Source


4  * Generated for API: HR_AU_ASSIGNMENT_API.UPDATE_AU_EMP_ASG
1 package body hrdpp_UPDATE_AU_EMP_ASG as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2013/08/13 18:08:41
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);
48 begin
45 end n;
46 function dd(p in date,i in varchar2)
47 return varchar2 is
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_DATETRACK_UPDATE_MODE in varchar2
84 ,P_ASSIGNMENT_NUMBER in varchar2 default null
85 ,P_CHANGE_REASON in varchar2 default null
86 ,P_COMMENTS in clob default null
87 ,P_DATE_PROBATION_END in date default null
88 ,I_DATE_PROBATION_END in varchar2 default 'N'
89 ,P_FREQUENCY in varchar2 default null
90 ,P_INTERNAL_ADDRESS_LINE in varchar2 default null
91 ,P_MANAGER_FLAG in varchar2 default null
92 ,P_NORMAL_HOURS in number default null
93 ,I_NORMAL_HOURS in varchar2 default 'N'
94 ,P_PERF_REVIEW_PERIOD in number default null
95 ,I_PERF_REVIEW_PERIOD in varchar2 default 'N'
96 ,P_PERF_REVIEW_PERIOD_FREQUENCY in varchar2 default null
97 ,P_PROBATION_PERIOD in number default null
98 ,I_PROBATION_PERIOD in varchar2 default 'N'
99 ,P_PROBATION_UNIT in varchar2 default null
100 ,P_SAL_REVIEW_PERIOD in number default null
101 ,I_SAL_REVIEW_PERIOD in varchar2 default 'N'
102 ,P_SAL_REVIEW_PERIOD_FREQUENCY in varchar2 default null
103 ,P_SOURCE_TYPE in varchar2 default null
104 ,P_TIME_NORMAL_FINISH in varchar2 default null
105 ,P_TIME_NORMAL_START in varchar2 default null
106 ,P_BARGAINING_UNIT_CODE in varchar2 default null
107 ,P_LABOUR_UNION_MEMBER_FLAG in varchar2 default null
108 ,P_HOURLY_SALARIED_CODE in varchar2 default null
109 ,P_ASS_ATTRIBUTE_CATEGORY in varchar2 default null
110 ,P_ASS_ATTRIBUTE1 in varchar2 default null
111 ,P_ASS_ATTRIBUTE2 in varchar2 default null
112 ,P_ASS_ATTRIBUTE3 in varchar2 default null
113 ,P_ASS_ATTRIBUTE4 in varchar2 default null
114 ,P_ASS_ATTRIBUTE5 in varchar2 default null
115 ,P_ASS_ATTRIBUTE6 in varchar2 default null
116 ,P_ASS_ATTRIBUTE7 in varchar2 default null
117 ,P_ASS_ATTRIBUTE8 in varchar2 default null
118 ,P_ASS_ATTRIBUTE9 in varchar2 default null
119 ,P_ASS_ATTRIBUTE10 in varchar2 default null
120 ,P_ASS_ATTRIBUTE11 in varchar2 default null
121 ,P_ASS_ATTRIBUTE12 in varchar2 default null
122 ,P_ASS_ATTRIBUTE13 in varchar2 default null
123 ,P_ASS_ATTRIBUTE14 in varchar2 default null
124 ,P_ASS_ATTRIBUTE15 in varchar2 default null
125 ,P_ASS_ATTRIBUTE16 in varchar2 default null
126 ,P_ASS_ATTRIBUTE17 in varchar2 default null
127 ,P_ASS_ATTRIBUTE18 in varchar2 default null
128 ,P_ASS_ATTRIBUTE19 in varchar2 default null
129 ,P_ASS_ATTRIBUTE20 in varchar2 default null
130 ,P_ASS_ATTRIBUTE21 in varchar2 default null
131 ,P_ASS_ATTRIBUTE22 in varchar2 default null
132 ,P_ASS_ATTRIBUTE23 in varchar2 default null
133 ,P_ASS_ATTRIBUTE24 in varchar2 default null
134 ,P_ASS_ATTRIBUTE25 in varchar2 default null
135 ,P_ASS_ATTRIBUTE26 in varchar2 default null
136 ,P_ASS_ATTRIBUTE27 in varchar2 default null
137 ,P_ASS_ATTRIBUTE28 in varchar2 default null
138 ,P_ASS_ATTRIBUTE29 in varchar2 default null
139 ,P_ASS_ATTRIBUTE30 in varchar2 default null
140 ,P_TITLE in varchar2 default null
141 ,P_LEV_LOD_FLG in varchar2 default null
142 ,P_GROUP_CERT_ISSUE_DATE in varchar2 default null
143 ,P_HRS_WORKED_PER_WEEK in varchar2 default null
144 ,P_CAGR_ID_FLEX_NUM in number default null
145 ,I_CAGR_ID_FLEX_NUM in varchar2 default 'N'
146 ,P_CAG_SEGMENT1 in varchar2 default null
147 ,P_CAG_SEGMENT2 in varchar2 default null
148 ,P_CAG_SEGMENT3 in varchar2 default null
149 ,P_CAG_SEGMENT4 in varchar2 default null
150 ,P_CAG_SEGMENT5 in varchar2 default null
151 ,P_CAG_SEGMENT6 in varchar2 default null
152 ,P_CAG_SEGMENT7 in varchar2 default null
153 ,P_CAG_SEGMENT8 in varchar2 default null
154 ,P_CAG_SEGMENT9 in varchar2 default null
155 ,P_CAG_SEGMENT10 in varchar2 default null
156 ,P_CAG_SEGMENT11 in varchar2 default null
157 ,P_CAG_SEGMENT12 in varchar2 default null
158 ,P_CAG_SEGMENT13 in varchar2 default null
159 ,P_CAG_SEGMENT14 in varchar2 default null
160 ,P_CAG_SEGMENT15 in varchar2 default null
161 ,P_CAG_SEGMENT16 in varchar2 default null
162 ,P_CAG_SEGMENT17 in varchar2 default null
163 ,P_CAG_SEGMENT18 in varchar2 default null
164 ,P_CAG_SEGMENT19 in varchar2 default null
165 ,P_CAG_SEGMENT20 in varchar2 default null
166 ,P_ASSIGNMENT_USER_KEY in varchar2
167 ,P_SUPERVISOR_USER_KEY in varchar2 default null
168 ,P_DEFAULT_CODE_COMB_USER_KEY in varchar2 default null
169 ,P_SET_OF_BOOKS_NAME in varchar2 default null
170 ,P_LEGAL_EMPLOYER_NAME in varchar2 default null
171 ,P_CONTRACT_USER_KEY in varchar2 default null
172 ,P_ESTABLISHMENT_NAME in varchar2 default null
173 ,P_LOCATION in varchar2 default null
174 ,P_CAGR_NAME in varchar2 default null) is
175 blid number := p_data_pump_batch_line_id;
176 begin
177 if blid is not null then
178 delete from hr_pump_batch_lines where batch_line_id = blid;
179 delete from hr_pump_batch_exceptions
183 (batch_id
180 where source_type = 'BATCH_LINE' and source_id = blid;
181 end if;
182 insert into hr_pump_batch_lines
184 ,batch_line_id
185 ,business_group_name
186 ,api_module_id
187 ,line_status
188 ,user_sequence
189 ,link_value
190 ,pval001
191 ,pval002
192 ,pval003
193 ,pval004
194 ,pval005
195 ,pval006
196 ,pval007
197 ,pval008
198 ,pval009
199 ,pval010
200 ,pval011
201 ,pval012
202 ,pval013
203 ,pval014
204 ,pval015
205 ,pval016
206 ,pval017
207 ,pval018
208 ,pval019
209 ,pval020
210 ,pval021
211 ,pval022
212 ,pval023
213 ,pval024
214 ,pval025
215 ,pval026
216 ,pval027
217 ,pval028
218 ,pval029
219 ,pval030
220 ,pval031
221 ,pval032
222 ,pval033
223 ,pval034
224 ,pval035
225 ,pval036
226 ,pval037
227 ,pval038
228 ,pval039
229 ,pval040
230 ,pval041
231 ,pval042
232 ,pval043
233 ,pval044
234 ,pval045
235 ,pval046
236 ,pval047
237 ,pval048
238 ,pval049
239 ,pval050
240 ,pval051
241 ,pval052
242 ,pval053
243 ,pval054
244 ,pval055
245 ,pval056
246 ,pval057
247 ,pval058
248 ,pval059
249 ,pval060
250 ,pval061
251 ,pval062
252 ,pval063
253 ,pval064
254 ,pval065
255 ,pval066
256 ,pval067
257 ,pval068
258 ,pval069
259 ,pval070
260 ,pval071
261 ,pval072
262 ,pval073
263 ,pval074
264 ,pval075
265 ,pval076
266 ,pval077
267 ,pval078
268 ,pval088
269 ,pval089
270 ,pval090
271 ,pval091
272 ,pval092
273 ,pval093
274 ,pval094
275 ,pval095
276 ,pval096)
277 values
278 (p_batch_id
279 ,nvl(blid,hr_pump_batch_lines_s.nextval)
280 ,p_data_pump_business_grp_name
281 ,2162
282 ,'U'
283 ,p_user_sequence
284 ,p_link_value
285 ,dc(P_EFFECTIVE_DATE)
286 ,P_DATETRACK_UPDATE_MODE
287 ,P_ASSIGNMENT_NUMBER
288 ,P_CHANGE_REASON
289 ,P_COMMENTS
290 ,dd(P_DATE_PROBATION_END,I_DATE_PROBATION_END)
291 ,P_FREQUENCY
292 ,P_INTERNAL_ADDRESS_LINE
293 ,P_MANAGER_FLAG
294 ,nd(P_NORMAL_HOURS,I_NORMAL_HOURS)
295 ,nd(P_PERF_REVIEW_PERIOD,I_PERF_REVIEW_PERIOD)
296 ,P_PERF_REVIEW_PERIOD_FREQUENCY
297 ,nd(P_PROBATION_PERIOD,I_PROBATION_PERIOD)
298 ,P_PROBATION_UNIT
299 ,nd(P_SAL_REVIEW_PERIOD,I_SAL_REVIEW_PERIOD)
300 ,P_SAL_REVIEW_PERIOD_FREQUENCY
301 ,P_SOURCE_TYPE
302 ,P_TIME_NORMAL_FINISH
303 ,P_TIME_NORMAL_START
304 ,P_BARGAINING_UNIT_CODE
305 ,P_LABOUR_UNION_MEMBER_FLAG
306 ,P_HOURLY_SALARIED_CODE
307 ,P_ASS_ATTRIBUTE_CATEGORY
308 ,P_ASS_ATTRIBUTE1
309 ,P_ASS_ATTRIBUTE2
310 ,P_ASS_ATTRIBUTE3
311 ,P_ASS_ATTRIBUTE4
312 ,P_ASS_ATTRIBUTE5
313 ,P_ASS_ATTRIBUTE6
314 ,P_ASS_ATTRIBUTE7
315 ,P_ASS_ATTRIBUTE8
316 ,P_ASS_ATTRIBUTE9
317 ,P_ASS_ATTRIBUTE10
318 ,P_ASS_ATTRIBUTE11
319 ,P_ASS_ATTRIBUTE12
320 ,P_ASS_ATTRIBUTE13
321 ,P_ASS_ATTRIBUTE14
322 ,P_ASS_ATTRIBUTE15
323 ,P_ASS_ATTRIBUTE16
324 ,P_ASS_ATTRIBUTE17
325 ,P_ASS_ATTRIBUTE18
326 ,P_ASS_ATTRIBUTE19
327 ,P_ASS_ATTRIBUTE20
328 ,P_ASS_ATTRIBUTE21
329 ,P_ASS_ATTRIBUTE22
330 ,P_ASS_ATTRIBUTE23
331 ,P_ASS_ATTRIBUTE24
332 ,P_ASS_ATTRIBUTE25
333 ,P_ASS_ATTRIBUTE26
334 ,P_ASS_ATTRIBUTE27
335 ,P_ASS_ATTRIBUTE28
336 ,P_ASS_ATTRIBUTE29
337 ,P_ASS_ATTRIBUTE30
338 ,P_TITLE
339 ,P_LEV_LOD_FLG
340 ,P_GROUP_CERT_ISSUE_DATE
341 ,P_HRS_WORKED_PER_WEEK
342 ,nd(P_CAGR_ID_FLEX_NUM,I_CAGR_ID_FLEX_NUM)
343 ,P_CAG_SEGMENT1
344 ,P_CAG_SEGMENT2
345 ,P_CAG_SEGMENT3
346 ,P_CAG_SEGMENT4
347 ,P_CAG_SEGMENT5
348 ,P_CAG_SEGMENT6
349 ,P_CAG_SEGMENT7
350 ,P_CAG_SEGMENT8
351 ,P_CAG_SEGMENT9
352 ,P_CAG_SEGMENT10
353 ,P_CAG_SEGMENT11
354 ,P_CAG_SEGMENT12
355 ,P_CAG_SEGMENT13
356 ,P_CAG_SEGMENT14
357 ,P_CAG_SEGMENT15
358 ,P_CAG_SEGMENT16
359 ,P_CAG_SEGMENT17
360 ,P_CAG_SEGMENT18
361 ,P_CAG_SEGMENT19
362 ,P_CAG_SEGMENT20
363 ,P_ASSIGNMENT_USER_KEY
364 ,P_SUPERVISOR_USER_KEY
365 ,P_DEFAULT_CODE_COMB_USER_KEY
366 ,P_SET_OF_BOOKS_NAME
367 ,P_LEGAL_EMPLOYER_NAME
368 ,P_CONTRACT_USER_KEY
369 ,P_ESTABLISHMENT_NAME
370 ,P_LOCATION
371 ,P_CAGR_NAME);
372 end insert_batch_lines;
373 --
374 procedure call
375 (p_business_group_id in number,
376 p_batch_line_id     in number) is
377 cursor cr is
378 select l.rowid myrowid,
379 decode(l.pval001,cn,dn,d(l.pval001)) p1,
380 decode(l.pval002,cn,vn,l.pval002) p2,
381 decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
382 l.pval003 d3,
383 decode(l.pval004,cn,vn,vn,vh,
384  hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),vn)) p4,
385 l.pval004 d4,
386 decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
387 l.pval005 d5,
388 decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
389 l.pval006 d6,
390 decode(l.pval007,cn,vn,vn,vh,
391  hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),vn)) p7,
392 l.pval007 d7,
393 decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
394 l.pval008 d8,
395 decode(l.pval009,cn,vn,vn,vh,
396  hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,
397 l.pval009 d9,
398 decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
399 l.pval010 d10,
400 decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
404 l.pval012 d12,
401 l.pval011 d11,
402 decode(l.pval012,cn,vn,vn,vh,
403  hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),vn)) p12,
405 decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
406 l.pval013 d13,
407 decode(l.pval014,cn,vn,vn,vh,
408  hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),vn)) p14,
409 l.pval014 d14,
410 decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
411 l.pval015 d15,
412 decode(l.pval016,cn,vn,vn,vh,
413  hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,
414 l.pval016 d16,
415 decode(l.pval017,cn,vn,vn,vh,
416  hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,
417 l.pval017 d17,
418 decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
419 l.pval018 d18,
420 decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
421 l.pval019 d19,
422 decode(l.pval020,cn,vn,vn,vh,
426  hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
423  hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,
424 l.pval020 d20,
425 decode(l.pval021,cn,vn,vn,'N',
427 l.pval021 d21,
428 decode(l.pval022,cn,vn,vn,vh,
429  hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,
430 l.pval022 d22,
431 decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
432 l.pval023 d23,
433 decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
434 l.pval024 d24,
435 decode(l.pval025,cn,vn,vn,vh,l.pval025) p25,
436 l.pval025 d25,
437 decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
438 l.pval026 d26,
439 decode(l.pval027,cn,vn,vn,vh,l.pval027) p27,
440 l.pval027 d27,
441 decode(l.pval028,cn,vn,vn,vh,l.pval028) p28,
442 l.pval028 d28,
443 decode(l.pval029,cn,vn,vn,vh,l.pval029) p29,
444 l.pval029 d29,
445 decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
446 l.pval030 d30,
447 decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
448 l.pval031 d31,
449 decode(l.pval032,cn,vn,vn,vh,l.pval032) p32,
450 l.pval032 d32,
451 decode(l.pval033,cn,vn,vn,vh,l.pval033) p33,
452 l.pval033 d33,
453 decode(l.pval034,cn,vn,vn,vh,l.pval034) p34,
454 l.pval034 d34,
455 decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
456 l.pval035 d35,
457 decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
458 l.pval036 d36,
459 decode(l.pval037,cn,vn,vn,vh,l.pval037) p37,
460 l.pval037 d37,
461 decode(l.pval038,cn,vn,vn,vh,l.pval038) p38,
462 l.pval038 d38,
463 decode(l.pval039,cn,vn,vn,vh,l.pval039) p39,
464 l.pval039 d39,
465 decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
466 l.pval040 d40,
467 decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
468 l.pval041 d41,
469 decode(l.pval042,cn,vn,vn,vh,l.pval042) p42,
470 l.pval042 d42,
471 decode(l.pval043,cn,vn,vn,vh,l.pval043) p43,
472 l.pval043 d43,
473 decode(l.pval044,cn,vn,vn,vh,l.pval044) p44,
474 l.pval044 d44,
475 decode(l.pval045,cn,vn,vn,vh,l.pval045) p45,
476 l.pval045 d45,
477 decode(l.pval046,cn,vn,vn,vh,l.pval046) p46,
478 l.pval046 d46,
479 decode(l.pval047,cn,vn,vn,vh,l.pval047) p47,
480 l.pval047 d47,
481 decode(l.pval048,cn,vn,vn,vh,l.pval048) p48,
482 l.pval048 d48,
483 decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
484 l.pval049 d49,
485 decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
486 l.pval050 d50,
487 decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
488 l.pval051 d51,
489 decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
490 l.pval052 d52,
491 decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
492 l.pval053 d53,
493 decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
494 l.pval054 d54,
495 decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
496 l.pval055 d55,
497 decode(l.pval056,cn,vn,vn,vh,l.pval056) p56,
498 l.pval056 d56,
499 decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
500 l.pval057 d57,
501 decode(l.pval058,cn,nn,vn,nh,n(l.pval058)) p58,
502 l.pval058 d58,
503 decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
504 l.pval059 d59,
505 decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,
506 l.pval060 d60,
507 decode(l.pval061,cn,vn,vn,vh,l.pval061) p61,
508 l.pval061 d61,
509 decode(l.pval062,cn,vn,vn,vh,l.pval062) p62,
510 l.pval062 d62,
511 decode(l.pval063,cn,vn,vn,vh,l.pval063) p63,
512 l.pval063 d63,
513 decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
514 l.pval064 d64,
515 decode(l.pval065,cn,vn,vn,vh,l.pval065) p65,
516 l.pval065 d65,
517 decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
518 l.pval066 d66,
519 decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
520 l.pval067 d67,
521 decode(l.pval068,cn,vn,vn,vh,l.pval068) p68,
522 l.pval068 d68,
523 decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
524 l.pval069 d69,
525 decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
526 l.pval070 d70,
527 decode(l.pval071,cn,vn,vn,vh,l.pval071) p71,
528 l.pval071 d71,
529 decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
530 l.pval072 d72,
531 decode(l.pval073,cn,vn,vn,vh,l.pval073) p73,
535 decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
532 l.pval073 d73,
533 decode(l.pval074,cn,vn,vn,vh,l.pval074) p74,
534 l.pval074 d74,
536 l.pval075 d75,
537 decode(l.pval076,cn,vn,vn,vh,l.pval076) p76,
538 l.pval076 d76,
539 decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
540 l.pval077 d77,
541 decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,
542 l.pval078 d78,
543 l.pval079 p79,
544 l.pval080 p80,
545 l.pval081 p81,
546 l.pval082 p82,
547 decode(l.pval083,cn,dn,d(l.pval083)) p83,
548 decode(l.pval084,cn,dn,d(l.pval084)) p84,
549 l.pval085 p85,
550 l.pval086 p86,
551 l.pval087 p87,
552 decode(l.pval088,cn,vn,l.pval088) p88,
553 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
554 l.pval089 d89,
555 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
556 l.pval090 d90,
557 decode(l.pval091,cn,vn,vn,vh,l.pval091) p91,
558 l.pval091 d91,
559 decode(l.pval092,cn,vn,vn,vh,l.pval092) p92,
560 l.pval092 d92,
561 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
562 l.pval093 d93,
563 decode(l.pval094,cn,vn,vn,vh,l.pval094) p94,
564 l.pval094 d94,
565 decode(l.pval095,cn,vn,vn,vh,l.pval095) p95,
566 l.pval095 d95,
567 decode(l.pval096,cn,vn,vn,vh,l.pval096) p96,
568 l.pval096 d96
569 from hr_pump_batch_lines l
570 where l.batch_line_id = p_batch_line_id;
571 --
572 c cr%rowtype;
573 l_validate boolean := false;
574 L_NO_MANAGERS_WARNING boolean;
575 L_OTHER_MANAGER_WARNING boolean;
576 L_ASSIGNMENT_ID number;
577 L_OBJECT_VERSION_NUMBER number;
578 L_SUPERVISOR_ID number;
579 L_DEFAULT_CODE_COMB_ID number;
580 L_SET_OF_BOOKS_ID number;
581 L_LEGAL_EMPLOYER_ID varchar2(2000);
582 L_CONTRACT_ID number;
583 L_ESTABLISHMENT_ID number;
584 L_COLLECTIVE_AGREEMENT_ID number;
585 --
586 begin
587 hr_data_pump.entry('call');
588 open cr;
589 fetch cr into c;
590 if cr%notfound then
591 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
592 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
593 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
594 hr_utility.set_message_token('VALUE',p_batch_line_id);
595 hr_utility.raise_error;
596 end if;
597 --
598 if c.p88 is null then
599 L_ASSIGNMENT_ID:=nn;
600 else
601 L_ASSIGNMENT_ID := 
602 hr_pump_get.get_assignment_id
603 (P_ASSIGNMENT_USER_KEY => c.p88);
604 end if;
605 --
606 if c.p88 is null or
607 c.p1 is null then
608 L_OBJECT_VERSION_NUMBER:=nn;
609 else
610 L_OBJECT_VERSION_NUMBER := 
611 hr_pump_get.GET_ASG_OVN
612 (P_ASSIGNMENT_USER_KEY => c.p88
613 ,P_EFFECTIVE_DATE => c.p1);
614 end if;
615 --
616 if c.d89=cn then
617 L_SUPERVISOR_ID:=nn;
618 elsif c.d89 is null then 
619 L_SUPERVISOR_ID:=nh;
620 else
621 L_SUPERVISOR_ID := 
625 --
622 hr_pump_get.get_supervisor_id
623 (P_SUPERVISOR_USER_KEY => c.p89);
624 end if;
626 if c.d90=cn then
627 L_DEFAULT_CODE_COMB_ID:=nn;
628 elsif c.d90 is null then 
629 L_DEFAULT_CODE_COMB_ID:=nh;
630 else
631 L_DEFAULT_CODE_COMB_ID := 
632 hr_pump_get.get_default_code_comb_id
633 (P_DEFAULT_CODE_COMB_USER_KEY => c.p90);
634 end if;
635 --
636 if c.d91=cn then
637 L_SET_OF_BOOKS_ID:=nn;
638 elsif c.d91 is null then 
639 L_SET_OF_BOOKS_ID:=nh;
640 else
641 L_SET_OF_BOOKS_ID := 
642 hr_pump_get.get_set_of_books_id
643 (P_SET_OF_BOOKS_NAME => c.p91);
644 end if;
645 --
646 if c.d92=cn then
647 L_LEGAL_EMPLOYER_ID:=vn;
648 elsif c.d92 is null then 
649 L_LEGAL_EMPLOYER_ID:=vh;
650 else
651 L_LEGAL_EMPLOYER_ID := 
652 PER_AU_DATA_PUMP.get_legal_employer_id
653 (P_LEGAL_EMPLOYER_NAME => c.p92
654 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
655 end if;
656 --
657 if c.d93=cn then
658 L_CONTRACT_ID:=nn;
659 elsif c.d93 is null then 
660 L_CONTRACT_ID:=nh;
661 else
662 L_CONTRACT_ID := 
663 hr_pump_get.get_contract_id
664 (P_CONTRACT_USER_KEY => c.p93);
665 end if;
666 --
667 if c.d94=cn or
668 c.d95=cn then
669 L_ESTABLISHMENT_ID:=nn;
670 elsif c.d94 is null or
671 c.d95 is null then 
672 L_ESTABLISHMENT_ID:=nh;
673 else
674 L_ESTABLISHMENT_ID := 
675 hr_pump_get.get_establishment_id
676 (P_ESTABLISHMENT_NAME => c.p94
677 ,P_LOCATION => c.p95);
678 end if;
679 --
680 if c.d96=cn or
681 c.p1 is null then
682 L_COLLECTIVE_AGREEMENT_ID:=nn;
683 elsif c.d96 is null then 
684 L_COLLECTIVE_AGREEMENT_ID:=nh;
685 else
686 L_COLLECTIVE_AGREEMENT_ID := 
687 hr_pump_get.get_collective_agreement_id
688 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
689 ,P_CAGR_NAME => c.p96
690 ,P_EFFECTIVE_DATE => c.p1);
691 end if;
695 (p_validate => l_validate
692 --
693 hr_data_pump.api_trc_on;
694 HR_AU_ASSIGNMENT_API.UPDATE_AU_EMP_ASG
696 ,P_EFFECTIVE_DATE => c.p1
697 ,P_DATETRACK_UPDATE_MODE => c.p2
698 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
699 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
700 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
701 ,P_ASSIGNMENT_NUMBER => c.p3
702 ,P_CHANGE_REASON => c.p4
703 ,P_COMMENTS => c.p5
704 ,P_DATE_PROBATION_END => c.p6
705 ,P_DEFAULT_CODE_COMB_ID => L_DEFAULT_CODE_COMB_ID
706 ,P_FREQUENCY => c.p7
707 ,P_INTERNAL_ADDRESS_LINE => c.p8
708 ,P_MANAGER_FLAG => c.p9
709 ,P_NORMAL_HOURS => c.p10
710 ,P_PERF_REVIEW_PERIOD => c.p11
711 ,P_PERF_REVIEW_PERIOD_FREQUENCY => c.p12
712 ,P_PROBATION_PERIOD => c.p13
713 ,P_PROBATION_UNIT => c.p14
714 ,P_SAL_REVIEW_PERIOD => c.p15
715 ,P_SAL_REVIEW_PERIOD_FREQUENCY => c.p16
716 ,P_SET_OF_BOOKS_ID => L_SET_OF_BOOKS_ID
717 ,P_SOURCE_TYPE => c.p17
718 ,P_TIME_NORMAL_FINISH => c.p18
719 ,P_TIME_NORMAL_START => c.p19
720 ,P_BARGAINING_UNIT_CODE => c.p20
721 ,P_LABOUR_UNION_MEMBER_FLAG => c.p21
722 ,P_HOURLY_SALARIED_CODE => c.p22
723 ,P_ASS_ATTRIBUTE_CATEGORY => c.p23
724 ,P_ASS_ATTRIBUTE1 => c.p24
725 ,P_ASS_ATTRIBUTE2 => c.p25
726 ,P_ASS_ATTRIBUTE3 => c.p26
727 ,P_ASS_ATTRIBUTE4 => c.p27
728 ,P_ASS_ATTRIBUTE5 => c.p28
729 ,P_ASS_ATTRIBUTE6 => c.p29
730 ,P_ASS_ATTRIBUTE7 => c.p30
731 ,P_ASS_ATTRIBUTE8 => c.p31
732 ,P_ASS_ATTRIBUTE9 => c.p32
733 ,P_ASS_ATTRIBUTE10 => c.p33
734 ,P_ASS_ATTRIBUTE11 => c.p34
735 ,P_ASS_ATTRIBUTE12 => c.p35
736 ,P_ASS_ATTRIBUTE13 => c.p36
737 ,P_ASS_ATTRIBUTE14 => c.p37
738 ,P_ASS_ATTRIBUTE15 => c.p38
739 ,P_ASS_ATTRIBUTE16 => c.p39
740 ,P_ASS_ATTRIBUTE17 => c.p40
741 ,P_ASS_ATTRIBUTE18 => c.p41
742 ,P_ASS_ATTRIBUTE19 => c.p42
743 ,P_ASS_ATTRIBUTE20 => c.p43
744 ,P_ASS_ATTRIBUTE21 => c.p44
745 ,P_ASS_ATTRIBUTE22 => c.p45
746 ,P_ASS_ATTRIBUTE23 => c.p46
747 ,P_ASS_ATTRIBUTE24 => c.p47
748 ,P_ASS_ATTRIBUTE25 => c.p48
749 ,P_ASS_ATTRIBUTE26 => c.p49
750 ,P_ASS_ATTRIBUTE27 => c.p50
751 ,P_ASS_ATTRIBUTE28 => c.p51
752 ,P_ASS_ATTRIBUTE29 => c.p52
753 ,P_ASS_ATTRIBUTE30 => c.p53
754 ,P_TITLE => c.p54
755 ,P_LEGAL_EMPLOYER_ID => L_LEGAL_EMPLOYER_ID
756 ,P_LEV_LOD_FLG => c.p55
757 ,P_GROUP_CERT_ISSUE_DATE => c.p56
758 ,P_HRS_WORKED_PER_WEEK => c.p57
759 ,P_CONTRACT_ID => L_CONTRACT_ID
760 ,P_ESTABLISHMENT_ID => L_ESTABLISHMENT_ID
761 ,P_COLLECTIVE_AGREEMENT_ID => L_COLLECTIVE_AGREEMENT_ID
762 ,P_CAGR_ID_FLEX_NUM => c.p58
763 ,P_CAG_SEGMENT1 => c.p59
764 ,P_CAG_SEGMENT2 => c.p60
765 ,P_CAG_SEGMENT3 => c.p61
766 ,P_CAG_SEGMENT4 => c.p62
767 ,P_CAG_SEGMENT5 => c.p63
768 ,P_CAG_SEGMENT6 => c.p64
769 ,P_CAG_SEGMENT7 => c.p65
770 ,P_CAG_SEGMENT8 => c.p66
771 ,P_CAG_SEGMENT9 => c.p67
772 ,P_CAG_SEGMENT10 => c.p68
773 ,P_CAG_SEGMENT11 => c.p69
774 ,P_CAG_SEGMENT12 => c.p70
775 ,P_CAG_SEGMENT13 => c.p71
776 ,P_CAG_SEGMENT14 => c.p72
777 ,P_CAG_SEGMENT15 => c.p73
778 ,P_CAG_SEGMENT16 => c.p74
779 ,P_CAG_SEGMENT17 => c.p75
780 ,P_CAG_SEGMENT18 => c.p76
781 ,P_CAG_SEGMENT19 => c.p77
782 ,P_CAG_SEGMENT20 => c.p78
783 ,P_CAGR_GRADE_DEF_ID => c.p79
784 ,P_CAGR_CONCATENATED_SEGMENTS => c.p80
785 ,P_COMMENT_ID => c.p81
786 ,P_SOFT_CODING_KEYFLEX_ID => c.p82
787 ,P_EFFECTIVE_START_DATE => c.p83
788 ,P_EFFECTIVE_END_DATE => c.p84
789 ,P_CONCATENATED_SEGMENTS => c.p85
790 ,P_NO_MANAGERS_WARNING => L_NO_MANAGERS_WARNING
791 ,P_OTHER_MANAGER_WARNING => L_OTHER_MANAGER_WARNING);
792 hr_data_pump.api_trc_off;
793 --
794 if L_NO_MANAGERS_WARNING then
795 c.p86 := 'TRUE';
796 else
797 c.p86 := 'FALSE';
798 end if;
799 --
800 if L_OTHER_MANAGER_WARNING then
801 c.p87 := 'TRUE';
802 else
803 c.p87 := 'FALSE';
804 end if;
805 --
806 update hr_pump_batch_lines l set
807 l.pval079 = decode(c.p79,null,cn,c.p79),
808 l.pval080 = decode(c.p80,null,cn,c.p80),
809 l.pval081 = decode(c.p81,null,cn,c.p81),
810 l.pval082 = decode(c.p82,null,cn,c.p82),
811 l.pval083 = decode(c.p83,null,cn,dc(c.p83)),
812 l.pval084 = decode(c.p84,null,cn,dc(c.p84)),
813 l.pval085 = decode(c.p85,null,cn,c.p85),
814 l.pval086 = decode(c.p86,null,cn,c.p86),
815 l.pval087 = decode(c.p87,null,cn,c.p87)
816 where l.rowid = c.myrowid;
817 --
818 close cr;
819 --
820 hr_data_pump.exit('call');
821 exception
822  when hr_multi_message.error_message_exist then
823    if cr%isopen then
824     close cr;
825    end if;
826    hr_pump_utils.set_multi_msg_error_flag(true);
827  when others then
828  if cr%isopen then
829   close cr;
830  end if;
831  raise;
832 end call;
833 end hrdpp_UPDATE_AU_EMP_ASG;