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

Line 323: curs := DBMS_SQL.OPEN_CURSOR;

319: FROM az_contexts_sql
320: WHERE context = ctx_type
321: AND purpose = 'VALIDATE';
322:
323: curs := DBMS_SQL.OPEN_CURSOR;
324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
325:
326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);

Line 324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);

320: WHERE context = ctx_type
321: AND purpose = 'VALIDATE';
322:
323: curs := DBMS_SQL.OPEN_CURSOR;
324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
325:
326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);

Line 326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);

322:
323: curs := DBMS_SQL.OPEN_CURSOR;
324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
325:
326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);
329:
330: rows := DBMS_SQL.EXECUTE(curs);

Line 327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);

323: curs := DBMS_SQL.OPEN_CURSOR;
324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
325:
326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);
329:
330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);

Line 328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);

324: DBMS_SQL.PARSE(curs, sqlstatement, DBMS_SQL.NATIVE);
325:
326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);
329:
330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:

Line 330: rows := DBMS_SQL.EXECUTE(curs);

326: DBMS_SQL.DEFINE_COLUMN(curs, 1, current_ctx_id);
327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);
329:
330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:
333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);
334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);

Line 331: rows := DBMS_SQL.FETCH_ROWS(curs);

327: DBMS_SQL.DEFINE_COLUMN(curs, 2, current_ctx_name, 80);
328: DBMS_SQL.BIND_VARIABLE(curs, ':opm_id', opm_id);
329:
330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:
333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);
334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);
335: DBMS_SQL.CLOSE_CURSOR(curs);

Line 333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);

329:
330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:
333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);
334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);
335: DBMS_SQL.CLOSE_CURSOR(curs);
336:
337: EXCEPTION

Line 334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);

330: rows := DBMS_SQL.EXECUTE(curs);
331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:
333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);
334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);
335: DBMS_SQL.CLOSE_CURSOR(curs);
336:
337: EXCEPTION
338: WHEN OTHERS THEN

Line 335: DBMS_SQL.CLOSE_CURSOR(curs);

331: rows := DBMS_SQL.FETCH_ROWS(curs);
332:
333: DBMS_SQL.COLUMN_VALUE(curs, 1, current_ctx_id);
334: DBMS_SQL.COLUMN_VALUE(curs, 2, current_ctx_name);
335: DBMS_SQL.CLOSE_CURSOR(curs);
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: IF DBMS_SQL.IS_OPEN(curs) then

Line 339: IF DBMS_SQL.IS_OPEN(curs) then

335: DBMS_SQL.CLOSE_CURSOR(curs);
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: IF DBMS_SQL.IS_OPEN(curs) then
340: DBMS_SQL.CLOSE_CURSOR(curs);
341: END IF;
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 340: DBMS_SQL.CLOSE_CURSOR(curs);

336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: IF DBMS_SQL.IS_OPEN(curs) then
340: DBMS_SQL.CLOSE_CURSOR(curs);
341: END IF;
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);