[Home] [Help]
380: ELSIF bmode = 'OFULL' THEN
381: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
382: ELSIF bmode = 'R' THEN
383: -- 4321268: rebuild in parallel mode always. Serial online mode,
384: -- is taking care in the individual index program.
385: IF pworker IS NOT NULL AND pworker > 0 THEN
386:
387: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD parallel '|| to_char(pworker);
388: END IF;
387: EXECUTE IMMEDIATE 'alter index ' || l_index_name ||' REBUILD parallel '|| to_char(pworker);
388: END IF;
389: -- 4321268_eof
390: ELSIF bmode = 'DR' THEN
391: -- logic to drop or create is taken in the individual api.
392: NULL;
393: ELSE
394: FND_FILE.PUT_LINE(FND_FILE.LOG,
395: fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE'));
1381:
1382: CURSOR set_cursor IS
1383: SELECT SET_ID FROM CS_KB_SETS_B;
1384: BEGIN
1385: SELECT SysDate INTO current_date FROM dual;
1386: x_user_id := FND_GLOBAL.user_id;
1387: x_login_id := FND_GLOBAL.login_id;
1388:
1389: SELECT def_id, days BULK COLLECT INTO list_of_def_id, list_of_days
1472: *
1473: */
1474: PROCEDURE Update_Magic_Word IS
1475: CURSOR Get_Magic_Word_Csr IS
1476: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
1477:
1478: CURSOR Test_Magic_Word_Csr(p_keyword VARCHAR2) IS
1479: SELECT NULL
1480: FROM cs_kb_sets_vl SetEO
1492: 'a' -- alpha characters only (mixed case)
1493: 'x' -- any alpha-numeric characters (upper)
1494: 'p' -- any printable characters
1495: */
1496: SELECT dbms_random.string( 'l', 5) FROM dual;
1497:
1498: l_magic_word VARCHAR2(240) := NULL;
1499: l_old_magic_word VARCHAR2(240) := NULL;
1500: l_result Test_Magic_Word_Csr%ROWTYPE;