APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ARTICLES_B

Line 341: FROM OKC_K_ARTICLES_B

337: l_dummy_var VARCHAR2(1) := '?';
338:
339: CURSOR l_cat_id_csr is
340: SELECT '!'
341: FROM OKC_K_ARTICLES_B
342: WHERE ID = p_cat_id;
343:
344: CURSOR l_attribute_value_set_id_csr is
345: SELECT '!'

Line 1979: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B

1975: IS
1976: CURSOR lock_csr IS
1977: SELECT rowid
1978: FROM OKC_K_ART_VARIABLES
1979: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
1980: WHERE SCN_ID=p_scn_id)
1981: FOR UPDATE NOWAIT;
1982:
1983: BEGIN

Line 2001: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B

1997: OPEN lock_csr;
1998: CLOSE lock_csr;
1999:
2000: DELETE FROM OKC_K_ART_VARIABLES
2001: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2002: WHERE SCN_ID=p_scn_id);
2003:
2004: /*IF (l_debug = 'Y') THEN
2005: Okc_Debug.Log('11000: Leaving Delete_set', 2);

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

2090:
2091: CURSOR lock_csr IS
2092: SELECT rowid
2093: FROM OKC_K_ART_VARIABLES
2094: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2095: document_type=p_doc_type AND
2096: document_id = p_doc_id)
2097: FOR UPDATE NOWAIT;
2098:

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

2113: OPEN lock_csr;
2114: CLOSE lock_csr;
2115:
2116: DELETE FROM OKC_K_ART_VARIABLES
2117: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2118: document_type=p_doc_type AND
2119: document_id = p_doc_id);
2120:
2121: /*IF (l_debug = 'Y') THEN

Line 2260: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B

2256: LAST_UPDATED_BY,
2257: LAST_UPDATE_LOGIN,
2258: LAST_UPDATE_DATE
2259: FROM OKC_K_ART_VARIABLES
2260: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B
2261: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2262: AND DOCUMENT_ID = P_DOC_ID);
2263:
2264: /*IF (l_debug = 'Y') THEN

Line 2356: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2352: LAST_UPDATED_BY,
2353: LAST_UPDATE_LOGIN,
2354: LAST_UPDATE_DATE
2355: FROM OKC_K_ART_VARIABLES_H
2356: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2357: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2358: AND DOCUMENT_ID = P_DOC_ID)
2359: AND major_version = p_major_version;
2360:

Line 2417: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2413: -- Restoring Base Table
2414: -----------------------------------------
2415: DELETE
2416: FROM OKC_K_ART_VARIABLES_H
2417: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2418: WHERE document_type = p_doc_type and document_id = p_doc_id)
2419: AND major_version = p_major_version;
2420:
2421: /*IF (l_debug = 'Y') THEN