APPS.OKS_IMPORT_CONTRACTS SQL Statements

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

Line: 52

  l_update_name           varchar2(30);

Line: 82

	 l_update_name := 'Import'||P_batch_id;

Line: 83

	 ad_parallel_updates_pkg.purge_processed_units(l_table_owner,
	                                               l_table_name,
	   	                                       l_update_name);

Line: 87

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

Line: 149

    SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
    WHERE  BATCH_ID = P_batch_id
      AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS  = 'R')
      AND rownum = 1;

Line: 155

    SELECT count(1) INTO l_worker_count FROM fnd_concurrent_requests
    WHERE  parent_request_id = G_WORKER_REQ_ID
      AND rownum = 1;