APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT SQL Statements

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

Line: 17

      SELECT id
      FROM   okl_cash_flow_levels
      WHERE  caf_id = p_cf_header_id
      ORDER BY start_date;

Line: 422

        IF UPPER(p_cashflow_level_tbl(i).record_mode) NOT IN ('CREATE', 'UPDATE') OR p_cashflow_level_tbl(i).record_mode IS NULL THEN
          OKL_API.SET_MESSAGE (
            p_app_name     => G_APP_NAME
           ,p_msg_name     => 'OKL_INVALID_VALUE2'
           ,p_token1       => 'API_NAME'
           ,p_token1_value => UPPER(l_api_name)
           ,p_token2       => 'NAME'
           ,p_token2_value => '('||i||') record_mode'
           ,p_token3       => 'VALUE'
           ,p_token3_value => UPPER(p_cashflow_level_tbl(i).record_mode)
           );

Line: 601

      SELECT
        lop.currency_code
       ,lsq.expected_start_date
       ,lsq.term
       ,lsq.pricing_method
      FROM
        okl_lease_quotes_b lsq
       ,okl_lease_opportunities_b lop
      WHERE lsq.id = p_quote_id
        AND lsq.parent_object_code = 'LEASEOPP'
        AND lsq.parent_object_id = lop.id;

Line: 614

      SELECT
        lap.currency_code
       ,lsq.expected_start_date
       ,lsq.term
       ,lsq.pricing_method
      FROM
        okl_lease_quotes_b lsq
       ,okl_lease_applications_b lap
      WHERE lsq.id = p_quote_id
        AND lsq.parent_object_code = 'LEASEAPP'
        AND lsq.parent_object_id = lap.id;

Line: 627

      SELECT
        currency_code
       ,expected_start_date
       ,term
       ,pricing_method
      FROM
        okl_quick_quotes_b
      WHERE id = p_quote_id;

Line: 802

  PROCEDURE insert_rows (
    p_cashflow_header_rec IN  OUT NOCOPY cashflow_header_rec_type
   ,p_cashflow_level_tbl  IN  OUT NOCOPY cashflow_level_tbl_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) := 'insert_rows';

Line: 856

    okl_cfo_pvt.insert_row (
      p_api_version   => G_API_VERSION
     ,p_init_msg_list => G_FALSE
     ,x_return_status => x_return_status
     ,x_msg_count     => x_msg_count
     ,x_msg_data      => x_msg_data
     ,p_cfov_rec      => l_cfov_rec
     ,x_cfov_rec      => lx_cfov_rec
     );

Line: 891

    okl_caf_pvt.insert_row (
      p_api_version   => G_API_VERSION
     ,p_init_msg_list => G_FALSE
     ,x_return_status => x_return_status
     ,x_msg_count     => x_msg_count
     ,x_msg_data      => x_msg_data
     ,p_cafv_rec      => l_cafv_rec
     ,x_cafv_rec      => lx_cafv_rec
     );

Line: 922

    okl_cfl_pvt.insert_row (
      p_api_version   => G_API_VERSION
     ,p_init_msg_list => G_FALSE
     ,x_return_status => x_return_status
     ,x_msg_count     => x_msg_count
     ,x_msg_data      => x_msg_data
     ,p_cflv_tbl      => l_cflv_tbl
     ,x_cflv_tbl      => lx_cflv_tbl
     );

Line: 973

  END insert_rows;

Line: 979

  PROCEDURE insert_update_rows (
    p_cashflow_header_rec IN OUT NOCOPY cashflow_header_rec_type
   ,p_cashflow_level_tbl  IN OUT NOCOPY cashflow_level_tbl_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) := 'insert_update_rows';

Line: 1006

    okl_caf_pvt.update_row (
      p_api_version   => G_API_VERSION
     ,p_init_msg_list => G_FALSE
     ,x_return_status => x_return_status
     ,x_msg_count     => x_msg_count
     ,x_msg_data      => x_msg_data
     ,p_cafv_rec      => l_cafv_rec
     ,x_cafv_rec      => lx_cafv_rec
     );

Line: 1035

        ELSIF UPPER(p_cashflow_level_tbl(i).record_mode) = 'UPDATE' THEN
          l_cflv_upd_tbl(i).id                    := p_cashflow_level_tbl(i).cashflow_level_id;

