APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

233: sysdate, -- LAST_UPDATE_DATE
234: p_userid, -- LAST_UPDATED_BY
235: null, -- LAST_UPDATE_LOGIN
236: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
238: WHERE apb.auction_header_id = p_auc_header_id
239: AND aip.auction_header_id = apb.auction_header_id
240: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
241: AND aip.line_number = apb.line_number

Line 351: FROM pon_auction_item_prices_all al

347: 'N', -- HAS_BID_FLAG
348: 'N', -- HAS_BID_PAYMENTS_FLAG
349: al.bid_start_price, -- BID_START_PRICE
350: al.has_quantity_tiers -- HAS_QUANTITY_TIERS
351: FROM pon_auction_item_prices_all al
352: WHERE al.auction_header_id = p_auc_header_id
353: AND al.line_number BETWEEN p_batch_start AND p_batch_end
354: AND NOT EXISTS
355: (SELECT bl.line_number

Line 371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

367: WHERE bl.bid_number = p_bid_number
368: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
369: AND EXISTS
370: (SELECT le.line_number
371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
372: WHERE al.auction_header_id = p_auc_header_id
373: AND al.line_number = bl.line_number
374: AND le.auction_header_id = al.auction_header_id
375: AND le.line_number = nvl(al.parent_line_number, al.line_number)

Line 619: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

615: sysdate, -- LAST_UPDATE_DATE
616: p_userid, -- LAST_UPDATED_BY
617: null, -- LAST_UPDATE_LOGIN
618: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
619: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
620: WHERE apb.auction_header_id = p_auc_header_id
621: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
622: AND aip.auction_header_id = apb.auction_header_id
623: AND aip.line_number = apb.line_number

Line 1404: FROM pon_auction_item_prices_all al,

1400: decode(sign(bl.proxy_bid_limit_price-bl.price), -1, 'Y', 'N'), 'N'), -- COPY_PRICE_FOR_PROXY_FLAG
1401: al.bid_start_price,
1402: decode(al.modified_date-old_al.modified_date,
1403: 0, bl.has_quantity_tiers, al.has_quantity_tiers) -- HAS_quantity_tiers
1404: FROM pon_auction_item_prices_all al,
1405: pon_auction_item_prices_all old_al,
1406: pon_bid_item_prices bl
1407: WHERE al.auction_header_id = p_auc_header_id
1408: AND bl.bid_number(+) = p_source_bid_num

Line 1405: pon_auction_item_prices_all old_al,

1401: al.bid_start_price,
1402: decode(al.modified_date-old_al.modified_date,
1403: 0, bl.has_quantity_tiers, al.has_quantity_tiers) -- HAS_quantity_tiers
1404: FROM pon_auction_item_prices_all al,
1405: pon_auction_item_prices_all old_al,
1406: pon_bid_item_prices bl
1407: WHERE al.auction_header_id = p_auc_header_id
1408: AND bl.bid_number(+) = p_source_bid_num
1409: AND bl.line_number(+) = al.line_number

Line 1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1

1430: -- update the bid_start_price for the current bid lines
1431: -- using values from the previous round auction/bid
1432: UPDATE pon_bid_item_prices bl
1433: SET bid_start_price = nvl((SELECT pon_bid_defaulting_pkg.apply_price_factors(p_auc_header_id, l_prev_rnd_active_bid_number, al.line_number, bl1.unit_price, bl1.quantity)
1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1
1435: WHERE al.auction_header_id = l_auction_header_id_prev_round
1436: AND al.line_number = bl.line_number
1437: AND al.line_number = bl1.line_number
1438: AND bl1.bid_number = l_prev_rnd_active_bid_number), bid_start_price)

Line 1457: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

1453: WHERE bl.bid_number = p_bid_number
1454: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1455: AND EXISTS
1456: (SELECT le.line_number
1457: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
1458: WHERE al.auction_header_id = p_auc_header_id
1459: AND al.line_number = bl.line_number
1460: AND le.auction_header_id = al.auction_header_id
1461: AND le.line_number = nvl(al.parent_line_number, al.line_number)

Line 1489: FROM pon_auction_item_prices_all al

1485: DELETE FROM pon_bid_item_prices bl
1486: WHERE bl.bid_number = p_bid_number
1487: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1488: AND EXISTS (SELECT al.line_number
1489: FROM pon_auction_item_prices_all al
1490: WHERE al.auction_header_id = p_auc_header_id
1491: AND al.line_number = bl.line_number
1492: AND al.close_bidding_date < l_closed_compare_date);
1493: END IF;

Line 2531: FROM pon_auction_item_prices_all al

2527: OR EXISTS
2528:
2529: -- Check auction side to check quantity
2530: (SELECT al.line_number
2531: FROM pon_auction_item_prices_all al
2532: WHERE al.auction_header_id = bl.auction_header_id
2533: AND al.line_number = bl.line_number
2534: AND (l_full_qty_reqd <> 'Y'
2535: AND al.order_type_lookup_code <> 'AMOUNT'

Line 4458: FROM PON_AUCTION_ITEM_PRICES_ALL pai,

4454: SELECT 'Y'
4455: INTO x_can_create_payments
4456: FROM dual
4457: WHERE EXISTS (SELECT 1
4458: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
4459: PON_BID_ITEM_PRICES pbi,
4460: PON_AUCTION_HEADERS_ALL pah
4461: WHERE pai.auction_header_id = p_auction_header_id
4462: AND pai.group_type NOT IN ('GROUP','LOT_LINE')

Line 4562: pon_auction_item_prices_all aip,

4558: nvl(aip.quantity, 1)
4559: )
4560: INTO l_auc_pf_unit_price
4561: FROM pon_pf_supplier_formula ppsf,
4562: pon_auction_item_prices_all aip,
4563: pon_bid_headers pbh
4564: WHERE ppsf.auction_header_id = p_auction_header_id
4565: AND ppsf.line_number = p_line_number
4566: AND ppsf.trading_partner_id = pbh.trading_partner_id

Line 4596: pon_auction_item_prices_all aip

4592: )
4593: ,0)
4594: INTO l_bid_line_pf_unit_price
4595: FROM pon_bid_price_elements spf,
4596: pon_auction_item_prices_all aip
4597: WHERE spf.bid_number = p_prev_auc_active_bid_number
4598: AND spf.line_number = p_line_number
4599: AND spf.sequence_number <> -10
4600: AND spf.pf_type = 'SUPPLIER'