APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_SHIPMENTS_INT

Line 1511: DELETE FROM pon_bid_shipments_int bshi

1507:
1508: DELETE FROM pon_bid_price_differ_int bpdi
1509: WHERE bpdi.batch_id = p_batch_id;
1510:
1511: DELETE FROM pon_bid_shipments_int bshi
1512: WHERE bshi.batch_id = p_batch_id;
1513:
1514: END copy_interface_to_txn_tables;
1515:

Line 2176: pon_bid_shipments_int bshi

2172: bipi.worksheet_sequence_number s_worksheet_seq_num,
2173: 'PON_AUCTS_PRICE_BREAKS' s_entity_name
2174: from
2175: pon_bid_item_prices_interface bipi,
2176: pon_bid_shipments_int bshi
2177: where bshi.batch_id = p_batch_id
2178: and bshi.bid_number = p_bid_number
2179: and bshi.action in (g_pb_required, g_pb_optional, g_pb_new)
2180: and bshi.batch_id = bipi.batch_id

Line 2384: FROM pon_bid_shipments_int bshi

2380: -- Thus, when determine skipped line, do not consider those that are intended to be deleted.
2381: -- For Price Tier, only consider Price, Price Discount is always null.
2382: AND ( NOT EXISTS
2383: (SELECT bshi.line_number
2384: FROM pon_bid_shipments_int bshi
2385: WHERE bshi.batch_id = bli.batch_id
2386: and bshi.line_number = bli.line_number
2387: and bshi.action in ( g_pb_required, g_pb_optional, g_pb_new )
2388: and (bshi.bid_currency_unit_price IS NOT null

Line 2464: DELETE FROM pon_bid_shipments_int bshi

2460: where bli.batch_id = p_batch_id
2461: AND bli.interface_line_id = g_skip_int);
2462:
2463: -- Delete from price breaks / price tiers interface table
2464: DELETE FROM pon_bid_shipments_int bshi
2465: WHERE bshi.batch_id = p_batch_id
2466: AND bshi.line_number in (
2467: select bli.line_number
2468: from pon_bid_item_prices_interface bli

Line 2921: update pon_bid_shipments_int bshi

2917: BEGIN
2918:
2919: --1. Populate Bid_shipment_number in Price Break Interface table
2920: -- Pupulate bid_shipment_number for those that were unknown ( fresh bid when there is no draft case ).
2921: update pon_bid_shipments_int bshi
2922: set bid_shipment_number =
2923: NVL( (select bsh.shipment_number
2924: from pon_bid_shipments bsh
2925: where bsh.bid_number = bshi.bid_number

Line 2958: FROM pon_bid_shipments_int bsi,

2954: bsi.price_type,
2955: bsi.price_discount,
2956: bsi.bid_currency_unit_price,
2957: bip.bid_currency_unit_price item_price
2958: FROM pon_bid_shipments_int bsi,
2959: pon_bid_item_prices bip
2960: WHERE bsi.batch_id = p_batch_id
2961: and bsi.bid_number = p_bid_number
2962: and bsi.bid_number = bip.bid_number

Line 3159: from pon_bid_shipments_int bsi

3155: where bsh.bid_number = p_bid_number
3156: and exists
3157: (
3158: select 1
3159: from pon_bid_shipments_int bsi
3160: where bsi.batch_id= p_batch_id
3161: and bsi.bid_number = P_BID_NUMBER
3162: and bsi.action = g_pb_delete
3163: and bsi.bid_number = bsh.bid_number

Line 3175: pon_bid_shipments_int bsi

3171: --5 Mark Supplier owned Price Break
3172: -- 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
3173: -- Notes, if need to use g_pb_optionals_updated flag to determine skipped line, move this part before determin_xml_skipped_line
3174: update
3175: pon_bid_shipments_int bsi
3176: set bsi.action= g_pb_optional_updated
3177: where bsi.batch_id = p_batch_id
3178: and bsi.BID_NUMBER = p_bid_number
3179: and bsi.action = g_pb_optional

Line 3211: pon_bid_shipments_int bshi

3207: where bsh.bid_number = p_bid_number
3208: and exists
3209: ( select 1
3210: from
3211: pon_bid_shipments_int bshi
3212: where bshi.batch_id = p_batch_id
3213: and bshi.bid_number = p_bid_number
3214: and bshi.action = g_pb_optional_updated
3215: and bshi.auction_header_id = bsh.auction_header_id