APPS.ICX_POR_BULK_LDR_PURGE SQL Statements

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

Line: 10

gDeleteJobNumbers		   dbms_sql.number_table;

Line: 21

SELECT round(p_commit_size/3)
INTO   gcommit_size
FROM   dual;

Line: 26

      DELETE FROM icx_por_batch_jobs
      WHERE  submission_datetime <= (SYSDATE-p_no_of_days)
      AND    ROWNUM <= gcommit_size
      RETURNING job_number BULK COLLECT INTO gDeleteJobNumbers;

Line: 39

      FORALL i IN 1..gDeleteJobNumbers.COUNT
	 DELETE FROM icx_por_failed_line_messages
         WHERE job_number = gDeleteJobNumbers(i);

Line: 45

      FORALL i IN 1..gDeleteJobNumbers.COUNT
	 DELETE FROM icx_por_failed_lines
	 WHERE job_number = gDeleteJobNumbers(i);

Line: 51

      FORALL i IN 1..gDeleteJobNumbers.COUNT
	 DELETE FROM icx_por_contract_references
	 WHERE job_number = gDeleteJobNumbers(i);