APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SETS_TL

Line 39: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

35: )
36: IS
37: CURSOR all_published_solutions IS
38: SELECT tl.rowid -- tl.set_id
39: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
40: WHERE b.set_id = tl.set_id
41: AND b.status = 'PUB';
42:
43:

Line 47: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';

43:
44: TYPE l_rowid_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
45: l_rowid_list l_rowid_type;
46:
47: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';
48:
49: BEGIN
50: x_return_status := fnd_api.G_RET_STS_SUCCESS;
51:

Line 57: UPDATE cs_kb_sets_tl

53: OPEN all_published_solutions;
54: LOOP
55: FETCH all_published_solutions BULK COLLECT INTO l_rowid_list limit G_BATCH_SIZE;
56: FORALL i IN l_rowid_list.FIRST..l_rowid_list.LAST
57: UPDATE cs_kb_sets_tl
58: SET composite_assoc_index = 'R'
59: -- ,last_update_date = SYSDATE --- do not checkin updating last_update_date
60: WHERE rowid = l_rowid_list(i);
61:

Line 401: l_index_name VARCHAR2(30) := 'cs_kb_sets_tl_N3';

397: )
398: IS
399: l_create_cmmd VARCHAR2(500):= NULL;
400: l_index_version VARCHAR2(15) := '115.10.1';
401: l_index_name VARCHAR2(30) := 'cs_kb_sets_tl_N3';
402:
403: BEGIN
404:
405: l_create_cmmd :=

Line 407: || g_cs_short_name||'.cs_kb_sets_tl(composite_assoc_index) '

403: BEGIN
404:
405: l_create_cmmd :=
406: ' CREATE INDEX '||g_cs_short_name||'.'||l_index_name||' on '
407: || g_cs_short_name||'.cs_kb_sets_tl(composite_assoc_index) '
408: || ' INDEXTYPE IS ctxsys.context '
409: || ' parameters (''datastore '||g_apps_short_name||'.CS_KB_COMPOSITE_ELES '
410: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
411: || ' lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

Line 749: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';

745: -- 3679483 eof
746: AND ROWNUM <= c_batch_size;
747:
748: l_solution_id NUMBER := 0;
749: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';
750: l_num_batch_rows_updated NUMBER := 0;
751: l_reindex_batch_size NUMBER := 300;
752: l_mode VARCHAR2(10) := bmode;
753:

Line 826: UPDATE cs_kb_sets_tl

822: -- statements in the batch
823: EXIT WHEN delay_marked_solns_batch_csr%NOTFOUND;
824:
825: -- Immediately mark the solution composite text index column
826: UPDATE cs_kb_sets_tl
827: SET composite_assoc_index = 'U'
828: WHERE set_id = l_solution_id;
829:
830: -- Clear the delayed index mark on the solution

Line 1437: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

1433: retcode OUT nocopy NUMBER )
1434: IS
1435: CURSOR all_published_solutions IS
1436: SELECT tl.set_id
1437: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1438: WHERE b.set_id = tl.set_id
1439: AND b.status = 'PUB';
1440: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1441: solnIdList solnIdListType;

Line 1440: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;

1436: SELECT tl.set_id
1437: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1438: WHERE b.set_id = tl.set_id
1439: AND b.status = 'PUB';
1440: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1441: solnIdList solnIdListType;
1442: lCommitBatchSize NUMBER := 100;
1443: lCounter NUMBER := 0;
1444: BEGIN