DBA Data[Home] [Help]

APPS.PO_REQIMP_PKG dependencies on PO_LINE_LOCATIONS

Line 277: x_unit_of_purchase IN po_line_locations.unit_meas_lookup_code%TYPE,

273: -- +=======================================================================+
274:
275: PROCEDURE JA_AU_PRICE_BREAK
276: (x_po_line_id IN po_lines.po_line_id%TYPE,
277: x_unit_of_purchase IN po_line_locations.unit_meas_lookup_code%TYPE,
278: x_quantity IN po_line_locations.quantity%TYPE,
279: x_unit_price OUT NOCOPY po_line_locations.price_override%TYPE)
280: IS
281:

Line 278: x_quantity IN po_line_locations.quantity%TYPE,

274:
275: PROCEDURE JA_AU_PRICE_BREAK
276: (x_po_line_id IN po_lines.po_line_id%TYPE,
277: x_unit_of_purchase IN po_line_locations.unit_meas_lookup_code%TYPE,
278: x_quantity IN po_line_locations.quantity%TYPE,
279: x_unit_price OUT NOCOPY po_line_locations.price_override%TYPE)
280: IS
281:
282: CURSOR l_price_break

Line 279: x_unit_price OUT NOCOPY po_line_locations.price_override%TYPE)

275: PROCEDURE JA_AU_PRICE_BREAK
276: (x_po_line_id IN po_lines.po_line_id%TYPE,
277: x_unit_of_purchase IN po_line_locations.unit_meas_lookup_code%TYPE,
278: x_quantity IN po_line_locations.quantity%TYPE,
279: x_unit_price OUT NOCOPY po_line_locations.price_override%TYPE)
280: IS
281:
282: CURSOR l_price_break
283: IS SELECT poll.price_override

Line 284: FROM po_line_locations poll

280: IS
281:
282: CURSOR l_price_break
283: IS SELECT poll.price_override
284: FROM po_line_locations poll
285: WHERE price_override is not null
286: AND sysdate between nvl(start_date,sysdate-1)
287: and nvl(end_date,sysdate+1)
288: AND (poll.quantity is null