APPS.OKC_CLM_PKG dependencies on OKC_K_ARTICLES_B

Line 658: FROM okc_k_articles_b KA,

654: VB.clm_ref2,
655: VB.clm_ref3,
656: VB.clm_ref4,
657: VB.clm_ref5
658: FROM okc_k_articles_b KA,
659: okc_k_art_variables KV,
660: okc_bus_variables_b VB,
661: okc_bus_variables_tl VBT
662: WHERE VB.variable_code = KV.variable_code

Line 824: SELECT kvar.variable_value_id FROM okc_k_art_variables kvar,okc_k_articles_b kart

820: l_api_version CONSTANT NUMBER := 1.0;
821:
822: CURSOR udv_value_csr(p_doc_id number, p_article_id number, p_article_version_id NUMBER)
823: IS
824: SELECT kvar.variable_value_id FROM okc_k_art_variables kvar,okc_k_articles_b kart
825: WHERE kart.id = kvar.cat_id
826: AND kart.document_id = p_doc_id
827: AND kvar.variable_value_id IN
828: (SELECT avs.variable_value_id FROM okc_art_var_sections avs

Line 861: FROM okc_articles_all art,okc_k_articles_b kart

857:
858:
859: CURSOR doc_details_csr ( p_doc_id NUMBER) IS
860: SELECT art.ORG_ID,art.ARTICLE_INTENT,kart.document_type
861: FROM okc_articles_all art,okc_k_articles_b kart
862: WHERE art.ARTICLE_ID = kart.sav_sae_id
863: AND kart.document_id = p_doc_id
864: AND ROWNUM=1;
865:

Line 1171: UPDATE okc_k_articles_b

1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: l_remaining_scn_ids: '|| l_remaining_scn_ids);
1168: END IF;
1169:
1170: IF l_remaining_scn_ids IS NOT NULL THEN
1171: UPDATE okc_k_articles_b
1172: SET scn_id = l_dup_scn_id_tbl(1),
1173: display_sequence = display_sequence + ((SELECT Max(display_sequence) FROM okc_k_articles_b
1174: WHERE document_type = p_document_type AND document_id = p_document_id
1175: AND scn_id = l_dup_scn_id_tbl(1)))

Line 1173: display_sequence = display_sequence + ((SELECT Max(display_sequence) FROM okc_k_articles_b

1169:
1170: IF l_remaining_scn_ids IS NOT NULL THEN
1171: UPDATE okc_k_articles_b
1172: SET scn_id = l_dup_scn_id_tbl(1),
1173: display_sequence = display_sequence + ((SELECT Max(display_sequence) FROM okc_k_articles_b
1174: WHERE document_type = p_document_type AND document_id = p_document_id
1175: AND scn_id = l_dup_scn_id_tbl(1)))
1176: WHERE document_type = p_document_type
1177: AND document_id = p_document_id

Line 1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');

1177: AND document_id = p_document_id
1178: AND scn_id IN (l_remaining_scn_ids);
1179:
1180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'700: Update done on okc_k_articles_b table ');
1182: END IF;
1183:
1184: /*When all the articles are updated with the first section_id, delete the remaining sections from okc_sections_b table*/
1185:

Line 1253: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

1249: IS
1250:
1251: l_api_name CONSTANT VARCHAR2(30) := 'clm_remove_dup_articles';
1252:
1253: TYPE ArticleVersionIdList IS TABLE OF OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1254:
1255: l_art_ver_ids_tbl ArticleVersionIdList;
1256: l_dup_articles VARCHAR2(4000);
1257: l_del_stmt VARCHAR2(4000);

Line 1261: FROM okc_k_articles_b

1257: l_del_stmt VARCHAR2(4000);
1258:
1259: CURSOR l_get_dup_articles_csr IS
1260: SELECT sav_sae_id, scn_id
1261: FROM okc_k_articles_b
1262: WHERE document_type = p_document_type
1263: AND document_id = p_document_id
1264: GROUP BY sav_sae_id, scn_id
1265: HAVING (Count(sav_sae_id) >1 );

Line 1269: FROM okc_k_articles_b

1265: HAVING (Count(sav_sae_id) >1 );
1266:
1267: CURSOR l_get_dup_art_ids(p_article_id NUMBER, p_scn_id NUMBER) IS
1268: SELECT id
1269: FROM okc_k_articles_b
1270: where document_type = p_document_type
1271: AND document_id = p_document_id
1272: AND sav_sae_id = p_article_id
1273: AND scn_id = p_scn_id

Line 1300: l_del_stmt := 'DELETE FROM okc_k_articles_b WHERE id IN (' || l_dup_articles || ')';

1296: END IF;
1297: END LOOP;
1298:
1299: IF l_dup_articles IS NOT NULL THEN
1300: l_del_stmt := 'DELETE FROM okc_k_articles_b WHERE id IN (' || l_dup_articles || ')';
1301: EXECUTE IMMEDIATE l_del_stmt;
1302: END IF;
1303:
1304: END LOOP;