APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_ASSOC

Line 421: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc ba

417: v_count_active_wi number := 0;
418:
419: -- For all monitored flows under this flow
420: cursor c_monitored_flows is
421: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc ba
422: where ba.biz_flow_parent_key = p_flow_key
423: and ((ba.monitored_flag='Y' and 1 not in (
424: select count(*)
425: from fnd_oam_bf_assoc_cust cust

Line 425: from fnd_oam_bf_assoc_cust cust

421: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc ba
422: where ba.biz_flow_parent_key = p_flow_key
423: and ((ba.monitored_flag='Y' and 1 not in (
424: select count(*)
425: from fnd_oam_bf_assoc_cust cust
426: where cust.biz_flow_child_key = ba.biz_flow_child_key
427: and cust.biz_flow_parent_key = ba.biz_flow_parent_key
428: and cust.monitored_flag = 'N'))
429: or (ba.monitored_flag='N' and 1 in (

Line 431: from fnd_oam_bf_assoc_cust cust

427: and cust.biz_flow_parent_key = ba.biz_flow_parent_key
428: and cust.monitored_flag = 'N'))
429: or (ba.monitored_flag='N' and 1 in (
430: select count(*)
431: from fnd_oam_bf_assoc_cust cust
432: where cust.biz_flow_child_key = ba.biz_flow_child_key
433: and cust.biz_flow_parent_key = ba.biz_flow_parent_key
434: and cust.monitored_flag='Y'))
435: )

Line 437: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc_cust ba

433: and cust.biz_flow_parent_key = ba.biz_flow_parent_key
434: and cust.monitored_flag='Y'))
435: )
436: union
437: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc_cust ba
438: where ba.biz_flow_parent_key = p_flow_key
439: and ba.monitored_flag = 'Y'
440: and ba.biz_flow_child_key not in
441: (select x.biz_flow_child_key from fnd_oam_bf_assoc x

Line 441: (select x.biz_flow_child_key from fnd_oam_bf_assoc x

437: select ba.biz_flow_child_key biz_flow_key from fnd_oam_bf_assoc_cust ba
438: where ba.biz_flow_parent_key = p_flow_key
439: and ba.monitored_flag = 'Y'
440: and ba.biz_flow_child_key not in
441: (select x.biz_flow_child_key from fnd_oam_bf_assoc x
442: where x.biz_flow_parent_key = p_flow_key);
443:
444: -- For all monitored components under this flow
445: cursor c_monitored_components is

Line 821: -- Updates fnd_oam_bf_assoc_cust if record exists for given parent

817:
818: --
819: -- Updates the monitored flag for the given sub flow in context of the
820: -- given parent flow.
821: -- Updates fnd_oam_bf_assoc_cust if record exists for given parent
822: -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to
823: -- fnd_oam_bf_assoc_cust and updates the monitored_flag in
824: -- fnd_oam_bf_assoc_cust.
825: --

Line 822: -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to

818: --
819: -- Updates the monitored flag for the given sub flow in context of the
820: -- given parent flow.
821: -- Updates fnd_oam_bf_assoc_cust if record exists for given parent
822: -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to
823: -- fnd_oam_bf_assoc_cust and updates the monitored_flag in
824: -- fnd_oam_bf_assoc_cust.
825: --
826: --

Line 823: -- fnd_oam_bf_assoc_cust and updates the monitored_flag in

819: -- Updates the monitored flag for the given sub flow in context of the
820: -- given parent flow.
821: -- Updates fnd_oam_bf_assoc_cust if record exists for given parent
822: -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to
823: -- fnd_oam_bf_assoc_cust and updates the monitored_flag in
824: -- fnd_oam_bf_assoc_cust.
825: --
826: --
827: PROCEDURE update_bf_monitored_flag (

Line 824: -- fnd_oam_bf_assoc_cust.

820: -- given parent flow.
821: -- Updates fnd_oam_bf_assoc_cust if record exists for given parent
822: -- and child. Otherwise, copies entry from fnd_oam_bf_assoc to
823: -- fnd_oam_bf_assoc_cust and updates the monitored_flag in
824: -- fnd_oam_bf_assoc_cust.
825: --
826: --
827: PROCEDURE update_bf_monitored_flag (
828: p_parent_flow_key varchar2,

Line 838: select 1 into v_cust_flag from fnd_oam_bf_assoc_cust

834: v_base_monitored_flag varchar2(1);
835: BEGIN
836: v_userid := get_user_id;
837: begin
838: select 1 into v_cust_flag from fnd_oam_bf_assoc_cust
839: where biz_flow_parent_key = p_parent_flow_key
840: and biz_flow_child_key = p_child_flow_key;
841: exception
842: when no_data_found then

Line 848: -- from fnd_oam_bf_assoc

844: end;
845:
846: if (v_cust_flag = 0) then
847: -- select monitored_flag into v_base_monitored_flag
848: -- from fnd_oam_bf_assoc
849: -- where biz_flow_parent_key = p_parent_flow_key
850: -- and biz_flow_child_key = p_child_flow_key;
851: --
852: -- if (v_base_monitored_flag <> p_new_flag) then

Line 854: -- insert into fnd_oam_bf_assoc_cust(

850: -- and biz_flow_child_key = p_child_flow_key;
851: --
852: -- if (v_base_monitored_flag <> p_new_flag) then
853: -- -- copy over record to cust table
854: -- insert into fnd_oam_bf_assoc_cust(
855: -- biz_flow_parent_key, biz_flow_child_key, monitored_flag,
856: -- created_by, creation_date, last_updated_by, last_update_date,
857: -- last_update_login)
858: -- select biz_flow_parent_key, biz_flow_child_key, monitored_flag,

Line 861: -- from fnd_oam_bf_assoc

857: -- last_update_login)
858: -- select biz_flow_parent_key, biz_flow_child_key, monitored_flag,
859: -- created_by, creation_date, last_updated_by, last_update_date,
860: -- last_update_login
861: -- from fnd_oam_bf_assoc
862: -- where biz_flow_parent_key = p_parent_flow_key
863: -- and biz_flow_child_key = p_child_flow_key;
864: -- end if;
865: -- now update fnd_oam_bf_assoc

Line 865: -- now update fnd_oam_bf_assoc

861: -- from fnd_oam_bf_assoc
862: -- where biz_flow_parent_key = p_parent_flow_key
863: -- and biz_flow_child_key = p_child_flow_key;
864: -- end if;
865: -- now update fnd_oam_bf_assoc
866: update fnd_oam_bf_assoc set
867: monitored_flag = p_new_flag,
868: last_update_date = sysdate,
869: last_updated_by = v_userid

Line 866: update fnd_oam_bf_assoc set

862: -- where biz_flow_parent_key = p_parent_flow_key
863: -- and biz_flow_child_key = p_child_flow_key;
864: -- end if;
865: -- now update fnd_oam_bf_assoc
866: update fnd_oam_bf_assoc set
867: monitored_flag = p_new_flag,
868: last_update_date = sysdate,
869: last_updated_by = v_userid
870: where biz_flow_parent_key = p_parent_flow_key

Line 873: -- now update fnd_oam_bf_assoc_cust

869: last_updated_by = v_userid
870: where biz_flow_parent_key = p_parent_flow_key
871: and biz_flow_child_key = p_child_flow_key;
872: else
873: -- now update fnd_oam_bf_assoc_cust
874: update fnd_oam_bf_assoc_cust set
875: monitored_flag = p_new_flag,
876: last_update_date = sysdate,
877: last_updated_by = v_userid

Line 874: update fnd_oam_bf_assoc_cust set

870: where biz_flow_parent_key = p_parent_flow_key
871: and biz_flow_child_key = p_child_flow_key;
872: else
873: -- now update fnd_oam_bf_assoc_cust
874: update fnd_oam_bf_assoc_cust set
875: monitored_flag = p_new_flag,
876: last_update_date = sysdate,
877: last_updated_by = v_userid
878: where biz_flow_parent_key = p_parent_flow_key

Line 1015: -- now update fnd_oam_bf_assoc

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
1016: update fnd_oam_bf_wit set
1017: monitored_flag = p_new_flag,
1018: last_update_date = sysdate,
1019: last_updated_by = v_userid

Line 1023: -- now update fnd_oam_bf_assoc_cust

1019: last_updated_by = v_userid
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