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 ) is
        v_strt_date DATE;

Line: 11

        deleted_requests_count NUMBER;

Line: 12

        deleted_response_count NUMBER;

Line: 13

        deleted_method_count NUMBER;

Line: 14

	deleted_att_count NUMBER;

Line: 36

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

Line: 39

  /* Purge Function to delete all response Data */
  deleted_response_count :=
delete_responses_by_date_range(v_strt_date,v_end_date);

Line: 42

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

Line: 44

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

Line: 46

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

Line: 50

end delete_by_date_cp;

Line: 53

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

Line: 64

    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<= trunc(WR.request_timestamp,'DD')
	AND  x_end_date>= trunc(WR.request_timestamp,'DD')
	)
	AND rownum <= 1000;

Line: 92

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

Line: 99

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

Line: 109

    DELETE
      FROM  FND_SOA_RESPONSE
      WHERE message_id IN
	(SELECT WR.message_id
	FROM
	FND_SOA_RESPONSE    WR
	WHERE
	(x_start_date IS NOT NULL and x_end_date IS NOT NULL)
	AND  x_start_date <= trunc(WR.response_timestamp,'DD')
	AND  x_end_date >= trunc(WR.response_timestamp,'DD')
	)
	AND rownum <= 1000;

Line: 139

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

Line: 144

/* 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: 154

	DELETE
	FROM FND_SOA_RESPONSE_METHOD
	WHERE
	message_id NOT  IN
	(SELECT message_id
	FROM
	FND_SOA_RESPONSE)
	AND rownum <= 1000;

Line: 180

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

Line: 185

/* 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: 195

	DELETE
	FROM FND_SOA_ATTACHMENT WA
	WHERE
	((WA.BELONGS_TO='REQUEST' AND  message_id NOT  IN
	(SELECT message_id
	FROM
	FND_SOA_REQUEST))
	OR
	(WA.BELONGS_TO='RESPONSE' AND  message_id NOT  IN
	(SELECT message_id
	FROM
	FND_SOA_RESPONSE)))
	AND rownum <= 1000;

Line: 226

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

Line: 232

/* 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: 242

	DELETE
	FROM FND_SOA_BODY_PIECE WP
	WHERE
	((WP.BELONGS_TO='REQUEST' AND  message_id NOT  IN
	(SELECT message_id
	FROM
	FND_SOA_REQUEST))
	OR
	(WP.BELONGS_TO='RESPONSE' AND  message_id NOT  IN
	(SELECT message_id
	FROM
	FND_SOA_RESPONSE)))
	AND rownum <= 1000;

Line: 273

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