APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_COMP_CUST

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