DBA Data[Home] [Help]

APPS.HR_RU_PEOPLE_LEG_HOOK dependencies on HR_RU_UTILITY

Line 75: hr_ru_utility.validate_spifn (p_per_information13,

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)

Line 158: hr_ru_utility.check_lookup_value

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: ),

Line 178: hr_ru_utility.check_lookup_value

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: ),

Line 205: hr_ru_utility.check_lookup_value

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: ),

Line 218: hr_ru_utility.check_lookup_value

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: ),

Line 231: hr_ru_utility.check_lookup_value

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: ),

Line 244: hr_ru_utility.check_lookup_value

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: ),

Line 317: hr_ru_utility.check_lookup_value

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: ),

Line 333: hr_ru_utility.validate_spifn (p_per_information13,

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)

Line 357: hr_ru_utility.check_lookup_value

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: ),

Line 374: hr_ru_utility.check_lookup_value

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: ),

Line 386: hr_ru_utility.check_lookup_value

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: ),

Line 413: hr_ru_utility.check_lookup_value

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: ),

Line 426: hr_ru_utility.check_lookup_value

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: ),

Line 439: hr_ru_utility.check_lookup_value

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: ),

Line 452: hr_ru_utility.check_lookup_value

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: ),

Line 533: hr_ru_utility.check_lookup_value

529: 'CITIZENSHIP'
530: ),
531: p_argument_value => p_per_information4
532: );
533: hr_ru_utility.check_lookup_value
534: (p_argument => hr_general.decode_lookup
535: ('RU_FORM_LABELS',
536: 'CITIZENSHIP'
537: ),

Line 623: hr_ru_utility.check_lookup_value

619: 'CITIZENSHIP'
620: ),
621: p_argument_value => p_per_information4
622: );
623: hr_ru_utility.check_lookup_value
624: (p_argument => hr_general.decode_lookup
625: ('RU_FORM_LABELS',
626: 'CITIZENSHIP'
627: ),

Line 733: hr_ru_utility.check_lookup_value

729: 'CITIZENSHIP'
730: ),
731: p_argument_value => p_per_information4
732: );
733: hr_ru_utility.check_lookup_value
734: (p_argument => hr_general.decode_lookup
735: ('RU_FORM_LABELS',
736: 'CITIZENSHIP'
737: ),

Line 841: hr_ru_utility.check_lookup_value

837: END IF;
838: -- Check Place of Birth takes valid OKATO lookup value
839: IF (p_per_information1 <> hr_api.g_varchar2)
840: THEN
841: hr_ru_utility.check_lookup_value
842: (p_argument => hr_general.decode_lookup
843: ('RU_FORM_LABELS',
844: 'PLACE_OF_BIRTH'
845: ),

Line 866: hr_ru_utility.check_lookup_value

862: );
863:
864: IF (p_per_information4 <> hr_api.g_varchar2)
865: THEN
866: hr_ru_utility.check_lookup_value
867: (p_argument => hr_general.decode_lookup
868: ('RU_FORM_LABELS',
869: 'CITIZENSHIP'
870: ),