1 package OE_UI_QUERIES_PKG AS
2 /* $Header: OEXVUIQS.pls 120.1 2005/09/06 14:44:43 jvicenti noship $ */
3 procedure INSERT_ROW (
4 X_QUERY_ID in NUMBER,
5 X_PUBLIC_FLAG in VARCHAR2,
6 X_LINES_WHERE_CLAUSE in VARCHAR2,
7 X_HEADERS_WHERE_CLAUSE in VARCHAR2,
8 X_ADV_HDR_WHERE_CLAUSE in VARCHAR2,
9 X_ADV_LIN_WHERE_CLAUSE in VARCHAR2,
10 X_HOLDS_WHERE_CLAUSE in VARCHAR2,
11 X_NAME in VARCHAR2,
12 X_CREATION_DATE in DATE,
13 X_CREATED_BY in NUMBER,
14 X_LAST_UPDATE_DATE in DATE,
15 X_LAST_UPDATED_BY in NUMBER,
16 X_LAST_UPDATE_LOGIN in NUMBER,
17 X_ORG_ACCESS_TYPE in VARCHAR2 default NULL,
18 X_ORG_ID in NUMBER default NULL);
19 procedure LOCK_ROW (
20 X_QUERY_ID in NUMBER,
21 X_PUBLIC_FLAG in VARCHAR2 DEFAULT NULL,
22 X_NAME in VARCHAR2 DEFAULT NULL
23 );
24 procedure UPDATE_ROW (
25 X_QUERY_ID in NUMBER,
26 X_DELETE_FLAG in VARCHAR2,
27 X_PUBLIC_FLAG in VARCHAR2,
28 X_NAME in VARCHAR2,
29 X_LAST_UPDATE_DATE in DATE,
30 X_LAST_UPDATED_BY in NUMBER,
31 X_LAST_UPDATE_LOGIN in NUMBER
32 );
33 procedure DELETE_ROW (
34 X_QUERY_ID in NUMBER
35 );
36 TYPE UI_TREE_REC IS RECORD
37 (
38 COLUMN_NAME VARCHAR2(4000),
39 COLUMN_VALUE VARCHAR2(4000),
40 COLUMN_TYPE VARCHAR2(4000),
41 COLUMN_INDEX_ID NUMBER
42 );
43
44 TYPE UI_TREE_TBL IS TABLE OF UI_TREE_REC
45 INDEX BY BINARY_INTEGER;
46
47 G_MISS_UI_TREE_TBL UI_TREE_TBL;
48
49 procedure INSERT_COLUMNS(
50 p_header_column_tbl IN UI_TREE_TBL,
51 p_query_id IN Number
52 );
53 procedure INSERT_ROW_COLUMNS(
54 p_column_name IN varchar2,
55 p_column_value IN varchar2,
56 p_column_data_type IN varchar2,
57 p_column_index_id IN number ,
58 p_query_id IN number
59 );
60 procedure ADD_LANGUAGE;
61 end OE_UI_QUERIES_PKG;