Line: 1053

      okl_cfl_pvt.insert_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cflv_tbl      => l_cflv_ins_tbl
       ,x_cflv_tbl      => lx_cflv_tbl
       );

Line: 1073

      okl_cfl_pvt.update_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cflv_tbl      => l_cflv_upd_tbl
       ,x_cflv_tbl      => lx_cflv_tbl
       );

Line: 1123

  END insert_update_rows;

Line: 1129

  PROCEDURE get_deleted_cashflow_levels (p_cashflow_header_id            IN  NUMBER,
                                p_cashflow_level_tbl       IN  cashflow_level_tbl_type,
                                x_deleted_cashflow_level_tbl   OUT NOCOPY cflv_tbl_type,
                                x_return_status       OUT NOCOPY VARCHAR2) IS

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

Line: 1138

      SELECT id
      FROM   okl_cash_flow_levels
      WHERE  caf_id = p_cashflow_header_id;

Line: 1143

    l_delete_flag          VARCHAR2(1);

Line: 1150

        l_delete_flag := 'Y';

Line: 1154

              l_delete_flag := 'N';

Line: 1159

        IF l_delete_flag = 'Y' THEN
          l_cashflow_level_tbl(i).id := l_db_cashflow_levels.id;

Line: 1171

    x_deleted_cashflow_level_tbl := l_cashflow_level_tbl;

Line: 1194

  END get_deleted_cashflow_levels;

Line: 1211

    l_deleted_cf_level_tbl   cflv_tbl_type;

Line: 1218

    get_deleted_cashflow_levels (
      p_cashflow_header_id         => p_cashflow_header_rec.cashflow_header_id
     ,p_cashflow_level_tbl         => p_cashflow_level_tbl
     ,x_deleted_cashflow_level_tbl => l_deleted_cf_level_tbl
     ,x_return_status              => x_return_status
     );

Line: 1231

    IF l_deleted_cf_level_tbl.COUNT > 0 THEN

      okl_cfl_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cflv_tbl      => l_deleted_cf_level_tbl
       );

Line: 1254

      okl_caf_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cafv_rec      => l_cafv_rec
       );

Line: 1271

      okl_cfo_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cfov_rec      => l_cfov_rec
       );

Line: 1353

    insert_rows (
      p_cashflow_header_rec => p_cashflow_header_rec
     ,p_cashflow_level_tbl  => p_cashflow_level_tbl
     ,x_return_status       => x_return_status
     ,x_msg_count           => x_msg_count
     ,x_msg_data            => x_msg_data
     );

