APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_RELEASES_ALL

Line 208: FROM PO_RELEASES_ALL PH,

204: -- SQL Why : Check if the document is approved and not archived
205: SELECT NVL(ph.revision_num, 0),
206: NVL(pha.revision_num, -1)
207: INTO x_revision_num, l_arch_revision_num
208: FROM PO_RELEASES_ALL PH,
209: PO_RELEASES_ARCHIVE_ALL PHA
210: WHERE ph.po_release_id = p_document_id
211: AND ph.approved_date IS NOT NULL
212: AND ph.approved_flag = 'Y'

Line 965: FROM PO_RELEASES_ALL

961: xml_send_date ,
962: 'Y',
963: document_creation_method --
964: , submit_date --
965: FROM PO_RELEASES_ALL
966: WHERE po_release_id = p_document_id;
967:
968: l_progress := '030';
969:

Line 2202: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;

2198: l_clm_flag VARCHAR2(1) := 'N';
2199:
2200: -- Bug 3648552
2201: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2202: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
2203:
2204:
2205: BEGIN
2206:

Line 2578: FROM po_releases_all

2574: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id
2575: IF (p_document_type = 'RELEASE') THEN
2576: SELECT po_header_id
2577: INTO l_po_header_id
2578: FROM po_releases_all
2579: WHERE po_release_id = p_document_id;
2580: l_po_release_id := p_document_id;
2581: ELSE
2582: l_po_header_id := p_document_id;