APPS.OKL_LEASE_QUOTE_INS_PVT SQL Statements

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

Line: 78

  PROCEDURE insert_row (
     p_insurance_estimate_rec  IN  OUT NOCOPY ins_est_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) := 'insert_row';

Line: 115

    okl_que_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_quev_rec            => l_quev_rec
     ,x_quev_rec            => lx_quev_rec
     );

Line: 153

  END insert_row;

Line: 159

  PROCEDURE update_row (
     p_insurance_estimate_rec  IN  ins_est_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_row';

Line: 198

    okl_que_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_quev_rec            => l_quev_rec
     ,x_quev_rec            => lx_quev_rec
     );

Line: 234

  END update_row;

Line: 325

  PROCEDURE update_cashflow (
     p_insurance_estimate_rec  IN  ins_est_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_cashflow';

Line: 368

    l_cashflow_level_tbl(1).record_mode         := 'UPDATE';

Line: 370

    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_cashflow_header_rec
     ,p_cashflow_level_tbl  => l_cashflow_level_tbl
     ,x_return_status       => x_return_status
     ,x_msg_count           => x_msg_count
     ,x_msg_data            => x_msg_data
     );

Line: 409

  END update_cashflow;

Line: 434

    SELECT parent_object_code
    FROM okl_lease_quotes_b
    WHERE id = p_insurance_estimate_rec.lease_quote_id;

Line: 479

    insert_row (
      p_insurance_estimate_rec  => l_insurance_estimate_rec
     ,x_return_status           => x_return_status
     ,x_msg_count               => x_msg_count
     ,x_msg_data                => x_msg_data
     );

Line: 552

  PROCEDURE update_insurance_estimate (
    p_api_version             IN  NUMBER
   ,p_init_msg_list           IN  VARCHAR2
   ,p_transaction_control     IN  VARCHAR2
   ,p_insurance_estimate_rec  IN  ins_est_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_insurance_estimate';

Line: 569

    SELECT parent_object_code
    FROM okl_lease_quotes_b
    WHERE id = p_insurance_estimate_rec.lease_quote_id;

Line: 610

    update_row (
      p_insurance_estimate_rec  => l_insurance_estimate_rec
     ,x_return_status           => x_return_status
     ,x_msg_count               => x_msg_count
     ,x_msg_data                => x_msg_data
     );

Line: 623

    update_cashflow (
      p_insurance_estimate_rec => l_insurance_estimate_rec
     ,x_return_status          => x_return_status
     ,x_msg_count              => x_msg_count
     ,x_msg_data               => x_msg_data
     );

Line: 676

  END update_insurance_estimate;

Line: 682

  PROCEDURE delete_insurance_estimate (
     p_api_version             IN  NUMBER
    ,p_init_msg_list           IN  VARCHAR2
    ,p_transaction_control     IN  VARCHAR2
    ,p_insurance_estimate_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_insurance_estimate';

Line: 705

    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_INSURANCE'
     ,p_source_object_id    => p_insurance_estimate_id
     ,x_return_status       => x_return_status
     ,x_msg_count           => x_msg_count
     ,x_msg_data            => x_msg_data
    );

Line: 722

    DELETE FROM okl_insurance_estimates_tl WHERE id = p_insurance_estimate_id;

Line: 723

    DELETE FROM okl_insurance_estimates_b WHERE id = p_insurance_estimate_id;

Line: 765

  END delete_insurance_estimate;