APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_SHIPMENTS_INT

Line 1312: DELETE FROM pon_bid_shipments_int bshi

1308:
1309: DELETE FROM pon_bid_price_differ_int bpdi
1310: WHERE bpdi.batch_id = p_batch_id;
1311:
1312: DELETE FROM pon_bid_shipments_int bshi
1313: WHERE bshi.batch_id = p_batch_id;
1314:
1315: END copy_interface_to_txn_tables;
1316:

Line 1963: pon_bid_shipments_int bshi

1959: bipi.worksheet_sequence_number s_worksheet_seq_num,
1960: 'PON_AUCTS_PRICE_BREAKS' s_entity_name
1961: from
1962: pon_bid_item_prices_interface bipi,
1963: pon_bid_shipments_int bshi
1964: where bshi.batch_id = p_batch_id
1965: and bshi.bid_number = p_bid_number
1966: and bshi.action in (g_pb_required, g_pb_optional, g_pb_new)
1967: and bshi.batch_id = bipi.batch_id

Line 2171: FROM pon_bid_shipments_int bshi

2167: -- Thus, when determine skipped line, do not consider those that are intended to be deleted.
2168: -- For Price Tier, only consider Price, Price Discount is always null.
2169: AND ( NOT EXISTS
2170: (SELECT bshi.line_number
2171: FROM pon_bid_shipments_int bshi
2172: WHERE bshi.batch_id = bli.batch_id
2173: and bshi.line_number = bli.line_number
2174: and bshi.action in ( g_pb_required, g_pb_optional, g_pb_new )
2175: and (bshi.bid_currency_unit_price IS NOT null

Line 2251: DELETE FROM pon_bid_shipments_int bshi

2247: where bli.batch_id = p_batch_id
2248: AND bli.interface_line_id = g_skip_int);
2249:
2250: -- Delete from price breaks / price tiers interface table
2251: DELETE FROM pon_bid_shipments_int bshi
2252: WHERE bshi.batch_id = p_batch_id
2253: AND bshi.line_number in (
2254: select bli.line_number
2255: from pon_bid_item_prices_interface bli

Line 2708: update pon_bid_shipments_int bshi

2704: BEGIN
2705:
2706: --1. Populate Bid_shipment_number in Price Break Interface table
2707: -- Pupulate bid_shipment_number for those that were unknown ( fresh bid when there is no draft case ).
2708: update pon_bid_shipments_int bshi
2709: set bid_shipment_number =
2710: NVL( (select bsh.shipment_number
2711: from pon_bid_shipments bsh
2712: where bsh.bid_number = bshi.bid_number

Line 2745: FROM pon_bid_shipments_int bsi,

2741: bsi.price_type,
2742: bsi.price_discount,
2743: bsi.bid_currency_unit_price,
2744: bip.bid_currency_unit_price item_price
2745: FROM pon_bid_shipments_int bsi,
2746: pon_bid_item_prices bip
2747: WHERE bsi.batch_id = p_batch_id
2748: and bsi.bid_number = p_bid_number
2749: and bsi.bid_number = bip.bid_number

Line 2946: from pon_bid_shipments_int bsi

2942: where bsh.bid_number = p_bid_number
2943: and exists
2944: (
2945: select 1
2946: from pon_bid_shipments_int bsi
2947: where bsi.batch_id= p_batch_id
2948: and bsi.bid_number = P_BID_NUMBER
2949: and bsi.action = g_pb_delete
2950: and bsi.bid_number = bsh.bid_number

Line 2962: pon_bid_shipments_int bsi

2958: --5 Mark Supplier owned Price Break
2959: -- 5.1 Mark Supplier owned Price Break set auction_shipment_number="" and has_price_differentials_flag='N' by comparing the 5 columns in PON_BID_SHIPMENTS with PON_AUCTION_SHIPMENTS_ALL
2960: -- Notes, if need to use g_pb_optionals_updated flag to determine skipped line, move this part before determin_xml_skipped_line
2961: update
2962: pon_bid_shipments_int bsi
2963: set bsi.action= g_pb_optional_updated
2964: where bsi.batch_id = p_batch_id
2965: and bsi.BID_NUMBER = p_bid_number
2966: and bsi.action = g_pb_optional

Line 2998: pon_bid_shipments_int bshi

2994: where bsh.bid_number = p_bid_number
2995: and exists
2996: ( select 1
2997: from
2998: pon_bid_shipments_int bshi
2999: where bshi.batch_id = p_batch_id
3000: and bshi.bid_number = p_bid_number
3001: and bshi.action = g_pb_optional_updated
3002: and bshi.auction_header_id = bsh.auction_header_id