1 PACKAGE fnd_oam_kbf AUTHID CURRENT_USER AS
2 /* $Header: AFOAMBFS.pls 120.3 2005/11/16 21:45:52 ppradhan noship $ */
3 -------------------------------------------------------------------------------
4 -- Common constants
5 -------------------------------------------------------------------------------
6
7
8 -------------------------------------------------------------------------------
9 -- Exceptions Related
10 -------------------------------------------------------------------------------
11
12 --
13 -- Name
14 -- get_sysal_cnt
15 --
16 -- Purpose
17 -- Returns the count of System Alerts across various severities and
18 -- acknowledged states by querying the fnd_log_unique_exceptions table.
19 --
20 -- Input Arguments
21 -- p_category - category for which to return the counts. Null by
22 -- by default.
23 -- Output Arguments
24 -- critical_n - count of new alerts which are of CRITICAL severity
25 -- error_n - count of new alerts which are of ERROR severity
26 -- warning_n - count of new alerts which are of WARNING severity
27 -- critical_o - count of open alerts which are of CRITICAL severity
28 -- error_o - count of open alerts which are of ERROR severity
29 -- warning_o - count of open alerts which are of WARNING severity
30 --
31 -- Notes:
32 --
33 --
34 PROCEDURE get_sysal_cnt
35 (critical_n OUT NOCOPY number,
36 error_n OUT NOCOPY number,
37 warning_n OUT NOCOPY number,
38 critical_o OUT NOCOPY number,
39 error_o OUT NOCOPY number,
40 warning_o OUT NOCOPY number,
41 p_category in varchar2 default null);
42
43 --
44 -- Name
45 -- get_occ_cnt
46 --
47 -- Purpose
48 -- Returns the count of Occurrances of alerts across various severities
49 -- and acknowledged states by querying
50 -- the fnd_log_exceptions table.
51 --
52 -- Input Arguments
53 -- p_category - category for which to return the counts. Null by
54 -- by default.
55 -- Output Arguments
56 -- critical_n - count of new occurrances which are of CRITICAL severity
57 -- error_n - count of new occurrances which are of ERROR severity
58 -- warning_n - count of new occurrances which are of WARNING severity
59 -- critical_o - count of open occurrances which are of CRITICAL severity
60 -- error_o - count of open occurrances which are of ERROR severity
61 -- warning_o - count of open occurrances which are of WARNING severity
62 --
63 -- Notes:
64 --
65 --
66 PROCEDURE get_occ_cnt
67 (critical_n OUT NOCOPY number,
68 error_n OUT NOCOPY number,
69 warning_n OUT NOCOPY number,
70 critical_o OUT NOCOPY number,
71 error_o OUT NOCOPY number,
72 warning_o OUT NOCOPY number,
73 p_category in varchar2 default null);
74
75
76 --
77 -- Name
78 -- change_state
79 --
80 -- Purpose
81 -- To change the state of a set of system alerts to 'O' - Open or 'C'
82 -- to close the alert. Newly generated alerts have the state 'N'. This
83 -- procedure will also insert a row into fnd_exception_notes to indicate
84 -- that the alert's state has been changed by the given user.
85 --
86 -- Input Arguments
87 -- p_logidset - a single logid or a set of ',' delimited log ids. e.g.
88 -- '1234' or '1234,1235,1236'
89 -- p_newstate - 'O' for Open or 'C' for Closed.
90 -- p_username - user name of the apps user who is changing the state.
91 --
92 -- Notes:
93 -- The purpose for this procedure is so that users can move the state
94 -- of system alerts from the OAM UI.
95 --
96 PROCEDURE change_state
97 (p_logidset IN varchar2,
98 p_newstate IN varchar2,
99 p_username IN varchar2);
100
101
102 -------------------------------------------------------------------------------
103 -- Metrics Related
104 -------------------------------------------------------------------------------
105
106
107 END fnd_oam_kbf;