APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_SHIPMENTS

Line 191: INSERT INTO pon_bid_shipments

187: ** exists" clause doesn't cause data corruption.
188: *************************************************************/
189:
190: -- Insert missing shipments for all non-negotiable shipments
191: INSERT INTO pon_bid_shipments
192: (
193: BID_NUMBER,
194: LINE_NUMBER,
195: SHIPMENT_NUMBER,

Line 579: INSERT INTO pon_bid_shipments

575: * Price Tiers Enhancements
576: * Quantity tiers are negotiable shipments so no need to copy the max_quantity field here
577: */
578:
579: INSERT INTO pon_bid_shipments
580: (
581: BID_NUMBER,
582: LINE_NUMBER,
583: SHIPMENT_NUMBER,

Line 631: FROM pon_bid_shipments pbs

627: AND aip.line_number = apb.line_number
628: AND nvl(aip.price_break_neg_flag, 'Y') = 'N'
629: AND NOT EXISTS
630: (SELECT pbs.auction_shipment_number
631: FROM pon_bid_shipments pbs
632: WHERE pbs.bid_number = p_bid_number
633: AND pbs.line_number = apb.line_number
634: AND pbs.auction_shipment_number = apb.shipment_number));
635:

Line 757: UPDATE pon_bid_shipments bpb

753: AND bpf.pf_type = 'SUPPLIER'
754: AND bpf.line_number BETWEEN p_batch_start AND p_batch_end;
755:
756: -- Update price break old value columns
757: UPDATE pon_bid_shipments bpb
758: SET (bpb.old_bid_currency_unit_price,
759: bpb.old_bid_currency_price,
760: bpb.old_price_discount,
761: bpb.old_ship_to_org_id,

Line 779: FROM pon_bid_shipments old_bpb

775: old_bpb.effective_end_date,
776: old_bpb.quantity,
777: old_bpb.max_quantity,
778: old_bpb.price_type
779: FROM pon_bid_shipments old_bpb
780: WHERE old_bpb.bid_number = p_source_bid_num
781: AND old_bpb.line_number = bpb.line_number
782: AND old_bpb.shipment_number = bpb.shipment_number)
783: WHERE bpb.bid_number = p_bid_number

Line 2095: INSERT INTO pon_bid_shipments

2091: BEGIN
2092:
2093: -- Get all auction side price breaks for modified lines that had a bid
2094: -- or for unmodified lines that had no bid
2095: INSERT INTO pon_bid_shipments
2096: (
2097: BID_NUMBER,
2098: LINE_NUMBER,
2099: SHIPMENT_NUMBER,

Line 2160: INSERT INTO pon_bid_shipments

2156: AND bl.has_bid_flag = 'N'
2157: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
2158:
2159: -- Get only-bid-side price breaks for unmodified lines
2160: INSERT INTO pon_bid_shipments
2161: (
2162: BID_NUMBER,
2163: LINE_NUMBER,
2164: SHIPMENT_NUMBER,

Line 2234: FROM pon_bid_shipments bpb,

2230: decode(p_rebid_flag, 'Y', bpb.effective_end_date, null), -- OLD_EFFECTIVE_END_DATE
2231: decode(p_rebid_flag, 'Y', bpb.quantity, null), -- OLD_QUANTITY
2232: decode(p_rebid_flag, 'Y', bpb.max_quantity, null), -- OLD_MAX_QUANTITY
2233: decode(p_rebid_flag, 'Y', bpb.price_type, null) -- OLD_PRICE_TYPE
2234: FROM pon_bid_shipments bpb,
2235: pon_bid_item_prices bl
2236: WHERE bpb.bid_number = p_source_bid_num
2237: AND bl.bid_number = p_bid_number
2238: AND bl.line_number = bpb.line_number

Line 2334: pon_bid_shipments bpb,

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
2338: AND bl.bid_number = p_bid_number

Line 2800: FROM pon_bid_shipments bs

2796: OR EXISTS
2797:
2798: -- Check shipments
2799: (SELECT bs.line_number
2800: FROM pon_bid_shipments bs
2801: WHERE bs.bid_number = bl.bid_number
2802: AND bs.line_number = bl.line_number
2803: AND (bs.auction_shipment_number IS null
2804: OR bs.price_type = 'PRICE' AND bs.bid_currency_unit_price IS NOT null