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_QUALIFICATION_TYP

Source


1 package body hrdpp_UPDATE_QUALIFICATION_TYP as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:19
4  * Generated for API: HR_QUALIFICATION_TYPE_API.UPDATE_QUALIFICATION_TYPE
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_LANGUAGE_CODE in varchar2 default null
84 ,P_NAME in varchar2 default null
85 ,P_CATEGORY in varchar2 default null
86 ,P_RANK in number default null
87 ,I_RANK in varchar2 default 'N'
88 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
89 ,P_ATTRIBUTE1 in varchar2 default null
90 ,P_ATTRIBUTE2 in varchar2 default null
91 ,P_ATTRIBUTE3 in varchar2 default null
92 ,P_ATTRIBUTE4 in varchar2 default null
93 ,P_ATTRIBUTE5 in varchar2 default null
94 ,P_ATTRIBUTE6 in varchar2 default null
95 ,P_ATTRIBUTE7 in varchar2 default null
96 ,P_ATTRIBUTE8 in varchar2 default null
97 ,P_ATTRIBUTE9 in varchar2 default null
98 ,P_ATTRIBUTE10 in varchar2 default null
99 ,P_ATTRIBUTE11 in varchar2 default null
100 ,P_ATTRIBUTE12 in varchar2 default null
101 ,P_ATTRIBUTE13 in varchar2 default null
102 ,P_ATTRIBUTE14 in varchar2 default null
103 ,P_ATTRIBUTE15 in varchar2 default null
104 ,P_ATTRIBUTE16 in varchar2 default null
105 ,P_ATTRIBUTE17 in varchar2 default null
106 ,P_ATTRIBUTE18 in varchar2 default null
107 ,P_ATTRIBUTE19 in varchar2 default null
108 ,P_ATTRIBUTE20 in varchar2 default null
109 ,P_INFORMATION_CATEGORY in varchar2 default null
110 ,P_INFORMATION1 in varchar2 default null
111 ,P_INFORMATION2 in varchar2 default null
112 ,P_INFORMATION3 in varchar2 default null
113 ,P_INFORMATION4 in varchar2 default null
114 ,P_INFORMATION5 in varchar2 default null
115 ,P_INFORMATION6 in varchar2 default null
116 ,P_INFORMATION7 in varchar2 default null
117 ,P_INFORMATION8 in varchar2 default null
118 ,P_INFORMATION9 in varchar2 default null
119 ,P_INFORMATION10 in varchar2 default null
120 ,P_INFORMATION11 in varchar2 default null
121 ,P_INFORMATION12 in varchar2 default null
122 ,P_INFORMATION13 in varchar2 default null
123 ,P_INFORMATION14 in varchar2 default null
124 ,P_INFORMATION15 in varchar2 default null
125 ,P_INFORMATION16 in varchar2 default null
126 ,P_INFORMATION17 in varchar2 default null
127 ,P_INFORMATION18 in varchar2 default null
128 ,P_INFORMATION19 in varchar2 default null
129 ,P_INFORMATION20 in varchar2 default null
130 ,P_INFORMATION21 in varchar2 default null
131 ,P_INFORMATION22 in varchar2 default null
132 ,P_INFORMATION23 in varchar2 default null
133 ,P_INFORMATION24 in varchar2 default null
134 ,P_INFORMATION25 in varchar2 default null
135 ,P_INFORMATION26 in varchar2 default null
136 ,P_INFORMATION27 in varchar2 default null
137 ,P_INFORMATION28 in varchar2 default null
138 ,P_INFORMATION29 in varchar2 default null
139 ,P_INFORMATION30 in varchar2 default null
140 ,P_QUAL_FRAMEWORK_ID in number default null
141 ,I_QUAL_FRAMEWORK_ID in varchar2 default 'N'
142 ,P_QUALIFICATION_TYPE in varchar2 default null
143 ,P_CREDIT_TYPE in varchar2 default null
144 ,P_CREDITS in number default null
145 ,I_CREDITS in varchar2 default 'N'
146 ,P_LEVEL_TYPE in varchar2 default null
147 ,P_LEVEL_NUMBER in number default null
148 ,I_LEVEL_NUMBER in varchar2 default 'N'
149 ,P_FIELD in varchar2 default null
150 ,P_SUB_FIELD in varchar2 default null
151 ,P_PROVIDER in varchar2 default null
152 ,P_QA_ORGANIZATION in varchar2 default null
153 ,P_QUALIFICATION_TYPE_NAME in varchar2) is
154 blid number := p_data_pump_batch_line_id;
155 begin
156 if blid is not null then
157 delete from hr_pump_batch_lines where batch_line_id = blid;
158 delete from hr_pump_batch_exceptions
159 where source_type = 'BATCH_LINE' and source_id = blid;
160 end if;
161 insert into hr_pump_batch_lines
162 (batch_id
163 ,batch_line_id
164 ,business_group_name
165 ,api_module_id
166 ,line_status
167 ,user_sequence
168 ,link_value
169 ,pval001
170 ,pval002
171 ,pval003
172 ,pval004
173 ,pval005
174 ,pval006
175 ,pval007
176 ,pval008
177 ,pval009
178 ,pval010
179 ,pval011
180 ,pval012
181 ,pval013
182 ,pval014
183 ,pval015
184 ,pval016
185 ,pval017
186 ,pval018
187 ,pval019
188 ,pval020
189 ,pval021
190 ,pval022
191 ,pval023
192 ,pval024
193 ,pval025
194 ,pval026
195 ,pval027
196 ,pval028
197 ,pval029
198 ,pval030
199 ,pval031
200 ,pval032
201 ,pval033
202 ,pval034
203 ,pval035
204 ,pval036
205 ,pval037
206 ,pval038
207 ,pval039
208 ,pval040
209 ,pval041
210 ,pval042
211 ,pval043
212 ,pval044
213 ,pval045
214 ,pval046
215 ,pval047
216 ,pval048
217 ,pval049
218 ,pval050
219 ,pval051
220 ,pval052
221 ,pval053
222 ,pval054
223 ,pval055
224 ,pval056
225 ,pval057
226 ,pval058
227 ,pval059
228 ,pval060
229 ,pval061
230 ,pval062
231 ,pval063
232 ,pval064
233 ,pval065
234 ,pval066
235 ,pval067
236 ,pval068)
237 values
238 (p_batch_id
239 ,nvl(blid,hr_pump_batch_lines_s.nextval)
240 ,p_data_pump_business_grp_name
241 ,3118
242 ,'U'
243 ,p_user_sequence
244 ,p_link_value
245 ,dc(P_EFFECTIVE_DATE)
246 ,P_LANGUAGE_CODE
247 ,P_NAME
248 ,P_CATEGORY
249 ,nd(P_RANK,I_RANK)
250 ,P_ATTRIBUTE_CATEGORY
251 ,P_ATTRIBUTE1
252 ,P_ATTRIBUTE2
253 ,P_ATTRIBUTE3
254 ,P_ATTRIBUTE4
255 ,P_ATTRIBUTE5
256 ,P_ATTRIBUTE6
257 ,P_ATTRIBUTE7
258 ,P_ATTRIBUTE8
259 ,P_ATTRIBUTE9
260 ,P_ATTRIBUTE10
261 ,P_ATTRIBUTE11
262 ,P_ATTRIBUTE12
263 ,P_ATTRIBUTE13
264 ,P_ATTRIBUTE14
265 ,P_ATTRIBUTE15
266 ,P_ATTRIBUTE16
267 ,P_ATTRIBUTE17
268 ,P_ATTRIBUTE18
269 ,P_ATTRIBUTE19
270 ,P_ATTRIBUTE20
271 ,P_INFORMATION_CATEGORY
272 ,P_INFORMATION1
273 ,P_INFORMATION2
274 ,P_INFORMATION3
275 ,P_INFORMATION4
276 ,P_INFORMATION5
277 ,P_INFORMATION6
278 ,P_INFORMATION7
279 ,P_INFORMATION8
280 ,P_INFORMATION9
281 ,P_INFORMATION10
282 ,P_INFORMATION11
283 ,P_INFORMATION12
284 ,P_INFORMATION13
285 ,P_INFORMATION14
286 ,P_INFORMATION15
287 ,P_INFORMATION16
288 ,P_INFORMATION17
289 ,P_INFORMATION18
290 ,P_INFORMATION19
291 ,P_INFORMATION20
292 ,P_INFORMATION21
293 ,P_INFORMATION22
294 ,P_INFORMATION23
295 ,P_INFORMATION24
296 ,P_INFORMATION25
297 ,P_INFORMATION26
298 ,P_INFORMATION27
299 ,P_INFORMATION28
300 ,P_INFORMATION29
301 ,P_INFORMATION30
302 ,nd(P_QUAL_FRAMEWORK_ID,I_QUAL_FRAMEWORK_ID)
303 ,P_QUALIFICATION_TYPE
304 ,P_CREDIT_TYPE
305 ,nd(P_CREDITS,I_CREDITS)
306 ,P_LEVEL_TYPE
307 ,nd(P_LEVEL_NUMBER,I_LEVEL_NUMBER)
308 ,P_FIELD
309 ,P_SUB_FIELD
310 ,P_PROVIDER
311 ,P_QA_ORGANIZATION
312 ,P_QUALIFICATION_TYPE_NAME);
313 end insert_batch_lines;
314 --
315 procedure call
316 (p_business_group_id in number,
317 p_batch_line_id     in number) is
318 cursor cr is
319 select l.rowid myrowid,
320 decode(l.pval001,cn,dn,d(l.pval001)) p1,
321 decode(l.pval002,cn,vn,vn,vh,l.pval002) p2,
322 l.pval002 d2,
323 decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
324 l.pval003 d3,
325 decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
326 l.pval004 d4,
327 decode(l.pval005,cn,nn,vn,nh,n(l.pval005)) p5,
328 l.pval005 d5,
329 decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
330 l.pval006 d6,
331 decode(l.pval007,cn,vn,vn,vh,l.pval007) p7,
332 l.pval007 d7,
333 decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
334 l.pval008 d8,
335 decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
336 l.pval009 d9,
337 decode(l.pval010,cn,vn,vn,vh,l.pval010) p10,
338 l.pval010 d10,
339 decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
340 l.pval011 d11,
341 decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
342 l.pval012 d12,
343 decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,
344 l.pval013 d13,
345 decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
346 l.pval014 d14,
347 decode(l.pval015,cn,vn,vn,vh,l.pval015) p15,
348 l.pval015 d15,
349 decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
350 l.pval016 d16,
351 decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
352 l.pval017 d17,
353 decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
354 l.pval018 d18,
355 decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
359 decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,
356 l.pval019 d19,
357 decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,
358 l.pval020 d20,
360 l.pval021 d21,
361 decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,
362 l.pval022 d22,
363 decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
364 l.pval023 d23,
365 decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
366 l.pval024 d24,
367 decode(l.pval025,cn,vn,vn,vh,l.pval025) p25,
368 l.pval025 d25,
369 decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
370 l.pval026 d26,
371 decode(l.pval027,cn,vn,vn,vh,l.pval027) p27,
372 l.pval027 d27,
373 decode(l.pval028,cn,vn,vn,vh,l.pval028) p28,
374 l.pval028 d28,
375 decode(l.pval029,cn,vn,vn,vh,l.pval029) p29,
376 l.pval029 d29,
377 decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
378 l.pval030 d30,
379 decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
380 l.pval031 d31,
381 decode(l.pval032,cn,vn,vn,vh,l.pval032) p32,
382 l.pval032 d32,
383 decode(l.pval033,cn,vn,vn,vh,l.pval033) p33,
384 l.pval033 d33,
385 decode(l.pval034,cn,vn,vn,vh,l.pval034) p34,
386 l.pval034 d34,
387 decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
388 l.pval035 d35,
389 decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
390 l.pval036 d36,
391 decode(l.pval037,cn,vn,vn,vh,l.pval037) p37,
392 l.pval037 d37,
393 decode(l.pval038,cn,vn,vn,vh,l.pval038) p38,
394 l.pval038 d38,
395 decode(l.pval039,cn,vn,vn,vh,l.pval039) p39,
396 l.pval039 d39,
397 decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
398 l.pval040 d40,
399 decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
400 l.pval041 d41,
401 decode(l.pval042,cn,vn,vn,vh,l.pval042) p42,
402 l.pval042 d42,
403 decode(l.pval043,cn,vn,vn,vh,l.pval043) p43,
404 l.pval043 d43,
405 decode(l.pval044,cn,vn,vn,vh,l.pval044) p44,
406 l.pval044 d44,
407 decode(l.pval045,cn,vn,vn,vh,l.pval045) p45,
408 l.pval045 d45,
409 decode(l.pval046,cn,vn,vn,vh,l.pval046) p46,
410 l.pval046 d46,
411 decode(l.pval047,cn,vn,vn,vh,l.pval047) p47,
412 l.pval047 d47,
413 decode(l.pval048,cn,vn,vn,vh,l.pval048) p48,
414 l.pval048 d48,
415 decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
416 l.pval049 d49,
417 decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
418 l.pval050 d50,
419 decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
420 l.pval051 d51,
421 decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
422 l.pval052 d52,
423 decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
424 l.pval053 d53,
425 decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
426 l.pval054 d54,
427 decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
428 l.pval055 d55,
429 decode(l.pval056,cn,vn,vn,vh,l.pval056) p56,
430 l.pval056 d56,
431 decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
432 l.pval057 d57,
433 decode(l.pval058,cn,nn,vn,nh,n(l.pval058)) p58,
434 l.pval058 d58,
435 decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
436 l.pval059 d59,
437 decode(l.pval060,cn,vn,vn,vh,
438  hr_pump_get.gl(l.pval060,'PER_QUAL_FWK_CREDIT_TYPE',d(l.pval001),l.pval002)) p60,
439 l.pval060 d60,
440 decode(l.pval061,cn,nn,vn,nh,n(l.pval061)) p61,
441 l.pval061 d61,
442 decode(l.pval062,cn,vn,vn,vh,
443  hr_pump_get.gl(l.pval062,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p62,
444 l.pval062 d62,
445 decode(l.pval063,cn,nn,vn,nh,
446  hr_pump_get.gl(l.pval063,'PER_QUAL_FWK_LEVEL_NUMBER',d(l.pval001),l.pval002)) p63,
447 l.pval063 d63,
448 decode(l.pval064,cn,vn,vn,vh,
449  hr_pump_get.gl(l.pval064,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p64,
450 l.pval064 d64,
451 decode(l.pval065,cn,vn,vn,vh,
452  hr_pump_get.gl(l.pval065,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p65,
453 l.pval065 d65,
454 decode(l.pval066,cn,vn,vn,vh,
455  hr_pump_get.gl(l.pval066,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p66,
456 l.pval066 d66,
457 decode(l.pval067,cn,vn,vn,vh,
458  hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,
459 l.pval067 d67,
460 decode(l.pval068,cn,vn,l.pval068) p68
461 from hr_pump_batch_lines l
462 where l.batch_line_id = p_batch_line_id;
463 --
464 c cr%rowtype;
465 l_validate boolean := false;
466 L_QUALIFICATION_TYPE_ID number;
467 L_OBJECT_VERSION_NUMBER number;
468 --
469 begin
470 hr_data_pump.entry('call');
471 open cr;
472 fetch cr into c;
473 if cr%notfound then
474 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
475 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
476 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
477 hr_utility.set_message_token('VALUE',p_batch_line_id);
478 hr_utility.raise_error;
479 end if;
480 --
481 L_QUALIFICATION_TYPE_ID := 
482 hr_pump_get.get_qualification_type_id
483 (P_DATA_PUMP_ALWAYS_CALL => null
484 ,P_QUALIFICATION_TYPE_NAME => c.p68);
485 --
486 L_OBJECT_VERSION_NUMBER := 
487 hr_pump_get.GET_EQT_OVN
488 (P_DATA_PUMP_ALWAYS_CALL => null
489 ,P_QUALIFICATION_TYPE_NAME => c.p68);
490 --
491 hr_data_pump.api_trc_on;
492 HR_QUALIFICATION_TYPE_API.UPDATE_QUALIFICATION_TYPE
493 (p_validate => l_validate
494 ,P_QUALIFICATION_TYPE_ID => L_QUALIFICATION_TYPE_ID
495 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
496 ,P_EFFECTIVE_DATE => c.p1
497 ,P_LANGUAGE_CODE => c.p2
498 ,P_NAME => c.p3
499 ,P_CATEGORY => c.p4
500 ,P_RANK => c.p5
501 ,P_ATTRIBUTE_CATEGORY => c.p6
502 ,P_ATTRIBUTE1 => c.p7
503 ,P_ATTRIBUTE2 => c.p8
504 ,P_ATTRIBUTE3 => c.p9
505 ,P_ATTRIBUTE4 => c.p10
506 ,P_ATTRIBUTE5 => c.p11
507 ,P_ATTRIBUTE6 => c.p12
508 ,P_ATTRIBUTE7 => c.p13
509 ,P_ATTRIBUTE8 => c.p14
510 ,P_ATTRIBUTE9 => c.p15
511 ,P_ATTRIBUTE10 => c.p16
512 ,P_ATTRIBUTE11 => c.p17
513 ,P_ATTRIBUTE12 => c.p18
514 ,P_ATTRIBUTE13 => c.p19
515 ,P_ATTRIBUTE14 => c.p20
516 ,P_ATTRIBUTE15 => c.p21
517 ,P_ATTRIBUTE16 => c.p22
518 ,P_ATTRIBUTE17 => c.p23
519 ,P_ATTRIBUTE18 => c.p24
520 ,P_ATTRIBUTE19 => c.p25
521 ,P_ATTRIBUTE20 => c.p26
522 ,P_INFORMATION_CATEGORY => c.p27
523 ,P_INFORMATION1 => c.p28
524 ,P_INFORMATION2 => c.p29
525 ,P_INFORMATION3 => c.p30
526 ,P_INFORMATION4 => c.p31
527 ,P_INFORMATION5 => c.p32
528 ,P_INFORMATION6 => c.p33
529 ,P_INFORMATION7 => c.p34
530 ,P_INFORMATION8 => c.p35
531 ,P_INFORMATION9 => c.p36
532 ,P_INFORMATION10 => c.p37
533 ,P_INFORMATION11 => c.p38
534 ,P_INFORMATION12 => c.p39
535 ,P_INFORMATION13 => c.p40
536 ,P_INFORMATION14 => c.p41
537 ,P_INFORMATION15 => c.p42
538 ,P_INFORMATION16 => c.p43
539 ,P_INFORMATION17 => c.p44
540 ,P_INFORMATION18 => c.p45
541 ,P_INFORMATION19 => c.p46
542 ,P_INFORMATION20 => c.p47
543 ,P_INFORMATION21 => c.p48
544 ,P_INFORMATION22 => c.p49
545 ,P_INFORMATION23 => c.p50
546 ,P_INFORMATION24 => c.p51
547 ,P_INFORMATION25 => c.p52
548 ,P_INFORMATION26 => c.p53
549 ,P_INFORMATION27 => c.p54
550 ,P_INFORMATION28 => c.p55
551 ,P_INFORMATION29 => c.p56
552 ,P_INFORMATION30 => c.p57
553 ,P_QUAL_FRAMEWORK_ID => c.p58
554 ,P_QUALIFICATION_TYPE => c.p59
555 ,P_CREDIT_TYPE => c.p60
556 ,P_CREDITS => c.p61
557 ,P_LEVEL_TYPE => c.p62
558 ,P_LEVEL_NUMBER => c.p63
559 ,P_FIELD => c.p64
560 ,P_SUB_FIELD => c.p65
561 ,P_PROVIDER => c.p66
562 ,P_QA_ORGANIZATION => c.p67);
563 hr_data_pump.api_trc_off;
564 
565 --
566 
567 --
568 close cr;
569 --
570 hr_data_pump.exit('call');
571 exception
572  when hr_multi_message.error_message_exist then
573    if cr%isopen then
574     close cr;
575    end if;
576    hr_pump_utils.set_multi_msg_error_flag(true);
577  when others then
578  if cr%isopen then
579   close cr;
580  end if;
581  raise;
582 end call;
583 end hrdpp_UPDATE_QUALIFICATION_TYP;