APPS.OKC_TERMS_COPY_GRP SQL Statements

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

Line: 91

SELECT TARGET_RESPONSE_DOC_TYPE
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type
AND    document_type_class = 'SOURCING';

Line: 99

SELECT enable_deliverables_yn
FROM okc_bus_doc_types_b
where document_type = p_target_doc_type;

Line: 105

SELECT doc_numbering_scheme
FROM okc_template_usages
WHERE document_type = p_doc_type
  AND document_id = p_doc_id;

Line: 224

                         p_update_from_doc_type  => p_source_doc_type,
                         p_update_from_doc_id  => p_source_doc_id,
                         p_update_to_doc_type    => p_target_doc_type,
                         p_update_to_doc_id      => p_target_doc_id,
                         X_RETURN_STATUS => x_return_status,
                         X_MSG_COUNT => X_MSG_COUNT,
                         X_MSG_DATA => X_MSG_DATA
                        );

Line: 589

SELECT * FROM OKC_TERMS_TEMPLATES_ALL
WHERE template_id=p_template_id;

Line: 593

SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL
WHERE org_id=b_org_id
AND   template_name=p_tmpl_name;

Line: 642

    SELECT mo_global.get_current_org_id()
          INTO l_template_rec.org_id from dual;

Line: 932

SELECT TARGET_RESPONSE_DOC_TYPE
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type
AND    document_type_class = 'SOURCING';

Line: 940

SELECT doc_numbering_scheme
FROM okc_template_usages
WHERE document_type = p_doc_type
  AND document_id = p_doc_id;

Line: 948

SELECT enable_deliverables_yn
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type;

Line: 1232

SELECT * FROM OKC_TERMS_TEMPLATES_ALL
WHERE template_id=p_template_id;

Line: 1974

        FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'140: calling OKC_TERMS_UTIL_GRP.delete_doc');

Line: 1978

       OKC_TERMS_UTIL_GRP.delete_doc
            (
              p_api_version     => 1.0
            , p_init_msg_list   => FND_API.G_TRUE
            , p_commit           => FND_API.G_FALSE
            , p_doc_id           => p_target_doc_id
            , p_doc_type         => p_target_doc_type
            , p_validate_commit  => FND_API.G_FALSE



           , p_retain_lock_terms_yn => l_retain_lock_terms_yn
           , p_retain_lock_xprt_yn => l_retain_lock_xprt_yn
           , p_retain_lock_deliverables_yn => l_retain_lock_deliverables_yn


           , x_return_status   => x_return_status
           , x_msg_data        => l_msg_data
           , x_msg_count       => l_msg_count
           , p_retain_exhibits => l_retain_exhibits

           );

Line: 2002

                   FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130:  OKC_TERMS_UTIL_GRP.delete_doc l_return_status : '||x_return_status);