DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ART_VAR_EXT_TL

Line 305: DELETE FROM OKC_K_ART_VAR_EXT_TL

301: END IF;
302:
303: IF l_doc_type_tbl.COUNT > 0 THEN
304: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
305: DELETE FROM OKC_K_ART_VAR_EXT_TL
306: WHERE cat_id IN
307: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
308: WHERE document_type=l_doc_type_tbl(i)
309: and document_id=l_doc_id_tbl(i)

Line 332: DELETE FROM OKC_K_ART_VAR_EXT_TLH

328: WHERE document_type=l_doc_type_tbl(i)
329: and document_id=l_doc_id_tbl(i));
330:
331: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
332: DELETE FROM OKC_K_ART_VAR_EXT_TLH
333: WHERE cat_id IN
334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
335: WHERE document_type=l_doc_type_tbl(i)
336: and document_id=l_doc_id_tbl(i)