APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1445: FROM PO_LINE_LOCATIONS_ALL PLL,

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,
1447: AP_PERIOD_CLOSE_EXCPS_GT GT
1448: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1449: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID

Line 1463: UPDATE po_line_locations_all

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
1465: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1466: FROM PO_LINE_LOCATIONS_ALL PLL,
1467: PO_DISTRIBUTIONS_ALL PD,

Line 1466: FROM PO_LINE_LOCATIONS_ALL PLL,

1462:
1463: UPDATE po_line_locations_all
1464: SET closed_date = g_sweep_to_date
1465: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1466: FROM PO_LINE_LOCATIONS_ALL PLL,
1467: PO_DISTRIBUTIONS_ALL PD,
1468: AP_PERIOD_CLOSE_EXCPS_GT GT
1469: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1470: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID

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

1475: AND PLL.CLOSED_DATE < g_sweep_to_date )
1476: GROUP BY PLL.LINE_LOCATION_ID, GT.PO_DISTRIBUTION_ID
1477: HAVING SUM(GT.AMOUNT) > 0);
1478:
1479: debug ('update_po_close_date: total records updated in po_line_locations_all:'||sql%rowcount);
1480:
1481: return TRUE;
1482:
1483: exception