DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_PRICE_DIFFERENTIALS

Line 2249: FROM pon_price_differentials

2245: BEGIN
2246: -- Find the max price_diff_line number for this line and save it
2247: SELECT NVL(MAX(price_differential_number),0)+1
2248: INTO p_price_differential_number
2249: FROM pon_price_differentials
2250: WHERE auction_header_id = p_document_number
2251: AND line_number = p_line_number
2252: AND shipment_number = p_shipment_number;
2253: IF (p_document_number IS NULL) THEN

Line 2279: INTO pon_price_differentials

2275: RETURN;
2276: END IF;
2277: v_debug_status := 'INSERT_PRICE_DIFFERENTIALS';
2278: INSERT
2279: INTO pon_price_differentials
2280: (
2281: auction_header_id,
2282: line_number,
2283: shipment_number,