1 package FND_OAM_BF_UTIL AUTHID CURRENT_USER as
2 /* $Header: AFOAMFLS.pls 115.0 2003/10/31 03:58:43 ppradhan noship $ */
3
4 --
5 -- Name
6 -- refresh_metrics
7 --
8 -- Purpose
9 -- computes and rolls up metrics related to business flows such as
10 -- - count of open system alerts
11 -- - count of errored concurrent requests
12 -- - count of errored work items
13 --
14 -- The resulting values will get populated into fnd_oam_bf_comp_info,
15 -- fnd_oam_bf_wit_info and fnd_oam_bf_rollup_info tables.
16 --
17 -- Input Arguments
18 --
19 -- Output Arguments
20 --
21 -- Notes:
22 --
23 --
24 PROCEDURE refresh_metrics;
25
26 --
27 -- Updates the monitored flag for the given flow
28 -- Updates fnd_oam_bf_cust if record exists for given flow key
29 -- Otherwise, copies entry from fnd_oam_bf to
30 -- fnd_oam_bf_cust and updates the monitored_flag in
31 -- fnd_oam_bf_cust.
32 --
33 --
34 PROCEDURE update_bf_monitored_flag (
35 p_flow_key varchar2,
36 p_new_flag varchar2);
37
38 --
39 -- Updates the monitored flag for the given sub flow in context of the
40 -- given parent flow.
41 -- Updates fnd_oam_bf_assoc_cust if record exists for given parent
42 -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to
43 -- fnd_oam_bf_assoc_cust and updates the monitored_flag in
44 -- fnd_oam_bf_assoc_cust.
45 --
46 --
47 PROCEDURE update_bf_monitored_flag (
48 p_parent_flow_key varchar2,
49 p_child_flow_key varchar2,
50 p_new_flag varchar2);
51
52 --
53 -- Updates the monitored flag for the given component in context of the
54 -- given parent flow.
55 -- Updates fnd_oam_bf_comp_cust if record exists for given parent
56 -- and child. Otherwise, copies entry from fnd_oam_bf_comp to
57 -- fnd_oam_bf_comp_cust and updates the monitored_flag in
58 -- fnd_oam_bf_comp_cust.
59 --
60 --
61 PROCEDURE update_comp_monitored_flag (
62 p_parent_flow_key varchar2,
63 p_component_type varchar2,
64 p_component_appl_id number,
65 p_component_id number,
66 p_new_flag varchar2);
67
68 --
69 -- Updates the monitored flag for the given item type in context of the
70 -- given parent flow.
71 -- Updates fnd_oam_bf_wit_cust if record exists for given parent
72 -- and child. Otherwise, copies entry from fnd_oam_bf_wit to
73 -- fnd_oam_bf_wit_cust and updates the monitored_flag in
74 -- fnd_oam_bf_wit_cust.
75 --
76 --
77 PROCEDURE update_wit_monitored_flag (
78 p_parent_flow_key varchar2,
79 p_item_type varchar2,
80 p_new_flag varchar2);
81
82 end FND_OAM_BF_UTIL;