APPS.RCV_TRANSACTION_PROCESSOR dependencies on PO_HEADERS_ALL

Line 163: l_po_auth_status PO_HEADERS_ALL.authorization_status%TYPE :='N';

159: -- Bug 9767933
160: l_archive_ext_rev_code VARCHAR2(100);
161:
162: /*start of bug 13394743*/
163: l_po_auth_status PO_HEADERS_ALL.authorization_status%TYPE :='N';
164: l_po_approved_flag PO_HEADERS_ALL.approved_flag%TYPE :='N';
165: l_pll_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE :='N';
166: l_po_unit_price PO_LINE_LOCATIONS_ALL.price_override%TYPE:=-1.0;
167: /*end of bug 13394743*/

Line 164: l_po_approved_flag PO_HEADERS_ALL.approved_flag%TYPE :='N';

160: l_archive_ext_rev_code VARCHAR2(100);
161:
162: /*start of bug 13394743*/
163: l_po_auth_status PO_HEADERS_ALL.authorization_status%TYPE :='N';
164: l_po_approved_flag PO_HEADERS_ALL.approved_flag%TYPE :='N';
165: l_pll_approved_flag PO_LINE_LOCATIONS_ALL.approved_flag%TYPE :='N';
166: l_po_unit_price PO_LINE_LOCATIONS_ALL.price_override%TYPE:=-1.0;
167: /*end of bug 13394743*/
168:

Line 223: from po_headers_all ph

219: 'RETURN TO RECEIVING', 'ACCEPT', 'REJECT', 'MATCH') ) ) THEN
220: Begin
221: select nvl(authorization_status,'N') auth_status, nvl(approved_flag,'N') app_flag
222: into l_po_auth_status, l_po_approved_flag
223: from po_headers_all ph
224: where ph.po_header_id = l_rti_row.po_header_id;
225:
226: select nvl(approved_flag,'N') app_flag, nvl(price_override, -1.0) new_price
227: into l_pll_approved_flag, l_po_unit_price