[Home] [Help]
PACKAGE: APPS.IEU_DIAGNOSTICS_PVT
Source
1 PACKAGE IEU_Diagnostics_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUVDFS.pls 115.11 2004/04/23 15:11:12 dolee ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- IEU_Diagnostics_PVT
8 -- Purpose
9 -- To provide easy to use apis for UQW Diagnostic Framework.
10 -- History
11 -- 14-Mar-2002 gpagadal Created.
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 -- ===============================================================
18 -- Start of Comments
19 -- ===============================================================
20 -- API Name
21 -- Is_ResourceId_Exist
22 -- Type
23 -- Private
24 -- Pre-Req
25 --
26 -- Parameters
27 --
28 -- IN
29 --
30 -- p_user_name IN VARCHAR2 Required
31 --
32 --
33 -- OUT
34 -- x_return_status OUT VARCHAR2
35 -- x_msg_count OUT NUMBER
36 -- x_msg_data OUT VARCHAR2
37 --
38 -- End of Comments
39 -- ===============================================================
40
41 PROCEDURE Is_ResourceId_Exist (x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_user_name IN VARCHAR2
45 );
46
47
48
49
50 -- ===============================================================
51 -- Start of Comments
52 -- ===============================================================
53 -- API Name
54 -- Check_User_Resp
55 -- Type
56 -- Private
57 -- Pre-Req
58 --
59 -- Parameters
60 --
61 -- IN
62 --
63 -- p_user_name IN VARCHAR2 Required
64 -- p_responsibility IN VARCHAR2 Required
65 --
66 --
67 -- OUT
68 -- x_return_status OUT VARCHAR2
69 -- x_msg_count OUT NUMBER
70 -- x_msg_data OUT VARCHAR2
71 -- x_user_id OUT NUMBER
72 -- x_resp_id OUT NUMBER
73 -- x_appl_id OUT NUMBER
74 --
75 -- End of Comments
76 -- ===============================================================
77
78
79 PROCEDURE Check_User_Resp (x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_user_name IN VARCHAR2,
83 p_responsibility IN VARCHAR2,
84 x_user_id OUT NOCOPY NUMBER,
85 x_resp_id OUT NOCOPY NUMBER,
86 x_appl_id OUT NOCOPY NUMBER
87 );
88
89 PROCEDURE Check_Object_Resp (x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_object_code IN VARCHAR2,
93 p_responsibility IN VARCHAR2,
94 x_resp_id OUT NOCOPY NUMBER
95 );
96
97 -- ===============================================================
98 -- Start of Comments
99 -- ===============================================================
100 -- API Name
101 -- Determine_Media_Enabled
102 -- Type
103 -- Private
104 -- Pre-Req
105 --
106 -- Parameters
107 --
108 -- IN
109 --
110 -- p_user_name IN VARCHAR2 Required
111 -- p_responsibility IN VARCHAR2 Required
112 --
113 --
114 -- OUT
115 -- x_return_status OUT VARCHAR2
116 -- x_media_types OUT IEU_DIAG_STRING_NST
117 -- x_msg_count OUT NUMBER
118 -- x_msg_data OUT VARCHAR2
119 --
120 -- End of Comments
121 -- ===============================================================
122
123
124 PROCEDURE Determine_Media_Enabled (x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_user_name IN VARCHAR2,
128 p_responsibility IN VARCHAR2,
129 x_media_types OUT NOCOPY IEU_DIAG_STRING_NST);
130
131
132
133 -- ===============================================================
134 -- Start of Comments
135 -- ===============================================================
136 -- API Name
137 -- Determine_Valid_Server
138 -- Type
139 -- Private
140 -- Pre-Req
141 --
142 -- Parameters
143 --
144 -- IN
145 --
146 -- p_user_name IN VARCHAR2 Required
147 -- p_responsibility IN VARCHAR2 Required
148 --
149 --
150 -- OUT
151 -- x_return_status OUT VARCHAR2
152 -- x_server_group OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 --
156 -- End of Comments
157 -- ===============================================================
158
159
160 PROCEDURE Determine_Valid_Server ( x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_user_name IN VARCHAR2,
164 p_responsibility IN VARCHAR2,
165 x_server_group OUT NOCOPY VARCHAR2,
166 x_medias OUT NOCOPY IEU_DIAG_STRING_NST);
167
168
169 -- ===============================================================
170 -- Start of Comments
171 -- ===============================================================
172 -- API Name
173 -- Get_Valid_Nodes
174 -- Type
175 -- Private
176 -- Pre-Req
177 --
178 -- Parameters
179 --
180 -- IN
181 --
182 -- p_user_name IN VARCHAR2 Required
183 -- p_responsibility IN VARCHAR2 Required
184 --
185 --
186 -- OUT
187 -- x_return_status OUT VARCHAR2
188 -- x_valid_nodes OUT IEU_DIAG_VNODE_NST
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2
191 --
192 -- End of Comments
193 -- ===============================================================
194
195
196 PROCEDURE Get_Valid_Nodes ( x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_user_name IN VARCHAR2,
200 p_responsibility IN VARCHAR2,
201 x_valid_nodes OUT NOCOPY IEU_DIAG_VNODE_NST);
202
203 -- ===============================================================
204 -- Start of Comments
205 -- ===============================================================
206 -- API Name
207 -- Check_Profile_Options
208 -- Type
209 -- Private
210 -- Pre-Req
211 --
212 -- Parameters
213 --
214 -- IN
215 --
216 -- p_user_name IN VARCHAR2 Required
217 -- p_responsibility IN VARCHAR2 Required
218 --
219 --
220 -- OUT
221 -- x_return_status OUT VARCHAR2
222 -- x_msg_count OUT NUMBER
223 -- x_msg_data OUT VARCHAR2
224 --
225 -- End of Comments
226 -- ===============================================================
227
228
229 PROCEDURE Check_Profile_Options( x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_user_name IN VARCHAR2,
233 p_responsibility IN VARCHAR2,
234 x_invalid_profile_options OUT NOCOPY IEU_DIAG_VNODE_NST);
235
236
237 -- ===============================================================
238 -- Start of Comments
239 -- ===============================================================
240 -- API Name
241 -- Check_Node_Enumeration
242 -- Type
243 -- Private
244 -- Pre-Req
245 --
246 -- Parameters
247 --
248 -- IN
249 --
250 -- p_user_name IN VARCHAR2 Required
251 -- p_responsibility IN VARCHAR2 Required
252 --
253 --
254 -- OUT
255 -- x_return_status OUT VARCHAR2
256 -- x_server_group OUT VARCHAR2
257 -- x_msg_count OUT NUMBER
258 -- x_msg_data OUT VARCHAR2
259 -- x_dupli_proc OUT IEU_DIAG_ENUM_NST
260 -- x_invalid_pkg OUT IEU_DIAG_ENUM_NST
261 -- x_invalid_proc OUT IEU_DIAG_ENUM_NST
262 -- x_enum_time OUT IEU_DIAG_ENUM_TIME_NST
263 -- End of Comments
264 -- ===============================================================
265
266 PROCEDURE Check_Node_Enumeration ( x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_user_name IN VARCHAR2,
270 p_responsibility IN VARCHAR2,
271 x_dupli_proc OUT NOCOPY IEU_DIAG_ENUM_NST,
272 x_invalid_pkg OUT NOCOPY IEU_DIAG_ENUM_NST,
273 x_invalid_proc OUT NOCOPY IEU_DIAG_ENUM_ERR_NST,
274 x_enum_time OUT NOCOPY IEU_DIAG_ENUM_TIME_NST,
275 x_user_ver_time OUT NOCOPY NUMBER,
276 x_etime_grand_total OUT NOCOPY NUMBER);
277
278
279
280 -- ===============================================================
281 -- Start of Comments
282 -- ===============================================================
283 -- API Name
284 -- Get_Valid_RT_Nodes
285 -- Type
286 -- Private
287 -- Pre-Req
288 --
289 -- Parameters
290 --
291 -- IN
292 --
293 -- p_user_name IN VARCHAR2 Required
294 -- p_responsibility IN VARCHAR2 Required
295 --
296 --
297 -- OUT
298 -- x_return_status OUT VARCHAR2
299 -- x_valid_nodes OUT IEU_DIAG_VNODE_NST
300 -- x_msg_count OUT NUMBER
301 -- x_msg_data OUT VARCHAR2
302 --
303 -- End of Comments
304 -- ===============================================================
305
306
307 PROCEDURE Get_Valid_RT_Nodes ( x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_user_name IN VARCHAR2,
311 p_responsibility IN VARCHAR2,
312 x_valid_nodes OUT NOCOPY IEU_DIAG_NODE_NST);
313
314 -- ===============================================================
315 -- Start of Comments
316 -- ===============================================================
317 -- API Name
318 -- Check_Refresh_Node_Counts
319 -- Type
320 -- Private
321 -- Pre-Req
322 --
323 -- Parameters
324 --
325 -- IN
326 --
327 -- p_user_name IN VARCHAR2 Required
328 -- p_responsibility IN VARCHAR2 Required
329 --
330 --
331 -- OUT
332 -- x_invalid_pkg OUT IEU_DIAG_REFRESH_NST
333 -- x_invalid_rproc OUT IEU_DIAG_REFRESH_ERR_NST
334 -- x_msg_count OUT NUMBER
335 -- x_msg_data OUT VARCHAR2
336 -- x_refresh_time OUT IEU_DIAG_REFRENUM_TIME_NST
337 -- End of Comments
338 -- ===============================================================
339
340
341 PROCEDURE Check_Refresh_Node_Counts ( x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_user_name IN VARCHAR2,
345 p_responsibility IN VARCHAR2,
346 x_invalid_pkg OUT NOCOPY IEU_DIAG_REFRESH_NST,
347 x_invalid_rproc OUT NOCOPY IEU_DIAG_REFRESH_ERR_NST,
348 x_refresh_time OUT NOCOPY IEU_DIAG_REFRENUM_TIME_NST,
349 x_user_ver_time OUT NOCOPY NUMBER,
350 x_etime_total OUT NOCOPY NUMBER,
351 x_rtime_total OUT NOCOPY NUMBER);
352
353
354
355 PROCEDURE Refresh_Node(p_node_id in number,
356 p_node_pid in number,
357 p_sel_enum_id in number,
358 p_where_clause in varchar2,
359 p_res_cat_enum_flag in varchar2,
360 p_refresh_view_name in varchar2,
361 p_refresh_view_sum_col in varchar2,
362 p_sel_rt_node_id in number,
363 p_count in number,
364 p_resource_id in number,
365 p_view_name in varchar2,
369
366 p_node_label in varchar2,
367 x_invalid_rproc OUT NOCOPY IEU_DIAG_REFRESH_ERR_NST
368 );
370
371 -- ===============================================================
372 -- Start of Comments
373 -- ===============================================================
374 -- API Name
375 -- Check_View
376 -- Type
377 -- Private
378 -- Pre-Req
379 --
380 -- Parameters
381 --
382 -- IN
383 --
384 -- p_user_name IN VARCHAR2 Required
385 -- p_responsibility IN VARCHAR2 Required
386 --
387 --
388 -- OUT
389 -- x_return_status OUT VARCHAR2
390 -- x_invalid_views OUT IEU_DIAG_STRING_NST
391 -- x_msg_count OUT NUMBER
392 -- x_msg_data OUT VARCHAR2
393
394 --
395 -- End of Comments
396 -- ===============================================================
397
398 PROCEDURE Check_View ( x_return_status OUT NOCOPY VARCHAR2,
399 x_msg_count OUT NOCOPY NUMBER,
400 x_msg_data OUT NOCOPY VARCHAR2,
401 p_user_name IN VARCHAR2,
402 p_responsibility IN VARCHAR2,
403 x_invalid_views OUT NOCOPY IEU_DIAG_STRING_NST);
404
405
406 --===================================================================
407 -- NAME
408 -- CHECK_TASK_LAUNCHING
409 --
410 -- PURPOSE
411 -- Private api to determine if the enabled tasks can be launched.
412 --
413 -- NOTES
414 -- 1. UWQ Login Diagnostics will use this procedure.
415 --
416 --
417 -- HISTORY
418 -- 10-April-2002 DOLEE Created
419
420 --===================================================================
421
422 PROCEDURE CHECK_TASK_LAUNCHING(x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_object_code IN VARCHAR2,
426 p_responsibility IN VARCHAR2,
427 p_task_source IN VARCHAR2,
428 x_problem_tasks OUT NOCOPY IEU_DIAG_STRING_NST,
429 x_log OUT NOCOPY IEU_DIAG_STRING_NST
430 );
431 PROCEDURE CHECK_OBJECT_FUNCTION(x_return_status OUT NOCOPY VARCHAR2,
432 x_msg_count OUT NOCOPY NUMBER,
433 x_msg_data OUT NOCOPY VARCHAR2,
434 p_object_code IN VARCHAR2,
435 p_task_source IN VARCHAR2,
436 x_problem_tasks IN OUT NOCOPY IEU_DIAG_STRING_NST,
437 x_log IN OUT NOCOPY IEU_DIAG_STRING_NST
441
438 );
439
440 END IEU_Diagnostics_PVT;