APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_ELEMENTS_TL

Line 107: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';

103: x_msg_error OUT NOCOPY VARCHAR2,
104: x_return_status OUT NOCOPY VARCHAR2
105: )
106: IS
107: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
108: BEGIN
109: x_return_status := fnd_api.G_RET_STS_SUCCESS;
110:
111: SAVEPOINT populate_element_index_SAV;

Line 116: UPDATE /*+ parallel(t) */ cs_kb_elements_tl t

112:
113: -- We do not use bulk update in this case because the concurrent request
114: -- is incompatbile with itself. Even we kick off the sync. request, it
115: -- will be in pending status until "DR" or "R" request is finished. So,
116: UPDATE /*+ parallel(t) */ cs_kb_elements_tl t
117: SET t.composite_text_index = 'B';
118:
119: COMMIT;
120:

Line 479: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';

475: IS
476: l_create_cmmd VARCHAR2(500):= NULL;
477:
478: l_index_version VARCHAR2(15) := '115.10.1';
479: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
480: BEGIN
481: l_create_cmmd :=
482: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
483: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '

Line 482: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '

478: l_index_version VARCHAR2(15) := '115.10.1';
479: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
480: BEGIN
481: l_create_cmmd :=
482: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
483: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '
484: ||' INDEXTYPE IS ctxsys.context '
485: ||' parameters (''datastore '||g_apps_short_name||'.CS_KB_ELES '
486: ||' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '

Line 483: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '

479: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
480: BEGIN
481: l_create_cmmd :=
482: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
483: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '
484: ||' INDEXTYPE IS ctxsys.context '
485: ||' parameters (''datastore '||g_apps_short_name||'.CS_KB_ELES '
486: ||' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
487: ||' lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

Line 913: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';

909: -- 3679483 eof
910: AND ROWNUM <= c_batch_size;
911:
912: l_statement_id NUMBER := 0;
913: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
914: l_num_batch_rows_updated NUMBER := 0;
915: l_reindex_batch_size NUMBER := 300;
916: l_mode VARCHAR2(10) := bmode;
917: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

Line 981: UPDATE cs_kb_elements_tl

977: -- statements in the batch
978: EXIT WHEN delay_marked_stmts_batch_csr%NOTFOUND;
979:
980: -- Immediately mark the statement composite text index column
981: UPDATE cs_kb_elements_tl
982: SET composite_text_index = 'U'
983: WHERE element_id = l_statement_id;
984:
985: -- Clear the delayed index mark on the statement