APPS.IGS_GE_GEN_001 dependencies on IGS_GE_S_LOG_ENTRY

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 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;