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_CONC_REPLACE_PKG dependencies on DBMS_SQL

Line 235: l_cursor_id := dbms_sql.open_cursor;

231: BEGIN
232: -- Delete rows from previous searches
233: DELETE FROM gmd_msnr_results WHERE concurrent_id IS NULL;
234: /*
235: l_cursor_id := dbms_sql.open_cursor;
236: fnd_dsql.set_cursor(l_cursor_id);
237: l_dsql_text := fnd_dsql.get_text(FALSE);
238:
239: l_debug_text := fnd_dsql.get_text(TRUE);

Line 242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);

238:
239: l_debug_text := fnd_dsql.get_text(TRUE);
240: --insert into shy_text values (l_debug_text); commit;
241:
242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
243: fnd_dsql.do_binds;
244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );

Line 245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );

241:
242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
243: fnd_dsql.do_binds;
244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );

Line 246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );

242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
243: fnd_dsql.do_binds;
244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );

Line 247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );

243: fnd_dsql.do_binds;
244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );

Line 248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );

244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
252:

Line 249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );

245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
252:
253: l_num_of_rows := dbms_sql.execute(l_cursor_id);

Line 250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );

246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
252:
253: l_num_of_rows := dbms_sql.execute(l_cursor_id);
254:

Line 251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );

247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
248: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
252:
253: l_num_of_rows := dbms_sql.execute(l_cursor_id);
254:
255: LOOP

Line 253: l_num_of_rows := dbms_sql.execute(l_cursor_id);

249: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
250: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
251: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
252:
253: l_num_of_rows := dbms_sql.execute(l_cursor_id);
254:
255: LOOP
256: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
257: l_row_cnt := l_row_cnt + 1;

Line 256: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then

252:
253: l_num_of_rows := dbms_sql.execute(l_cursor_id);
254:
255: LOOP
256: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
257: l_row_cnt := l_row_cnt + 1;
258:
259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );

Line 259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );

255: LOOP
256: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
257: l_row_cnt := l_row_cnt + 1;
258:
259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );

Line 260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );

256: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
257: l_row_cnt := l_row_cnt + 1;
258:
259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );

Line 261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );

257: l_row_cnt := l_row_cnt + 1;
258:
259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );

Line 262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );

258:
259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
266:

Line 263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );

259: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
266:
267: IF (l_object_status_code IN ('200','500','800','1000')) THEN

Line 264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );

260: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
266:
267: IF (l_object_status_code IN ('200','500','800','1000')) THEN
268: l_object_select_ind := 0;

Line 265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );

261: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
262: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
263: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
264: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
265: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
266:
267: IF (l_object_status_code IN ('200','500','800','1000')) THEN
268: l_object_select_ind := 0;
269: END IF;

Line 307: IF (dbms_sql.is_open(l_cursor_id)) THEN

303: EXIT;
304: END IF;
305: END LOOP;
306:
307: IF (dbms_sql.is_open(l_cursor_id)) THEN
308: dbms_sql.close_cursor(l_cursor_id);
309: END IF;
310: */
311: -- Commit all data populated

Line 308: dbms_sql.close_cursor(l_cursor_id);

304: END IF;
305: END LOOP;
306:
307: IF (dbms_sql.is_open(l_cursor_id)) THEN
308: dbms_sql.close_cursor(l_cursor_id);
309: END IF;
310: */
311: -- Commit all data populated
312: --Commit; Bug 4479488 Commented the commit

Line 318: /*IF (dbms_sql.is_open(l_cursor_id)) THEN

314: Populate_search_table_new(X_search_tbl);
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: /*IF (dbms_sql.is_open(l_cursor_id)) THEN
319: dbms_sql.close_cursor(l_cursor_id);
320: END IF;*/
321: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
322: END Populate_search_table;

Line 319: dbms_sql.close_cursor(l_cursor_id);

315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: /*IF (dbms_sql.is_open(l_cursor_id)) THEN
319: dbms_sql.close_cursor(l_cursor_id);
320: END IF;*/
321: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
322: END Populate_search_table;
323:

Line 2288: l_cursor_id := dbms_sql.open_cursor;

2284: END IF;
2285:
2286: END IF;
2287:
2288: l_cursor_id := dbms_sql.open_cursor;
2289: fnd_dsql.set_cursor(l_cursor_id);
2290: l_dynamic_select := fnd_dsql.get_text(FALSE);
2291:
2292: l_dsql_debug := fnd_dsql.get_text(TRUE);

Line 2297: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);

2293: IF (l_debug = 'Y') THEN
2294: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2295: END IF;
2296:
2297: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2298: fnd_dsql.do_binds;
2299:
2300: pRows_Processed := dbms_sql.execute(l_cursor_id);
2301:

Line 2300: pRows_Processed := dbms_sql.execute(l_cursor_id);

2296:
2297: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2298: fnd_dsql.do_binds;
2299:
2300: pRows_Processed := dbms_sql.execute(l_cursor_id);
2301:
2302: IF (l_debug = 'Y') THEN
2303: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Rows fetched = '||pRows_Processed||
2304: ' and Original select cnt = '||l_row_count);

Line 2307: dbms_sql.close_cursor(l_cursor_id); -- close cursor

2303: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Rows fetched = '||pRows_Processed||
2304: ' and Original select cnt = '||l_row_count);
2305: END IF;
2306:
2307: dbms_sql.close_cursor(l_cursor_id); -- close cursor
2308:
2309: IF (l_debug = 'Y') THEN
2310: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : pRows_Processed = '||pRows_Processed);
2311: END IF;