DBA Data[Home] [Help]

APPS.OKL_CURE_RECON_PVT SQL Statements

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

Line: 13

       SELECT scs_code
       FROM   okc_k_headers_b
       WHERE  scs_code = 'SYNDICATION'
         AND  id = p_khr_id;
Line: 19

       SELECT 1
       FROM   okc_rules_b
       WHERE  dnz_chr_id = p_khr_id
         AND  rule_information_category = 'LAFCTG';
Line: 77

  ** the operation (insert, update ,delete)
*/

PROCEDURE AddfailMsg
  ( p_object	    IN	VARCHAR2,
    p_operation 	IN	VARCHAR2 ) IS

BEGIN
      fnd_message.set_name('OKL', 'OKL_FAILED_OPERATION');
Line: 86

      fnd_message.set_token('UPDATE', p_operation);
Line: 108

         SELECT  application_id
         FROM    fnd_application_vl
         WHERE   application_short_name = x_short_name;
Line: 113

         SELECT  msg.message_number
         FROM    fnd_new_messages msg, fnd_languages_vl lng
         WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;
Line: 165

PROCEDURE  UPDATE_CRT (  p_report_id     IN NUMBER,
                         p_status        IN VARCHAR2,
                         x_return_status OUT NOCOPY VARCHAR2,
                         x_msg_count     OUT NOCOPY NUMBER,
                         x_msg_data      OUT NOCOPY VARCHAR2)
IS

l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 176

l_api_name      CONSTANT VARCHAR2(50) := 'UPDATE_CRT';
Line: 181

select object_version_number
from   okl_cure_reports
where  cure_report_id =p_report_id;
Line: 190

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : START ');
Line: 196

  SAVEPOINT UPDATE_CRT;
Line: 199

    OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure_reports');
Line: 208

              p_operation =>  'UPDATE' );
Line: 216

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.cure_report_id : '||lp_crtv_rec.cure_report_id);
Line: 217

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : lp_crtv_rec.approval_status : '||lp_crtv_rec.approval_status);
Line: 219

  okl_cure_reports_pub.update_cure_reports(
                    p_api_version                  =>1.0
                   ,p_init_msg_list                =>FND_API.G_FALSE
                   ,x_return_status                =>l_return_status
                   ,x_msg_count                    =>l_msg_count
                   ,x_msg_data                     =>l_msg_data
                   ,p_crtv_rec                     =>lp_crtv_rec
                   ,x_crtv_rec                     =>xp_crtv_rec);
Line: 228

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : okl_cure_reports_pub.update_cure_reports : '||l_return_status);
Line: 241

      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
Line: 255

                            ' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CRT');
Line: 258

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CRT : END ');
Line: 262

    ROLLBACK TO UPDATE_CRT;
Line: 270

    ROLLBACK TO UPDATE_CRT;
Line: 278

    ROLLBACK TO UPDATE_CRT;
Line: 282

    Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CRT');
Line: 287

END UPDATE_CRT;
Line: 289

PROCEDURE  UPDATE_CAM (  p_cam_tbl        IN cure_amount_tbl,
                         p_report_id      IN NUMBER,
                         x_return_status  OUT NOCOPY VARCHAR2,
                         x_msg_count      OUT NOCOPY NUMBER,
                         x_msg_data       OUT NOCOPY VARCHAR2)
IS

l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 300

l_api_name      CONSTANT VARCHAR2(50) := 'UPDATE_CAM';
Line: 304

select a.object_version_number,a.cure_amount,b.khr_id
from   okl_cure_amounts a, okl_k_headers b
where  cure_amount_id =p_cam_id
and a.chr_id =b.id;
Line: 322

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : START ');
Line: 329

  SAVEPOINT UPDATE_CAM;
Line: 333

    OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start update_cure amounts');
Line: 341

             p_operation =>  'UPDATE' );
Line: 362

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_contract_info.get_rule_value : '||l_return_status);
Line: 388

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.cure_amount_id : '||lp_camv_rec.cure_amount_id);
Line: 389

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.negotiated_amount : '||lp_camv_rec.negotiated_amount);
Line: 390

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.crt_id : '||lp_camv_rec.crt_id);
Line: 403

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.process : '||lp_camv_rec.process);
Line: 405

    okl_cure_amounts_pub.update_cure_amounts(
                    p_api_version     =>1.0
                   ,p_init_msg_list   =>FND_API.G_FALSE
                   ,x_return_status   =>l_return_status
                   ,x_msg_count       =>l_msg_count
                   ,x_msg_data        =>l_msg_data
                   ,p_camv_rec        =>lp_camv_rec
                   ,x_camv_rec        =>xp_camv_rec);
