APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_ROLLUP_INFO

Line 187: from fnd_oam_bf_rollup_info

183: v_userid number := 0;
184: BEGIN
185: v_userid := get_user_id;
186: select 1 into v_x
187: from fnd_oam_bf_rollup_info
188: where biz_flow_key = p_biz_flow_key;
189:
190: -- update
191: update fnd_oam_bf_rollup_info

Line 191: update fnd_oam_bf_rollup_info

187: from fnd_oam_bf_rollup_info
188: where biz_flow_key = p_biz_flow_key;
189:
190: -- update
191: update fnd_oam_bf_rollup_info
192: set count_alerts = p_count_alerts,
193: count_errored_requests = p_count_errored_requests,
194: count_errored_work_items = p_count_errored_work_items,
195: setup_status = p_setup_status,

Line 208: insert into fnd_oam_bf_rollup_info (

204: last_update_login = 0
205: where biz_flow_key = p_biz_flow_key;
206: EXCEPTION
207: when no_data_found then
208: insert into fnd_oam_bf_rollup_info (
209: biz_flow_key,
210: count_alerts,
211: count_errored_requests,
212: count_errored_work_items,

Line 392: -- fnd_oam_bf_rollup_info table. Rollup values are based only on

388: END compute_metrics;
389:
390: --
391: -- Computes the rolled values for the given metrics and loads it into the
392: -- fnd_oam_bf_rollup_info table. Rollup values are based only on
393: -- associations for which the monitored_flag='Y'
394: --
395: -- 1) p_count_alerts - Total count of open/new alerts for this flow
396: -- 2) p_count_err_requests - Total count of errored concurrent requests

Line 630: -- fnd_oam_bf_rollup_info

626: end;
627: end loop;
628:
629: -- finally update the out parameters and load the info into
630: -- fnd_oam_bf_rollup_info
631: p_count_alerts := v_count_alerts;
632: p_count_err_requests := v_count_err_requests;
633: p_count_err_wi := v_count_err_wi;
634: p_count_running_requests := v_count_running_requests;

Line 654: -- The resulting values will get populated into fnd_oam_bf_rollup_info

650: -- - count of open system alerts
651: -- - count of errored concurrent requests
652: -- - count of errored work items
653: --
654: -- The resulting values will get populated into fnd_oam_bf_rollup_info
655: -- tables.
656: --
657: -- Input Arguments
658: --

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