eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SETS_TL

Line 41: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

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

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

45:
46: TYPE l_rowid_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
47: l_rowid_list l_rowid_type;
48:
49: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';
50: l_soln_comp_attach_index VARCHAR2(250) := 'CS_KB_SETS_ATTACH_TL_N3'; --12.1.3
51:
52: BEGIN
53: --12.1.3

Line 77: UPDATE cs_kb_sets_tl

73: --The else condition was commented to fix bug 8757484
74: IF attachment_flag = 'Y' THEN
75: FORALL i IN l_rowid_list.FIRST..l_rowid_list.LAST
76:
77: UPDATE cs_kb_sets_tl
78: SET composite_assoc_attach_index = 'R'
79: WHERE rowid = l_rowid_list(i);
80: --ELSE
81: FORALL i IN l_rowid_list.FIRST..l_rowid_list.LAST

Line 82: UPDATE cs_kb_sets_tl

78: SET composite_assoc_attach_index = 'R'
79: WHERE rowid = l_rowid_list(i);
80: --ELSE
81: FORALL i IN l_rowid_list.FIRST..l_rowid_list.LAST
82: UPDATE cs_kb_sets_tl
83: SET composite_assoc_index = 'R'
84: WHERE rowid = l_rowid_list(i);
85: END IF;
86: --12.1.3

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

426: IS
427: l_create_cmmd VARCHAR2(500):= NULL;
428: l_create_cmmd1 VARCHAR2(500):= NULL; --12.1.3
429: l_index_version VARCHAR2(15) := '115.10.1';
430: l_index_name VARCHAR2(30) := 'cs_kb_sets_tl_N3';
431: l_index_name1 VARCHAR2(30) := 'cs_kb_sets_attach_tl_N3';
432: l_dummy_col VARCHAR2(100):='.cs_kb_sets_tl(composite_assoc_index) '; --12.1.3
433: l_datastore VARCHAR2(100):= '.CS_KB_COMPOSITE_ELES '; --12.1.3
434:

Line 432: l_dummy_col VARCHAR2(100):='.cs_kb_sets_tl(composite_assoc_index) '; --12.1.3

428: l_create_cmmd1 VARCHAR2(500):= NULL; --12.1.3
429: l_index_version VARCHAR2(15) := '115.10.1';
430: l_index_name VARCHAR2(30) := 'cs_kb_sets_tl_N3';
431: l_index_name1 VARCHAR2(30) := 'cs_kb_sets_attach_tl_N3';
432: l_dummy_col VARCHAR2(100):='.cs_kb_sets_tl(composite_assoc_index) '; --12.1.3
433: l_datastore VARCHAR2(100):= '.CS_KB_COMPOSITE_ELES '; --12.1.3
434:
435: BEGIN
436:

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

436:
437:
438: l_create_cmmd :=
439: ' CREATE INDEX '||g_cs_short_name||'.'||l_index_name||' on '
440: || g_cs_short_name||'.cs_kb_sets_tl(composite_assoc_index) '
441: || ' INDEXTYPE IS ctxsys.context '
442: || ' parameters (''datastore '||g_apps_short_name||'.CS_KB_COMPOSITE_ELES '
443: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
444: || ' lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

Line 469: l_dummy_col :='.cs_kb_sets_tl(composite_assoc_attach_index) ';

465: -- 4321268_eof*/
466:
467: IF attachment_flag = 'Y' THEN
468: -- l_index_name := 'cs_kb_sets_attach_tl_N3';
469: l_dummy_col :='.cs_kb_sets_tl(composite_assoc_attach_index) ';
470: l_datastore := '.CS_KB_COMPOSITE_ATTACH_ELES ';
471: l_create_cmmd1 :=
472: ' CREATE INDEX '||g_cs_short_name||'.'||l_index_name1||' on '
473: || g_cs_short_name||l_dummy_col

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

850: AND ROWNUM <= c_batch_size;
851:
852: l_solution_id NUMBER := 0;
853:
854: l_soln_comp_index VARCHAR2(250) := 'CS_KB_SETS_TL_N3';
855: l_soln_comp_attach_index VARCHAR2(250):= 'CS_KB_SETS_ATTACH_TL_N3'; --12.1.3
856: l_num_batch_rows_updated NUMBER := 0;
857: l_reindex_batch_size NUMBER := 300;
858: l_mode VARCHAR2(10) := bmode;

Line 964: UPDATE cs_kb_sets_tl

960: EXIT WHEN delay_marked_solns_batch_csr%NOTFOUND;
961:
962: -- Immediately mark the solution composite text index column
963: /* Commented for 12.1.3
964: UPDATE cs_kb_sets_tl
965: SET composite_assoc_index = 'U'
966: WHERE set_id = l_solution_id;*/
967: --12.1.3
968: --IF attachment = 'Y' THEN

Line 969: UPDATE cs_kb_sets_tl

965: SET composite_assoc_index = 'U'
966: WHERE set_id = l_solution_id;*/
967: --12.1.3
968: --IF attachment = 'Y' THEN
969: UPDATE cs_kb_sets_tl
970: SET composite_assoc_attach_index = 'U'
971: WHERE set_id = l_solution_id;
972: --ELSE
973: UPDATE cs_kb_sets_tl

Line 973: UPDATE cs_kb_sets_tl

969: UPDATE cs_kb_sets_tl
970: SET composite_assoc_attach_index = 'U'
971: WHERE set_id = l_solution_id;
972: --ELSE
973: UPDATE cs_kb_sets_tl
974: SET composite_assoc_index = 'U'
975: WHERE set_id = l_solution_id;
976: --END IF;
977: --12.1.3

Line 1586: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

1582: retcode OUT nocopy NUMBER )
1583: IS
1584: CURSOR all_published_solutions IS
1585: SELECT tl.set_id
1586: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1587: WHERE b.set_id = tl.set_id
1588: AND b.status = 'PUB';
1589: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1590: solnIdList solnIdListType;

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

1585: SELECT tl.set_id
1586: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1587: WHERE b.set_id = tl.set_id
1588: AND b.status = 'PUB';
1589: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1590: solnIdList solnIdListType;
1591: lCommitBatchSize NUMBER := 100;
1592: lCounter NUMBER := 0;
1593: BEGIN