[Home] [Help]
PACKAGE: APPS.BIS_ALERT_SERVICE_PVT
Source
1 PACKAGE BIS_ALERT_SERVICE_PVT AS
2 /* $Header: BISVALRS.pls 120.1 2005/11/18 05:51:41 ankgoel noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVALRS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for Alert Services
13 REM |
14 REM | NOTES |
15 REM | |
16 REM | HISTORY |
17 REM | APR-2000 irchen Creation
18 REM | 15-Dec-2003 arhegde enh# 3148615 Change/Target based alerting. |
19 REM | 18-Nov-2005 ankgoel bug# 4675515 DBI Actuals for previous time period |
20 REM +=======================================================================+
21 */
22
23 -- Procedures
24 --
25 Procedure Service_Alert_Request
26 ( ERRBUF OUT NOCOPY VARCHAR2
27 , RETCODE OUT NOCOPY VARCHAR2
28 , p_measure_id IN NUMBER
29 , p_measure_short_name IN VARCHAR2
30 , p_plan_id IN NUMBER := NULL
31 , p_org_level_id IN NUMBER := NULL
32 , p_org_level_short_name IN VARCHAR2 := NULL
33 , p_organization_id IN VARCHAR2 := NULL
34 , p_time_level_id IN NUMBER := NULL
35 , p_time_level_short_name IN VARCHAR2 := NULL
36 , p_time_level_value_id IN VARCHAR2 := NULL
37 , p_dim1_level_id IN NUMBER := NULL
38 , p_dim1_level_short_name IN VARCHAR2 := NULL
39 , p_dim1_level_value_id IN VARCHAR2 := NULL
40 , p_dim2_level_id IN NUMBER := NULL
41 , p_dim2_level_short_name IN VARCHAR2 := NULL
42 , p_dim2_level_value_id IN VARCHAR2 := NULL
43 , p_dim3_level_id IN NUMBER := NULL
44 , p_dim3_level_short_name IN VARCHAR2 := NULL
45 , p_dim3_level_value_id IN VARCHAR2 := NULL
46 , p_dim4_level_id IN NUMBER := NULL
47 , p_dim4_level_short_name IN VARCHAR2 := NULL
48 , p_dim4_level_value_id IN VARCHAR2 := NULL
49 , p_dim5_level_id IN NUMBER := NULL
50 , p_dim5_level_short_name IN VARCHAR2 := NULL
51 , p_dim5_level_value_id IN VARCHAR2 := NULL
52 , p_dim6_level_id IN NUMBER := NULL
53 , p_dim6_level_short_name IN VARCHAR2 := NULL
54 , p_dim6_level_value_id IN VARCHAR2 := NULL
55 , p_dim7_level_id IN NUMBER := NULL
56 , p_dim7_level_short_name IN VARCHAR2 := NULL
57 , p_dim7_level_value_id IN VARCHAR2 := NULL
58 , p_primary_dim_level_id IN NUMBER := NULL
59 , p_primary_dim_level_short_name IN VARCHAR2 := NULL
60 , P_notify_set IN VARCHAR2 := NULL
61 , p_alert_type IN VARCHAR2 default NULL
62 , p_alert_level IN VARCHAR2 default NULL
63 , p_current_row IN VARCHAR2 := 'N'
64 , p_alert_based_on IN VARCHAR2 := BIS_CONCURRENT_MANAGER_PVT.C_ALERT_BASED_ON_TARGET
65 );
66
67 Procedure Service_Alert_Request_Pvt
68 ( ERRBUF OUT NOCOPY VARCHAR2
69 , RETCODE OUT NOCOPY VARCHAR2
70 , p_measure_id IN NUMBER := NULL
71 , p_measure_short_name IN VARCHAR2 := NULL
72 , p_target_level_id IN NUMBER
73 , p_target_level_short_name IN VARCHAR2
74 , p_plan_id IN NUMBER := NULL
75 , p_org_level_id IN NUMBER := NULL
76 , p_org_level_short_name IN VARCHAR2 := NULL
77 , p_organization_id IN VARCHAR2 := NULL
78 , p_time_level_id IN NUMBER := NULL
79 , p_time_level_short_name IN VARCHAR2 := NULL
80 , p_time_level_value_id IN VARCHAR2 := NULL
81 , p_dim1_level_id IN NUMBER := NULL
82 , p_dim1_level_short_name IN VARCHAR2 := NULL
83 , p_dim1_level_value_id IN VARCHAR2 := NULL
84 , p_dim2_level_id IN NUMBER := NULL
85 , p_dim2_level_short_name IN VARCHAR2 := NULL
86 , p_dim2_level_value_id IN VARCHAR2 := NULL
87 , p_dim3_level_id IN NUMBER := NULL
88 , p_dim3_level_short_name IN VARCHAR2 := NULL
89 , p_dim3_level_value_id IN VARCHAR2 := NULL
90 , p_dim4_level_id IN NUMBER := NULL
91 , p_dim4_level_short_name IN VARCHAR2 := NULL
92 , p_dim4_level_value_id IN VARCHAR2 := NULL
93 , p_dim5_level_id IN NUMBER := NULL
94 , p_dim5_level_short_name IN VARCHAR2 := NULL
95 , p_dim5_level_value_id IN VARCHAR2 := NULL
96 , p_dim6_level_id IN NUMBER := NULL
97 , p_dim6_level_short_name IN VARCHAR2 := NULL
98 , p_dim6_level_value_id IN VARCHAR2 := NULL
99 , p_dim7_level_id IN NUMBER := NULL
100 , p_dim7_level_short_name IN VARCHAR2 := NULL
101 , p_dim7_level_value_id IN VARCHAR2 := NULL
102 , p_target_id IN NUMBER := NULL
103 , p_target IN NUMBER := NULL
104 , p_actual_id IN NUMBER := NULL
105 , p_actual IN NUMBER := NULL
106 , p_primary_dim_level_id IN NUMBER := NULL
107 , p_primary_dim_level_short_name IN VARCHAR2 := NULL
108 , P_notify_set IN VARCHAR2 := NULL
109 , p_alert_type IN VARCHAR2 default NULL
110 , p_alert_level IN VARCHAR2 default NULL
111 , p_current_row IN VARCHAR2 := NULL
112 );
113
114 --
115 -- Data Types: Records
116 --
117 TYPE Alert_Request_Rec_Type IS RECORD
118 ( measure_id NUMBER
119 , measure_short_name VARCHAR2(240)
120 , target_level_id NUMBER
121 , target_level_short_name VARCHAR2(240)
122 , plan_id NUMBER
123 , org_level_id NUMBER
124 , org_level_short_name VARCHAR2(240)
125 , organization_id VARCHAR2(240)
126 , time_level_id NUMBER
127 , time_level_short_name VARCHAR2(240)
128 , time_level_value_id VARCHAR2(240)
129 , dim1_level_id NUMBER
130 , dim1_level_short_name VARCHAR2(240)
131 , dim1_level_value_id VARCHAR2(240)
132 , dim2_level_id NUMBER
133 , dim2_level_short_name VARCHAR2(240)
134 , dim2_level_value_id VARCHAR2(240)
135 , dim3_level_id NUMBER
136 , dim3_level_short_name VARCHAR2(240)
137 , dim3_level_value_id VARCHAR2(240)
138 , dim4_level_id NUMBER
139 , dim4_level_short_name VARCHAR2(240)
140 , dim4_level_value_id VARCHAR2(240)
141 , dim5_level_id NUMBER
142 , dim5_level_short_name VARCHAR2(240)
143 , dim5_level_value_id VARCHAR2(240)
144 , dim6_level_id NUMBER
145 , dim6_level_short_name VARCHAR2(240)
146 , dim6_level_value_id VARCHAR2(240)
147 , dim7_level_id NUMBER
148 , dim7_level_short_name VARCHAR2(240)
149 , dim7_level_value_id VARCHAR2(240)
150 , target_id NUMBER
151 , target NUMBER
152 , actual_id NUMBER
153 , actual NUMBER
154 , primary_dim_level_id NUMBER
155 , primary_dim_level_short_name VARCHAR2(240)
156 , notify_set VARCHAR2(240)
157 , alert_type VARCHAR2(32000)
158 , alert_level VARCHAR2(32000)
159 , alert_based_on VARCHAR2(32000)
160 , current_row VARCHAR2(10)
161 );
162
163 --
164 -- Data Types: Tables
165 --
166 TYPE Alert_Request_Tbl_Type IS TABLE OF Alert_Request_Rec_Type
167 INDEX BY BINARY_INTEGER;
168
169 Procedure Form_Alert_Request_rec
170 ( p_target_level_rec IN BIS_Target_level_PUB.Target_level_rec_Type
171 , p_target_rec IN BIS_Target_PUB.Target_rec_Type
172 , p_dimension_level_rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
173 , p_notify_set IN VARCHAR2 := NULL
174 , p_alert_type IN VARCHAR2 := NULL
175 , p_alert_level IN VARCHAR2 := NULL
176 , x_Alert_Request_rec OUT NOCOPY Alert_Request_rec_Type
177 );
178
179 Procedure Form_Concurrent_Request
180 ( p_Alert_Request_Tbl IN Alert_Request_Tbl_Type
181 , x_Concurrent_Request_Tbl
182 OUT NOCOPY BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type
183 );
184
185 END BIS_ALERT_SERVICE_PVT;