APPS.FND_OAM_DASHBOARD_UTIL dependencies on FND_OAM_SVCI_INFO

Line 171: -- into fnd_oam_svci_info. For the given service instance if a row

167: -- load_svci_info
168: --
169: -- Purpose
170: -- Loads services instances related alerting, collection information
171: -- into fnd_oam_svci_info. For the given service instance if a row
172: -- already exists it updates the row; otherwise it inserts a new row.
173: --
174: -- Input Arguments
175: --

Line 202: from fnd_oam_svci_info

198: v_userid := 0;
199: end;
200:
201: select 1 into v_x
202: from fnd_oam_svci_info
203: where application_id = p_application_id
204: and concurrent_queue_name = p_concurrent_queue_name;
205:
206: -- update

Line 207: update fnd_oam_svci_info

203: where application_id = p_application_id
204: and concurrent_queue_name = p_concurrent_queue_name;
205:
206: -- update
207: update fnd_oam_svci_info
208: set alert_enabled_flag = p_alert_enabled_flag,
209: collection_enabled_flag = p_collection_enabled_flag,
210: threshold_value = p_threshold_value,
211: last_updated_by = v_userid,

Line 218: insert into fnd_oam_svci_info (

214: where application_id = p_application_id
215: and concurrent_queue_name = p_concurrent_queue_name;
216: EXCEPTION
217: when no_data_found then
218: insert into fnd_oam_svci_info (
219: application_id,
220: concurrent_queue_name,
221: alert_enabled_flag,
222: collection_enabled_flag,