Line: 414

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_cure_amounts_pub.update_cure_amounts : '||l_return_status);
Line: 427

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure amounts table ');
Line: 442

                            ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_CAM');
Line: 446

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : END ');
Line: 450

      ROLLBACK TO UPDATE_CAM;
Line: 458

      ROLLBACK TO UPDATE_CAM;
Line: 466

      ROLLBACK TO UPDATE_CAM;
Line: 470

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CAM');
Line: 475

END UPDATE_CAM;
Line: 477

PROCEDURE  UPDATE_INVOICE_HDR_LINES
                          (p_negotiated_amount IN NUMBER,
                           p_tai_id            IN NUMBER,
                           p_trx_status        IN VARCHAR2,
                           p_invoice_date      IN DATE,
                           x_return_status  OUT NOCOPY VARCHAR2,
                           x_msg_count      OUT NOCOPY NUMBER,
                           x_msg_data       OUT NOCOPY VARCHAR2) IS

l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 490

l_api_name        CONSTANT VARCHAR2(50) := 'UPDATE_INVOICE_HDR_LINES';
Line: 496

SELECT object_version_number
FROM   okl_trx_ar_invoices_b
WHERE  id = p_tai_id;
Line: 502

SELECT object_version_number,id
FROM   okl_txl_ar_inv_lns_b
WHERE  tai_id = p_tai_id;
Line: 508

SELECT object_version_number,id
FROM   OKL_TXD_AR_LN_DTLS_b
WHERE  til_id_details = p_til_id_details;
Line: 521

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : START ');
Line: 522

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_tai_id : '||p_tai_id);
Line: 523

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
Line: 524

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
Line: 525

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
Line: 527

  SAVEPOINT UPDATE_INVOICE_HDR_LINES;
Line: 533

                            , 'start UPDATE_INVOICE_HDR_LINES');
Line: 541

                  p_operation =>  'UPDATE' );
Line: 561

  okl_trx_ar_invoices_pub.update_trx_ar_invoices
                     (p_api_version     => 1.0,
                      p_init_msg_list   => 'F',
                      x_return_status   => l_return_status,
                      x_msg_count       => l_msg_count,
                      x_msg_data        => l_msg_data,
                      p_taiv_rec        => lp_taiv_rec,
                      x_taiv_rec        => xp_taiv_rec);
Line: 570

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.update_trx_ar_invoices : '||l_return_status);
Line: 589

                  p_operation =>  'UPDATE' );
Line: 599

    okl_txl_ar_inv_lns_pub.update_txl_ar_inv_lns
                     (p_api_version     => 1.0,
                      p_init_msg_list   => 'F',
                      x_return_status   => l_return_status,
                      x_msg_count       => l_msg_count,
                      x_msg_data        => l_msg_data,
                      p_tilv_rec        => lp_tilv_rec,
                      x_tilv_rec        => xp_tilv_rec);
Line: 608

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.update_txl_ar_inv_lns : '||l_return_status);
Line: 625

                  p_operation =>  'UPDATE' );
Line: 635

      okl_tld_pvt.update_row(
               p_api_version          =>  1.0,
               p_init_msg_list        =>  'F',
               x_return_status        =>  l_return_status,
               x_msg_count            =>  x_msg_count,
               x_msg_data             =>  x_msg_data,
               p_tldv_rec             =>  lp_tldv_rec,
               x_tldv_rec             =>  xp_tldv_rec);
Line: 644

      okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : okl_tld_pvt.update_row : '||l_return_status);
Line: 672

                            ,' End of Procedure => OKL_PAY_RECON_PVT.UPDATE_INVOICE_HDR_LINES');
Line: 675

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICE_HDR_LINES : END ');
Line: 680

    ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
Line: 689

    ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
Line: 698

    ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
Line: 702

    Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICE_HDR_LINES');
Line: 707

END update_invoice_hdr_lines;
Line: 738

SELECT c.minimum_accountable_unit,
       c.PRECISION
FROM   fnd_currencies c,
       okl_trx_ar_invoices_b b
