APPS.CS_KB_CONC_PROG_PKG dependencies on CS_FORUM_MESSAGES_TL

Line 208: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';

204: x_msg_error OUT NOCOPY VARCHAR2,
205: x_return_status OUT NOCOPY VARCHAR2
206: )
207: IS
208: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
209: BEGIN
210: x_return_status := fnd_api.G_RET_STS_SUCCESS;
211:
212: SAVEPOINT populate_forum_index_SAV;

Line 214: UPDATE /*+ parallel(t) */ cs_forum_messages_tl t

210: x_return_status := fnd_api.G_RET_STS_SUCCESS;
211:
212: SAVEPOINT populate_forum_index_SAV;
213:
214: UPDATE /*+ parallel(t) */ cs_forum_messages_tl t
215: SET t.composite_assoc_col = 'B';
216:
217: COMMIT;
218:

Line 729: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';

725: IS
726: l_create_cmmd VARCHAR2(500):= NULL;
727:
728: l_index_version VARCHAR2(15) := '115.10.1';
729: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
730: BEGIN
731: l_create_cmmd :=
732: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
733: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '

Line 732: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '

728: l_index_version VARCHAR2(15) := '115.10.1';
729: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
730: BEGIN
731: l_create_cmmd :=
732: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
733: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '
734: || 'indextype is ctxsys.context parameters( '''
735: || 'datastore '||g_apps_short_name||'.CS_FORUM_MESG_ELES '
736: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '

Line 733: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '

729: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
730: BEGIN
731: l_create_cmmd :=
732: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
733: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '
734: || 'indextype is ctxsys.context parameters( '''
735: || 'datastore '||g_apps_short_name||'.CS_FORUM_MESG_ELES '
736: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
737: || 'lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

Line 1195: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';

1191: BMODE IN VARCHAR2,
1192: pworker IN NUMBER DEFAULT 0)
1193:
1194: IS
1195: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
1196: l_mode VARCHAR2(10) := bmode;
1197: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
1198: BEGIN
1199: -- Initialize some variables