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_CA_INST

Line 140: -- percentage field held in the IGS_CA_INST_REL table for the

136: RETURN NUMBER AS
137: gv_other_detail VARCHAR2(255);
138: BEGIN -- resp_clc_load_eftsu
139: -- Calculate the maximum EFTSU applicable in a load calendar according to the
140: -- percentage field held in the IGS_CA_INST_REL table for the
141: -- relationship between the academic and load calendar instances.
142: DECLARE
143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;

Line 144: IGS_CA_INST_REL.load_research_percentage%TYPE;

140: -- percentage field held in the IGS_CA_INST_REL table for the
141: -- relationship between the academic and load calendar instances.
142: DECLARE
143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;
145: CURSOR c_cir IS
146: SELECT cir.load_research_percentage
147: FROM IGS_CA_INST_REL cir
148: WHERE sup_cal_type = p_acad_cal_type AND

Line 147: FROM IGS_CA_INST_REL cir

143: v_load_research_percentage
144: IGS_CA_INST_REL.load_research_percentage%TYPE;
145: CURSOR c_cir IS
146: SELECT cir.load_research_percentage
147: FROM IGS_CA_INST_REL cir
148: WHERE sup_cal_type = p_acad_cal_type AND
149: sup_ci_sequence_number = p_acad_ci_sequence_number AND
150: sub_cal_type = p_load_cal_type AND
151: sub_ci_sequence_number = p_load_ci_sequence_number;

Line 254: IGS_CA_INST ci,

250: acai.attendance_type
251: FROM
252: IGS_AD_PS_APPL_INST acai,
253: IGS_AD_APPL aa,
254: IGS_CA_INST ci,
255: IGS_AD_PS_APPL aca,
256: IGS_PS_VER crv
257: WHERE acai.person_id = p_person_id AND
258: acai.admission_appl_number = v_ca_acai_adm_appl_number AND

Line 534: IGS_CA_INST ci,

530: acai.attendance_type
531: FROM
532: IGS_AD_PS_APPL_INST acai,
533: IGS_AD_APPL aa,
534: IGS_CA_INST ci,
535: IGS_AD_PS_APPL aca,
536: IGS_PS_VER crv
537: WHERE acai.person_id = p_person_id AND
538: acai.admission_appl_number = v_ca_acai_adm_appl_number AND

Line 792: v_acad_cal_type IGS_CA_INST.cal_type%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;
796: v_message_name VARCHAR2(30);

Line 793: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%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;
796: v_message_name VARCHAR2(30);
797: v_credit_points NUMBER;

Line 794: v_acad_ci_start_dt IGS_CA_INST.start_dt%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;
796: v_message_name VARCHAR2(30);
797: v_credit_points NUMBER;
798: v_load_eftsu NUMBER;

Line 795: v_acad_ci_end_dt IGS_CA_INST.end_dt%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;
796: v_message_name VARCHAR2(30);
797: v_credit_points NUMBER;
798: v_load_eftsu NUMBER;
799: v_sua_eftd NUMBER;