[Home] [Help]
104: v_userid number := 0;
105: BEGIN
106: v_userid := get_user_id;
107: select 1 into v_x
108: from fnd_oam_bf_comp_info
109: where component_type = p_component_type
110: and component_appl_id = p_component_appl_id
111: and component_id = p_component_id;
112:
110: and component_appl_id = p_component_appl_id
111: and component_id = p_component_id;
112:
113: -- update
114: update fnd_oam_bf_comp_info
115: set count_alerts = p_count_alerts,
116: count_errored_requests = p_count_errored_requests,
117: setup_status = p_setup_status,
118: test_status = p_test_status,
127: and component_appl_id = p_component_appl_id
128: and component_id = p_component_id;
129: EXCEPTION
130: when no_data_found then
131: insert into fnd_oam_bf_comp_info (
132: component_type,
133: component_appl_id,
134: component_id,
135: count_alerts,
256: -- - count of running concurrent requests
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: --
517: nvl(count_running_requests,0), nvl(count_form_sessions,0),
518: nvl(count_ssf_sessions,0)
519: into v_temp_alerts, v_temp_err_req, v_temp_running_req,
520: v_temp_form_sessions, v_temp_ssf_sessions
521: from fnd_oam_bf_comp_info
522: where component_type = c.component_type
523: and component_appl_id = c.component_appl_id
524: and component_id = c.component_id;
525: v_count_alerts := v_count_alerts + v_temp_alerts;
721: -- - count of open system alerts
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: --