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 248: okc_k_articles_b k

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

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

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

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

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

Line 619: FROM okc_k_articles_b

615: l_cat_id NUMBER;
616:
617: CURSOR csr_new_cat_id IS
618: SELECT id
619: FROM okc_k_articles_b
620: WHERE orig_system_reference_code = 'COPY'
621: AND orig_system_reference_id1 = p_old_cat_id
622: AND document_type = p_doc_type
623: AND document_id = p_doc_id;