APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFER_INT

Line 213: FROM pon_bid_price_differ_int bpdi

209: -- No price differentials
210: AND (al.has_price_differentials_flag = 'N'
211: OR NOT EXISTS
212: (SELECT bpdi.sequence_number
213: FROM pon_bid_price_differ_int bpdi
214: WHERE bpdi.batch_id = bli.batch_id
215: AND bpdi.auction_line_number = bli.line_number
216: AND bpdi.multiplier IS NOT null))
217: -- No attributes

Line 334: DELETE FROM pon_bid_price_differ_int bpdi

330: AND (bli.line_number = g_error_int
331: OR bli.line_number = g_skip_int));
332:
333: -- Delete from price differentials interface table
334: DELETE FROM pon_bid_price_differ_int bpdi
335: WHERE bpdi.batch_id = p_batch_id
336: AND bpdi.interface_line_id in (
337: select bli.interface_line_id
338: from pon_bid_item_prices_interface bli

Line 381: UPDATE pon_bid_price_differ_int bpdi

377:
378: -- Update price differentials' internal line numbers's
379: -- NOTE: we also update line_number for those price differentials with
380: -- valid line_numbers
381: UPDATE pon_bid_price_differ_int bpdi
382: SET bpdi.auction_line_number =
383: (SELECT bli.line_number
384: FROM pon_bid_item_prices_interface bli
385: WHERE bli.batch_id = bpdi.batch_id

Line 814: UPDATE pon_bid_price_differ_int bpdi

810: -- Update sequence_number since it is internal and user specifies
811: -- price differentials by price differential name
812: -- price differentials on lines with differential_response_type
813: -- as DISPLAY_ONLY are marked as skipped so they will get purged
814: UPDATE pon_bid_price_differ_int bpdi
815: SET bpdi.sequence_number =
816: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
817: g_skip_int, bpd.price_differential_number)
818: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,

Line 865: FROM pon_bid_price_differ_int bpdi

861: bpdi.auction_header_id,
862: bpdi.bid_number,
863: bpdi.auction_line_number,
864: g_exp_date
865: FROM pon_bid_price_differ_int bpdi
866: WHERE bpdi.batch_id = p_batch_id
867: AND bpdi.sequence_number = g_error_int);
868:
869: -- Delete from price differentials interface table

Line 870: DELETE FROM pon_bid_price_differ_int bpdi

866: WHERE bpdi.batch_id = p_batch_id
867: AND bpdi.sequence_number = g_error_int);
868:
869: -- Delete from price differentials interface table
870: DELETE FROM pon_bid_price_differ_int bpdi
871: WHERE bpdi.batch_id = p_batch_id
872: AND bpdi.sequence_number = g_error_int;
873:
874: END validate_children;

Line 1163: FROM pon_bid_price_differ_int

1159: auction_shipment_number,
1160: sequence_number,
1161: interface_line_id,
1162: multiplier
1163: FROM pon_bid_price_differ_int
1164: WHERE batch_id = p_batch_id
1165: and auction_shipment_number = -1) bpdi
1166: ON (bpd.bid_number = bpdi.bid_number
1167: AND bpd.line_number = bpdi.auction_line_number

Line 1189: from pon_bid_price_differ_int bpdi,

1185: bsh.shipment_number,
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

Line 1230: FROM pon_bid_price_differ_int

1226: bid_number,
1227: auction_line_number,
1228: sequence_number,
1229: multiplier
1230: FROM pon_bid_price_differ_int
1231: WHERE batch_id = p_batch_id) bpdi
1232: ON (bpd.bid_number = bpdi.bid_number
1233: AND bpd.line_number = bpdi.auction_line_number
1234: AND bpd.shipment_number = -1

Line 1309: DELETE FROM pon_bid_price_differ_int bpdi

1305:
1306: DELETE FROM pon_bid_price_elements_int bpfi
1307: WHERE bpfi.batch_id = p_batch_id;
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;

Line 2156: FROM pon_bid_price_differ_int bpdi

2152: AND bpfi.bid_currency_value IS NOT null))
2153: -- No line / Price Break level price differentials
2154: AND ( NOT EXISTS
2155: (SELECT bpdi.sequence_number
2156: FROM pon_bid_price_differ_int bpdi
2157: WHERE bpdi.batch_id = bli.batch_id
2158: and bpdi.auction_line_number = bli.line_number
2159: --and bpdi.shipment_number = -1
2160: AND bpdi.multiplier IS NOT null))

Line 2242: DELETE FROM pon_bid_price_differ_int bpdi

2238: where bli.batch_id = p_batch_id
2239: AND bli.interface_line_id = g_skip_int);
2240:
2241: -- Delete from price differentials interface table
2242: DELETE FROM pon_bid_price_differ_int bpdi
2243: WHERE bpdi.batch_id = p_batch_id
2244: AND bpdi.auction_line_number in (
2245: select bli.line_number
2246: from pon_bid_item_prices_interface bli