APPS.OKC_CODE_HOOK dependencies on OKC_K_ARTICLES_B

Line 309: UPDATE okc_k_articles_b

305:
306: -- Execute the update statement
307: -- Oracle Database 10g Release 1 (10.1.0.2)
308: FORALL i IN indices OF l_outcome_tbl
309: UPDATE okc_k_articles_b
310: SET mandatory_yn = Nvl(l_outcome_tbl(i).mandatory_yn,l_tmp_lvl_mandatory_flag)
311: ,mandatory_rwa = l_outcome_tbl(i).mandatory_rwa
312: WHERE document_type = p_doc_type
313: AND document_id = p_doc_id

Line 318: G_PKG_NAME, '140: sync_rwa_with_document : After updating okc_k_articles_b table');

314: AND sav_sae_id = l_outcome_tbl(i).clause_id ;
315:
316: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
317: FND_LOG.STRING(G_PROC_LEVEL,
318: G_PKG_NAME, '140: sync_rwa_with_document : After updating okc_k_articles_b table');
319: END IF;
320:
321: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
322: FND_LOG.STRING(G_PROC_LEVEL,

Line 403: FROM okc_k_articles_b,okc_articles_all

399: SubStr(article_number,InStr(article_number,'.')+1,InStr(article_number,' ')-InStr(article_number,'.')))),SubStr(article_number,InStr(article_number,'.')+1, InStr(article_number,'-')-InStr(article_number,'.')-1)) col2,
400: Decode(InStr(article_number,' '),0,Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1)),
401: Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1, InStr(article_number,' ')-InStr(article_number,'-')-1))) col3,
402: Decode(InStr(article_number,' '),0,' ',SubStr(article_number,InStr(article_number,' ')+1)) col4
403: FROM okc_k_articles_b,okc_articles_all
404: WHERE document_type=p_doc_type AND
405: document_id=p_doc_id AND
406: sav_sae_id=article_id
407: ORDER BY scn_id,To_Number(col1),To_Number(col2),To_Number(col3),col4);

Line 412: FROM okc_k_articles_b,okc_articles_all

408:
409:
410: cursor c_sort_aplhanumeric is
411: SELECT id,scn_id
412: FROM okc_k_articles_b,okc_articles_all
413: WHERE document_type=p_doc_type AND
414: document_id=p_doc_id AND
415: sav_sae_id=article_id
416: ORDER BY scn_id,article_number;