DBA Data[Home] [Help]

PACKAGE: APPS.BSC_KPI_DEFAULTS_PKG

Source


1 package BSC_KPI_DEFAULTS_PKG AUTHID CURRENT_USER as
2 /* $Header: BSCKPIDS.pls 115.7 2003/02/12 14:25:57 adrao ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_TAB_ID in NUMBER,
6   X_INDICATOR in NUMBER,
7   X_FORMAT_MASK in VARCHAR2,
8   X_COLOR_METHOD in NUMBER,
9   X_COLOR_LEVEL1 in NUMBER,
10   X_COLOR_LEVEL2 in NUMBER,
11   X_COLOR_LEVEL3 in NUMBER,
12   X_COLOR_LEVEL4 in NUMBER,
13   X_DIM_SET_ID in NUMBER,
14   X_DIM_LEVEL1_VALUE in NUMBER,
15   X_DIM_LEVEL2_VALUE in NUMBER,
16   X_DIM_LEVEL3_VALUE in NUMBER,
17   X_DIM_LEVEL4_VALUE in NUMBER,
18   X_DIM_LEVEL5_VALUE in NUMBER,
19   X_DIM_LEVEL6_VALUE in NUMBER,
20   X_DIM_LEVEL7_VALUE in NUMBER,
21   X_DIM_LEVEL8_VALUE in NUMBER,
22   X_ANALYSIS_OPTION0_NAME in VARCHAR2,
23   X_ANALYSIS_OPTION1_NAME in VARCHAR2,
24   X_ANALYSIS_OPTION2_NAME in VARCHAR2,
25   X_PERIOD_NAME in VARCHAR2,
26   X_SERIES_NAME in VARCHAR2,
27   X_DIM_LEVEL1_NAME in VARCHAR2,
28   X_DIM_LEVEL2_NAME in VARCHAR2,
29   X_DIM_LEVEL3_NAME in VARCHAR2,
30   X_DIM_LEVEL4_NAME in VARCHAR2,
31   X_DIM_LEVEL5_NAME in VARCHAR2,
32   X_DIM_LEVEL6_NAME in VARCHAR2,
33   X_DIM_LEVEL7_NAME in VARCHAR2,
34   X_DIM_LEVEL8_NAME in VARCHAR2,
35   X_DIM_LEVEL1_TEXT in VARCHAR2,
36   X_DIM_LEVEL2_TEXT in VARCHAR2,
37   X_DIM_LEVEL3_TEXT in VARCHAR2,
38   X_DIM_LEVEL4_TEXT in VARCHAR2,
39   X_DIM_LEVEL5_TEXT in VARCHAR2,
40   X_DIM_LEVEL6_TEXT in VARCHAR2,
41   X_DIM_LEVEL7_TEXT in VARCHAR2,
42   X_DIM_LEVEL8_TEXT in VARCHAR2);
43 procedure LOCK_ROW (
44   X_TAB_ID in NUMBER,
45   X_INDICATOR in NUMBER,
46   X_FORMAT_MASK in VARCHAR2,
47   X_COLOR_METHOD in NUMBER,
48   X_COLOR_LEVEL1 in NUMBER,
49   X_COLOR_LEVEL2 in NUMBER,
50   X_COLOR_LEVEL3 in NUMBER,
51   X_COLOR_LEVEL4 in NUMBER,
52   X_DIM_SET_ID in NUMBER,
53   X_DIM_LEVEL1_VALUE in NUMBER,
54   X_DIM_LEVEL2_VALUE in NUMBER,
55   X_DIM_LEVEL3_VALUE in NUMBER,
56   X_DIM_LEVEL4_VALUE in NUMBER,
57   X_DIM_LEVEL5_VALUE in NUMBER,
58   X_DIM_LEVEL6_VALUE in NUMBER,
59   X_DIM_LEVEL7_VALUE in NUMBER,
60   X_DIM_LEVEL8_VALUE in NUMBER,
61   X_ANALYSIS_OPTION0_NAME in VARCHAR2,
62   X_ANALYSIS_OPTION1_NAME in VARCHAR2,
63   X_ANALYSIS_OPTION2_NAME in VARCHAR2,
64   X_PERIOD_NAME in VARCHAR2,
65   X_SERIES_NAME in VARCHAR2,
66   X_DIM_LEVEL1_NAME in VARCHAR2,
67   X_DIM_LEVEL2_NAME in VARCHAR2,
68   X_DIM_LEVEL3_NAME in VARCHAR2,
69   X_DIM_LEVEL4_NAME in VARCHAR2,
70   X_DIM_LEVEL5_NAME in VARCHAR2,
71   X_DIM_LEVEL6_NAME in VARCHAR2,
72   X_DIM_LEVEL7_NAME in VARCHAR2,
73   X_DIM_LEVEL8_NAME in VARCHAR2,
74   X_DIM_LEVEL1_TEXT in VARCHAR2,
75   X_DIM_LEVEL2_TEXT in VARCHAR2,
76   X_DIM_LEVEL3_TEXT in VARCHAR2,
77   X_DIM_LEVEL4_TEXT in VARCHAR2,
78   X_DIM_LEVEL5_TEXT in VARCHAR2,
79   X_DIM_LEVEL6_TEXT in VARCHAR2,
80   X_DIM_LEVEL7_TEXT in VARCHAR2,
81   X_DIM_LEVEL8_TEXT in VARCHAR2
82 );
83 procedure UPDATE_ROW (
84   X_TAB_ID in NUMBER,
85   X_INDICATOR in NUMBER,
86   X_FORMAT_MASK in VARCHAR2,
87   X_COLOR_METHOD in NUMBER,
88   X_COLOR_LEVEL1 in NUMBER,
89   X_COLOR_LEVEL2 in NUMBER,
90   X_COLOR_LEVEL3 in NUMBER,
91   X_COLOR_LEVEL4 in NUMBER,
92   X_DIM_SET_ID in NUMBER,
93   X_DIM_LEVEL1_VALUE in NUMBER,
94   X_DIM_LEVEL2_VALUE in NUMBER,
95   X_DIM_LEVEL3_VALUE in NUMBER,
96   X_DIM_LEVEL4_VALUE in NUMBER,
97   X_DIM_LEVEL5_VALUE in NUMBER,
98   X_DIM_LEVEL6_VALUE in NUMBER,
99   X_DIM_LEVEL7_VALUE in NUMBER,
100   X_DIM_LEVEL8_VALUE in NUMBER,
101   X_ANALYSIS_OPTION0_NAME in VARCHAR2,
102   X_ANALYSIS_OPTION1_NAME in VARCHAR2,
103   X_ANALYSIS_OPTION2_NAME in VARCHAR2,
104   X_PERIOD_NAME in VARCHAR2,
105   X_SERIES_NAME in VARCHAR2,
106   X_DIM_LEVEL1_NAME in VARCHAR2,
107   X_DIM_LEVEL2_NAME in VARCHAR2,
108   X_DIM_LEVEL3_NAME in VARCHAR2,
109   X_DIM_LEVEL4_NAME in VARCHAR2,
110   X_DIM_LEVEL5_NAME in VARCHAR2,
111   X_DIM_LEVEL6_NAME in VARCHAR2,
112   X_DIM_LEVEL7_NAME in VARCHAR2,
113   X_DIM_LEVEL8_NAME in VARCHAR2,
114   X_DIM_LEVEL1_TEXT in VARCHAR2,
115   X_DIM_LEVEL2_TEXT in VARCHAR2,
116   X_DIM_LEVEL3_TEXT in VARCHAR2,
117   X_DIM_LEVEL4_TEXT in VARCHAR2,
118   X_DIM_LEVEL5_TEXT in VARCHAR2,
119   X_DIM_LEVEL6_TEXT in VARCHAR2,
120   X_DIM_LEVEL7_TEXT in VARCHAR2,
121   X_DIM_LEVEL8_TEXT in VARCHAR2
122 );
123 procedure DELETE_ROW (
124   X_TAB_ID in NUMBER,
125   X_INDICATOR in NUMBER
126 );
127 procedure ADD_LANGUAGE;
128 end BSC_KPI_DEFAULTS_PKG;