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

Line 406: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

402: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
403: uft.FEE_TYPE = p_fee_type AND
404: uft.logical_delete_dt IS NULL;
405:
406: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
407:
408: cp_version_number
409: IGS_EN_SU_ATTEMPT.version_number%TYPE,
410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,

Line 409: IGS_EN_SU_ATTEMPT.version_number%TYPE,

405:
406: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
407:
408: cp_version_number
409: IGS_EN_SU_ATTEMPT.version_number%TYPE,
410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
411: cp_ci_sequence_number
412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

Line 410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,

406: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
407:
408: cp_version_number
409: IGS_EN_SU_ATTEMPT.version_number%TYPE,
410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
411: cp_ci_sequence_number
412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,

Line 412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

408: cp_version_number
409: IGS_EN_SU_ATTEMPT.version_number%TYPE,
410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
411: cp_ci_sequence_number
412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
415: cp_v_audit_only VARCHAR2) IS
416: SELECT 'X'

Line 413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

409: IGS_EN_SU_ATTEMPT.version_number%TYPE,
410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
411: cp_ci_sequence_number
412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
415: cp_v_audit_only VARCHAR2) IS
416: SELECT 'X'
417: FROM IGS_EN_SU_ATTEMPT sua,

Line 414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,

410: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
411: cp_ci_sequence_number
412: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
415: cp_v_audit_only VARCHAR2) IS
416: SELECT 'X'
417: FROM IGS_EN_SU_ATTEMPT sua,
418: IGS_LOOKUPS_view suas

Line 417: FROM IGS_EN_SU_ATTEMPT sua,

413: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
414: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
415: cp_v_audit_only VARCHAR2) IS
416: SELECT 'X'
417: FROM IGS_EN_SU_ATTEMPT sua,
418: IGS_LOOKUPS_view suas
419: WHERE sua.person_id = p_person_id AND
420: sua.course_cd = p_course_cd AND
421: ( sua.unit_cd = cp_unit_cd OR cp_unit_cd IS NULL) AND

Line 476: FROM igs_en_su_attempt sua,

472: -- Cursor to find out if the Student has atleast one auditable unit
473: CURSOR c_sua_audit_one (cp_person_id NUMBER,
474: cp_course_cd VARCHAR2) IS
475: SELECT 'X'
476: FROM igs_en_su_attempt sua,
477: igs_lookups_view suas
478: WHERE sua.person_id = p_person_id
479: AND sua.course_cd = p_course_cd
480: AND suas.lookup_type = g_v_sua_status

Line 555: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

551: usft.logical_delete_dt IS NULL AND
552: usft.unit_set_cd = us.unit_set_cd AND
553: usft.version_number = us.version_number;
554: CURSOR c_ftg_uft (
555: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
556: cp_version_number
557: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS
558: SELECT uft.unit_cd,
559: uft.version_number,

Line 557: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS

553: usft.version_number = us.version_number;
554: CURSOR c_ftg_uft (
555: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
556: cp_version_number
557: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS
558: SELECT uft.unit_cd,
559: uft.version_number,
560: uft.CAL_TYPE,
561: uft.ci_sequence_number,