DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PRICING_PVT SQL Statements

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

Line: 31

    SELECT id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,reference_number
      ,status
      ,parent_object_code
      ,parent_object_id
      ,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
      ,rate_card_id
      ,rate_template_id
      ,target_rate_type
      ,target_rate
      ,target_amount
      ,target_frequency
      ,target_arrears_yn
      ,target_periods
      ,iir
      ,booking_yield
      ,pirr
      ,airr
      ,sub_iir
      ,sub_booking_yield
      ,sub_pirr
      ,sub_airr
      ,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
      ,structured_pricing
      ,line_level_pricing
      ,short_description
      ,description
      ,comments
      ,PRIMARY_QUOTE
    INTO
      l_lsqv_rec.id
      ,l_lsqv_rec.object_version_number
      ,l_lsqv_rec.attribute_category
      ,l_lsqv_rec.attribute1
      ,l_lsqv_rec.attribute2
      ,l_lsqv_rec.attribute3
      ,l_lsqv_rec.attribute4
      ,l_lsqv_rec.attribute5
      ,l_lsqv_rec.attribute6
      ,l_lsqv_rec.attribute7
      ,l_lsqv_rec.attribute8
      ,l_lsqv_rec.attribute9
      ,l_lsqv_rec.attribute10
      ,l_lsqv_rec.attribute11
      ,l_lsqv_rec.attribute12
      ,l_lsqv_rec.attribute13
      ,l_lsqv_rec.attribute14
      ,l_lsqv_rec.attribute15
      ,l_lsqv_rec.reference_number
      ,l_lsqv_rec.status
      ,l_lsqv_rec.parent_object_code
      ,l_lsqv_rec.parent_object_id
      ,l_lsqv_rec.valid_from
      ,l_lsqv_rec.valid_to
      ,l_lsqv_rec.customer_bookclass
      ,l_lsqv_rec.customer_taxowner
      ,l_lsqv_rec.expected_start_date
      ,l_lsqv_rec.expected_funding_date
      ,l_lsqv_rec.expected_delivery_date
      ,l_lsqv_rec.pricing_method
      ,l_lsqv_rec.term
      ,l_lsqv_rec.product_id
      ,l_lsqv_rec.end_of_term_option_id
      ,l_lsqv_rec.rate_card_id
      ,l_lsqv_rec.rate_template_id
      ,l_lsqv_rec.target_rate_type
      ,l_lsqv_rec.target_rate
      ,l_lsqv_rec.target_amount
      ,l_lsqv_rec.target_frequency
      ,l_lsqv_rec.target_arrears_yn
      ,l_lsqv_rec.target_periods
      ,l_lsqv_rec.iir
      ,l_lsqv_rec.booking_yield
      ,l_lsqv_rec.pirr
      ,l_lsqv_rec.airr
      ,l_lsqv_rec.sub_iir
      ,l_lsqv_rec.sub_booking_yield
      ,l_lsqv_rec.sub_pirr
      ,l_lsqv_rec.sub_airr
      ,l_lsqv_rec.usage_category
      ,l_lsqv_rec.usage_industry_class
      ,l_lsqv_rec.usage_industry_code
      ,l_lsqv_rec.usage_amount
      ,l_lsqv_rec.usage_location_id
      ,l_lsqv_rec.property_tax_applicable
      ,l_lsqv_rec.property_tax_billing_type
      ,l_lsqv_rec.upfront_tax_treatment
      ,l_lsqv_rec.upfront_tax_stream_type
      ,l_lsqv_rec.transfer_of_title
      ,l_lsqv_rec.age_of_equipment
      ,l_lsqv_rec.purchase_of_lease
      ,l_lsqv_rec.sale_and_lease_back
      ,l_lsqv_rec.interest_disclosed
      ,l_lsqv_rec.structured_pricing
      ,l_lsqv_rec.line_level_pricing
      ,l_lsqv_rec.short_description
      ,l_lsqv_rec.description
      ,l_lsqv_rec.comments
      ,l_lsqv_rec.PRIMARY_QUOTE
    FROM OKL_LEASE_QUOTES_V
    WHERE id = p_quote_id;
