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_SYNC_T

Line 77: INSERT INTO OKC_WORD_SYNC_T(

73: IS
74: PRAGMA autonomous_transaction
75:
76: BEGIN
77: INSERT INTO OKC_WORD_SYNC_T(
78: )
79: VALUES ();
80: END save_data; */
81:

Line 113: from OKC_WORD_SYNC_T

109: -- Get the XML from the table.
110: -------------------------------------
111: select blob_to_clob(blob_data)
112: into p_document_xml
113: from OKC_WORD_SYNC_T
114: WHERE id = 1
115: AND doc_id = p_doc_id
116: AND doc_type = p_doc_type;
117:

Line 157: UPDATE OKC_WORD_SYNC_T

153: l_doc_clob := regexp_replace(l_doc_clob,'~','&');
154:
155: l_progress := 030;
156:
157: UPDATE OKC_WORD_SYNC_T
158: SET blob_data = clob_to_blob(l_doc_clob)
159: WHERE id = 1
160: AND doc_id = p_doc_id
161: AND doc_type = p_doc_type;

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;

250: '100: Entered '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
251: END IF;
252:
253: -- Get the Document XML
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;
255:
256: l_progress := '020';
257:
258: -- Replace w:list with wlist

Line 440: UPDATE OKC_WORD_SYNC_T

436: -- code to remove custom tags - end
437:
438:
439: l_progress := '140';
440: UPDATE OKC_WORD_SYNC_T
441: SET blob_data = clob_to_blob(l_doc_clob)
442: WHERE id = 1
443: and doc_id = p_doc_id
444: AND doc_type = p_doc_type;

Line 563: FROM okc_word_sync_t

559: l_encoding VARCHAR2(100);
560:
561: CURSOR c_mod_encoding IS
562: SELECT id,blob_data
563: FROM okc_word_sync_t
564: WHERE doc_id = p_doc_id
565: AND doc_type = p_doc_type
566: AND cat_id IS NOT NULL;
567:

Line 580: -- Get the document data from okc_word_sync_t

576: G_MODULE||l_api_name,
577: '100: Entered '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
578: END IF;
579:
580: -- Get the document data from okc_word_sync_t
581: l_progress := '010';
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

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;

578: END IF;
579:
580: -- Get the document data from okc_word_sync_t
581: l_progress := '010';
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);

Line 598: INSERT INTO okc_word_sync_t (id,doc_id,doc_type,CLOB_data)

594: l_doc_xml := xmltype(regexp_replace(l_doc_clob,'w:body','wbody'));
595:
596: -- Get the place holder xml which is used for adding clause text
597: l_progress := '050';
598: INSERT INTO okc_word_sync_t (id,doc_id,doc_type,CLOB_data)
599: select 10,p_doc_id,p_doc_type, deleteXML(l_doc_xml,'//wbody/*').getclobVal()
600: from dual;
601:
602:

Line 624: -- Insert the Articles into okc_word_sync_t

620: l_i := l_i+1;
621: END LOOP;
622:
623:
624: -- Insert the Articles into okc_word_sync_t
625: l_progress := '080';
626: FORALL i IN CAT_ID_TBL.first..CAT_ID_TBL.last
627: INSERT INTO okc_word_sync_t (id,doc_id,doc_type,cat_id,action,CLOB_data)
628: VALUES (id_TBL(i),p_doc_id,p_doc_type,CAT_ID_TBL(i),'NONE',ART_CLOB_TBL(i));

Line 627: INSERT INTO okc_word_sync_t (id,doc_id,doc_type,cat_id,action,CLOB_data)

623:
624: -- Insert the Articles into okc_word_sync_t
625: l_progress := '080';
626: FORALL i IN CAT_ID_TBL.first..CAT_ID_TBL.last
627: INSERT INTO okc_word_sync_t (id,doc_id,doc_type,cat_id,action,CLOB_data)
628: VALUES (id_TBL(i),p_doc_id,p_doc_type,CAT_ID_TBL(i),'NONE',ART_CLOB_TBL(i));
629:
630: --Mark new clauses...
631: l_progress := '090';

Line 632: UPDATE OKC_WORD_SYNC_T t0

