APPS.PO_LINES_SV2 dependencies on PO_LINE_LOCATIONS

Line 93: -- PO_LINE_LOCATIONS_ALL.retroactive_date.

89: --Name: retroactive_change
90: --Pre-reqs:
91: -- None.
92: --Modifies:
93: -- PO_LINE_LOCATIONS_ALL.retroactive_date.
94: --Locks:
95: -- None.
96: --Function:
97: -- This is the API which updates the column retroactive_date in po_line_locations

Line 97: -- This is the API which updates the column retroactive_date in po_line_locations

93: -- PO_LINE_LOCATIONS_ALL.retroactive_date.
94: --Locks:
95: -- None.
96: --Function:
97: -- This is the API which updates the column retroactive_date in po_line_locations
98: -- for Release ONLY with sysdate.
99: -- This procedure is called from PO_SHIPMENTS.price_override WHEN-VALIDATE-ITEM
100: -- trigger in the Enter Release form.
101: -- This will give the release shipment a different time with its corresponding

Line 123: UPDATE po_line_locations pll

119:
120: --Bug12931756, update retroactive_date directly to the same date as
121: --on the corresponding blanket agreement line. The approval workflow
122: --would not update the retroactive_date again
123: UPDATE po_line_locations pll
124: SET retroactive_date = (SELECT pl.retroactive_date
125: FROM po_lines_all pl
126: WHERE pl.po_line_id = pll.po_line_id),
127: --retroactive_date = SYSDATE,