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

Line 257: CUR := DBMS_SQL.OPEN_CURSOR;

253: RET INTEGER;
254:
255: BEGIN
256:
257: CUR := DBMS_SQL.OPEN_CURSOR;
258: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
259: RET := DBMS_SQL.EXECUTE(CUR);
260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:

Line 258: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);

254:
255: BEGIN
256:
257: CUR := DBMS_SQL.OPEN_CURSOR;
258: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
259: RET := DBMS_SQL.EXECUTE(CUR);
260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:
262: exception when others then

Line 259: RET := DBMS_SQL.EXECUTE(CUR);

255: BEGIN
256:
257: CUR := DBMS_SQL.OPEN_CURSOR;
258: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
259: RET := DBMS_SQL.EXECUTE(CUR);
260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:
262: exception when others then
263: IF dbms_sql.is_open(cur) THEN

Line 260: DBMS_SQL.CLOSE_CURSOR(CUR);

256:
257: CUR := DBMS_SQL.OPEN_CURSOR;
258: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
259: RET := DBMS_SQL.EXECUTE(CUR);
260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:
262: exception when others then
263: IF dbms_sql.is_open(cur) THEN
264: dbms_sql.close_cursor(cur);

Line 263: IF dbms_sql.is_open(cur) THEN

259: RET := DBMS_SQL.EXECUTE(CUR);
260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:
262: exception when others then
263: IF dbms_sql.is_open(cur) THEN
264: dbms_sql.close_cursor(cur);
265: END IF;
266: raise;
267: END EXEC_SQL;

Line 264: dbms_sql.close_cursor(cur);

260: DBMS_SQL.CLOSE_CURSOR(CUR);
261:
262: exception when others then
263: IF dbms_sql.is_open(cur) THEN
264: dbms_sql.close_cursor(cur);
265: END IF;
266: raise;
267: END EXEC_SQL;
268:

Line 321: cursor_handle := DBMS_SQL.OPEN_CURSOR;

317: RAISE_APPLICATION_ERROR(-20999,'Bind variables and values does not match');
318: RETURN;
319: END IF ;
320:
321: cursor_handle := DBMS_SQL.OPEN_CURSOR;
322: DBMS_SQL.PARSE(cursor_handle,p_sql,dbms_sql.native);
323:
324: FOR i IN vars_in.FIRST .. vars_in.LAST
325: LOOP

Line 322: DBMS_SQL.PARSE(cursor_handle,p_sql,dbms_sql.native);

318: RETURN;
319: END IF ;
320:
321: cursor_handle := DBMS_SQL.OPEN_CURSOR;
322: DBMS_SQL.PARSE(cursor_handle,p_sql,dbms_sql.native);
323:
324: FOR i IN vars_in.FIRST .. vars_in.LAST
325: LOOP
326: DBMS_SQL.BIND_VARIABLE (cursor_handle, vars_in(i), values_in(i));

Line 326: DBMS_SQL.BIND_VARIABLE (cursor_handle, vars_in(i), values_in(i));

322: DBMS_SQL.PARSE(cursor_handle,p_sql,dbms_sql.native);
323:
324: FOR i IN vars_in.FIRST .. vars_in.LAST
325: LOOP
326: DBMS_SQL.BIND_VARIABLE (cursor_handle, vars_in(i), values_in(i));
327: END LOOP;
328:
329: status := DBMS_SQL.EXECUTE(cursor_handle);
330:

Line 329: status := DBMS_SQL.EXECUTE(cursor_handle);

325: LOOP
326: DBMS_SQL.BIND_VARIABLE (cursor_handle, vars_in(i), values_in(i));
327: END LOOP;
328:
329: status := DBMS_SQL.EXECUTE(cursor_handle);
330:
331: DBMS_SQL.CLOSE_CURSOR (cursor_handle);
332:
333: EXCEPTION

Line 331: DBMS_SQL.CLOSE_CURSOR (cursor_handle);

327: END LOOP;
328:
329: status := DBMS_SQL.EXECUTE(cursor_handle);
330:
331: DBMS_SQL.CLOSE_CURSOR (cursor_handle);
332:
333: EXCEPTION
334: WHEN OTHERS
335: THEN

Line 336: IF DBMS_SQL.IS_OPEN(cursor_handle) THEN

332:
333: EXCEPTION
334: WHEN OTHERS
335: THEN
336: IF DBMS_SQL.IS_OPEN(cursor_handle) THEN
337: DBMS_SQL.CLOSE_CURSOR (cursor_handle);
338: END IF;
339: RAISE;
340: END exec_sql_with_binds;

Line 337: DBMS_SQL.CLOSE_CURSOR (cursor_handle);

333: EXCEPTION
334: WHEN OTHERS
335: THEN
336: IF DBMS_SQL.IS_OPEN(cursor_handle) THEN
337: DBMS_SQL.CLOSE_CURSOR (cursor_handle);
338: END IF;
339: RAISE;
340: END exec_sql_with_binds;
341:

Line 404: cursor_handle := dbms_sql.open_cursor;

400: ret_value NUMBER;
401:
402: BEGIN
403:
404: cursor_handle := dbms_sql.open_cursor;
405:
406: fnd_dsql.set_cursor(cursor_handle);
407:
408: sql_text := fnd_dsql.get_text;

Line 412: dbms_sql.parse(cursor_handle,sql_text,dbms_sql.NATIVE);

408: sql_text := fnd_dsql.get_text;
409:
410: -- qa_skiplot_utility.insert_error_log(p_module_name => 'cu2.qlttxn.100', p_error_message => sql_text);
411:
412: dbms_sql.parse(cursor_handle,sql_text,dbms_sql.NATIVE);
413:
414: -- bind the variable
415: fnd_dsql.do_binds;
416:

Line 417: ret_value := dbms_sql.execute(cursor_handle);

413:
414: -- bind the variable
415: fnd_dsql.do_binds;
416:
417: ret_value := dbms_sql.execute(cursor_handle);
418:
419: dbms_sql.close_cursor(cursor_handle);
420:
421: EXCEPTION

Line 419: dbms_sql.close_cursor(cursor_handle);

415: fnd_dsql.do_binds;
416:
417: ret_value := dbms_sql.execute(cursor_handle);
418:
419: dbms_sql.close_cursor(cursor_handle);
420:
421: EXCEPTION
422: WHEN OTHERS
423: THEN

Line 424: IF dbms_sql.is_open(cursor_handle) THEN

420:
421: EXCEPTION
422: WHEN OTHERS
423: THEN
424: IF dbms_sql.is_open(cursor_handle) THEN
425: dbms_sql.close_cursor (cursor_handle);
426: END IF;
427: RAISE; -- dont know what to do with exception. So just propagate it.
428:

Line 425: dbms_sql.close_cursor (cursor_handle);

421: EXCEPTION
422: WHEN OTHERS
423: THEN
424: IF dbms_sql.is_open(cursor_handle) THEN
425: dbms_sql.close_cursor (cursor_handle);
426: END IF;
427: RAISE; -- dont know what to do with exception. So just propagate it.
428:
429: