APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_CUST

Line 564: from fnd_oam_bf fb, fnd_oam_bf_cust fbc

560: -- check the absolute monitored flag for seeded flow
561: select
562: nvl(fbc.monitored_flag,fb.monitored_flag)
563: into v_abs_cust_mflag
564: from fnd_oam_bf fb, fnd_oam_bf_cust fbc
565: where fb.biz_flow_key = fbc.biz_flow_key (+)
566: and fb.biz_flow_key=fl.biz_flow_key;
567: exception
568: when no_data_found then

Line 572: from fnd_oam_bf_cust fbc

568: when no_data_found then
569: -- check the absolute monitored flag for user created flow
570: select fbc.monitored_flag
571: into v_abs_cust_mflag
572: from fnd_oam_bf_cust fbc
573: where fbc.biz_flow_key=fl.biz_flow_key;
574: end;
575:
576: if (v_abs_cust_mflag = 'Y') then

Line 669: from fnd_oam_bf fb, fnd_oam_bf_cust fbc

665: IS
666: cursor c_monitored_key_flows is
667: select
668: fb.biz_flow_key biz_flow_key
669: from fnd_oam_bf fb, fnd_oam_bf_cust fbc
670: where fb.biz_flow_key = fbc.biz_flow_key (+)
671: and fb.is_top_level = 'Y'
672: and nvl(fbc.monitored_flag,fb.monitored_flag) = 'Y'
673: union

Line 675: from fnd_oam_bf_cust fbc

671: and fb.is_top_level = 'Y'
672: and nvl(fbc.monitored_flag,fb.monitored_flag) = 'Y'
673: union
674: select fbc.biz_flow_key biz_flow_key
675: from fnd_oam_bf_cust fbc
676: where fbc.monitored_flag = 'Y'
677: and fbc.is_top_level = 'Y'
678: and fbc.biz_flow_key not in (
679: select fb.biz_flow_key from fnd_oam_bf fb

Line 749: -- Updates fnd_oam_bf_cust if record exists for given flow key

745: END refresh_metrics;
746:
747: --
748: -- Updates the monitored flag for the given flow
749: -- Updates fnd_oam_bf_cust if record exists for given flow key
750: -- Otherwise, copies entry from fnd_oam_bf to
751: -- fnd_oam_bf_cust and updates the monitored_flag in
752: -- fnd_oam_bf_cust.
753: --

Line 751: -- fnd_oam_bf_cust and updates the monitored_flag in

747: --
748: -- Updates the monitored flag for the given flow
749: -- Updates fnd_oam_bf_cust if record exists for given flow key
750: -- Otherwise, copies entry from fnd_oam_bf to
751: -- fnd_oam_bf_cust and updates the monitored_flag in
752: -- fnd_oam_bf_cust.
753: --
754: --
755: PROCEDURE update_bf_monitored_flag (

Line 752: -- fnd_oam_bf_cust.

748: -- Updates the monitored flag for the given flow
749: -- Updates fnd_oam_bf_cust if record exists for given flow key
750: -- Otherwise, copies entry from fnd_oam_bf to
751: -- fnd_oam_bf_cust and updates the monitored_flag in
752: -- fnd_oam_bf_cust.
753: --
754: --
755: PROCEDURE update_bf_monitored_flag (
756: p_flow_key varchar2,

Line 765: select 1 into v_cust_flag from fnd_oam_bf_cust

761: v_base_monitored_flag varchar2(1);
762: BEGIN
763: v_userid := get_user_id;
764: begin
765: select 1 into v_cust_flag from fnd_oam_bf_cust
766: where biz_flow_key = p_flow_key;
767: exception
768: when no_data_found then
769: v_cust_flag := 0;

Line 779: -- insert into fnd_oam_bf_cust(

775: -- where biz_flow_key = p_flow_key;
776: --
777: -- if (v_base_monitored_flag <> p_new_flag) then
778: -- -- copy over record to cust table
779: -- insert into fnd_oam_bf_cust(
780: -- biz_flow_key, monitored_flag, is_top_level,
781: -- created_by, creation_date, last_updated_by, last_update_date,
782: -- last_update_login)
783: -- select biz_flow_key, monitored_flag, is_top_level,

Line 788: -- insert into fnd_oam_bf_cust_tl(

784: -- created_by, creation_date, last_updated_by, last_update_date,
785: -- last_update_login
786: -- from fnd_oam_bf
787: -- where biz_flow_key = p_flow_key;
788: -- insert into fnd_oam_bf_cust_tl(
789: -- biz_flow_key, language, flow_display_name, description,
790: -- created_by, creation_date, last_updated_by, last_update_date,
791: -- last_update_login, source_lang)
792: -- select biz_flow_key, language, flow_display_name, description,

Line 805: -- now update fnd_oam_bf_cust

801: last_update_date = sysdate,
802: last_updated_by = v_userid
803: where biz_flow_key = p_flow_key;
804: else
805: -- now update fnd_oam_bf_cust
806: update fnd_oam_bf_cust set
807: monitored_flag = p_new_flag,
808: last_update_date = sysdate,
809: last_updated_by = v_userid

Line 806: update fnd_oam_bf_cust set

802: last_updated_by = v_userid
803: where biz_flow_key = p_flow_key;
804: else
805: -- now update fnd_oam_bf_cust
806: update fnd_oam_bf_cust set
807: monitored_flag = p_new_flag,
808: last_update_date = sysdate,
809: last_updated_by = v_userid
810: where biz_flow_key = p_flow_key;