APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_WIT_CUST

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 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 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 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 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