APPS.PER_RO_NI_VALIDATION dependencies on HR_API

Line 138: if nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date and l_valid_flag then-- to skip vaidations when called from formula

134: l_valid_flag := FALSE;
135: return_value := 4;
136: end if;
137:
138: if nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date and l_valid_flag then-- to skip vaidations when called from formula
139: if ((mod(l_year,100) <> Y2) or (l_month <> M4) or (l_date <> D6)) then -- date of birth mismatch
140: l_valid_flag := FALSE;
141: return_value := 3;
142: end if;

Line 151: if (nvl(p_citizenship,'X')= 'RO' or S1 <= 6 ) and nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then -- chk for Romanian Citizenship

147: hr_utility.trace('S1'||S1);
148: hr_utility.trace('(trunc(l_year,-2)/100)'||(trunc(l_year,-2)/100));
149: -- Gender | Citizenship | Residence
150: if l_valid_flag then -- skip validation when citizenship not provided
151: if (nvl(p_citizenship,'X')= 'RO' or S1 <= 6 ) and nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then -- chk for Romanian Citizenship
152: case (trunc(l_year,-2)/100)
153: when 19 then
154: if not((P_SEX='M' and S1 = 1) or (P_SEX ='F' and S1 = 2)) then
155: l_valid_flag := FALSE;

Line 177: elsif nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then --((trunc(l_year,-2)/100) <> 19) and

173: if (p_residence = 'R') then
174: if not((P_SEX='M' and S1=7 ) or (P_SEX='F' and S1=8)) then
175: l_valid_flag := FALSE;
176: return_value := 4;
177: elsif nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then --((trunc(l_year,-2)/100) <> 19) and
178: l_valid_flag := FALSE;
179: return_value := 3;
180: end if;
181: else

Line 185: elsif nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then -- ((trunc(l_year,-2)/100) <> 19)

181: else
182: if S1 <> 9 then
183: l_valid_flag := FALSE;
184: return_value := 4;
185: elsif nvl(P_DATE_OF_BIRTH,hr_api.g_date) <> hr_api.g_date then -- ((trunc(l_year,-2)/100) <> 19)
186: l_valid_flag := FALSE;
187: return_value := 3;
188: end if;
189: end if;