DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_REQUISITION_HEADERS_ALL

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 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 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;