APPS.QA_DEVICE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

        SELECT user_id
        FROM fnd_user
        WHERE user_name = p_name;

Line: 95

		UPDATE qa_device_data_values
    SET event_data = p_device_data,
      event_time = systimestamp,
      event_generation_time = p_device_event_time,
      quality_code = p_quality_code,
      last_updated_by = l_user_id,
      last_update_login = l_user_id,
      last_update_date = sysdate
    WHERE device_name = p_device_name
     AND device_source = p_device_source;

Line: 107

      fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

Line: 133

     		fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

Line: 200

		 UPDATE qa_device_data_values
		 SET event_data = p_device_data(i),
  		 event_time = systimestamp,
  		 event_generation_time = p_device_event_time(i),
  		 quality_code = p_quality_code(i),
  		 last_updated_by = l_user_id,
  		 last_update_login = l_user_id,
  		 last_update_date = sysdate
		 WHERE device_name = p_device_name(i)
 		  AND device_source = p_device_source;

Line: 227

    	fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

Line: 256

     		fnd_message.set_name('QA', 'QA_DEV_INSERT_FAILED');

Line: 322

     UPDATE qa_device_info
      SET enabled_flag = 1,
          description = p_device_desc(i),
          elapsed_time = to_number(substr(p_expiration(i), 1, 15)),
          last_updated_by = l_user_id,
  		    last_update_login = l_user_id,
  		    last_update_date = sysdate
  	WHERE device_name = p_device_name(i)
  	 AND sensor_alias = p_device_source;

Line: 339

  	    -- Insert device if it does not exist.
  	    INSERT INTO qa_device_info(
  	         device_id,
  	         device_name,
  	         description,
  	         sensor_alias,
  	         elapsed_time,
  	         override_flag,
  	         enabled_flag,
  	         created_by,
  	         creation_date,
  	         last_update_login,
  	         last_update_date,
  	         last_updated_by)
        VALUES(
             qa_device_info_s.nextval,
             p_device_name(cntr),
             p_device_desc(cntr),
             p_device_source,
             to_number(substr(p_expiration(cntr), 1, 15)),
             2,
             1,
             l_user_id,
             sysdate,
             l_user_id,
             sysdate,
             l_user_id);

Line: 368

      SELECT COUNT(device_name)
    	INTO exists_count
    	FROM qa_device_data_values
    	WHERE device_name = p_device_name(cntr)
     	 AND device_source = p_device_source;

Line: 376

       INSERT INTO qa_device_data_values(
	       device_name,
	       device_source,
	       event_data,
	       event_time,
	       event_generation_time,
	       quality_code,
	       created_by,
	       creation_date,
	       last_update_login,
	       last_update_date,
	       last_updated_by)
	     VALUES(
	       p_device_name(cntr),
	       p_device_source,
	       '-1',
	       systimestamp,
	       sysdate,
	       -1,
	       l_user_id,
	       sysdate,
	       l_user_id,
	       sysdate,
	       l_user_id);

Line: 427

PROCEDURE delete_device_info_bulk(
    p_api_version               IN  NUMBER,
    p_init_msg_list             IN  VARCHAR2,
    p_validation_level          IN  NUMBER,
    p_user_name                 IN  VARCHAR2,
    p_device_source             IN  VARCHAR2,
    p_device_name               IN  VARCHAR2_TABLE,
    p_commit                    IN  VARCHAR2,
    x_msg_count                 OUT NOCOPY NUMBER,
    x_msg_data                  OUT NOCOPY VARCHAR2,
    x_return_status             OUT NOCOPY VARCHAR2) IS

  	l_api_version               NUMBER := 1.0;

Line: 441

  	l_api_name          CONSTANT VARCHAR2(30)   := 'delete_device_info_bulk';

Line: 472

     UPDATE qa_device_info
     SET enabled_flag = 2,
         last_updated_by = l_user_id,
  		   last_update_login = l_user_id,
  		   last_update_date = sysdate
     WHERE device_name = p_device_name(i)
      AND sensor_alias = p_device_source;

Line: 482

     DELETE FROM qa_device_data_values
     WHERE device_name = p_device_name(i)
      AND device_source = p_device_source;

Line: 506

END delete_device_info_bulk;