APPS.OKC_CLS_UTIL dependencies on OKC_K_ARTICLES_B

Line 513: FROM okc_k_articles_b

509: -- delete existing CLS clauses
510: -- delete the variables first
511: DELETE FROM okc_k_art_variables
512: WHERE CAT_ID IN (SELECT id
513: FROM okc_k_articles_b
514: WHERE SOURCE_FLAG = 'C'
515: AND DOCUMENT_TYPE = p_doc_type
516: AND DOCUMENT_ID = p_doc_id
517: );

Line 519: DELETE FROM okc_k_articles_b

515: AND DOCUMENT_TYPE = p_doc_type
516: AND DOCUMENT_ID = p_doc_id
517: );
518: -- delete the clauses
519: DELETE FROM okc_k_articles_b
520: WHERE SOURCE_FLAG = 'C'
521: AND DOCUMENT_TYPE = p_doc_type
522: AND DOCUMENT_ID = p_doc_id ;
523:

Line 535: FROM okc_k_articles_b

531: -- derive DISPLAY_SEQUENCE
532: -- derive ARTICLE_VERSION_ID
533: SELECT Max(DISPLAY_SEQUENCE)
534: INTO l_max_seq
535: FROM okc_k_articles_b
536: WHERE DOCUMENT_TYPE = p_doc_type
537: AND DOCUMENT_ID = p_doc_id ;
538:
539: -- to-do :

Line 592: FROM okc_k_articles_b art, OKC_CLS_CLAUSE_BUFFER_T buf

588: SELECT CASE WHEN art.ARTICLE_VERSION_ID <> buf.ORIG_ARTICLE_VERSION_ID THEN 'Y'
589: ELSE 'N'
590: END AS wrong_version_yn,
591: CLAUSE_NUMBER
592: FROM okc_k_articles_b art, OKC_CLS_CLAUSE_BUFFER_T buf
593: WHERE art.DOCUMENT_TYPE = p_doc_type
594: AND art.DOCUMENT_ID = p_doc_id
595: AND art.SAV_SAE_ID = buf.ORIG_ARTICLE_ID
596: )

Line 668: INSERT INTO okc_k_articles_b (

664: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,'okc.plsql.OKC_CLS_UTIL.'||l_api_name,'LOAD_CLAUSES_FOR_DOC: Inserting the clauses.');
665: END IF;
666:
667: -- add the clauses
668: INSERT INTO okc_k_articles_b (
669: ID,
670: SAV_SAE_ID,
671: OBJECT_VERSION_NUMBER,
672: CREATED_BY,

Line 688: (SELECT okc_k_articles_b_s.NEXTVAL,

684: ARTICLE_VERSION_ID,
685: ORIG_SYSTEM_REFERENCE_CODE,
686: ORIG_SYSTEM_REFERENCE_ID1,
687: ORIG_ARTICLE_ID)
688: (SELECT okc_k_articles_b_s.NEXTVAL,
689: ORIG_ARTICLE_ID,
690: 1,
691: fnd_global.user_id,
692: SYSDATE,

Line 710: FROM okc_k_articles_b

706: ORIG_ARTICLE_ID
707: FROM OKC_CLS_CLAUSE_BUFFER_T buf
708: WHERE TOKEN = p_token
709: AND NOT EXISTS (SELECT 1
710: FROM okc_k_articles_b
711: WHERE DOCUMENT_TYPE = p_doc_type
712: AND DOCUMENT_ID = p_doc_id
713: AND SAV_SAE_ID = buf.ORIG_ARTICLE_ID
714: )

Line 747: FROM okc_k_articles_b art,

743: sysdate,
744: fnd_global.user_id,
745: sysdate,
746: fnd_global.login_id
747: FROM okc_k_articles_b art,
748: OKC_ARTICLE_VARIABLES art_vbles,
749: OKC_BUS_VARIABLES_B art_bus_vbles
750:
751: WHERE art.DOCUMENT_TYPE = p_doc_type