APPS.CS_SR_SYNC_INDEX_PKG dependencies on CS_INCIDENTS_ALL_TL

Line 84: '.SUMMARY_CTX_INDEX on cs_incidents_all_tl(summary) '||

80:
81: --2. Create summary index.
82: l_create_cmmd :=
83: ' create index '||g_cs_short_name||
84: '.SUMMARY_CTX_INDEX on cs_incidents_all_tl(summary) '||
85: ' indextype is ctxsys.context '||
86: ' parameters(''lexer ' || g_apps_short_name || '.CS_SR_GLOBAL_LEXER '||
87: ' language column source_lang '||
88: ' memory 10M '||

Line 434: FROM cs_incidents_all_tl;

430: x_return_status OUT NOCOPY VARCHAR2)
431: IS
432: CURSOR all_srs IS
433: SELECT rowid
434: FROM cs_incidents_all_tl;
435:
436: TYPE l_rowid_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
437: l_rowid_list l_rowid_type;
438: l_index_name VARCHAR2(250);

Line 443: l_index_name := 'CS_INCIDENTS_ALL_TL_N1';

439:
440: BEGIN
441: -- Initialize local variables.
442: x_return_status := fnd_api.G_RET_STS_SUCCESS;
443: l_index_name := 'CS_INCIDENTS_ALL_TL_N1';
444:
445: -- Bulk fetch a list of row id
446: OPEN all_srs;
447: LOOP

Line 450: UPDATE cs_incidents_all_tl

446: OPEN all_srs;
447: LOOP
448: FETCH all_srs BULK COLLECT INTO l_rowid_list limit G_BATCH_SIZE;
449: FORALL i IN l_rowid_list.FIRST..l_rowid_list.LAST
450: UPDATE cs_incidents_all_tl
451: SET text_index = 'X'
452: WHERE rowid = l_rowid_list(i);
453:
454: COMMIT;

Line 487: * Synchronize the CS_INCIDENTS_ALL_TL_N1 text index.

483: -- 4917652_eof
484:
485: /*
486: * Sync_Text_Index
487: * Synchronize the CS_INCIDENTS_ALL_TL_N1 text index.
488: * Supported mode: S, DR, OFAST, OFAST, R
489: */
490: PROCEDURE Sync_Text_Index (
491: ERRBUF OUT NOCOPY VARCHAR2,

Line 498: index3 VARCHAR2(250) := 'CS_INCIDENTS_ALL_TL_N1';

494: PINDEX_WITH IN VARCHAR2,
495: pworker IN NUMBER DEFAULT 0)
496:
497: IS
498: index3 VARCHAR2(250) := 'CS_INCIDENTS_ALL_TL_N1';
499: l_mode VARCHAR2(10) := bmode;
500: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
501: l_create_cmmd VARCHAR2(500):= NULL;
502: l_index_with varchar2(30) := pindex_with;

Line 529: ' CREATE INDEX '||g_cs_short_name||'.cs_incidents_all_tl_n1 '

525: END IF;
526:
527: -- Create the index
528: l_create_cmmd :=
529: ' CREATE INDEX '||g_cs_short_name||'.cs_incidents_all_tl_n1 '
530: ||'on '||g_cs_short_name||'.cs_incidents_all_tl(text_index) '
531: ||' indextype is ctxsys.context parameters ('''
532: ||' datastore '||g_apps_short_name||'.CS_SR_TEXT_INDEX_ELES '
533: ||' section group '||g_apps_short_name||'.CS_SR_BASIC_GRP '

Line 530: ||'on '||g_cs_short_name||'.cs_incidents_all_tl(text_index) '

526:
527: -- Create the index
528: l_create_cmmd :=
529: ' CREATE INDEX '||g_cs_short_name||'.cs_incidents_all_tl_n1 '
530: ||'on '||g_cs_short_name||'.cs_incidents_all_tl(text_index) '
531: ||' indextype is ctxsys.context parameters ('''
532: ||' datastore '||g_apps_short_name||'.CS_SR_TEXT_INDEX_ELES '
533: ||' section group '||g_apps_short_name||'.CS_SR_BASIC_GRP '
534: ||' lexer '||g_apps_short_name