Line: 219

    SELECT id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,parent_object_code
      ,parent_object_id
      ,stream_type_id
      ,fee_type
      ,rate_card_id
      ,rate_template_id
      ,structured_pricing
      ,target_arrears
      ,effective_from
      ,effective_to
      ,supplier_id
      ,rollover_quote_id
      ,initial_direct_cost
      ,fee_amount
      ,target_amount
      ,target_frequency
      ,payment_type_id
      ,fee_purpose_code -- Bug#9708535
    INTO
      l_feev_rec.id
      ,l_feev_rec.object_version_number
      ,l_feev_rec.attribute_category
      ,l_feev_rec.attribute1
      ,l_feev_rec.attribute2
      ,l_feev_rec.attribute3
      ,l_feev_rec.attribute4
      ,l_feev_rec.attribute5
      ,l_feev_rec.attribute6
      ,l_feev_rec.attribute7
      ,l_feev_rec.attribute8
      ,l_feev_rec.attribute9
      ,l_feev_rec.attribute10
      ,l_feev_rec.attribute11
      ,l_feev_rec.attribute12
      ,l_feev_rec.attribute13
      ,l_feev_rec.attribute14
      ,l_feev_rec.attribute15
      ,l_feev_rec.parent_object_code
      ,l_feev_rec.parent_object_id
      ,l_feev_rec.stream_type_id
      ,l_feev_rec.fee_type
      ,l_feev_rec.rate_card_id
      ,l_feev_rec.rate_template_id
      ,l_feev_rec.structured_pricing
      ,l_feev_rec.target_arrears
      ,l_feev_rec.effective_from
      ,l_feev_rec.effective_to
      ,l_feev_rec.supplier_id
      ,l_feev_rec.rollover_quote_id
      ,l_feev_rec.initial_direct_cost
      ,l_feev_rec.fee_amount
      ,l_feev_rec.target_amount
      ,l_feev_rec.target_frequency
      ,l_feev_rec.payment_type_id
      ,l_feev_rec.fee_purpose_code -- Bug#9708535
    FROM okL_fees_V
    WHERE id = p_fee_id;
Line: 341

    SELECT id
      ,object_version_number
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,parent_object_code
      ,parent_object_id
      ,asset_number
      ,install_site_id
      ,rate_card_id
      ,rate_template_id
      ,oec
      ,end_of_term_value_default
      ,end_of_term_value
      ,oec_percentage
      ,target_amount
      ,target_frequency
      ,short_description
      ,description
      ,comments
    INTO
      l_assv_rec.id
      ,l_assv_rec.object_version_number
      ,l_assv_rec.attribute_category
      ,l_assv_rec.attribute1
      ,l_assv_rec.attribute2
      ,l_assv_rec.attribute3
      ,l_assv_rec.attribute4
      ,l_assv_rec.attribute5
      ,l_assv_rec.attribute6
      ,l_assv_rec.attribute7
      ,l_assv_rec.attribute8
      ,l_assv_rec.attribute9
      ,l_assv_rec.attribute10
      ,l_assv_rec.attribute11
      ,l_assv_rec.attribute12
      ,l_assv_rec.attribute13
      ,l_assv_rec.attribute14
      ,l_assv_rec.attribute15
      ,l_assv_rec.parent_object_code
      ,l_assv_rec.parent_object_id
      ,l_assv_rec.asset_number
      ,l_assv_rec.install_site_id
      ,l_assv_rec.rate_card_id
      ,l_assv_rec.rate_template_id
      ,l_assv_rec.oec
      ,l_assv_rec.end_of_term_value_default
      ,l_assv_rec.end_of_term_value
      ,l_assv_rec.oec_percentage
      ,l_assv_rec.target_amount
      ,l_assv_rec.target_frequency
      ,l_assv_rec.short_description
      ,l_assv_rec.description
      ,l_assv_rec.comments
    FROM OKL_ASSETS_V
    WHERE id = p_asset_id;
Line: 444

     SELECT count(*) overriden_assets_count
     FROM OKL_LEASE_QUOTES_B QTE,
          OKL_ASSETS_B AST
     WHERE AST.PARENT_OBJECT_ID = QTE.ID
     AND   (    AST.RATE_TEMPLATE_ID IS NOT NULL
             OR AST.STRUCTURED_PRICING = 'Y' )
     AND   QTE.ID = p_quote_id
     AND   p_line_level_pricing = 'Y';
Line: 454

     SELECT count(*) overriden_assets_count
     FROM OKL_LEASE_QUOTES_B QTE,
          OKL_ASSETS_B AST
     WHERE AST.PARENT_OBJECT_ID = QTE.ID
     AND   (    AST.RATE_CARD_ID IS NOT NULL
             OR AST.LEASE_RATE_FACTOR IS NOT NULL )
     AND   QTE.ID = p_quote_id
     AND   p_line_level_pricing = 'Y';
