DBA Data[Home] [Help]

APPS.HR_RO_PERSON_VALIDATE dependencies on HR_GENERAL

Line 118: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','RESIDENCE'),p_per_information1,'PER_RO_RESIDENCE',p_hire_date);

114: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'First Name', p_argument_value => p_first_name );
115: hr_utility.set_location('Person validation :: ',1);
116: -- lookup chk :: Residence, Citizenship
117: IF nvl(p_per_information1,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
118: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','RESIDENCE'),p_per_information1,'PER_RO_RESIDENCE',p_hire_date);
119: END IF;
120: IF nvl(p_per_information2,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
121: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','CITIZENSHIP'),p_per_information2,'PER_RO_CITIZENSHIP',p_hire_date);
122: END IF;

Line 121: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','CITIZENSHIP'),p_per_information2,'PER_RO_CITIZENSHIP',p_hire_date);

117: IF nvl(p_per_information1,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
118: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','RESIDENCE'),p_per_information1,'PER_RO_RESIDENCE',p_hire_date);
119: END IF;
120: IF nvl(p_per_information2,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
121: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','CITIZENSHIP'),p_per_information2,'PER_RO_CITIZENSHIP',p_hire_date);
122: END IF;
123: hr_utility.set_location('Person validation :: ',2);
124: -- country x region x town
125: IF p_country_of_birth = 'RO' THEN