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_OR_INST_IMP_001 dependencies on IGS_LOOKUP_VALUES

Line 79: CURSOR c_lookup_type(cp_lookup_code igs_lookup_values.lookup_code%TYPE,

75: || (reverse chronological order - newest change first)
76: */
77: return boolean is
78:
79: CURSOR c_lookup_type(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
80: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
81: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
82: SELECT 'X'
83: FROM igs_lookup_values where

Line 80: cp_lookup_type igs_lookup_values.lookup_type%TYPE,

76: */
77: return boolean is
78:
79: CURSOR c_lookup_type(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
80: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
81: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
82: SELECT 'X'
83: FROM igs_lookup_values where
84: lookup_code = cp_lookup_code AND

Line 81: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS

77: return boolean is
78:
79: CURSOR c_lookup_type(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
80: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
81: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
82: SELECT 'X'
83: FROM igs_lookup_values where
84: lookup_code = cp_lookup_code AND
85: lookup_type = cp_lookup_type AND

Line 83: FROM igs_lookup_values where

79: CURSOR c_lookup_type(cp_lookup_code igs_lookup_values.lookup_code%TYPE,
80: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
81: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
82: SELECT 'X'
83: FROM igs_lookup_values where
84: lookup_code = cp_lookup_code AND
85: lookup_type = cp_lookup_type AND
86: enabled_flag = cp_enabled_flag;
87:

Line 2078: CURSOR inst_lookup_cur(cp_lookup_type IGS_LOOKUP_VALUES.LOOKUP_TYPE%TYPE) IS

2074: Change History
2075: Who When What
2076: ***************************************************************/
2077:
2078: CURSOR inst_lookup_cur(cp_lookup_type IGS_LOOKUP_VALUES.LOOKUP_TYPE%TYPE) IS
2079: SELECT lookup_code,meaning
2080: FROM IGS_LOOKUP_VALUES
2081: WHERE
2082: LOOKUP_TYPE = cp_lookup_type;

Line 2080: FROM IGS_LOOKUP_VALUES

2076: ***************************************************************/
2077:
2078: CURSOR inst_lookup_cur(cp_lookup_type IGS_LOOKUP_VALUES.LOOKUP_TYPE%TYPE) IS
2079: SELECT lookup_code,meaning
2080: FROM IGS_LOOKUP_VALUES
2081: WHERE
2082: LOOKUP_TYPE = cp_lookup_type;
2083:
2084: l_lookup_rec inst_lookup_cur%ROWTYPE;

Line 2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2082: LOOKUP_TYPE = cp_lookup_type;
2083:
2084: l_lookup_rec inst_lookup_cur%ROWTYPE;
2085:
2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2083:
2084: l_lookup_rec inst_lookup_cur%ROWTYPE;
2085:
2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2084: l_lookup_rec inst_lookup_cur%ROWTYPE;
2085:
2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2085:
2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2086: l_inst_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

Line 2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2087: l_inst_note_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2095:

Line 2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2088: l_inst_stat_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2095:
2096: -- Cursor for taking logging statistics, done after updating the status of IGS_OR_INST_INT

Line 2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2089: l_inst_stat_dtl_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2095:
2096: -- Cursor for taking logging statistics, done after updating the status of IGS_OR_INST_INT
2097: CURSOR log_inst_err_cur (cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE,cp_status_error IGS_OR_INST_INT.STATUS%TYPE,cp_status_warn IGS_OR_INST_INT.STATUS%TYPE) IS

Line 2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;

2090: l_inst_cont_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2091: l_inst_cont_phone_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2092: l_inst_addr_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2093: l_inst_addr_usage_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2094: l_inst_rec_err_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
2095:
2096: -- Cursor for taking logging statistics, done after updating the status of IGS_OR_INST_INT
2097: CURSOR log_inst_err_cur (cp_batch_id IGS_OR_INST_INT.BATCH_ID%TYPE,cp_status_error IGS_OR_INST_INT.STATUS%TYPE,cp_status_warn IGS_OR_INST_INT.STATUS%TYPE) IS
2098: SELECT RPAD(INTERFACE_ID,12) || ' ' || LPAD(STATUS,7) || ' ' || ERROR_CODE EREC