eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HRDPP_CREATE_RU_APPLICANT

Source


1 package body hrdpp_CREATE_RU_APPLICANT as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:22
4  * Generated for API: HR_RU_APPLICANT_API.CREATE_RU_APPLICANT
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_DATE_RECEIVED in date
83 ,P_LAST_NAME in varchar2
84 ,P_APPLICANT_NUMBER in varchar2
85 ,P_PER_COMMENTS in varchar2 default null
86 ,P_DATE_EMPLOYEE_DATA_VERIFIED in date default null
87 ,P_DATE_OF_BIRTH in date default null
88 ,P_EMAIL_ADDRESS in varchar2 default null
89 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in varchar2 default null
90 ,P_FIRST_NAME in varchar2
91 ,P_KNOWN_AS in varchar2 default null
92 ,P_MARITAL_STATUS in varchar2 default null
93 ,P_MIDDLE_NAMES in varchar2 default null
94 ,P_NATIONALITY in varchar2 default null
95 ,P_INN in varchar2 default null
96 ,P_PREVIOUS_LAST_NAME in varchar2 default null
97 ,P_REGISTERED_DISABLED_FLAG in varchar2 default null
98 ,P_SEX in varchar2 default null
99 ,P_TITLE in varchar2 default null
100 ,P_WORK_TELEPHONE in varchar2 default null
101 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
102 ,P_ATTRIBUTE1 in varchar2 default null
103 ,P_ATTRIBUTE2 in varchar2 default null
104 ,P_ATTRIBUTE3 in varchar2 default null
105 ,P_ATTRIBUTE4 in varchar2 default null
106 ,P_ATTRIBUTE5 in varchar2 default null
107 ,P_ATTRIBUTE6 in varchar2 default null
108 ,P_ATTRIBUTE7 in varchar2 default null
109 ,P_ATTRIBUTE8 in varchar2 default null
110 ,P_ATTRIBUTE9 in varchar2 default null
111 ,P_ATTRIBUTE10 in varchar2 default null
112 ,P_ATTRIBUTE11 in varchar2 default null
113 ,P_ATTRIBUTE12 in varchar2 default null
114 ,P_ATTRIBUTE13 in varchar2 default null
115 ,P_ATTRIBUTE14 in varchar2 default null
116 ,P_ATTRIBUTE15 in varchar2 default null
117 ,P_ATTRIBUTE16 in varchar2 default null
118 ,P_ATTRIBUTE17 in varchar2 default null
119 ,P_ATTRIBUTE18 in varchar2 default null
120 ,P_ATTRIBUTE19 in varchar2 default null
121 ,P_ATTRIBUTE20 in varchar2 default null
122 ,P_ATTRIBUTE21 in varchar2 default null
123 ,P_ATTRIBUTE22 in varchar2 default null
124 ,P_ATTRIBUTE23 in varchar2 default null
125 ,P_ATTRIBUTE24 in varchar2 default null
126 ,P_ATTRIBUTE25 in varchar2 default null
127 ,P_ATTRIBUTE26 in varchar2 default null
128 ,P_ATTRIBUTE27 in varchar2 default null
129 ,P_ATTRIBUTE28 in varchar2 default null
130 ,P_ATTRIBUTE29 in varchar2 default null
131 ,P_ATTRIBUTE30 in varchar2 default null
132 ,P_PLACE_OF_BIRTH in varchar2 default null
133 ,P_REFERENCES in varchar2 default null
134 ,P_LOCAL_COEFFICIENT in varchar2 default null
135 ,P_CITIZENSHIP in varchar2
136 ,P_MILITARY_DOC in varchar2 default null
137 ,P_RESERVE_CATEGORY in varchar2 default null
138 ,P_MILITARY_RANK in varchar2 default null
139 ,P_MILITARY_PROFILE in varchar2 default null
140 ,P_MILITARY_REG_CODE in varchar2 default null
141 ,P_MIL_SRVC_READINESS_CATEGORY in varchar2 default null
142 ,P_MILITARY_COMMISSARIAT in varchar2 default null
143 ,P_QUITTING_MARK in varchar2 default null
144 ,P_MILITARY_UNIT_NUMBER in varchar2 default null
145 ,P_MILITARY_REG_TYPE in varchar2 default null
146 ,P_MILITARY_REG_DETAILS in varchar2 default null
147 ,P_PENSION_FUND_NUMBER in varchar2 default null
148 ,P_BACKGROUND_CHECK_STATUS in varchar2 default null
149 ,P_BACKGROUND_DATE_CHECK in date default null
150 ,P_FTE_CAPACITY in number default null
151 ,P_HOLD_APPLICANT_DATE_UNTIL in date default null
152 ,P_HONORS in varchar2 default null
153 ,P_MAILSTOP in varchar2 default null
154 ,P_OFFICE_NUMBER in varchar2 default null
155 ,P_ON_MILITARY_SERVICE in varchar2 default null
156 ,P_GENITIVE_LAST_NAME in varchar2 default null
157 ,P_PROJECTED_START_DATE in date default null
158 ,P_RESUME_EXISTS in varchar2 default null
159 ,P_RESUME_LAST_UPDATED in date default null
160 ,P_STUDENT_STATUS in varchar2 default null
161 ,P_WORK_SCHEDULE in varchar2 default null
162 ,P_SUFFIX in varchar2 default null
163 ,P_DATE_OF_DEATH in date default null
164 ,P_RECEIPT_OF_DEATH_CERT_DATE in date default null
165 ,P_COORD_BEN_MED_PLN_NO in varchar2 default null
166 ,P_COORD_BEN_NO_CVG_FLAG in varchar2 default null
167 ,P_USES_TOBACCO_FLAG in varchar2 default null
168 ,P_DPDNT_ADOPTION_DATE in date default null
169 ,P_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default null
170 ,P_ORIGINAL_DATE_OF_HIRE in date default null
171 ,P_TOWN_OF_BIRTH in varchar2 default null
172 ,P_REGION_OF_BIRTH in varchar2 default null
173 ,P_COUNTRY_OF_BIRTH in varchar2 default null
174 ,P_GLOBAL_PERSON_ID in varchar2 default null
175 ,P_PARTY_ID in number default null
176 ,P_PERSON_USER_KEY in varchar2
177 ,P_ASSIGNMENT_USER_KEY in varchar2
178 ,P_APPLICATION_USER_KEY in varchar2
179 ,P_USER_PERSON_TYPE in varchar2 default null
180 ,P_LANGUAGE_CODE in varchar2 default null
181 ,P_CORRESPONDENCE_LANGUAGE in varchar2 default null
182 ,P_BENEFIT_GROUP in varchar2 default null) is
183 blid number := p_data_pump_batch_line_id;
184 begin
185 if blid is not null then
186 delete from hr_pump_batch_lines where batch_line_id = blid;
187 delete from hr_pump_batch_exceptions
188 where source_type = 'BATCH_LINE' and source_id = blid;
189 end if;
190 insert into hr_pump_batch_lines
191 (batch_id
192 ,batch_line_id
193 ,business_group_name
194 ,api_module_id
195 ,line_status
196 ,user_sequence
197 ,link_value
198 ,pval001
199 ,pval002
200 ,pval003
201 ,pval004
202 ,pval005
203 ,pval006
204 ,pval007
205 ,pval008
206 ,pval009
207 ,pval010
208 ,pval011
209 ,pval012
210 ,pval013
211 ,pval014
212 ,pval015
213 ,pval016
214 ,pval017
215 ,pval018
216 ,pval019
217 ,pval020
218 ,pval021
219 ,pval022
220 ,pval023
221 ,pval024
222 ,pval025
223 ,pval026
224 ,pval027
225 ,pval028
226 ,pval029
227 ,pval030
228 ,pval031
229 ,pval032
230 ,pval033
231 ,pval034
232 ,pval035
233 ,pval036
234 ,pval037
235 ,pval038
236 ,pval039
237 ,pval040
238 ,pval041
239 ,pval042
240 ,pval043
241 ,pval044
242 ,pval045
243 ,pval046
244 ,pval047
245 ,pval048
246 ,pval049
247 ,pval050
248 ,pval051
249 ,pval052
250 ,pval053
251 ,pval054
252 ,pval055
253 ,pval056
254 ,pval057
255 ,pval058
256 ,pval059
257 ,pval060
258 ,pval061
259 ,pval062
260 ,pval063
261 ,pval064
262 ,pval065
263 ,pval066
264 ,pval067
265 ,pval068
266 ,pval069
267 ,pval070
268 ,pval071
269 ,pval072
270 ,pval073
271 ,pval074
272 ,pval075
273 ,pval076
274 ,pval077
275 ,pval078
276 ,pval079
277 ,pval080
278 ,pval081
279 ,pval082
280 ,pval083
281 ,pval084
282 ,pval085
283 ,pval086
284 ,pval087
285 ,pval088
286 ,pval089
287 ,pval090
288 ,pval091
289 ,pval092
290 ,pval093
291 ,pval094
292 ,pval095
293 ,pval096
294 ,pval097
295 ,pval108
296 ,pval109
297 ,pval110
298 ,pval111)
299 values
300 (p_batch_id
301 ,nvl(blid,hr_pump_batch_lines_s.nextval)
302 ,p_data_pump_business_grp_name
303 ,3871
304 ,'U'
305 ,p_user_sequence
306 ,p_link_value
307 ,dc(P_DATE_RECEIVED)
308 ,P_LAST_NAME
309 ,P_APPLICANT_NUMBER
310 ,P_PER_COMMENTS
311 ,dc(P_DATE_EMPLOYEE_DATA_VERIFIED)
312 ,dc(P_DATE_OF_BIRTH)
313 ,P_EMAIL_ADDRESS
314 ,P_EXPENSE_CHECK_SEND_TO_ADDRES
315 ,P_FIRST_NAME
316 ,P_KNOWN_AS
317 ,P_MARITAL_STATUS
318 ,P_MIDDLE_NAMES
319 ,P_NATIONALITY
320 ,P_INN
321 ,P_PREVIOUS_LAST_NAME
322 ,P_REGISTERED_DISABLED_FLAG
323 ,P_SEX
324 ,P_TITLE
325 ,P_WORK_TELEPHONE
326 ,P_ATTRIBUTE_CATEGORY
327 ,P_ATTRIBUTE1
328 ,P_ATTRIBUTE2
329 ,P_ATTRIBUTE3
330 ,P_ATTRIBUTE4
331 ,P_ATTRIBUTE5
332 ,P_ATTRIBUTE6
333 ,P_ATTRIBUTE7
334 ,P_ATTRIBUTE8
335 ,P_ATTRIBUTE9
336 ,P_ATTRIBUTE10
337 ,P_ATTRIBUTE11
338 ,P_ATTRIBUTE12
339 ,P_ATTRIBUTE13
340 ,P_ATTRIBUTE14
341 ,P_ATTRIBUTE15
342 ,P_ATTRIBUTE16
343 ,P_ATTRIBUTE17
344 ,P_ATTRIBUTE18
345 ,P_ATTRIBUTE19
346 ,P_ATTRIBUTE20
347 ,P_ATTRIBUTE21
348 ,P_ATTRIBUTE22
349 ,P_ATTRIBUTE23
350 ,P_ATTRIBUTE24
351 ,P_ATTRIBUTE25
352 ,P_ATTRIBUTE26
353 ,P_ATTRIBUTE27
354 ,P_ATTRIBUTE28
355 ,P_ATTRIBUTE29
356 ,P_ATTRIBUTE30
357 ,P_PLACE_OF_BIRTH
358 ,P_REFERENCES
359 ,P_LOCAL_COEFFICIENT
360 ,P_CITIZENSHIP
361 ,P_MILITARY_DOC
362 ,P_RESERVE_CATEGORY
363 ,P_MILITARY_RANK
364 ,P_MILITARY_PROFILE
365 ,P_MILITARY_REG_CODE
366 ,P_MIL_SRVC_READINESS_CATEGORY
367 ,P_MILITARY_COMMISSARIAT
368 ,P_QUITTING_MARK
369 ,P_MILITARY_UNIT_NUMBER
370 ,P_MILITARY_REG_TYPE
371 ,P_MILITARY_REG_DETAILS
372 ,P_PENSION_FUND_NUMBER
373 ,P_BACKGROUND_CHECK_STATUS
374 ,dc(P_BACKGROUND_DATE_CHECK)
375 ,P_FTE_CAPACITY
376 ,dc(P_HOLD_APPLICANT_DATE_UNTIL)
377 ,P_HONORS
378 ,P_MAILSTOP
379 ,P_OFFICE_NUMBER
380 ,P_ON_MILITARY_SERVICE
381 ,P_GENITIVE_LAST_NAME
382 ,dc(P_PROJECTED_START_DATE)
383 ,P_RESUME_EXISTS
384 ,dc(P_RESUME_LAST_UPDATED)
385 ,P_STUDENT_STATUS
386 ,P_WORK_SCHEDULE
387 ,P_SUFFIX
388 ,dc(P_DATE_OF_DEATH)
389 ,dc(P_RECEIPT_OF_DEATH_CERT_DATE)
390 ,P_COORD_BEN_MED_PLN_NO
391 ,P_COORD_BEN_NO_CVG_FLAG
392 ,P_USES_TOBACCO_FLAG
393 ,dc(P_DPDNT_ADOPTION_DATE)
394 ,P_DPDNT_VLNTRY_SVCE_FLAG
395 ,dc(P_ORIGINAL_DATE_OF_HIRE)
396 ,P_TOWN_OF_BIRTH
397 ,P_REGION_OF_BIRTH
398 ,P_COUNTRY_OF_BIRTH
399 ,P_GLOBAL_PERSON_ID
400 ,P_PARTY_ID
401 ,P_PERSON_USER_KEY
402 ,P_ASSIGNMENT_USER_KEY
403 ,P_APPLICATION_USER_KEY
407 ,P_BENEFIT_GROUP);
404 ,P_USER_PERSON_TYPE
405 ,P_LANGUAGE_CODE
406 ,P_CORRESPONDENCE_LANGUAGE
408 end insert_batch_lines;
409 --
410 procedure call
411 (p_business_group_id in number,
412 p_batch_line_id     in number) is
413 cursor cr is
414 select l.rowid myrowid,
415 decode(l.pval001,cn,dn,d(l.pval001)) p1,
416 decode(l.pval002,cn,vn,l.pval002) p2,
417 decode(l.pval003,cn,vn,l.pval003) p3,
418 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
419 l.pval004 d4,
420 decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
421 l.pval005 d5,
422 decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
423 l.pval006 d6,
424 decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
425 l.pval007 d7,
426 decode(l.pval008,cn,vn,vn,vn,
427  hr_pump_get.gl(l.pval008,'HOME_OFFICE',d(l.pval001),l.pval109)) p8,
428 l.pval008 d8,
429 decode(l.pval009,cn,vn,l.pval009) p9,
430 decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
431 l.pval010 d10,
432 decode(l.pval011,cn,vn,vn,vn,
436 l.pval012 d12,
433  hr_pump_get.gl(l.pval011,'MAR_STATUS',d(l.pval001),l.pval109)) p11,
434 l.pval011 d11,
435 decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
437 decode(l.pval013,cn,vn,vn,vn,
438  hr_pump_get.gl(l.pval013,'NATIONALITY',d(l.pval001),l.pval109)) p13,
439 l.pval013 d13,
440 decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
441 l.pval014 d14,
442 decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
443 l.pval015 d15,
444 decode(l.pval016,cn,vn,vn,vn,
445  hr_pump_get.gl(l.pval016,'YES_NO',d(l.pval001),l.pval109)) p16,
446 l.pval016 d16,
447 decode(l.pval017,cn,vn,vn,vn,
448  hr_pump_get.gl(l.pval017,'SEX',d(l.pval001),l.pval109)) p17,
449 l.pval017 d17,
450 decode(l.pval018,cn,vn,vn,vn,
451  hr_pump_get.gl(l.pval018,'TITLE',d(l.pval001),l.pval109)) p18,
452 l.pval018 d18,
453 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
454 l.pval019 d19,
455 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
456 l.pval020 d20,
457 decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
458 l.pval021 d21,
459 decode(l.pval022,cn,vn,vn,vn,l.pval022) p22,
460 l.pval022 d22,
461 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
462 l.pval023 d23,
463 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
464 l.pval024 d24,
465 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
466 l.pval025 d25,
467 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
468 l.pval026 d26,
469 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
470 l.pval027 d27,
471 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
472 l.pval028 d28,
473 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
474 l.pval029 d29,
475 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
476 l.pval030 d30,
477 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
478 l.pval031 d31,
479 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
480 l.pval032 d32,
481 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
482 l.pval033 d33,
483 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
484 l.pval034 d34,
485 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
486 l.pval035 d35,
487 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
488 l.pval036 d36,
489 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
490 l.pval037 d37,
491 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
492 l.pval038 d38,
493 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
494 l.pval039 d39,
495 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
496 l.pval040 d40,
497 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
498 l.pval041 d41,
502 l.pval043 d43,
499 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
500 l.pval042 d42,
501 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
503 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
504 l.pval044 d44,
505 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
506 l.pval045 d45,
507 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
508 l.pval046 d46,
509 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
510 l.pval047 d47,
511 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
512 l.pval048 d48,
513 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
514 l.pval049 d49,
515 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
516 l.pval050 d50,
517 decode(l.pval051,cn,vn,vn,vn,
518  hr_pump_get.gl(l.pval051,'RU_OKATO',d(l.pval001),l.pval109)) p51,
519 l.pval051 d51,
520 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
521 l.pval052 d52,
522 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
523 l.pval053 d53,
524 decode(l.pval054,cn,vn,
525  hr_pump_get.gl(l.pval054,'RU_CITIZENSHIP',d(l.pval001),l.pval109)) p54,
526 decode(l.pval055,cn,vn,vn,vn,
527  hr_pump_get.gl(l.pval055,'RU_MILITARY_DOC_TYPE',d(l.pval001),l.pval109)) p55,
528 l.pval055 d55,
529 decode(l.pval056,cn,vn,vn,vn,
530  hr_pump_get.gl(l.pval056,'RU_RESERVE_CATEGORY',d(l.pval001),l.pval109)) p56,
531 l.pval056 d56,
532 decode(l.pval057,cn,vn,vn,vn,
533  hr_pump_get.gl(l.pval057,'RU_MILITARY_RANK',d(l.pval001),l.pval109)) p57,
534 l.pval057 d57,
535 decode(l.pval058,cn,vn,vn,vn,
536  hr_pump_get.gl(l.pval058,'RU_MILITARY_PROFILE',d(l.pval001),l.pval109)) p58,
537 l.pval058 d58,
538 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
539 l.pval059 d59,
540 decode(l.pval060,cn,vn,vn,vn,
541  hr_pump_get.gl(l.pval060,'RU_MILITARY_SERVICE_READINESS_CATEGORY',d(l.pval001),l.pval109)) p60,
542 l.pval060 d60,
543 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
544 l.pval061 d61,
545 decode(l.pval062,cn,vn,vn,vn,
546  hr_pump_get.gl(l.pval062,'RU_QUITTING_MARK',d(l.pval001),l.pval109)) p62,
547 l.pval062 d62,
548 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
549 l.pval063 d63,
550 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
551 l.pval064 d64,
552 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
553 l.pval065 d65,
554 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
555 l.pval066 d66,
556 decode(l.pval067,cn,vn,vn,vn,
557  hr_pump_get.gl(l.pval067,'YES_NO',d(l.pval001),l.pval109)) p67,
558 l.pval067 d67,
559 decode(l.pval068,cn,dn,vn,dn,d(l.pval068)) p68,
560 l.pval068 d68,
561 decode(l.pval069,cn,nn,vn,nn,n(l.pval069)) p69,
562 l.pval069 d69,
563 decode(l.pval070,cn,dn,vn,dn,d(l.pval070)) p70,
564 l.pval070 d70,
565 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
566 l.pval071 d71,
567 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
568 l.pval072 d72,
569 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
570 l.pval073 d73,
571 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
572 l.pval074 d74,
573 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
574 l.pval075 d75,
575 decode(l.pval076,cn,dn,vn,dn,d(l.pval076)) p76,
576 l.pval076 d76,
577 decode(l.pval077,cn,vn,vn,vn,
578  hr_pump_get.gl(l.pval077,'YES_NO',d(l.pval001),l.pval109)) p77,
579 l.pval077 d77,
580 decode(l.pval078,cn,dn,vn,dn,d(l.pval078)) p78,
581 l.pval078 d78,
582 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
583 l.pval079 d79,
584 decode(l.pval080,cn,vn,vn,vn,
585  hr_pump_get.gl(l.pval080,'WORK_SCHEDULE',d(l.pval001),l.pval109)) p80,
586 l.pval080 d80,
587 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
588 l.pval081 d81,
589 decode(l.pval082,cn,dn,vn,dn,d(l.pval082)) p82,
590 l.pval082 d82,
591 decode(l.pval083,cn,dn,vn,dn,d(l.pval083)) p83,
592 l.pval083 d83,
593 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
594 l.pval084 d84,
595 decode(l.pval085,cn,vn,vn,'N',
596  hr_pump_get.gl(l.pval085,'YES_NO',d(l.pval001),l.pval109)) p85,
597 l.pval085 d85,
598 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
599 l.pval086 d86,
600 decode(l.pval087,cn,dn,vn,dn,d(l.pval087)) p87,
601 l.pval087 d87,
602 decode(l.pval088,cn,vn,vn,'N',
603  hr_pump_get.gl(l.pval088,'YES_NO',d(l.pval001),l.pval109)) p88,
604 l.pval088 d88,
605 decode(l.pval089,cn,dn,vn,dn,d(l.pval089)) p89,
606 l.pval089 d89,
607 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
608 l.pval090 d90,
609 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
610 l.pval091 d91,
611 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
612 l.pval092 d92,
613 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
614 l.pval093 d93,
615 decode(l.pval094,cn,nn,vn,nn,n(l.pval094)) p94,
616 l.pval094 d94,
617 l.pval095 p95,
618 l.pval096 p96,
619 l.pval097 p97,
620 l.pval098 p98,
621 l.pval099 p99,
622 l.pval100 p100,
623 decode(l.pval101,cn,dn,d(l.pval101)) p101,
624 decode(l.pval102,cn,dn,d(l.pval102)) p102,
625 l.pval103 p103,
626 l.pval104 p104,
627 l.pval105 p105,
628 l.pval106 p106,
629 l.pval107 p107,
630 decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
631 l.pval108 d108,
632 decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
633 l.pval109 d109,
634 decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
635 l.pval110 d110,
636 decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
637 l.pval111 d111
638 from hr_pump_batch_lines l
639 where l.batch_line_id = p_batch_line_id;
640 --
641 c cr%rowtype;
642 l_validate boolean := false;
643 L_PERSON_ID number;
644 L_ASSIGNMENT_ID number;
645 L_APPLICATION_ID number;
646 L_NAME_COMBINATION_WARNING boolean;
647 L_ORIG_HIRE_WARNING boolean;
648 L_PERSON_TYPE_ID number;
649 L_CORRESPONDENCE_LANGUAGE varchar2(2000);
650 L_BENEFIT_GROUP_ID number;
651 --
652 begin
653 hr_data_pump.entry('call');
654 open cr;
655 fetch cr into c;
656 if cr%notfound then
660 hr_utility.set_message_token('VALUE',p_batch_line_id);
657 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
658 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
659 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
661 hr_utility.raise_error;
662 end if;
663 --
664 if c.p108 is null or
665 c.p109 is null then
666 L_PERSON_TYPE_ID:=nn;
667 else
668 L_PERSON_TYPE_ID := 
669 hr_pump_get.get_person_type_id
670 (P_USER_PERSON_TYPE => c.p108
671 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
672 ,P_LANGUAGE_CODE => c.p109);
673 end if;
674 --
675 if c.p110 is null then
676 L_CORRESPONDENCE_LANGUAGE:=vn;
677 else
678 L_CORRESPONDENCE_LANGUAGE := 
679 hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
680 (P_CORRESPONDENCE_LANGUAGE => c.p110);
681 end if;
682 --
683 if c.p111 is null then
684 L_BENEFIT_GROUP_ID:=nn;
685 else
686 L_BENEFIT_GROUP_ID := 
687 hr_pump_get.get_benefit_group_id
688 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
689 ,P_BENEFIT_GROUP => c.p111);
690 end if;
691 --
692 hr_data_pump.api_trc_on;
693 HR_RU_APPLICANT_API.CREATE_RU_APPLICANT
694 (p_validate => l_validate
695 ,P_DATE_RECEIVED => c.p1
696 ,p_business_group_id => p_business_group_id
697 ,P_LAST_NAME => c.p2
698 ,P_PERSON_TYPE_ID => L_PERSON_TYPE_ID
699 ,P_APPLICANT_NUMBER => c.p3
700 ,P_PER_COMMENTS => c.p4
701 ,P_DATE_EMPLOYEE_DATA_VERIFIED => c.p5
702 ,P_DATE_OF_BIRTH => c.p6
703 ,P_EMAIL_ADDRESS => c.p7
704 ,P_EXPENSE_CHECK_SEND_TO_ADDRES => c.p8
705 ,P_FIRST_NAME => c.p9
706 ,P_KNOWN_AS => c.p10
707 ,P_MARITAL_STATUS => c.p11
708 ,P_MIDDLE_NAMES => c.p12
709 ,P_NATIONALITY => c.p13
710 ,P_INN => c.p14
711 ,P_PREVIOUS_LAST_NAME => c.p15
712 ,P_REGISTERED_DISABLED_FLAG => c.p16
713 ,P_SEX => c.p17
714 ,P_TITLE => c.p18
715 ,P_WORK_TELEPHONE => c.p19
716 ,P_ATTRIBUTE_CATEGORY => c.p20
717 ,P_ATTRIBUTE1 => c.p21
718 ,P_ATTRIBUTE2 => c.p22
719 ,P_ATTRIBUTE3 => c.p23
720 ,P_ATTRIBUTE4 => c.p24
721 ,P_ATTRIBUTE5 => c.p25
722 ,P_ATTRIBUTE6 => c.p26
723 ,P_ATTRIBUTE7 => c.p27
724 ,P_ATTRIBUTE8 => c.p28
725 ,P_ATTRIBUTE9 => c.p29
726 ,P_ATTRIBUTE10 => c.p30
727 ,P_ATTRIBUTE11 => c.p31
728 ,P_ATTRIBUTE12 => c.p32
729 ,P_ATTRIBUTE13 => c.p33
730 ,P_ATTRIBUTE14 => c.p34
731 ,P_ATTRIBUTE15 => c.p35
732 ,P_ATTRIBUTE16 => c.p36
733 ,P_ATTRIBUTE17 => c.p37
734 ,P_ATTRIBUTE18 => c.p38
735 ,P_ATTRIBUTE19 => c.p39
736 ,P_ATTRIBUTE20 => c.p40
737 ,P_ATTRIBUTE21 => c.p41
738 ,P_ATTRIBUTE22 => c.p42
739 ,P_ATTRIBUTE23 => c.p43
740 ,P_ATTRIBUTE24 => c.p44
741 ,P_ATTRIBUTE25 => c.p45
742 ,P_ATTRIBUTE26 => c.p46
743 ,P_ATTRIBUTE27 => c.p47
744 ,P_ATTRIBUTE28 => c.p48
745 ,P_ATTRIBUTE29 => c.p49
746 ,P_ATTRIBUTE30 => c.p50
747 ,P_PLACE_OF_BIRTH => c.p51
748 ,P_REFERENCES => c.p52
749 ,P_LOCAL_COEFFICIENT => c.p53
750 ,P_CITIZENSHIP => c.p54
751 ,P_MILITARY_DOC => c.p55
752 ,P_RESERVE_CATEGORY => c.p56
753 ,P_MILITARY_RANK => c.p57
754 ,P_MILITARY_PROFILE => c.p58
755 ,P_MILITARY_REG_CODE => c.p59
756 ,P_MIL_SRVC_READINESS_CATEGORY => c.p60
757 ,P_MILITARY_COMMISSARIAT => c.p61
758 ,P_QUITTING_MARK => c.p62
759 ,P_MILITARY_UNIT_NUMBER => c.p63
760 ,P_MILITARY_REG_TYPE => c.p64
761 ,P_MILITARY_REG_DETAILS => c.p65
762 ,P_PENSION_FUND_NUMBER => c.p66
763 ,P_BACKGROUND_CHECK_STATUS => c.p67
764 ,P_BACKGROUND_DATE_CHECK => c.p68
765 ,P_CORRESPONDENCE_LANGUAGE => L_CORRESPONDENCE_LANGUAGE
766 ,P_FTE_CAPACITY => c.p69
767 ,P_HOLD_APPLICANT_DATE_UNTIL => c.p70
768 ,P_HONORS => c.p71
769 ,P_MAILSTOP => c.p72
770 ,P_OFFICE_NUMBER => c.p73
771 ,P_ON_MILITARY_SERVICE => c.p74
772 ,P_GENITIVE_LAST_NAME => c.p75
773 ,P_PROJECTED_START_DATE => c.p76
774 ,P_RESUME_EXISTS => c.p77
775 ,P_RESUME_LAST_UPDATED => c.p78
776 ,P_STUDENT_STATUS => c.p79
777 ,P_WORK_SCHEDULE => c.p80
778 ,P_SUFFIX => c.p81
779 ,P_DATE_OF_DEATH => c.p82
780 ,P_BENEFIT_GROUP_ID => L_BENEFIT_GROUP_ID
781 ,P_RECEIPT_OF_DEATH_CERT_DATE => c.p83
782 ,P_COORD_BEN_MED_PLN_NO => c.p84
783 ,P_COORD_BEN_NO_CVG_FLAG => c.p85
784 ,P_USES_TOBACCO_FLAG => c.p86
785 ,P_DPDNT_ADOPTION_DATE => c.p87
786 ,P_DPDNT_VLNTRY_SVCE_FLAG => c.p88
787 ,P_ORIGINAL_DATE_OF_HIRE => c.p89
788 ,P_TOWN_OF_BIRTH => c.p90
789 ,P_REGION_OF_BIRTH => c.p91
790 ,P_COUNTRY_OF_BIRTH => c.p92
791 ,P_GLOBAL_PERSON_ID => c.p93
792 ,P_PARTY_ID => c.p94
793 ,P_PERSON_ID => L_PERSON_ID
794 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
795 ,P_APPLICATION_ID => L_APPLICATION_ID
796 ,P_PER_OBJECT_VERSION_NUMBER => c.p98
797 ,P_ASG_OBJECT_VERSION_NUMBER => c.p99
798 ,P_APL_OBJECT_VERSION_NUMBER => c.p100
799 ,P_PER_EFFECTIVE_START_DATE => c.p101
800 ,P_PER_EFFECTIVE_END_DATE => c.p102
801 ,P_FULL_NAME => c.p103
802 ,P_PER_COMMENT_ID => c.p104
803 ,P_ASSIGNMENT_SEQUENCE => c.p105
804 ,P_NAME_COMBINATION_WARNING => L_NAME_COMBINATION_WARNING
805 ,P_ORIG_HIRE_WARNING => L_ORIG_HIRE_WARNING);
806 hr_data_pump.api_trc_off;
807 --
808 iuk(p_batch_line_id,c.p95,L_PERSON_ID);
809 --
810 iuk(p_batch_line_id,c.p96,L_ASSIGNMENT_ID);
811 --
812 iuk(p_batch_line_id,c.p97,L_APPLICATION_ID);
813 --
814 if L_NAME_COMBINATION_WARNING then
815 c.p106 := 'TRUE';
816 else
817 c.p106 := 'FALSE';
818 end if;
819 --
820 if L_ORIG_HIRE_WARNING then
821 c.p107 := 'TRUE';
822 else
823 c.p107 := 'FALSE';
824 end if;
825 --
826 update hr_pump_batch_lines l set
827 l.pval003 = decode(c.p3,null,cn,c.p3),
828 l.pval095 = decode(c.p95,null,cn,c.p95),
829 l.pval096 = decode(c.p96,null,cn,c.p96),
830 l.pval097 = decode(c.p97,null,cn,c.p97),
834 l.pval101 = decode(c.p101,null,cn,dc(c.p101)),
831 l.pval098 = decode(c.p98,null,cn,c.p98),
832 l.pval099 = decode(c.p99,null,cn,c.p99),
833 l.pval100 = decode(c.p100,null,cn,c.p100),
835 l.pval102 = decode(c.p102,null,cn,dc(c.p102)),
836 l.pval103 = decode(c.p103,null,cn,c.p103),
837 l.pval104 = decode(c.p104,null,cn,c.p104),
838 l.pval105 = decode(c.p105,null,cn,c.p105),
839 l.pval106 = decode(c.p106,null,cn,c.p106),
840 l.pval107 = decode(c.p107,null,cn,c.p107)
841 where l.rowid = c.myrowid;
842 --
843 close cr;
844 --
845 hr_data_pump.exit('call');
846 exception
847  when hr_multi_message.error_message_exist then
848    if cr%isopen then
849     close cr;
850    end if;
851    hr_pump_utils.set_multi_msg_error_flag(true);
852  when others then
853  if cr%isopen then
854   close cr;
855  end if;
856  raise;
857 end call;
858 end hrdpp_CREATE_RU_APPLICANT;