APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ARTICLES_B

Line 267: ( SELECT ID FROM OKC_K_ARTICLES_B

263:
264: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
265: DELETE FROM OKC_K_ART_VARIABLES
266: WHERE cat_id IN
267: ( SELECT ID FROM OKC_K_ARTICLES_B
268: WHERE document_type=l_doc_type_tbl(i)
269: and document_id=l_doc_id_tbl(i));
270:
271: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 274: ( SELECT ID FROM OKC_K_ARTICLES_BH

270:
271: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
272: DELETE FROM OKC_K_ART_VARIABLES_H
273: WHERE cat_id IN
274: ( SELECT ID FROM OKC_K_ARTICLES_BH
275: WHERE document_type=l_doc_type_tbl(i)
276: and document_id=l_doc_id_tbl(i));
277:
278: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 279: DELETE FROM OKC_K_ARTICLES_B

275: WHERE document_type=l_doc_type_tbl(i)
276: and document_id=l_doc_id_tbl(i));
277:
278: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
279: DELETE FROM OKC_K_ARTICLES_B
280: WHERE document_type=l_doc_type_tbl(i)
281: and document_id=l_doc_id_tbl(i);
282:
283: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 284: DELETE FROM OKC_K_ARTICLES_BH

280: WHERE document_type=l_doc_type_tbl(i)
281: and document_id=l_doc_id_tbl(i);
282:
283: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
284: DELETE FROM OKC_K_ARTICLES_BH
285: WHERE document_type=l_doc_type_tbl(i)
286: and document_id=l_doc_id_tbl(i);
287:
288: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 421: from okc_k_art_variables var, okc_k_articles_b kart

417: i BINARY_INTEGER;
418:
419: CURSOR var_codes_crs IS
420: select distinct var.variable_code
421: from okc_k_art_variables var, okc_k_articles_b kart
422: where kart.document_type = p_doc_type
423: and kart.document_id = p_doc_id
424: and kart.amendment_Operation_code is null
425: and kart.id=var.cat_id

Line 635: FROM okc_k_articles_b kart, okc_articles_all a

631: l_return_value VARCHAR2(100) := G_NO_ARTICLE_EXIST;
632:
633: CURSOR find_art_crs IS
634: SELECT a.standard_yn
635: FROM okc_k_articles_b kart, okc_articles_all a
636: WHERE kart.document_type=p_doc_type
637: AND kart.document_id=p_doc_id
638: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
639: AND nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 896: FROM okc_k_articles_b a

892: l_deliverable_changed VARCHAR2(1) := 'N';
893:
894: CURSOR find_art_crs IS
895: SELECT 'Y'
896: FROM okc_k_articles_b a
897: WHERE ( document_type=p_doc_type AND document_id=p_doc_id AND source_flag
898: IS NULL )
899:
900: OR (

Line 905: (SELECT 'x' from okc_k_articles_b b

901: document_type='TEMPLATE' AND document_id IN
902: (SELECT template_id FROM okc_template_usages
903: WHERE document_type=p_doc_type AND document_id=p_doc_id )
904: AND NOT EXISTS
905: (SELECT 'x' from okc_k_articles_b b
906: WHERE b.document_type=p_doc_type AND b.document_id=p_doc_id
907: AND ( b.sav_sae_id=a.sav_sae_id or b.ref_article_id=a.sav_sae_id) )
908: )
909: ;

Line 1168: FROM okc_k_articles_b kart, okc_articles_all a

1164: l_dummy VARCHAR2(1) := '?';
1165: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1166: CURSOR find_art_crs IS
1167: SELECT a.standard_yn
1168: FROM okc_k_articles_b kart, okc_articles_all a
1169: WHERE kart.document_type=p_doc_type
1170: AND kart.document_id=p_doc_id
1171: AND kart.summary_amend_operation_code IS NOT NULL
1172: AND a.article_id = kart.sav_sae_id

Line 1586: FROM OKC_K_ARTICLES_B

1582: l_contract_source_code okc_template_usages.contract_source_code%TYPE := 'STRUCTURED';
1583:
1584: Cursor l_get_max_art_date_csr IS
1585: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1586: FROM OKC_K_ARTICLES_B
1587: WHERE DOCUMENT_TYPE=p_doc_type
1588: AND DOCUMENT_ID=p_doc_id;
1589:
1590: Cursor l_get_max_scn_date_csr IS

Line 1598: FROM OKC_K_ARTICLES_BH

1594: AND DOCUMENT_ID=p_doc_id;
1595:
1596: Cursor l_get_max_art_hist_date_csr IS
1597: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1598: FROM OKC_K_ARTICLES_BH
1599: WHERE DOCUMENT_TYPE=p_doc_type
1600: AND DOCUMENT_ID=p_doc_id;
1601:
1602: Cursor l_get_max_scn_hist_date_csr IS

Line 2087: FROM okc_k_articles_b kart

2083: l_return_value VARCHAR2(1) := FND_API.G_FALSE;
2084:
2085: CURSOR find_art_crs IS
2086: SELECT '!'
2087: FROM okc_k_articles_b kart
2088: WHERE kart.document_type=p_doc_type
2089: AND kart.document_id=p_doc_id
2090: AND kart.source_flag IS NULL
2091: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED