APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ART_VARIABLES

Line 307: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

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)
310: AND BUSVAR.mrv_flag='Y'
311: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 317: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

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)
320: AND BUSVAR.mrv_flag='Y'
321: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 325: DELETE FROM OKC_K_ART_VARIABLES

321: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE
322: AND ARTVAR.CAT_ID=KART.ID);
323:
324: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
325: DELETE FROM OKC_K_ART_VARIABLES
326: WHERE cat_id IN
327: ( SELECT ID FROM OKC_K_ARTICLES_B
328: WHERE document_type=l_doc_type_tbl(i)
329: and document_id=l_doc_id_tbl(i));

Line 334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

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)
337: AND BUSVAR.mrv_flag='Y'
338: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

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)
348: AND BUSVAR.mrv_flag='Y'
349: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 354: DELETE FROM OKC_K_ART_VARIABLES_H

350: AND ARTVAR.CAT_ID=KART.ID);
351:
352:
353: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
354: DELETE FROM OKC_K_ART_VARIABLES_H
355: WHERE cat_id IN
356: ( SELECT ID FROM OKC_K_ARTICLES_BH
357: WHERE document_type=l_doc_type_tbl(i)
358: and document_id=l_doc_id_tbl(i));

Line 511: from okc_k_art_variables var, okc_k_articles_b kart

507: i BINARY_INTEGER;
508:
509: CURSOR var_codes_crs IS
510: select distinct var.variable_code
511: from okc_k_art_variables var, okc_k_articles_b kart
512: where kart.document_type = p_doc_type
513: and kart.document_id = p_doc_id
514: and kart.amendment_Operation_code is null
515: and kart.id=var.cat_id