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

Line 427: l_cursor := dbms_sql.open_cursor;

423: l_display VARCHAR2(254);
424: l_ret_code NUMBER;
425: l_count NUMBER;
426: BEGIN
427: l_cursor := dbms_sql.open_cursor;
428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);
429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);

Line 428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);

424: l_ret_code NUMBER;
425: l_count NUMBER;
426: BEGIN
427: l_cursor := dbms_sql.open_cursor;
428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);
429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);
432: l_count := 0;

Line 429: dbms_sql.define_column(l_cursor, 1, l_value, 254);

425: l_count NUMBER;
426: BEGIN
427: l_cursor := dbms_sql.open_cursor;
428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);
429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);
432: l_count := 0;
433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);

Line 430: dbms_sql.define_column(l_cursor, 2, l_display, 254);

426: BEGIN
427: l_cursor := dbms_sql.open_cursor;
428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);
429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);
432: l_count := 0;
433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);
434:

Line 431: l_ret_code := dbms_sql.execute(l_cursor);

427: l_cursor := dbms_sql.open_cursor;
428: dbms_sql.parse(l_cursor, p_select, DBMS_SQL.V7);
429: dbms_sql.define_column(l_cursor, 1, l_value, 254);
430: dbms_sql.define_column(l_cursor, 2, l_display, 254);
431: l_ret_code := dbms_sql.execute(l_cursor);
432: l_count := 0;
433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);
434:
435: LOOP

Line 437: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN

433: p_output := p_output || ' ' || htf.formSelectOpen(p_name);
434:
435: LOOP
436:
437: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
438: l_count := l_count + 1;
439: dbms_sql.column_value(l_cursor, 1, l_value);
440: dbms_sql.column_value(l_cursor, 2, l_display);
441:

Line 439: dbms_sql.column_value(l_cursor, 1, l_value);

435: LOOP
436:
437: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
438: l_count := l_count + 1;
439: dbms_sql.column_value(l_cursor, 1, l_value);
440: dbms_sql.column_value(l_cursor, 2, l_display);
441:
442: IF l_count = 1 THEN
443: p_output := p_output || ' ' ||

Line 440: dbms_sql.column_value(l_cursor, 2, l_display);

436:
437: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
438: l_count := l_count + 1;
439: dbms_sql.column_value(l_cursor, 1, l_value);
440: dbms_sql.column_value(l_cursor, 2, l_display);
441:
442: IF l_count = 1 THEN
443: p_output := p_output || ' ' ||
444: htf.formSelectOption(l_display, 'YES', 'value="' || l_value || '"');

Line 456: dbms_sql.close_cursor(l_cursor);

452: END IF;
453:
454: END LOOP;
455:
456: dbms_sql.close_cursor(l_cursor);
457: p_output := p_output || ' ' || htf.formSelectClose;
458:
459: EXCEPTION
460: WHEN others THEN