APPS.OKC_PO_MOD_PKG SQL Statements

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

Line: 27

  G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

Line: 29

  G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line: 30

  G_LOCK_RECORD_DELETED        CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;

Line: 88

    SELECT article_id INTO l_article_id
      FROM okc_article_versions
      WHERE article_version_id = p_article_version_id;

Line: 101

      SELECT default_section INTO l_section_code
        FROM okc_article_versions
        WHERE article_version_id = p_article_version_id;

Line: 107

      select article_title into l_article_title
	  from okc_articles_all
	  where article_id = l_article_id;

Line: 127

	        FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');

Line: 136

	          FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 145

	       FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving update_variable_values because of EXCEPTION: '||sqlerrm);

Line: 162

                                    x_updated_yn       OUT NOCOPY VARCHAR2,
                                    x_return_status    OUT NOCOPY VARCHAR2
                                    ,p_locking_enabled_yn IN VARCHAR2 DEFAULT 'N')
IS

l_api_name VARCHAR2(240) := 'upd_mulmod_clause_changes';

Line: 186

l_updated_yn VARCHAR2(1) := 'N';

Line: 192

  SELECT clause_action_code, old_article_version_id, new_article_version_id
  FROM po_multi_mod_clause_changes
  WHERE multi_mod_request_id   = p_multi_mod_req_id;

Line: 197

  SELECT scn_id
    FROM okc_sections_b
    WHERE document_type = p_document_type
    AND document_id = p_document_id
    AND  scn_code = p_scn_code;

Line: 204

           SELECT id, scn_id, display_sequence
              FROM okc_k_articles_b
              WHERE document_type = p_document_type
              AND document_id = p_document_id
              AND article_version_id = p_article_version_id;

Line: 211

SELECT 1
FROM
  OKC_TEMPLATE_USAGES
WHERE   document_type = p_document_type
AND     document_id   = p_document_id;

Line: 218

SELECT
       article_id,
	  article_title,
       article_version_id,
	  article_version_number,
       article_intent,
	  provision_yn,
	  article_status,
	  start_date,
	  end_date
FROM
  okc_articles_local_v ART
WHERE ART.article_version_id = p_article_version_id
AND   ART.org_id = p_org_id
UNION
SELECT
       article_id,
	  article_title,
       article_version_id,
	  article_version_number,
       article_intent,
	  provision_yn,
	  article_status,
	  start_date,
	  end_date
FROM
  okc_articles_global_v ART
WHERE ART.article_version_id = p_article_version_id
AND   ART.org_id = p_org_id;

Line: 367

          IF (l_return_status = 'S' AND l_updated_yn = 'N') THEN
             l_updated_yn := 'Y';

Line: 371

        ELSIF c_get_clause_changes_csr_rec.clause_action_code = 'DELETE' THEN

          /*If the action is Delete, we need to delete the clause from the mod Document.*/

          --This loop will get executed inside the call remove_std_art_from_doc
           FOR get_old_article_details_rec IN c_get_old_article_details_csr( l_old_article_version_id ) LOOP

           /* okc_terms_migrate_grp.remove_std_clause_from_doc(p_api_version          =>  1.0,
                                              p_mode                 => l_mode,
                                              p_document_type        =>  p_document_type,
                                              p_document_id          =>  p_document_id,
                                              p_clause_version_id    =>  l_old_article_version_id,
				                                      p_renumber_terms       => 'N',
                                              x_return_status        =>  l_return_status,
                                              x_msg_data             =>  l_msg_data,
                                              x_msg_count            =>  l_msg_count); */

Line: 399

          IF (l_updated_yn = 'N' AND l_return_status = 'S') THEN
             l_updated_yn := 'Y';

Line: 406

            Delete the clause. Add the clause in the same section and at the same sequence.*/

          FOR get_old_article_details_rec IN c_get_old_article_details_csr( l_old_article_version_id ) LOOP
            l_section_id := get_old_article_details_rec.scn_id;

Line: 438

          IF (l_return_status = 'S' AND l_updated_yn = 'N') THEN
             l_updated_yn := 'Y';

Line: 446

      x_updated_yn:= l_updated_yn;

Line: 448

    /*Update messages in the Concurrent Program Log*/
      FOR i IN 1 .. fnd_msg_pub.count_msg
      LOOP
         l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

Line: 460

	        FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving update_variable_values: OKC_API.G_EXCEPTION_ERROR Exception');

Line: 484

         x_updated_yn := l_updated_yn;

Line: 490

	          FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 499

	       FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving update_variable_values because of EXCEPTION: '||sqlerrm);

Line: 511

PROCEDURE delete_mulmod_clause_changes(p_multi_mod_req_id IN NUMBER,
                                    x_return_status    OUT NOCOPY VARCHAR2)
IS
l_return_status VARCHAR2(1);

Line: 518

l_api_name VARCHAR2(100) := 'delete_mulmod_clause_changes';

Line: 524

       FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered delete_mulmod_clause_changes');

Line: 533

     DELETE FROM po_multi_mod_clause_changes
     WHERE multi_mod_request_id = p_multi_mod_req_id;

Line: 539

        FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving delete_mulmod_clause_changes');

Line: 547

	        FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_ERROR Exception');

Line: 556

	          FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line: 565

	       FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving delete_mulmod_clause_changes because of EXCEPTION: '||sqlerrm);

Line: 575

END delete_mulmod_clause_changes;

Line: 592

      SELECT Count(*) INTO l_count
        FROM po_multi_mod_clause_changes
        WHERE multi_mod_request_id = p_multi_mod_req_id;