APPS.OKL_INTERNAL_TO_EXTERNAL_PUB SQL Statements

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

Line: 46

      ROLLBACK TO cnsld_ar_hdrs_insert;

Line: 54

      ROLLBACK TO cnsld_ar_hdrs_insert;

Line: 62

      ROLLBACK TO cnsld_ar_hdrs_insert;

Line: 94

	  SELECT
          DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
	  FROM dual;

Line: 100

          SELECT count(*)
          FROM okl_ext_sell_invs_v
          WHERE trx_status_code = p_sts AND
                request_id = p_req_id ;

Line: 106

          SELECT count(*)
          FROM okl_ext_sell_invs_v
          WHERE trx_status_code = p_sts AND
                request_id = p_req_id ;

Line: 139

            DELETE OKL_PARALLEL_PROCESSES
            WHERE assigned_process = p_assigned_process;