APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_EN_SU_ATTEMPT

Line 660: igs_en_su_attempt_all suav,

656: NVL (cps.enrolled_credit_points, uv.enrolled_credit_points)
657: ) v_cp_achievable
658: FROM igs_ps_stdnt_unt_trn sut,
659: igs_ps_stdnt_trn sct,
660: igs_en_su_attempt_all suav,
661: igs_ps_usec_cps cps,
662: igs_ps_unit_ver uv,
663: igs_ca_inst ci
664: WHERE sut.person_id = p_person_id

Line 1232: FROM igs_en_su_attempt_all suav,

1228: NVL (suav.override_enrolled_cp,
1229: NVL (cps.enrolled_credit_points, uv.enrolled_credit_points)
1230: ) v_cp_achievable,
1231: suav.unit_attempt_status, suav.administrative_unit_status
1232: FROM igs_en_su_attempt_all suav,
1233: igs_ps_usec_cps cps,
1234: igs_ps_unit_ver uv,
1235: igs_en_stdnt_ps_att sca
1236: WHERE suav.person_id = p_person_id

Line 1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1265: ORDER BY suav.ci_start_dt, suav.unit_cd;
1266:
1267: ---------------------------------------- Local Function ------------------------
1268: FUNCTION asspl_val_dsp_unit(
1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1266:
1267: ---------------------------------------- Local Function ------------------------
1268: FUNCTION asspl_val_dsp_unit(
1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
1274: -- anilk, 22-Apr-2003, Bug# 2829262

Line 1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

1267: ---------------------------------------- Local Function ------------------------
1268: FUNCTION asspl_val_dsp_unit(
1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
1274: -- anilk, 22-Apr-2003, Bug# 2829262
1275: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE )

Line 1275: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE )

1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
1274: -- anilk, 22-Apr-2003, Bug# 2829262
1275: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE )
1276: RETURN BOOLEAN IS
1277:
1278: BEGIN
1279: DECLARE

Line 2044: FROM IGS_EN_SU_ATTEMPT sua

2040: WHERE cgm1.course_group_cd = cg1.course_group_cd
2041: AND cg1.course_group_type = cgt1.course_group_type
2042: AND cgt1.s_course_group_type = 'RELATED'))))) AND
2043: EXISTS( SELECT 'X'
2044: FROM IGS_EN_SU_ATTEMPT sua
2045: WHERE sua.person_id = suav.person_id AND
2046: sua.course_cd = suav.course_cd AND
2047: -- anilk, 22-Apr-2003, Bug# 2829262
2048: sua.uoo_id = suav.uoo_id AND

Line 2139: FROM IGS_EN_SU_ATTEMPT sua

2135: WHERE cgm1.course_group_cd = cg1.course_group_cd
2136: AND cg1.course_group_type = cgt1.course_group_type
2137: AND cgt1.s_course_group_type = 'RELATED'))))) AND
2138: EXISTS( SELECT 'X'
2139: FROM IGS_EN_SU_ATTEMPT sua
2140: WHERE sua.person_id = suav.person_id AND
2141: sua.course_cd = suav.course_cd AND
2142: -- anilk, 22-Apr-2003, Bug# 2829262
2143: sua.uoo_id = suav.uoo_id AND

Line 2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

2187: ci.start_dt,
2188: sca.course_cd;
2189: ---------------------------------------asspl_val_dsp_g_crs----------------------
2190: FUNCTION asspl_val_dsp_g_crs(
2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,
2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)

Line 2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

2188: sca.course_cd;
2189: ---------------------------------------asspl_val_dsp_g_crs----------------------
2190: FUNCTION asspl_val_dsp_g_crs(
2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,
2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
2196: RETURN BOOLEAN IS

Line 2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,

2190: FUNCTION asspl_val_dsp_g_crs(
2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,
2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
2196: RETURN BOOLEAN IS
2197:
2198: BEGIN -- asspl_val_dsp_g_crs

Line 2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)

2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,
2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
2196: RETURN BOOLEAN IS
2197:
2198: BEGIN -- asspl_val_dsp_g_crs
2199: -- local function to determine if a generic COURSE is displayed.

Line 2204: FROM IGS_EN_SU_ATTEMPT sua

2200: DECLARE
2201: v_dummy VARCHAR2(1);
2202: CURSOR c_sua IS
2203: SELECT 'x'
2204: FROM IGS_EN_SU_ATTEMPT sua
2205: WHERE sua.person_id = p_person_id AND
2206: sua.course_cd = p_course_cd AND
2207: (sua.unit_attempt_status IN ( 'ENROLLED',
2208: 'COMPLETED',