APPS.FND_SOA_UTIL SQL Statements

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

Line: 4

/* Purge Function to delete all Data */
procedure delete_by_date_cp(errbuf out NOCOPY varchar2,
                            retcode out NOCOPY varchar2,
                            start_date in  varchar2,
                            end_date in  varchar2,
                            module in varchar2) is
        v_strt_date DATE;

Line: 12

        deleted_requests_count NUMBER;

Line: 13

        deleted_response_count NUMBER;

Line: 14

        deleted_method_count NUMBER;

Line: 15

	deleted_att_count NUMBER;

Line: 16

	deleted_error_count NUMBER;

Line: 17

	deleted_log_count NUMBER;

Line: 48

  /* Purge Function to delete obsoleted Log Data */
  deleted_log_count := delete_log_by_date_range(v_strt_date,v_end_date, v_direction);

Line: 50

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_LOG_MESSAGES - '||deleted_log_count);

Line: 52

  /* Purge Function to delete all requests Data */
  deleted_requests_count := delete_requests_by_date_range(v_direction,v_strt_date,v_end_date);

Line: 54

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_REQUEST - '||deleted_requests_count);

Line: 56

  /* Purge Function to delete all method Data */
  deleted_method_count := delete_method_by_date_range(v_strt_date,v_end_date);

Line: 58

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RESPONSE_METHOD - '||deleted_method_count);

Line: 60

  /* Purge Function to delete all attachment Data */
  deleted_att_count := delete_att_by_date_range(v_strt_date,v_end_date);

Line: 62

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_ATTACHMENT - '||deleted_att_count);

Line: 64

  /* Purge Function to delete all attachment body Data */
  deleted_att_count := delete_body_by_date_range(v_strt_date,v_end_date);

Line: 66

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_BODY_PIECE - '||deleted_att_count);

Line: 68

  /* Purge Function to delete all Error Data */
  deleted_error_count := delete_error_by_date_range(v_strt_date,v_end_date);

Line: 70

  FND_FILE.put_line(FND_FILE.log, 'Records purged in FND_SOA_RUNTIME_ERROR - '||deleted_error_count);

Line: 75

end delete_by_date_cp;

Line: 78

/* Purge Function to delete all requests Data */
FUNCTION delete_requests_by_date_range(
         x_direction IN VARCHAR2,
         x_start_date IN DATE,
         x_end_date IN DATE) return NUMBER is
  rowcount number := 0;

Line: 89

    DELETE FROM  FND_SOA_REQUEST
    WHERE message_id IN
	(SELECT WR.message_id
       	 FROM FND_SOA_REQUEST WR
	 WHERE (x_start_date IS NOT NULL and x_end_date IS NOT NULL)
         AND x_start_date <= WR.request_timestamp
         AND x_end_date >= WR.request_timestamp)
    AND nvl(direction, 'INBOUND') = x_direction
    AND request_status <> 'IN_PROCESS'
    AND rownum <= 20000;

Line: 116

  fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from FND_SOA_REQUEST ');

Line: 121

/* Purge Function to delete all method Data */
FUNCTION delete_method_by_date_range(
         x_start_date IN DATE,
         x_end_date IN DATE) return NUMBER is
  rowcount number := 0;

Line: 131

     DELETE FROM FND_SOA_RESPONSE_METHOD
     WHERE message_id NOT IN
            (SELECT message_id FROM FND_SOA_REQUEST)
     AND rownum <= 20000;

Line: 153

			'Deleted '|| rowcount ||' rows from FND_SOA_RESPONSE_METHOD ');

Line: 158

/* Purge Function to delete all attachment Data */
FUNCTION delete_att_by_date_range(
         x_start_date IN DATE,
         x_end_date IN DATE) return NUMBER is
  rowcount number := 0;

Line: 168

    DELETE FROM FND_SOA_ATTACHMENT WA
    WHERE message_id NOT IN
	(SELECT message_id FROM FND_SOA_REQUEST)
    AND rownum <= 20000;

Line: 189

			'Deleted '|| rowcount ||' rows from FND_SOA_ATTACHMENT');

Line: 195

/* Purge Function to delete all attachment body Data */
FUNCTION delete_body_by_date_range(
         x_start_date IN DATE,
         x_end_date IN DATE) return NUMBER is
  rowcount number := 0;

Line: 205

   DELETE
     FROM FND_SOA_BODY_PIECE WP
     WHERE (message_id NOT IN
             (SELECT message_id FROM FND_SOA_REQUEST))
     AND rownum <= 20000;

Line: 228

			'Deleted '|| rowcount ||' rows from FND_SOA_BODY_PIECE');

Line: 232

/* Purge function to delete all Error Data */
FUNCTION delete_error_by_date_range(
		x_start_date IN DATE,
		x_end_date IN DATE) return NUMBER is
	rowcount number := 0;

Line: 242

	DELETE FROM FND_SOA_RUNTIME_ERROR RE
	WHERE (message_id NOT IN
	      (SELECT message_id FROM FND_SOA_REQUEST))
        AND rownum <= 20000;

Line: 264

			'Deleted '|| rowcount ||' rows from FND_SOA_RUNTIME_ERROR');

Line: 268

/* Purge function to delete all Log Data */
FUNCTION delete_log_by_date_range(
		x_start_date IN DATE,
		x_end_date IN DATE,
                x_direction in varchar2) return NUMBER is
	rowcount number := 0;

Line: 279

     DELETE from fnd_log_messages
     where transaction_context_id in
     (select transaction_context_id
      from fnd_log_transaction_context
      where transaction_type = 'SOA_INSTANCE'
      and transaction_id in
          (select message_id
           from fnd_soa_request
           where REQUEST_STATUS = 'SUCCESS'
           and x_start_date <= REQUEST_TIMESTAMP
           AND x_end_date >= REQUEST_TIMESTAMP
           AND direction = x_direction))
      AND rownum <= 20000;

Line: 309

			'Deleted '|| rowcount ||' rows from FND_LOG_MESSAGES');

Line: 313

/* Purge Function to Delete Log Details by Message ID */
FUNCTION delete_log_by_instance_id(
	x_instance_id IN NUMBER) return NUMBER is
	rowcount number := 0;

Line: 322

	DELETE
            from fnd_log_messages
	    where transaction_context_id in
	    (select transaction_context_id
	         from fnd_log_transaction_context
		 where transaction_type = 'SOA_INSTANCE'
		 and transaction_id = x_instance_id) and rownum <= 20000;