APPS.PO_DRAFT_MERGE_PKG dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 2337: UPDATE po_line_locations_archive_all polla

2333: AND polld.draft_id = p_draft_id
2334: AND polld.change_status = 'NEW')))
2335: LOOP
2336:
2337: UPDATE po_line_locations_archive_all polla
2338: SET polla.need_by_date = poll.need_by_date,
2339: polla.promised_date = poll.promised_date,
2340: polla.last_accept_date = poll.last_accept_date,
2341: polla.clm_period_perf_start_date = poll.clm_period_perf_start_date,

Line 2353: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_archive_all - No of rows updated :' , SQL%ROWCOUNT);

2349: END LOOP;
2350:
2351: d_progress := 11;
2352: IF (PO_LOG.d_stmt) THEN
2353: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_archive_all - No of rows updated :' , SQL%ROWCOUNT);
2354: END IF;
2355:
2356:
2357: EXCEPTION