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 360: FROM qa_device_data_values

356: END IF;
357:
358: SELECT COUNT(device_name)
359: INTO exists_count
360: FROM qa_device_data_values
361: WHERE device_name = p_device_name(cntr)
362: AND device_source = p_device_source;
363:
364: IF exists_count = 0 THEN

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

361: WHERE device_name = p_device_name(cntr)
362: AND device_source = p_device_source;
363:
364: IF exists_count = 0 THEN
365: --Insert a new row for the device in QA_DEVICE_DATA_VALUES table if it is not already present.
366: INSERT INTO qa_device_data_values(
367: device_name,
368: device_source,
369: event_data,

Line 366: INSERT INTO qa_device_data_values(

362: AND device_source = p_device_source;
363:
364: IF exists_count = 0 THEN
365: --Insert a new row for the device in QA_DEVICE_DATA_VALUES table if it is not already present.
366: INSERT INTO qa_device_data_values(
367: device_name,
368: device_source,
369: event_data,
370: event_time,

Line 470: --Remove corresponding row from qa_device_data_values

466: last_update_date = sysdate
467: WHERE device_name = p_device_name(i)
468: AND sensor_alias = p_device_source;
469:
470: --Remove corresponding row from qa_device_data_values
471: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
472: DELETE FROM qa_device_data_values
473: WHERE device_name = p_device_name(i)
474: AND device_source = p_device_source;

Line 472: DELETE FROM qa_device_data_values

468: AND sensor_alias = p_device_source;
469:
470: --Remove corresponding row from qa_device_data_values
471: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
472: DELETE FROM qa_device_data_values
473: WHERE device_name = p_device_name(i)
474: AND device_source = p_device_source;
475:
476: IF fnd_api.to_boolean(p_commit) THEN