APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_HEADERS_ALL

Line 573: l_revision_num po_headers_all.revision_num%type;

569: *******************************************************************/
570:
571: FUNCTION PO_Archive_Check(p_doc_id IN NUMBER)
572: RETURN BOOLEAN IS
573: l_revision_num po_headers_all.revision_num%type;
574: l_archived_number po_headers_archive.revision_num%type;
575: l_need_to_check boolean;
576: l_progress varchar2(3);
577: begin

Line 624: l_revision_num po_headers_all.revision_num%type;

620: *******************************************************************/
621:
622: FUNCTION Release_Archive_Check(p_doc_id IN NUMBER)
623: RETURN BOOLEAN IS
624: l_revision_num po_headers_all.revision_num%type;
625: l_archived_number po_headers_archive.revision_num%type;
626: l_need_to_check boolean;
627: l_progress varchar2(3);
628: begin

Line 2138: FROM po_headers_all

2134: WHERE po_release_id = p_doc_id
2135: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2136: UNION ALL
2137: SELECT org_id
2138: FROM po_headers_all
2139: WHERE po_header_id = p_doc_id
2140: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE);
2141:
2142:

Line 2191: po_headers_all poh,

2187:
2188: FROM
2189: po_line_locations_archive_all poall,
2190: po_line_locations_all poll,
2191: po_headers_all poh,
2192: po_lines_all pol,
2193: po_distributions_all pod -----
2194: WHERE
2195: poll.line_location_id = pod.line_location_id -----