DBA Data[Home] [Help]

APPS.HR_ES_UTILITY dependencies on HR_NI_CHK_PKG

Line 11: v_dni_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)

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

Line 59: v_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)

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

Line 87: -- v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)

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:

Line 89: v_nie_return := hr_ni_chk_pkg.chk_nat_id_format(substr(p_identifier_value,1,30)

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';

Line 733: ELSIF (hr_ni_chk_pkg.chk_nat_id_format(p_identifier_value,'DDDDDDDDDDDD') <> p_identifier_value) THEN

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);