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_GE_GEN_001 dependencies on IGS_GE_S_LOG

Line 186: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,

182: -- Remove s_log and s_log_entry records older than a specified number of days.
183: retcode:=0;
184: DECLARE
185: CURSOR c_sl (
186: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
187: cp_days_old_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
188: SELECT creation_dt , rowid
189: FROM IGS_GE_S_LOG
190: WHERE s_log_type = cp_s_log_type AND

Line 187: cp_days_old_dt IGS_GE_S_LOG.creation_dt%TYPE) IS

183: retcode:=0;
184: DECLARE
185: CURSOR c_sl (
186: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
187: cp_days_old_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
188: SELECT creation_dt , rowid
189: FROM IGS_GE_S_LOG
190: WHERE s_log_type = cp_s_log_type AND
191: creation_dt < cp_days_old_dt

Line 189: FROM IGS_GE_S_LOG

185: CURSOR c_sl (
186: cp_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
187: cp_days_old_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
188: SELECT creation_dt , rowid
189: FROM IGS_GE_S_LOG
190: WHERE s_log_type = cp_s_log_type AND
191: creation_dt < cp_days_old_dt
192: FOR UPDATE of s_log_type NOWAIT;
193: CURSOR c_sle (

Line 194: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,

190: WHERE s_log_type = cp_s_log_type AND
191: creation_dt < cp_days_old_dt
192: FOR UPDATE of s_log_type NOWAIT;
193: CURSOR c_sle (
194: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
195: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
196: SELECT creation_dt , rowid
197: FROM IGS_GE_S_LOG_ENTRY
198: WHERE s_log_type = cp_s_log_type AND

Line 195: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS

191: creation_dt < cp_days_old_dt
192: FOR UPDATE of s_log_type NOWAIT;
193: CURSOR c_sle (
194: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
195: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
196: SELECT creation_dt , rowid
197: FROM IGS_GE_S_LOG_ENTRY
198: WHERE s_log_type = cp_s_log_type AND
199: creation_dt = cp_creation_dt

Line 197: FROM IGS_GE_S_LOG_ENTRY

193: CURSOR c_sle (
194: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
195: cp_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) IS
196: SELECT creation_dt , rowid
197: FROM IGS_GE_S_LOG_ENTRY
198: WHERE s_log_type = cp_s_log_type AND
199: creation_dt = cp_creation_dt
200: FOR UPDATE of s_log_type NOWAIT;
201: v_record_found BOOLEAN := FALSE;

Line 215: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(x_rowid => v_sle_rec.rowid) ;

211: FOR v_sle_rec IN c_sle(
212: p_s_log_type,
213: v_sl_rec.creation_dt)
214: LOOP
215: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(x_rowid => v_sle_rec.rowid) ;
216: END LOOP;
217: -- Remove the current log record
218: IGS_GE_S_LOG_PKG.DELETE_ROW(x_rowid => v_sl_rec.rowid);
219: END LOOP;

Line 218: IGS_GE_S_LOG_PKG.DELETE_ROW(x_rowid => v_sl_rec.rowid);

214: LOOP
215: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(x_rowid => v_sle_rec.rowid) ;
216: END LOOP;
217: -- Remove the current log record
218: IGS_GE_S_LOG_PKG.DELETE_ROW(x_rowid => v_sl_rec.rowid);
219: END LOOP;
220: EXCEPTION
221: WHEN e_resource_busy_exception THEN
222: RETCODE := 2 ;