WHERE  c.currency_code = b.currency_code
AND    b.khr_id = p_khr_id;
Line: 751

SELECT NVL(inv_organization_id,   -99)
FROM okc_k_headers_b
WHERE id = p_contract_id;
Line: 879

PROCEDURE  INSERT_INVOICE_HDR_LINES
                          (p_negotiated_amount IN NUMBER,
                           p_cam_id            IN NUMBER,
                           p_trx_status        IN VARCHAR2,
                           p_invoice_date      IN DATE,
                           x_return_status     OUT NOCOPY VARCHAR2,
                           x_msg_count         OUT NOCOPY NUMBER,
                           x_msg_data          OUT NOCOPY VARCHAR2) IS

l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 892

l_api_name      CONSTANT VARCHAR2(50) := 'INSERT_INVOICE_HDR_LINES';
Line: 912

SELECT  cam.chr_id               chr_id
       ,chr.currency_code        currency_code
       ,chr.conversion_type      conversion_type
       ,chr.conversion_rate      conversion_rate
       ,chr.conversion_rate_date conversion_rate_date
       ,chr.authoring_org_id     org_id
FROM    okl_cure_amounts         cam
       ,okc_k_headers_b          chr
WHERE   chr.id                 = cam.chr_id
AND     cam.cure_amount_id     = p_cam_id;
Line: 928

  SELECT cust_trx_type_id l_cust_trx_type_id
  FROM   ra_cust_trx_types
  WHERE  name = 'Invoice-OKL';
Line: 935

SELECT  id FROM okl_trx_types_tl
WHERE   name = 'Billing' AND   language = 'US';
Line: 942

		SELECT	c.receipt_method_id
		FROM	ra_cust_receipt_methods  c
		WHERE	c.cust_receipt_method_id = cp_cust_rct_mthd;
Line: 949

SELECT	a.cust_account_id	cust_account_id,
			a.cust_acct_site_id	cust_acct_site_id,
			a.payment_term_id	payment_term_id
FROM    okx_cust_site_uses_v	a,
		okx_customer_accounts_v	c
WHERE	a.id1			= cp_site_use_id
		AND	a.site_use_code		= cp_site_use_code
		AND	c.id1			= a.cust_account_id;
Line: 963

SELECT	c.standard_terms	standard_terms
FROM	hz_customer_profiles	c
WHERE	c.cust_account_id	= cp_cust_id
        AND	c.site_use_id		= cp_site_use_id
		UNION
		SELECT	c1.standard_terms	standard_terms
		FROM	hz_customer_profiles	c1
		WHERE	c1.cust_account_id	= cp_cust_id
		AND	c1.site_use_id		IS NULL
		AND	NOT EXISTS (
			SELECT	'1'
			FROM	hz_customer_profiles	c2
			WHERE	c2.cust_account_id	= cp_cust_id
			AND	c2.site_use_id		= cp_site_use_id);
Line: 985

   select BILL_TO_SITE_USE_ID
   from okc_k_party_roles_v
   where dnz_chr_id = p_program_id
   and RLE_CODE ='OKL_VENDOR';
Line: 996

select khr_id from okl_k_headers where id= p_contract_id;
Line: 1011

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : START ');
Line: 1012

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_cam_id : '||p_cam_id);
Line: 1013

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_trx_status : '||p_trx_status);
Line: 1014

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_invoice_date : '||p_invoice_date);
Line: 1015

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : p_negotiated_amount : '||p_negotiated_amount);
Line: 1017

  SAVEPOINT INSERT_INVOICE_HDR_LINES;
Line: 1022

                            , 'start INSERT_INVOICE_HDR_LINES');
Line: 1030

                  p_operation =>  'INSERT' );
