APPS.IGS_SS_ENR_DETAILS dependencies on FND_PROFILE

Line 2428: IF fnd_profile.value('IGS_PS_PRENRL_YEAR_IND') = 'Y' THEN

2424:
2425: l_us_title igs_en_unit_set.title%TYPE;
2426: BEGIN
2427: -- Check whether the pre-enrollment YOP profile is set to Y
2428: IF fnd_profile.value('IGS_PS_PRENRL_YEAR_IND') = 'Y' THEN
2429:
2430: -- loop through the census dates for given term cal type and sequence number
2431: FOR l_rec_cen_dates IN c_term_cen_dates(p_term_cal_type,
2432: p_term_sequence_number) LOOP

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

2484: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2485: AND sca.person_id = cp_person_id
2486: AND sca.course_cd = cp_program_cd
2487: AND ((igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) = 'PRIMARY') OR
2488: (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N')= 'N')
2489: );
2490:
2491: l_prg_title igs_ps_ver_all.title%TYPE;
2492:

Line 2543: IF fnd_profile.value('CAREER_MODEL_ENABLED') = 'Y' THEN

2539: l_sec_prg_title VARCHAR2(2000);
2540:
2541: BEGIN
2542:
2543: IF fnd_profile.value('CAREER_MODEL_ENABLED') = 'Y' THEN
2544:
2545: FOR l_sec_prg_rec IN c_sec_prg_title(p_person_id,p_program_cd,p_program_version,p_term_cal_type,p_term_sequence_number) LOOP
2546: l_sec_prg_title := l_sec_prg_title ||', '||l_sec_prg_rec.title;
2547: END LOOP;

Line 4753: IF l_plan_flag = 'Y' AND NVL(fnd_profile.value('IGS_EN_USE_PLAN'),'OFF') = 'ON' THEN

4749: END IF; -- end of IF l_schedule_flag = 'Y
4750:
4751: -- Check whether the planning is open for the given term
4752: -- if the plannings is allowed for the plannig sheet and IGS: Use Planning Sheet Profile is ON
4753: IF l_plan_flag = 'Y' AND NVL(fnd_profile.value('IGS_EN_USE_PLAN'),'OFF') = 'ON' THEN
4754:
4755: -- Get the planning sheet date alias value for the given load calendar.
4756: l_dt_alias_val := igs_ss_enr_details.get_alias_val( p_load_cal_type, p_load_seq_num,l_plan_dt_alias);
4757: