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_REVIEW_UPLD_TERMS_PVT dependencies on OKC_WORD_SYNC_T

Line 2085: UPDATE okc_word_sync_t

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
2087: WHERE doc_id = p_document_id
2088: AND doc_type = p_document_type
2089: AND action = 'ADDEDASSIGNED';

Line 2688: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;

2684: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2685: END IF;
2686:
2687: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2688: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2689:
2690: -- Standard check of p_commit
2691: IF FND_API.To_Boolean( p_commit ) THEN
2692: COMMIT WORK;

Line 2776: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;

2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2773: END IF;
2774:
2775: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2776: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2777:
2778: -- Standard check of p_commit
2779: IF FND_API.To_Boolean( p_commit ) THEN
2780: COMMIT WORK;

Line 3665: (EXISTS (SELECT 1 FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID AND action = 'UPDATEDASSIGNED'))));

3661: AND KART.DOCUMENT_ID = UT.DOCUMENT_ID
3662:
3663: AND (
3664: (NVL(VER.DISPLAY_NAME,ART.ARTICLE_TITLE) <> to_char(UT.OBJECT_TITLE)) OR
3665: (EXISTS (SELECT 1 FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID AND action = 'UPDATEDASSIGNED'))));
3666: -- ('UPDATED' = (SELECT ACTION FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID))));
3667:
3668:
3669: ELSE

Line 3666: -- ('UPDATED' = (SELECT ACTION FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID))));

3662:
3663: AND (
3664: (NVL(VER.DISPLAY_NAME,ART.ARTICLE_TITLE) <> to_char(UT.OBJECT_TITLE)) OR
3665: (EXISTS (SELECT 1 FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID AND action = 'UPDATEDASSIGNED'))));
3666: -- ('UPDATED' = (SELECT ACTION FROM OKC_WORD_SYNC_T WHERE DOC_ID = P_DOCUMENT_ID AND DOC_TYPE = P_DOCUMENT_TYPE AND CAT_ID = UT.OBJECT_ID))));
3667:
3668:
3669: ELSE
3670: