1 PACKAGE fnd_oam_dashboard_util AUTHID CURRENT_USER AS
2 /* $Header: AFOAMDUS.pls 115.4 2004/04/21 15:31:14 ppradhan noship $ */
3
4 -- Name
5 -- get_trans_name_values
6 --
7 -- Purpose
8 -- Gets the translated list of name values that will be used in the
9 -- system alert raised by the dashboard collection program.
10 --
11 -- Input Arguments
12 -- p_message_type - Value should be either 'MET' for message based on
13 -- threshold values
14 -- or 'STATUS' for metrics based on status values
15 -- p_name_val_codes:
16 -- If p_message_type is 'MET' then this should be a comma delimited
17 -- list of metric_short_name:metric_value
18 -- values. For example:
19 -- 'ACTIVE_USERS:300,DB_SESSIONS:404'
20 -- If p_message_type is 'STATUS' then this should be a comma delimited
21 -- list of application_id:concurrent_queue_id:status_code or
22 -- metric_short_name:statis_code values
23 --
24 -- For example:
25 -- '0:3042:2,0:10434:2,PHP_GEN:2'
26 --
27 -- Output Arguments
28 --
29 -- Returns
30 -- If p_message_type is 'MET' then returns the list of
31 -- translated metric display name and metric value
32 --
33 -- If p_message_type is 'STATUS' then returns the list of
34 -- translated service instance display name and status values.
35 --
36 -- For example:
37 -- MET: 'Active Users: 300;Database Sessions: 404;'
38 -- STATUS: 'Workflow Mailer: Down; Standard Manager: Down; PHP: Down'
39 -- Notes:
40 -- INTERNAL_USE_ONLY - This function is for use by the dashboard
41 -- collection program only.
42 --
43 FUNCTION get_trans_name_values (
44 p_message_type varchar2,
45 p_name_val_codes varchar2) RETURN varchar2;
46
47 PRAGMA RESTRICT_REFERENCES(get_trans_name_values, WNDS);
48
49
50 -- Name
51 -- load_svci_info
52 --
53 -- Purpose
54 -- Loads services instances related alerting, collection information
55 -- into fnd_oam_svci_info. For the given service instance if a row
56 -- already exists it updates the row; otherwise it inserts a new row.
57 --
58 -- Input Arguments
59 --
60 -- Output Arguments
61 --
62 -- Returns
63 --
64 -- Notes:
65 --
66 PROCEDURE load_svci_info(
67 p_application_id number,
68 p_concurrent_queue_name varchar2,
69 p_alert_enabled_flag varchar2,
70 p_collection_enabled_flag varchar2,
71 p_threshold_value varchar2,
72 p_owner varchar2);
73
74 -- Name
75 -- save_web_ping_timeout
76 --
77 -- Purpose
78 -- Saves the value for the new web ping timeout by simply updating
79 -- the profile option "OAM_DASHBOARD_WEB_PING_TIMEOUT"
80 --
81 -- Input Arguments
82 --
83 -- Output Arguments
84 --
85 -- Returns
86 --
87 -- Notes:
88 --
89 FUNCTION save_web_ping_timeout(p_new_val VARCHAR2) return number;
90
91 -- Name
92 -- format_time
93 --
94 -- Purpose
95 -- Formats the given number of seconds into 'HH:MM:SS' format.
96 -- e.g. 66 is converted to 00:01:06
97 --
98 -- Input Arguments
99 -- p_seconds - Time in seconds
100 --
101 -- Output Arguments
102 --
103 -- Returns
104 -- Formated String in 'HH:MM:SS' format
105 --
106 -- Notes:
107 --
108 FUNCTION format_time(p_seconds number) return varchar2;
109
110 -- Name
111 -- get_meaning
112 --
113 -- Purpose
114 -- Gets the meaning for the given lookup_type and comma seperated
115 -- look_up codes from the fnd_lookups table
116 --
117 -- Input Arguments
118 -- p_lookup_type - Look up type (String)
119 -- p_lookup_codes - Comma separated lookup codes with no space in between
120 -- them. for eg: '2,1,3,4' etc.
121 --
122 -- Output Arguments
123 --
124 -- Returns
125 -- Comma separated meanings corresponding to each code.
126 --
127 -- Notes:
128 --
129
130 FUNCTION get_meaning (p_lookup_type varchar2,
131 p_lookup_codes varchar2) RETURN varchar2;
132
133 END fnd_oam_dashboard_util;