APPS.PER_ES_UPDATE_PERSON dependencies on HR_API

Line 85: IF p_per_information2 = hr_api.g_varchar2 AND p_per_information3 = hr_api.g_varchar2 THEN

81: l_identifier_value := p_per_information3;
82: -- p_per_information2 and p_per_information3 will be passed as NULL wen called
83: --from ppl mgt template and would be defaulted to g_varchar2 wen called from self service
84: --the below condition handles both the scenarios
85: IF p_per_information2 = hr_api.g_varchar2 AND p_per_information3 = hr_api.g_varchar2 THEN
86: null;
87: ELSE
88: l_identifier_type := p_per_information2;
89: l_identifier_value := p_per_information3;

Line 92: IF p_per_information2 = hr_api.g_varchar2 THEN

88: l_identifier_type := p_per_information2;
89: l_identifier_value := p_per_information3;
90: --
91:
92: IF p_per_information2 = hr_api.g_varchar2 THEN
93: OPEN get_identifier_type(p_person_id,p_effective_date);
94: FETCH get_identifier_type INTO l_identifier_type;
95: CLOSE get_identifier_type;
96: ELSIF p_per_information3 = hr_api.g_varchar2 THEN

Line 96: ELSIF p_per_information3 = hr_api.g_varchar2 THEN

92: IF p_per_information2 = hr_api.g_varchar2 THEN
93: OPEN get_identifier_type(p_person_id,p_effective_date);
94: FETCH get_identifier_type INTO l_identifier_type;
95: CLOSE get_identifier_type;
96: ELSIF p_per_information3 = hr_api.g_varchar2 THEN
97: OPEN get_identifier_value(p_person_id,p_effective_date);
98: FETCH get_identifier_value INTO l_identifier_value;
99: CLOSE get_identifier_value;
100: END IF;

Line 133: IF p_national_identifier = hr_api.g_varchar2 AND l_identifier_value = hr_api.g_varchar2 THEN

129: END IF;
130: --
131: END IF;
132: --
133: IF p_national_identifier = hr_api.g_varchar2 AND l_identifier_value = hr_api.g_varchar2 THEN
134: null;
135: ELSE
136: l_national_identifier := p_national_identifier;
137: IF p_national_identifier = hr_api.g_varchar2 THEN

Line 137: IF p_national_identifier = hr_api.g_varchar2 THEN

133: IF p_national_identifier = hr_api.g_varchar2 AND l_identifier_value = hr_api.g_varchar2 THEN
134: null;
135: ELSE
136: l_national_identifier := p_national_identifier;
137: IF p_national_identifier = hr_api.g_varchar2 THEN
138: OPEN get_national_ident(p_person_id,p_effective_date);
139: FETCH get_national_ident INTO l_national_identifier;
140: CLOSE get_national_ident;
141: END IF;

Line 142: IF l_identifier_value = hr_api.g_varchar2 THEN

138: OPEN get_national_ident(p_person_id,p_effective_date);
139: FETCH get_national_ident INTO l_national_identifier;
140: CLOSE get_national_ident;
141: END IF;
142: IF l_identifier_value = hr_api.g_varchar2 THEN
143: OPEN get_identifier_value(p_person_id,p_effective_date);
144: FETCH get_identifier_value INTO l_identifier_value;
145: CLOSE get_identifier_value;
146: END IF;

Line 167: hr_api.mandatory_arg_error

163: END IF;
164: END IF;
165: END IF;
166: --
167: hr_api.mandatory_arg_error
168: (p_api_name => l_proc,
169: p_argument => hr_general.decode_lookup('ES_FORM_LABELS','LAST_NAME_1'),
170: p_argument_value => p_last_name
171: );