Line: 1069

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.khr_id : '||lp_taiv_rec.khr_id);
Line: 1070

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_code : '||lp_taiv_rec.currency_code);
Line: 1071

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_type : '||lp_taiv_rec.currency_conversion_type);
Line: 1072

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_rate : '||lp_taiv_rec.currency_conversion_rate);
Line: 1073

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.currency_conversion_date : '||lp_taiv_rec.currency_conversion_date);
Line: 1074

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.org_id : '||lp_taiv_rec.org_id);
Line: 1094

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.try_id : '||lp_taiv_rec.try_id);
Line: 1120

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_tilv_rec.sty_id : '||lp_tilv_rec.sty_id);
Line: 1144

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_program_id : '||l_program_id);
Line: 1165

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : l_bill_to_address_id : '||l_bill_to_address_id);
Line: 1199

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ibt_id : '||lp_taiv_rec.ibt_id);
Line: 1200

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.ixx_id : '||lp_taiv_rec.ixx_id);
Line: 1201

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irt_id : '||lp_taiv_rec.irt_id);
Line: 1284

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.irm_id : '||lp_taiv_rec.irm_id);
Line: 1320

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : lp_taiv_rec.cust_trx_type_id : '||lp_taiv_rec.cust_trx_type_id);
Line: 1337

  okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices
                     (p_api_version     => 1.0,
                      p_init_msg_list   => 'F',
                      x_return_status   => l_return_status,
                      x_msg_count       => l_msg_count,
                      x_msg_data        => l_msg_data,
                      p_taiv_rec        => lp_taiv_rec,
                      x_taiv_rec        => xp_taiv_rec);
Line: 1346

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_trx_ar_invoices_pub.INSERT_trx_ar_invoices : '||l_return_status);
Line: 1365

                  p_operation =>  'INSERT' );
Line: 1386

    okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
                     (p_api_version     => 1.0,
                      p_init_msg_list   => 'F',
                      x_return_status   => l_return_status,
                      x_msg_count       => l_msg_count,
                      x_msg_data        => l_msg_data,
                      p_tilv_rec        => lp_tilv_rec,
                      x_tilv_rec        => xp_tilv_rec);
Line: 1395

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns : '||l_return_status);
Line: 1414

                  p_operation =>  'INSERT' );
Line: 1437

      okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_internal_billing_pvt.Get_Invoice_format : '||l_return_status);
Line: 1456

      okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : additional_tld_attr : '||l_return_status);
Line: 1469

      okl_tld_pvt.insert_row(
            p_api_version          =>  1.0,
            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_tldv_rec             =>  lp_tldv_rec,
            x_tldv_rec             =>  xp_tldv_rec);
Line: 1478

      okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : okl_tld_pvt.insert_row : '||l_return_status);
Line: 1502

                            ,' End of Procedure => OKL_PAY_RECON_PVT.INSERT_INVOICE_HDR_LINES');
Line: 1505

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : INSERT_INVOICE_HDR_LINES : END ');
Line: 1510

      ROLLBACK TO INSERT_INVOICE_HDR_LINES;
Line: 1519

      ROLLBACK TO INSERT_INVOICE_HDR_LINES;
Line: 1528

      ROLLBACK TO INSERT_INVOICE_HDR_LINES;
Line: 1532

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','INSERT_INVOICE_HDR_LINES');
Line: 1537

END insert_invoice_hdr_lines;
Line: 1555

select cam.qte_id,qte.date_effective_to
from okl_cure_amounts cam, okl_trx_quotes_b qte
where cam.cure_amount_id =p_cam_id
      and qte.id =cam.qte_id;
Line: 1578

                  p_operation =>  'UPDATE' );
Line: 1655

PROCEDURE  UPDATE_TAI_TIL (p_cam_tbl        IN cure_amount_tbl,
                           p_invoice_date   IN DATE,
                           p_trx_status     IN VARCHAR2,
                           x_return_status  OUT NOCOPY VARCHAR2,
                           x_msg_count      OUT NOCOPY NUMBER,
                           x_msg_data       OUT NOCOPY VARCHAR2) IS

l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 1666

l_api_name      CONSTANT VARCHAR2(50) := 'UPDATE_TAI_TIL';
Line: 1671

select id
from okl_trx_ar_invoices_b where
cpy_id =p_cam_id;
Line: 1679

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : START ');
Line: 1686

  SAVEPOINT UPDATE_TAI_TIL;
Line: 1689

    OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_TAI_TIL');
Line: 1725

        update_invoice_hdr_lines (
                   p_negotiated_amount =>p_cam_tbl(i).negotiated_amount,
                   p_tai_id            =>l_tai_id,
                   p_trx_status        =>p_trx_status,
                   p_invoice_date      =>p_invoice_date,
                   x_return_status     =>l_return_status,
                   x_msg_count         =>l_msg_count,
                   x_msg_data          =>l_msg_data);
