APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 637: INSERT INTO pon_bid_price_differentials

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

Line 668: FROM pon_bid_price_differentials pbpd

664: WHERE apd.auction_header_id = p_auc_header_id
665: AND apd.line_number BETWEEN p_batch_start AND p_batch_end
666: AND NOT EXISTS
667: (SELECT pbpd.price_differential_number
668: FROM pon_bid_price_differentials pbpd
669: WHERE pbpd.bid_number = p_bid_number
670: AND pbpd.line_number = apd.line_number
671: AND pbpd.price_differential_number = apd.price_differential_number));
672:

Line 783: UPDATE pon_bid_price_differentials bpd

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

Line 786: FROM pon_bid_price_differentials old_bpd

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

Line 2032: INSERT INTO pon_bid_price_differentials

2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2029: ) IS
2030: BEGIN
2031:
2032: INSERT INTO pon_bid_price_differentials
2033: (
2034: AUCTION_HEADER_ID,
2035: BID_NUMBER,
2036: LINE_NUMBER,

Line 2065: pon_bid_price_differentials bpd,

2061: p_userid, -- LAST_UPDATED_BY
2062: null, -- LAST_UPDATE_LOGIN
2063: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2064: FROM pon_price_differentials apd,
2065: pon_bid_price_differentials bpd,
2066: pon_bid_item_prices bl
2067: WHERE apd.auction_header_id = p_auc_header_id
2068: AND apd.shipment_number = -1 -- only line level differentials
2069: AND bl.auction_header_id = apd.auction_header_id

Line 2097: pon_bid_price_differentials bpd,

2093: p_userid, -- LAST_UPDATED_BY
2094: null, -- LAST_UPDATE_LOGIN
2095: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2096: FROM pon_price_differentials apd,
2097: pon_bid_price_differentials bpd,
2098: pon_bid_shipments bpb,
2099: pon_bid_item_prices bl
2100: WHERE apd.auction_header_id = p_auc_header_id
2101: AND apd.shipment_number <> -1 -- only shipment differentials

Line 2577: FROM pon_bid_price_differentials bpd

2573: OR EXISTS
2574:
2575: -- Check price differentials, including shipment price differentials
2576: (SELECT bpd.line_number
2577: FROM pon_bid_price_differentials bpd
2578: WHERE bpd.bid_number = bl.bid_number
2579: AND bpd.line_number = bl.line_number
2580: AND bpd.multiplier IS NOT null
2581: AND rownum = 1)