Line: 464

     SELECT count(*) overriden_assets_count
     FROM OKL_LEASE_QUOTES_B QTE,
          OKL_ASSETS_B AST
     WHERE AST.PARENT_OBJECT_ID = QTE.ID
     AND   (  AST.STRUCTURED_PRICING = 'Y')
     AND   QTE.ID = p_quote_id
     AND   p_line_level_pricing = 'Y';
Line: 473

     SELECT count(*) assets_count
     FROM OKL_LEASE_QUOTES_B QTE,
          OKL_ASSETS_B AST
     WHERE AST.PARENT_OBJECT_ID = QTE.ID
     AND   QTE.ID = p_quote_id;
Line: 950

    SELECT ID
    FROM   OKL_LEASE_QUOTES_B
    WHERE parent_object_id =p_parent_object_id
    AND   primary_quote = 'Y';
Line: 996

         OKL_LEASE_QUOTE_PVT.update_lease_qte(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_transaction_control  => G_FALSE
         ,p_lease_qte_rec        => l_lsqv_rec
         ,x_lease_qte_rec        => lx_lsqv_rec
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1105

  PROCEDURE create_update_payment (
     p_api_version             IN NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_lease_qte_rec           IN lease_qte_rec_type
    ,p_payment_header_rec      IN cashflow_hdr_rec_type
    ,p_payment_level_tbl       IN cashflow_level_tbl_type
    ,x_return_status           OUT NOCOPY VARCHAR2
    ,x_msg_count               OUT NOCOPY NUMBER
    ,x_msg_data                OUT NOCOPY VARCHAR2
    ) IS

    -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 1118

    l_api_name    CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
Line: 1138

    SELECT 'YES'
    FROM   OKL_CASH_FLOW_OBJECTS
    WHERE  OTY_CODE     = 'LEASE_QUOTE'
    AND    SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
    AND    SOURCE_ID    = p_quote_id;
Line: 1145

     SELECT ID
     FROM OKL_ASSETS_B
     WHERE parent_object_id = lc_quote_id
     AND   parent_object_code = 'LEASEQUOTE';
Line: 1151

     SELECT ID
     FROM OKL_FEES_B
     WHERE parent_object_id = lc_quote_id
     AND   parent_object_code = 'LEASEQUOTE'
     AND   fee_type <> 'CAPITALIZED';
Line: 1246

          okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
          ,'begin debug call update_lease_qte');
Line: 1249

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

          okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
          ,'end debug call update_lease_qte');
Line: 1270

            okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
            ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 1273

          okl_lease_quote_cashflow_pvt.delete_cashflows(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_transaction_control  => G_FALSE
         ,p_source_object_code   => 'LEASE_QUOTE'
         ,p_source_object_id     => p_lease_qte_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1283

            okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
             ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 1316

                 okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
                 ,'begin debug call update_cashflow');
Line: 1319

                OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
                                    p_api_version         => G_API_VERSION
                                   ,p_init_msg_list       => G_FALSE
                                   ,p_transaction_control => G_FALSE
                                   ,p_cashflow_header_rec => l_payment_header_rec
                                   ,p_cashflow_level_tbl  => l_payment_level_tbl
                                   ,x_return_status       => x_return_status
                                   ,x_msg_count           => x_msg_count
                                   ,x_msg_data            => x_msg_data);
Line: 1329

                 okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
                 ,'end debug call update_cashflow');
Line: 1369

         delete_line_payment(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_source_object_code   => 'QUOTED_ASSET'
         ,p_source_object_id     => l_quote_asset_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1387

         delete_line_payment(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_source_object_code   => 'QUOTED_FEE'
         ,p_source_object_id     => l_quote_fees_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1449

  END create_update_payment;
Line: 1466

  PROCEDURE create_update_payment (
     p_api_version             IN NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_lease_qte_rec           IN lease_qte_rec_type
    ,x_return_status           OUT NOCOPY VARCHAR2
    ,x_msg_count               OUT NOCOPY NUMBER
    ,x_msg_data                OUT NOCOPY VARCHAR2
    ) IS

    -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 1477

    l_api_name    CONSTANT VARCHAR2(30) DEFAULT 'CREATE_UPDATE_PAYMENT';
Line: 1494

     SELECT ID
     FROM OKL_ASSETS_B
     WHERE parent_object_id = lc_quote_id
     AND   parent_object_code = 'LEASEQUOTE';
Line: 1500

     SELECT ID
     FROM OKL_FEES_B
     WHERE parent_object_id = lc_quote_id
     AND   parent_object_code = 'LEASEQUOTE'
     AND   fee_type <> 'CAPITALIZED';
Line: 1606

           okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
           ,'begin debug call update_lease_qte');
Line: 1609

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

             okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_PVT.update_lease_qte'
             ,'End debug call update_lease_qte');
