The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- Column variables for DBMS_SQL package for mapping to selected values from cursors
-- Unreleased lines -- Backordered lines
u_line_id BINARY_INTEGER; b_line_id BINARY_INTEGER;
PROCEDURE Insert_RL_Row(p_source IN VARCHAR2);
call_parameters.delete;
release_table.delete;
release_table.delete(current_line - 1);
release_table.delete(current_line - 1);
release_table.delete(current_line - 1);
Insert_RL_Row('u');
Insert_RL_Row('b');
Insert_RL_Row('b');
Insert_RL_Row('u');
Insert_RL_Row('u');
Insert_RL_Row('b');
Insert_RL_Row('u');
Insert_RL_Row('b');
Insert_RL_Row('b');
Insert_RL_Row('u');
PROCEDURE Insert_RL_Row(
p_source IN VARCHAR2
) IS
cs BINARY_INTEGER;
END Insert_RL_Row;
WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');
call_parameters.delete;
sync_table.delete;
-- Inserts the next line detail into sync_table
IF DBMS_SQL.Fetch_Rows(s_cursor) > 0 THEN
Map_Col_Value('s');
Insert_RL_Row('s');
sync_table.delete(current_sync_line - 1);
call_parameters.delete;
release_table.delete;
Insert_RL_Row('n');
release_table.delete(current_line - 1);