APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 641: INSERT INTO pon_bid_price_differentials

637: ** STEP 8: Insert all the missing line-level as well as shipment
638: ** level price breaks in a single insert statement.
639: *************************************************************/
640:
641: INSERT INTO pon_bid_price_differentials
642: (
643: AUCTION_HEADER_ID,
644: BID_NUMBER,
645: LINE_NUMBER,

Line 672: FROM pon_bid_price_differentials pbpd

668: WHERE apd.auction_header_id = p_auc_header_id
669: AND apd.line_number BETWEEN p_batch_start AND p_batch_end
670: AND NOT EXISTS
671: (SELECT pbpd.price_differential_number
672: FROM pon_bid_price_differentials pbpd
673: WHERE pbpd.bid_number = p_bid_number
674: AND pbpd.line_number = apd.line_number
675: AND pbpd.price_differential_number = apd.price_differential_number));
676:

Line 787: UPDATE pon_bid_price_differentials bpd

783: WHERE bpb.bid_number = p_bid_number
784: AND bpb.line_number BETWEEN p_batch_start AND p_batch_end;
785:
786: -- Update price differential old value columns
787: UPDATE pon_bid_price_differentials bpd
788: SET bpd.old_multiplier =
789: (SELECT old_bpd.multiplier
790: FROM pon_bid_price_differentials old_bpd
791: WHERE old_bpd.bid_number = p_source_bid_num

Line 790: FROM pon_bid_price_differentials old_bpd

786: -- Update price differential old value columns
787: UPDATE pon_bid_price_differentials bpd
788: SET bpd.old_multiplier =
789: (SELECT old_bpd.multiplier
790: FROM pon_bid_price_differentials old_bpd
791: WHERE old_bpd.bid_number = p_source_bid_num
792: AND old_bpd.line_number = bpd.line_number
793: AND old_bpd.shipment_number = bpd.shipment_number
794: AND old_bpd.price_differential_number = bpd.price_differential_number)

Line 2268: INSERT INTO pon_bid_price_differentials

2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2265: ) IS
2266: BEGIN
2267:
2268: INSERT INTO pon_bid_price_differentials
2269: (
2270: AUCTION_HEADER_ID,
2271: BID_NUMBER,
2272: LINE_NUMBER,

Line 2301: pon_bid_price_differentials bpd,

2297: p_userid, -- LAST_UPDATED_BY
2298: null, -- LAST_UPDATE_LOGIN
2299: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2300: FROM pon_price_differentials apd,
2301: pon_bid_price_differentials bpd,
2302: pon_bid_item_prices bl
2303: WHERE apd.auction_header_id = p_auc_header_id
2304: AND apd.shipment_number = -1 -- only line level differentials
2305: AND bl.auction_header_id = apd.auction_header_id

Line 2333: pon_bid_price_differentials bpd,

2329: p_userid, -- LAST_UPDATED_BY
2330: null, -- LAST_UPDATE_LOGIN
2331: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2332: FROM pon_price_differentials apd,
2333: pon_bid_price_differentials bpd,
2334: pon_bid_shipments bpb,
2335: pon_bid_item_prices bl
2336: WHERE apd.auction_header_id = p_auc_header_id
2337: AND apd.shipment_number <> -1 -- only shipment differentials

Line 2813: FROM pon_bid_price_differentials bpd

2809: OR EXISTS
2810:
2811: -- Check price differentials, including shipment price differentials
2812: (SELECT bpd.line_number
2813: FROM pon_bid_price_differentials bpd
2814: WHERE bpd.bid_number = bl.bid_number
2815: AND bpd.line_number = bl.line_number
2816: AND bpd.multiplier IS NOT null
2817: AND rownum = 1)