1 PACKAGE BODY CST_BIS_ALERT AS
2 /* $Header: CSTBIALB.pls 120.1 2005/10/04 17:58:41 julzhang noship $ */
3
4
5
6 FUNCTION GET_SEGMENT( str IN VARCHAR2,
7 delim IN VARCHAR2,
8 segment_num IN NUMBER ) RETURN VARCHAR2 IS
9 BEGIN
10 return 'null';
11 END Get_Segment;
12
13
14
15
16
17
18 /*
19 * Notify
20 * Spawns the Workflow process.
21 */
22
23 procedure Notify( p_measure_short_name in varchar2,
24 p_target_level_id in number,
25 notify_resp_short_name in varchar2,
26 p_plan_id in number,
27 time_level_value_id in varchar2,
28 org_level_value_id in varchar2,
29 dim1_level_value_id in varchar2,
30 dim2_level_value_id in varchar2,
31 dim3_level_value_id in varchar2,
32 target in number,
33 actual_value in number,
34 time_level in number,
35 org_level in number,
36 dim1_level in number,
37 dim2_level in number,
38 dim3_level in number,
39 target_min in number,
40 target_max in number )
41 is
42
43 begin
44
45 return;
46
47 end Notify;
48
49
50
51
52
53 /*
54 * PostActual
55 * Called by Alert_Check to post actuals to the BIS table.
56 * The posting is done by calling BIS API (BIS_ACTUAL_PUB).
57 */
58
59 PROCEDURE PostActual( target_level_id in number,
60 time_value in varchar2,
61 org_value in varchar2,
62 dim1_value in varchar2,
63 dim2_value in varchar2,
64 dim3_value in varchar2,
65 dim4_value in varchar2,
66 dim5_value in varchar2,
67 time_level in number,
68 org_level in number,
69 dim1_level in number,
70 dim2_level in number,
71 dim3_level in number,
72 dim4_level in number,
73 dim5_level in number,
74 actual in number ) IS
75 BEGIN
76
77 return;
78
79 END PostActual;
80
81
82
83 /*
84 * PostLevelActuals
85 * Will post all actuals for the given dim level combination.
86 * The dim level should be 0 for ALL, and increasing for
87 * finer levels.
88 * e.g.
89 * time_level = 0 : TOTAL_TIME
90 * time_level = 1 : YEAR
91 * time_level = 2 : QUARTER
92 * time_level = 3 : MONTH
93 */
94
95 PROCEDURE PostLevelActuals( p_measure_short_name in varchar2,
96 target_level_id in number,
97 time_level in number,
98 org_level in number,
99 dim1_level in number,
100 dim2_level in number,
101 dim3_level in number,
102 dim4_level in number,
103 dim5_level in number ) IS
104
105 BEGIN
106
107 return;
108
109 END PostLevelActuals;
110
111
112
113
114 procedure PostMeasureActuals( p_measure_short_name in varchar2 )
115 is
116 begin
117
118 return;
119
120 end PostMeasureActuals;
121
122
123
124
125 PROCEDURE CompareLevelTargets( p_measure_short_name in varchar2,
126 target_level_id in number,
127 time_level in number,
128 org_level in number,
129 dim1_level in number,
130 dim2_level in number,
131 dim3_level in number,
132 dim4_level in number,
133 dim5_level in number )
134 IS
135
136 begin
137
138 return;
139
140 end CompareLevelTargets;
141
142
143
144
145
146 procedure CompareMeasureTargets( p_measure_short_name in varchar2 )
147 is
148 begin
149
150 return;
151
152 end CompareMeasureTargets;
153
154
155
156
157
158 procedure Alert_Check( p_measure_short_name in varchar2 )
159 is
160 begin
161
162 return;
163
164 end Alert_Check;
165
166
167
168
169 END CST_BIS_ALERT;