DBA Data[Home] [Help]

APPS.RLM_UI_QUERIES_PKG dependencies on RLM_UI_QUERY_COLUMNS

Line 22: INSERT into RLM_UI_QUERY_COLUMNS(

18: INTO x_QUERY_ID
19: FROM dual;
20: END IF;
21: FOR v_counter in query_tab.FIRST..query_tab.LAST LOOP
22: INSERT into RLM_UI_QUERY_COLUMNS(
23: QUERY_ID
24: ,COLUMN_NAME
25: ,COLUMN_TYPE
26: ,COLUMN_VALUE

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

59:
60: procedure SELECT_ROW (x_query_id in out NOCOPY number,
61: query_tab OUT NOCOPY query_tab_type) is
62: v_index number := 0;
63: cursor c1 is select * from rlm_ui_query_columns where query_id = x_query_id;
64: begin
65: for c1_rec in c1 loop
66: query_tab(v_index).column_name :=c1_rec.column_name;
67: query_tab(v_index).column_type :=c1_rec.column_type;

Line 90: delete from rlm_ui_query_columns

86: end;
87:
88: procedure DELETE_ROW (x_query_id in out NOCOPY number) is
89: begin
90: delete from rlm_ui_query_columns
91: where query_id = x_query_id;
92: end;
93:
94: end RLM_UI_QUERIES_PKG ;