eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_ST_GEN_004 dependencies on IGS_EN_SU_ATTEMPT

Line 162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

158: -- Derive the IGS_PS_UNIT of study completion status
159: -- DEETYA element 355
160: DECLARE
161: v_ret_val NUMBER(2);
162: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
163: v_dummy_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
164: v_dummy_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 169: FROM IGS_EN_SU_ATTEMPT

165: v_dummy_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
166: v_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
167: CURSOR c_get_unit_attempt_status IS
168: SELECT unit_attempt_status
169: FROM IGS_EN_SU_ATTEMPT
170: WHERE person_id = p_person_id AND
171: course_cd = p_course_cd AND
172: uoo_id = p_uoo_id;
173: BEGIN

Line 533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

529: gslo.eftsu <> 0;
530: CURSOR c_sua_ucl_um (
531: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,
533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS

Line 535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

531: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,
533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
538: SELECT um.s_unit_mode
539: FROM IGS_EN_SU_ATTEMPT sua,

Line 536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,
533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
538: SELECT um.s_unit_mode
539: FROM IGS_EN_SU_ATTEMPT sua,
540: IGS_AS_UNIT_CLASS ucl,

Line 537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS

533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
538: SELECT um.s_unit_mode
539: FROM IGS_EN_SU_ATTEMPT sua,
540: IGS_AS_UNIT_CLASS ucl,
541: IGS_AS_UNIT_MODE um

Line 539: FROM IGS_EN_SU_ATTEMPT sua,

535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
537: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
538: SELECT um.s_unit_mode
539: FROM IGS_EN_SU_ATTEMPT sua,
540: IGS_AS_UNIT_CLASS ucl,
541: IGS_AS_UNIT_MODE um
542: WHERE sua.person_id = cp_person_id AND
543: sua.course_cd = cp_course_cd AND

Line 3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3032: ess.sua_ci_sequence_number = uoo.ci_sequence_number AND
3033: ess.sua_location_cd = uoo.location_cd AND
3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date

Line 3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3033: ess.sua_location_cd = uoo.location_cd AND
3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3034: ess.unit_class = uoo.unit_class ;
3035: CURSOR c_suah1 (
3036: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah
3042: WHERE suah.person_id = cp_person_id AND

Line 3041: FROM IGS_EN_SU_ATTEMPT_H suah

3037: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3038: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3039: SELECT suah.last_updated_by,
3040: suah.last_update_date
3041: FROM IGS_EN_SU_ATTEMPT_H suah
3042: WHERE suah.person_id = cp_person_id AND
3043: suah.course_cd = cp_course_cd AND
3044: suah.uoo_id = cp_uoo_id AND
3045: (suah.enrolled_dt IS NOT NULL OR

Line 3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3045: (suah.enrolled_dt IS NOT NULL OR
3046: suah.discontinued_dt IS NOT NULL)
3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date

Line 3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3046: suah.discontinued_dt IS NOT NULL)
3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3047: ORDER BY suah.hist_end_dt DESC;
3048: CURSOR c_suah2 (
3049: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah
3055: WHERE suah.person_id = cp_person_id AND

Line 3054: FROM IGS_EN_SU_ATTEMPT_H suah

3050: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3051: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3052: SELECT suah.last_updated_by,
3053: suah.last_update_date
3054: FROM IGS_EN_SU_ATTEMPT_H suah
3055: WHERE suah.person_id = cp_person_id AND
3056: suah.course_cd = cp_course_cd AND
3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;

Line 3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

3056: suah.course_cd = cp_course_cd AND
3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date

Line 3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

3057: suah.uoo_id = cp_uoo_id
3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah

Line 3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS

3058: ORDER BY suah.hist_end_dt DESC;
3059: CURSOR c_suah3 (
3060: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah
3066: WHERE suah.person_id = cp_person_id AND

Line 3065: FROM IGS_EN_SU_ATTEMPT_H suah

3061: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
3062: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE) IS
3063: SELECT suah.last_updated_by,
3064: suah.last_update_date
3065: FROM IGS_EN_SU_ATTEMPT_H suah
3066: WHERE suah.person_id = cp_person_id AND
3067: suah.course_cd = cp_course_cd AND
3068: suah.uoo_id = cp_uoo_id AND
3069: (suah.enrolled_dt IS NOT NULL OR

Line 3073: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

3069: (suah.enrolled_dt IS NOT NULL OR
3070: suah.discontinued_dt IS NOT NULL)
3071: ORDER BY suah.hist_end_dt DESC;
3072: CURSOR c_sua (
3073: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
3074: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
3075: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
3076: SELECT sua.last_updated_by,
3077: sua.last_update_date

Line 3074: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

3070: suah.discontinued_dt IS NOT NULL)
3071: ORDER BY suah.hist_end_dt DESC;
3072: CURSOR c_sua (
3073: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
3074: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
3075: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
3076: SELECT sua.last_updated_by,
3077: sua.last_update_date
3078: FROM IGS_EN_SU_ATTEMPT sua

Line 3075: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

3071: ORDER BY suah.hist_end_dt DESC;
3072: CURSOR c_sua (
3073: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
3074: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
3075: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
3076: SELECT sua.last_updated_by,
3077: sua.last_update_date
3078: FROM IGS_EN_SU_ATTEMPT sua
3079: WHERE sua.person_id = cp_person_id AND

Line 3078: FROM IGS_EN_SU_ATTEMPT sua

3074: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
3075: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
3076: SELECT sua.last_updated_by,
3077: sua.last_update_date
3078: FROM IGS_EN_SU_ATTEMPT sua
3079: WHERE sua.person_id = cp_person_id AND
3080: sua.course_cd = cp_course_cd AND
3081: sua.uoo_id = cp_uoo_id
3082: ORDER BY sua.last_update_date DESC;