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 37: Ctx_Ddl.Drop_Section_Group

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

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

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

Line 54: Ctx_Ddl.Create_Section_Group

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

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

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

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

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

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

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

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

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

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

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

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

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

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

76: end;
77:
78: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
79: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');
80: ctx_ddl.set_attribute('edrwordlist','PREFIX_MIN_LENGTH',1);
81: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
82:
83: --Bug 2783886: End
84:

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

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

Line 94: Ctx_Ddl.Add_zone_Section

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

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

140:
141: -- 2979172 start: need new procedures to sync/optimize index
142: -- Procedure: Synchronize_Index
143: -- In Param :
144: -- Function : use ctx_ddl.sync_index to do the work scheduled by concurrent manager
145:
146: PROCEDURE Synchronize_Index (
147: ERRBUF OUT NOCOPY VARCHAR2,
148: RETCODE OUT NOCOPY NUMBER )

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

155: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
156: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
157: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
158:
159: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
160:
161: -- Bug 3196897: start:
162: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
163: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );

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

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

Line 204: l_opt_level := ctx_ddl.optlevel_full;

200:
201: BEGIN
202: -- check the valid parameter for optimization level
203: IF p_optimize_level is null THEN
204: l_opt_level := ctx_ddl.optlevel_full;
205: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
206: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
207: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
208: fnd_message.set_token( 'PARAM', 'p_optimize_level' );

Line 220: l_maxtime := ctx_ddl.maxtime_unlimited;

216: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
217:
218: -- check the valid parameter for the time spent in each running of optimization
219: IF p_duration is null THEN
220: l_maxtime := ctx_ddl.maxtime_unlimited;
221: ELSE
222: IF trunc(p_duration) <> p_duration or p_duration < 0
223: or p_duration > ctx_ddl.maxtime_unlimited THEN
224: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );

Line 223: or p_duration > ctx_ddl.maxtime_unlimited THEN

219: IF p_duration is null THEN
220: l_maxtime := ctx_ddl.maxtime_unlimited;
221: ELSE
222: IF trunc(p_duration) <> p_duration or p_duration < 0
223: or p_duration > ctx_ddl.maxtime_unlimited THEN
224: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
225: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
226: fnd_message.set_token( 'PARAM', 'p_duration' );
227: fnd_message.set_token( 'VALUE', p_duration );

Line 236: l_maxtime := ctx_ddl.maxtime_unlimited;

232: IF p_optimize_level = 'FAST' THEN
233: l_maxtime := null;
234: ELSE
235: IF p_duration IS NULL THEN
236: l_maxtime := ctx_ddl.maxtime_unlimited;
237: ELSE
238: l_maxtime := trunc( p_duration );
239: END IF;
240: END IF;

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

244: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
245: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
246: END IF;
247:
248: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
249: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
250: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: