APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_REQUISITION_HEADERS

Line 129: FROM po_requisition_headers prh

125:
126: CURSOR state_req(docid NUMBER) IS
127: SELECT nvl(prh.authorization_status, 'INCOMPLETE'),
128: nvl(prh.closed_code, 'OPEN')
129: FROM po_requisition_headers prh
130: WHERE prh.requisition_header_id = docid;
131:
132: CURSOR ship_closed(shipid NUMBER) IS
133: SELECT nvl(poll.closed_code, 'OPEN')

Line 545: FROM po_requisition_headers_all porh

541: d_progress := 60;
542:
543: SELECT porh.preparer_id
544: INTO x_preparer_id
545: FROM po_requisition_headers_all porh
546: WHERE porh.requisition_header_id = p_document_id;
547:
548: d_progress := 70;
549: IF (PO_LOG.d_stmt) THEN

Line 906: FROM PO_REQUISITION_HEADERS porh

902: d_progress := 50;
903:
904: SELECT porh.authorization_status, porh.creation_date, 0
905: INTO l_old_status, l_creation_date, l_revision_num
906: FROM PO_REQUISITION_HEADERS porh
907: WHERE porh.requisition_header_id = p_document_id;
908:
909: ELSIF (p_document_type IN ('PA', 'PO'))
910: THEN

Line 1655: UPDATE PO_REQUISITION_HEADERS porh

1651: THEN
1652:
1653: d_progress := 10;
1654: --Bug 5151097 : Update Approved Date when Approved
1655: UPDATE PO_REQUISITION_HEADERS porh
1656: SET porh.authorization_status = p_new_status
1657: , porh.approved_date = DECODE (p_new_status,
1658: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1659: SYSDATE,null)