APPS.QA_DEVICE_PUB dependencies on QA_DEVICE_INFO

Line 322: UPDATE qa_device_info

318: -- Trimming the length of the elapsed time to 15 characters.
319: -- skolluku
320: --
321: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
322: UPDATE qa_device_info
323: SET enabled_flag = 1,
324: description = p_device_desc(i),
325: elapsed_time = to_number(substr(p_expiration(i), 1, 15)),
326: last_updated_by = l_user_id,

Line 340: INSERT INTO qa_device_info(

336: --
337: FOR cntr IN p_device_name.FIRST..p_device_name.LAST LOOP
338: IF SQL%BULK_ROWCOUNT(cntr) = 0 THEN
339: -- Insert device if it does not exist.
340: INSERT INTO qa_device_info(
341: device_id,
342: device_name,
343: description,
344: sensor_alias,

Line 354: qa_device_info_s.nextval,

350: last_update_login,
351: last_update_date,
352: last_updated_by)
353: VALUES(
354: qa_device_info_s.nextval,
355: p_device_name(cntr),
356: p_device_desc(cntr),
357: p_device_source,
358: to_number(substr(p_expiration(cntr), 1, 15)),

Line 472: UPDATE qa_device_info

468: END IF;
469:
470: --Disable all required devices
471: FORALL i IN p_device_name.FIRST..p_device_name.LAST SAVE EXCEPTIONS
472: UPDATE qa_device_info
473: SET enabled_flag = 2,
474: last_updated_by = l_user_id,
475: last_update_login = l_user_id,
476: last_update_date = sysdate