APPS.OKL_FE_STD_RATE_TMPL_PUB SQL Statements

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

Line: 16

  g_exception_cannot_update   EXCEPTION;

Line: 251

  PROCEDURE insert_srt(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_srtv_rec      IN            okl_srtv_rec
                      ,p_srv_rec       IN            okl_srv_rec
                      ,x_srtv_rec         OUT NOCOPY okl_srtv_rec
                      ,x_srv_rec          OUT NOCOPY okl_srv_rec) AS
    l_api_version                NUMBER       := 1.0;

Line: 261

    l_api_name                   VARCHAR2(40) := 'insert_srt';

Line: 278

    okl_fe_std_rate_tmpl_pvt.insert_srt(l_api_version
                                       ,p_init_msg_list
                                       ,l_return_status
                                       ,x_msg_count
                                       ,x_msg_data
                                       ,p_srtv_rec
                                       ,p_srv_rec
                                       ,x_srtv_rec
                                       ,x_srv_rec);

Line: 321

  END insert_srt;

Line: 325

  PROCEDURE update_srt(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_srv_rec       IN            okl_srv_rec
                      ,x_srv_rec          OUT NOCOPY okl_srv_rec) AS
    l_api_version                NUMBER       := 1.0;

Line: 333

    l_api_name                   VARCHAR2(40) := 'update_srt';

Line: 351

    okl_fe_std_rate_tmpl_pvt.update_srt(l_api_version
                                       ,p_init_msg_list
                                       ,l_return_status
                                       ,x_msg_count
                                       ,x_msg_data
                                       ,p_srv_rec
                                       ,x_srv_rec);

Line: 392

  END update_srt;

Line: 674

  PROCEDURE update_default(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_srt_id        IN            NUMBER) AS
    l_api_version                NUMBER       := 1.0;

Line: 681

    l_api_name                   VARCHAR2(40) := 'update_default';

Line: 699

    okl_fe_std_rate_tmpl_pvt.update_default(l_api_version
                                           ,l_init_msg_list
                                           ,l_return_status
                                           ,x_msg_count
                                           ,x_msg_data
                                           ,p_srt_id);

Line: 739

  END update_default;