APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_HEADERS

Line 1766: FROM po_headers_all poh

1762: d_progress := 40;
1763:
1764: SELECT NVL(poh.encumbrance_required_flag, 'N')
1765: INTO l_bpa_enc_required
1766: FROM po_headers_all poh
1767: WHERE poh.po_header_id = p_document_id;
1768:
1769: d_progress := 50;
1770: IF (PO_LOG.d_stmt) THEN

Line 2075: UPDATE po_headers poh

2071: ELSIF ((p_document_type = 'PA') and (p_document_subtype = 'CONTRACT')) then
2072:
2073: d_progress := 30;
2074:
2075: UPDATE po_headers poh
2076: SET poh.last_update_date = SYSDATE
2077: , poh.last_updated_by = p_user_id
2078: , poh.last_update_login = p_login_id
2079: , poh.closed_date = DECODE(p_action,

Line 2503: FROM po_headers_all

2499: ELSE
2500:
2501: SELECT Nvl(authorization_status, 'INCOMPLETE')
2502: INTO l_authorization_status
2503: FROM po_headers_all
2504: WHERE po_header_id = p_document_id;
2505:
2506: END IF;
2507:

Line 3357: UPDATE po_headers poh

3353: IF (PO_LOG.d_stmt) THEN
3354: PO_LOG.stmt(d_module, d_progress, 'l_rollup_code', l_rollup_code);
3355: END IF;
3356:
3357: UPDATE po_headers poh
3358: SET poh.closed_code = l_rollup_code
3359: , poh.last_update_date = SYSDATE
3360: , poh.last_updated_by = p_user_id
3361: , poh.last_update_login = p_login_id