APPS.CS_KB_CONC_PROG_PKG dependencies on CS_FORUM_MESSAGES_TL

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

175: x_msg_error OUT NOCOPY VARCHAR2,
176: x_return_status OUT NOCOPY VARCHAR2
177: )
178: IS
179: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
180: BEGIN
181: x_return_status := fnd_api.G_RET_STS_SUCCESS;
182:
183: SAVEPOINT populate_forum_index_SAV;

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

181: x_return_status := fnd_api.G_RET_STS_SUCCESS;
182:
183: SAVEPOINT populate_forum_index_SAV;
184:
185: UPDATE /*+ parallel(t) */ cs_forum_messages_tl t
186: SET t.composite_assoc_col = 'B';
187:
188: COMMIT;
189:

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

622: IS
623: l_create_cmmd VARCHAR2(500):= NULL;
624:
625: l_index_version VARCHAR2(15) := '115.10.1';
626: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
627: BEGIN
628: l_create_cmmd :=
629: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
630: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '

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

625: l_index_version VARCHAR2(15) := '115.10.1';
626: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
627: BEGIN
628: l_create_cmmd :=
629: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
630: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '
631: || 'indextype is ctxsys.context parameters( '''
632: || 'datastore '||g_apps_short_name||'.CS_FORUM_MESG_ELES '
633: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '

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

626: l_index_name VARCHAR2(30) := 'cs_forum_messages_tl_n4';
627: BEGIN
628: l_create_cmmd :=
629: 'create index '||g_cs_short_name||'.cs_forum_messages_tl_n4 '
630: || 'on '||g_cs_short_name||'.cs_forum_messages_tl(composite_assoc_col) '
631: || 'indextype is ctxsys.context parameters( '''
632: || 'datastore '||g_apps_short_name||'.CS_FORUM_MESG_ELES '
633: || ' section group '||g_apps_short_name||'.CS_KB_BASIC_GRP '
634: || 'lexer '||g_apps_short_name||'.CS_KB_GLOBAL_LEXER language column SOURCE_LANG '

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

1042: BMODE IN VARCHAR2,
1043: pworker IN NUMBER DEFAULT 0)
1044:
1045: IS
1046: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
1047: l_mode VARCHAR2(10) := bmode;
1048: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
1049: BEGIN
1050: -- Initialize some variables