APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_WORD_DOWNLOAD_UPLOAD

Line 1969: --OKC_WORD_DOWNLOAD_UPLOAD.UPLOAD_POST_PROCESSOR(p_document_id,p_document_type,object_id)

1965: lock_text,
1966: new_parent_id,
1967: object_title,
1968: old_review_upld_terms_id --,
1969: --OKC_WORD_DOWNLOAD_UPLOAD.UPLOAD_POST_PROCESSOR(p_document_id,p_document_type,object_id)
1970: --OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, object_id)
1971: FROM okc_review_upld_terms
1972: WHERE document_id = p_document_id
1973: AND document_type = p_document_type

Line 1970: --OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, object_id)

1966: new_parent_id,
1967: object_title,
1968: old_review_upld_terms_id --,
1969: --OKC_WORD_DOWNLOAD_UPLOAD.UPLOAD_POST_PROCESSOR(p_document_id,p_document_type,object_id)
1970: --OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, object_id)
1971: FROM okc_review_upld_terms
1972: WHERE document_id = p_document_id
1973: AND document_type = p_document_type
1974: CONNECT BY PRIOR review_upld_terms_id = new_parent_id

Line 2082: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;

2078: END IF;
2079:
2080: END IF;
2081: --2 way word sync with clause edit begins
2082: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;
2083: IF l_prof_value = 'Y' THEN
2084: OPEN accepted_terms_with_wml_csr;
2085: UPDATE okc_word_sync_t
2086: SET cat_id = NULL

Line 2116: obj_texts_wml(i) := OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, obj_ids(i));

2112:
2113: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2114: LOOP
2115: IF obj_types(i) = 'ARTICLE' THEN
2116: obj_texts_wml(i) := OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, obj_ids(i));
2117: ELSE
2118: obj_texts_wml(i) := NULL;
2119: END IF;
2120: END LOOP;

Line 2304: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));

2300: obj_ids(i) := l_cat_id;
2301: art_vers(i) := l_article_version_id;
2302:
2303: IF l_prof_value = 'Y' THEN
2304: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2305: END IF;
2306:
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: After calling OKC_K_NON_STD_ART_GRP.create_non_std_article');

Line 2408: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));

2404:
2405: obj_ids(i) := l_cat_id;
2406: art_vers(i) := l_article_version_id;
2407: IF l_prof_value = 'Y' THEN
2408: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2409: END IF;
2410:
2411:
2412: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2493: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));

2489:
2490: obj_ids(i) := l_cat_id;
2491: art_vers(i) := l_article_version_id;
2492: IF l_prof_value = 'Y' THEN
2493: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2494: END IF;
2495:
2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');

Line 3638: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;

3634: end loop;
3635:
3636:
3637: -- 2 way word sync with clause edit begins
3638: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;
3639: IF l_prof_value = 'Y' THEN
3640:
3641: UPDATE OKC_REVIEW_UPLD_TERMS UT
3642: SET ACTION='UPDATED',

Line 4008: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;

4004: and rev.document_id = p_document_id);
4005:
4006:
4007: -- 2 way word sync with clause edit begins
4008: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;
4009: IF l_prof_value = 'Y' THEN
4010: NULL;
4011: ELSE
4012: