APPS.OKC_QA_PRICE_PVT SQL Statements

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

Line: 27

    select application_id,
           estimated_amount,
		 buy_or_sell,
		 orig_system_source_code
      from okc_k_headers_b
     where id = p_chr_id;

Line: 39

   SELECT hdr.orig_system_source_code, cle.ID
   FROM OKC_K_LINES_B    cle,
         OKC_K_HEADERS_B  hdr
   WHERE hdr.id    = p_chr_id
   AND hdr.id      =  cle.dnz_chr_id (+)
   AND ROWNUM      < 2;

Line: 146

    OKC_Price_Pub.Update_Contract_Price(
         p_api_version     => 1.0,
         p_init_msg_list   => OKC_API.G_FALSE,
         p_commit          => OKC_API.G_FALSE,
         p_chr_id          => p_chr_id,
         px_control_rec    => l_control_rec,
         x_cle_price_tbl   => l_cle_price_tbl,
         x_chr_net_price   => l_chr_net_price,
         x_return_status   => l_return_status,
         x_msg_count       => l_msg_count,
         x_msg_data        => l_msg_data);

Line: 245

    select application_id,
		 buy_or_sell,
		 orig_system_source_code
      from okc_k_headers_b
     where id = p_chr_id;

Line: 256

    SELECT hdr.orig_system_source_code, cle.ID
    FROM   OKC_K_LINES_B    cle,
           OKC_K_HEADERS_B  hdr
    WHERE  hdr.id    = p_chr_id
    AND    hdr.id    =  cle.dnz_chr_id (+)
    AND ROWNUM      < 2;

Line: 304

     SELECT object1_id1, number_of_items qty
     FROM   okc_k_items
     WHERE  cle_id = b_cle_id
     AND    dnz_chr_id = p_chr_id
     AND    jtot_object1_code = 'OKX_COVLINE';

Line: 313

     SELECT number_of_items qty
     FROM   okc_k_items
     WHERE  cle_id = b_cle_id
     AND    dnz_chr_id = p_chr_id;

Line: 573

       SELECT            cle_id, id, line_number, lse_id
       BULK COLLECT INTO l_cle_id_tbl,l_id_tbl, l_line_number_tbl, l_lse_id_tbl
       FROM okc_k_lines_b
       CONNECT BY PRIOR id = cle_id
       START WITH chr_id   = p_chr_id;

Line: 579

          okc_debug.Log('1060 : select rowcount'||SQL%ROWCOUNT, 1);