DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on HR_NI_CHK_PKG

Line 320: IF (l_len =7 AND (l_tmp IS NULL OR hr_ni_chk_pkg.chk_nat_id_format(l_tmp,'A') = '0' )) OR (l_len=6 AND l_tmp IS NOT NULL)

316: ELSE
317: SELECT translate (p_military_reg_board_code, '0123456789', ' ')
318: INTO l_tmp
319: FROM dual;
320: IF (l_len =7 AND (l_tmp IS NULL OR hr_ni_chk_pkg.chk_nat_id_format(l_tmp,'A') = '0' )) OR (l_len=6 AND l_tmp IS NOT NULL)
321: THEN
322: hr_utility.set_message (800, 'HR_RU_INVALID_MIL_REG_CODE');
323: hr_utility.set_warning;
324: END IF;

Line 514: IF hr_ni_chk_pkg.chk_nat_id_format (p_kpp, 'DDDDDDDDD') = '0'

510: IF LENGTH (p_kpp) <> 9
511: THEN
512: RETURN 0;
513: END IF;
514: IF hr_ni_chk_pkg.chk_nat_id_format (p_kpp, 'DDDDDDDDD') = '0'
515: THEN
516: RETURN 0;
517: END IF;
518: IF p_kpp = '000000000'

Line 548: IF hr_ni_chk_pkg.chk_nat_id_format (p_si, 'DDDDDDDDDD') = '0'

544: IF chk_code > 0
545: THEN
546: RETURN 0;
547: END IF;
548: IF hr_ni_chk_pkg.chk_nat_id_format (p_si, 'DDDDDDDDDD') = '0'
549: THEN
550: RETURN 0;
551: END IF;
552: RETURN 1;

Line 574: IF hr_ni_chk_pkg.chk_nat_id_format (p_okogu, 'DDDDD') = '0'

570: IF chk_code > 0
571: THEN
572: RETURN 0;
573: END IF;
574: IF hr_ni_chk_pkg.chk_nat_id_format (p_okogu, 'DDDDD') = '0'
575: THEN
576: RETURN 0;
577: END IF;
578: RETURN 1;

Line 594: IF hr_ni_chk_pkg.chk_nat_id_format (p_okpo, 'DDDDDDDD') = '0'

590: IF LENGTH (p_okpo) <> 8
591: THEN
592: RETURN 0;
593: END IF;
594: IF hr_ni_chk_pkg.chk_nat_id_format (p_okpo, 'DDDDDDDD') = '0'
595: THEN
596: RETURN 0;
597: END IF;
598: IF p_okpo = '00000000'

Line 627: IF hr_ni_chk_pkg.chk_nat_id_format (p_spifn, 'DDD-DDD-DDDDDD') = '0'

623: IF chk_code > 0
624: THEN
625: RETURN 0;
626: END IF;
627: IF hr_ni_chk_pkg.chk_nat_id_format (p_spifn, 'DDD-DDD-DDDDDD') = '0'
628: THEN
629: RETURN 0;
630: END IF;
631: IF instr (p_spifn, '-', 1) <> 4 OR instr (p_spifn, '-', 5) <> 8

Line 698: IF hr_ni_chk_pkg.chk_nat_id_format (p_bank_bik, 'DDDDDDDDD') = '0'

694: IF LENGTH (p_bank_bik) <> 9
695: THEN
696: RETURN 0;
697: END IF;
698: IF hr_ni_chk_pkg.chk_nat_id_format (p_bank_bik, 'DDDDDDDDD') = '0'
699: THEN
700: RETURN 0;
701: END IF;
702: IF p_bank_bik = '000000000'

Line 726: IF hr_ni_chk_pkg.chk_nat_id_format (p_bank_acc_no, 'DDDDDDDDDDDDDDDDDDDD') = '0'

722: IF LENGTH (p_bank_acc_no) <> 20
723: THEN
724: RETURN 0;
725: END IF;
726: IF hr_ni_chk_pkg.chk_nat_id_format (p_bank_acc_no, 'DDDDDDDDDDDDDDDDDDDD') = '0'
727: THEN
728: RETURN 0;
729: END IF;
730: IF p_bank_acc_no = '00000000000000000000'