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.PO_REQUISITION_LINES_PKG2 dependencies on PO_REQUISITION_HEADERS_ALL

Line 134: x_auth_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

130: CURSOR C2 IS SELECT po_requisition_lines_s.nextval FROM sys.dual;
131:
132: -- begin
133: x_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.REQS_IN_POOL_FLAG%TYPE;
134: x_auth_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
135: x_contractor_status PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
136: x_progress VARCHAR2(3) := NULL;
137: x_return_status VARCHAR2(1);
138:

Line 135: x_contractor_status PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;

131:
132: -- begin
133: x_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.REQS_IN_POOL_FLAG%TYPE;
134: x_auth_status PO_REQUISITION_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
135: x_contractor_status PO_REQUISITION_HEADERS_ALL.CONTRACTOR_STATUS%TYPE;
136: x_progress VARCHAR2(3) := NULL;
137: x_return_status VARCHAR2(1);
138:
139: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;

Line 163: FROM po_requisition_headers_all prh

159: SELECT prh.authorization_status
160: , prh.contractor_status
161: INTO x_auth_status
162: , x_contractor_status
163: FROM po_requisition_headers_all prh
164: WHERE prh.requisition_header_id = X_Requisition_Header_Id;
165:
166: x_progress := '012';
167: