APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_REQUISITION_HEADERS

Line 160: FROM po_requisition_headers prh

156:
157: CURSOR state_req(docid NUMBER) IS
158: SELECT nvl(prh.authorization_status, 'INCOMPLETE'),
159: nvl(prh.closed_code, 'OPEN')
160: FROM po_requisition_headers prh
161: WHERE prh.requisition_header_id = docid;
162:
163: CURSOR ship_closed(shipid NUMBER) IS
164: SELECT nvl(poll.closed_code, 'OPEN')

Line 670: FROM po_requisition_headers_all porh

666: d_progress := 60;
667:
668: SELECT porh.preparer_id
669: INTO x_preparer_id
670: FROM po_requisition_headers_all porh
671: WHERE porh.requisition_header_id = p_document_id;
672:
673: d_progress := 70;
674: IF (PO_LOG.d_stmt) THEN

Line 1067: FROM PO_REQUISITION_HEADERS porh

1063: d_progress := 50;
1064:
1065: SELECT porh.authorization_status, porh.creation_date, 0
1066: INTO l_old_status, l_creation_date, l_revision_num
1067: FROM PO_REQUISITION_HEADERS porh
1068: WHERE porh.requisition_header_id = p_document_id;
1069:
1070: ELSIF (p_document_type IN ('PA', 'PO'))
1071: THEN

Line 1818: l_conformed_id PO_REQUISITION_HEADERS_ALL.conformed_header_id%TYPE;

1814: IS
1815:
1816: l_conterms_exist PO_HEADERS.conterms_exist_flag%TYPE;
1817: l_pending_signature PO_HEADERS.pending_signature_flag%TYPE;
1818: l_conformed_id PO_REQUISITION_HEADERS_ALL.conformed_header_id%TYPE;
1819:
1820: l_ret_sts VARCHAR2(1);
1821: l_err_msg VARCHAR2(200);
1822: l_msg_count NUMBER;

Line 1850: UPDATE PO_REQUISITION_HEADERS porh

1846: THEN
1847:
1848: d_progress := 10;
1849: --Bug 5151097 : Update Approved Date when Approved
1850: UPDATE PO_REQUISITION_HEADERS porh
1851: SET porh.authorization_status = p_new_status
1852: , porh.approved_date = DECODE (p_new_status,
1853: PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
1854: SYSDATE,null)

Line 1865: FROM po_requisition_headers_all

1861: d_progress := 15;
1862:
1863: BEGIN
1864: SELECT conformed_header_id INTO l_conformed_id
1865: FROM po_requisition_headers_all
1866: WHERE requisition_header_id = p_document_id;
1867: EXCEPTION
1868: WHEN No_Data_Found THEN
1869: l_conformed_id := NULL;