507: END IF;
508:
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
719: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,'okc.plsql.OKC_CLS_UTIL.'||l_api_name,'LOAD_CLAUSES_FOR_DOC: Inserting the Variables.');
720: END IF;
721:
722: -- add the variables
723: INSERT INTO okc_k_art_variables (
724: CAT_ID,
725: VARIABLE_CODE,
726: VARIABLE_TYPE,
727: EXTERNAL_YN,