APPS.OKL_INS_CLAIM_ASSET_PVT SQL Statements

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

Line: 35

       SELECT CSI.LOCATION_ID
       FROM OKC_K_LINES_B A,
            OKC_K_LINES_B B,
            OKC_K_LINES_B C,
            OKC_K_ITEMS CIM,
            OKX_INSTALL_ITEMS_V CSI
       WHERE A.ID = p_kle_id
       AND   B.CLE_ID = A.ID
       AND   B.LSE_ID = 43
       AND   C.CLE_ID = B.ID
       AND   C.LSE_ID = 45
       AND CIM.CLE_ID = C.ID
       AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
       AND CSI.ID1 = CIM.OBJECT1_ID1
       AND CSI.ID2 = CIM.OBJECT1_ID2;

Line: 52

       select CLE.ID
       from okc_k_lines_b cle , okc_line_styles_b lse
       where cle.cle_id = p_cle_id  and
             cle.lse_id =  lse.id and
             lse.LTY_CODE = 'FIXED_ASSET';

Line: 80

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCLAB.pls call okl_ins_claims_pub.insert_INS_CLAIMS ');

Line: 83

    okl_ins_claims_pub.insert_INS_CLAIMS(
          p_api_version        =>  p_api_version
         ,p_init_msg_list      =>  p_init_msg_list
         ,x_return_status      =>  x_return_status
         ,x_msg_count          =>  x_msg_count
         ,x_msg_data           =>  x_msg_data
         ,p_clmv_tbl           =>  l_clmv_tbl
    	 ,x_clmv_tbl           =>  x_clmv_tbl );

Line: 93

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCLAB.pls call okl_ins_claims_pub.insert_INS_CLAIMS ');

Line: 169

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCLAB.pls call okl_asset_cndtns_pub.insert_asset_cndtns ');

Line: 172

    okl_asset_cndtns_pub.insert_asset_cndtns(
    	        p_api_version    => p_api_version
    	       ,p_init_msg_list  =>  p_init_msg_list
    	       ,x_return_status  =>  x_return_status
    	       ,x_msg_count      =>  x_msg_count
    	       ,x_msg_data       =>  x_msg_data
    	       ,p_acdv_tbl       =>  l_acdv_tbl
    	       ,x_acdv_tbl       =>  px_acdv_tbl);

Line: 182

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCLAB.pls call okl_asset_cndtns_pub.insert_asset_cndtns ');

Line: 209

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCLAB.pls call okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns ');

Line: 212

    okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns(
    	          p_api_version    =>  p_api_version
    	         ,p_init_msg_list  =>  p_init_msg_list
    	         ,x_return_status  =>  x_return_status
    	         ,x_msg_count      =>  x_msg_count
    	         ,x_msg_data       =>  x_msg_data
    	         ,p_acnv_tbl       =>  l_acnv_tbl
    		 ,x_acnv_tbl       =>  px_acnv_tbl);

Line: 222

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCLAB.pls call okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns ');

Line: 299

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCLAB.pls call Okl_Streams_Pub.update_streams   ');

Line: 302

        		  Okl_Streams_Pub.update_streams  (
	   p_api_version                   => l_api_version,
       p_init_msg_list                => Okc_Api.G_FALSE  ,
       x_return_status                => X_return_status  ,
       x_msg_count                    => x_msg_count,
       x_msg_data                     => x_msg_data ,
       p_stmv_tbl                     =>  l_stmv_tbl,
       x_stmv_tbl                       => x_stmv_tbl);

Line: 312

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCLAB.pls call Okl_Streams_Pub.update_streams   ');