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_WIT

Line 55: from fnd_oam_bf_wit_info

51: v_userid number := 0;
52: BEGIN
53: v_userid := get_user_id;
54: select 1 into v_x
55: from fnd_oam_bf_wit_info
56: where item_type = p_item_type;
57:
58: -- update
59: update fnd_oam_bf_wit_info

Line 59: update fnd_oam_bf_wit_info

55: from fnd_oam_bf_wit_info
56: where item_type = p_item_type;
57:
58: -- update
59: update fnd_oam_bf_wit_info
60: set count_errored_items = p_count_errored_items,
61: count_active_items = p_count_active_items,
62: last_updated_by = v_userid,
63: last_update_date = sysdate,

Line 68: insert into fnd_oam_bf_wit_info (

64: last_update_login = 0
65: where item_type = p_item_type;
66: EXCEPTION
67: when no_data_found then
68: insert into fnd_oam_bf_wit_info (
69: item_type,
70: count_errored_items,
71: count_active_items,
72: created_by,

Line 261: -- fnd_oam_bf_wit_info tables.

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: --
265: -- Output Arguments

Line 280: from fnd_oam_bf_wit

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
282: select distinct item_type
283: from fnd_oam_bf_wit_cust ;
284: BEGIN

Line 283: from fnd_oam_bf_wit_cust ;

279: select distinct item_type
280: from fnd_oam_bf_wit
281: union
282: select distinct item_type
283: from fnd_oam_bf_wit_cust ;
284: BEGIN
285: -- for each associated components count the
286: -- number of open and new system
287: -- alerts and errored concurrent requests

Line 482: select w.item_type from fnd_oam_bf_wit w

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
482: select w.item_type from fnd_oam_bf_wit w
483: where w.biz_flow_key = p_flow_key
484: and ((w.monitored_flag = 'Y' and 1 not in (
485: select count(*) from fnd_oam_bf_wit_cust cust
486: where cust.item_type = w.item_type

Line 485: select count(*) from fnd_oam_bf_wit_cust cust

481: cursor c_monitored_wit is
482: select w.item_type from fnd_oam_bf_wit w
483: where w.biz_flow_key = p_flow_key
484: and ((w.monitored_flag = 'Y' and 1 not in (
485: select count(*) from fnd_oam_bf_wit_cust cust
486: where cust.item_type = w.item_type
487: and cust.biz_flow_key = w.biz_flow_key
488: and cust.monitored_flag = 'N'))
489: or (w.monitored_flag = 'N' and 1 in (

Line 490: select count(*) from fnd_oam_bf_wit_cust cust

486: where cust.item_type = w.item_type
487: and cust.biz_flow_key = w.biz_flow_key
488: and cust.monitored_flag = 'N'))
489: or (w.monitored_flag = 'N' and 1 in (
490: select count(*) from fnd_oam_bf_wit_cust cust
491: where cust.item_type = w.item_type
492: and cust.biz_flow_key = w.biz_flow_key
493: and cust.monitored_flag = 'Y'))
494: )

Line 496: select w.item_type from fnd_oam_bf_wit_cust w

492: and cust.biz_flow_key = w.biz_flow_key
493: and cust.monitored_flag = 'Y'))
494: )
495: union
496: select w.item_type from fnd_oam_bf_wit_cust w
497: where w.biz_flow_key = p_flow_key
498: and w.monitored_flag = 'Y'
499: and w.item_type not in
500: (select x.item_type from fnd_oam_bf_wit x

Line 500: (select x.item_type from fnd_oam_bf_wit x

496: select w.item_type from fnd_oam_bf_wit_cust w
497: where w.biz_flow_key = p_flow_key
498: and w.monitored_flag = 'Y'
499: and w.item_type not in
500: (select x.item_type from fnd_oam_bf_wit x
501: where x.biz_flow_key = p_flow_key);
502:
503: BEGIN
504: if (g_debug) then

Line 547: from fnd_oam_bf_wit_info

543: v_temp_active_wi number := 0;
544: begin
545: select nvl(count_errored_items,0), nvl(count_active_items,0)
546: into v_temp_err_wi, v_temp_active_wi
547: from fnd_oam_bf_wit_info
548: where item_type = w.item_type;
549: v_count_err_wi := v_count_err_wi + v_temp_err_wi;
550: v_count_active_wi := v_count_active_wi + v_temp_active_wi;
551: end;

Line 726: -- fnd_oam_bf_wit_info and fnd_oam_bf_rollup_info tables.

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: --
730: -- Output Arguments

Line 988: select 1 into v_cust_flag from fnd_oam_bf_wit_cust

984: v_base_monitored_flag varchar2(1);
985: BEGIN
986: v_userid := get_user_id;
987: begin
988: select 1 into v_cust_flag from fnd_oam_bf_wit_cust
989: where biz_flow_key = p_parent_flow_key
990: and item_type = p_item_type;
991: exception
992: when no_data_found then

Line 998: -- from fnd_oam_bf_wit

994: end;
995:
996: if (v_cust_flag = 0) then
997: -- select monitored_flag into v_base_monitored_flag
998: -- from fnd_oam_bf_wit
999: -- where biz_flow_key = p_parent_flow_key
1000: -- and item_type = p_item_type;
1001: --
1002: -- if (v_base_monitored_flag <> p_new_flag) then

Line 1004: -- insert into fnd_oam_bf_wit_cust(

1000: -- and item_type = p_item_type;
1001: --
1002: -- if (v_base_monitored_flag <> p_new_flag) then
1003: -- -- copy over record to cust table
1004: -- insert into fnd_oam_bf_wit_cust(
1005: -- biz_flow_key, item_type, monitored_flag,
1006: -- created_by, creation_date, last_updated_by, last_update_date,
1007: -- last_update_login)
1008: -- select biz_flow_key, item_type, monitored_flag,

Line 1011: -- from fnd_oam_bf_wit

1007: -- last_update_login)
1008: -- select biz_flow_key, item_type, monitored_flag,
1009: -- created_by, creation_date, last_updated_by, last_update_date,
1010: -- last_update_login
1011: -- from fnd_oam_bf_wit
1012: -- where biz_flow_key = p_parent_flow_key
1013: -- and item_type = p_item_type;
1014: -- end if;
1015: -- now update fnd_oam_bf_assoc

Line 1016: update fnd_oam_bf_wit set

1012: -- where biz_flow_key = p_parent_flow_key
1013: -- and item_type = p_item_type;
1014: -- end if;
1015: -- now update fnd_oam_bf_assoc
1016: update fnd_oam_bf_wit set
1017: monitored_flag = p_new_flag,
1018: last_update_date = sysdate,
1019: last_updated_by = v_userid
1020: where biz_flow_key = p_parent_flow_key

Line 1024: update fnd_oam_bf_wit_cust set

1020: where biz_flow_key = p_parent_flow_key
1021: and item_type = p_item_type;
1022: else
1023: -- now update fnd_oam_bf_assoc_cust
1024: update fnd_oam_bf_wit_cust set
1025: monitored_flag = p_new_flag,
1026: last_update_date = sysdate,
1027: last_updated_by = v_userid
1028: where biz_flow_key = p_parent_flow_key