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

Line 87: cp_person_id igs_en_su_attempt.person_id%TYPE,

83: --
84: -- Cursor added to get the Student Unit Attempt uoo_id
85: --
86: CURSOR c_sua_uoo (
87: cp_person_id igs_en_su_attempt.person_id%TYPE,
88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

Line 88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

84: -- Cursor added to get the Student Unit Attempt uoo_id
85: --
86: CURSOR c_sua_uoo (
87: cp_person_id igs_en_su_attempt.person_id%TYPE,
88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,

Line 89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

85: --
86: CURSOR c_sua_uoo (
87: cp_person_id igs_en_su_attempt.person_id%TYPE,
88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE

Line 90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

86: CURSOR c_sua_uoo (
87: cp_person_id igs_en_su_attempt.person_id%TYPE,
88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE
94: ) IS

Line 91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

87: cp_person_id igs_en_su_attempt.person_id%TYPE,
88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE
94: ) IS
95: SELECT sua.uoo_id

Line 92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,

88: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE
94: ) IS
95: SELECT sua.uoo_id
96: FROM igs_en_su_attempt sua

Line 93: cp_unit_class igs_en_su_attempt.unit_class%TYPE

89: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
90: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
91: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE
94: ) IS
95: SELECT sua.uoo_id
96: FROM igs_en_su_attempt sua
97: WHERE sua.person_id = cp_person_id

Line 96: FROM igs_en_su_attempt sua

92: cp_location_cd igs_en_su_attempt.location_cd%TYPE,
93: cp_unit_class igs_en_su_attempt.unit_class%TYPE
94: ) IS
95: SELECT sua.uoo_id
96: FROM igs_en_su_attempt sua
97: WHERE sua.person_id = cp_person_id
98: AND sua.course_cd = cp_course_cd
99: AND sua.unit_cd = cp_unit_cd
100: AND sua.cal_type = cp_cal_type

Line 675: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

671: --
672: -- Get Student Unit Attempt details
673: --
674: CURSOR c_sua (
675: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
676: ) IS
677: SELECT sua.unit_attempt_status,
678: NVL (ugs.grading_schema_code, ungs.GRADING_SCHEMA_CODE),
679: NVL (ugs.grd_schm_version_number, ungs.GRD_SCHM_VERSION_NUMBER)

Line 680: FROM igs_en_su_attempt sua,

676: ) IS
677: SELECT sua.unit_attempt_status,
678: NVL (ugs.grading_schema_code, ungs.GRADING_SCHEMA_CODE),
679: NVL (ugs.grd_schm_version_number, ungs.GRD_SCHM_VERSION_NUMBER)
680: FROM igs_en_su_attempt sua,
681: --igs_ps_unit_ofr_opt uoo,
682: IGS_PS_UNIT_GRD_SCHM ungs,
683: igs_ps_usec_grd_schm ugs
684: WHERE sua.person_id = p_person_id

Line 697: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

693: --
694: -- Get saved or submitted grades
695: --
696: CURSOR c_suao (
697: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
698: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
699: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
700: ) IS
701: SELECT suao.mark,

Line 698: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

694: -- Get saved or submitted grades
695: --
696: CURSOR c_suao (
697: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
698: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
699: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
700: ) IS
701: SELECT suao.mark,
702: suao.grade,

Line 699: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

695: --
696: CURSOR c_suao (
697: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
698: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
699: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
700: ) IS
701: SELECT suao.mark,
702: suao.grade,
703: suao.finalised_outcome_ind