APPS.QA_DEVICE_PUB dependencies on QA_DEVICE_INFO

Line 317: UPDATE qa_device_info

313: raise fnd_api.g_exc_error;
314: END IF;
315:
316: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
317: UPDATE qa_device_info
318: SET enabled_flag = 1,
319: description = p_device_desc(i),
320: elapsed_time = p_expiration(i),
321: last_updated_by = l_user_id,

Line 330: INSERT INTO qa_device_info(

326:
327: FOR cntr IN p_device_name.FIRST..p_device_name.LAST LOOP
328: IF SQL%BULK_ROWCOUNT(cntr) = 0 THEN
329: -- Insert device if it does not exist.
330: INSERT INTO qa_device_info(
331: device_id,
332: device_name,
333: description,
334: sensor_alias,

Line 344: qa_device_info_s.nextval,

340: last_update_login,
341: last_update_date,
342: last_updated_by)
343: VALUES(
344: qa_device_info_s.nextval,
345: p_device_name(cntr),
346: p_device_desc(cntr),
347: p_device_source,
348: p_expiration(cntr),

Line 462: UPDATE qa_device_info

458: END IF;
459:
460: --Disable all required devices
461: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
462: UPDATE qa_device_info
463: SET enabled_flag = 2,
464: last_updated_by = l_user_id,
465: last_update_login = l_user_id,
466: last_update_date = sysdate