APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_HEADERS_ALL

Line 1442: UPDATE po_headers_all POH

1438: FUNCTION update_po_close_date RETURN BOOLEAN IS
1439:
1440: BEGIN
1441:
1442: UPDATE po_headers_all POH
1443: SET POH.closed_date = g_sweep_to_date
1444: WHERE po_header_id in (SELECT PLL.PO_HEADER_ID
1445: FROM PO_LINE_LOCATIONS_ALL PLL,
1446: PO_DISTRIBUTIONS_ALL PD,

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

1456: HAVING SUM(GT.AMOUNT) > 0)
1457: AND ( POH.CLOSED_DATE IS NOT NULL
1458: AND POH.CLOSED_DATE < g_sweep_to_date );
1459:
1460: debug ('update_po_close_date: total records updated in po_headers_all:'||sql%rowcount);
1461:
1462:
1463: UPDATE po_line_locations_all
1464: SET closed_date = g_sweep_to_date