[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- insert them into the IGS_GE_S_LOG_ENTRY table. If it is possible that the
-- pl/sql table may be populated with differing IGS_GE_S_LOG_ENTRY types within
-- the same transaction, this module will check if the creation date
-- parameter is set and will use this. If the creation date parameter
-- is null, then it will create an IGS_GE_S_LOG record and the returned
-- creation date will be used. If no parent is found, due to differing
-- s_log_type, then the procedure will create the IGS_GE_S_LOG record using the
-- same creation date that has been used previously.
DECLARE
e_no_parent_rec_exception EXCEPTION;
-- Insert the IGS_GE_S_LOG record using the same creation date.
IGS_GE_S_LOG_PKG.INSERT_ROW(
x_rowid => l_rowid ,
x_s_log_type => r_log_entry.s_log_type,
x_creation_dt => p_creation_dt,
x_key =>r_log_entry.sl_key ,
x_mode => 'R' );
-- until they are required to be inserted into the IGS_GE_S_LOG_ENTRY table.
DECLARE
BEGIN
r_log_entry.s_log_type := p_s_log_type;