APPS.RLM_UI_QUERIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

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 ;

Line: 17

   SELECT  RLM_UI_QUERIES_S.nextval
   INTO  x_QUERY_ID
   FROM dual;

Line: 22

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

Line: 56

END INSERT_ROW;

Line: 60

procedure  SELECT_ROW (x_query_id in out NOCOPY  number,
		      query_tab  OUT NOCOPY query_tab_type) is
v_index number := 0;

Line: 63

cursor c1 is select * from rlm_ui_query_columns where query_id = x_query_id;

Line: 73

end SELECT_ROW;

Line: 77

procedure  UPDATE_ROW (x_query_id in out NOCOPY  number,
		      query_tab  IN query_tab_type) is
v_index number :=0;

Line: 82

DELETE_ROW(x_query_id);

Line: 83

insert_row(x_query_id,
	   v_rowid,
	   query_tab);

Line: 88

procedure DELETE_ROW (x_query_id in out NOCOPY  number) is
begin
delete from rlm_ui_query_columns
where query_id = x_query_id;