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_UPLOAD_SALARY_PROPOSAL

Source


1 package body hrdpp_UPLOAD_SALARY_PROPOSAL as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:53
4  * Generated for API: HR_UPLOAD_PROPOSAL_API.UPLOAD_SALARY_PROPOSAL
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_CHANGE_DATE in date
83 ,P_PROPOSED_SALARY in number default null
84 ,P_PROPOSAL_REASON in varchar2 default null
85 ,P_NEXT_SAL_REVIEW_DATE in date default null
86 ,P_FORCED_RANKING in number default null
87 ,P_DATE_TO in date default null
88 ,P_PAY_PROPOSAL_ID in number
89 ,P_OBJECT_VERSION_NUMBER in number
90 ,P_COMPONENT_REASON_1 in varchar2
91 ,P_CHANGE_AMOUNT_1 in number default null
92 ,P_CHANGE_PERCENTAGE_1 in number default null
93 ,P_APPROVED_1 in varchar2
94 ,P_COMPONENT_ID_1 in number
95 ,P_PPC_OBJECT_VERSION_NUMBER_1 in number
96 ,P_COMPONENT_REASON_2 in varchar2
97 ,P_CHANGE_AMOUNT_2 in number default null
98 ,P_CHANGE_PERCENTAGE_2 in number default null
99 ,P_APPROVED_2 in varchar2
100 ,P_COMPONENT_ID_2 in number
101 ,P_PPC_OBJECT_VERSION_NUMBER_2 in number
102 ,P_COMPONENT_REASON_3 in varchar2
103 ,P_CHANGE_AMOUNT_3 in number default null
104 ,P_CHANGE_PERCENTAGE_3 in number default null
105 ,P_APPROVED_3 in varchar2
106 ,P_COMPONENT_ID_3 in number
107 ,P_PPC_OBJECT_VERSION_NUMBER_3 in number
108 ,P_COMPONENT_REASON_4 in varchar2
109 ,P_CHANGE_AMOUNT_4 in number default null
110 ,P_CHANGE_PERCENTAGE_4 in number default null
111 ,P_APPROVED_4 in varchar2
112 ,P_COMPONENT_ID_4 in number
113 ,P_PPC_OBJECT_VERSION_NUMBER_4 in number
114 ,P_COMPONENT_REASON_5 in varchar2
115 ,P_CHANGE_AMOUNT_5 in number default null
116 ,P_CHANGE_PERCENTAGE_5 in number default null
117 ,P_APPROVED_5 in varchar2
118 ,P_COMPONENT_ID_5 in number
119 ,P_PPC_OBJECT_VERSION_NUMBER_5 in number
120 ,P_COMPONENT_REASON_6 in varchar2
121 ,P_CHANGE_AMOUNT_6 in number default null
122 ,P_CHANGE_PERCENTAGE_6 in number default null
123 ,P_APPROVED_6 in varchar2
124 ,P_COMPONENT_ID_6 in number
125 ,P_PPC_OBJECT_VERSION_NUMBER_6 in number
126 ,P_COMPONENT_REASON_7 in varchar2
127 ,P_CHANGE_AMOUNT_7 in number default null
128 ,P_CHANGE_PERCENTAGE_7 in number default null
129 ,P_APPROVED_7 in varchar2
130 ,P_COMPONENT_ID_7 in number
131 ,P_PPC_OBJECT_VERSION_NUMBER_7 in number
132 ,P_COMPONENT_REASON_8 in varchar2
133 ,P_CHANGE_AMOUNT_8 in number default null
134 ,P_CHANGE_PERCENTAGE_8 in number default null
135 ,P_APPROVED_8 in varchar2
136 ,P_COMPONENT_ID_8 in number
137 ,P_PPC_OBJECT_VERSION_NUMBER_8 in number
138 ,P_COMPONENT_REASON_9 in varchar2
139 ,P_CHANGE_AMOUNT_9 in number default null
140 ,P_CHANGE_PERCENTAGE_9 in number default null
141 ,P_APPROVED_9 in varchar2
142 ,P_COMPONENT_ID_9 in number
143 ,P_PPC_OBJECT_VERSION_NUMBER_9 in number
144 ,P_COMPONENT_REASON_10 in varchar2
145 ,P_CHANGE_AMOUNT_10 in number default null
146 ,P_CHANGE_PERCENTAGE_10 in number default null
147 ,P_APPROVED_10 in varchar2
148 ,P_COMPONENT_ID_10 in number
149 ,P_PPC_OBJECT_VERSION_NUMBER_10 in number
150 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
151 ,P_ATTRIBUTE1 in varchar2 default null
152 ,P_ATTRIBUTE2 in varchar2 default null
153 ,P_ATTRIBUTE3 in varchar2 default null
154 ,P_ATTRIBUTE4 in varchar2 default null
155 ,P_ATTRIBUTE5 in varchar2 default null
156 ,P_ATTRIBUTE6 in varchar2 default null
157 ,P_ATTRIBUTE7 in varchar2 default null
158 ,P_ATTRIBUTE8 in varchar2 default null
159 ,P_ATTRIBUTE9 in varchar2 default null
160 ,P_ATTRIBUTE10 in varchar2 default null
161 ,P_ATTRIBUTE11 in varchar2 default null
162 ,P_ATTRIBUTE12 in varchar2 default null
163 ,P_ATTRIBUTE13 in varchar2 default null
164 ,P_ATTRIBUTE14 in varchar2 default null
165 ,P_ATTRIBUTE15 in varchar2 default null
166 ,P_ATTRIBUTE16 in varchar2 default null
167 ,P_ATTRIBUTE17 in varchar2 default null
168 ,P_ATTRIBUTE18 in varchar2 default null
169 ,P_ATTRIBUTE19 in varchar2 default null
170 ,P_ATTRIBUTE20 in varchar2 default null
171 ,P_ASSIGNMENT_USER_KEY in varchar2) is
172 blid number := p_data_pump_batch_line_id;
173 begin
174 if blid is not null then
175 delete from hr_pump_batch_lines where batch_line_id = blid;
176 delete from hr_pump_batch_exceptions
177 where source_type = 'BATCH_LINE' and source_id = blid;
178 end if;
179 insert into hr_pump_batch_lines
180 (batch_id
181 ,batch_line_id
182 ,business_group_name
183 ,api_module_id
184 ,line_status
185 ,user_sequence
186 ,link_value
187 ,pval001
188 ,pval002
189 ,pval003
190 ,pval004
191 ,pval005
192 ,pval006
193 ,pval007
194 ,pval008
195 ,pval009
196 ,pval010
197 ,pval011
198 ,pval012
199 ,pval013
200 ,pval014
201 ,pval015
202 ,pval016
203 ,pval017
204 ,pval018
205 ,pval019
206 ,pval020
207 ,pval021
208 ,pval022
209 ,pval023
210 ,pval024
211 ,pval025
212 ,pval026
213 ,pval027
214 ,pval028
215 ,pval029
216 ,pval030
217 ,pval031
218 ,pval032
219 ,pval033
220 ,pval034
221 ,pval035
222 ,pval036
223 ,pval037
224 ,pval038
225 ,pval039
226 ,pval040
227 ,pval041
228 ,pval042
229 ,pval043
230 ,pval044
231 ,pval045
232 ,pval046
233 ,pval047
234 ,pval048
235 ,pval049
236 ,pval050
237 ,pval051
238 ,pval052
239 ,pval053
240 ,pval054
241 ,pval055
242 ,pval056
243 ,pval057
244 ,pval058
245 ,pval059
246 ,pval060
247 ,pval061
248 ,pval062
249 ,pval063
250 ,pval064
251 ,pval065
252 ,pval066
253 ,pval067
254 ,pval068
255 ,pval071
256 ,pval072
257 ,pval073
258 ,pval074
259 ,pval075
260 ,pval076
261 ,pval077
262 ,pval078
263 ,pval079
264 ,pval080
265 ,pval081
266 ,pval082
267 ,pval083
268 ,pval084
269 ,pval085
270 ,pval086
271 ,pval087
272 ,pval088
273 ,pval089
274 ,pval090
275 ,pval091
276 ,pval092)
277 values
278 (p_batch_id
279 ,nvl(blid,hr_pump_batch_lines_s.nextval)
280 ,p_data_pump_business_grp_name
281 ,1324
282 ,'U'
283 ,p_user_sequence
284 ,p_link_value
285 ,dc(P_CHANGE_DATE)
286 ,P_PROPOSED_SALARY
287 ,P_PROPOSAL_REASON
288 ,dc(P_NEXT_SAL_REVIEW_DATE)
289 ,P_FORCED_RANKING
290 ,dc(P_DATE_TO)
291 ,P_PAY_PROPOSAL_ID
292 ,P_OBJECT_VERSION_NUMBER
293 ,P_COMPONENT_REASON_1
294 ,P_CHANGE_AMOUNT_1
295 ,P_CHANGE_PERCENTAGE_1
296 ,P_APPROVED_1
297 ,P_COMPONENT_ID_1
298 ,P_PPC_OBJECT_VERSION_NUMBER_1
299 ,P_COMPONENT_REASON_2
300 ,P_CHANGE_AMOUNT_2
301 ,P_CHANGE_PERCENTAGE_2
302 ,P_APPROVED_2
303 ,P_COMPONENT_ID_2
304 ,P_PPC_OBJECT_VERSION_NUMBER_2
305 ,P_COMPONENT_REASON_3
306 ,P_CHANGE_AMOUNT_3
307 ,P_CHANGE_PERCENTAGE_3
308 ,P_APPROVED_3
309 ,P_COMPONENT_ID_3
310 ,P_PPC_OBJECT_VERSION_NUMBER_3
311 ,P_COMPONENT_REASON_4
312 ,P_CHANGE_AMOUNT_4
313 ,P_CHANGE_PERCENTAGE_4
314 ,P_APPROVED_4
315 ,P_COMPONENT_ID_4
316 ,P_PPC_OBJECT_VERSION_NUMBER_4
317 ,P_COMPONENT_REASON_5
318 ,P_CHANGE_AMOUNT_5
319 ,P_CHANGE_PERCENTAGE_5
320 ,P_APPROVED_5
321 ,P_COMPONENT_ID_5
322 ,P_PPC_OBJECT_VERSION_NUMBER_5
323 ,P_COMPONENT_REASON_6
324 ,P_CHANGE_AMOUNT_6
325 ,P_CHANGE_PERCENTAGE_6
326 ,P_APPROVED_6
327 ,P_COMPONENT_ID_6
328 ,P_PPC_OBJECT_VERSION_NUMBER_6
329 ,P_COMPONENT_REASON_7
330 ,P_CHANGE_AMOUNT_7
331 ,P_CHANGE_PERCENTAGE_7
332 ,P_APPROVED_7
333 ,P_COMPONENT_ID_7
334 ,P_PPC_OBJECT_VERSION_NUMBER_7
335 ,P_COMPONENT_REASON_8
336 ,P_CHANGE_AMOUNT_8
337 ,P_CHANGE_PERCENTAGE_8
338 ,P_APPROVED_8
339 ,P_COMPONENT_ID_8
340 ,P_PPC_OBJECT_VERSION_NUMBER_8
341 ,P_COMPONENT_REASON_9
342 ,P_CHANGE_AMOUNT_9
343 ,P_CHANGE_PERCENTAGE_9
344 ,P_APPROVED_9
345 ,P_COMPONENT_ID_9
346 ,P_PPC_OBJECT_VERSION_NUMBER_9
347 ,P_COMPONENT_REASON_10
348 ,P_CHANGE_AMOUNT_10
349 ,P_CHANGE_PERCENTAGE_10
350 ,P_APPROVED_10
351 ,P_COMPONENT_ID_10
352 ,P_PPC_OBJECT_VERSION_NUMBER_10
353 ,P_ATTRIBUTE_CATEGORY
354 ,P_ATTRIBUTE1
355 ,P_ATTRIBUTE2
356 ,P_ATTRIBUTE3
357 ,P_ATTRIBUTE4
358 ,P_ATTRIBUTE5
359 ,P_ATTRIBUTE6
360 ,P_ATTRIBUTE7
361 ,P_ATTRIBUTE8
362 ,P_ATTRIBUTE9
363 ,P_ATTRIBUTE10
364 ,P_ATTRIBUTE11
365 ,P_ATTRIBUTE12
366 ,P_ATTRIBUTE13
367 ,P_ATTRIBUTE14
368 ,P_ATTRIBUTE15
369 ,P_ATTRIBUTE16
370 ,P_ATTRIBUTE17
371 ,P_ATTRIBUTE18
372 ,P_ATTRIBUTE19
373 ,P_ATTRIBUTE20
374 ,P_ASSIGNMENT_USER_KEY);
375 end insert_batch_lines;
376 --
377 procedure call
378 (p_business_group_id in number,
379 p_batch_line_id     in number) is
380 cursor cr is
381 select l.rowid myrowid,
385 decode(l.pval003,cn,vn,vn,vn,
382 decode(l.pval001,cn,dn,d(l.pval001)) p1,
383 decode(l.pval002,cn,nn,vn,nn,n(l.pval002)) p2,
384 l.pval002 d2,
386  hr_pump_get.gl(l.pval003,'PROPOSAL_REASON',dn,vn)) p3,
387 l.pval003 d3,
388 decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,
389 l.pval004 d4,
390 decode(l.pval005,cn,nn,vn,nn,n(l.pval005)) p5,
391 l.pval005 d5,
392 decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
393 l.pval006 d6,
394 decode(l.pval007,cn,nn,n(l.pval007)) p7,
395 decode(l.pval008,cn,nn,n(l.pval008)) p8,
396 decode(l.pval009,cn,vn,
397  hr_pump_get.gl(l.pval009,'PROPOSAL_REASON',dn,vn)) p9,
398 decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
399 l.pval010 d10,
400 decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
401 l.pval011 d11,
402 decode(l.pval012,cn,vn,
403  hr_pump_get.gl(l.pval012,'YES_NO',dn,vn)) p12,
404 decode(l.pval013,cn,nn,n(l.pval013)) p13,
405 decode(l.pval014,cn,nn,n(l.pval014)) p14,
406 decode(l.pval015,cn,vn,
407  hr_pump_get.gl(l.pval015,'PROPOSAL_REASON',dn,vn)) p15,
408 decode(l.pval016,cn,nn,vn,nn,n(l.pval016)) p16,
409 l.pval016 d16,
410 decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
411 l.pval017 d17,
412 decode(l.pval018,cn,vn,
413  hr_pump_get.gl(l.pval018,'YES_NO',dn,vn)) p18,
414 decode(l.pval019,cn,nn,n(l.pval019)) p19,
415 decode(l.pval020,cn,nn,n(l.pval020)) p20,
416 decode(l.pval021,cn,vn,
417  hr_pump_get.gl(l.pval021,'PROPOSAL_REASON',dn,vn)) p21,
418 decode(l.pval022,cn,nn,vn,nn,n(l.pval022)) p22,
419 l.pval022 d22,
420 decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
421 l.pval023 d23,
422 decode(l.pval024,cn,vn,
423  hr_pump_get.gl(l.pval024,'YES_NO',dn,vn)) p24,
424 decode(l.pval025,cn,nn,n(l.pval025)) p25,
425 decode(l.pval026,cn,nn,n(l.pval026)) p26,
426 decode(l.pval027,cn,vn,
427  hr_pump_get.gl(l.pval027,'PROPOSAL_REASON',dn,vn)) p27,
428 decode(l.pval028,cn,nn,vn,nn,n(l.pval028)) p28,
429 l.pval028 d28,
430 decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
431 l.pval029 d29,
432 decode(l.pval030,cn,vn,
433  hr_pump_get.gl(l.pval030,'YES_NO',dn,vn)) p30,
434 decode(l.pval031,cn,nn,n(l.pval031)) p31,
435 decode(l.pval032,cn,nn,n(l.pval032)) p32,
436 decode(l.pval033,cn,vn,
437  hr_pump_get.gl(l.pval033,'PROPOSAL_REASON',dn,vn)) p33,
438 decode(l.pval034,cn,nn,vn,nn,n(l.pval034)) p34,
439 l.pval034 d34,
440 decode(l.pval035,cn,nn,vn,nn,n(l.pval035)) p35,
441 l.pval035 d35,
442 decode(l.pval036,cn,vn,
443  hr_pump_get.gl(l.pval036,'YES_NO',dn,vn)) p36,
444 decode(l.pval037,cn,nn,n(l.pval037)) p37,
445 decode(l.pval038,cn,nn,n(l.pval038)) p38,
446 decode(l.pval039,cn,vn,
447  hr_pump_get.gl(l.pval039,'PROPOSAL_REASON',dn,vn)) p39,
448 decode(l.pval040,cn,nn,vn,nn,n(l.pval040)) p40,
449 l.pval040 d40,
450 decode(l.pval041,cn,nn,vn,nn,n(l.pval041)) p41,
451 l.pval041 d41,
452 decode(l.pval042,cn,vn,
453  hr_pump_get.gl(l.pval042,'YES_NO',dn,vn)) p42,
454 decode(l.pval043,cn,nn,n(l.pval043)) p43,
455 decode(l.pval044,cn,nn,n(l.pval044)) p44,
456 decode(l.pval045,cn,vn,
457  hr_pump_get.gl(l.pval045,'PROPOSAL_REASON',dn,vn)) p45,
458 decode(l.pval046,cn,nn,vn,nn,n(l.pval046)) p46,
459 l.pval046 d46,
460 decode(l.pval047,cn,nn,vn,nn,n(l.pval047)) p47,
461 l.pval047 d47,
462 decode(l.pval048,cn,vn,
463  hr_pump_get.gl(l.pval048,'YES_NO',dn,vn)) p48,
464 decode(l.pval049,cn,nn,n(l.pval049)) p49,
465 decode(l.pval050,cn,nn,n(l.pval050)) p50,
466 decode(l.pval051,cn,vn,
467  hr_pump_get.gl(l.pval051,'PROPOSAL_REASON',dn,vn)) p51,
468 decode(l.pval052,cn,nn,vn,nn,n(l.pval052)) p52,
469 l.pval052 d52,
470 decode(l.pval053,cn,nn,vn,nn,n(l.pval053)) p53,
471 l.pval053 d53,
472 decode(l.pval054,cn,vn,
473  hr_pump_get.gl(l.pval054,'YES_NO',dn,vn)) p54,
474 decode(l.pval055,cn,nn,n(l.pval055)) p55,
475 decode(l.pval056,cn,nn,n(l.pval056)) p56,
476 decode(l.pval057,cn,vn,
477  hr_pump_get.gl(l.pval057,'PROPOSAL_REASON',dn,vn)) p57,
478 decode(l.pval058,cn,nn,vn,nn,n(l.pval058)) p58,
479 l.pval058 d58,
480 decode(l.pval059,cn,nn,vn,nn,n(l.pval059)) p59,
481 l.pval059 d59,
482 decode(l.pval060,cn,vn,
483  hr_pump_get.gl(l.pval060,'YES_NO',dn,vn)) p60,
484 decode(l.pval061,cn,nn,n(l.pval061)) p61,
485 decode(l.pval062,cn,nn,n(l.pval062)) p62,
486 decode(l.pval063,cn,vn,
487  hr_pump_get.gl(l.pval063,'PROPOSAL_REASON',dn,vn)) p63,
488 decode(l.pval064,cn,nn,vn,nn,n(l.pval064)) p64,
489 l.pval064 d64,
490 decode(l.pval065,cn,nn,vn,nn,n(l.pval065)) p65,
491 l.pval065 d65,
492 decode(l.pval066,cn,vn,
493  hr_pump_get.gl(l.pval066,'YES_NO',dn,vn)) p66,
494 decode(l.pval067,cn,nn,n(l.pval067)) p67,
495 decode(l.pval068,cn,nn,n(l.pval068)) p68,
496 l.pval069 p69,
497 l.pval070 p70,
498 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
499 l.pval071 d71,
500 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
501 l.pval072 d72,
502 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
503 l.pval073 d73,
504 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
505 l.pval074 d74,
506 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
507 l.pval075 d75,
508 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
509 l.pval076 d76,
510 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
511 l.pval077 d77,
512 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
513 l.pval078 d78,
514 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
515 l.pval079 d79,
516 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
517 l.pval080 d80,
518 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
519 l.pval081 d81,
520 decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
521 l.pval082 d82,
522 decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
523 l.pval083 d83,
527 l.pval085 d85,
524 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
525 l.pval084 d84,
526 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
528 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
529 l.pval086 d86,
530 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
531 l.pval087 d87,
532 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
533 l.pval088 d88,
534 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
535 l.pval089 d89,
536 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
537 l.pval090 d90,
538 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
539 l.pval091 d91,
540 decode(l.pval092,cn,vn,l.pval092) p92
541 from hr_pump_batch_lines l
542 where l.batch_line_id = p_batch_line_id;
543 --
544 c cr%rowtype;
545 l_validate boolean := false;
546 L_PYP_PROPOSED_SAL_WARNING boolean;
547 L_ADDITIONAL_COMP_WARNING boolean;
548 L_ASSIGNMENT_ID number;
549 --
550 begin
551 hr_data_pump.entry('call');
552 open cr;
553 fetch cr into c;
554 if cr%notfound then
555 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
556 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
557 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
558 hr_utility.set_message_token('VALUE',p_batch_line_id);
559 hr_utility.raise_error;
560 end if;
561 --
562 if c.p92 is null then
563 L_ASSIGNMENT_ID:=nn;
564 else
565 L_ASSIGNMENT_ID := 
566 hr_pump_get.get_assignment_id
567 (P_ASSIGNMENT_USER_KEY => c.p92);
568 end if;
569 --
570 hr_data_pump.api_trc_on;
571 HR_UPLOAD_PROPOSAL_API.UPLOAD_SALARY_PROPOSAL
572 (p_validate => l_validate
573 ,P_CHANGE_DATE => c.p1
574 ,p_business_group_id => p_business_group_id
575 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
576 ,P_PROPOSED_SALARY => c.p2
577 ,P_PROPOSAL_REASON => c.p3
578 ,P_NEXT_SAL_REVIEW_DATE => c.p4
579 ,P_FORCED_RANKING => c.p5
580 ,P_DATE_TO => c.p6
581 ,P_PAY_PROPOSAL_ID => c.p7
582 ,P_OBJECT_VERSION_NUMBER => c.p8
583 ,P_COMPONENT_REASON_1 => c.p9
584 ,P_CHANGE_AMOUNT_1 => c.p10
585 ,P_CHANGE_PERCENTAGE_1 => c.p11
586 ,P_APPROVED_1 => c.p12
587 ,P_COMPONENT_ID_1 => c.p13
588 ,P_PPC_OBJECT_VERSION_NUMBER_1 => c.p14
589 ,P_COMPONENT_REASON_2 => c.p15
590 ,P_CHANGE_AMOUNT_2 => c.p16
591 ,P_CHANGE_PERCENTAGE_2 => c.p17
592 ,P_APPROVED_2 => c.p18
593 ,P_COMPONENT_ID_2 => c.p19
594 ,P_PPC_OBJECT_VERSION_NUMBER_2 => c.p20
595 ,P_COMPONENT_REASON_3 => c.p21
596 ,P_CHANGE_AMOUNT_3 => c.p22
597 ,P_CHANGE_PERCENTAGE_3 => c.p23
598 ,P_APPROVED_3 => c.p24
599 ,P_COMPONENT_ID_3 => c.p25
600 ,P_PPC_OBJECT_VERSION_NUMBER_3 => c.p26
601 ,P_COMPONENT_REASON_4 => c.p27
602 ,P_CHANGE_AMOUNT_4 => c.p28
603 ,P_CHANGE_PERCENTAGE_4 => c.p29
604 ,P_APPROVED_4 => c.p30
605 ,P_COMPONENT_ID_4 => c.p31
606 ,P_PPC_OBJECT_VERSION_NUMBER_4 => c.p32
607 ,P_COMPONENT_REASON_5 => c.p33
608 ,P_CHANGE_AMOUNT_5 => c.p34
609 ,P_CHANGE_PERCENTAGE_5 => c.p35
610 ,P_APPROVED_5 => c.p36
611 ,P_COMPONENT_ID_5 => c.p37
612 ,P_PPC_OBJECT_VERSION_NUMBER_5 => c.p38
613 ,P_COMPONENT_REASON_6 => c.p39
614 ,P_CHANGE_AMOUNT_6 => c.p40
615 ,P_CHANGE_PERCENTAGE_6 => c.p41
616 ,P_APPROVED_6 => c.p42
617 ,P_COMPONENT_ID_6 => c.p43
618 ,P_PPC_OBJECT_VERSION_NUMBER_6 => c.p44
619 ,P_COMPONENT_REASON_7 => c.p45
620 ,P_CHANGE_AMOUNT_7 => c.p46
621 ,P_CHANGE_PERCENTAGE_7 => c.p47
622 ,P_APPROVED_7 => c.p48
623 ,P_COMPONENT_ID_7 => c.p49
624 ,P_PPC_OBJECT_VERSION_NUMBER_7 => c.p50
625 ,P_COMPONENT_REASON_8 => c.p51
626 ,P_CHANGE_AMOUNT_8 => c.p52
627 ,P_CHANGE_PERCENTAGE_8 => c.p53
628 ,P_APPROVED_8 => c.p54
629 ,P_COMPONENT_ID_8 => c.p55
630 ,P_PPC_OBJECT_VERSION_NUMBER_8 => c.p56
631 ,P_COMPONENT_REASON_9 => c.p57
632 ,P_CHANGE_AMOUNT_9 => c.p58
633 ,P_CHANGE_PERCENTAGE_9 => c.p59
634 ,P_APPROVED_9 => c.p60
635 ,P_COMPONENT_ID_9 => c.p61
636 ,P_PPC_OBJECT_VERSION_NUMBER_9 => c.p62
637 ,P_COMPONENT_REASON_10 => c.p63
638 ,P_CHANGE_AMOUNT_10 => c.p64
639 ,P_CHANGE_PERCENTAGE_10 => c.p65
640 ,P_APPROVED_10 => c.p66
641 ,P_COMPONENT_ID_10 => c.p67
642 ,P_PPC_OBJECT_VERSION_NUMBER_10 => c.p68
643 ,P_PYP_PROPOSED_SAL_WARNING => L_PYP_PROPOSED_SAL_WARNING
644 ,P_ADDITIONAL_COMP_WARNING => L_ADDITIONAL_COMP_WARNING
645 ,P_ATTRIBUTE_CATEGORY => c.p71
646 ,P_ATTRIBUTE1 => c.p72
647 ,P_ATTRIBUTE2 => c.p73
648 ,P_ATTRIBUTE3 => c.p74
649 ,P_ATTRIBUTE4 => c.p75
650 ,P_ATTRIBUTE5 => c.p76
651 ,P_ATTRIBUTE6 => c.p77
652 ,P_ATTRIBUTE7 => c.p78
653 ,P_ATTRIBUTE8 => c.p79
654 ,P_ATTRIBUTE9 => c.p80
655 ,P_ATTRIBUTE10 => c.p81
656 ,P_ATTRIBUTE11 => c.p82
657 ,P_ATTRIBUTE12 => c.p83
658 ,P_ATTRIBUTE13 => c.p84
659 ,P_ATTRIBUTE14 => c.p85
660 ,P_ATTRIBUTE15 => c.p86
661 ,P_ATTRIBUTE16 => c.p87
662 ,P_ATTRIBUTE17 => c.p88
663 ,P_ATTRIBUTE18 => c.p89
664 ,P_ATTRIBUTE19 => c.p90
665 ,P_ATTRIBUTE20 => c.p91);
666 hr_data_pump.api_trc_off;
667 --
668 if L_PYP_PROPOSED_SAL_WARNING then
669 c.p69 := 'TRUE';
670 else
671 c.p69 := 'FALSE';
672 end if;
673 --
674 if L_ADDITIONAL_COMP_WARNING then
675 c.p70 := 'TRUE';
676 else
677 c.p70 := 'FALSE';
678 end if;
679 --
680 update hr_pump_batch_lines l set
681 l.pval007 = decode(c.p7,null,cn,c.p7),
682 l.pval008 = decode(c.p8,null,cn,c.p8),
683 l.pval013 = decode(c.p13,null,cn,c.p13),
684 l.pval014 = decode(c.p14,null,cn,c.p14),
685 l.pval019 = decode(c.p19,null,cn,c.p19),
686 l.pval020 = decode(c.p20,null,cn,c.p20),
687 l.pval025 = decode(c.p25,null,cn,c.p25),
688 l.pval026 = decode(c.p26,null,cn,c.p26),
689 l.pval031 = decode(c.p31,null,cn,c.p31),
690 l.pval032 = decode(c.p32,null,cn,c.p32),
691 l.pval037 = decode(c.p37,null,cn,c.p37),
692 l.pval038 = decode(c.p38,null,cn,c.p38),
693 l.pval043 = decode(c.p43,null,cn,c.p43),
694 l.pval044 = decode(c.p44,null,cn,c.p44),
695 l.pval049 = decode(c.p49,null,cn,c.p49),
696 l.pval050 = decode(c.p50,null,cn,c.p50),
697 l.pval055 = decode(c.p55,null,cn,c.p55),
698 l.pval056 = decode(c.p56,null,cn,c.p56),
699 l.pval061 = decode(c.p61,null,cn,c.p61),
700 l.pval062 = decode(c.p62,null,cn,c.p62),
701 l.pval067 = decode(c.p67,null,cn,c.p67),
702 l.pval068 = decode(c.p68,null,cn,c.p68),
703 l.pval069 = decode(c.p69,null,cn,c.p69),
704 l.pval070 = decode(c.p70,null,cn,c.p70)
705 where l.rowid = c.myrowid;
706 --
707 close cr;
708 --
709 hr_data_pump.exit('call');
710 exception
711  when hr_multi_message.error_message_exist then
712    if cr%isopen then
713     close cr;
714    end if;
715    hr_pump_utils.set_multi_msg_error_flag(true);
716  when others then
717  if cr%isopen then
718   close cr;
719  end if;
720  raise;
721 end call;
722 end hrdpp_UPLOAD_SALARY_PROPOSAL;