APPS.RLM_UI_QUERIES_PKG dependencies on RLM_UI_QUERIES

Line 1: package body RLM_UI_QUERIES_PKG as

1: package body RLM_UI_QUERIES_PKG as
2: /* $Header: RLMQRYB.pls 115.5 2002/11/09 02:02:21 rlanka ship $ */
3:
4:
5: procedure INSERT_ROW (

Line 12: CURSOR c1 is Select rowid from RLM_UI_QUERIES

8: query_tab IN query_tab_type
9:
10: ) is
11:
12: CURSOR c1 is Select rowid from RLM_UI_QUERIES
13: WHERE QUERY_ID = x_QUERY_ID ;
14: v_counter number;
15: BEGIN
16: IF (x_QUERY_ID is NULL) THEN

Line 17: SELECT RLM_UI_QUERIES_S.nextval

13: WHERE QUERY_ID = x_QUERY_ID ;
14: v_counter number;
15: BEGIN
16: IF (x_QUERY_ID is NULL) THEN
17: SELECT RLM_UI_QUERIES_S.nextval
18: INTO x_QUERY_ID
19: FROM dual;
20: END IF;
21: FOR v_counter in query_tab.FIRST..query_tab.LAST LOOP

Line 94: end RLM_UI_QUERIES_PKG ;

90: delete from rlm_ui_query_columns
91: where query_id = x_query_id;
92: end;
93:
94: end RLM_UI_QUERIES_PKG ;