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 535: hr_ru_utility.check_lookup_value

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

Line 631: hr_ru_utility.check_lookup_value

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

Line 741: hr_ru_utility.check_lookup_value

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

Line 849: hr_ru_utility.check_lookup_value

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

Line 874: hr_ru_utility.check_lookup_value

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