APPS.IGS_EN_GEN_LEGACY dependencies on IGS_EN_SU_ATTEMPT

Line 164: FROM igs_en_su_attempt sua

160: --
161: -- Cursor to find matching Units Attempts for Transfer.
162: CURSOR cnt_unit IS
163: SELECT COUNT(*)
164: FROM igs_en_su_attempt sua
165: WHERE sua.person_id = p_person_id AND
166: sua.course_cd = p_program_cd AND
167: sua.unit_cd = p_unit_cd AND
168: sua.cal_type = p_cal_type AND

Line 177: FROM igs_en_su_attempt sua

173: --
174: -- Cursor to get the unit attempt status.
175: CURSOR val_status IS
176: SELECT sua.unit_attempt_status
177: FROM igs_en_su_attempt sua
178: WHERE sua.person_id = p_person_id AND
179: sua.course_cd= p_program_cd AND
180: sua.unit_cd = p_unit_cd AND
181: sua.cal_type = p_cal_type AND

Line 187: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE ;

183: sua.location_cd = p_location_cd AND
184: sua.unit_class = p_unit_class ;
185:
186: l_count NUMBER := 0;
187: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE ;
188:
189: BEGIN
190:
191: -- Validate unit to be transferred

Line 382: l_version_number igs_en_su_attempt.version_number%TYPE;

378: ci_sequence_number = p_ci_sequence_number AND
379: location_cd = p_location_cd AND
380: unit_class = p_unit_class;
381:
382: l_version_number igs_en_su_attempt.version_number%TYPE;
383: l_count NUMBER := 0;
384:
385: BEGIN
386:

Line 553: FROM IGS_EN_SU_ATTEMPT

549: Who When What
550: ------------------------------------------------------------------*/
551: CURSOR cur_unit_atmpt_dis IS
552: SELECT cal_type,ci_sequence_number,discontinued_dt
553: FROM IGS_EN_SU_ATTEMPT
554: WHERE person_id = x_person_id
555: AND course_cd = x_course_cd
556: AND discontinued_dt IS NOT NULL
557: ORDER BY discontinued_dt DESC;

Line 569: FROM IGS_EN_SU_ATTEMPT

565: ORDER BY load_start_dt DESC;
566:
567: CURSOR cur_unit_atmpt_grd IS
568: SELECT cal_type,ci_sequence_number
569: FROM IGS_EN_SU_ATTEMPT
570: WHERE person_id = x_person_id
571: AND course_cd = x_course_cd
572: AND unit_attempt_status='COMPLETED';
573:

Line 584: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

580: ORDER BY load_end_dt DESC;
581:
582: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
583: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
584: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
585:
586: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;
587: cur_term_cal_rec cur_term_cal%ROWTYPE;
588: cur_unit_atmpt_grd_rec cur_unit_atmpt_grd%ROWTYPE;

Line 1744: FROM igs_en_su_attempt sua,

1740: -- teaching period census dates.
1741:
1742: CURSOR c_intm_census_ovrlp(l_census_dt_alias igs_ge_s_gen_cal_con.census_dt_alias%TYPE) IS
1743: SELECT 'x'
1744: FROM igs_en_su_attempt sua,
1745: igs_ca_da_inst_v da
1746: WHERE sua.person_id = p_person_id
1747: AND sua.course_cd = p_program_cd
1748: AND sua.unit_attempt_status IN ('ENROLLED','COMPLETED')