1 PACKAGE BNE_QUERY_UTILS AUTHID CURRENT_USER AS
2 /* $Header: bnequeryutilss.pls 120.2 2005/06/29 03:40:51 dvayro noship $ */
3
4 PROCEDURE CREATE_SIMPLE_QUERY
5 (P_APPLICATION_ID IN NUMBER,
6 P_QUERY_CODE IN VARCHAR2,
7 P_ID_COL IN VARCHAR2,
8 P_ID_COL_ALIAS IN VARCHAR2,
9 P_MEANING_COL IN VARCHAR2,
10 P_MEANING_COL_ALIAS IN VARCHAR2,
11 P_DESCRIPTION_COL IN VARCHAR2,
12 P_DESCRIPTION_COL_ALIAS IN VARCHAR2,
13 P_ADDITIONAL_COLS IN VARCHAR2,
14 P_OBJECT_NAME IN VARCHAR2,
15 P_ADDITIONAL_WHERE_CLAUSE IN VARCHAR2,
16 P_ORDER_BY_CLAUSE IN VARCHAR2,
17 P_USER_NAME IN VARCHAR2,
18 P_USER_ID IN NUMBER
19 );
20
21 PROCEDURE CREATE_RAW_QUERY
22 (P_APPLICATION_ID IN NUMBER,
23 P_QUERY_CODE IN VARCHAR2,
24 P_QUERY IN VARCHAR2,
25 P_USER_NAME IN VARCHAR2,
26 P_USER_ID IN NUMBER
27 );
28
29 PROCEDURE CREATE_JAVA_QUERY
30 (P_APPLICATION_ID IN NUMBER,
31 P_QUERY_CODE IN VARCHAR2,
32 P_QUERY_CLASS IN VARCHAR2,
33 P_USER_NAME IN VARCHAR2,
34 P_USER_ID IN NUMBER
35 );
36
37 PROCEDURE DELETE_QUERY
38 (P_APPLICATION_ID IN NUMBER,
39 P_QUERY_CODE IN VARCHAR2
40 );
41
42 END BNE_QUERY_UTILS;