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

1186: bpdi.sequence_number,
1187: bpdi.interface_line_id ,
1188: bpdi.multiplier
1189: from pon_bid_price_differ_int bpdi,
1190: pon_bid_shipments bsh
1191: where bpdi.batch_id = p_batch_id
1192: and bpdi.auction_header_id = bsh.auction_header_id
1193: and bpdi.bid_number = bsh.bid_number
1194: and bpdi.auction_line_number = bsh.line_number

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

1925: WORKSHEET_SEQUENCE_NUMBER,
1926: ENTITY_MESSAGE_CODE)
1927: VALUES
1928: (l_interface_type,
1929: 'PON_BID_SHIPMENTS',
1930: fnd_message.get_string('PON', 'PON_BID_PRICE_OR_DISCOUNT'),
1931: p_batch_id,
1932: s_interface_line_id,
1933: 'PON_FIELD_MUST_BE_ENTERED',

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

2681: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
2682: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2683: p_userid IN pon_bid_item_prices.last_updated_by%TYPE,
2684: p_bid_currency_precision IN pon_bid_headers.number_price_decimals%TYPE,
2685: p_shipment_type IN pon_bid_shipments.shipment_type%TYPE
2686: )
2687: is
2688: l_module CONSTANT VARCHAR2(32) := 'copy_shipment_interface_to_txn';
2689: l_line_number_col PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;

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

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
2713: and bsh.line_number = bshi.line_number
2714: and bsh.auction_shipment_number = bshi.auction_shipment_number),
2715: bid_shipment_number)

Line 2724: MERGE INTO pon_bid_shipments bsh

2720:
2721: --2. Update Price Break / Price Tier Transaction based on bid_shipment_number
2722: --Notes. The calculation between bid_currency_unit_price and Discount relies on the line's bid_currency_unit_price,
2723: --thus this merge should happened after line entity has updated bid_currency_unit_price.
2724: MERGE INTO pon_bid_shipments bsh
2725: USING
2726: (SELECT
2727: bsi.action,
2728: bsi.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 2941: delete from pon_bid_shipments bsh

2937: bshi.action = g_pb_new;
2938:
2939:
2940: --4. Delete data from transaction table for those Price Breaks that are flagged to be deleted based on
2941: delete from pon_bid_shipments bsh
2942: where bsh.bid_number = p_bid_number
2943: and exists
2944: (
2945: select 1

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

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

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

2987: );
2988:
2989: -- 5.2 Update shipment transaction table for supplier owned shipments.
2990: update
2991: pon_bid_shipments bsh
2992: set bsh.auction_shipment_number = null,
2993: bsh.has_price_differentials_flag = 'N'
2994: where bsh.bid_number = p_bid_number
2995: and exists

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

Line 3025: from pon_bid_shipments bsh,pon_bid_item_prices bip

3021: (bsd.bid_number, bsd.line_number, bsd.shipment_number)
3022: not in
3023: (
3024: select bsh.bid_number, bsh.line_number, bsh.shipment_number
3025: from pon_bid_shipments bsh,pon_bid_item_prices bip
3026: where bip.batch_id = p_batch_id
3027: and bip.bid_number = p_bid_number
3028: and bip.bid_number = bsh.bid_number
3029: and bip.line_number = bsh.line_number