eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_COMP

Line 108: from fnd_oam_bf_comp_info

104: v_userid number := 0;
105: BEGIN
106: v_userid := get_user_id;
107: select 1 into v_x
108: from fnd_oam_bf_comp_info
109: where component_type = p_component_type
110: and component_appl_id = p_component_appl_id
111: and component_id = p_component_id;
112:

Line 114: update fnd_oam_bf_comp_info

110: and component_appl_id = p_component_appl_id
111: and component_id = p_component_id;
112:
113: -- update
114: update fnd_oam_bf_comp_info
115: set count_alerts = p_count_alerts,
116: count_errored_requests = p_count_errored_requests,
117: setup_status = p_setup_status,
118: test_status = p_test_status,

Line 131: insert into fnd_oam_bf_comp_info (

127: and component_appl_id = p_component_appl_id
128: and component_id = p_component_id;
129: EXCEPTION
130: when no_data_found then
131: insert into fnd_oam_bf_comp_info (
132: component_type,
133: component_appl_id,
134: component_id,
135: count_alerts,

Line 260: -- The resulting values will get populated into fnd_oam_bf_comp_info,

256: -- - count of running concurrent requests
257: -- - count of active form sessions
258: -- - count of active ssf sessions (last hour)
259: --
260: -- The resulting values will get populated into fnd_oam_bf_comp_info,
261: -- fnd_oam_bf_wit_info tables.
262: --
263: -- Input Arguments
264: --

Line 274: from fnd_oam_bf_comp

270: PROCEDURE compute_metrics
271: IS
272: cursor c_comps is
273: select distinct component_type, component_appl_id, component_id
274: from fnd_oam_bf_comp
275: union
276: select distinct component_type, component_appl_id, component_id
277: from fnd_oam_bf_comp_cust;
278: cursor c_wits is

Line 277: from fnd_oam_bf_comp_cust;

273: select distinct component_type, component_appl_id, component_id
274: from fnd_oam_bf_comp
275: union
276: select distinct component_type, component_appl_id, component_id
277: from fnd_oam_bf_comp_cust;
278: cursor c_wits is
279: select distinct item_type
280: from fnd_oam_bf_wit
281: union

Line 447: from fnd_oam_bf_comp c

443:
444: -- For all monitored components under this flow
445: cursor c_monitored_components is
446: select c.component_type, c.component_appl_id, c.component_id
447: from fnd_oam_bf_comp c
448: where c.biz_flow_key = p_flow_key
449: and ((c.monitored_flag='Y' and 1 not in (
450: select count(*)
451: from fnd_oam_bf_comp_cust cust

Line 451: from fnd_oam_bf_comp_cust cust

447: from fnd_oam_bf_comp c
448: where c.biz_flow_key = p_flow_key
449: and ((c.monitored_flag='Y' and 1 not in (
450: select count(*)
451: from fnd_oam_bf_comp_cust cust
452: where cust.component_type = c.component_type
453: and cust.component_appl_id = c.component_appl_id
454: and cust.component_id = c.component_id
455: and cust.biz_flow_key = c.biz_flow_key

Line 459: from fnd_oam_bf_comp_cust cust

455: and cust.biz_flow_key = c.biz_flow_key
456: and cust.monitored_flag='N'))
457: or (c.monitored_flag = 'N' and 1 in (
458: select count(*)
459: from fnd_oam_bf_comp_cust cust
460: where cust.component_type = c.component_type
461: and cust.component_appl_id = c.component_appl_id
462: and cust.component_id = c.component_id
463: and cust.biz_flow_key = c.biz_flow_key

Line 468: from fnd_oam_bf_comp_cust c

464: and cust.monitored_flag='Y'))
465: )
466: union
467: select c.component_type, c.component_appl_id, c.component_id
468: from fnd_oam_bf_comp_cust c
469: where c.biz_flow_key = p_flow_key
470: and c.monitored_flag = 'Y'
471: and c.component_type || ':' ||
472: c.component_appl_id || ':' ||

Line 477: from fnd_oam_bf_comp x

473: c.component_id not in
474: (select x.component_type || ':' ||
475: x.component_appl_id || ':' ||
476: x.component_id
477: from fnd_oam_bf_comp x
478: where x.biz_flow_key = p_flow_key);
479:
480: -- For all monitored work item types directly associated with this flow
481: cursor c_monitored_wit is

Line 521: from fnd_oam_bf_comp_info

517: nvl(count_running_requests,0), nvl(count_form_sessions,0),
518: nvl(count_ssf_sessions,0)
519: into v_temp_alerts, v_temp_err_req, v_temp_running_req,
520: v_temp_form_sessions, v_temp_ssf_sessions
521: from fnd_oam_bf_comp_info
522: where component_type = c.component_type
523: and component_appl_id = c.component_appl_id
524: and component_id = c.component_id;
525: v_count_alerts := v_count_alerts + v_temp_alerts;

Line 725: -- The resulting values will get populated into fnd_oam_bf_comp_info,

721: -- - count of open system alerts
722: -- - count of errored concurrent requests
723: -- - count of errored work items
724: --
725: -- The resulting values will get populated into fnd_oam_bf_comp_info,
726: -- fnd_oam_bf_wit_info and fnd_oam_bf_rollup_info tables.
727: --
728: -- Input Arguments
729: --

Line 890: -- Updates fnd_oam_bf_comp_cust if record exists for given parent

886:
887: --
888: -- Updates the monitored flag for the given component in context of the
889: -- given parent flow.
890: -- Updates fnd_oam_bf_comp_cust if record exists for given parent
891: -- and child. Otherwise, copies entry from fnd_oam_bf_comp to
892: -- fnd_oam_bf_comp_cust and updates the monitored_flag in
893: -- fnd_oam_bf_comp_cust.
894: --

Line 891: -- and child. Otherwise, copies entry from fnd_oam_bf_comp to

887: --
888: -- Updates the monitored flag for the given component in context of the
889: -- given parent flow.
890: -- Updates fnd_oam_bf_comp_cust if record exists for given parent
891: -- and child. Otherwise, copies entry from fnd_oam_bf_comp to
892: -- fnd_oam_bf_comp_cust and updates the monitored_flag in
893: -- fnd_oam_bf_comp_cust.
894: --
895: --

Line 892: -- fnd_oam_bf_comp_cust and updates the monitored_flag in

888: -- Updates the monitored flag for the given component in context of the
889: -- given parent flow.
890: -- Updates fnd_oam_bf_comp_cust if record exists for given parent
891: -- and child. Otherwise, copies entry from fnd_oam_bf_comp to
892: -- fnd_oam_bf_comp_cust and updates the monitored_flag in
893: -- fnd_oam_bf_comp_cust.
894: --
895: --
896: PROCEDURE update_comp_monitored_flag (

Line 893: -- fnd_oam_bf_comp_cust.

889: -- given parent flow.
890: -- Updates fnd_oam_bf_comp_cust if record exists for given parent
891: -- and child. Otherwise, copies entry from fnd_oam_bf_comp to
892: -- fnd_oam_bf_comp_cust and updates the monitored_flag in
893: -- fnd_oam_bf_comp_cust.
894: --
895: --
896: PROCEDURE update_comp_monitored_flag (
897: p_parent_flow_key varchar2,

Line 909: select 1 into v_cust_flag from fnd_oam_bf_comp_cust

905: v_base_monitored_flag varchar2(1);
906: BEGIN
907: v_userid := get_user_id;
908: begin
909: select 1 into v_cust_flag from fnd_oam_bf_comp_cust
910: where biz_flow_key = p_parent_flow_key
911: and component_type = p_component_type
912: and component_appl_id = p_component_appl_id
913: and component_id = p_component_id;

Line 921: -- from fnd_oam_bf_comp

917: end;
918:
919: if (v_cust_flag = 0) then
920: -- select monitored_flag into v_base_monitored_flag
921: -- from fnd_oam_bf_comp
922: -- where biz_flow_key = p_parent_flow_key
923: -- and component_type = p_component_type
924: -- and component_appl_id = p_component_appl_id
925: -- and component_id = p_component_id;

Line 929: -- insert into fnd_oam_bf_comp_cust(

925: -- and component_id = p_component_id;
926: --
927: -- if (v_base_monitored_flag <> p_new_flag) then
928: -- -- copy over record to cust table
929: -- insert into fnd_oam_bf_comp_cust(
930: -- biz_flow_key, component_type, component_appl_id, component_id,
931: -- monitored_flag,
932: -- created_by, creation_date, last_updated_by, last_update_date,
933: -- last_update_login)

Line 938: -- from fnd_oam_bf_comp

934: -- select biz_flow_key,component_type,component_appl_id, component_id,
935: -- monitored_flag,
936: -- created_by, creation_date, last_updated_by, last_update_date,
937: -- last_update_login
938: -- from fnd_oam_bf_comp
939: -- where biz_flow_key = p_parent_flow_key
940: -- and component_type = p_component_type
941: -- and component_appl_id = p_component_appl_id
942: -- and component_id = p_component_id;

Line 945: update fnd_oam_bf_comp set

941: -- and component_appl_id = p_component_appl_id
942: -- and component_id = p_component_id;
943: -- end if;
944: -- now update regular table
945: update fnd_oam_bf_comp set
946: monitored_flag = p_new_flag,
947: last_update_date = sysdate,
948: last_updated_by = v_userid
949: where biz_flow_key = p_parent_flow_key

Line 955: update fnd_oam_bf_comp_cust set

951: and component_appl_id = p_component_appl_id
952: and component_id = p_component_id;
953: else
954: -- now update cust table
955: update fnd_oam_bf_comp_cust set
956: monitored_flag = p_new_flag,
957: last_update_date = sysdate,
958: last_updated_by = v_userid
959: where biz_flow_key = p_parent_flow_key