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 2923: FROM pon_bid_shipments pbs

2919: x_price NUMBER := NULL;
2920:
2921: CURSOR break_price IS
2922: SELECT pbs.unit_price
2923: FROM pon_bid_shipments pbs
2924: WHERE pbs.shipment_type = 'PRICE BREAK'
2925: AND pbs.bid_number = p_bid_number
2926: AND pbs.line_number = p_line_number
2927: AND nvl(pbs.quantity, 0) <= nvl(p_quantity, 0)

Line 2976: FROM pon_bid_shipments pbs

2972: x_price NUMBER := NULL;
2973:
2974: CURSOR break_price IS
2975: SELECT pbs.price
2976: FROM pon_bid_shipments pbs
2977: WHERE pbs.shipment_type = 'PRICE BREAK'
2978: AND pbs.bid_number = p_bid_number
2979: AND pbs.line_number = p_line_number
2980: AND nvl(pbs.quantity, 0) <= nvl(p_quantity, 0)