APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_ELEMENTS_TL

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

132: x_msg_error OUT NOCOPY VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2
134: )
135: IS
136: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
137: BEGIN
138: x_return_status := fnd_api.G_RET_STS_SUCCESS;
139:
140: SAVEPOINT populate_element_index_SAV;

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

141:
142: -- We do not use bulk update in this case because the concurrent request
143: -- is incompatbile with itself. Even we kick off the sync. request, it
144: -- will be in pending status until "DR" or "R" request is finished. So,
145: UPDATE /*+ parallel(t) */ cs_kb_elements_tl t
146: SET t.composite_text_index = 'B';
147:
148: COMMIT;
149:

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

578: IS
579: l_create_cmmd VARCHAR2(500):= NULL;
580:
581: l_index_version VARCHAR2(15) := '115.10.1';
582: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
583: BEGIN
584: l_create_cmmd :=
585: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
586: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '

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

581: l_index_version VARCHAR2(15) := '115.10.1';
582: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
583: BEGIN
584: l_create_cmmd :=
585: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
586: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '
587: ||' INDEXTYPE IS ctxsys.context '
588: ||' parameters (''datastore '||g_apps_short_name||'.CS_KB_ELES '
589: ||' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '

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

582: l_index_name VARCHAR2(30) := 'cs_kb_elements_tl_N2';
583: BEGIN
584: l_create_cmmd :=
585: ' CREATE INDEX '||g_cs_short_name||'.cs_kb_elements_tl_N2 on '
586: ||g_cs_short_name||'.cs_kb_elements_tl(composite_text_index) '
587: ||' INDEXTYPE IS ctxsys.context '
588: ||' parameters (''datastore '||g_apps_short_name||'.CS_KB_ELES '
589: ||' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
590: ||' lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

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

1058: -- 3679483 eof
1059: AND ROWNUM <= c_batch_size;
1060:
1061: l_statement_id NUMBER := 0;
1062: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
1063: l_num_batch_rows_updated NUMBER := 0;
1064: l_reindex_batch_size NUMBER := 300;
1065: l_mode VARCHAR2(10) := bmode;
1066: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

Line 1130: UPDATE cs_kb_elements_tl

1126: -- statements in the batch
1127: EXIT WHEN delay_marked_stmts_batch_csr%NOTFOUND;
1128:
1129: -- Immediately mark the statement composite text index column
1130: UPDATE cs_kb_elements_tl
1131: SET composite_text_index = 'U'
1132: WHERE element_id = l_statement_id;
1133:
1134: -- Clear the delayed index mark on the statement