eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_WORD_DOWNLOAD_UPLOAD dependencies on OKC_WORD_DOWNLOAD_UPLOAD

Line 1: PACKAGE BODY okc_word_download_upload AS

1: PACKAGE BODY okc_word_download_upload AS
2: /* $Header: OKCWDUPB.pls 120.2.12020000.6 2012/12/12 10:37:09 skavutha ship $ */
3: ------------------------------------------------------------------------------
4: -- GLOBAL CONSTANTS
5: ------------------------------------------------------------------------------

Line 6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_WORD_DOWNLOAD_UPLOAD';

2: /* $Header: OKCWDUPB.pls 120.2.12020000.6 2012/12/12 10:37:09 skavutha ship $ */
3: ------------------------------------------------------------------------------
4: -- GLOBAL CONSTANTS
5: ------------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_WORD_DOWNLOAD_UPLOAD';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8:
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';

Line 285: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);

281: from okc_article_versions VER,okc_k_articles_b ART
282: where ART.id = l_article_id
283: and VER.article_id = ART.sav_sae_id
284: and VER.article_version_id = ART.article_version_id;
285: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);
286: IF l_insert_by_reference = 'Y' then
287: l_clob_temp := to_clob('' || l_reference_text || '');
288: ELSE
289: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);

Line 289: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);

285: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);
286: IF l_insert_by_reference = 'Y' then
287: l_clob_temp := to_clob('' || l_reference_text || '');
288: ELSE
289: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);
290: END IF;
291:
292: --make the list related attributes as unique by appending the position no
293: --w:listDefId="[[:digit:]]{1}" ,w:ilfo="[[:digit:]]{1}",w:ilst w:val="[[:digit:]]{1}" & w:ilfo w:val="[[:digit:]]{1}"

Line 313: l_art_XML := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_download(l_art_XML,l_var_XML);

309: l_art_XML := xmltype(l_clob_temp).extract('/SOMETAG/wbody/*');
310:
311: l_progress := '050';
312: -- Resolve the Variables
313: l_art_XML := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_download(l_art_XML,l_var_XML);
314: -- Store the resolved clause in a pl/sql table.
315: l_art_body_tbl(l_i) := ''||l_art_XML.getClobVal()||'';
316:
317:

Line 586: l_doc_clob := okc_word_download_upload.blob_to_clob(l_doc_blob);

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;
583:
584: -- convert the document to clob
585: l_progress := '020';
586: l_doc_clob := okc_word_download_upload.blob_to_clob(l_doc_blob);
587:
588: -- change_encoding
589: l_progress := '030';
590: l_doc_clob := change_encoding(l_doc_clob);

Line 617: ART_CLOB_TBL(l_i) := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_upload(ART_CLOB_TBL(l_i));

613: --ART_CLOB_TBL(l_i) := XMLType.appendChildXML(l_doc_placeholder_xml,'//wbody', l_doc_xml.Extract('//ClauseTag['||To_Char(l_i)||']/ArticleText[1]/*')).GetClobVal();
614:
615: IF (XMLType(ART_CLOB_TBL(l_i)).existsnode('//var')>0) THEN
616: l_progress := '070';
617: ART_CLOB_TBL(l_i) := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_upload(ART_CLOB_TBL(l_i));
618: END IF;
619: ART_CLOB_TBL(l_i) := regexp_replace(regexp_replace(ART_CLOB_TBL(l_i),'wbody','w:body'),'',' ');
620: l_i := l_i+1;
621: END LOOP;

Line 657: 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;

653: AND st.action <> 'ADDED'
654: AND ART.id = st.cat_id
655: and VER.article_id = ART.sav_sae_id
656: and VER.article_version_id = ART.article_version_id
657: 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;
658:
659: -- Mark the Clauses as 'UPDATED'
660: l_progress := '110';
661: IF cat_id1_tbl.Count>0 THEN

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));