Line: 1411

  PROCEDURE update_cashflow (
     p_api_version             IN  NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_transaction_control     IN  VARCHAR2
    ,p_cashflow_header_rec     IN  OUT NOCOPY cashflow_header_rec_type
    ,p_cashflow_level_tbl      IN  OUT NOCOPY cashflow_level_tbl_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_cashflow';

Line: 1465

    insert_update_rows (
      p_cashflow_header_rec => p_cashflow_header_rec
     ,p_cashflow_level_tbl  => p_cashflow_level_tbl
     ,x_return_status       => x_return_status
     ,x_msg_count           => x_msg_count
     ,x_msg_data            => x_msg_data
     );

Line: 1517

  END update_cashflow;

Line: 1558

    SELECT pricing_method,status,parent_object_code
    FROM OKL_LEASE_QUOTES_B
    where id = p_lease_quote_id;

Line: 1564

    SELECT id
    FROM   okl_cash_flow_objects
    WHERE
           oty_code = p_oty_code
    AND    source_table = p_source_table
    AND    source_id = p_source_id;

Line: 1573

    SELECT id, sty_id, due_arrears_yn, cft_code , sts_code
    FROM   okl_cash_flows
    WHERE  cfo_id = p_cfo_id;

Line: 1580

    SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate , missing_pmt_flag
    FROM   OKL_CASH_FLOW_LEVELS
    WHERE caf_id = p_caf_id;

Line: 1641

          SELECT parent_object_code
          INTO lv_parent_object_code
          FROM okl_lease_quotes_b
          WHERE id = p_quote_id;*/

Line: 1662

      l_cashflow_level_tbl.delete;

Line: 1788

  PROCEDURE delete_cashflows (
     p_api_version             IN  NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_transaction_control     IN  VARCHAR2
    ,p_source_object_code      IN  VARCHAR2
    ,p_source_object_id        IN  NUMBER
    ,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) := 'delete_cashflows';

Line: 1819

    DELETE FROM okl_cash_flow_levels WHERE caf_id IN
      (SELECT id FROM okl_cash_flows WHERE cfo_id IN
        (SELECT id
         FROM okl_cash_flow_objects
         WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
        )
       );

Line: 1827

    DELETE FROM okl_cash_flows WHERE cfo_id IN
        (SELECT id
         FROM okl_cash_flow_objects
         WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id
        );

Line: 1833

    DELETE FROM okl_cash_flow_objects
    WHERE oty_code = p_source_object_code AND source_table = l_source_table AND source_id = p_source_object_id;

Line: 1876

  END delete_cashflows;

Line: 1882

  PROCEDURE delete_cashflow (
     p_api_version             IN  NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_transaction_control     IN  VARCHAR2
    ,p_cashflow_header_id      IN  NUMBER
    ,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) := 'delete_cashflow';

Line: 1897

    DELETE FROM okl_cash_flow_levels WHERE caf_id = p_cashflow_header_id;

Line: 1898

    DELETE FROM okl_cash_flows WHERE id = p_cashflow_header_id;

Line: 1943

  END delete_cashflow;

Line: 1949

  PROCEDURE delete_cashflow_level (
     p_api_version             IN  NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_transaction_control     IN  VARCHAR2
    ,p_cashflow_level_id       IN  NUMBER
    ,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) := 'delete_cashflow_level';

Line: 1964

    DELETE FROM okl_cash_flow_levels WHERE id = p_cashflow_level_id;

Line: 2006

  END delete_cashflow_level;

Line: 2025

    l_deleted_cf_level_tbl   cflv_tbl_type;

Line: 2039

      SELECT id
      FROM   okl_cash_flows
      WHERE  sts_code = 'WORK'
      AND DNZ_QTE_ID = p_quote_id;

Line: 2045

      SELECT distinct a.id
      FROM   okl_cash_flow_levels a,
             okl_cash_flows b
      WHERE  a.caf_id = b.id
      AND b.sts_code = 'WORK'
      AND B.DNZ_QTE_ID = p_quote_id;

Line: 2053

      SELECT cfo_id
      FROM   okl_cash_flows
      WHERE  sts_code = 'WORK'
      AND DNZ_QTE_ID = p_quote_id;

Line: 2059

      SELECT distinct a.id, a.object_version_number
      FROM   okl_cash_flow_levels a,
             okl_cash_flows b,
             okl_lease_quotes_b qte
      WHERE  a.caf_id = b.id
      AND a.missing_pmt_flag = 'Y'
      AND B.DNZ_QTE_ID = p_quote_id
      AND B.DNZ_QTE_ID = qte.id
      AND qte.pricing_method = 'SM';

Line: 2070

        select cdj.id
        from okl_cost_adjustments_b cdj,
        okl_assets_b ast
        where cdj.adjustment_source_type = p_adj_src_type
        and cdj.parent_object_code ='ASSET'
        and cdj.parent_object_id = ast.id
        and ast.parent_object_code = 'LEASEQUOTE'
        and ast.parent_object_id = p_qte_id;

Line: 2082

        l_deleted_cf_level_tbl(i).id := l_db_cashflow_levels.id;

Line: 2087

    IF l_deleted_cf_level_tbl.COUNT > 0 THEN

      okl_cfl_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cflv_tbl      => l_deleted_cf_level_tbl
       );

Line: 2110

      okl_cfo_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cfov_rec      => l_cfov_rec
       );

Line: 2131

      okl_caf_pvt.delete_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cafv_rec      => l_cafv_rec
       );

Line: 2161

      okl_cfl_pvt.update_row (
        p_api_version   => G_API_VERSION
       ,p_init_msg_list => G_FALSE
       ,x_return_status => x_return_status
       ,x_msg_count     => x_msg_count
       ,x_msg_data      => x_msg_data
       ,p_cflv_tbl      => l_sm_cashflow_levels_tbl
       ,x_cflv_tbl      => x_sm_cashflow_levels_tbl
       );

Line: 2181

    SELECT pricing_method
    INTO l_pricing_method
    FROM okl_lease_quotes_b
    WHERE ID = p_quote_id;

