[Home] [Help]
352: ELSIF bmode = 'OFULL' THEN
353: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
354: ELSIF bmode = 'R' THEN
355: -- 4321268: rebuild in parallel mode always. Serial online mode,
356: -- is taking care in the individual index program.
357: IF pworker IS NOT NULL AND pworker > 0 THEN
358:
359: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD parallel '|| to_char(pworker);
360: END IF;
359: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD parallel '|| to_char(pworker);
360: END IF;
361: -- 4321268_eof
362: ELSIF bmode = 'DR' THEN
363: -- logic to drop or create is taken in the individual api.
364: NULL;
365: ELSE
366: FND_FILE.PUT_LINE(FND_FILE.LOG,
367: fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE'));
1232:
1233: CURSOR set_cursor IS
1234: SELECT SET_ID FROM CS_KB_SETS_B;
1235: BEGIN
1236: SELECT SysDate INTO current_date FROM dual;
1237: x_user_id := FND_GLOBAL.user_id;
1238: x_login_id := FND_GLOBAL.login_id;
1239:
1240: SELECT def_id, days BULK COLLECT INTO list_of_def_id, list_of_days
1323: *
1324: */
1325: PROCEDURE Update_Magic_Word IS
1326: CURSOR Get_Magic_Word_Csr IS
1327: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
1328:
1329: CURSOR Test_Magic_Word_Csr(p_keyword VARCHAR2) IS
1330: SELECT NULL
1331: FROM cs_kb_sets_vl SetEO
1343: 'a' -- alpha characters only (mixed case)
1344: 'x' -- any alpha-numeric characters (upper)
1345: 'p' -- any printable characters
1346: */
1347: SELECT dbms_random.string( 'l', 5) FROM dual;
1348:
1349: l_magic_word VARCHAR2(240) := NULL;
1350: l_old_magic_word VARCHAR2(240) := NULL;
1351: l_result Test_Magic_Word_Csr%ROWTYPE;