DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on FND_PROFILE

Line 1568: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1564: --logicall code is adding w.r.t. to YOP-EN build bug id :2156956 by kkillams
1565: --checking of passing parameter unitset are active or not.
1566: l_us_count :=0;
1567: --Checking the whether pre-enrollment profile value is set Y or not.
1568: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1569: IF p_unit_set_cd1 is NULL THEN
1570: l_us_count:= l_us_count + 1;
1571: ELSE
1572: OPEN c_yop_us_st(v_acaiv_rec.person_id,v_acaiv_rec.course_cd,p_unit_set_cd1);

Line 1598: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1594: vl_process := TRUE;
1595: END IF;
1596:
1597: IF vl_process THEN
1598: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1599: v_prog_outcome := enrp_get_pr_outcome(v_acaiv_rec.person_id,v_acaiv_rec.course_cd);
1600: IF v_prog_outcome IS NULL THEN
1601: vl_process := FALSE;
1602: ELSIF v_prog_outcome = 'ADVANCE' AND NVL(p_progress_stat,'ADVANCE') IN ('ADVANCE','BOTH') THEN

Line 1766: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1762: --checking of passing unitset are active or not.
1763: l_us_count:=0;
1764:
1765: --Checking the whether pre-enrollment profile value is set Y or not.
1766: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1767: IF p_unit_set_cd1 is NULL THEN
1768: l_us_count:= l_us_count + 1;
1769: ELSE
1770: OPEN c_yop_us_st(v_sca_rec.person_id,v_sca_rec.course_cd,p_unit_set_cd1);

Line 1796: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1792: vl_process := TRUE;
1793: END IF;
1794:
1795: IF vl_process THEN
1796: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1797: v_prog_outcome := enrp_get_pr_outcome(v_sca_rec.person_id,v_sca_rec.course_cd);
1798: IF v_prog_outcome IS NULL OR v_prog_outcome = 'NEW' THEN
1799: vl_process := FALSE;
1800: ELSIF v_prog_outcome = 'ADVANCE' AND NVL(p_progress_stat,'ADVANCE') IN ('ADVANCE','BOTH') THEN

Line 1908: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1904: --logicall code is adding w.r.t. to YOP-EN build bug id :2156956 by kkillams
1905: --checking of passing unitset are active or not.
1906: l_us_count:=0;
1907: --Checking the whether pre-enrollment profile value is set Y or not.
1908: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1909: IF p_unit_set_cd1 is NULL THEN
1910: l_us_count:= l_us_count + 1;
1911: ELSE
1912: OPEN c_yop_us_st(v_sca_rec.person_id,v_sca_rec.course_cd,p_unit_set_cd1);

Line 1938: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN

1934: vl_process := TRUE;
1935: END IF;
1936:
1937: IF vl_process THEN
1938: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
1939: v_prog_outcome := enrp_get_pr_outcome(v_sca_rec.person_id,v_sca_rec.course_cd);
1940: IF v_prog_outcome IS NULL OR v_prog_outcome = 'NEW' THEN
1941: vl_process := FALSE;
1942: ELSIF v_prog_outcome = 'ADVANCE' AND NVL(p_progress_stat,'ADVANCE') IN ('ADVANCE','BOTH') THEN

Line 2602: IF fnd_profile.value('IGS_EN_UPDATE_CP_GS')='Y' THEN

2598: -- l_v_person_type := l_cur_sys_per_typ.system_type
2599: -- as it was overwritting the person type of the logged in user.
2600: --
2601: IF l_cur_sys_per_typ.system_type = 'STUDENT' THEN
2602: IF fnd_profile.value('IGS_EN_UPDATE_CP_GS')='Y' THEN
2603: RETURN 'N';
2604: END IF;
2605:
2606: IF igs_en_gen_015.validation_step_is_overridden(