7: --
8: v_dni_return VARCHAR2(30);
9: BEGIN
10: -- For Bug 3358291 did the SUBSTR of p_identifier_value
11: v_dni_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
12: ,'DDDDDDDD');
13: IF (v_dni_return='0') THEN
14: RETURN 'N';
15: ELSE
55: v_nif(21) := 'C';
56: v_nif(22) := 'K';
57: v_nif(23) := 'E';
58: --
59: v_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
60: ,'DDDDDDDDA');
61: IF v_return = '0' THEN
62: RETURN 'N';
63: ELSE
83: BEGIN
84: -- Bug 7214735
85: -- Changing the valid format for NIE to ADDDDDDDDA ( like A12345678Z ),
86: -- i.e, 8 digits inplace of 7
87: -- v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
88: -- ,'ADDDDDDDA');
89: v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
90: ,'ADDDDDDDDA');
91:
85: -- Changing the valid format for NIE to ADDDDDDDDA ( like A12345678Z ),
86: -- i.e, 8 digits inplace of 7
87: -- v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
88: -- ,'ADDDDDDDA');
89: v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)
90: ,'ADDDDDDDDA');
91:
92: IF (v_nie_return='0') THEN
93: RETURN 'N';
729: BEGIN
730: --
731: IF (length(p_identifier_value) <> 12) THEN
732: RETURN 'N';
733: ELSIF (hr_ni_chk_pkg.chk_nat_id_format(p_identifier_value,'DDDDDDDDDDDD') <> p_identifier_value) THEN
734: RETURN 'N';
735: ELSE
736: v_province_code := substr(p_identifier_value,1,2);
737: --v_random_number := substr(p_identifier_value,3,8);