APPS.IGS_PE_GEN_004 dependencies on FND_PROFILE

Line 113: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');

109: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;
110: l_per_country_code VARCHAR2(30);
111: l_oth_ctzn_exists VARCHAR2(1);
112: BEGIN
113: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');
114: l_per_country_code := convert_country_code (l_fnd_country_code);
115:
116: OPEN check_eit_cur(p_person_id, 'PE_INT_PERM_RES', l_per_country_code);
117: FETCH check_eit_cur INTO check_eit_rec;

Line 180: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');

176: l_fnd_country_code FND_TERRITORIES_VL.TERRITORY_CODE%TYPE;
177: l_per_country_code VARCHAR2(30);
178: BEGIN
179:
180: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');
181: l_per_country_code := convert_country_code (l_fnd_country_code);
182:
183: OPEN check_eit_cur(p_person_id, 'PE_INT_PERM_RES', l_per_country_code);
184: FETCH check_eit_cur INTO check_eit_rec;

Line 330: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');

326: APP_EXCEPTION.RAISE_EXCEPTION;
327: END IF;
328: CLOSE student_check_cur;
329:
330: l_fnd_country_code := FND_PROFILE.VALUE('OSS_COUNTRY_CODE');
331: l_per_country_code := convert_country_code (l_fnd_country_code);
332:
333: /* Logic if p_has_citizen = 'Y' THEN
334: -- Check whether in HZ_CITIZENSHIP the person has any record with the Country as in the profile OSS_COUNTRY_CODE.