Line: 1734

        insert_invoice_hdr_lines (
                   p_negotiated_amount =>p_cam_tbl(i).negotiated_amount,
                   p_cam_id            =>p_cam_tbl(i).cam_id,
                   p_trx_status        =>p_trx_status,
                   p_invoice_date      =>p_invoice_date,
                   x_return_status     =>l_return_status,
                   x_msg_count         =>l_msg_count,
                   x_msg_data          =>l_msg_data);
Line: 1754

                                  'Error in update tai_til :' ||l_message);
Line: 1793

                            ' End of Procedure =>OKL_PAY_RECON_PVT.UPDATE_TAI_TIL');
Line: 1796

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : END ');
Line: 1800

    ROLLBACK TO UPDATE_TAI_TIL;
Line: 1808

    ROLLBACK TO UPDATE_TAI_TIL;
Line: 1816

    ROLLBACK TO UPDATE_TAI_TIL;
Line: 1820

    Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_TAI_TIL');
Line: 1825

END UPDATE_TAI_TIL;
Line: 1827

PROCEDURE UPDATE_INVOICES (p_cam_tbl IN cure_amount_tbl,
                           p_report_id    IN NUMBER,
                           p_invoice_date IN DATE,
                           x_return_status OUT NOCOPY VARCHAR2,
                           x_msg_count     OUT NOCOPY NUMBER,
                           x_msg_data      OUT NOCOPY VARCHAR2) IS
l_return_status	VARCHAR2(1)	:= FND_API.G_RET_STS_SUCCESS;
Line: 1837

l_api_name      CONSTANT VARCHAR2(50) := 'UPDATE_INVOICES';
Line: 1843

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : START ');
Line: 1844

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_report_id : '||p_report_id);
Line: 1845

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : p_invoice_date : '||p_invoice_date);
Line: 1860

  SAVEPOINT UPDATE_INVOICES;
Line: 1863

    OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'start UPDATE_INVOICES');
Line: 1867

  UPDATE_TAI_TIL(p_cam_tbl       =>p_cam_tbl,
                 p_invoice_date  =>p_invoice_date,
                 p_trx_status    =>'WORKING',
                 x_return_status =>l_return_status,
                 x_msg_count     =>l_msg_count,
                 x_msg_data      =>l_msg_data);
Line: 1886

  UPDATE_CAM (p_cam_tbl       =>p_cam_tbl,
              p_report_id     =>p_report_id,
              x_return_status =>l_return_status,
              x_msg_count     =>l_msg_count,
              x_msg_data      =>l_msg_data);
Line: 1904

  UPDATE_CRT (p_report_id     =>p_report_id,
              p_status        =>'ACCEPTANCE_IN_PROGRESS',
              x_return_status =>l_return_status,
              x_msg_count     =>l_msg_count,
              x_msg_data      =>l_msg_data);
Line: 1921

      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
Line: 1932

                            ' End of Procedure =>OKL_PAY_RECON_PVT.update_invoices');
Line: 1935

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_INVOICES : END ');
Line: 1939

    ROLLBACK TO UPDATE_INVOICES;
Line: 1947

    ROLLBACK TO UPDATE_INVOICES;
Line: 1955

    ROLLBACK TO UPDATE_INVOICES;
Line: 1959

    Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICES');
Line: 1964

END UPDATE_INVOICES;
Line: 1975

  SELECT mo_global.get_current_org_id() l_fnd_profile
  FROM   dual;
Line: 1982

  SELECT cust_trx_type_id l_cust_trx_type_id
  FROM   ra_cust_trx_types
  WHERE  name = 'Invoice-OKL';
Line: 1990

  SELECT  ct.object1_id1           id
         ,chr.scs_code             scs_code
  FROM   okc_contacts              ct,
         okc_contact_sources       csrc,
         okc_k_party_roles_b       pty,
         okc_k_headers_b           chr
  WHERE  ct.cpl_id               = pty.id
  AND    ct.cro_code             = csrc.cro_code
  AND    ct.jtot_object1_code    = csrc.jtot_object_code
  AND    ct.dnz_chr_id           = chr.id
  AND    pty.rle_code            = csrc.rle_code
  AND    csrc.cro_code           = 'SALESPERSON'
  AND    csrc.rle_code           = 'LESSOR'
  AND    csrc.buy_or_sell        = chr.buy_or_sell
  AND    pty.dnz_chr_id          = chr.id
  AND    pty.chr_id              = chr.id
  AND    chr.id                  = p_contract_id;
