eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ARTICLES_B

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 327: ( SELECT ID FROM OKC_K_ARTICLES_B

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));
330:
331: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

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 356: ( SELECT ID FROM OKC_K_ARTICLES_BH

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));
359:
360: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 361: DELETE FROM OKC_K_ARTICLES_B

357: WHERE document_type=l_doc_type_tbl(i)
358: and document_id=l_doc_id_tbl(i));
359:
360: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
361: DELETE FROM OKC_K_ARTICLES_B
362: WHERE document_type=l_doc_type_tbl(i)
363: and document_id=l_doc_id_tbl(i);
364:
365: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 366: DELETE FROM OKC_K_ARTICLES_BH

362: WHERE document_type=l_doc_type_tbl(i)
363: and document_id=l_doc_id_tbl(i);
364:
365: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
366: DELETE FROM OKC_K_ARTICLES_BH
367: WHERE document_type=l_doc_type_tbl(i)
368: and document_id=l_doc_id_tbl(i);
369:
370: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

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

Line 726: FROM okc_k_articles_b kart, okc_articles_all a

722: l_return_value VARCHAR2(100) := G_NO_ARTICLE_EXIST;
723:
724: CURSOR find_art_crs IS
725: SELECT a.standard_yn
726: FROM okc_k_articles_b kart, okc_articles_all a
727: WHERE kart.document_type=p_doc_type
728: AND kart.document_id=p_doc_id
729: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
730: AND nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1000: FROM okc_k_articles_b a

996: l_deliverable_changed VARCHAR2(1) := 'N';
997:
998: CURSOR find_art_crs IS
999: SELECT 'Y'
1000: FROM okc_k_articles_b a
1001: WHERE ( document_type=p_doc_type AND document_id=p_doc_id AND source_flag
1002: IS NULL )
1003:
1004: OR (

Line 1009: (SELECT 'x' from okc_k_articles_b b

1005: document_type='TEMPLATE' AND document_id IN
1006: (SELECT template_id FROM okc_template_usages
1007: WHERE document_type=p_doc_type AND document_id=p_doc_id )
1008: AND NOT EXISTS
1009: (SELECT 'x' from okc_k_articles_b b
1010: WHERE b.document_type=p_doc_type AND b.document_id=p_doc_id
1011: AND ( b.sav_sae_id=a.sav_sae_id /*or b.ref_article_id=a.sav_sae_id*/) )
1012: )
1013: ;

Line 1272: FROM okc_k_articles_b kart, okc_articles_all a

1268: l_dummy VARCHAR2(1) := '?';
1269: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1270: CURSOR find_art_crs IS
1271: SELECT a.standard_yn
1272: FROM okc_k_articles_b kart, okc_articles_all a
1273: WHERE kart.document_type=p_doc_type
1274: AND kart.document_id=p_doc_id
1275: AND kart.summary_amend_operation_code IS NOT NULL
1276: AND a.article_id = kart.sav_sae_id

Line 1690: FROM OKC_K_ARTICLES_B

1686: l_contract_source_code okc_template_usages.contract_source_code%TYPE := 'STRUCTURED';
1687:
1688: Cursor l_get_max_art_date_csr IS
1689: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1690: FROM OKC_K_ARTICLES_B
1691: WHERE DOCUMENT_TYPE=p_doc_type
1692: AND DOCUMENT_ID=p_doc_id;
1693:
1694: Cursor l_get_max_scn_date_csr IS

Line 1702: FROM OKC_K_ARTICLES_BH

1698: AND DOCUMENT_ID=p_doc_id;
1699:
1700: Cursor l_get_max_art_hist_date_csr IS
1701: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1702: FROM OKC_K_ARTICLES_BH
1703: WHERE DOCUMENT_TYPE=p_doc_type
1704: AND DOCUMENT_ID=p_doc_id;
1705:
1706: Cursor l_get_max_scn_hist_date_csr IS

Line 2196: FROM okc_k_articles_b kart

2192: l_return_value VARCHAR2(1) := FND_API.G_FALSE;
2193:
2194: CURSOR find_art_crs IS
2195: SELECT '!'
2196: FROM okc_k_articles_b kart
2197: WHERE kart.document_type=p_doc_type
2198: AND kart.document_id=p_doc_id
2199: AND kart.source_flag IS NULL
2200: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 4404: From okc_k_articles_b

4400:
4401: CURSOR cur_art_details (cp_kart_sec_id IN NUMBER)
4402: IS
4403: SELECT orig_system_reference_code, orig_system_reference_id1, document_type,document_id
4404: From okc_k_articles_b
4405: Where id= cp_kart_sec_id ;
4406: l_tgt_art_details_rec cur_art_details%ROWTYPE;
4407: l_src_art_details_rec cur_art_details%ROWTYPE;
4408:

Line 4526: From okc_k_articles_b

4522:
4523: CURSOR cur_art_details
4524: IS
4525: SELECT orig_system_reference_code, orig_system_reference_id1
4526: From okc_k_articles_b
4527: Where id= p_kart_sec_id ;
4528: l_art_details_rec cur_art_details%ROWTYPE;
4529: l_lock_exists VARCHAR2(1);
4530: BEGIN