DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ART_VAR_EXT_B

Line 315: DELETE FROM OKC_K_ART_VAR_EXT_B

311: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE
312: AND ARTVAR.CAT_ID=KART.ID);
313:
314: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
315: DELETE FROM OKC_K_ART_VAR_EXT_B
316: WHERE cat_id IN
317: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
318: WHERE document_type=l_doc_type_tbl(i)
319: and document_id=l_doc_id_tbl(i)

Line 343: DELETE FROM OKC_K_ART_VAR_EXT_BH

339: AND ARTVAR.CAT_ID=KART.ID);
340:
341:
342: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
343: DELETE FROM OKC_K_ART_VAR_EXT_BH
344: WHERE cat_id IN
345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
346: WHERE document_type=l_doc_type_tbl(i)
347: and document_id=l_doc_id_tbl(i)