The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
x_query_id in out NOCOPY number,
x_rowid out NOCOPY rowid,
query_tab IN query_tab_type
) is
CURSOR c1 is Select rowid from RLM_UI_QUERIES
WHERE QUERY_ID = x_QUERY_ID ;
SELECT RLM_UI_QUERIES_S.nextval
INTO x_QUERY_ID
FROM dual;
INSERT into RLM_UI_QUERY_COLUMNS(
QUERY_ID
,COLUMN_NAME
,COLUMN_TYPE
,COLUMN_VALUE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
)
VALUES (
x_QUERY_ID
,query_tab(v_counter).column_name
,query_tab(v_counter).column_type
,query_tab(v_counter).column_value
,sysdate
,fnd_global.user_id
,sysdate
,fnd_global.user_id
,fnd_global.user_id
);
END INSERT_ROW;
procedure SELECT_ROW (x_query_id in out NOCOPY number,
query_tab OUT NOCOPY query_tab_type) is
v_index number := 0;
cursor c1 is select * from rlm_ui_query_columns where query_id = x_query_id;
end SELECT_ROW;
procedure UPDATE_ROW (x_query_id in out NOCOPY number,
query_tab IN query_tab_type) is
v_index number :=0;
DELETE_ROW(x_query_id);
insert_row(x_query_id,
v_rowid,
query_tab);
procedure DELETE_ROW (x_query_id in out NOCOPY number) is
begin
delete from rlm_ui_query_columns
where query_id = x_query_id;