APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_HEADERS_ALL

Line 649: FROM po_headers_all poh

645: ELSE
646: BEGIN
647: SELECT poh.agent_id
648: INTO x_preparer_id
649: FROM po_headers_all poh
650: WHERE poh.po_header_id = p_document_id;
651: EXCEPTION
652: WHEN OTHERS THEN
653: IF (PO_LOG.d_stmt) THEN

Line 1247: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

1243: l_rollup_msg VARCHAR2(256);
1244: l_ctl_replaced_null_entry BOOLEAN := FALSE;
1245: l_count_hist NUMBER;
1246:
1247: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
1248:
1249: BEGIN
1250:
1251: d_progress := 0;

Line 1440: FROM po_headers_all poh

1436: -- so we're safe using headers_all
1437:
1438: SELECT max(poh.revision_num)
1439: INTO l_revision_num
1440: FROM po_headers_all poh
1441: WHERE poh.po_header_id = p_document_id;
1442:
1443: d_progress := 160;
1444: IF (PO_LOG.d_stmt) THEN

Line 2059: FROM po_headers_all poh

2055: undef_clm_document_number =
2056: Decode (p_draft_id,
2057: def_draft_id, undef_clm_document_number,
2058: -1, (SELECT clm_document_number
2059: FROM po_headers_all poh
2060: WHERE poh.po_header_id = p_document_id),
2061: (SELECT modification_number
2062: FROM po_drafts
2063: WHERE document_id = p_document_id

Line 2085: FROM PO_HEADERS_ALL poh

2081: WHERE poll.po_header_id = p_document_id
2082: AND poll.po_release_id IS NULL
2083: AND NVL(poll.approved_flag, 'N') <> 'Y'
2084: AND EXISTS ( SELECT 'PO Does not require signature'
2085: FROM PO_HEADERS_ALL poh
2086: WHERE poh.po_header_id = poll.po_header_id
2087: AND NVL(poh.pending_signature_flag, 'N') <> 'Y');
2088:
2089: IF ((l_ret_sts = FND_API.G_RET_STS_UNEXP_ERROR)

Line 2636: FROM po_headers_all

2632: -- Changed the above line to handle the CPA case also
2633: IF ( l_idv_header_id IS NOT NULL) THEN
2634:
2635: SELECT clm_amount_released INTO l_clm_amt_released_hdr
2636: FROM po_headers_all
2637: WHERE po_header_id = l_idv_header_id;
2638:
2639: -- Changed the above line to handle the BPA case only
2640: IF ( l_idv_line_id IS NOT NULL) THEN

Line 2772: UPDATE po_headers_all SET CLM_AMOUNT_RELEASED = l_clm_amt_released_hdr

2768: PO_LOG.stmt(d_module, d_progress, 'l_amt_ordered_idv_line ', l_amt_ordered_idv_line);
2769: PO_LOG.stmt(d_module, d_progress, 'l_qty_ordered_idv_line ', l_qty_ordered_idv_line);
2770: END IF;
2771:
2772: UPDATE po_headers_all SET CLM_AMOUNT_RELEASED = l_clm_amt_released_hdr
2773: WHERE po_header_id = l_idv_header_id;
2774:
2775: d_progress := 80;
2776: -- Changed the above line to handle the BPA case only