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.JTF_AMVIMT_PUB dependencies on DBMS_SQL

Line 87: curs := dbms_sql.open_cursor;

83:
84: -----------------------
85: -- rebuild the index --
86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);

Line 90: dbms_sql.parse(curs, stmt, dbms_sql.native);

86: -----------------------
87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;

Line 91: rows := dbms_sql.execute(curs);

87: curs := dbms_sql.open_cursor;
88: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||

Line 92: dbms_sql.close_cursor(curs);

88: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
89: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';

Line 94: curs := dbms_sql.open_cursor;

90: dbms_sql.parse(curs, stmt, dbms_sql.native);
91: rows := dbms_sql.execute(curs);
92: dbms_sql.close_cursor(curs);
93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);

Line 97: dbms_sql.parse(curs, stmt, dbms_sql.native);

93:
94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: curs := dbms_sql.open_cursor;

Line 98: rows := dbms_sql.execute(curs);

94: curs := dbms_sql.open_cursor;
95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: curs := dbms_sql.open_cursor;
102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||

Line 99: dbms_sql.close_cursor(curs);

95: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
96: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: curs := dbms_sql.open_cursor;
102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
103: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';

Line 101: curs := dbms_sql.open_cursor;

97: dbms_sql.parse(curs, stmt, dbms_sql.native);
98: rows := dbms_sql.execute(curs);
99: dbms_sql.close_cursor(curs);
100:
101: curs := dbms_sql.open_cursor;
102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
103: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
104: dbms_sql.parse(curs, stmt, dbms_sql.native);
105: rows := dbms_sql.execute(curs);

Line 104: dbms_sql.parse(curs, stmt, dbms_sql.native);

100:
101: curs := dbms_sql.open_cursor;
102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
103: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
104: dbms_sql.parse(curs, stmt, dbms_sql.native);
105: rows := dbms_sql.execute(curs);
106: dbms_sql.close_cursor(curs);
107:
108: curs := dbms_sql.open_cursor;

Line 105: rows := dbms_sql.execute(curs);

101: curs := dbms_sql.open_cursor;
102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
103: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
104: dbms_sql.parse(curs, stmt, dbms_sql.native);
105: rows := dbms_sql.execute(curs);
106: dbms_sql.close_cursor(curs);
107:
108: curs := dbms_sql.open_cursor;
109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||

Line 106: dbms_sql.close_cursor(curs);

102: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
103: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
104: dbms_sql.parse(curs, stmt, dbms_sql.native);
105: rows := dbms_sql.execute(curs);
106: dbms_sql.close_cursor(curs);
107:
108: curs := dbms_sql.open_cursor;
109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
110: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';

Line 108: curs := dbms_sql.open_cursor;

104: dbms_sql.parse(curs, stmt, dbms_sql.native);
105: rows := dbms_sql.execute(curs);
106: dbms_sql.close_cursor(curs);
107:
108: curs := dbms_sql.open_cursor;
109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
110: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
111: dbms_sql.parse(curs, stmt, dbms_sql.native);
112: rows := dbms_sql.execute(curs);

Line 111: dbms_sql.parse(curs, stmt, dbms_sql.native);

107:
108: curs := dbms_sql.open_cursor;
109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
110: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
111: dbms_sql.parse(curs, stmt, dbms_sql.native);
112: rows := dbms_sql.execute(curs);
113: dbms_sql.close_cursor(curs);
114:
115: --

Line 112: rows := dbms_sql.execute(curs);

108: curs := dbms_sql.open_cursor;
109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
110: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
111: dbms_sql.parse(curs, stmt, dbms_sql.native);
112: rows := dbms_sql.execute(curs);
113: dbms_sql.close_cursor(curs);
114:
115: --
116: EXCEPTION

Line 113: dbms_sql.close_cursor(curs);

109: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
110: 'parameters(''optimize '|| p_optimize_level || l_maxtime ||''')';
111: dbms_sql.parse(curs, stmt, dbms_sql.native);
112: rows := dbms_sql.execute(curs);
113: dbms_sql.close_cursor(curs);
114:
115: --
116: EXCEPTION
117: WHEN OTHERS THEN

Line 162: curs := dbms_sql.open_cursor;

158:
159: -----------------------
160: -- rebuild the index --
161: -----------------------
162: curs := dbms_sql.open_cursor;
163: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
164: 'parameters(''sync'')';
165: dbms_sql.parse(curs, stmt, dbms_sql.native);
166: rows := dbms_sql.execute(curs);

Line 165: dbms_sql.parse(curs, stmt, dbms_sql.native);

161: -----------------------
162: curs := dbms_sql.open_cursor;
163: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
164: 'parameters(''sync'')';
165: dbms_sql.parse(curs, stmt, dbms_sql.native);
166: rows := dbms_sql.execute(curs);
167: dbms_sql.close_cursor(curs);
168:
169: curs := dbms_sql.open_cursor;

Line 166: rows := dbms_sql.execute(curs);

162: curs := dbms_sql.open_cursor;
163: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
164: 'parameters(''sync'')';
165: dbms_sql.parse(curs, stmt, dbms_sql.native);
166: rows := dbms_sql.execute(curs);
167: dbms_sql.close_cursor(curs);
168:
169: curs := dbms_sql.open_cursor;
170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||

Line 167: dbms_sql.close_cursor(curs);

163: stmt := 'alter index '||owner||'.jtf_amv_items_url_ctx rebuild online '||
164: 'parameters(''sync'')';
165: dbms_sql.parse(curs, stmt, dbms_sql.native);
166: rows := dbms_sql.execute(curs);
167: dbms_sql.close_cursor(curs);
168:
169: curs := dbms_sql.open_cursor;
170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
171: 'parameters(''sync'')';

Line 169: curs := dbms_sql.open_cursor;

165: dbms_sql.parse(curs, stmt, dbms_sql.native);
166: rows := dbms_sql.execute(curs);
167: dbms_sql.close_cursor(curs);
168:
169: curs := dbms_sql.open_cursor;
170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
171: 'parameters(''sync'')';
172: dbms_sql.parse(curs, stmt, dbms_sql.native);
173: rows := dbms_sql.execute(curs);

Line 172: dbms_sql.parse(curs, stmt, dbms_sql.native);

168:
169: curs := dbms_sql.open_cursor;
170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
171: 'parameters(''sync'')';
172: dbms_sql.parse(curs, stmt, dbms_sql.native);
173: rows := dbms_sql.execute(curs);
174: dbms_sql.close_cursor(curs);
175:
176: curs := dbms_sql.open_cursor;

Line 173: rows := dbms_sql.execute(curs);

169: curs := dbms_sql.open_cursor;
170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
171: 'parameters(''sync'')';
172: dbms_sql.parse(curs, stmt, dbms_sql.native);
173: rows := dbms_sql.execute(curs);
174: dbms_sql.close_cursor(curs);
175:
176: curs := dbms_sql.open_cursor;
177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||

Line 174: dbms_sql.close_cursor(curs);

170: stmt := 'alter index '||owner||'.jtf_amv_items_name_ctx rebuild online '||
171: 'parameters(''sync'')';
172: dbms_sql.parse(curs, stmt, dbms_sql.native);
173: rows := dbms_sql.execute(curs);
174: dbms_sql.close_cursor(curs);
175:
176: curs := dbms_sql.open_cursor;
177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
178: 'parameters(''sync'')';

Line 176: curs := dbms_sql.open_cursor;

172: dbms_sql.parse(curs, stmt, dbms_sql.native);
173: rows := dbms_sql.execute(curs);
174: dbms_sql.close_cursor(curs);
175:
176: curs := dbms_sql.open_cursor;
177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
178: 'parameters(''sync'')';
179: dbms_sql.parse(curs, stmt, dbms_sql.native);
180: rows := dbms_sql.execute(curs);

Line 179: dbms_sql.parse(curs, stmt, dbms_sql.native);

175:
176: curs := dbms_sql.open_cursor;
177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
178: 'parameters(''sync'')';
179: dbms_sql.parse(curs, stmt, dbms_sql.native);
180: rows := dbms_sql.execute(curs);
181: dbms_sql.close_cursor(curs);
182:
183: curs := dbms_sql.open_cursor;

Line 180: rows := dbms_sql.execute(curs);

176: curs := dbms_sql.open_cursor;
177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
178: 'parameters(''sync'')';
179: dbms_sql.parse(curs, stmt, dbms_sql.native);
180: rows := dbms_sql.execute(curs);
181: dbms_sql.close_cursor(curs);
182:
183: curs := dbms_sql.open_cursor;
184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||

Line 181: dbms_sql.close_cursor(curs);

177: stmt := 'alter index '||owner||'.jtf_amv_items_desc_ctx rebuild online '||
178: 'parameters(''sync'')';
179: dbms_sql.parse(curs, stmt, dbms_sql.native);
180: rows := dbms_sql.execute(curs);
181: dbms_sql.close_cursor(curs);
182:
183: curs := dbms_sql.open_cursor;
184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
185: 'parameters(''sync'')';

Line 183: curs := dbms_sql.open_cursor;

179: dbms_sql.parse(curs, stmt, dbms_sql.native);
180: rows := dbms_sql.execute(curs);
181: dbms_sql.close_cursor(curs);
182:
183: curs := dbms_sql.open_cursor;
184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
185: 'parameters(''sync'')';
186: dbms_sql.parse(curs, stmt, dbms_sql.native);
187: rows := dbms_sql.execute(curs);

Line 186: dbms_sql.parse(curs, stmt, dbms_sql.native);

182:
183: curs := dbms_sql.open_cursor;
184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
185: 'parameters(''sync'')';
186: dbms_sql.parse(curs, stmt, dbms_sql.native);
187: rows := dbms_sql.execute(curs);
188: dbms_sql.close_cursor(curs);
189:
190: --

Line 187: rows := dbms_sql.execute(curs);

183: curs := dbms_sql.open_cursor;
184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
185: 'parameters(''sync'')';
186: dbms_sql.parse(curs, stmt, dbms_sql.native);
187: rows := dbms_sql.execute(curs);
188: dbms_sql.close_cursor(curs);
189:
190: --
191: EXCEPTION

Line 188: dbms_sql.close_cursor(curs);

184: stmt := 'alter index '||owner||'.jtf_amv_items_text_ctx rebuild online '||
185: 'parameters(''sync'')';
186: dbms_sql.parse(curs, stmt, dbms_sql.native);
187: rows := dbms_sql.execute(curs);
188: dbms_sql.close_cursor(curs);
189:
190: --
191: EXCEPTION
192: WHEN OTHERS THEN