DBA Data[Home] [Help]

APPS.HR_NL_EXTRA_PERSON_RULES dependencies on HR_API

Line 32: if (p_national_identifier is null OR p_national_identifier = hr_api.g_varchar2) AND NVL(fnd_profile.value('HR_NL_NI_OPTIONAL'),'N') = 'N'

28: hr_utility.set_message_token('LEG_CODE','NL');
29: hr_utility.raise_error;
30: end if;
31:
32: if (p_national_identifier is null OR p_national_identifier = hr_api.g_varchar2) AND NVL(fnd_profile.value('HR_NL_NI_OPTIONAL'),'N') = 'N'
33: AND fnd_profile.VALUE('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') /* bug 4570899*/ then
34: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
35: hr_utility.set_message_token('FIELD','SOFI Number');
36: hr_utility.set_message_token('LEG_CODE','NL');

Line 128: IF P_LAST_NAME = hr_api.g_varchar2 THEN

124: IF P_EMPLOYEE_NUMBER = NULL THEN
125: l_employee_num := P_EMPLOYEE_NUMBER;
126: END IF;
127:
128: IF P_LAST_NAME = hr_api.g_varchar2 THEN
129: l_last_name := P_LAST_NAME;
130: END IF;
131:
132: IF P_PER_INFORMATION1 = hr_api.g_varchar2 THEN

Line 132: IF P_PER_INFORMATION1 = hr_api.g_varchar2 THEN

128: IF P_LAST_NAME = hr_api.g_varchar2 THEN
129: l_last_name := P_LAST_NAME;
130: END IF;
131:
132: IF P_PER_INFORMATION1 = hr_api.g_varchar2 THEN
133: l_initial := P_PER_INFORMATION1;
134: END IF;
135:
136: IF P_NATIONAL_IDENTIFIER = hr_api.g_varchar2 THEN

Line 136: IF P_NATIONAL_IDENTIFIER = hr_api.g_varchar2 THEN

132: IF P_PER_INFORMATION1 = hr_api.g_varchar2 THEN
133: l_initial := P_PER_INFORMATION1;
134: END IF;
135:
136: IF P_NATIONAL_IDENTIFIER = hr_api.g_varchar2 THEN
137: l_sofi := P_NATIONAL_IDENTIFIER;
138: END IF;
139:
140: /* If resend flag is already set to YES