eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_TEXT_INDEX_PVT dependencies on EAM_TEXT_UTIL

Line 428: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN

424: Lexer_Name := g_Pref_Owner || '.EAM_ASSET_LEXER_' || Lang_Code_List(i);
425:
426: IF ( Lang_Code_List(i) = 'JA' ) THEN
427: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
428: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN
429: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
430: ELSE
431: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
432: END IF;

Line 436: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN

432: END IF;
433:
434: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
435: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
436: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN
437: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
439: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
440: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

Line 462: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

458: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
459: END IF;
460:
461: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
462: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
463: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
464: ELSE
465: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
466: END IF;

Line 497: --IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

493:
494: -- Disable stem indexing to improve index creation performance.
495: -- This would not affect stem expansion (with $) at query time.
496: --
497: --IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
498: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
499: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
500: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
501: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');

Line 793: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

789: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);
790:
791: -- Decide whether parallel indexing can be used, depending on DB version.
792:
793: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
794: l_index_parallel := c_parallel_clause;
795: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
796: END IF;
797:

Line 795: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);

791: -- Decide whether parallel indexing can be used, depending on DB version.
792:
793: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
794: l_index_parallel := c_parallel_clause;
795: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
796: END IF;
797:
798: -- Start logging indexing progress
799:

Line 823: eam_text_util.Set_Context ('CREATE_INDEX');

819:
820: IF ( l_create_index ) THEN
821: BEGIN
822: request_log('EAM_TEXT_CREATE');
823: eam_text_util.Set_Context ('CREATE_INDEX');
824:
825: sql_stmt :=
826: 'CREATE INDEX ' || g_Index_Owner || '.' || p_Index_Name ||
827: ' ON ' || g_Prod_Schema || '.EAM_ASSET_TEXT (text) ' ||

Line 873: eam_text_util.Incremental_Sync

869: END IF; -- create index
870: /*
871: Log_Line (l_api_name || ': calling Incremental_Sync', FND_LOG.LEVEL_EVENT, l_api_name);
872:
873: eam_text_util.Incremental_Sync
874: (
875: p_Index_Name => p_Index_Name
876: , p_batch_size => 40000
877: , x_rows_processed => l_rows_processed

Line 1152: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN

1148:
1149: IF ( Lang_Code_List(i) = 'JA' ) THEN
1150:
1151: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
1152: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN
1153: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
1154: ELSE
1155: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
1156: END IF;

Line 1161: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN

1157:
1158: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
1159:
1160: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
1161: IF ( eam_text_util.get_DB_Version_Num >= 9.0 ) THEN
1162: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
1163: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
1164: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
1165: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

Line 1188: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

1184: END IF;
1185:
1186: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
1187:
1188: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
1189: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
1190: ELSE
1191: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
1192: END IF;

Line 1221: --IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

1217:
1218: -- Disable stem indexing to improve index creation performance.
1219: -- This would not affect stem expansion (with $) at query time.
1220: --
1221: --IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
1222: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
1223: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
1224: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
1225: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');

Line 1518: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

1514: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);
1515:
1516: -- Decide whether parallel indexing can be used, depending on DB version.
1517:
1518: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
1519: l_index_parallel := c_parallel_clause;
1520: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
1521: END IF;
1522:

Line 1520: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);

1516: -- Decide whether parallel indexing can be used, depending on DB version.
1517:
1518: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
1519: l_index_parallel := c_parallel_clause;
1520: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
1521: END IF;
1522:
1523: -- Start logging indexing progress
1524:

Line 1548: eam_text_util.Set_Context ('CREATE_INDEX');

1544:
1545: IF ( l_create_index ) THEN
1546: BEGIN
1547: request_log('EAM_TEXT_CREATE');
1548: eam_text_util.Set_Context ('CREATE_INDEX');
1549:
1550: sql_stmt :=
1551: 'CREATE INDEX ' || g_Index_Owner || '.' || p_Index_Name ||
1552: ' ON ' || g_Prod_Schema || '.EAM_WORK_ORDER_TEXT (text) ' ||

Line 1598: eam_text_util.Incremental_Sync

1594: END IF; -- create index
1595: /*
1596: Log_Line (l_api_name || ': calling Incremental_Sync');
1597:
1598: eam_text_util.Incremental_Sync
1599: (
1600: p_Index_Name => p_Index_Name
1601: , p_batch_size => 40000
1602: , x_rows_processed => l_rows_processed

Line 1758: Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);

1754: , p_maxtime => p_maxtime
1755: , p_index_name => l_Index_Name
1756: );
1757: ELSIF (p_action = 5) THEN
1758: Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);
1759:
1760: Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1, --User Defined Status Id whose status code has been updated
1761: p_commit => FND_API.G_TRUE,
1762: x_return_status => l_return_status);

Line 1760: Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1, --User Defined Status Id whose status code has been updated

1756: );
1757: ELSIF (p_action = 5) THEN
1758: Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);
1759:
1760: Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1, --User Defined Status Id whose status code has been updated
1761: p_commit => FND_API.G_TRUE,
1762: x_return_status => l_return_status);
1763:
1764: Log_Line ('after calling update status event ...Return Status is : '|| l_return_status, FND_LOG.LEVEL_EVENT, l_api_name);