DBA Data[Home] [Help]

APPS.IGS_PE_USERID_PKG dependencies on FND_LOOKUP_VALUES

Line 2166: FROM fnd_lookup_values

2162: ) IS
2163:
2164: CURSOR cur_gender (cp_gender VARCHAR2) IS
2165: SELECT meaning
2166: FROM fnd_lookup_values
2167: WHERE lookup_type = 'HZ_GENDER'
2168: AND view_application_id = 222
2169: AND language = USERENV('LANG')
2170: AND security_group_id = 0

Line 2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;

2174: SELECT description
2175: FROM igs_pe_person_id_typ
2176: WHERE person_id_type = cp_pers_id_type;
2177:
2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;

Line 2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;

2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;
2184: l_formatted_phone VARCHAR2(100);
2185: x_return_status VARCHAR2(1);
2186: x_msg_count NUMBER;