APPS.OKC_KEXP_PVT SQL Statements

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

Line: 32

     SELECT  okc_kexp_report_s1.NEXTVAL
	INTO    l_report_seq
	FROM    dual;

Line: 43

     l_qry := 'SELECT row_id                '||
              'FROM   okc_k_headers_v  CHRV '||
              'WHERE                        '||
               p_ksearch_where_clause;                  --> Input Parameter

Line: 75

	    INSERT
	    INTO   OKC_KEXP_REPORT
	           (
	             CONTRACT_HEADER_ROWID,
	             REPORT_ID,
	             REPORT_DATE    )
            VALUES
			 (
                  okc_kexp_pls_tbl(i),        -- Row Id
                  l_report_seq,               -- Report Id
                  SYSDATE                     -- Report Date
                 );

Line: 91

	 -- Delete plsql collection table
	 -- -------------------------------------
	    okc_kexp_pls_tbl.DELETE;

Line: 126

PROCEDURE delete_ksrch_rows(
             p_from_date      IN  DATE     ,
             p_to_date        IN  DATE     ,
             x_return_status  OUT NOCOPY VARCHAR2 ) IS
BEGIN

   -- ------------------------------------------------------
   -- To delete rows from the temporary table for a given
   -- period of days. This procedure will be registered as
   -- the concurrent program, with two input parameters.
   -- ------------------------------------------------------
   IF   p_from_date <= p_to_date
   THEN

        DELETE FROM okc_kexp_report
        WHERE       report_date
        BETWEEN     p_from_date AND p_to_date;

Line: 177

END delete_ksrch_rows;

Line: 189

     SELECT name
     FROM   OKX_SALESREPS_V
	WHERE  id1 = p_id1
	AND    id2 = p_id2;