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

Line 351: cp_person_id igs_en_su_attempt.person_id%TYPE,

347: v_message_name VARCHAR2 (30);
348: v_rowid_saved BOOLEAN := FALSE;
349: v_grade igs_as_su_stmptout_all.grade%TYPE;
350: CURSOR c_sua (
351: cp_person_id igs_en_su_attempt.person_id%TYPE,
352: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
354: ) IS
355: SELECT sua.*,

Line 352: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

348: v_rowid_saved BOOLEAN := FALSE;
349: v_grade igs_as_su_stmptout_all.grade%TYPE;
350: CURSOR c_sua (
351: cp_person_id igs_en_su_attempt.person_id%TYPE,
352: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
354: ) IS
355: SELECT sua.*,
356: sua.ROWID

Line 353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

349: v_grade igs_as_su_stmptout_all.grade%TYPE;
350: CURSOR c_sua (
351: cp_person_id igs_en_su_attempt.person_id%TYPE,
352: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
354: ) IS
355: SELECT sua.*,
356: sua.ROWID
357: FROM igs_en_su_attempt sua

Line 357: FROM igs_en_su_attempt sua

353: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
354: ) IS
355: SELECT sua.*,
356: sua.ROWID
357: FROM igs_en_su_attempt sua
358: WHERE sua.person_id = cp_person_id
359: AND sua.course_cd = cp_course_cd
360: AND sua.uoo_id = cp_uoo_id;
361: v_sua_rec c_sua%ROWTYPE;

Line 371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;

367: v_translated_grading_schema_cd igs_as_su_stmptout_all.translated_grading_schema_cd%TYPE;
368: v_translated_version_number igs_as_su_stmptout_all.translated_version_number%TYPE;
369: v_translated_grade igs_as_su_stmptout_all.translated_grade%TYPE;
370: v_translated_dt igs_as_su_stmptout_all.translated_dt%TYPE;
371: v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE;
372:
373: --
374: -- Check if there is a transfer for Unit
375: --

Line 387: FROM igs_en_su_attempt_all sua

383: WHERE sut1.person_id = cp_person_id
384: AND sut1.transfer_course_cd = cp_course_cd
385: AND sut1.uoo_id = cp_uoo_id
386: AND EXISTS ( SELECT 'X'
387: FROM igs_en_su_attempt_all sua
388: WHERE sua.person_id = sut1.person_id
389: AND sua.course_cd = sut1.transfer_course_cd
390: AND sua.uoo_id = sut1.uoo_id
391: AND sua.unit_attempt_status IN ('COMPLETED', 'DISCONTIN')

Line 393: FROM igs_en_su_attempt_all sua

389: AND sua.course_cd = sut1.transfer_course_cd
390: AND sua.uoo_id = sut1.uoo_id
391: AND sua.unit_attempt_status IN ('COMPLETED', 'DISCONTIN')
392: AND EXISTS (SELECT 'X'
393: FROM igs_en_su_attempt_all sua
394: WHERE sua.person_id = sut1.person_id
395: AND sua.course_cd = sut1.course_cd
396: AND sua.uoo_id = sut1.uoo_id
397: AND sua.unit_attempt_status = 'DUPLICATE'))

Line 692: ELSIF NOT igs_en_su_attempt_pkg.get_pk_for_validation (

688: OR (new_references.uoo_id IS NULL)
689: )
690: ) THEN
691: NULL;
692: ELSIF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
693: new_references.person_id,
694: new_references.course_cd,
695: new_references.uoo_id
696: ) THEN

Line 797: PROCEDURE get_fk_igs_en_su_attempt (x_person_id IN NUMBER, x_course_cd IN VARCHAR2, x_uoo_id IN NUMBER) AS

793: END IF;
794: CLOSE cur_rowid;
795: END get_fk_igs_lookups_view;
796:
797: PROCEDURE get_fk_igs_en_su_attempt (x_person_id IN NUMBER, x_course_cd IN VARCHAR2, x_uoo_id IN NUMBER) AS
798: CURSOR cur_rowid IS
799: SELECT ROWID
800: FROM igs_as_su_stmptout_all
801: WHERE person_id = x_person_id

Line 817: END get_fk_igs_en_su_attempt;

813: app_exception.raise_exception;
814: RETURN;
815: END IF;
816: CLOSE cur_rowid;
817: END get_fk_igs_en_su_attempt;
818:
819: PROCEDURE get_fk_igs_as_grd_sch_grade (x_grading_schema_cd IN VARCHAR2, x_version_number IN NUMBER, x_grade IN VARCHAR2) AS
820: CURSOR cur_rowid IS
821: SELECT ROWID

Line 908: FROM igs_en_su_attempt sua

904: x_show_on_academic_histry_flag IN VARCHAR2
905: ) AS
906: CURSOR c_sua_ass_ind IS
907: SELECT sua.no_assessment_ind
908: FROM igs_en_su_attempt sua
909: WHERE sua.person_id = x_person_id
910: AND sua.course_cd = x_course_cd
911: AND sua.uoo_id = x_uoo_id;
912: l_sua_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;

Line 912: l_sua_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;

908: FROM igs_en_su_attempt sua
909: WHERE sua.person_id = x_person_id
910: AND sua.course_cd = x_course_cd
911: AND sua.uoo_id = x_uoo_id;
912: l_sua_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
913: CURSOR c_gsg_result_type IS
914: SELECT gsg.s_result_type
915: FROM igs_as_grd_sch_grade gsg
916: WHERE gsg.grading_schema_cd = x_grading_schema_cd