DBA Data[Home] [Help]

APPS.PO_LINES_SV2 dependencies on PO_LINE_LOCATIONS

Line 69: -- PO_LINE_LOCATIONS_ALL.retroactive_date.

65: --Name: retroactive_change
66: --Pre-reqs:
67: -- None.
68: --Modifies:
69: -- PO_LINE_LOCATIONS_ALL.retroactive_date.
70: --Locks:
71: -- None.
72: --Function:
73: -- This is the API which updates the column retroactive_date in po_line_locations

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

69: -- PO_LINE_LOCATIONS_ALL.retroactive_date.
70: --Locks:
71: -- None.
72: --Function:
73: -- This is the API which updates the column retroactive_date in po_line_locations
74: -- for Release ONLY with sysdate.
75: -- This procedure is called from PO_SHIPMENTS.price_override WHEN-VALIDATE-ITEM
76: -- trigger in the Enter Release form.
77: -- This will give the release shipment a different time with its corresponding

Line 96: UPDATE po_line_locations

92: l_user_id NUMBER := FND_GLOBAL.user_id;
93: BEGIN
94: l_progress := '010';
95:
96: UPDATE po_line_locations
97: SET retroactive_date = SYSDATE,
98: last_update_date = SYSDATE,
99: last_updated_by = l_user_id
100: WHERE line_location_id = p_line_location_id;