[Home] [Help]
PACKAGE: APPS.BNE_STORED_SQL_PKG
Source
1 package BNE_STORED_SQL_PKG as
2 /* $Header: bnestsqls.pls 120.2 2005/06/29 03:41:07 dvayro noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_APPLICATION_ID in NUMBER,
7 X_CONTENT_CODE in VARCHAR2,
8 X_QUERY in VARCHAR2,
9 X_OBJECT_VERSION_NUMBER in NUMBER,
10 X_CREATION_DATE in DATE,
11 X_CREATED_BY in NUMBER,
12 X_LAST_UPDATE_DATE in DATE,
13 X_LAST_UPDATED_BY in NUMBER,
14 X_LAST_UPDATE_LOGIN in NUMBER,
15 X_QUERY_APP_ID in NUMBER,
16 X_QUERY_CODE in VARCHAR2);
17 procedure LOCK_ROW (
18 X_APPLICATION_ID in NUMBER,
19 X_CONTENT_CODE in VARCHAR2,
20 X_QUERY in VARCHAR2,
21 X_OBJECT_VERSION_NUMBER in NUMBER,
22 X_QUERY_APP_ID in NUMBER,
23 X_QUERY_CODE in VARCHAR2
24 );
25 procedure UPDATE_ROW (
26 X_APPLICATION_ID in NUMBER,
27 X_CONTENT_CODE in VARCHAR2,
28 X_QUERY in VARCHAR2,
29 X_OBJECT_VERSION_NUMBER in NUMBER,
30 X_LAST_UPDATE_DATE in DATE,
31 X_LAST_UPDATED_BY in NUMBER,
32 X_LAST_UPDATE_LOGIN in NUMBER,
33 X_QUERY_APP_ID in NUMBER,
34 X_QUERY_CODE in VARCHAR2
35 );
36 procedure DELETE_ROW (
37 X_APPLICATION_ID in NUMBER,
38 X_CONTENT_CODE in VARCHAR2
39 );
40 procedure ADD_LANGUAGE;
41 procedure LOAD_ROW(
42 x_content_asn in VARCHAR2,
43 x_content_code in VARCHAR2,
44 x_object_version_number in VARCHAR2,
45 x_query in VARCHAR2,
46 x_owner in VARCHAR2,
47 x_last_update_date in VARCHAR2,
48 x_custom_mode in VARCHAR2,
49 x_query_app_asn in VARCHAR2 DEFAULT NULL,
50 x_query_code in VARCHAR2 DEFAULT NULL
51 );
52
53 end BNE_STORED_SQL_PKG;