APPS.PON_AUCTION_HEADERS_PKG dependencies on PON_BID_SHIPMENTS

Line 121: print_log (l_api_name, 'Done updating pon_bid_item_prices, now updating pon_bid_shipments');

117: WHERE
118: pbip.bid_number = p_bid_number;
119: END IF;
120:
121: print_log (l_api_name, 'Done updating pon_bid_item_prices, now updating pon_bid_shipments');
122:
123: IF (p_price_tiers_indicator = 'QUANTITY_BASED') THEN
124: UPDATE
125: pon_bid_shipments pbs

Line 125: pon_bid_shipments pbs

121: print_log (l_api_name, 'Done updating pon_bid_item_prices, now updating pon_bid_shipments');
122:
123: IF (p_price_tiers_indicator = 'QUANTITY_BASED') THEN
124: UPDATE
125: pon_bid_shipments pbs
126: SET
127: pbs.per_unit_price_component = pbs.unit_price +
128: nvl((
129: SELECT SUM(DECODE(pbpe.pricing_basis,

Line 2848: FROM pon_bid_shipments pbs

2844: x_price NUMBER := NULL;
2845:
2846: CURSOR break_price IS
2847: SELECT pbs.unit_price
2848: FROM pon_bid_shipments pbs
2849: WHERE pbs.shipment_type = 'PRICE BREAK'
2850: AND pbs.bid_number = p_bid_number
2851: AND pbs.line_number = p_line_number
2852: AND nvl(pbs.quantity, 0) <= nvl(p_quantity, 0)

Line 2901: FROM pon_bid_shipments pbs

2897: x_price NUMBER := NULL;
2898:
2899: CURSOR break_price IS
2900: SELECT pbs.price
2901: FROM pon_bid_shipments pbs
2902: WHERE pbs.shipment_type = 'PRICE BREAK'
2903: AND pbs.bid_number = p_bid_number
2904: AND pbs.line_number = p_line_number
2905: AND nvl(pbs.quantity, 0) <= nvl(p_quantity, 0)