APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_HEADERS_ARCHIVE

Line 574: l_archived_number po_headers_archive.revision_num%type;

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
578: l_progress := '000';

Line 582: PO_HEADERS_ARCHIVE POHA

578: l_progress := '000';
579: SELECT POH.revision_num, nvl(POHA.revision_num, -1)
580: into l_revision_num, l_archived_number
581: FROM PO_HEADERS POH,
582: PO_HEADERS_ARCHIVE POHA
583: WHERE POH.po_header_id = p_doc_id
584: AND POH.po_header_id = POHA.po_header_id (+)
585: AND POHA.latest_external_flag (+) = 'Y';
586:

Line 625: l_archived_number po_headers_archive.revision_num%type;

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
629:

Line 738: PO_HEADERS_ARCHIVE POHA

734: from sys.dual
735: where exists(
736: select null
737: FROM PO_HEADERS POH,
738: PO_HEADERS_ARCHIVE POHA
739: WHERE POH.po_header_id = p_doc_id
740: AND POH.po_header_id = POHA.po_header_id (+)
741: AND POHA.latest_external_flag (+) = 'Y'
742: AND (

Line 1793: from po_headers_archive

1789: l_progress := '015';
1790: BEGIN
1791: select 'Y'
1792: into l_Archive_Record_Exists
1793: from po_headers_archive
1794: where po_header_id = p_doc_id and rownum = 1;
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN
1797: l_Archive_Record_Exists := 'N';