[Home] [Help]
918: l_rec_exist := TRUE;
919: END IF;
920: CLOSE c_pos;
921:
922: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
923: FOR vc_acad_us_rec IN c_acad_us(p_unit_set_cd) LOOP
924: OPEN c_susa_exists(vc_acad_us_rec.stream_unit_set_cd, p_person_id, p_course_Cd);
925: FETCH c_susa_exists INTO v_dummy;
926: IF c_susa_exists%FOUND THEN
950: --smaddali adding code for YOP-EN dld . bug#2156956
951: -- If year of program mode is enabled then check if 'academic period within unit sets' is checked
952: -- for the pattern of study, if so get number of periods form igs_en_susa_year_v else use original function
953: --l_rec_exist checks if vt_two_pos has any values in it.
954: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' AND l_rec_exist THEN
955: IF NVL(vt_two_pos(vt_two_pos.FIRST).acad_perd_unit_set,'N') = 'Y' AND
956: p_unit_set_cd IS NOT NULL THEN
957: OPEN c_num_acad_perd ;
958: FETCH c_num_acad_perd INTO v_period_number ;
977: p_acad_sequence_number,
978: v_aci_rec.start_dt);
979: END IF;
980:
981: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y'
982: AND NVL(p_progress_outcome_type,'ADVANCE') = 'REPEATYR'
983: AND NVL(P_PROGRESS_STAT,'ADVANCE') IN ('BOTH','REPEATYR') THEN
984: v_period_number := v_period_number - 1;
985: END IF;
1004: p_log_creation_dt,
1005: v_warn_level,
1006: v_message_name) = cst_false THEN
1007: IF v_message_name = 'IGS_EN_STUD_INELG_PROGRESSION'
1008: AND NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y'
1009: AND NVL(p_progress_outcome_type,'ADVANCE') = 'REPEATYR'
1010: AND NVL(P_PROGRESS_STAT,'ADVANCE') IN ('BOTH','REPEATYR')THEN
1011: NULL; -- do nothing
1012: ELSE
1278: IGS_CA_GEN_001.CALP_GET_CI_DATES(v_posp_rec.teach_cal_type,
1279: v_cir_rec.sequence_number,
1280: v_ci_start_dt,v_ci_end_dt);
1281: -- Check whether the profile is set or not
1282: IF NVL(fnd_profile.value('IGS_EN_CORE_VAL'),'N') = 'N' THEN
1283: l_core_indicator_code := NULL;
1284: ELSE
1285: -- If the profile is set, derive the value of core indicator based
1286: -- on the value of core unit indicator in pattern of study periods table.
2766: l_rec_exist := TRUE;
2767: END IF;
2768: CLOSE c_pos;
2769:
2770: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
2771:
2772: FOR vc_acad_us_rec IN c_acad_us(p_unit_set_cd) LOOP
2773: OPEN c_susa_exists(vc_acad_us_rec.stream_unit_set_cd, p_person_id, p_program_cd);
2774: FETCH c_susa_exists INTO l_dummy;
2782: -- Determine the number of academic periods in which the
2783: -- student has been enrolled
2784:
2785: -- If year of program mode is enabled
2786: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' AND l_rec_exist THEN
2787:
2788: -- If 'Academic Period within Unit Sets' is checked for the pattern of study,
2789: -- Get number of periods from igs_en_susa_year_v else use original function
2790: -- igs_en_gen_004.enrp_get_perd_num.
2833:
2834: BEGIN
2835:
2836: -- If the value of profile 'IGS_EN_CORE_VAL' if not set or set to No then Return NULL
2837: IF NVL(fnd_profile.value('IGS_EN_CORE_VAL'),'N') = 'N' THEN
2838:
2839: RETURN NULL;
2840: END IF;
2841:
2855: SYSDATE
2856: );
2857:
2858: -- If Pre_Enrollment Year profile option is set to Yes
2859: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
2860:
2861: -- Get the current unit set attempt of type pre-enrollment
2862: OPEN c_last_unit_set;
2863: FETCH c_last_unit_set INTO l_last_unit_set_cd;
3195: -- Determine the number of academic periods in which the
3196: -- student has been enrolled
3197:
3198: -- If year of program mode is enabled
3199: IF NVL(FND_PROFILE.VALUE('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
3200:
3201: -- If 'Academic Period within Unit Sets' is checked for the pattern of study,
3202: -- Get number of periods from igs_en_susa_year_v else use original function
3203: -- igs_en_gen_004.enrp_get_perd_num.
3246:
3247: BEGIN
3248:
3249: -- If the value of profile 'IGS_EN_CORE_VAL' if not set or set to No then Return NULL
3250: IF NVL(fnd_profile.value('IGS_EN_CORE_VAL'),'N') = 'N' THEN
3251:
3252: RETURN NULL;
3253: END IF;
3254:
3282: SYSDATE
3283: );
3284:
3285: -- If Pre_Enrollment Year profile option is set to Yes
3286: IF NVL(fnd_profile.value('IGS_PS_PRENRL_YEAR_IND'),'N') = 'Y' THEN
3287:
3288: -- Get the current unit set attempt of type pre-enrollment
3289: IF p_unit_set_cd IS NULL THEN
3290: OPEN c_last_unit_set;