APPS.OKC_IMP_TERMS_TEMPLATES_PUB SQL Statements

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

Line: 52

   PROCEDURE update_template( p_template_tbl   IN OUT NOCOPY   okc_imp_terms_templates_pvt.terms_template_tbl_type,
                              p_commit         IN              VARCHAR2 := fnd_api.g_false
                             )
   IS
   BEGIN
      okc_imp_terms_templates_pvt.update_template(p_template_tbl => p_template_tbl,
                                                  p_commit       =>  p_commit
                                                  );

Line: 60

   END  update_template;

Line: 85

   PROCEDURE delete_articles (
      p_template_id        IN              NUMBER,
      p_k_article_id_tbl   IN              okc_imp_terms_templates_pvt.k_article_id_tbl_type,
      p_commit             IN              VARCHAR2 := fnd_api.g_false,
      x_k_article_id_tbl   OUT NOCOPY      okc_imp_terms_templates_pvt.k_article_id_tbl_type,
      x_return_status      OUT NOCOPY      VARCHAR2,
      x_msg_data           OUT NOCOPY      VARCHAR2
   )
   IS
   BEGIN
      okc_imp_terms_templates_pvt.delete_articles
                                   (p_template_id           => p_template_id,
                                    p_k_article_id_tbl      => p_k_article_id_tbl,
                                    p_commit                => p_commit,
                                    x_k_article_id_tbl      => x_k_article_id_tbl,
                                    x_return_status         => x_return_status,
                                    x_msg_data              => x_msg_data
                                   );

Line: 103

   END delete_articles;

Line: 105

   PROCEDURE delete_sections (
      p_template_id      IN              NUMBER,
      p_section_id_tbl   IN              okc_imp_terms_templates_pvt.section_id_tbl_type,
      p_commit           IN              VARCHAR2 := fnd_api.g_false,
      x_section_id_tbl   OUT NOCOPY      okc_imp_terms_templates_pvt.section_id_tbl_type,
      x_return_status    OUT NOCOPY      VARCHAR2,
      x_msg_data         OUT NOCOPY      VARCHAR2
   )
   IS
   BEGIN
      okc_imp_terms_templates_pvt.delete_sections
                                       (p_template_id         => p_template_id,
                                        p_section_id_tbl      => p_section_id_tbl,
                                        p_commit              => p_commit,
                                        x_section_id_tbl      => x_section_id_tbl,
                                        x_return_status       => x_return_status,
                                        x_msg_data            => x_msg_data
                                       );

Line: 123

   END delete_sections;

Line: 125

   PROCEDURE delete_deliverables (
      p_template_id          IN              NUMBER,
      p_deliverable_id_tbl   IN              okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
      p_commit               IN              VARCHAR2 := fnd_api.g_false,
      x_deliverable_id_tbl   OUT NOCOPY      okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
      x_return_status        OUT NOCOPY      VARCHAR2,
      x_msg_data             OUT NOCOPY      VARCHAR2
   )
   IS
   BEGIN
      okc_imp_terms_templates_pvt.delete_deliverables
                               (p_template_id             => p_template_id,
                                p_deliverable_id_tbl      => p_deliverable_id_tbl,
                                p_commit                  => p_commit,
                                x_deliverable_id_tbl      => x_deliverable_id_tbl,
                                x_return_status           => x_return_status,
                                x_msg_data                => x_msg_data
                               );

Line: 143

   END delete_deliverables;

Line: 158

   PROCEDURE update_tmpl_usage(
      p_template_id      IN NUMBER ,
      p_tmpl_usage_tbl   IN OUT NOCOPY   okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
      p_commit            IN              VARCHAR2 := fnd_api.g_false
   )
   IS
   BEGIN
        okc_imp_terms_templates_pvt.update_tmpl_usage( p_template_id =>  p_template_id,
                                                      p_tmpl_usage_tbl => p_tmpl_usage_tbl,
                                                      p_commit  => p_commit
                                                     );

Line: 169

   END  update_tmpl_usage;

Line: 171

   PROCEDURE delete_tmpl_usage (
      p_template_id      IN NUMBER ,
      p_tmpl_usage_tbl   IN OUT NOCOPY   okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
      p_commit           IN VARCHAR2 := fnd_api.g_false
                                )
   IS
   BEGIN
      okc_imp_terms_templates_pvt.delete_tmpl_usage( p_template_id =>  p_template_id,
                                                      p_tmpl_usage_tbl => p_tmpl_usage_tbl,
                                                      p_commit  => p_commit
                                                     );

Line: 183

  END  delete_tmpl_usage;