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_IN_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 649: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

645: gv_other_detail VARCHAR2(255);
646: BEGIN -- func_module
647: DECLARE
648: cst_enrolled CONSTANT
649: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
650: v_crv_credit_points_required IGS_PS_VER.credit_points_required%TYPE;
651: v_enrolled_total NUMBER;
652: v_cp_required IGS_PS_VER.credit_points_required%TYPE;
653: v_cp_passed NUMBER;

Line 673: FROM IGS_EN_SU_ATTEMPT sua,

669: NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
670: )
671: )
672: )
673: FROM IGS_EN_SU_ATTEMPT sua,
674: IGS_PS_UNIT_VER uv ,
675: IGS_PS_USEC_CPS cps
676: WHERE sua.person_id = p_person_id AND
677: sua.course_cd = p_course_cd AND

Line 986: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE)

982: p_s_result_type IN VARCHAR2 ,
983: p_repeatable_ind IN VARCHAR2 ,
984: p_achievable_credit_points IN NUMBER ,
985: p_enrolled_credit_points IN NUMBER,
986: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE)
987: RETURN NUMBER AS
988: /*
989: | Who When What
990: |

Line 1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;

1003: DECLARE
1004: cst_completed CONSTANT VARCHAR2(12) := 'COMPLETED';
1005: cst_duplicate CONSTANT VARCHAR2(12) := 'DUPLICATE';
1006: cst_pass CONSTANT VARCHAR2(7) := 'PASS';
1007: v_override_achievable_cp IGS_EN_SU_ATTEMPT.override_achievable_cp%TYPE;
1008: v_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1009: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1010: v_achievable_credit_points IGS_PS_UNIT_VER.achievable_credit_points%TYPE;
1011: v_enrolled_credit_points IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

Line 1020: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,

1016: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1017: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
1019:
1020: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
1021: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1022: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1023: SELECT sua.version_number,
1024: sua.ci_end_dt,

Line 1021: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

1017: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
1019:
1020: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
1021: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1022: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1023: SELECT sua.version_number,
1024: sua.ci_end_dt,
1025: sua.unit_attempt_status,

Line 1022: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

1018: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
1019:
1020: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
1021: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1022: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1023: SELECT sua.version_number,
1024: sua.ci_end_dt,
1025: sua.unit_attempt_status,
1026: sua.location_cd,

Line 1028: FROM IGS_EN_SU_ATTEMPT sua

1024: sua.ci_end_dt,
1025: sua.unit_attempt_status,
1026: sua.location_cd,
1027: sua.unit_class
1028: FROM IGS_EN_SU_ATTEMPT sua
1029: WHERE sua.person_id = cp_person_id AND
1030: sua.course_cd = cp_course_cd AND
1031: sua.uoo_id = cp_uoo_id;
1032: v_sua_rec c_sua%ROWTYPE;

Line 1033: CURSOR c_sua1 (cp_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,

1029: WHERE sua.person_id = cp_person_id AND
1030: sua.course_cd = cp_course_cd AND
1031: sua.uoo_id = cp_uoo_id;
1032: v_sua_rec c_sua%ROWTYPE;
1033: CURSOR c_sua1 (cp_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
1034: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
1035: cp_unit_class igs_en_su_attempt.unit_class%TYPE) IS
1036: SELECT sua.cal_type,
1037: sua.ci_sequence_number,

Line 1034: cp_location_cd igs_en_su_attempt.location_cd%TYPE,

1030: sua.course_cd = cp_course_cd AND
1031: sua.uoo_id = cp_uoo_id;
1032: v_sua_rec c_sua%ROWTYPE;
1033: CURSOR c_sua1 (cp_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
1034: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
1035: cp_unit_class igs_en_su_attempt.unit_class%TYPE) IS
1036: SELECT sua.cal_type,
1037: sua.ci_sequence_number,
1038: sua.unit_attempt_status,

Line 1035: cp_unit_class igs_en_su_attempt.unit_class%TYPE) IS

1031: sua.uoo_id = cp_uoo_id;
1032: v_sua_rec c_sua%ROWTYPE;
1033: CURSOR c_sua1 (cp_ci_end_dt igs_en_su_attempt.ci_end_dt%TYPE,
1034: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
1035: cp_unit_class igs_en_su_attempt.unit_class%TYPE) IS
1036: SELECT sua.cal_type,
1037: sua.ci_sequence_number,
1038: sua.unit_attempt_status,
1039: sua.uoo_id

Line 1040: FROM IGS_EN_SU_ATTEMPT sua

1036: SELECT sua.cal_type,
1037: sua.ci_sequence_number,
1038: sua.unit_attempt_status,
1039: sua.uoo_id
1040: FROM IGS_EN_SU_ATTEMPT sua
1041: WHERE sua.person_id = p_person_id AND
1042: sua.course_cd = p_course_cd AND
1043: sua.unit_cd = p_unit_cd AND
1044: sua.location_cd = cp_location_cd AND