Line: 2204

        okl_cdj_pvt.delete_row (
                                p_api_version   => G_API_VERSION
                               ,p_init_msg_list => G_FALSE
                               ,x_return_status => x_return_status
                               ,x_msg_count     => x_msg_count
                               ,x_msg_data      => x_msg_data
                               ,p_cdjv_tbl      => l_cdjv_tbl
                               );

Line: 2226

    OKL_LEASE_QUOTE_PVT.update_lease_qte (
               p_api_version   => G_API_VERSION
              ,p_init_msg_list => G_FALSE
              ,p_transaction_control   => G_TRUE
              ,p_lease_qte_rec => l_lease_qte_rec
              ,x_lease_qte_rec => x_lease_qte_rec
              ,x_return_status => x_return_status
              ,x_msg_count     => x_msg_count
              ,x_msg_data      => x_msg_data);

Line: 2295

      SELECT  id,
              expected_start_date,
              term,
              end_of_term_option_id,
              pricing_method,
              structured_pricing,
              rate_template_id,
              rate_card_id,
              target_amount,
              target_arrears,
              target_frequency,
              lease_rate_factor,
              target_rate,
              target_rate_type,
              target_periods
      FROM  okl_quick_quotes_b where
      id = p_estimate_id;

Line: 2315

      SELECT
         attribute_category
        ,attribute1
        ,attribute2
        ,attribute3
        ,attribute4
        ,attribute5
        ,attribute6
        ,attribute7
        ,attribute8
        ,attribute9
        ,attribute10
        ,attribute11
        ,attribute12
        ,attribute13
        ,attribute14
        ,attribute15
        ,reference_number
        ,object_version_number
		,parent_object_id
		,parent_object_code
		,valid_from
		,valid_to
		,customer_bookclass
		,customer_taxowner
		,expected_start_date
		,expected_funding_date
		,expected_delivery_date
		,pricing_method
		,term
		,product_id
		,end_of_term_option_id
		,usage_category
		,usage_industry_class
		,usage_industry_code
		,usage_amount
		,usage_location_id
		,property_tax_applicable
		,property_tax_billing_type
		,upfront_tax_treatment
		,upfront_tax_stream_type
		,transfer_of_title
		,age_of_equipment
		,purchase_of_lease
		,sale_and_lease_back
		,interest_disclosed
		,target_rate_type
		,target_rate
		,target_amount
		,target_frequency
		,target_arrears_yn
		,target_periods
		,structured_pricing
		,line_level_pricing
		,lease_rate_factor
		,rate_card_id
		,rate_template_id
		,iir
		,booking_yield
		,pirr
		,airr
		,sub_iir
		,sub_booking_yield
		,sub_pirr
		,sub_airr
		,primary_quote
        ,short_description
        ,description
        ,comments
    FROM okl_lease_quotes_v
    where id= p_quote_id;

Line: 2393

    SELECT STRM.STY_ID PAYMENT_TYPE_ID,
           STRM.STY_NAME PAYMENT_TYPE,
           STRM.START_DATE,
           STRM.END_DATE,
           STRM.STY_PURPOSE
    FROM OKL_STRM_TMPT_PRIMARY_UV STRM
    WHERE STY_PURPOSE = strm_purpose
      AND START_DATE <= expStartDate
      AND NVL(END_DATE, expStartDate) >= expStartDate
      AND STRM.PDT_ID = pdtId;

Line: 2406

    SELECT id
    FROM   okl_cash_flow_objects
    WHERE
           oty_code = p_oty_code
    AND    source_table = p_source_table
    AND    source_id = p_source_id;

Line: 2415

    SELECT id, sty_id, due_arrears_yn, cft_code
    FROM   okl_cash_flows
    WHERE  cfo_id = p_cfo_id;

Line: 2421

    SELECT amount, number_of_periods, fqy_code, stub_days, stub_amount, rate
    FROM   OKL_CASH_FLOW_LEVELS
    WHERE caf_id = p_caf_id;

Line: 2514

              l_cashflow_level_tbl.delete;

Line: 2559

       OKL_LEASE_QUOTE_PVT.update_lease_qte (
                   p_api_version   => G_API_VERSION
                  ,p_init_msg_list => G_FALSE
                  ,p_transaction_control   => G_TRUE
                  ,p_lease_qte_rec => l_lease_qte_rec
                  ,x_lease_qte_rec => x_lease_qte_rec
                  ,x_return_status => x_return_status
                  ,x_msg_count     => x_msg_count
                  ,x_msg_data      => x_msg_data);