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.EDR_INDEXED_XML_UTIL dependencies on CTX_DDL

Line 41: Ctx_Ddl.Drop_Section_Group

37: fnd_file.put_line(FND_FILE.LOG,'Index does not exist. Creating index for the first time.');
38: end;
39:
40: begin
41: Ctx_Ddl.Drop_Section_Group
42: ( group_name => 'edr_section_group'
43: );
44: fnd_file.put_line(FND_FILE.LOG,'Section group dropped for refresh');
45: exception

Line 51: ctx_ddl.drop_preference('edrlex');

47: fnd_file.put_line(FND_FILE.LOG,'Section group does not exist');
48: end;
49:
50: begin
51: ctx_ddl.drop_preference('edrlex');
52: fnd_file.put_line(FND_FILE.LOG,'Lexer preference dropped');
53: exception
54: when no_ctx_object then
55: fnd_file.put_line(FND_FILE.LOG,'Lexer preference does not exist.');

Line 58: Ctx_Ddl.Create_Section_Group

54: when no_ctx_object then
55: fnd_file.put_line(FND_FILE.LOG,'Lexer preference does not exist.');
56: end;
57:
58: Ctx_Ddl.Create_Section_Group
59: (group_name => 'edr_section_group',
60: group_type => 'xml_section_group');
61: fnd_file.put_line(FND_FILE.LOG,'Section group created ');
62:

Line 63: ctx_ddl.create_preference('edrlex','BASIC_LEXER');

59: (group_name => 'edr_section_group',
60: group_type => 'xml_section_group');
61: fnd_file.put_line(FND_FILE.LOG,'Section group created ');
62:
63: ctx_ddl.create_preference('edrlex','BASIC_LEXER');
64:
65: --Bug 2783886: Start
66: --added .?_! as printjoin attributes
67: ctx_ddl.set_attribute('edrlex','printjoins','{},&?\/()[]-;~|$!>*=.?_!');

Line 67: ctx_ddl.set_attribute('edrlex','printjoins','{},&?\/()[]-;~|$!>*=.?_!');

63: ctx_ddl.create_preference('edrlex','BASIC_LEXER');
64:
65: --Bug 2783886: Start
66: --added .?_! as printjoin attributes
67: ctx_ddl.set_attribute('edrlex','printjoins','{},&?\/()[]-;~|$!>*=.?_!');
68: --ctx_ddl.set_attribute('edrlex','printjoins','{},&?\()[]-;~|$!>*=');
69:
70: --add the prefix index attribute to the basic wordlist so that
71: --performance of the right wild card % queries improves

Line 68: --ctx_ddl.set_attribute('edrlex','printjoins','{},&?\()[]-;~|$!>*=');

64:
65: --Bug 2783886: Start
66: --added .?_! as printjoin attributes
67: ctx_ddl.set_attribute('edrlex','printjoins','{},&?\/()[]-;~|$!>*=.?_!');
68: --ctx_ddl.set_attribute('edrlex','printjoins','{},&?\()[]-;~|$!>*=');
69:
70: --add the prefix index attribute to the basic wordlist so that
71: --performance of the right wild card % queries improves
72: --FYI we are now putting a wild card at the end of ALL queries

Line 75: ctx_ddl.drop_preference('edrwordlist');

71: --performance of the right wild card % queries improves
72: --FYI we are now putting a wild card at the end of ALL queries
73:
74: begin
75: ctx_ddl.drop_preference('edrwordlist');
76: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference dropped');
77: exception
78: when no_ctx_object then
79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');

Line 82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');

78: when no_ctx_object then
79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');
80: end;
81:
82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');
84: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);
85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
86:

Line 83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');

79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');
80: end;
81:
82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');
84: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);
85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
86:
87: --Bug 2783886: End

Line 84: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);

80: end;
81:
82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');
84: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);
85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
86:
87: --Bug 2783886: End
88:

Line 85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);

81:
82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');
84: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);
85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
86:
87: --Bug 2783886: End
88:
89: fnd_file.put_line(FND_FILE.LOG,'Lexer preference created');

Line 98: Ctx_Ddl.Add_zone_Section

94: if (l_status = 'N') then
95: update edr_idx_xml_element_b set status = 'I' where index_tag = l_tag;
96: fnd_file.put_line(FND_FILE.LOG,'Activated section: '||l_section_name);
97: end if;
98: Ctx_Ddl.Add_zone_Section
99: (group_name =>'edr_section_group',
100: section_name =>l_section_name,
101: tag =>l_tag
102: );

Line 150: -- Function : use ctx_ddl.sync_index to do the work scheduled by concurrent manager

146:
147: -- 2979172 start: need new procedures to sync/optimize index
148: -- Procedure: Synchronize_Index
149: -- In Param :
150: -- Function : use ctx_ddl.sync_index to do the work scheduled by concurrent manager
151:
152: PROCEDURE Synchronize_Index (
153: ERRBUF OUT NOCOPY VARCHAR2,
154: RETCODE OUT NOCOPY NUMBER )

Line 165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );

161: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
162: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
163: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
164:
165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
166:
167: -- Bug 3196897: start:
168: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
169: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );

Line 196: -- Function : use ctx_ddl.sync_index to do the work scheduled by concurrent manager

192: -- In Param : p_optimize_level 'FAST' for defragmentation only
193: -- 'FULL' does both defragmentation and garbage collection
194: -- p_duration number of minutes for the duration of running one optimization
195: -- next time the optimization will continue what's left last time
196: -- Function : use ctx_ddl.sync_index to do the work scheduled by concurrent manager
197:
198: PROCEDURE Optimize_Index (
199: ERRBUF OUT NOCOPY VARCHAR2,
200: RETCODE OUT NOCOPY NUMBER,

Line 210: l_opt_level := ctx_ddl.optlevel_full;

206:
207: BEGIN
208: -- check the valid parameter for optimization level
209: IF p_optimize_level is null THEN
210: l_opt_level := ctx_ddl.optlevel_full;
211: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );

Line 226: l_maxtime := ctx_ddl.maxtime_unlimited;

222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
223:
224: -- check the valid parameter for the time spent in each running of optimization
225: IF p_duration is null THEN
226: l_maxtime := ctx_ddl.maxtime_unlimited;
227: ELSE
228: IF trunc(p_duration) <> p_duration or p_duration < 0
229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );

Line 229: or p_duration > ctx_ddl.maxtime_unlimited THEN

225: IF p_duration is null THEN
226: l_maxtime := ctx_ddl.maxtime_unlimited;
227: ELSE
228: IF trunc(p_duration) <> p_duration or p_duration < 0
229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );

Line 242: l_maxtime := ctx_ddl.maxtime_unlimited;

238: IF p_optimize_level = 'FAST' THEN
239: l_maxtime := null;
240: ELSE
241: IF p_duration IS NULL THEN
242: l_maxtime := ctx_ddl.maxtime_unlimited;
243: ELSE
244: l_maxtime := trunc( p_duration );
245: END IF;
246: END IF;

Line 254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );

250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;
253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
256: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
257: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
258: