APPS.OKL_AM_LOAN_TRMNT_PVT SQL Statements

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

Line: 123

	   OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_tcnv_rec.update_status_yn: ' || p_tcnv_rec.update_status_yn);

Line: 143

	   OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_tcnv_rec.tmt_contract_updated_yn: ' || p_tcnv_rec.tmt_contract_updated_yn);

Line: 146

	   OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_tcnv_rec.tmt_streams_updated_yn: ' || p_tcnv_rec.tmt_streams_updated_yn);

Line: 210

    SELECT SYSDATE INTO l_sys_date FROM DUAL;

Line: 252

          p_trn_mode                    => 'INSERT');

Line: 279

          p_control_flag                => 'UPDATE',
          x_return_status               => l_return_status,
	  -- akrangan bug 5354501 fix start
	  x_msg_count                   => x_msg_count,
	  x_msg_data                    => x_msg_data);

Line: 431

          p_trn_mode                      => 'UPDATE');

Line: 529

          p_trn_mode                    => 'UPDATE');

Line: 743

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_LEASE_TRMNT_PVT.update_k_hdr_and_lines');

Line: 746

      OKL_AM_LEASE_TRMNT_PVT.update_k_hdr_and_lines(
        p_api_version     	            => p_api_version,
        p_init_msg_list   	            => OKL_API.G_FALSE,
        x_return_status   	            => l_return_status,
        x_msg_count       	            => x_msg_count,
        x_msg_data        	            => x_msg_data,
        p_status        	              => l_status,
        p_term_rec                      => l_term_rec,
        p_klev_tbl                      => lx_klev_tbl,
        p_trn_reason_code               => lp_tcnv_rec.trn_code,
        px_overall_status               => l_overall_status,
        px_tcnv_rec                     => lp_tcnv_rec,
        x_chrv_rec                      => lx_chrv_rec,
        x_clev_tbl                      => lx_clev_tbl,
        p_sys_date                      => l_sys_date);

Line: 762

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_LEASE_TRMNT_PVT.update_k_hdr_and_lines , return status: ' || l_return_status);

Line: 774

          p_tmt_flag                    => 'TMT_CONTRACT_UPDATED_YN',
          p_tsu_code                    => 'PROCESSED',
          px_tcnv_rec                   => lp_tcnv_rec);

Line: 781

      ELSE -- Update of K hdr and lines failed

        -- Contract table update failed.
        OKL_API.set_message( p_app_name      => G_APP_NAME,
                             p_msg_name      => 'OKL_AM_ERR_K_UPD');

Line: 794

          p_tmt_flag                    => 'TMT_CONTRACT_UPDATED_YN',
          p_tsu_code                    => 'ERROR',
          px_tcnv_rec                   => lp_tcnv_rec);

Line: 817

          p_trn_mode                    => 'UPDATE');