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

Line 198: l_cursor_id := DBMS_SQL.open_cursor;

194: -- Delete rows from previous searches
195: DELETE FROM gmd_msnr_results
196: WHERE concurrent_id IS NULL;
197:
198: l_cursor_id := DBMS_SQL.open_cursor;
199: fnd_dsql.set_cursor (l_cursor_id);
200: l_dsql_text := fnd_dsql.get_text (FALSE);
201: l_debug_text := fnd_dsql.get_text (TRUE);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);

Line 205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);

201: l_debug_text := fnd_dsql.get_text (TRUE);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);
203: --raghav_debug ('l_debug_text ' || l_debug_text);
204:
205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);
206: fnd_dsql.do_binds;
207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);

Line 208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);

204:
205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);
206: fnd_dsql.do_binds;
207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);

Line 209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);

205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);
206: fnd_dsql.do_binds;
207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);

Line 210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);

206: fnd_dsql.do_binds;
207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);

Line 211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);

207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);

Line 212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);

208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
216:

Line 213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);

209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
216:
217: LOOP

Line 214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);

210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);
211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
216:
217: LOOP
218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN

Line 215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);

211: DBMS_SQL.define_column (l_cursor_id, 4, l_object_desc, 240);
212: DBMS_SQL.define_column (l_cursor_id, 5, l_object_status_desc, 240);
213: DBMS_SQL.define_column (l_cursor_id, 6, l_object_select_ind);
214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
216:
217: LOOP
218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
219: l_row_cnt := l_row_cnt + 1;

Line 218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN

214: DBMS_SQL.define_column (l_cursor_id, 7, l_object_status_code, 240);
215: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
216:
217: LOOP
218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
219: l_row_cnt := l_row_cnt + 1;
220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);

Line 220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);

216:
217: LOOP
218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
219: l_row_cnt := l_row_cnt + 1;
220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);

Line 221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);

217: LOOP
218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
219: l_row_cnt := l_row_cnt + 1;
220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);

Line 222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);

218: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN
219: l_row_cnt := l_row_cnt + 1;
220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);
226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);

Line 223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);

219: l_row_cnt := l_row_cnt + 1;
220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);
226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);
227:

Line 224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);

220: DBMS_SQL.column_value (l_cursor_id, 1, l_object_id);
221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);
226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);
227:
228: IF (l_object_status_code IN ('200', '500', '800', '1000')) THEN

Line 225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);

221: DBMS_SQL.column_value (l_cursor_id, 2, l_object_name);
222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);
226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);
227:
228: IF (l_object_status_code IN ('200', '500', '800', '1000')) THEN
229: l_object_select_ind := 0;

Line 226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);

222: DBMS_SQL.column_value (l_cursor_id, 3, l_object_vers);
223: DBMS_SQL.column_value (l_cursor_id, 4, l_object_desc);
224: DBMS_SQL.column_value (l_cursor_id, 5, l_object_status_desc);
225: DBMS_SQL.column_value (l_cursor_id, 6, l_object_select_ind);
226: DBMS_SQL.column_value (l_cursor_id, 7, l_object_status_code);
227:
228: IF (l_object_status_code IN ('200', '500', '800', '1000')) THEN
229: l_object_select_ind := 0;
230: END IF;

Line 267: DBMS_SQL.close_cursor (l_cursor_id);

263: EXIT;
264: END IF;
265: END LOOP;
266:
267: DBMS_SQL.close_cursor (l_cursor_id);
268: -- Commit all data populated
269: --Commit; -- Bug 4444060 Commented the commit
270: EXCEPTION
271: WHEN OTHERS THEN

Line 272: IF (DBMS_SQL.is_open (l_cursor_id)) THEN

268: -- Commit all data populated
269: --Commit; -- Bug 4444060 Commented the commit
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF (DBMS_SQL.is_open (l_cursor_id)) THEN
273: DBMS_SQL.close_cursor (l_cursor_id);
274: END IF;
275:
276: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 273: DBMS_SQL.close_cursor (l_cursor_id);

269: --Commit; -- Bug 4444060 Commented the commit
270: EXCEPTION
271: WHEN OTHERS THEN
272: IF (DBMS_SQL.is_open (l_cursor_id)) THEN
273: DBMS_SQL.close_cursor (l_cursor_id);
274: END IF;
275:
276: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
277: END populate_search_table;