APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ALL

Line 75: FROM PO_HEADERS_ALL PH,

71: -- SQL Why : Check if the document is approved and not archived
72: SELECT NVL(ph.revision_num, 0),
73: NVL(pha.revision_num, -1)
74: INTO x_revision_num, l_arch_revision_num
75: FROM PO_HEADERS_ALL PH,
76: PO_HEADERS_ARCHIVE_ALL PHA
77: WHERE ph.po_header_id = p_document_id
78: AND ph.approved_date IS NOT NULL
79: AND ph.approved_flag = 'Y'

Line 541: FROM PO_HEADERS_ALL

537: , created_language --
538: , cpa_reference --
539: , last_updated_program --
540: , pay_when_paid -- E and C ER
541: FROM PO_HEADERS_ALL
542: WHERE po_header_id = p_document_id;
543:
544: l_progress := '030';
545:

Line 1898: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1894: l_revision_num NUMBER;
1895: l_continue BOOLEAN := FALSE;
1896:
1897: -- Bug 3648552
1898: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1899: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
1900:
1901:
1902: BEGIN

Line 2618: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

2614: l_progress VARCHAR2(3);
2615: l_return_status VARCHAR2(1);
2616: l_msg_count NUMBER;
2617: l_msg_data VARCHAR2(2000);
2618: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2619: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;
2620: l_clear_amendment VARCHAR2(1);
2621:
2622:

Line 2619: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;

2615: l_return_status VARCHAR2(1);
2616: l_msg_count NUMBER;
2617: l_msg_data VARCHAR2(2000);
2618: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
2619: l_pending_signature_flag PO_HEADERS_ALL.pending_signature_flag%TYPE;
2620: l_clear_amendment VARCHAR2(1);
2621:
2622:
2623: BEGIN

Line 2644: FROM po_headers_all

2640: SELECT NVL(conterms_exist_flag, 'N'),
2641: NVL(pending_signature_flag, 'N')
2642: INTO l_conterms_exist_flag,
2643: l_pending_signature_flag
2644: FROM po_headers_all
2645: WHERE po_header_id = p_document_id;
2646:
2647: IF (l_conterms_exist_flag = 'Y') THEN
2648: l_progress := '020';

Line 2826: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

2822: l_module VARCHAR2(100);
2823: l_progress VARCHAR2(3);
2824: l_revision_num NUMBER;
2825: l_return_status VARCHAR2(1);
2826: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
2827:
2828: BEGIN
2829:
2830: -- Standard call to check for call compatibility

Line 3027: FROM po_headers_all

3023: -- SQL What:Find out if it is a global agreement
3024: -- SQL Why :Archive org_assignment table if needed
3025: SELECT NVL(global_agreement_flag, 'N')
3026: INTO l_ga_flag
3027: FROM po_headers_all
3028: WHERE po_header_id = p_document_id;
3029:
3030: IF (l_ga_flag = 'Y') THEN
3031: l_progress := '170';