9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
415: -- CALL to Code hook for further processing
416: OKC_WORD_SYNC_HOOK.DOWNLOAD_CONTRACT_EXT(
417: p_doc_type => p_doc_type,
418: p_doc_id => p_doc_id,
419: p_init_msg_list => FND_API.G_FALSE,
420: x_contract_xml => l_doc_clob,
421: x_return_status => l_return_status,
422: x_msg_count => l_msg_count,
423: x_msg_data => l_msg_data
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:
1355: END get_article_html_for_comp;
1356:
1357: function convert_wml_to_html_1(p_art_wml CLOB) return CLOB as