APPS.FND_OAM_BF_UTIL dependencies on FND_OAM_BF_WIT_INFO

Line 55: from fnd_oam_bf_wit_info

51: v_userid number := 0;
52: BEGIN
53: v_userid := get_user_id;
54: select 1 into v_x
55: from fnd_oam_bf_wit_info
56: where item_type = p_item_type;
57:
58: -- update
59: update fnd_oam_bf_wit_info

Line 59: update fnd_oam_bf_wit_info

55: from fnd_oam_bf_wit_info
56: where item_type = p_item_type;
57:
58: -- update
59: update fnd_oam_bf_wit_info
60: set count_errored_items = p_count_errored_items,
61: count_active_items = p_count_active_items,
62: last_updated_by = v_userid,
63: last_update_date = sysdate,

Line 68: insert into fnd_oam_bf_wit_info (

64: last_update_login = 0
65: where item_type = p_item_type;
66: EXCEPTION
67: when no_data_found then
68: insert into fnd_oam_bf_wit_info (
69: item_type,
70: count_errored_items,
71: count_active_items,
72: created_by,

Line 261: -- fnd_oam_bf_wit_info tables.

257: -- - count of active form sessions
258: -- - count of active ssf sessions (last hour)
259: --
260: -- The resulting values will get populated into fnd_oam_bf_comp_info,
261: -- fnd_oam_bf_wit_info tables.
262: --
263: -- Input Arguments
264: --
265: -- Output Arguments

Line 547: from fnd_oam_bf_wit_info

543: v_temp_active_wi number := 0;
544: begin
545: select nvl(count_errored_items,0), nvl(count_active_items,0)
546: into v_temp_err_wi, v_temp_active_wi
547: from fnd_oam_bf_wit_info
548: where item_type = w.item_type;
549: v_count_err_wi := v_count_err_wi + v_temp_err_wi;
550: v_count_active_wi := v_count_active_wi + v_temp_active_wi;
551: end;

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