71: IF p_per_information13 <> hr_api.g_varchar2
72: AND p_per_information13 IS NOT NULL
73: THEN
74: l_err :=
75: hr_ru_utility.validate_spifn (p_per_information13,
76: l_effective_date
77: );
78:
79: IF (l_err = 1)
154: db_person_rec.per_information18);
155:
156: IF l_per_information5 IS NOT NULL
157: THEN
158: hr_ru_utility.check_lookup_value
159: (p_argument => hr_general.decode_lookup
160: ('RU_FORM_LABELS',
161: 'MILITARY_DOCUMENT'
162: ),
174: );
175:
176: IF l_per_information12 IS NOT NULL
177: THEN
178: hr_ru_utility.check_lookup_value
179: (p_argument => hr_general.decode_lookup
180: ('RU_FORM_LABELS',
181: 'QUITTING_MARK'
182: ),
201: ELSIF l_per_information5 = '1'
202: THEN
203: IF (l_per_information6 IS NOT NULL)
204: THEN
205: hr_ru_utility.check_lookup_value
206: (p_argument => hr_general.decode_lookup
207: ('RU_FORM_LABELS',
208: 'RESERVE_CATEGORY'
209: ),
214: END IF;
215:
216: IF (l_per_information7 IS NOT NULL)
217: THEN
218: hr_ru_utility.check_lookup_value
219: (p_argument => hr_general.decode_lookup
220: ('RU_FORM_LABELS',
221: 'MILITARY_RANK'
222: ),
227: END IF;
228:
229: IF (l_per_information8 IS NOT NULL)
230: THEN
231: hr_ru_utility.check_lookup_value
232: (p_argument => hr_general.decode_lookup
233: ('RU_FORM_LABELS',
234: 'PROFILE'
235: ),
240: END IF;
241:
242: IF (l_per_information18 IS NOT NULL)
243: THEN
244: hr_ru_utility.check_lookup_value
245: (p_argument => hr_general.decode_lookup
246: ('RU_FORM_LABELS',
247: 'MILITARY_REG_TYPE'
248: ),
313: --
314: -- Check Place of Birth takes valid OKATO lookup value
315: IF (p_per_information1 IS NOT NULL)
316: THEN
317: hr_ru_utility.check_lookup_value
318: (p_argument => hr_general.decode_lookup
319: ('RU_FORM_LABELS',
320: 'PLACE_OF_BIRTH'
321: ),
329: --Validate Pension fund number
330: IF p_per_information13 IS NOT NULL
331: THEN
332: l_err :=
333: hr_ru_utility.validate_spifn (p_per_information13,
334: l_effective_date
335: );
336:
337: IF (l_err = 1)
353:
354: --Check for Invalid Combination of military document and other military details
355: IF p_per_information5 IS NOT NULL
356: THEN
357: hr_ru_utility.check_lookup_value
358: (p_argument => hr_general.decode_lookup
359: ('RU_FORM_LABELS',
360: 'MILITARY_DOCUMENT'
361: ),
370: 'MIL_SERVICE_READINESS'
371: ),
372: p_argument_value => p_per_information10
373: );
374: hr_ru_utility.check_lookup_value
375: (p_argument => hr_general.decode_lookup
376: ('RU_FORM_LABELS',
377: 'MIL_SERVICE_READINESS'
378: ),
382: );
383:
384: IF p_per_information12 IS NOT NULL
385: THEN
386: hr_ru_utility.check_lookup_value
387: (p_argument => hr_general.decode_lookup
388: ('RU_FORM_LABELS',
389: 'QUITTING_MARK'
390: ),
409: ELSIF p_per_information5 = '1'
410: THEN
411: IF (p_per_information6 IS NOT NULL)
412: THEN
413: hr_ru_utility.check_lookup_value
414: (p_argument => hr_general.decode_lookup
415: ('RU_FORM_LABELS',
416: 'RESERVE_CATEGORY'
417: ),
422: END IF;
423:
424: IF (p_per_information7 IS NOT NULL)
425: THEN
426: hr_ru_utility.check_lookup_value
427: (p_argument => hr_general.decode_lookup
428: ('RU_FORM_LABELS',
429: 'MILITARY_RANK'
430: ),
435: END IF;
436:
437: IF (p_per_information8 IS NOT NULL)
438: THEN
439: hr_ru_utility.check_lookup_value
440: (p_argument => hr_general.decode_lookup
441: ('RU_FORM_LABELS',
442: 'PROFILE'
443: ),
448: END IF;
449:
450: IF (p_per_information18 IS NOT NULL)
451: THEN
452: hr_ru_utility.check_lookup_value
453: (p_argument => hr_general.decode_lookup
454: ('RU_FORM_LABELS',
455: 'MILITARY_REG_TYPE'
456: ),
531: 'CITIZENSHIP'
532: ),
533: p_argument_value => p_per_information4
534: );
535: hr_ru_utility.check_lookup_value
536: (p_argument => hr_general.decode_lookup
537: ('RU_FORM_LABELS',
538: 'CITIZENSHIP'
539: ),
627: 'CITIZENSHIP'
628: ),
629: p_argument_value => p_per_information4
630: );
631: hr_ru_utility.check_lookup_value
632: (p_argument => hr_general.decode_lookup
633: ('RU_FORM_LABELS',
634: 'CITIZENSHIP'
635: ),
737: 'CITIZENSHIP'
738: ),
739: p_argument_value => p_per_information4
740: );
741: hr_ru_utility.check_lookup_value
742: (p_argument => hr_general.decode_lookup
743: ('RU_FORM_LABELS',
744: 'CITIZENSHIP'
745: ),
845: END IF;
846: -- Check Place of Birth takes valid OKATO lookup value
847: IF (p_per_information1 <> hr_api.g_varchar2)
848: THEN
849: hr_ru_utility.check_lookup_value
850: (p_argument => hr_general.decode_lookup
851: ('RU_FORM_LABELS',
852: 'PLACE_OF_BIRTH'
853: ),
870: );
871:
872: IF (p_per_information4 <> hr_api.g_varchar2)
873: THEN
874: hr_ru_utility.check_lookup_value
875: (p_argument => hr_general.decode_lookup
876: ('RU_FORM_LABELS',
877: 'CITIZENSHIP'
878: ),