1 package BSC_KPI_ANALYSIS_OPTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: BSCKAOPS.pls 115.7 2003/02/12 14:25:47 adrao ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_INDICATOR in NUMBER,
6 X_ANALYSIS_GROUP_ID in NUMBER,
7 X_OPTION_ID in NUMBER,
8 X_PARENT_OPTION_ID in NUMBER,
9 X_GRANDPARENT_OPTION_ID in NUMBER,
10 X_DIM_SET_ID in NUMBER,
11 X_USER_LEVEL0 in NUMBER,
12 X_USER_LEVEL1 in NUMBER,
13 X_USER_LEVEL1_DEFAULT in NUMBER,
14 X_USER_LEVEL2 in NUMBER,
15 X_USER_LEVEL2_DEFAULT in NUMBER,
16 X_NAME in VARCHAR2,
17 X_HELP in VARCHAR2);
18 procedure LOCK_ROW (
19 X_INDICATOR in NUMBER,
20 X_ANALYSIS_GROUP_ID in NUMBER,
21 X_OPTION_ID in NUMBER,
22 X_PARENT_OPTION_ID in NUMBER,
23 X_GRANDPARENT_OPTION_ID in NUMBER,
24 X_DIM_SET_ID in NUMBER,
25 X_USER_LEVEL0 in NUMBER,
26 X_USER_LEVEL1 in NUMBER,
27 X_USER_LEVEL1_DEFAULT in NUMBER,
28 X_USER_LEVEL2 in NUMBER,
29 X_USER_LEVEL2_DEFAULT in NUMBER,
30 X_NAME in VARCHAR2,
31 X_HELP in VARCHAR2
32 );
33 procedure UPDATE_ROW (
34 X_INDICATOR in NUMBER,
35 X_ANALYSIS_GROUP_ID in NUMBER,
36 X_OPTION_ID in NUMBER,
37 X_PARENT_OPTION_ID in NUMBER,
38 X_GRANDPARENT_OPTION_ID in NUMBER,
39 X_DIM_SET_ID in NUMBER,
40 X_USER_LEVEL0 in NUMBER,
41 X_USER_LEVEL1 in NUMBER,
42 X_USER_LEVEL1_DEFAULT in NUMBER,
43 X_USER_LEVEL2 in NUMBER,
44 X_USER_LEVEL2_DEFAULT in NUMBER,
45 X_NAME in VARCHAR2,
46 X_HELP in VARCHAR2
47 );
48 procedure DELETE_ROW (
49 X_INDICATOR in NUMBER,
50 X_ANALYSIS_GROUP_ID in NUMBER,
51 X_OPTION_ID in NUMBER,
52 X_PARENT_OPTION_ID in NUMBER,
53 X_GRANDPARENT_OPTION_ID in NUMBER
54 );
55 procedure ADD_LANGUAGE;
56 end BSC_KPI_ANALYSIS_OPTIONS_PKG;