APPS.IGS_GE_GEN_003 dependencies on IGS_GE_S_LOG_ENTRY

Line 113: IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW(

109: -- system logging structure
110: SELECT IGS_GE_S_ERROR_LOG_SEQ_NUM_S.nextval INTO L_VAL
111: FROM DUAL;
112:
113: IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW(
114: x_rowid => l_rowid ,
115: x_s_log_type => p_s_log_type,
116: x_creation_dt => p_creation_dt,
117: x_sequence_number => L_VAL,

Line 223: -- This module is used to keep a count in the IGS_GE_S_LOG_ENTRY table.

219: p_total_count OUT NOCOPY NUMBER )
220: AS
221: gv_other_detail VARCHAR2(255);
222: BEGIN -- genp_set_sle_count
223: -- This module is used to keep a count in the IGS_GE_S_LOG_ENTRY table.
224: -- It will generally be called by batch routines that keep a count of
225: -- records processed up to the point of the routines last commit point.
226: -- If an exception is encountered at anytime, then the count will not be
227: -- compromised upto the point of last committing and can be used in exception

Line 236: FROM IGS_GE_S_LOG_ENTRY sle

232: v_update_log BOOLEAN := FALSE;
233: v_total_count NUMBER := 0;
234: CURSOR c_sle IS
235: SELECT rowid, SLE.*
236: FROM IGS_GE_S_LOG_ENTRY sle
237: WHERE sle.s_log_type = p_s_log_type AND
238: sle.creation_dt = p_creation_dt AND
239: sle.key = p_sle_key
240: FOR UPDATE OF sle.text NOWAIT;

Line 255: IGS_GE_S_LOG_ENTRY_pkg.update_row(

251: -- Determine if an entry exists already and update it, otherwise create it.
252: FOR v_sle_rec IN c_sle LOOP
253: -- v_total_count := TO_NUMBER(v_sle_rec.text) + p_count;
254:
255: IGS_GE_S_LOG_ENTRY_pkg.update_row(
256: X_ROWID => v_sle_rec.rowid,
257: X_S_LOG_TYPE => v_sle_rec.s_log_type ,
258: X_CREATION_DT => v_sle_rec.creation_dt ,
259: X_SEQUENCE_NUMBER =>v_sle_rec.sequence_number,