DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PUB SQL Statements

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

Line: 220

  PROCEDURE insert_end_of_term_option(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_ethv_rec      IN            okl_ethv_rec
                                     ,p_eve_rec       IN            okl_eve_rec
                                     ,p_eto_tbl       IN            okl_eto_tbl
                                     ,p_etv_tbl       IN            okl_etv_tbl
                                     ,x_ethv_rec         OUT NOCOPY okl_ethv_rec
                                     ,x_eve_rec          OUT NOCOPY okl_eve_rec
                                     ,x_eto_tbl          OUT NOCOPY okl_eto_tbl
                                     ,x_etv_tbl          OUT NOCOPY okl_etv_tbl) AS
    l_api_name                   VARCHAR2(40) := 'INSERT_PURCHASE_OPTION';
Line: 254

    okl_fe_eo_term_options_pvt.insert_end_of_term_option(l_api_version
                                                        ,p_init_msg_list
                                                        ,l_return_status
                                                        ,x_msg_count
                                                        ,x_msg_data
                                                        ,p_ethv_rec
                                                        ,p_eve_rec
                                                        ,p_eto_tbl
                                                        ,p_etv_tbl
                                                        ,x_ethv_rec
                                                        ,x_eve_rec
                                                        ,x_eto_tbl
                                                        ,x_etv_tbl);
Line: 298

  END insert_end_of_term_option;
Line: 300

  PROCEDURE update_end_of_term_option(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_eve_rec       IN            okl_eve_rec
                                     ,p_eto_tbl       IN            okl_eto_tbl
                                     ,p_etv_tbl       IN            okl_etv_tbl
                                     ,x_eve_rec          OUT NOCOPY okl_eve_rec
                                     ,x_eto_tbl          OUT NOCOPY okl_eto_tbl
                                     ,x_etv_tbl          OUT NOCOPY okl_etv_tbl) AS
    l_api_name                   VARCHAR2(40) := 'UPDATE_PURCHASE_OPTION';
Line: 332

    okl_fe_eo_term_options_pvt.update_end_of_term_option(l_api_version
                                                        ,p_init_msg_list
                                                        ,l_return_status
                                                        ,x_msg_count
                                                        ,x_msg_data
                                                        ,p_eve_rec
                                                        ,p_eto_tbl
                                                        ,p_etv_tbl
                                                        ,x_eve_rec
                                                        ,x_eto_tbl
                                                        ,x_etv_tbl);
Line: 374

  END update_end_of_term_option;