Line: 1630

            okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
            ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 1633

        okl_lease_quote_cashflow_pvt.delete_cashflows(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_transaction_control  => G_FALSE
         ,p_source_object_code   => 'LEASE_QUOTE'
         ,p_source_object_id     => p_lease_qte_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1643

            okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
            ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 1656

         delete_line_payment(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_source_object_code   => 'QUOTED_ASSET'
         ,p_source_object_id     => l_quote_asset_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1674

         delete_line_payment(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_source_object_code   => 'QUOTED_FEE'
         ,p_source_object_id     => l_quote_fees_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 1736

  END create_update_payment;
Line: 1753

  PROCEDURE create_update_line_payment (
     p_api_version             IN NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_fee_rec                 IN fee_rec_type
    ,p_asset_rec               IN asset_rec_type
    ,p_payment_header_rec      IN cashflow_hdr_rec_type
    ,p_payment_level_tbl       IN cashflow_level_tbl_type
    ,x_return_status           OUT NOCOPY VARCHAR2
    ,x_msg_count               OUT NOCOPY NUMBER
    ,x_msg_data                OUT NOCOPY VARCHAR2
    ) IS

    -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 1791

    SELECT 'YES'
    FROM   OKL_CASH_FLOW_OBJECTS
    WHERE OTY_CODE = 'QUOTED_ASSET'
    AND   SOURCE_TABLE = 'OKL_ASSETS_B'
    AND   SOURCE_ID    = p_asset_id;
Line: 1799

    SELECT 'YES'
    FROM   OKL_CASH_FLOW_OBJECTS
    WHERE OTY_CODE = 'QUOTED_FEE'
    AND   SOURCE_TABLE = 'OKL_FEES_B'
    AND   SOURCE_ID    = p_fee_id;
Line: 1851

        okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
        ,'begin debug call update_row');
Line: 1854

     OKL_FEE_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_feev_rec       => l_fee_rec
       ,x_feev_rec       => lx_fee_rec
       );
Line: 1864

        okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
        ,'end debug call update_row');
Line: 1880

     SELECT pricing_method
     INTO l_pricing_method
     FROM okl_lease_quotes_b
     where id = l_fee_Rec.parent_object_id;
Line: 1902

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
         ,'begin debug call update_row');
Line: 1905

     OKL_ASS_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_assv_rec      => l_asset_rec
                           ,x_assv_rec      => lx_asset_rec );
Line: 1913

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
         ,'end debug call update_row');
Line: 1928

     SELECT pricing_method
     INTO l_pricing_method
     FROM okl_lease_quotes_b
     where id = l_asset_rec.parent_object_id;
Line: 1968

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
         ,'begin debug call update_cashflow');
Line: 1971

       OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
                            p_api_version   => G_API_VERSION
                           ,p_init_msg_list => G_FALSE
                           ,p_transaction_control => G_FALSE
                           ,p_cashflow_header_rec => l_payment_header_rec
                           ,p_cashflow_level_tbl => l_payment_level_tbl
                           ,x_return_status => x_return_status
                           ,x_msg_count     => x_msg_count
                           ,x_msg_data      => x_msg_data);
Line: 1981

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
         ,'end debug call update_cashflow');
Line: 2024

   /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
   FROM okl_lease_quotes_b where ID = nvl(l_fee_rec.parent_object_id,l_Asset_rec.parent_object_id);
Line: 2071

  END create_update_line_payment;
Line: 2087

  PROCEDURE create_update_line_payment (
     p_api_version             IN NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_fee_rec                 IN fee_rec_type
    ,x_return_status           OUT NOCOPY VARCHAR2
    ,x_msg_count               OUT NOCOPY NUMBER
    ,x_msg_data                OUT NOCOPY VARCHAR2
    ) IS

   -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 2155

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
         ,'begin debug call update_row');
Line: 2158

    OKL_FEE_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_feev_rec       => l_fee_rec
     ,x_feev_rec       => lx_fee_rec
     );
