APPS.QA_DEVICE_PUB dependencies on QA_DEVICE_DATA_VALUES

Line 95: UPDATE qa_device_data_values

91: fnd_msg_pub.add();
92: raise fnd_api.g_exc_error;
93: END IF;
94:
95: UPDATE qa_device_data_values
96: SET event_data = p_device_data,
97: event_time = systimestamp,
98: event_generation_time = p_device_event_time,
99: quality_code = p_quality_code,

Line 200: UPDATE qa_device_data_values

196: raise fnd_api.g_exc_error;
197: END IF;
198:
199: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
200: UPDATE qa_device_data_values
201: SET event_data = p_device_data(i),
202: event_time = systimestamp,
203: event_generation_time = p_device_event_time(i),
204: quality_code = p_quality_code(i),

Line 370: FROM qa_device_data_values

366: END IF;
367:
368: SELECT COUNT(device_name)
369: INTO exists_count
370: FROM qa_device_data_values
371: WHERE device_name = p_device_name(cntr)
372: AND device_source = p_device_source;
373:
374: IF exists_count = 0 THEN

Line 375: --Insert a new row for the device in QA_DEVICE_DATA_VALUES table if it is not already present.

371: WHERE device_name = p_device_name(cntr)
372: AND device_source = p_device_source;
373:
374: IF exists_count = 0 THEN
375: --Insert a new row for the device in QA_DEVICE_DATA_VALUES table if it is not already present.
376: INSERT INTO qa_device_data_values(
377: device_name,
378: device_source,
379: event_data,

Line 376: INSERT INTO qa_device_data_values(

372: AND device_source = p_device_source;
373:
374: IF exists_count = 0 THEN
375: --Insert a new row for the device in QA_DEVICE_DATA_VALUES table if it is not already present.
376: INSERT INTO qa_device_data_values(
377: device_name,
378: device_source,
379: event_data,
380: event_time,

Line 480: --Remove corresponding row from qa_device_data_values

476: last_update_date = sysdate
477: WHERE device_name = p_device_name(i)
478: AND sensor_alias = p_device_source;
479:
480: --Remove corresponding row from qa_device_data_values
481: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
482: DELETE FROM qa_device_data_values
483: WHERE device_name = p_device_name(i)
484: AND device_source = p_device_source;

Line 482: DELETE FROM qa_device_data_values

478: AND sensor_alias = p_device_source;
479:
480: --Remove corresponding row from qa_device_data_values
481: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
482: DELETE FROM qa_device_data_values
483: WHERE device_name = p_device_name(i)
484: AND device_source = p_device_source;
485:
486: IF fnd_api.to_boolean(p_commit) THEN