APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ARTICLES_B

Line 347: FROM OKC_K_ARTICLES_B

343: l_dummy_var VARCHAR2(1) := '?';
344:
345: CURSOR l_cat_id_csr is
346: SELECT '!'
347: FROM OKC_K_ARTICLES_B
348: WHERE ID = p_cat_id;
349:
350: CURSOR l_attribute_value_set_id_csr is
351: SELECT '!'

Line 2004: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B

2000: IS
2001: CURSOR lock_csr IS
2002: SELECT rowid
2003: FROM OKC_K_ART_VARIABLES
2004: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2005: WHERE SCN_ID=p_scn_id)
2006: FOR UPDATE NOWAIT;
2007:
2008: CURSOR cat_mrv_csr

Line 2011: FROM OKC_K_ARTICLES_B KART

2007:
2008: CURSOR cat_mrv_csr
2009: IS
2010: SELECT kart.ID
2011: FROM OKC_K_ARTICLES_B KART
2012: , OKC_BUS_VARIABLES_B BUS_VAR
2013: , OKC_K_ART_VARIABLES KVAR
2014: WHERE kart.SCN_ID=p_scn_id
2015: AND KVAR.cat_id=kart.id

Line 2043: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B

2039: END LOOP;
2040:
2041:
2042: DELETE FROM OKC_K_ART_VARIABLES
2043: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2044: WHERE SCN_ID=p_scn_id);
2045:
2046: /*IF (l_debug = 'Y') THEN
2047: Okc_Debug.Log('11000: Leaving Delete_set', 2);

Line 2137: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE

2133:
2134: CURSOR lock_csr IS
2135: SELECT rowid
2136: FROM OKC_K_ART_VARIABLES
2137: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2138: document_type= p_doc_type AND
2139: document_id = p_doc_id
2140: AND
2141: (( p_retain_lock_terms_yn = 'N')

Line 2151: FROM OKC_K_ARTICLES_B KART

2147:
2148: CURSOR doc_mrv_csr
2149: IS
2150: SELECT kart.ID
2151: FROM OKC_K_ARTICLES_B KART
2152: , OKC_BUS_VARIABLES_B BUS_VAR
2153: , OKC_K_ART_VARIABLES KVAR
2154: WHERE kart.document_type=p_doc_type
2155: AND kart.document_id = p_doc_id

Line 2190: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE

2186: END LOOP;
2187:
2188:
2189: DELETE FROM OKC_K_ART_VARIABLES
2190: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2191: document_type=p_doc_type AND
2192: document_id = p_doc_id);
2193:
2194:

Line 2290: FROM OKC_K_ARTICLES_B KART

2286:
2287: CURSOR doc_mrv_csr
2288: IS
2289: SELECT kart.ID
2290: FROM OKC_K_ARTICLES_B KART
2291: , OKC_BUS_VARIABLES_B BUS_VAR
2292: , OKC_K_ART_VARIABLES KVAR
2293: WHERE kart.document_type=p_doc_type
2294: AND kart.document_id = p_doc_id

Line 2353: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B

2349: LAST_UPDATE_DATE,
2350: mr_variable_html,
2351: mr_variable_xml
2352: FROM OKC_K_ART_VARIABLES
2353: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B
2354: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2355: AND DOCUMENT_ID = P_DOC_ID);
2356: /*IF (l_debug = 'Y') THEN
2357: Okc_Debug.Log('10000: Leaving create_version', 2);

Line 2409: FROM OKC_K_ARTICLES_BH KART

2405:
2406: CURSOR doc_ver_mrv_csr
2407: IS
2408: SELECT kart.ID
2409: FROM OKC_K_ARTICLES_BH KART
2410: , OKC_BUS_VARIABLES_B BUS_VAR
2411: , OKC_K_ART_VARIABLES_H KVAR
2412: WHERE kart.document_type=p_doc_type
2413: AND kart.document_id = p_doc_id

Line 2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2468: LAST_UPDATE_DATE,
2469: mr_variable_html,
2470: mr_variable_xml
2471: FROM OKC_K_ART_VARIABLES_H
2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2473: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2474: AND DOCUMENT_ID = P_DOC_ID)
2475: AND major_version = p_major_version;
2476:

Line 2523: FROM OKC_K_ARTICLES_BH KART

2519: IS
2520: CURSOR doc_ver_mrv_csr
2521: IS
2522: SELECT kart.ID
2523: FROM OKC_K_ARTICLES_BH KART
2524: , OKC_BUS_VARIABLES_B BUS_VAR
2525: , OKC_K_ART_VARIABLES_H KVAR
2526: WHERE kart.document_type=p_doc_type
2527: AND kart.document_id = p_doc_id

Line 2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2549: END LOOP;
2550:
2551: DELETE
2552: FROM OKC_K_ART_VARIABLES_H
2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2554: WHERE document_type = p_doc_type and document_id = p_doc_id)
2555: AND major_version = p_major_version;
2556:
2557: /*IF (l_debug = 'Y') THEN