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_EN_TRANSFER_APIS dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 2058: CURSOR c_get_earliest_load_cal_dtls(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.TEACH_CAL_TYPE%TYPE,

2054: SELECT cal_type,ci_sequence_number
2055: FROM IGS_PS_UNIT_OFR_OPT
2056: WHERE uoo_id = cp_uoo_id;
2057:
2058: CURSOR c_get_earliest_load_cal_dtls(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.TEACH_CAL_TYPE%TYPE,
2059: cp_teach_cal_seq_no IGS_CA_TEACH_TO_LOAD_V.TEACH_CI_SEQUENCE_NUMBER%TYPE) IS
2060:
2061: SELECT load_cal_type,load_ci_sequence_number
2062: FROM IGS_CA_TEACH_TO_LOAD_V

Line 2059: cp_teach_cal_seq_no IGS_CA_TEACH_TO_LOAD_V.TEACH_CI_SEQUENCE_NUMBER%TYPE) IS

2055: FROM IGS_PS_UNIT_OFR_OPT
2056: WHERE uoo_id = cp_uoo_id;
2057:
2058: CURSOR c_get_earliest_load_cal_dtls(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.TEACH_CAL_TYPE%TYPE,
2059: cp_teach_cal_seq_no IGS_CA_TEACH_TO_LOAD_V.TEACH_CI_SEQUENCE_NUMBER%TYPE) IS
2060:
2061: SELECT load_cal_type,load_ci_sequence_number
2062: FROM IGS_CA_TEACH_TO_LOAD_V
2063: WHERE teach_cal_type = cp_teach_cal_type AND

Line 2062: FROM IGS_CA_TEACH_TO_LOAD_V

2058: CURSOR c_get_earliest_load_cal_dtls(cp_teach_cal_type IGS_CA_TEACH_TO_LOAD_V.TEACH_CAL_TYPE%TYPE,
2059: cp_teach_cal_seq_no IGS_CA_TEACH_TO_LOAD_V.TEACH_CI_SEQUENCE_NUMBER%TYPE) IS
2060:
2061: SELECT load_cal_type,load_ci_sequence_number
2062: FROM IGS_CA_TEACH_TO_LOAD_V
2063: WHERE teach_cal_type = cp_teach_cal_type AND
2064: teach_ci_sequence_number = cp_teach_cal_seq_no
2065: ORDER BY LOAD_START_DT;
2066:

Line 2084: l_load_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;

2080: l_uooid NUMBER;
2081: l_uooids_str VARCHAR2(1000);
2082: l_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
2083: l_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
2084: l_load_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
2085: l_load_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
2086:
2087: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
2088: l_message_name1 VARCHAR2(4000);

Line 2085: l_load_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;

2081: l_uooids_str VARCHAR2(1000);
2082: l_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
2083: l_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
2084: l_load_cal_type IGS_CA_TEACH_TO_LOAD_V.LOAD_CAL_TYPE%TYPE;
2085: l_load_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.LOAD_CI_SEQUENCE_NUMBER%TYPE;
2086:
2087: l_enr_method igs_en_cat_prc_dtl.enr_method_type%TYPE;
2088: l_message_name1 VARCHAR2(4000);
2089: l_message_name2 VARCHAR2(4000);