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

Line 760: p_uoo_id igs_en_su_attempt.uoo_id%TYPE )

756: p_ci_sequence_number IN NUMBER ,
757: p_load_cal_type IN VARCHAR2 ,
758: p_load_ci_sequence_number IN NUMBER ,
759: p_truncate_ind IN VARCHAR2,
760: p_uoo_id igs_en_su_attempt.uoo_id%TYPE )
761: RETURN NUMBER AS
762: /*
763: | Who When What
764: | knaraset 09-May-03 modified function to add parameter uoo_id which is used in cursor c_sua, as part of MUS build bug 2829262

Line 787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;

783: DECLARE
784: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;

Line 788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

784: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
792: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

Line 789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
792: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
793: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;

786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
792: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
793: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
794: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

Line 791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;

787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;
791: v_sua_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
792: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
793: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
794: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
795: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

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

808: ca.sequence_number
809: FROM IGS_RE_CANDIDATURE ca
810: WHERE ca.person_id = p_person_id AND
811: NVL(ca.sca_course_cd, 'NULL') = NVL(p_course_cd, 'NULL');
812: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
813: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
814: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
815: SELECT sua.override_eftsu,
816: sua.cal_type,

Line 813: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

809: FROM IGS_RE_CANDIDATURE ca
810: WHERE ca.person_id = p_person_id AND
811: NVL(ca.sca_course_cd, 'NULL') = NVL(p_course_cd, 'NULL');
812: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
813: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
814: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
815: SELECT sua.override_eftsu,
816: sua.cal_type,
817: sua.ci_sequence_number,

Line 814: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

810: WHERE ca.person_id = p_person_id AND
811: NVL(ca.sca_course_cd, 'NULL') = NVL(p_course_cd, 'NULL');
812: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
813: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
814: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
815: SELECT sua.override_eftsu,
816: sua.cal_type,
817: sua.ci_sequence_number,
818: sua.uoo_id,

Line 820: FROM IGS_EN_SU_ATTEMPT sua,

816: sua.cal_type,
817: sua.ci_sequence_number,
818: sua.uoo_id,
819: sua.version_number
820: FROM IGS_EN_SU_ATTEMPT sua,
821: IGS_EN_STDNT_PS_ATT sca,
822: IGS_PS_UNIT_VER uv
823: WHERE sua.person_id = cp_person_id AND
824: sua.course_cd = cp_course_cd AND

Line 832: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

828: uv.unit_cd = sua.unit_cd AND
829: uv.version_number = sua.version_number AND
830: uv.research_unit_ind = 'Y';
831: CURSOR c_sgcc (
832: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
833: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
834: IS
835: SELECT NVL(
836: dai.absolute_val,

Line 833: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)

829: uv.version_number = sua.version_number AND
830: uv.research_unit_ind = 'Y';
831: CURSOR c_sgcc (
832: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
833: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
834: IS
835: SELECT NVL(
836: dai.absolute_val,
837: IGS_CA_GEN_001.calp_get_alias_val(