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 575: INSERT INTO pon_bid_shipments

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

Line 627: FROM pon_bid_shipments pbs

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

Line 753: UPDATE pon_bid_shipments bpb

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

Line 775: FROM pon_bid_shipments old_bpb

771: old_bpb.effective_end_date,
772: old_bpb.quantity,
773: old_bpb.max_quantity,
774: old_bpb.price_type
775: FROM pon_bid_shipments old_bpb
776: WHERE old_bpb.bid_number = p_source_bid_num
777: AND old_bpb.line_number = bpb.line_number
778: AND old_bpb.shipment_number = bpb.shipment_number)
779: WHERE bpb.bid_number = p_bid_number

Line 1859: INSERT INTO pon_bid_shipments

1855: BEGIN
1856:
1857: -- Get all auction side price breaks for modified lines that had a bid
1858: -- or for unmodified lines that had no bid
1859: INSERT INTO pon_bid_shipments
1860: (
1861: BID_NUMBER,
1862: LINE_NUMBER,
1863: SHIPMENT_NUMBER,

Line 1924: INSERT INTO pon_bid_shipments

1920: AND bl.has_bid_flag = 'N'
1921: AND bl.line_number BETWEEN p_batch_start AND p_batch_end);
1922:
1923: -- Get only-bid-side price breaks for unmodified lines
1924: INSERT INTO pon_bid_shipments
1925: (
1926: BID_NUMBER,
1927: LINE_NUMBER,
1928: SHIPMENT_NUMBER,

Line 1998: FROM pon_bid_shipments bpb,

1994: decode(p_rebid_flag, 'Y', bpb.effective_end_date, null), -- OLD_EFFECTIVE_END_DATE
1995: decode(p_rebid_flag, 'Y', bpb.quantity, null), -- OLD_QUANTITY
1996: decode(p_rebid_flag, 'Y', bpb.max_quantity, null), -- OLD_MAX_QUANTITY
1997: decode(p_rebid_flag, 'Y', bpb.price_type, null) -- OLD_PRICE_TYPE
1998: FROM pon_bid_shipments bpb,
1999: pon_bid_item_prices bl
2000: WHERE bpb.bid_number = p_source_bid_num
2001: AND bl.bid_number = p_bid_number
2002: AND bl.line_number = bpb.line_number

Line 2098: pon_bid_shipments bpb,

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

Line 2564: FROM pon_bid_shipments bs

2560: OR EXISTS
2561:
2562: -- Check shipments
2563: (SELECT bs.line_number
2564: FROM pon_bid_shipments bs
2565: WHERE bs.bid_number = bl.bid_number
2566: AND bs.line_number = bl.line_number
2567: AND (bs.auction_shipment_number IS null
2568: OR bs.price_type = 'PRICE' AND bs.bid_currency_unit_price IS NOT null