676: l_doc_clob:= regexp_replace(regexp_replace(l_doc_xml.getClobVal(),'agsfddfsga','w:'),'wbody','w:body');
677:
678: -- Insert the document into okc_word_sync_t
679: l_progress := '130';
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));
681: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
683: G_MODULE||l_api_name,
684: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');

Line 732: SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(FILE_DATA)

728: t_xml XMLType;
729:
730:
731: CURSOR get_doc_data is
732: SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(FILE_DATA)
733: FROM OKC_REVIEW_UPLD_HEADER
734: WHERE (DOCUMENT_TYPE,DOCUMENT_ID) IN (SELECT DOCUMENT_TYPE,DOCUMENT_ID
735: FROM OKC_K_ARTICLES_B
736: 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;

753:
754: OPEN get_doc_data;
755: FETCH get_doc_data INTO l_doc_clob;
756: IF get_doc_data%NOTFOUND THEN
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;
758: END IF;
759: CLOSE get_doc_data;
760:
761: l_doc_clob := regexp_replace(l_doc_clob,'w:body','wbody');

Line 805: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);

801: G_MODULE||l_api_name,
802: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
803: END IF;
804:
805: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);
806:
807: END;
808:
809: EXCEPTION WHEN OTHERS THEN

Line 817: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);

813: G_MODULE||l_api_name,
814: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
815: END IF;
816:
817: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);
818:
819: END UPLOAD_POST_PROCESSOR;
820:
821:

Line 1084: l_art_CLOB := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_upload(l_art_CLOB);

1080: SELECT deleteXML(xmltype(p_doc_clob),'//wbody/*').getClobVal() INTO l_art_clob FROM dual;
1081: l_art_XML := p_art_clob.extract('//ArticleText[1]/*');
1082: select appendChildXML(XMLTYPE(l_art_clob),'//wbody',l_art_XML).getClobVal()
1083: into l_art_CLOB from dual;
1084: l_art_CLOB := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_upload(l_art_CLOB);
1085: l_art_CLOB := regexp_replace(regexp_replace(l_art_CLOB,'wbody','w:body'),'',' ');
1086:
1087: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);
1088:

Line 1087: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);

1083: into l_art_CLOB from dual;
1084: l_art_CLOB := OKC_WORD_DOWNLOAD_UPLOAD.resolve_variables_upload(l_art_CLOB);
1085: l_art_CLOB := regexp_replace(regexp_replace(l_art_CLOB,'wbody','w:body'),'',' ');
1086:
1087: return OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_art_clob);
1088:
1089: END GET_ARTICLE_WML;
1090:
1091:

Line 1340: select okc_word_download_upload.blob_to_clob(article_text_in_word) into x_art_wml

1336: and WT.cat_id = UPLD.object_id
1337: AND wt.action = 'UPDATEDASSIGNED';
1338:
1339: ELSE
1340: select okc_word_download_upload.blob_to_clob(article_text_in_word) into x_art_wml
1341: from okc_article_versions VER
1342: where VER.article_version_id = p_art_ver_id
1343: and ver.edited_in_word = 'Y';
1344:

Line 1350: x_art_html := okc_word_download_upload.Clob_to_blob(x_art_wml);

1346:
1347: x_art_wml := convert_wml_to_html_1(x_art_wml);
1348: --x_art_wml := regexp_replace(x_art_wml,'','');
1349: x_art_wml := regexp_replace(x_art_wml,' ','');
1350: x_art_html := okc_word_download_upload.Clob_to_blob(x_art_wml);
1351: x_success := FND_API.G_TRUE;
1352: EXCEPTION
1353: when others then x_success := FND_API.G_FALSE;
1354:

Line 1498: END OKC_WORD_DOWNLOAD_UPLOAD;

1494: END IF;
1495: RETURN l_clob;
1496: END;
1497:
1498: END OKC_WORD_DOWNLOAD_UPLOAD;