PACKAGE: APPS.QP_UI_QUERIES_PKG

Source

1 package QP_UI_QUERIES_PKG AS
2 /* $Header: QPXVUIQS.pls 120.0 2005/06/02 00:50:31 appldev 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_NAME in VARCHAR2,
9   X_CREATION_DATE in DATE,
10   X_CREATED_BY in NUMBER,
11   X_LAST_UPDATE_DATE in DATE,
12   X_LAST_UPDATED_BY in NUMBER,
13   X_LAST_UPDATE_LOGIN in NUMBER);
14 procedure LOCK_ROW (
15   X_QUERY_ID in NUMBER,
16   X_PUBLIC_FLAG in VARCHAR2 DEFAULT NULL,
17   X_NAME in VARCHAR2 DEFAULT NULL
18 );
19 procedure UPDATE_ROW (
20   X_QUERY_ID in NUMBER,
21   X_DELETE_FLAG in VARCHAR2,
22   X_PUBLIC_FLAG in VARCHAR2,
23   X_NAME in VARCHAR2,
24   X_LAST_UPDATE_DATE in DATE,
25   X_LAST_UPDATED_BY in NUMBER,
26   X_LAST_UPDATE_LOGIN in NUMBER
27 );
28 procedure DELETE_ROW (
29   X_QUERY_ID in NUMBER
30 );
31 TYPE UI_TREE_REC  IS RECORD
32   (
33    COLUMN_NAME     VARCHAR2(4000),
34    COLUMN_VALUE    VARCHAR2(4000),
35    COLUMN_TYPE     VARCHAR2(4000),
36    COLUMN_INDEX_ID NUMBER
37    );
38 
39 TYPE UI_TREE_TBL IS TABLE OF UI_TREE_REC
40 INDEX BY BINARY_INTEGER;
41 
42 G_MISS_UI_TREE_TBL UI_TREE_TBL;
43 
44 procedure INSERT_COLUMNS(
45   p_header_column_tbl IN UI_TREE_TBL,
46   p_query_id          IN Number
47 );
48 
49 procedure INSERT_ROW_COLUMNS(
50   p_column_name IN varchar2,
51   p_column_value  IN varchar2,
52   p_column_data_type   IN varchar2,
53   p_column_index_id   IN  number ,
54   p_query_id   IN  number
55 );
56 
57 procedure ADD_LANGUAGE;
58 
59 end QP_UI_QUERIES_PKG;