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_K_ART_VARIABLES_GRP dependencies on OKC_K_ARTICLES_B

Line 246: okc_k_articles_b k

242:
243: Cursor l_get_cat_id_csr IS
244: SELECT DISTINCT k.id
245: FROM okc_k_art_variables v,
246: okc_k_articles_b k
247: WHERE k.id = v.cat_id
248: AND NVL(v.override_global_yn,'N') <> 'Y'
249: AND v.variable_code = p_variable_code
250: AND k.document_type = p_doc_type

Line 304: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);

300: object_version_number = object_version_number + 1
301: WHERE variable_code = p_variable_code
302: AND NVL(override_global_yn,'N') <> 'Y'
303: AND cat_id IN
304: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);
305:
306: -- Update the global value for all records with override_global_yn = Y
307:
308: UPDATE okc_k_art_variables

Line 315: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);

311: object_version_number = object_version_number + 1
312: WHERE variable_code = p_variable_code
313: AND NVL(override_global_yn,'N') ='Y'
314: AND cat_id IN
315: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);
316:
317:
318: IF (l_debug = 'Y') THEN
319: okc_debug.log('400: Updating k article record', 2);

Line 612: FROM okc_k_articles_b

608: l_cat_id NUMBER;
609:
610: CURSOR csr_new_cat_id IS
611: SELECT id
612: FROM okc_k_articles_b
613: WHERE orig_system_reference_code = 'COPY'
614: AND orig_system_reference_id1 = p_old_cat_id
615: AND document_type = p_doc_type
616: AND document_id = p_doc_id;