APPS.OKC_WORD_DOWNLOAD_UPLOAD SQL Statements

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

Line: 77

 INSERT INTO  OKC_WORD_SYNC_T(
                             )
                             VALUES ();

Line: 111

  select blob_to_clob(blob_data)
   into p_document_xml
   from OKC_WORD_SYNC_T
   WHERE id = 1
   AND doc_id = p_doc_id
   AND doc_type = p_doc_type;

Line: 134

		     select updateXML(l_doc_xml,l_xpath_temp,l_art_xml) into l_doc_xml FROM dual;

Line: 137

         select updateXML(l_doc_xml,l_xpath_temp,'
##ARTICLEWML##') into l_doc_xml FROM dual;

Line: 146

     SELECT updateXML( l_doc_xml
                       ,'//ArticleText[not(.//var)]','
##ARTICLEWML##'
                       ).getClobVal()

      INTO l_doc_clob
      FROM dual;

Line: 157

     UPDATE OKC_WORD_SYNC_T
     SET blob_data = clob_to_blob(l_doc_clob)
     WHERE id = 1
     AND doc_id  = p_doc_id
     AND  doc_type = p_doc_type;

Line: 232

 l_insert_by_reference VARCHAR2(1);

Line: 254

  select blob_to_clob(blob_data) into p_document_xml from OKC_WORD_SYNC_T WHERE id = 1 and doc_id = p_doc_id AND doc_type = p_doc_type;

Line: 279

       select VER.INSERT_BY_REFERENCE,VER.REFERENCE_TEXT,VER.article_text_in_word
        into l_insert_by_reference,l_reference_text,l_article_text_in_word
        from  okc_article_versions VER,okc_k_articles_b ART
        where ART.id = l_article_id
        and   VER.article_id = ART.sav_sae_id
        and   VER.article_version_id = ART.article_version_id;

Line: 286

      IF l_insert_by_reference = 'Y' then
          l_clob_temp := to_clob('' || l_reference_text || '');

Line: 320

           select deleteXML(XMLType(l_clob_temp),'//wlistDef//wlsid').getClobVal() into l_clob_temp from dual;

Line: 331

      SELECT deleteXML( l_doc_xml
                       ,'//ClauseTag/*'
                      )
       INTO  l_doc_xml
      FROM dual;

Line: 429

    select updateXML(xmltype(l_doc_clob),
                      '//SectionTag/@*','',
                      '//ClauseTag/@*','',
                      '//var/@*',''
                      ).getClobVal() into l_doc_clob from dual;

Line: 440

     UPDATE OKC_WORD_SYNC_T
     SET blob_data = clob_to_blob(l_doc_clob)
     WHERE id = 1
     and doc_id  = p_doc_id
     AND doc_type  = p_doc_type;

Line: 503

	select deleteXML(XMLType(v_clob),'//wlvlPicBulletId').getClobVal() into v_clob from dual;

Line: 562

SELECT id,blob_data
FROM okc_word_sync_t
WHERE doc_id = p_doc_id
AND   doc_type = p_doc_type
AND   cat_id IS NOT NULL;

Line: 582

select blob_data into l_doc_blob from okc_word_sync_t where id = 1 and doc_id = p_doc_id and doc_type = p_doc_type;

Line: 598

INSERT INTO okc_word_sync_t (id,doc_id,doc_type,CLOB_data)
select 10,p_doc_id,p_doc_type, deleteXML(l_doc_xml,'//wbody/*').getclobVal()
from dual;

Line: 627

INSERT INTO okc_word_sync_t (id,doc_id,doc_type,cat_id,action,CLOB_data)
VALUES (id_TBL(i),p_doc_id,p_doc_type,CAT_ID_TBL(i),'NONE',ART_CLOB_TBL(i));

Line: 632

UPDATE OKC_WORD_SYNC_T t0
SET    ACTION = 'ADDED'
       --cat_id = NULL
WHERE  t0.doc_id  = p_doc_id
AND    t0.doc_type  = p_doc_type
AND ( cat_id = 0 OR
          EXISTS (select 1 from OKC_WORD_SYNC_T t1
               where  t1.doc_id  = p_doc_id
               and    t1.doc_type  = p_doc_type
               and    t0.cat_id = t1.cat_id
               and    t1.id < t0.id)
               );

Line: 648

SELECT art.id
BULK COLLECT INTO  cat_id1_tbl
From  okc_article_versions VER,okc_k_articles_b ART,okc_word_sync_t   st
WHERE  st.doc_id    = p_doc_id
 AND   st.doc_type =  p_doc_type
 AND   st.action <> 'ADDED'
 AND   ART.id =  st.cat_id
 and   VER.article_id = ART.sav_sae_id
 and   VER.article_version_id = ART.article_version_id
 AND   Dbms_Lob.compare(okc_word_download_upload.get_articleWML_Text(VER.article_text_in_word),okc_word_download_upload.get_articleWML_Text(st.CLOB_data)) <> 0;

Line: 663

UPDATE okc_word_sync_t
SET  action = 'UPDATED'
WHERE  doc_id    = p_doc_id
AND    doc_type =  p_doc_type
AND    action <> 'ADDED'
AND    cat_id=cat_id1_tbl(i);

Line: 673

SELECT UpdateXML(l_doc_xml,
                 '//ArticleText', l_dummy_article_text
                 )INTO l_doc_xml FROM dual;

Line: 680

insert into okc_word_sync_t(id,doc_id,doc_type,blob_data) values(2,p_doc_id,p_doc_type,okc_word_download_upload.clob_to_blob(l_doc_clob));

Line: 732

 SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(FILE_DATA)
 FROM OKC_REVIEW_UPLD_HEADER
 WHERE (DOCUMENT_TYPE,DOCUMENT_ID) IN (SELECT DOCUMENT_TYPE,DOCUMENT_ID
                                       FROM OKC_K_ARTICLES_B
                                       WHERE ID  = p_cat_id);

Line: 757

       SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(blob_data) INTO l_doc_clob FROM OKC_WORD_SYNC_T WHERE id = 1 AND doc_id = p_doc_id AND doc_type = p_doc_type;

Line: 766

    select deleteXML(xmltype(l_doc_clob),'//wbody/*').getClobVal() into l_clob_temp from dual;

Line: 918

SELECT FND_PROFILE.VALUE('OKC_WORD_SYNC_ART_EDIT') INTO PROF_VALUE FROM DUAL;

Line: 929

PROCEDURE INSERT_WML_TEXT(p_article_version_id NUMBER, p_article_text_in_word BLOB) IS
BEGIN
  IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
                    G_MODULE||'INSERT_WML_TEXT',
                    '100: Entered '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');

Line: 936

UPDATE okc_article_versions
SET article_text_in_word = p_article_text_in_word,
    edited_in_word       = 'Y'
WHERE article_version_id = p_article_version_id;

Line: 942

                    G_MODULE||'INSERT_WML_TEXT',
                    '100: Leaving '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');

Line: 945

END INSERT_WML_TEXT;

Line: 1028

      SELECT updateXML( l_art_XML,l_xpath,xmltype(l_var_str).extract('/DUMMY/*')) INTO l_art_XML FROM dual;

Line: 1048

select blob_to_clob(blob_data) into html_clob from okc_word_sync_t where id = 3 and doc_id = p_doc_id and doc_type = p_doc_type;

Line: 1062

update  okc_word_sync_t
set blob_data = clob_to_blob(stripped_html)
where id = 3
and   doc_id = p_doc_id
and doc_type = p_doc_type;

Line: 1080

    SELECT deleteXML(xmltype(p_doc_clob),'//wbody/*').getClobVal() INTO l_art_clob FROM dual;

Line: 1082

    select appendChildXML(XMLTYPE(l_art_clob),'//wbody',l_art_XML).getClobVal()
    into l_art_CLOB from dual;

Line: 1133

CURSOR get_updated_csr IS
SELECT action,clob_data
FROM okc_word_sync_t
WHERE doc_id = p_doc_id
AND doc_type = p_doc_type
AND cat_id = p_cat_id
AND action = 'UPDATED';

Line: 1145

SELECT id,action,clob_data
FROM okc_word_sync_t
WHERE doc_id = p_doc_id
AND doc_type = p_doc_type
AND cat_id = Nvl(p_cat_id,0)
AND action = 'ADDED'
AND id = (SELECT Min(id) FROM okc_word_sync_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND cat_id = Nvl(p_cat_id,0) AND action = 'ADDED');

Line: 1154

SELECT action
FROM okc_word_sync_t
WHERE doc_id = p_doc_id
AND doc_type = p_doc_type
AND cat_id = p_cat_id
AND action = 'NONE';

Line: 1163

SELECT clob_data
FROM okc_word_sync_t
WHERE doc_id = p_doc_id
AND doc_type = p_doc_type
AND  id=10;

Line: 1177

OPEN get_updated_csr;

Line: 1178

FETCH get_updated_csr INTO t_action,t_clob_data;

Line: 1179

IF get_updated_csr%FOUND THEN

  OPEN get_placeholder_xml;

Line: 1196

  UPDATE okc_word_sync_t
  SET action = 'UPDATEDASSIGNED' , clob_data =  l_placeholder_xml
  WHERE doc_id = p_doc_id
  AND doc_type = p_doc_type
  AND cat_id = Nvl(p_cat_id,0)
  AND action = 'UPDATED';

Line: 1203

  CLOSE get_updated_csr;

Line: 1212

    SELECT article_text INTO t_clob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b  WHERE id = p_cat_id);

Line: 1218

    UPDATE okc_word_sync_t
    SET action = 'NONEASSIGNED'
    WHERE doc_id = p_doc_id
    AND doc_type = p_doc_type
    AND cat_id = p_cat_id
    AND action = 'NONE';

Line: 1244

      UPDATE okc_word_sync_t
      SET action = 'ADDEDASSIGNED' , clob_data =  l_placeholder_xml
      WHERE doc_id = p_doc_id
      AND doc_type = p_doc_type
      AND cat_id = Nvl(p_cat_id,0)
      AND action = 'ADDED'
      AND id = t_id;

Line: 1286

      SELECT action,clob_to_blob(clob_data) INTO t_action,t_blob_data FROM okc_word_sync_t
      WHERE doc_id = p_doc_id
      AND doc_type = p_doc_type
      AND cat_id = p_cat_id;

Line: 1292

        SELECT article_text_in_word INTO t_blob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b  WHERE id = p_cat_id);

Line: 1304

      SELECT clob_to_blob(clob_data),id INTO t_blob_data,l_id FROM okc_word_sync_t
      WHERE doc_id = p_doc_id
      AND doc_type = p_doc_type
      AND action = 'ADDEDASSIGNED'
      AND id = (SELECT Min(id) FROM okc_word_sync_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND action = 'ADDEDASSIGNED');

Line: 1310

      UPDATE okc_word_sync_t
        SET action = 'ADDEDDONE'
        WHERE id = l_id;

Line: 1331

  select wt.clob_data into x_art_wml
  from   okc_review_upld_terms UPLD,OKC_WORD_SYNC_T WT
  where  UPLD.REVIEW_UPLD_TERMS_ID = p_review_upld_terms_id
  and    WT.doc_id = UPLD.document_id
  and    WT.doc_type = UPLD.DOCUMENT_TYPE
  and    WT.cat_id = UPLD.object_id
  AND    wt.action = 'UPDATEDASSIGNED';

Line: 1340

  select okc_word_download_upload.blob_to_clob(article_text_in_word) into x_art_wml
  from   okc_article_versions VER
  where  VER.article_version_id = p_art_ver_id
  and    ver.edited_in_word = 'Y';

Line: 1370

  select updateXML(xmltype(l_art_html),'//wxsect[1]',XMLType(l_tbl).extract('/div/*')).getClobVal() into l_art_html from dual;

Line: 1377

  select updateXML(xmltype(l_art_html),'//wxsub-section[1]',XMLType(l_tbl).extract('/div/*')).getClobVal() into l_art_html from dual;

Line: 1383

  select updateXML(xmltype(l_art_html),'//wtbl[1]',XMLType(l_tbl)).getClobVal() into l_art_html from dual;

Line: 1395

  select updateXML(xmltype(l_art_html),'//wxsub-section[1]',XMLType(l_tbl).extract('/div/*')).getClobVal() into l_art_html from dual;

Line: 1409

  select updateXML(xmltype(l_art_html),'//wp[1]',XMLType(l_tbl)).getClobVal() into l_art_html from dual;

Line: 1426

 select updateXML(xmltype(l_table),'//wtr[1]',XMLType(l_row)).getClobVal() into l_table from dual;

Line: 1444

 select updateXML(xmltype(l_row),'//wtc[1]',XMLType(l_cell)).getClobVal() into l_row from dual;

Line: 1467

select deleteXML(XMLType(l_html_diff),'//br').getClobVal() into l_html_diff from dual;

Line: 1477

select deleteXML(XMLType(l_html_diff),'//br').getClobVal() into l_html_diff from dual;