1 package XDO_CONFIG_VALUES_PKG as
2 /* $Header: XDOCFGVS.pls 120.0 2005/09/01 20:26:17 bokim noship $ */
3
4 procedure INSERT_ROW (
5 P_VALUE_ID in NUMBER,
6 P_CONFIG_LEVEL in NUMBER,
7 P_APPLICATION_SHORT_NAME in VARCHAR2,
8 P_DATA_SOURCE_CODE in VARCHAR2,
9 P_TEMPLATE_CODE in VARCHAR2,
10 P_PROPERTY_CODE in VARCHAR2,
11 P_VALUE in VARCHAR2,
12 P_BVALUE in RAW,
13 P_CREATION_DATE in DATE,
14 P_CREATED_BY in NUMBER,
15 P_LAST_UPDATE_DATE in DATE,
16 P_LAST_UPDATED_BY in NUMBER,
17 P_LAST_UPDATE_LOGIN in NUMBER
18 );
19
20 procedure UPDATE_ROW (
21 P_CONFIG_LEVEL in NUMBER,
22 P_APPLICATION_SHORT_NAME in VARCHAR2,
23 P_DATA_SOURCE_CODE in VARCHAR2,
24 P_TEMPLATE_CODE in VARCHAR2,
25 P_PROPERTY_CODE in VARCHAR2,
26 P_VALUE in VARCHAR2,
27 P_BVALUE in RAW,
28 P_LAST_UPDATE_DATE in DATE,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_LOGIN in NUMBER
31 );
32
33 procedure DELETE_ROW (
34 P_CONFIG_LEVEL in NUMBER,
35 P_APPLICATION_SHORT_NAME in VARCHAR2,
36 P_DATA_SOURCE_CODE in VARCHAR2,
37 P_TEMPLATE_CODE in VARCHAR2,
38 P_PROPERTY_CODE in VARCHAR2
39 );
40
41 procedure LOAD_ROW (
42 P_CONFIG_LEVEL in NUMBER,
43 P_APPLICATION_SHORT_NAME in VARCHAR2,
44 P_DATA_SOURCE_CODE in VARCHAR2,
45 P_TEMPLATE_CODE in VARCHAR2,
46 P_PROPERTY_CODE in VARCHAR2,
47 P_VALUE in VARCHAR2,
48 P_LAST_UPDATE_DATE in DATE,
49 P_LAST_UPDATED_BY in NUMBER,
50 P_LAST_UPDATE_LOGIN in NUMBER
51 );
52
53 function GET_VALUE_ID (
54 P_CONFIG_LEVEL in NUMBER,
55 P_APPLICATION_SHORT_NAME in VARCHAR2,
56 P_DATA_SOURCE_CODE in VARCHAR2,
57 P_TEMPLATE_CODE in VARCHAR2,
58 P_PROPERTY_CODE in VARCHAR2
59 ) return number;
60
61 end XDO_CONFIG_VALUES_PKG;