DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_HEADERS_ALL

Line 1705: UPDATE po_headers_all POH

1701: FUNCTION update_po_close_date RETURN BOOLEAN IS
1702:
1703: BEGIN
1704:
1705: UPDATE po_headers_all POH
1706: SET POH.closed_date = g_sweep_to_date
1707: WHERE po_header_id in (SELECT PLL.PO_HEADER_ID
1708: FROM PO_LINE_LOCATIONS_ALL PLL,
1709: PO_DISTRIBUTIONS_ALL PD,

Line 1723: debug ('update_po_close_date: total records updated in po_headers_all:'||sql%rowcount);

1719: HAVING SUM(GT.AMOUNT) > 0)
1720: AND ( POH.CLOSED_DATE IS NOT NULL
1721: AND POH.CLOSED_DATE < g_sweep_to_date );
1722:
1723: debug ('update_po_close_date: total records updated in po_headers_all:'||sql%rowcount);
1724:
1725:
1726: UPDATE po_line_locations_all
1727: SET closed_date = g_sweep_to_date