APPS.OKS_IMPORT_PURGE SQL Statements

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

Line: 50

  l_update_name           varchar2(30);

Line: 80

	 l_update_name := 'Import'||P_batch_id;

Line: 81

	 ad_parallel_updates_pkg.purge_processed_units(l_table_owner,
	                                               l_table_name,
	   	                                       l_update_name);

Line: 85

         DELETE FROM AD_PARALLEL_UPDATES
	 WHERE OWNER = l_table_owner AND TABLE_NAME = l_table_name AND script_name = l_update_name;

Line: 142

    SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
    WHERE  BATCH_ID = P_batch_id
      AND  INTERFACE_STATUS = 'S'
      AND  rownum = 1;

Line: 162

         DELETE FROM OKS_IMPORT_STATISTICS WHERE BATCH_ID = P_batch_id;