APPS.PO_SUPPLY dependencies on PO_HEADERS

Line 488: l_auth_status po_headers.authorization_status%TYPE;

484:
485:
486: FUNCTION approve_po_supply(p_docid IN NUMBER) RETURN BOOLEAN IS
487:
488: l_auth_status po_headers.authorization_status%TYPE;
489:
490: -- : This cursor was incorrectly accessing
491: -- po_requisition_headers instead of po_headers. Verified against
492: -- older Pro*C code, which was using po_headers.

Line 491: -- po_requisition_headers instead of po_headers. Verified against

487:
488: l_auth_status po_headers.authorization_status%TYPE;
489:
490: -- : This cursor was incorrectly accessing
491: -- po_requisition_headers instead of po_headers. Verified against
492: -- older Pro*C code, which was using po_headers.
493:
494: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
495: CURSOR auth_status(header_id NUMBER)

Line 492: -- older Pro*C code, which was using po_headers.

488: l_auth_status po_headers.authorization_status%TYPE;
489:
490: -- : This cursor was incorrectly accessing
491: -- po_requisition_headers instead of po_headers. Verified against
492: -- older Pro*C code, which was using po_headers.
493:
494: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
495: CURSOR auth_status(header_id NUMBER)
496: IS

Line 498: FROM po_headers_all poh

494: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
495: CURSOR auth_status(header_id NUMBER)
496: IS
497: SELECT poh.authorization_status
498: FROM po_headers_all poh
499: WHERE poh.po_header_id = header_id;
500:
501: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_po_supply';
502: d_progress NUMBER;

Line 613: l_auth_status po_headers.authorization_status%TYPE;

609: FUNCTION approve_blanket_supply(p_docid IN NUMBER)
610: RETURN BOOLEAN
611: IS
612:
613: l_auth_status po_headers.authorization_status%TYPE;
614: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
615: CURSOR auth_status(release_id NUMBER)
616: IS
617: SELECT por.authorization_status