DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on PON_PRICE_DIFFERENTIALS

Line 1433: FROM pon_price_differentials

1429:
1430: -- Find the max price_diff_line number for this line and save it
1431: SELECT nvl(max(price_differential_number),0)+1
1432: INTO p_price_differential_number
1433: FROM pon_price_differentials
1434: WHERE auction_header_id = p_document_number AND
1435: line_number = p_line_number AND
1436: shipment_number = p_shipment_number;
1437:

Line 1469: INSERT INTO pon_price_differentials

1465:
1466:
1467: v_debug_status := 'INSERT_PRICE_DIFFERENTIALS';
1468:
1469: INSERT INTO pon_price_differentials
1470: (
1471: auction_header_id,
1472: line_number,
1473: shipment_number,