PACKAGE: APPS.OKC_WORD_DOWNLOAD_UPLOAD

Source

1 PACKAGE okc_word_download_upload AUTHID CURRENT_USER AS
2 /* $Header: OKCWDUPS.pls 120.1.12020000.5 2012/12/12 10:29:31 skavutha ship $ */
3 
4 -- Download Procedures
5 
6 PROCEDURE DOWNLOAD_PRE_PROCESSOR(p_doc_id NUMBER,p_doc_type VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,x_msg_data OUT NOCOPY VARCHAR2);
7 PROCEDURE DOWNLOAD_POST_PROCESSOR(p_doc_id NUMBER,p_doc_type VARCHAR2,x_return_status OUT NOCOPY VARCHAR2,x_msg_data OUT NOCOPY VARCHAR2);
8 FUNCTION get_article_body(p_text_in_word IN BLOB) RETURN CLOB;
9 FUNCTION RESOLVE_VARIABLES_DOWNLOAD(p_art_XML XMLType,p_var_XML XMLType) RETURN XMLType;
10 
11 PROCEDURE UPLOAD_PRE_PROCESSOR(p_doc_id NUMBER,p_doc_type VARCHAR2, p_cust_tag_exists IN VARCHAR2 DEFAULT 'Y'
12                                                           ,x_return_status OUT NOCOPY VARCHAR2,x_msg_data OUT NOCOPY VARCHAR2);
13 FUNCTION UPLOAD_POST_PROCESSOR(p_doc_id NUMBER,p_doc_type VARCHAR2,p_cat_id NUMBER) return BLOB;
14 FUNCTION RESOLVE_VARIABLES_UPLOAD(p_art_CLOB CLOB) RETURN CLOB;
15 
16 -- Utility Procedures
17 FUNCTION BLOB_TO_CLOB(p_text_in_word IN BLOB) RETURN CLOB;
18 FUNCTION CLOB_TO_BLOB(p_clob IN CLOB) return BLOB;
19 FUNCTION GET_WORD_SYNC_PROFILE RETURN VARCHAR2;
20 PROCEDURE INSERT_WML_TEXT(p_article_version_id NUMBER, p_article_text_in_word BLOB);
21 PROCEDURE STRIP_TAGS (p_doc_id NUMBER, p_doc_type VARCHAR2);
22 FUNCTION GET_ARTICLE_WML(p_art_clob XMLType,p_doc_clob CLOB) return BLOB;
23 FUNCTION get_articleWML_Text(p_art_blob BLOB) return CLOB;
24 FUNCTION get_articleWML_Text(p_art_blob CLOB) return CLOB;
25 PROCEDURE get_latest_wml (p_doc_id IN NUMBER, p_doc_type IN VARCHAR2, p_cat_id IN NUMBER DEFAULT NULL,x_action OUT NOCOPY VARCHAR2, x_wml_blob OUT BLOB,
26         x_return_status OUT NOCOPY VARCHAR2,x_msg_data OUT NOCOPY VARCHAR2);
27 FUNCTION get_latest_wmlblob (p_doc_id IN NUMBER, p_doc_type IN VARCHAR2, p_cat_id IN NUMBER DEFAULT NULL) RETURN BLOB;
28 PROCEDURE get_article_html_for_comp(p_art_ver_id IN NUMBER,p_review_upld_terms_id IN NUMBER,x_art_html OUT NOCOPY BLOB,x_success OUT NOCOPY VARCHAR2);
29 FUNCTION convert_wml_to_html_1(p_art_wml CLOB) return CLOB;
30 FUNCTION convert_rows_to_html(p_table CLOB) return CLOB;
31 FUNCTION convert_cells_to_html(p_row CLOB) return CLOB;
32 FUNCTION clean_html_diff(p_html_diff CLOB) RETURN CLOB;
33 FUNCTION change_encoding(p_clob CLOB) RETURN CLOB;
34 END OKC_WORD_DOWNLOAD_UPLOAD;