eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_SHIPMENTS

Line 1389: pon_bid_shipments bsh

1385: bpdi.sequence_number,
1386: bpdi.interface_line_id ,
1387: bpdi.multiplier
1388: from pon_bid_price_differ_int bpdi,
1389: pon_bid_shipments bsh
1390: where bpdi.batch_id = p_batch_id
1391: and bpdi.auction_header_id = bsh.auction_header_id
1392: and bpdi.bid_number = bsh.bid_number
1393: and bpdi.auction_line_number = bsh.line_number

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 2142: 'PON_BID_SHIPMENTS',

2138: WORKSHEET_SEQUENCE_NUMBER,
2139: ENTITY_MESSAGE_CODE)
2140: VALUES
2141: (l_interface_type,
2142: 'PON_BID_SHIPMENTS',
2143: fnd_message.get_string('PON', 'PON_BID_PRICE_OR_DISCOUNT'),
2144: p_batch_id,
2145: s_interface_line_id,
2146: 'PON_FIELD_MUST_BE_ENTERED',

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 2898: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE

2894: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2895: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2896: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2897: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2898: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2899: )
2900: is
2901: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2902: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

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 2924: from pon_bid_shipments bsh

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
2926: and bsh.line_number = bshi.line_number
2927: and bsh.auction_shipment_number = bshi.auction_shipment_number),
2928: bid_shipment_number)

Line 2937: MERGE INTO pon_bid_shipments bsh

2933:
2934: --2. Update Price Break / Price Tier Transaction based on bid_shipment_number
2935: --Notes. The calculation between bid_currency_unit_price and Discount relies on the line's bid_currency_unit_price,
2936: --thus this merge should happened after line entity has updated bid_currency_unit_price.
2937: MERGE INTO pon_bid_shipments bsh
2938: USING
2939: (SELECT
2940: bsi.action,
2941: bsi.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 3154: delete from pon_bid_shipments bsh

3150: bshi.action = g_pb_new;
3151:
3152:
3153: --4. Delete data from transaction table for those Price Breaks that are flagged to be deleted based on
3154: delete from pon_bid_shipments bsh
3155: where bsh.bid_number = p_bid_number
3156: and exists
3157: (
3158: select 1

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 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

3168: --Step 5 and 6 are only for price break.
3169: IF (p_shipment_type = g_shipment_type_pricebreak) THEN
3170:
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

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 3204: pon_bid_shipments bsh

3200: );
3201:
3202: -- 5.2 Update shipment transaction table for supplier owned shipments.
3203: update
3204: pon_bid_shipments bsh
3205: set bsh.auction_shipment_number = null,
3206: bsh.has_price_differentials_flag = 'N'
3207: where bsh.bid_number = p_bid_number
3208: and exists

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

Line 3238: from pon_bid_shipments bsh,pon_bid_item_prices bip

3234: (bsd.bid_number, bsd.line_number, bsd.shipment_number)
3235: not in
3236: (
3237: select bsh.bid_number, bsh.line_number, bsh.shipment_number
3238: from pon_bid_shipments bsh,pon_bid_item_prices bip
3239: where bip.batch_id = p_batch_id
3240: and bip.bid_number = p_bid_number
3241: and bip.bid_number = bsh.bid_number
3242: and bip.line_number = bsh.line_number