APPS.IGS_EN_PRC_LOAD dependencies on FND_PROFILE

Line 47: g_wlst_prfl CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('IGS_EN_VAL_WLST');

43: ckasu 24-Feb-2006 Modified cur_stud_ua_acad curson in enrp_clc_cp_upto_tp_start_dt
44: for perf bug #5059308
45: ********************************************************************************************/
46:
47: g_wlst_prfl CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('IGS_EN_VAL_WLST');
48:
49: -- To calculate the EFTSU total for a UNIT attempt across all load cals
50: FUNCTION ENRP_CLC_SUA_EFTSUT(
51: P_PERSON_ID IN NUMBER ,

Line 1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')

1818: WHERE sca.person_id = cp_person_id
1819: AND sca.course_cd = pv.course_cd
1820: AND sca.version_number = pv.version_number
1821: AND (
1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')
1823: OR
1824: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N')
1825: );
1826:

Line 1824: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N')

1820: AND sca.version_number = pv.version_number
1821: AND (
1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')
1823: OR
1824: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N')
1825: );
1826:
1827:
1828: vc_spa c_spa%ROWTYPE;

Line 2041: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N')='N' THEN

2037: RETURN;
2038: END IF;
2039:
2040: --## Check for the type of Model whether career centric or Program Centric
2041: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N')='N' THEN
2042: OPEN c_active_cd('N');
2043: FETCH c_active_cd INTO l_active_cd;
2044: IF c_active_cd%NOTFOUND THEN
2045: close c_active_cd;