APPS.OKL_LEASE_OPPORTUNITY_PVT SQL Statements

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

Line: 5

    SELECT OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE
    FROM DUAL;

Line: 21

      SELECT '1'
      FROM okl_lease_opportunities_b
      WHERE  reference_number = p_reference_number
      AND    id <> NVL(p_lease_opp_rec.id, -9999);

Line: 217

    okl_lop_pvt.insert_row(
                       p_api_version   => G_API_VERSION
                      ,p_init_msg_list => G_TRUE
                      ,x_return_status => l_return_status
                      ,x_msg_count     => x_msg_count
                      ,x_msg_data      => x_msg_data
                      ,p_lopv_rec      => l_lease_opp_rec
                      ,x_lopv_rec      => x_lease_opp_rec
                      );

Line: 235

      UPDATE okl_quick_quotes_b SET
        lease_opportunity_id = x_lease_opp_rec.id
       ,currency_code = l_lease_opp_rec.currency_code
       ,program_agreement_id = l_lease_opp_rec.program_agreement_id
      WHERE id = p_quick_quote_id;

Line: 289

  PROCEDURE update_lease_opp (p_api_version             IN  NUMBER,
                              p_init_msg_list           IN  VARCHAR2,
                              p_transaction_control     IN  VARCHAR2,
                              p_lease_opp_rec           IN  lease_opp_rec_type,
                              x_lease_opp_rec           OUT NOCOPY lease_opp_rec_type,
                              x_return_status           OUT NOCOPY VARCHAR2,
                              x_msg_count               OUT NOCOPY NUMBER,
                              x_msg_data                OUT NOCOPY VARCHAR2) IS

    l_program_name         CONSTANT VARCHAR2(30) := 'update_lease_opp';

Line: 354

    okl_lop_pvt.update_row(
                       p_api_version   => G_API_VERSION
                      ,p_init_msg_list => G_TRUE
                      ,x_return_status => l_return_status
                      ,x_msg_count     => x_msg_count
                      ,x_msg_data      => x_msg_data
                      ,p_lopv_rec      => l_lease_opp_rec
                      ,x_lopv_rec      => x_lease_opp_rec);

Line: 408

  END update_lease_opp;

Line: 429

      SELECT lsq.id
      FROM   okl_lease_quotes_b lsq
      WHERE  lsq.parent_object_code = 'LEASEOPP'
        AND  lsq.parent_object_id = p_lease_opp_id;

Line: 435

      SELECT qqh.id
      FROM   okl_quick_quotes_b qqh
      WHERE  lease_opportunity_id = p_lease_opp_id;

Line: 443

      DELETE FROM okl_quick_quote_lines_tl WHERE id IN (SELECT id FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id);

Line: 444

      DELETE FROM okl_quick_quote_lines_b WHERE quick_quote_id = l_qqh.id;

Line: 445

      DELETE FROM okl_quick_quotes_b WHERE id = l_qqh.id;

Line: 446

      DELETE FROM okl_quick_quotes_tl WHERE id = l_qqh.id;

Line: 538

	Select object_version_number
	into l_lopv_rec.object_version_number
	from Okl_lease_opportunities_b
	where id = p_lease_opp_id;

Line: 543

    update_lease_opp (p_api_version          => p_api_version
                      ,p_init_msg_list       => p_init_msg_list
                      ,p_transaction_control => p_transaction_control
                      ,p_lease_opp_rec       => l_lopv_rec
                      ,x_lease_opp_rec       => q_lopv_rec
                      ,x_return_status       => l_return_status
                      ,x_msg_count           => x_msg_count
                      ,x_msg_data            => x_msg_data);

Line: 642

      SELECT property_tax_applicable,
             bill_property_tax
      FROM   okl_property_tax_setups
      WHERE  org_id = mo_global.get_current_org_id();

Line: 648

      SELECT okl_util.get_next_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER') FROM DUAL;--Bug 7022258-Modified by kkorrapo

Line: 651

       SELECT rep.salesrep_id sales_rep_id
              ,rep.name sales_rep_name
       FROM   jtf_rs_salesreps rep
              ,jtf_rs_resource_extns res
       WHERE  rep.org_id = mo_global.get_current_org_id()
       AND    rep.resource_id = res.resource_id
       AND    res.user_id = G_USER_ID;

Line: 660

      SELECT descriptive_flexfield_name
      FROM   fnd_descriptive_flexs
      WHERE  table_application_id = 540
      AND    application_table_name = 'OKL_LEASE_OPPORTUNITIES_B'
      AND    context_column_name = 'ATTRIBUTE_CATEGORY'
      AND    freeze_flex_definition_flag = 'Y';