[Home] [Help]
PACKAGE: APPS.FND_OAM_CPCHARTS_COL
Source
1 PACKAGE fnd_oam_cpcharts_col AUTHID CURRENT_USER AS
2 /* $Header: AFOAMCCS.pls 120.0 2005/11/18 15:37:02 appldev noship $ */
3
4 --
5 -- Name
6 -- insert_metric_internal
7 -- Purpose
8 -- This procedure is for internal use only!
9 -- This procedure will insert a row in fnd_oam_chart_metrics for the given
10 -- metric name.
11 --
12 -- Input Arguments
13 -- p_metric_name varchar2
14 -- p_context varchar2
15 -- p_value number
16 --
17 -- Output Arguments
18 --
19 -- Input/Output Arguments
20 --
21 -- Notes:
22 -- This is an internal convenience method only for OAM chart data collection
23 --
24 PROCEDURE insert_metric_internal (
25 p_metric_name in varchar2,
26 p_context in varchar2,
27 p_value in number);
28
29
30 -- Name
31 -- delete_metric_internal
32 -- Purpose
33 -- This procedure is for internal use only!
34 -- This procedure will delete the metric entry if it exists in fnd_oam_chart_metrics for the given
35 -- metric name.
36 --
37 -- Input Arguments
38 -- p_metric_name varchar2
39 --
40 -- Output Arguments
41 --
42 -- Input/Output Arguments
43 --
44 -- Notes:
45 -- This is an internal convenience method only for OAM chart data collection
46 --
47 PROCEDURE delete_metric_internal(
48 p_metric_name in varchar2);
49
50 -- Name
51 -- update_metric_internal
52 -- Purpose
53 -- This procedure is for internal use only!
54 -- This procedure will update a row in fnd_oam_chart_metrics for the given
55 -- metric name. If it does not exist, then insert.
56 --
57 -- Input Arguments
58 -- p_metric_name varchar2
59 -- p_context varchar2
60 -- p_value number
61 --
62 -- Output Arguments
63 --
64 -- Input/Output Arguments
65 --
66 -- Notes:
67 -- This is an internal convenience method only for OAM chart data collection
68 --
69
70 PROCEDURE update_metric_internal (
71 p_metric_name in varchar2,
72 p_context in varchar2,
73 p_value in number);
74
75 --
76 --
77 -- Name
78 -- refresh_req_status
79 --
80 -- Purpose
81 -- Computes the metric values for the all request status
82 --
83 PROCEDURE refresh_req_status;
84
85 -- Name
86 -- update_req_status_metric
87 --
88 -- Purpose
89 -- compute the metric value for one request status
90 --
91 PROCEDURE update_req_status_metric(p_metric_name in varchar2);
92
93 --
94 -- Name
95 -- refresh_completed_req_status
96 --
97 -- Purpose
98 -- Computes the metric values for the completed request status for the last hour
99 --
100 -- Input Arguments
101 --
102 -- Output Arguments
103 --
104 -- Notes:
105 --
106 --
107 PROCEDURE refresh_completed_req_status;
108
109 -- Name
110 -- refresh_pending_req_status
111 --
112 -- Purpose
113 -- Computes the metric values for the pending request status
114 --
115 -- Input Arguments
116 --
117 -- Output Arguments
118 --
119 -- Notes:
120 --
121 --
122 PROCEDURE refresh_pending_req_status;
123 -- Name
124 -- refresh_running_req_duration
125 --
126 -- Purpose
127 -- Computes the metric values for the running request duration
128 --
129 -- Input Arguments
130 --
131 -- Output Arguments
132 --
133 -- Notes:
134 --
135 --
136 PROCEDURE refresh_running_req_duration;
137 --
138 -- Name
139 -- refresh_running_req_user
140 --
141 -- Purpose
142 -- Computes the metric values for the running request grouped by user
143 --
144 -- Input Arguments
145 --
146 -- Output Arguments
147 --
148 -- Notes:
149 --
150 --
151 PROCEDURE refresh_running_req_user;
152 --
153 -- Name
154 -- refresh_pending_req_user
155 --
156 -- Purpose
157 -- Computes the metric values for the pending request grouped by user
158 --
159 --
160
161 PROCEDURE refresh_pending_req_user;
162 --
163 -- Name
164 -- refresh_running_req_app
165 --
166 -- Purpose
167 -- Computes the metric values for the running request grouped by application
168 --
169 -- Input Arguments
170 --
171 -- Output Arguments
172 --
173 -- Notes:
174 --
175 --
176 PROCEDURE refresh_running_req_app;
177 -- Name
178 -- refresh_pending_req_app
179 --
180 -- Purpose
181 -- Computes the metric values for the pending request grouped by application
182 --
183 --
184
185 PROCEDURE refresh_pending_req_app;
186
187 --
188 -- Name
189 -- refresh_running_req_resp
190 --
191 -- Purpose
192 -- Computes the metric values for the running request grouped by responsibility
193 --
194 -- Input Arguments
195 --
196 -- Output Arguments
197 --
198 -- Notes:
199 --
200 PROCEDURE refresh_running_req_resp;
201 -- Name
202 -- refresh_pending_req_resp
203 --
204 -- Purpose
205 -- Computes the metric values for the pending request grouped by responsibility
206 --
207 --
208
209 PROCEDURE refresh_pending_req_resp;
210
211 -- Name
212 -- update_run_req_mgr_metric
213 --
214 -- Purpose
215 -- compute the count of running requests for a specified manager
216 --
217 PROCEDURE update_run_req_mgr_metric(p_queue_application_id in number,
218 p_concurrent_queue_name in varchar2,
219 p_user_concurrent_queue_name in varchar2);
220 -- Name
221 -- update_pend_req_mgr_metric
222 --
223 -- Purpose
224 -- compute the count of pending requests for a specified manager
225 --
226 PROCEDURE update_pend_req_mgr_metric(p_queue_application_id in number,
227 p_concurrent_queue_name in varchar2,
228 p_user_concurrent_queue_name in varchar2);
229 -- Name
230 -- update_process_mgr_metric
231 --
232 -- Purpose
233 -- compute the count of process for a specified manager
234 --
235 PROCEDURE update_process_mgr_metric(p_queue_application_id in number,
236 p_concurrent_queue_name in varchar2,
237 p_user_concurrent_queue_name in varchar2);
238 -- Name
239 -- refresh_run_req_process_mgr
240 --
241 -- Purpose
242 -- refresh the count of running requests and processes for all managers
243 --
244 PROCEDURE refresh_run_req_process_mgr;
245 -- Name
246 -- refresh_pend_req_mgr
247 --
248 -- Purpose
249 -- refresh the count of pending requests for all managers
250 --
251 PROCEDURE refresh_pend_req_mgr;
252 -- Name
253 -- refresh_req_stats_user
254 --
255 -- Purpose
256 -- refresh the concurrent request statistics by user
257 --
258 PROCEDURE refresh_req_stats_user;
259
260 -- Name
261 -- refresh_req_stats_program
262 --
263 -- Purpose
264 -- refresh the concurrent request statistics by program
265 --
266 PROCEDURE refresh_req_stats_program;
267 -- Name
268 -- insert_stats_user
269 -- Purpose
270 -- This procedure is for internal use only!
271 -- This procedure will insert a row in fnd_oam_stats_user
272 --
273 -- Input Arguments
274 --
275 --
276 PROCEDURE insert_stats_user (
277 p_user_id in number,
278 p_stats_interval in varchar2,
279 p_comp_req_count in number,
280 p_total_runtime in number);
281 -- Name
282 -- insert_stats_program
283 -- Purpose
284 -- This procedure is for internal use only!
285 -- This procedure will insert a row in fnd_oam_stats_user
286 --
287 -- Input Arguments
288 --
289 --
290 PROCEDURE insert_stats_program (
291 p_app_id in number,
292 p_program_id in number,
293 p_stats_interval in varchar2,
294 p_total_runtime in number,
295 p_ave_tuntime in number,
296 p_min_tuntime in number,
297 p_max_tuntime in number,
298 p_times_run in number);
299
300 --
301 -- Name
302 -- refresh_all
303 --
304 -- Purpose
305 -- Computes the values for all chart metrics
306 --
307 -- Input Arguments
308 --
309 -- Output Arguments
310 -- errbuf - for any error message
311 -- retcode - 0 for success, 1 for success with warnings, 2 for error
312 --
313 -- Notes:
314 --
315 --
316 PROCEDURE refresh_all (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2);
317
318 --
319 -- Name
320 -- submit_req_conditional
321 --
322 -- Purpose
323 -- Submits a request for program 'OAMCHARTCOL' if and only if there are no
324 -- other requests for this program in the pending or running phase.
325 --
326 -- Input Arguments
327 --
328 -- Output Arguments
329 --
330 --
331 -- Notes:
332 --
333 --
334 PROCEDURE submit_req_conditional;
335
336
337 END fnd_oam_cpcharts_col;