[Home] [Help]
PACKAGE: APPS.BIS_CONCURRENT_MANAGER_PVT
Source
1 PACKAGE BIS_CONCURRENT_MANAGER_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVCONS.pls 115.19 2003/12/15 14:15:39 arhegde ship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVCONS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API for managing concurrent requests |
14 REM | |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | Jun-2000 irchen creation |
19 REM | 30-JAN-03 mdamle SONAR Conversion to Java (APIs called from Java) |
20 REM | 21-MAR-2003 sugopal It should not be able to schedule an alert again
21 REM | when it is running. Added condition to check for
22 REM | the same - bug#2834155
23 REM | 30-JAN-2003 rchandra refer the new concurrent program |
24 REM | BIS_ALERT_SERVICE_PVT_JAVA1 which takes in |
25 REM | parameters for dimension levels 6 and 7 |
26 REM | though it is being passed from BISVCONB.pls |
27 REM | 01-AUG-2003 rchandra refer the old concurrent program |
28 REM | BIS_ALERT_SERVICE_PVT_JAVA for bug 2891945 |
29 REM | 15-Dec-2003 arhegde enh# 3148615 Change/Target based alerting. |
30 REM +=======================================================================+
31 */
32
33 --
34 -- Constants
35 --
36
37 G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_CONCURRENT_MANAGER_PVT';
38
39 G_ALERT_PROGRAM CONSTANT VARCHAR2(100) := 'BIS_ALERT_SERVICE';
40 -- mdamle 01/20/2003 - SONAR Conversion to Java - APIs called from Java
41 G_ALERT_PROGRAM_PVT CONSTANT VARCHAR2(100) := 'BIS_ALERT_SERVICE_PVT_JAVA';
42
43 G_CONC_REQUEST_RUNNING CONSTANT VARCHAR2(30) := 'RUNNING';
44 G_CONC_REQUEST_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
45 G_CONC_REQUEST_SCHEDULED CONSTANT VARCHAR2(30) := 'SCHEDULED';
46 G_CONC_REQUEST_PENDING CONSTANT VARCHAR2(30) := 'PENDING';
47 G_CONC_REQUEST_NORMAL CONSTANT VARCHAR2(30) := 'NORMAL';
48 C_ALERT_BASED_ON_TARGET CONSTANT VARCHAR2(10) := '0';
49 C_ALERT_BASED_ON_CHANGE CONSTANT VARCHAR2(10) := '1';
50
51 TYPE PMF_Request_Rec_Type IS RECORD
52 ( application_short_name VARCHAR2(240)
53 , program VARCHAR2(240)
54 , description VARCHAR2(240)
55 , start_time VARCHAR2(240)
56 , argument1 NUMBER -- measure_id
57 , argument2 VARCHAR2(240) -- measure_short_name
58 , argument3 NUMBER -- target_level_id
59 , argument4 VARCHAR2(240) -- target_level_short_name
60 , argument5 NUMBER -- plan_id
61 , argument6 NUMBER -- org_level_id
62 , argument7 VARCHAR2(240) -- org_level_short_name
63 , argument8 VARCHAR2(240) -- organization_id
64 , argument9 NUMBER -- time_level_id
65 , argument10 VARCHAR2(240) -- time_level_short_name
66 , argument11 VARCHAR2(240) -- time_level_value_id
67 , argument12 NUMBER -- dim1_level_id
68 , argument13 VARCHAR2(240) -- dim1_level_short_name
69 , argument14 VARCHAR2(240) -- dim1_level_value_id
70 , argument15 NUMBER -- dim2_level_id
71 , argument16 VARCHAR2(240) -- dim2_level_short_name
72 , argument17 VARCHAR2(240) -- dim2_level_value_id
73 , argument18 NUMBER -- dim3_level_id
74 , argument19 VARCHAR2(240) -- dim3_level_short_name
75 , argument20 VARCHAR2(240) -- dim3_level_value_id
76 , argument21 NUMBER -- dim4_level_id
77 , argument22 VARCHAR2(240) -- dim4_level_short_name
78 , argument23 VARCHAR2(240) -- dim4_level_value_id
79 , argument24 NUMBER -- dim5_level_id
80 , argument25 VARCHAR2(240) -- dim5_level_short_name
81 , argument26 VARCHAR2(240) -- dim5_level_value_id
82 , argument27 NUMBER -- dim6_level_id
83 , argument28 VARCHAR2(240) -- dim6_level_short_name
84 , argument29 VARCHAR2(240) -- dim6_level_value_id
85 , argument30 NUMBER -- dim7_level_id
86 , argument31 VARCHAR2(240) -- dim7_level_short_name
87 , argument32 VARCHAR2(240) -- dim7_level_value_id
88 , argument33 NUMBER -- target_id
89 , argument34 NUMBER -- target
90 , argument35 NUMBER -- actual_id
91 , argument36 NUMBER -- actual
92 , argument37 NUMBER -- primary_dim_level_id
93 , argument38 VARCHAR2(240) -- primary_dim_level_short_name
94 , argument39 VARCHAR2(240) -- notify_set
95 , argument40 VARCHAR2(240) -- alert_type
96 , argument41 VARCHAR2(240) -- alert_level
97 , argument42 VARCHAR2(240) -- p_current_row
98 , argument43 VARCHAR2(240)
99 , argument44 VARCHAR2(240)
100 , argument45 VARCHAR2(240)
101 , argument46 VARCHAR2(240)
102 , argument47 VARCHAR2(240)
103 , argument48 VARCHAR2(240)
104 , argument49 VARCHAR2(240)
105 , argument50 VARCHAR2(240)
106 , argument51 VARCHAR2(240)
107 , argument52 VARCHAR2(240)
108 , argument53 VARCHAR2(240)
109 , argument54 VARCHAR2(240)
110 , argument55 VARCHAR2(240)
111 , argument56 VARCHAR2(240)
112 , argument57 VARCHAR2(240)
113 , argument58 VARCHAR2(240)
114 , argument59 VARCHAR2(240)
115 , argument60 VARCHAR2(240)
116 );
117
118 TYPE PMF_Request_Tbl_Type IS TABLE OF
119 PMF_Request_Rec_Type INDEX BY BINARY_INTEGER;
120
121 TYPE Fnd_Concurrent_Requests_Tbl IS TABLE OF Fnd_Concurrent_Requests%ROWTYPE
122 INDEX BY BINARY_INTEGER;
123
124 --
125 -- FUNCTIONS
126 --
127
128 FUNCTION Get_Freq_Display_Unit(p_freq_unit_code IN VARCHAR2) RETURN VARCHAR2;
129
130 --
131 -- PROCEDURES
132 --
133
134 --
135 -- Checks if request is scheduled to run again. If not, the request
136 -- is deleted from the Registration table and the ad hoc workflow role
137 -- is removed.
138 --
139 PROCEDURE Manage_Alert_Registrations
140 ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
141 , x_request_scheduled OUT NOCOPY VARCHAR2
142 , x_return_status OUT NOCOPY VARCHAR2
143 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
144 );
145
146 --
147 -- Submits the PMF concurrent requests
148 --
149 Procedure Submit_Concurrent_Request
150 ( p_Concurrent_Request_Tbl IN PMF_Request_Tbl_Type
151 , x_request_id_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
152 , x_errbuf OUT NOCOPY VARCHAR2
153 , x_retcode OUT NOCOPY VARCHAR2
154 );
155
156 Procedure Submit_Concurrent_Request
157 ( p_Concurrent_Request_rec IN PMF_Request_rec_Type
158 , x_request_id OUT NOCOPY VARCHAR2
159 , x_errbuf OUT NOCOPY VARCHAR2
160 , x_retcode OUT NOCOPY VARCHAR2
161 );
162
163 --
164 -- Retrieves the concurrent requests for this parameter set
165 --
166 PROCEDURE Get_All_Requests
167 ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
168 , x_Concurrent_Request_tbl OUT NOCOPY Fnd_Concurrent_Requests_Tbl
169 , x_return_status OUT NOCOPY VARCHAR2
170 );
171
172 --
173 -- Retrieves the scheduling information for this alert
174 --
175 Procedure Get_Request_Schedule_Info
176 ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
177 , x_schedule_date OUT NOCOPY VARCHAR2
178 , x_schedule_time OUT NOCOPY VARCHAR2
179 , x_schedule_unit OUT NOCOPY VARCHAR2
180 , x_schedule_freq OUT NOCOPY VARCHAR2
181 , x_schedule_freq_unit OUT NOCOPY VARCHAR2
182 , x_schedule_end_date OUT NOCOPY VARCHAR2
183 , x_schedule_end_time OUT NOCOPY VARCHAR2
184 , x_next_run_date OUT NOCOPY VARCHAR2
185 , x_next_run_time OUT NOCOPY VARCHAR2
186 , x_description OUT NOCOPY VARCHAR2
187 , x_return_status OUT NOCOPY VARCHAR2
188 );
189
190 Procedure Get_Request_Schedule_Info
191 ( p_measure_id IN VARCHAR2 := NULL
192 , p_target_level_id IN VARCHAR2 := NULL
193 , p_time_level_id IN VARCHAR2 := NULL
194 , p_plan_id IN VARCHAR2 := NULL
195 , p_parameter1_value IN VARCHAR2 := NULL
196 , p_parameter2_value IN VARCHAR2 := NULL
197 , p_parameter3_value IN VARCHAR2 := NULL
198 , p_parameter4_value IN VARCHAR2 := NULL
199 , p_parameter5_value IN VARCHAR2 := NULL
200 , p_parameter6_value IN VARCHAR2 := NULL
201 , p_parameter7_value IN VARCHAR2 := NULL
202 , x_schedule_date OUT NOCOPY VARCHAR2
203 , x_schedule_time OUT NOCOPY VARCHAR2
204 , x_schedule_unit OUT NOCOPY VARCHAR2
205 , x_schedule_freq OUT NOCOPY VARCHAR2
206 , x_schedule_freq_unit OUT NOCOPY VARCHAR2
207 , x_schedule_end_date OUT NOCOPY VARCHAR2
208 , x_schedule_end_time OUT NOCOPY VARCHAR2
209 , x_next_run_date OUT NOCOPY VARCHAR2
210 , x_next_run_time OUT NOCOPY VARCHAR2
211 , x_description OUT NOCOPY VARCHAR2
212 , x_return_status OUT NOCOPY VARCHAR2
213 );
214
215 Procedure Format_Schedule_Freq_Unit
216 ( p_schedule_unit IN VARCHAR2
217 , p_schedule_freq IN VARCHAR2
218 , x_schedule_freq_unit OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE Set_Repeat_Options
222 ( p_repeat_interval IN VARCHAR2
223 , p_repeat_units IN VARCHAR2
224 , P_Start_time IN VARCHAR2
225 , P_end_time IN VARCHAR2
226 , x_result OUT NOCOPY VARCHAR2
227 );
231 , x_Concurrent_Program_ID OUT NOCOPY NUMBER
228
229 Procedure Get_PMF_Concurrent_Program_ID
230 ( p_main_request_flag IN VARCHAR2 := FND_API.G_FALSE
232 , x_Application_ID OUT NOCOPY NUMBER
233 );
234
235
236 END BIS_CONCURRENT_MANAGER_PVT;