APPS.PSB_MESSAGE_S SQL Statements

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

Line: 128

 PROCEDURE  Insert_Error( p_source_process IN VARCHAR2,
			  p_process_id     IN NUMBER,
			  p_msg_count      IN NUMBER,
			  p_msg_data       IN VARCHAR2,
			  p_desc_sequence  IN VARCHAR2 := FND_API.G_FALSE
			)
 IS


  l_msg_count   NUMBER          := p_msg_count ;

Line: 175

	    insert into PSB_ERROR_MESSAGES
		       (concurrent_request_id,
			process_id,
			source_process,
			sequence_number,
			description,
			creation_date,
			created_by)
		values (l_conc_req_id,
			p_process_id,
			p_source_process,
			l_seq_number,
			l_msg_buf,
			sysdate,
			l_user_id);

Line: 194

	insert into PSB_ERROR_MESSAGES
		       (concurrent_request_id,
			process_id,
			source_process,
			sequence_number,
			description,
			creation_date,
			created_by)
		values (l_conc_req_id,
			p_process_id,
			p_source_process,
			1,
			l_msg_buf,
			sysdate,
			l_user_id);

Line: 211

 END Insert_Error ;

Line: 340

PROCEDURE BATCH_INSERT_ERROR (p_source_process IN VARCHAR2,
                          p_process_id     IN NUMBER)
IS
  l_msg_count    NUMBER;

Line: 355

  SELECT max(sequence_number) seq_no
  FROM   psb_error_messages
  WHERE  process_id = p_process_id
  AND    source_process = p_source_process;

Line: 393

     insert into PSB_ERROR_MESSAGES
     (concurrent_request_id,
      process_id,
      source_process,
      sequence_number,
      description,
      creation_date,
      created_by
      )
      values
     (
      l_conc_req_id,
      p_process_id,
      p_source_process,
      l_seq_no,
      l_msg_buf,
      sysdate,
      l_user_id
      );

Line: 419

    insert into PSB_ERROR_MESSAGES
    (concurrent_request_id,
     process_id,
     source_process,
     sequence_number,
     description,
     creation_date,
     created_by)
     values
     (l_conc_req_id,
      p_process_id,
      p_source_process,
      1,
      l_msg_buf,
      sysdate,
      l_user_id);