Line: 2012

  SELECT bill_to_site_use_id cust_acct_site_id
  FROM   okc_k_headers_b
  WHERE  id = p_contract_id;
Line: 2023

select currency_code
from   OKC_K_HEADERS_b
where  id =l_khr_id;
Line: 2029

SELECT currency_conversion_type,
       currency_conversion_rate,
	 currency_conversion_date
FROM 	 okl_k_headers
WHERE  id = l_khr_id;
Line: 2045

SELECT tai.id
       ,tai.try_id
       ,til.sty_id
       ,tld.id
       ,tai.khr_id
       ,tai.date_invoiced
       ,tai.amount
FROM   okl_trx_ar_invoices_b tai
       ,okl_txl_ar_inv_lns_b til
       ,okl_txd_ar_ln_dtls_b tld
WHERE  tai.cpy_id         = p_cam_id
AND    tai.id             = til.tai_id
AND    tld.til_id_details = til.id;
Line: 2069

SELECT   okl.pdt_id
        ,okl.id
        ,okc.scs_code  -- Bug# 4622198
FROM    okl_k_headers    okl,
        okl_cure_amounts cam,
        okc_k_headers_b  okc -- Bug# 4622198
WHERE   okc.id = okl.id     -- Bug# 4622198
and     okl.id = cam.chr_id
and     cam.cure_amount_id =p_cam_id;
Line: 2502

  UPDATE_TAI_TIL(p_cam_tbl       =>p_cam_tbl,
                 p_invoice_date  =>p_invoice_date,
                 p_trx_status    =>'SUBMITTED',
                 x_return_status =>l_return_status,
                 x_msg_count     =>l_msg_count,
                 x_msg_data      =>l_msg_data);
Line: 2509

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_TAI_TIL : '||l_return_status);
Line: 2542

  UPDATE_CAM (p_cam_tbl       =>p_cam_tbl,
              p_report_id     =>p_report_id,
              x_return_status =>l_return_status,
              x_msg_count     =>l_msg_count,
              x_msg_data      =>l_msg_data);
Line: 2548

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CAM : '||l_return_status);
Line: 2562

  UPDATE_CRT (p_report_id     =>p_report_id,
              p_status        =>'ACCEPTANCE_COMPLETED',
              x_return_status =>l_return_status,
              x_msg_count     =>l_msg_count,
              x_msg_data      =>l_msg_data);
Line: 2568

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : SUBMIT_INVOICES : UPDATE_CRT : '||l_return_status);
Line: 2581

      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
Line: 2627

PROCEDURE UPDATE_CURE_INVOICE (
                               p_api_version   IN NUMBER,
                               p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
                               p_commit        IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
                               p_report_id     IN NUMBER,
                               p_invoice_date  IN DATE,
                               p_cam_tbl       IN cure_amount_tbl,
                               p_operation     IN VARCHAR2,
                               x_return_status OUT NOCOPY VARCHAR2,
                               x_msg_count     OUT NOCOPY NUMBER,
                               x_msg_data      OUT NOCOPY VARCHAR2) IS

  l_return_status      VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Line: 2646

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : START ');
Line: 2653

  SAVEPOINT UPDATE_CURE_INVOICE_PVT;
Line: 2656

  IF p_operation ='UPDATE'
  THEN
    IF (G_IS_DEBUG_STATEMENT_ON = true)
    THEN
      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, 'Operation is Update');
Line: 2662

    Update_invoices (p_cam_tbl       =>p_cam_tbl,
                     p_report_id     =>p_report_id,
                     p_invoice_date  =>p_invoice_date,
                     x_return_status =>l_return_status,
                     x_msg_count     =>l_msg_count,
                     x_msg_data      =>l_msg_data);
Line: 2669

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : Update_invoices : '||l_return_status);
Line: 2684

    okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : submit_invoices : '||l_return_status);
Line: 2698

      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices updated');
Line: 2709

                            ' End of Procedure => OKL_PAY_RECON_PVT.update_Cure_invoices');
Line: 2712

  okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CURE_INVOICE : END ');
Line: 2716

    ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
Line: 2724

    ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
Line: 2732

    ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
Line: 2736

    Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');
Line: 2741

END UPDATE_CURE_INVOICE;