APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_HEADERS

Line 1689: FROM po_headers_all poh

1685: d_progress := 40;
1686:
1687: SELECT NVL(poh.encumbrance_required_flag, 'N')
1688: INTO l_bpa_enc_required
1689: FROM po_headers_all poh
1690: WHERE poh.po_header_id = p_document_id;
1691:
1692: d_progress := 50;
1693: IF (PO_LOG.d_stmt) THEN

Line 1994: UPDATE po_headers poh

1990: ELSIF ((p_document_type = 'PA') and (p_document_subtype = 'CONTRACT')) then
1991:
1992: d_progress := 30;
1993:
1994: UPDATE po_headers poh
1995: SET poh.last_update_date = SYSDATE
1996: , poh.last_updated_by = p_user_id
1997: , poh.last_update_login = p_login_id
1998: , poh.closed_date = DECODE(p_action,

Line 3064: UPDATE po_headers poh

3060: IF (PO_LOG.d_stmt) THEN
3061: PO_LOG.stmt(d_module, d_progress, 'l_rollup_code', l_rollup_code);
3062: END IF;
3063:
3064: UPDATE po_headers poh
3065: SET poh.closed_code = l_rollup_code
3066: , poh.last_update_date = SYSDATE
3067: , poh.last_updated_by = p_user_id
3068: , poh.last_update_login = p_login_id