1 package BNE_RAW_QUERY_PKG AUTHID CURRENT_USER as
2 /* $Header: bnerawquerys.pls 120.2 2005/06/29 03:40:53 dvayro noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_APPLICATION_ID in NUMBER,
7 X_QUERY_CODE in VARCHAR2,
8 X_SEQUENCE_NUM in NUMBER,
9 X_OBJECT_VERSION_NUMBER in NUMBER,
10 X_QUERY in VARCHAR2,
11 X_CREATION_DATE in DATE,
12 X_CREATED_BY in NUMBER,
13 X_LAST_UPDATE_DATE in DATE,
14 X_LAST_UPDATED_BY in NUMBER,
15 X_LAST_UPDATE_LOGIN in NUMBER);
16
17 procedure LOCK_ROW (
18 X_APPLICATION_ID in NUMBER,
19 X_QUERY_CODE in VARCHAR2,
20 X_SEQUENCE_NUM in NUMBER,
21 X_OBJECT_VERSION_NUMBER in NUMBER,
22 X_QUERY in VARCHAR2
23 );
24
25 procedure UPDATE_ROW (
26 X_APPLICATION_ID in NUMBER,
27 X_QUERY_CODE in VARCHAR2,
28 X_SEQUENCE_NUM in NUMBER,
29 X_OBJECT_VERSION_NUMBER in NUMBER,
30 X_QUERY in VARCHAR2,
31 X_LAST_UPDATE_DATE in DATE,
32 X_LAST_UPDATED_BY in NUMBER,
33 X_LAST_UPDATE_LOGIN in NUMBER
34 );
35
36 procedure DELETE_ROW (
37 X_APPLICATION_ID in NUMBER,
38 X_QUERY_CODE in VARCHAR2,
39 X_SEQUENCE_NUM in NUMBER
40 );
41
42 procedure ADD_LANGUAGE;
43
44 procedure LOAD_ROW (
45 x_query_asn IN VARCHAR2,
46 x_query_code IN VARCHAR2,
47 x_sequence_num IN VARCHAR2,
48 x_object_version_number IN VARCHAR2,
49 x_query IN VARCHAR2,
50 x_owner IN VARCHAR2,
51 x_last_update_date IN VARCHAR2,
52 x_custom_mode IN VARCHAR2
53 );
54
55 end BNE_RAW_QUERY_PKG;