APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 412: from po_line_locations_all pll, po_line_locations_draft_all pld

408: pll.quantity_received,
409: pll.quantity_billed,
410: pll.amount_received,
411: pll.amount_billed*/
412: from po_line_locations_all pll, po_line_locations_draft_all pld
413: where pld.line_location_id = pll.line_location_id
414: and pld.draft_id = p_draft_id
415: and (pld.quantity_received <> pll.quantity_received or
416: pld.quantity_billed <> pll.quantity_billed or

Line 926: UPDATE po_line_locations_draft_all

922: 'Updating shipments ');
923: --update
924: FORALL I in l_shipments.line_location_id.first
925: ..l_shipments.line_location_id.last
926: UPDATE po_line_locations_draft_all
927: set quantity_received = l_shipments.quantity_received(I),
928: quantity_billed = l_shipments.quantity_billed(I),
929: amount_received = l_shipments.amount_received(I),
930: amount_billed = l_shipments.amount_billed(I)

Line 2049: ,po_line_locations_draft_all plda

2045: l_draft_old_amount_tbl,
2046: l_line_location_tbl,
2047: l_change_status_tbl
2048: FROM po_line_locations_all pla
2049: ,po_line_locations_draft_all plda
2050: WHERE pla.line_location_id = plda.line_location_id
2051: AND plda.draft_id = p_draft_id
2052: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
2053: AND NOT EXISTS (SELECT 'F locks'

Line 2081: FROM po_line_locations_draft_all plda,

2077: ,'N'
2078: BULK COLLECT INTO l_po_line_loc_s_no_lck_tbl
2079: ,l_draft_id_tbl
2080: ,l_delete_flag_tbl
2081: FROM po_line_locations_draft_all plda,
2082: po_line_locations_all pla
2083: WHERE plda.draft_id = p_draft_id
2084: AND pla.line_location_id = plda.line_location_id
2085: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 2103: DELETE FROM po_line_locations_draft_all plda

2099: END IF;
2100:
2101: -- 3. Delete shipments identified in #2 above.
2102: FORALL i in 1..l_po_line_loc_s_no_lck_tbl.COUNT
2103: DELETE FROM po_line_locations_draft_all plda
2104: WHERE plda.line_location_id = l_po_line_loc_s_no_lck_tbl(i)
2105: AND plda.draft_id = p_draft_id;
2106:
2107: d_position := 50;

Line 2127: UPDATE po_line_locations_draft_all

2123: END IF;
2124:
2125: -- 5. Sync quantity and amount using the values fetched in #1 above
2126: FORALL i in 1.. l_line_location_tbl.COUNT
2127: UPDATE po_line_locations_draft_all
2128: SET old_quantity = l_base_quantity_tbl(i)
2129: ,quantity = l_base_quantity_tbl(i) + (l_draft_quantity_tbl(i)-l_draft_old_quantity_tbl(i))
2130: ,old_amount = l_base_amount_tbl(i)
2131: ,amount = l_base_amount_tbl(i) + (l_draft_amount_tbl(i) - l_draft_old_amount_tbl(i))

Line 2156: UPDATE po_line_locations_draft_all

2152: PO_LOG.stmt(d_module,d_position ,'sync_shipments_ext');
2153: END IF;
2154:
2155: FORALL i in 1.. l_line_location_tbl.COUNT
2156: UPDATE po_line_locations_draft_all
2157: SET revision_num=l_header_base_rev_num(i),
2158: change_status = l_change_status_tbl(i)
2159: WHERE line_location_id = l_line_location_tbl(i)
2160: AND draft_id = p_draft_id;