APPS.IGS_EN_GEN_011 dependencies on FND_PROFILE

Line 745: fnd_profile.value('OSS_COUNTRY_CODE') = 'GB' ) THEN

741:
742: -- Check if the version number has been updated
743: -- and country code is 'GB', as per HESA bug 3985220
744: IF (v_sca_upd_exists.version_number <> p_to_crs_version_number AND
745: fnd_profile.value('OSS_COUNTRY_CODE') = 'GB' ) THEN
746:
747: BEGIN
748: FOR v_he_spa_upd_rec IN c_he_spa_upd LOOP
749:

Line 1387: OR NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N')

1383: sua.cal_type = p_teach_cal_type AND
1384: sua.ci_sequence_number = p_teach_ci_sequence_number))
1385: AND (igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id,sca.course_cd,
1386: p_load_cal_type,p_load_cal_seq) = 'PRIMARY'
1387: OR NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N')
1388: ORDER BY sca.person_id,
1389: sca.course_cd
1390: FOR UPDATE NOWAIT;
1391: CURSOR c_enroll(cp_code igs_lookup_values.lookup_code%TYPE) IS

Line 2172: IF fnd_profile.value('IGS_EN_CORE_VAL') = 'Y' THEN

2168: l_ret_stat:= NULL;
2169:
2170: -- Check whether the profile is set or not
2171: -- If it is set to 'Y' determine the value of core indicator otherwise assign NULL to it
2172: IF fnd_profile.value('IGS_EN_CORE_VAL') = 'Y' THEN
2173: l_core_indicator_code := igs_en_gen_009.enrp_check_usec_core(rec_sca.person_id,rec_sca.course_cd,l_uoo_id);
2174: ELSE
2175: l_core_indicator_code := NULL;
2176: END IF;