APPS.IGS_EN_GEN_003 dependencies on IGS_PS_TYPE

Line 233: v_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;

229: v_set_cal BOOLEAN;
230: v_crs_commencement_type VARCHAR2(10);
231: v_commencement_type VARCHAR2(10);
232: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
233: v_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
234: l_position NUMBER;
235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236:
237: CURSOR c_sca(

Line 282: FROM IGS_PS_TYPE pt,

278: CURSOR c_pst(
279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
280: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
281: SELECT ENROLMENT_CAT
282: FROM IGS_PS_TYPE pt,
283: IGS_PS_VER pv
284: WHERE pv.course_cd = p_course_cd AND
285: pv.course_type = pt.course_type AND
286: pv.version_number = cp_version_number ;

Line 766: FROM IGS_PS_TYPE pt,

762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,
764: cp_version_number IGS_PS_VER.version_number%TYPE) IS
765: Select award_course_ind
766: FROM IGS_PS_TYPE pt,
767: IGS_PS_VER pv
768: WHERE pv.course_type = pt.course_type AND
769: pv.course_cd = cp_course_cd AND
770: pv.version_number = cp_version_number ;

Line 771: lv_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;

767: IGS_PS_VER pv
768: WHERE pv.course_type = pt.course_type AND
769: pv.course_cd = cp_course_cd AND
770: pv.version_number = cp_version_number ;
771: lv_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
772: CURSOR c_cttl(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE,
773: cp_teach_ci_seq_num IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE) IS
774: Select load_cal_type,
775: load_ci_sequence_number