eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STRM_GEN_TEMPLATE_PUB SQL Statements

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

Line: 104


Procedure update_strm_gen_template(
                    p_api_version             IN  NUMBER
                    ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                    ,x_return_status           OUT NOCOPY VARCHAR2
                    ,x_msg_count               OUT NOCOPY NUMBER
                    ,x_msg_data                OUT NOCOPY VARCHAR2
                    ,p_gtsv_rec                IN  gtsv_rec_type
                    ,p_gttv_rec                IN  gttv_rec_type
                    ,p_gtpv_tbl                IN  gtpv_tbl_type
                    ,p_gtlv_tbl                IN  gtlv_tbl_type
                    ,x_gttv_rec                OUT NOCOPY gttv_rec_type  -- Return the Template Info
      )IS
    l_api_name VARCHAR2(30):= 'update_strm_gen_template';

Line: 133


    OKL_STRM_GEN_TEMPLATE_PVT.update_strm_gen_template(
                     p_api_version   => l_api_version
                    ,p_init_msg_list => p_init_msg_list
                    ,x_return_status => l_return_status
                    ,x_msg_count     => x_msg_count
                    ,x_msg_data      => x_msg_data
                    ,p_gtsv_rec      => p_gtsv_rec
                    ,p_gttv_rec      => p_gttv_rec
                    ,p_gtpv_tbl      => p_gtpv_tbl
                    ,p_gtlv_tbl      => p_gtlv_tbl
                    ,x_gttv_rec      => x_gttv_rec
    );

Line: 191


Procedure update_dep_strms(
                     p_api_version             IN  NUMBER
                    ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                    ,x_return_status           OUT NOCOPY VARCHAR2
                    ,x_msg_count               OUT NOCOPY NUMBER
                    ,x_msg_data                OUT NOCOPY VARCHAR2
                    ,p_gtt_id                  IN  OKL_ST_GEN_TEMPLATES.ID%type
                    ,p_pri_sty_id              IN  OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
                    ,p_gtlv_tbl                IN  gtlv_tbl_type
                    ,x_missing_deps            OUT NOCOPY VARCHAR2
                    ,x_show_warn_flag          OUT NOCOPY VARCHAR2
      )IS
    l_api_name VARCHAR2(30):= 'update_dep_strms';

Line: 219


    OKL_STRM_GEN_TEMPLATE_PVT.update_dep_strms(
                     p_api_version    => l_api_version
                    ,p_init_msg_list  => p_init_msg_list
                    ,x_return_status  => l_return_status
                    ,x_msg_count      => x_msg_count
                    ,x_msg_data       => x_msg_data
                    ,p_gtt_id         => p_gtt_id
                    ,p_pri_sty_id     => p_pri_sty_id
                    ,p_gtlv_tbl       => p_gtlv_tbl
                    ,x_missing_deps   => x_missing_deps
                    ,x_show_warn_flag => x_show_warn_flag
    );

Line: 364


Procedure delete_tmpt_prc_params(
                    p_api_version             IN  NUMBER
                    ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                    ,x_return_status           OUT NOCOPY VARCHAR2
                    ,x_msg_count               OUT NOCOPY NUMBER
                    ,x_msg_data                OUT NOCOPY VARCHAR2
                    ,p_gtpv_tbl                IN  gtpv_tbl_type
      ) IS
    l_api_name VARCHAR2(30):= 'delete_tmpt_prc_params';

Line: 389


    OKL_STRM_GEN_TEMPLATE_PVT.delete_tmpt_prc_params(
                    p_api_version     => l_api_version
                    ,p_init_msg_list  => p_init_msg_list
                    ,x_return_status  => x_return_status
                    ,x_msg_count      => x_msg_count
                    ,x_msg_data       => x_msg_data
                    ,p_gtpv_tbl       => p_gtpv_tbl
      );

Line: 444


Procedure delete_pri_tmpt_lns(
                    p_api_version             IN  NUMBER
                    ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                    ,x_return_status           OUT NOCOPY VARCHAR2
                    ,x_msg_count               OUT NOCOPY NUMBER
                    ,x_msg_data                OUT NOCOPY VARCHAR2
                    ,p_gtlv_tbl                IN  gtlv_tbl_type
      )IS
    l_api_name VARCHAR2(30):= 'delete_pri_tmpt_lns';

Line: 470


    OKL_STRM_GEN_TEMPLATE_PVT.delete_pri_tmpt_lns(
                    p_api_version     => l_api_version
                    ,p_init_msg_list  => p_init_msg_list
                    ,x_return_status  => x_return_status
                    ,x_msg_count      => x_msg_count
                    ,x_msg_data       => x_msg_data
                    ,p_gtlv_tbl       => p_gtlv_tbl
      );

Line: 525


Procedure delete_dep_tmpt_lns(
                    p_api_version             IN  NUMBER
                    ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                    ,x_return_status           OUT NOCOPY VARCHAR2
                    ,x_msg_count               OUT NOCOPY NUMBER
                    ,x_msg_data                OUT NOCOPY VARCHAR2
                    ,p_gtlv_tbl                IN  gtlv_tbl_type
      )IS
    l_api_name VARCHAR2(30):= 'delete_dep_tmpt_lns';

Line: 551


    OKL_STRM_GEN_TEMPLATE_PVT.delete_dep_tmpt_lns(
                    p_api_version     => l_api_version
                    ,p_init_msg_list  => p_init_msg_list
                    ,x_return_status  => x_return_status
                    ,x_msg_count      => x_msg_count
                    ,x_msg_data       => x_msg_data
                    ,p_gtlv_tbl       => p_gtlv_tbl
      );

Line: 847


  PROCEDURE update_pri_dep_of_sgt(
              p_api_version             IN  NUMBER
             ,p_init_msg_list           IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
             ,x_return_status           OUT NOCOPY VARCHAR2
             ,x_msg_count               OUT NOCOPY NUMBER
             ,x_msg_data                OUT NOCOPY VARCHAR2
             ,p_gtsv_rec                IN  gtsv_rec_type
             ,p_gttv_rec                IN  gttv_rec_type
             ,p_gtpv_tbl                IN  gtpv_tbl_type
             ,p_pri_gtlv_tbl            IN  gtlv_tbl_type
             ,p_del_dep_gtlv_tbl        IN  gtlv_tbl_type
             ,p_ins_dep_gtlv_tbl        IN  gtlv_tbl_type
             ,x_gttv_rec                OUT NOCOPY gttv_rec_type
             ,x_pri_purpose_list        OUT NOCOPY VARCHAR2)
  IS
    l_api_name          VARCHAR2(30):= 'update_pri_dep_of_sgt';

Line: 878


    okl_strm_gen_template_pvt.update_pri_dep_of_sgt(
      p_api_version       => p_api_version,
      p_init_msg_list     => p_init_msg_list,
      x_return_status     => l_return_status,
      x_msg_count         => x_msg_count,
      x_msg_data          => x_msg_data,
      p_gtsv_rec          => p_gtsv_rec,
      p_gttv_rec          => p_gttv_rec,
      p_gtpv_tbl          => p_gtpv_tbl,
      p_pri_gtlv_tbl      => p_pri_gtlv_tbl,
      p_del_dep_gtlv_tbl  => p_del_dep_gtlv_tbl,
      p_ins_dep_gtlv_tbl  => p_ins_dep_gtlv_tbl ,
      x_gttv_rec          => x_gttv_rec,
      x_pri_purpose_list  => x_pri_purpose_list );

Line: 928


  END update_pri_dep_of_sgt;