628: VALUES (id_TBL(i),p_doc_id,p_doc_type,CAT_ID_TBL(i),'NONE',ART_CLOB_TBL(i));
629:
630: --Mark new clauses...
631: l_progress := '090';
632: UPDATE OKC_WORD_SYNC_T t0
633: SET ACTION = 'ADDED'
634: --cat_id = NULL
635: WHERE t0.doc_id = p_doc_id
636: AND t0.doc_type = p_doc_type

Line 638: EXISTS (select 1 from OKC_WORD_SYNC_T t1

634: --cat_id = NULL
635: WHERE t0.doc_id = p_doc_id
636: AND t0.doc_type = p_doc_type
637: AND ( cat_id = 0 OR
638: EXISTS (select 1 from OKC_WORD_SYNC_T t1
639: where t1.doc_id = p_doc_id
640: and t1.doc_type = p_doc_type
641: and t0.cat_id = t1.cat_id
642: and t1.id < t0.id)

Line 650: From okc_article_versions VER,okc_k_articles_b ART,okc_word_sync_t st

646: l_progress := '100';
647:
648: SELECT art.id
649: BULK COLLECT INTO cat_id1_tbl
650: From okc_article_versions VER,okc_k_articles_b ART,okc_word_sync_t st
651: WHERE st.doc_id = p_doc_id
652: AND st.doc_type = p_doc_type
653: AND st.action <> 'ADDED'
654: AND ART.id = st.cat_id

Line 663: UPDATE okc_word_sync_t

659: -- Mark the Clauses as 'UPDATED'
660: l_progress := '110';
661: IF cat_id1_tbl.Count>0 THEN
662: FORALL i IN cat_id1_tbl.first..cat_id1_tbl.last
663: UPDATE okc_word_sync_t
664: SET action = 'UPDATED'
665: WHERE doc_id = p_doc_id
666: AND doc_type = p_doc_type
667: AND action <> 'ADDED'

Line 678: -- Insert the document into okc_word_sync_t

674: '//ArticleText', l_dummy_article_text
675: )INTO l_doc_xml FROM dual;
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 ,

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

1044: stripped_html clob;
1045:
1046: begin
1047:
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;
1049:
1050: pos1 := regexp_instr(html_clob,'');
1051: pos2 := regexp_instr(html_clob,'');
1052:

Line 1062: update okc_word_sync_t

1058: /*stripped_html := regexp_replace(stripped_html,'''','"'); -- After the Import XSL is applied miscellaneous and
1059: stripped_html := regexp_replace(stripped_html,' >','>');
1060: stripped_html := regexp_replace(stripped_html,' />','/>');*/
1061:
1062: update okc_word_sync_t
1063: set blob_data = clob_to_blob(stripped_html)
1064: where id = 3
1065: and doc_id = p_doc_id
1066: and doc_type = p_doc_type;

Line 1135: FROM okc_word_sync_t

1131: t_id NUMBER;
1132:
1133: CURSOR get_updated_csr IS
1134: SELECT action,clob_data
1135: FROM okc_word_sync_t
1136: WHERE doc_id = p_doc_id
1137: AND doc_type = p_doc_type
1138: AND cat_id = p_cat_id
1139: AND action = 'UPDATED';

Line 1142: and in okc_word_sync_t they will be loaded as 0. so the nvl check is added

1138: AND cat_id = p_cat_id
1139: AND action = 'UPDATED';
1140:
1141: /* p_cat_id will be null for the clauses added via 2010 and they will be sent as null
1142: and in okc_word_sync_t they will be loaded as 0. so the nvl check is added
1143: */
1144: CURSOR get_added_csr IS
1145: SELECT id,action,clob_data
1146: FROM okc_word_sync_t

Line 1146: FROM okc_word_sync_t

1142: and in okc_word_sync_t they will be loaded as 0. so the nvl check is added
1143: */
1144: CURSOR get_added_csr IS
1145: SELECT id,action,clob_data
1146: FROM okc_word_sync_t
1147: WHERE doc_id = p_doc_id
1148: AND doc_type = p_doc_type
1149: AND cat_id = Nvl(p_cat_id,0)
1150: AND action = 'ADDED'

Line 1151: 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');

1147: WHERE doc_id = p_doc_id
1148: AND doc_type = p_doc_type
1149: AND cat_id = Nvl(p_cat_id,0)
1150: AND action = 'ADDED'
1151: 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');
1152:
1153: CURSOR get_none_csr IS
1154: SELECT action
1155: FROM okc_word_sync_t

Line 1155: FROM okc_word_sync_t

1151: 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');
1152:
1153: CURSOR get_none_csr IS
1154: SELECT action
1155: FROM okc_word_sync_t
1156: WHERE doc_id = p_doc_id
1157: AND doc_type = p_doc_type
1158: AND cat_id = p_cat_id
1159: AND action = 'NONE';

Line 1164: FROM okc_word_sync_t

1160:
1161: CURSOR get_placeholder_xml
1162: IS
1163: SELECT clob_data
1164: FROM okc_word_sync_t
1165: WHERE doc_id = p_doc_id
1166: AND doc_type = p_doc_type
1167: AND id=10;
1168:

Line 1196: UPDATE okc_word_sync_t

1192:
1193: x_action := t_action;
1194: x_wml_blob := clob_to_blob(l_placeholder_xml);
1195:
1196: UPDATE okc_word_sync_t
1197: SET action = 'UPDATEDASSIGNED' , clob_data = l_placeholder_xml
1198: WHERE doc_id = p_doc_id
1199: AND doc_type = p_doc_type
1200: AND cat_id = Nvl(p_cat_id,0)

Line 1218: UPDATE okc_word_sync_t

1214:
1215: x_action := t_action;
1216: x_wml_blob := t_blob_data;
1217:
1218: UPDATE okc_word_sync_t
1219: SET action = 'NONEASSIGNED'
1220: WHERE doc_id = p_doc_id
1221: AND doc_type = p_doc_type
1222: AND cat_id = p_cat_id

Line 1244: UPDATE okc_word_sync_t

1240: x_action := t_action;
1241: x_wml_blob := clob_to_blob(l_placeholder_xml);
1242:
1243:
1244: UPDATE okc_word_sync_t
1245: SET action = 'ADDEDASSIGNED' , clob_data = l_placeholder_xml
1246: WHERE doc_id = p_doc_id
1247: AND doc_type = p_doc_type
1248: AND cat_id = Nvl(p_cat_id,0)

Line 1286: SELECT action,clob_to_blob(clob_data) INTO t_action,t_blob_data FROM okc_word_sync_t

1282: l_id NUMBER;
1283: BEGIN
1284: IF p_cat_id IS NOT NULL THEN
1285: BEGIN
1286: SELECT action,clob_to_blob(clob_data) INTO t_action,t_blob_data FROM okc_word_sync_t
1287: WHERE doc_id = p_doc_id
1288: AND doc_type = p_doc_type
1289: AND cat_id = p_cat_id;
1290:

Line 1304: SELECT clob_to_blob(clob_data),id INTO t_blob_data,l_id FROM okc_word_sync_t

1300: ELSE
1301:
1302:
1303: BEGIN
1304: SELECT clob_to_blob(clob_data),id INTO t_blob_data,l_id FROM okc_word_sync_t
1305: WHERE doc_id = p_doc_id
1306: AND doc_type = p_doc_type
1307: AND action = 'ADDEDASSIGNED'
1308: 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 1308: 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');

1304: SELECT clob_to_blob(clob_data),id INTO t_blob_data,l_id FROM okc_word_sync_t
1305: WHERE doc_id = p_doc_id
1306: AND doc_type = p_doc_type
1307: AND action = 'ADDEDASSIGNED'
1308: 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');
1309:
1310: UPDATE okc_word_sync_t
1311: SET action = 'ADDEDDONE'
1312: WHERE id = l_id;

Line 1310: UPDATE okc_word_sync_t

1306: AND doc_type = p_doc_type
1307: AND action = 'ADDEDASSIGNED'
1308: 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');
1309:
1310: UPDATE okc_word_sync_t
1311: SET action = 'ADDEDDONE'
1312: WHERE id = l_id;
1313: EXCEPTION
1314: WHEN No_Data_Found THEN

Line 1332: from okc_review_upld_terms UPLD,OKC_WORD_SYNC_T WT

1328: BEGIN
1329:
1330: IF p_review_upld_terms_id IS NOT NULL THEN
1331: select wt.clob_data into x_art_wml
1332: from okc_review_upld_terms UPLD,OKC_WORD_SYNC_T WT
1333: where UPLD.REVIEW_UPLD_TERMS_ID = p_review_upld_terms_id
1334: and WT.doc_id = UPLD.document_id
1335: and WT.doc_type = UPLD.DOCUMENT_TYPE
1336: and WT.cat_id = UPLD.object_id