1 PACKAGE CSM_AD_SIMPLE_SEARCH_VIEW_PKG as
2 /* $Header: csmlasss.pls 120.0 2008/01/25 19:16:54 trajasek noship $ */
3
4 PROCEDURE INSERT_ROW (
5 X_SEARCH_TYPE_ID IN NUMBER,
6 X_LEVEL_ID IN NUMBER,
7 X_LEVEL_VALUE IN NUMBER,
8 X_NAME IN VARCHAR2,
9 X_COLUMN_NAME IN VARCHAR2,
10 X_DISPLAY_SEQ IN NUMBER,
11 X_ORIGINAL_SEQ IN NUMBER,
12 X_GROUP_TYPE IN VARCHAR2,
13 X_IS_REMOVED IN VARCHAR2,
14 X_DB_TYPE IN VARCHAR2,
15 X_OPERATION IN VARCHAR2,
16 X_OWNER IN VARCHAR2
17 );
18
19 PROCEDURE UPDATE_ROW (
20 X_SEARCH_TYPE_ID IN NUMBER,
21 X_LEVEL_ID IN NUMBER,
22 X_LEVEL_VALUE IN NUMBER,
23 X_NAME IN VARCHAR2,
24 X_COLUMN_NAME IN VARCHAR2,
25 X_DISPLAY_SEQ IN NUMBER,
26 X_ORIGINAL_SEQ IN NUMBER,
27 X_GROUP_TYPE IN VARCHAR2,
28 X_IS_REMOVED IN VARCHAR2,
29 X_DB_TYPE IN VARCHAR2,
30 X_OPERATION IN VARCHAR2,
31 X_OWNER IN VARCHAR2
32 );
33
34 PROCEDURE LOAD_ROW (
35 X_ID IN NUMBER,
36 X_SEARCH_TYPE_ID IN NUMBER,
37 X_LEVEL_ID IN NUMBER,
38 X_LEVEL_VALUE IN NUMBER,
39 X_NAME IN VARCHAR2,
40 X_COLUMN_NAME IN VARCHAR2,
41 X_DISPLAY_SEQ IN NUMBER,
42 X_ORIGINAL_SEQ IN NUMBER,
43 X_GROUP_TYPE IN VARCHAR2,
44 X_IS_REMOVED IN VARCHAR2,
45 X_DB_TYPE IN VARCHAR2,
46 X_OPERATION IN VARCHAR2,
47 X_OWNER IN VARCHAR2
48 );
49
50 END CSM_AD_SIMPLE_SEARCH_VIEW_PKG;