Line: 2168

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
         ,'end debug call update_row');
Line: 2179

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
         ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 2182

        okl_lease_quote_cashflow_pvt.delete_cashflows(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_transaction_control  => G_FALSE
         ,p_source_object_code   => 'QUOTED_FEE'
         ,p_source_object_id     => p_fee_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 2192

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
         ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 2202

   /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
   FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
Line: 2250

  END create_update_line_payment;
Line: 2267

  PROCEDURE create_update_line_payment (
     p_api_version             IN NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_asset_rec               IN asset_rec_type
    ,x_return_status           OUT NOCOPY VARCHAR2
    ,x_msg_count               OUT NOCOPY NUMBER
    ,x_msg_data                OUT NOCOPY VARCHAR2
    ) IS

    -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 2326

       okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
        ,'begin debug call update_row');
Line: 2329

    OKL_ASS_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_assv_rec      => l_asset_rec
                           ,x_assv_rec      => lx_asset_rec );
Line: 2337

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
         ,'begin debug call update_row');
Line: 2348

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
         ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 2351

        okl_lease_quote_cashflow_pvt.delete_cashflows(
          p_api_version          => G_API_VERSION
         ,p_init_msg_list        => G_FALSE
         ,p_transaction_control  => G_FALSE
         ,p_source_object_code   => 'QUOTED_ASSET'
         ,p_source_object_id     => p_asset_rec.id
         ,x_return_status        => x_return_status
         ,x_msg_count            => x_msg_count
         ,x_msg_data             => x_msg_data);
Line: 2361

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
         ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
Line: 2371

   /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
   FROM okl_lease_quotes_b where ID = l_asset_rec.parent_object_id;
Line: 2419

  END create_update_line_payment;
Line: 2436

  PROCEDURE delete_line_payment(
     p_api_version             IN NUMBER
    ,p_init_msg_list           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

    -- Variables Declarations
    l_api_version CONSTANT NUMBER       DEFAULT 1.0;
Line: 2448

    l_api_name    CONSTANT VARCHAR2(30) DEFAULT 'DELETE_LINE_PAYMENT';
Line: 2467

    SELECT 'YES'
    FROM   OKL_CASH_FLOW_OBJECTS
    WHERE OTY_CODE = p_source_code
    AND   SOURCE_ID = p_source_id;
Line: 2515

        okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
        ,'begin debug call update_row');
Line: 2518

     OKL_FEE_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_feev_rec       => l_fee_rec
       ,x_feev_rec       => lx_fee_rec
       );
Line: 2528

        okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_FEE_PVT.update_row'
        ,'end debug call update_row');
Line: 2549

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
         ,'begin debug call update_row');
Line: 2552

     OKL_ASS_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_assv_rec      => l_asset_rec
                           ,x_assv_rec      => lx_asset_rec );
Line: 2561

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_ASS_PVT.update_row'
         ,'end debug call update_row');
Line: 2578

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
         ,'begin debug call delete_cashflows');
Line: 2581

       OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
                            p_api_version   => G_API_VERSION
                           ,p_init_msg_list => G_FALSE
                           ,p_transaction_control => G_FALSE
                           ,p_source_object_code => l_source_object_code
                           ,p_source_object_id => l_source_object_id
                           ,x_return_status => x_return_status
                           ,x_msg_count     => x_msg_count
                           ,x_msg_data      => x_msg_data);
Line: 2592

         okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
         ,'end debug call delete_cashflows');
Line: 2637

  END delete_line_payment;
Line: 2661

         SELECT   STUB_DAYS,
                  STUB_AMOUNT
         FROM   OKL_CASH_FLOW_LEVELS
         WHERE  CAF_ID = l_cashflow_id;
Line: 2667

           SELECT SUM(NUMBER_OF_PERIODS)
           FROM   OKL_CASH_FLOW_LEVELS
           WHERE  CAF_ID = l_cashflow_id;
Line: 2733

         SELECT   STUB_DAYS,
                  STUB_AMOUNT
         FROM   OKL_CASH_FLOW_LEVELS
         WHERE  CAF_ID = l_cashflow_id;
Line: 2739

           SELECT COUNT(ID)
           FROM   OKL_CASH_FLOW_LEVELS
           WHERE  CAF_ID = l_cashflow_id;
Line: 2744

           SELECT AMOUNT
           FROM   OKL_CASH_FLOW_LEVELS
           WHERE  CAF_ID = l_cashflow_id;