APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on FND_PROFILE

Line 456: IF fnd_profile.value('IGS_FI_RES_CLASS_ID') IS NULL THEN

452: END IF;
453: CLOSE cur_ninumber_alt_type;
454:
455: -- Check whether the Residency Class Profile is defined for Residency Category import
456: IF fnd_profile.value('IGS_FI_RES_CLASS_ID') IS NULL THEN
457:
458: fnd_file.put_line( fnd_file.LOG ,' ');
459: fnd_message.set_name('IGS','IGS_UC_RES_CLASS_NOT_DEF');
460: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2137: ,fnd_profile.value('IGS_FI_RES_CLASS_ID')

2133: VALUES (
2134: igs_pe_res_dtls_int_s.NEXTVAL
2135: ,p_interface_id
2136: ,l_residency_status_cd
2137: ,fnd_profile.value('IGS_FI_RES_CLASS_ID')
2138: ,TRUNC(SYSDATE)
2139: ,l_person_number -- Bug No. 2980137. Replaced decision_make_id with l_person_number
2140: ,'2' -- Pending Status
2141: ,g_created_by