APPS.OKL_CREATE_DISB_TRANS_PVT SQL Statements

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

Line: 50

  select vs.vendor_id
  from   ap_supplier_sites vs
  where vs.vendor_site_id = p_vendor_site_id
  ;

Line: 58

  select a.application_id
  from FND_APPLICATION a
  where APPLICATION_SHORT_NAME = 'OKL'
  ;

Line: 66

  select to_number(a.set_of_books_id)
  from HR_OPERATING_UNITS a
  where ORGANIZATION_ID = p_org_id
  ;

Line: 74

  select a.TERMS_ID, a.PAY_GROUP_LOOKUP_CODE
  from PO_VENDOR_SITES_ALL a
  where vendor_site_id = p_vendor_site_id
  ;

Line: 345

    SELECT  khr.pdt_id
    FROM    okl_k_headers khr
    WHERE   khr.id =  p_khr_id;

Line: 351

    SELECT khr.currency_code
           ,chr.currency_conversion_type
           ,chr.currency_conversion_rate
           ,chr.currency_conversion_date
           ,chr.legal_entity_id
    FROM   okc_k_headers_b khr,
            okl_k_headers chr
    WHERE khr.id = chr.id
    AND     khr.id = p_khr_id;

Line: 363

  select a.application_id
  from FND_APPLICATION a
  where APPLICATION_SHORT_NAME = 'OKL'
  ;

Line: 776

   OKL_TRX_AP_INVOICES_PUB.Insert_trx_ap_invoices(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_tapv_rec         =>   l_tapv_rec
                                                 ,x_tapv_rec         =>   lx_tapv_rec);

Line: 878

   OKL_TXL_AP_INV_LNS_PUB.insert_txl_ap_inv_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_tplv_tbl         =>   l_tplv_tbl
            ,x_tplv_tbl         =>   lx_tplv_tbl);

Line: 1282

  PROCEDURE Update_Disb_Trx(p_api_version               IN  NUMBER
                           ,p_init_msg_list             IN  VARCHAR2    DEFAULT OKL_API.G_FALSE
                           ,x_return_status             OUT NOCOPY VARCHAR2
                           ,x_msg_count                 OUT NOCOPY NUMBER
                           ,x_msg_data                  OUT NOCOPY VARCHAR2
                           ,p_tapv_rec                  IN tapv_rec_type
                           ,x_tapv_rec                  OUT NOCOPY tapv_rec_type
                            )
  IS
   l_api_name      CONSTANT VARCHAR2(30)   := 'UPDATE_DISB_TRX';

Line: 1314

   OKL_TRX_AP_INVOICES_PUB.Update_trx_ap_invoices(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_tapv_rec         =>   l_tapv_rec
                                                 ,x_tapv_rec         =>   lx_tapv_rec);

Line: 1359

  END Update_Disb_Trx;

Line: 1366

		SELECT sum(lin.amount) khr_line_amount
		FROM ap_invoice_lines_all lin
		    ,okl_txl_ap_inv_lns_all_b tpl
		    ,fnd_application app
		WHERE lin.application_id = app.application_id
		AND   app.application_short_name = 'OKL'
		AND   lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
		AND   tpl.id = TO_NUMBER(lin.reference_key1)
		AND   lin.invoice_id = cp_invoice_id
		AND   tpl.khr_id = cp_khr_id;

Line: 1379

		SELECT sum(tpl.amount) khr_line_amount
		FROM ap_invoices_all ap
		    ,okl_txl_ap_inv_lns_all_b tpl
      	    ,okl_cnsld_ap_invs_all cin
		where ap.product_table = 'OKL_CNSLD_AP_INVS_ALL'
		AND   cin.cnsld_ap_inv_id = TO_NUMBER(ap.reference_key1)
		AND   tpl.cnsld_ap_inv_id = cin.cnsld_ap_inv_id
		AND   ap.invoice_id = cp_invoice_id
		AND   tpl.khr_id = cp_khr_id;