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

Line 572: p_values dbms_sql.VARCHAR2_TABLE;

568: * This function returns multiple_value or shipment number of a given *
569: * requisition line id *
570: **************************************************************************/
571: function get_shipment_number(req_line_id NUMBER) RETURN VARCHAR2 is
572: p_values dbms_sql.VARCHAR2_TABLE;
573: begin
574: select RSH.SHIPMENT_NUM BULK COLLECT INTO p_values
575: from RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL
576: WHERE RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID