APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFER_INT

Line 215: FROM pon_bid_price_differ_int bpdi

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

Line 361: DELETE FROM pon_bid_price_differ_int bpdi

357: AND (bli.line_number = g_error_int
358: OR bli.line_number = g_skip_int));
359:
360: -- Delete from price differentials interface table
361: DELETE FROM pon_bid_price_differ_int bpdi
362: WHERE bpdi.batch_id = p_batch_id
363: AND bpdi.interface_line_id in (
364: select bli.interface_line_id
365: from pon_bid_item_prices_interface bli

Line 408: UPDATE pon_bid_price_differ_int bpdi

404:
405: -- Update price differentials' internal line numbers's
406: -- NOTE: we also update line_number for those price differentials with
407: -- valid line_numbers
408: UPDATE pon_bid_price_differ_int bpdi
409: SET bpdi.auction_line_number =
410: (SELECT bli.line_number
411: FROM pon_bid_item_prices_interface bli
412: WHERE bli.batch_id = bpdi.batch_id

Line 891: UPDATE pon_bid_price_differ_int bpdi

887: -- Update sequence_number since it is internal and user specifies
888: -- price differentials by price differential name
889: -- price differentials on lines with differential_response_type
890: -- as DISPLAY_ONLY are marked as skipped so they will get purged
891: UPDATE pon_bid_price_differ_int bpdi
892: SET bpdi.sequence_number =
893: nvl((SELECT decode(al.differential_response_type, 'DISPLAY_ONLY',
894: g_skip_int, bpd.price_differential_number)
895: FROM pon_bid_price_differentials bpd, po_price_diff_lookups_v pdl,

Line 942: FROM pon_bid_price_differ_int bpdi

938: bpdi.auction_header_id,
939: bpdi.bid_number,
940: bpdi.auction_line_number,
941: g_exp_date
942: FROM pon_bid_price_differ_int bpdi
943: WHERE bpdi.batch_id = p_batch_id
944: AND bpdi.sequence_number = g_error_int);
945:
946: -- Delete from price differentials interface table

Line 947: DELETE FROM pon_bid_price_differ_int bpdi

943: WHERE bpdi.batch_id = p_batch_id
944: AND bpdi.sequence_number = g_error_int);
945:
946: -- Delete from price differentials interface table
947: DELETE FROM pon_bid_price_differ_int bpdi
948: WHERE bpdi.batch_id = p_batch_id
949: AND bpdi.sequence_number = g_error_int;
950:
951: END validate_children;

Line 1362: FROM pon_bid_price_differ_int

1358: auction_shipment_number,
1359: sequence_number,
1360: interface_line_id,
1361: multiplier
1362: FROM pon_bid_price_differ_int
1363: WHERE batch_id = p_batch_id
1364: and auction_shipment_number = -1) bpdi
1365: ON (bpd.bid_number = bpdi.bid_number
1366: AND bpd.line_number = bpdi.auction_line_number

Line 1388: from pon_bid_price_differ_int bpdi,

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

Line 1429: FROM pon_bid_price_differ_int

1425: bid_number,
1426: auction_line_number,
1427: sequence_number,
1428: multiplier
1429: FROM pon_bid_price_differ_int
1430: WHERE batch_id = p_batch_id) bpdi
1431: ON (bpd.bid_number = bpdi.bid_number
1432: AND bpd.line_number = bpdi.auction_line_number
1433: AND bpd.shipment_number = -1

Line 1508: DELETE FROM pon_bid_price_differ_int bpdi

1504:
1505: DELETE FROM pon_bid_price_elements_int bpfi
1506: WHERE bpfi.batch_id = p_batch_id;
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;

Line 2369: FROM pon_bid_price_differ_int bpdi

2365: AND bpfi.bid_currency_value IS NOT null))
2366: -- No line / Price Break level price differentials
2367: AND ( NOT EXISTS
2368: (SELECT bpdi.sequence_number
2369: FROM pon_bid_price_differ_int bpdi
2370: WHERE bpdi.batch_id = bli.batch_id
2371: and bpdi.auction_line_number = bli.line_number
2372: --and bpdi.shipment_number = -1
2373: AND bpdi.multiplier IS NOT null))

Line 2455: DELETE FROM pon_bid_price_differ_int bpdi

2451: where bli.batch_id = p_batch_id
2452: AND bli.interface_line_id = g_skip_int);
2453:
2454: -- Delete from price differentials interface table
2455: DELETE FROM pon_bid_price_differ_int bpdi
2456: WHERE bpdi.batch_id = p_batch_id
2457: AND bpdi.auction_line_number in (
2458: select bli.line_number
2459: from pon_bid_item_prices_interface bli