APPS.PON_RESPONSE_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 78: v_line_close_bidding_date pon_auction_item_prices_all.close_bidding_date%TYPE;

74: p_is_paused IN pon_auction_headers_all.is_paused%TYPE,
75: p_pause_date IN pon_auction_headers_all.last_pause_date%TYPE)
76: RETURN DATE
77: IS
78: v_line_close_bidding_date pon_auction_item_prices_all.close_bidding_date%TYPE;
79: l_api_name CONSTANT VARCHAR2(30) := 'get_line_close_bidding_date';
80:
81: BEGIN
82:

Line 85: FROM pon_auction_item_prices_all a

81: BEGIN
82:
83: SELECT a.close_bidding_date
84: INTO v_line_close_bidding_date
85: FROM pon_auction_item_prices_all a
86: WHERE a.auction_header_id = p_auction_header_id
87: AND a.line_number = p_line_number;
88:
89: IF p_is_paused = 'Y' AND v_line_close_bidding_date > p_pause_date THEN

Line 171: pon_auction_item_prices_all a1

167: decode(v_contract_type,
168: 'STANDARD', p2.quantity,
169: nvl(p2.quantity, a1.quantity))))
170: FROM pon_bid_item_prices p2,
171: pon_auction_item_prices_all a1
172: WHERE p2.bid_number = p_bid_number
173: AND a1.auction_header_id = p2.auction_header_id
174: AND p2.line_number = a1.line_number
175: AND a1.parent_line_number = p1.line_number)

Line 180: FROM pon_auction_item_prices_all a2

176: WHERE p1.bid_number = p_bid_number
177: AND (p_do_all_lines = 'Y'
178: OR p1.batch_id = p_batch_id)
179: AND (SELECT a2.group_type
180: FROM pon_auction_item_prices_all a2
181: WHERE a2.auction_header_id = p1.auction_header_id
182: AND a2.line_number = p1.line_number) = 'GROUP';
183:
184: IF ((g_fnd_debug = 'Y') AND (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)) THEN

Line 249: pon_auction_item_prices_all auc_line

245: nvl(group_line.quantity, auc_line.quantity))))
246: INTO p_group_amount
247: FROM pon_bid_item_prices groups,
248: pon_bid_item_prices group_line,
249: pon_auction_item_prices_all auc_line
250: WHERE groups.bid_number = p_bid_number
251: AND group_line.bid_number = groups.bid_number
252: AND groups.line_number = p_line_number
253: AND group_line.auction_header_id = auc_line.auction_header_id

Line 355: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

351: OR v_surrog_bid_flag = 'Y')
352: AND pbip.copy_price_for_proxy_flag = 'N'
353: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
354: AND pbip.line_number IN (SELECT line_number
355: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
356: PON_AUCTION_HEADERS_ALL pah
357: WHERE pah.auction_header_id = paip.auction_header_id
358: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
359: AND paip.auction_header_id = pbip.auction_header_id

Line 387: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

383: AND ((get_line_close_bidding_date(pbip.auction_header_id, pbip.line_number, v_is_paused, v_paused_date) > sysdate) OR (v_surrog_bid_flag = 'Y'))
384: AND pbip.copy_price_for_proxy_flag = 'N')
385: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
386: AND pbs.line_number IN (SELECT line_number
387: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
388: PON_AUCTION_HEADERS_ALL pah
389: WHERE pah.auction_header_id = paip.auction_header_id
390: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
391: AND paip.auction_header_id = pbs.auction_header_id

Line 411: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

407: AND ((get_line_close_bidding_date(pbip.auction_header_id, pbip.line_number, v_is_paused, v_paused_date) > sysdate) OR (v_surrog_bid_flag = 'Y'))
408: AND pbip.copy_price_for_proxy_flag = 'N')
409: AND ((nvl(p_powerbidlosinglines,'N') = 'Y'
410: AND pbs.line_number IN (SELECT line_number
411: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
412: PON_AUCTION_HEADERS_ALL pah
413: WHERE pah.auction_header_id = paip.auction_header_id
414: AND DECODE(pah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING',paip.best_bid_bid_number,paip.best_bid_number) <> p_previous_bid_number
415: AND paip.auction_header_id = pbs.auction_header_id

Line 607: pon_auction_item_prices_all aip

603: 'Y', nvl(pbip.quantity, 1),
604: nvl(aip.quantity, 1)))
605: FROM pon_pf_supplier_formula ppsf,
606: pon_bid_headers pbh,
607: pon_auction_item_prices_all aip
608: WHERE ppsf.auction_header_id = pbip.auction_header_id
609: AND ppsf.line_number = pbip.line_number
610: AND pbip.bid_number = pbh.bid_number
611: AND ppsf.trading_partner_id = pbh.trading_partner_id

Line 642: pon_auction_item_prices_all aip

638: 'Y', nvl(pbip.quantity, 1),
639: nvl(aip.quantity, 1)))))),
640: 0)
641: FROM pon_bid_price_elements spf,
642: pon_auction_item_prices_all aip
643: WHERE spf.bid_number = p_bid_number
644: AND spf.line_number = pbip.line_number
645: AND spf.sequence_number <> -10
646: AND aip.auction_header_id = spf.auction_header_id

Line 713: FROM pon_auction_item_prices_all paip

709: decode(v_max_rtng_negotiable, 'Y',
710: decode( pbip.max_retainage_amount-paip.max_retainage_amount, 0, pbip.max_retainage_amount,pbip.bid_curr_max_retainage_amt/v_rate),
711: pbip.max_retainage_amount
712: ), pbip.max_retainage_amount)
713: FROM pon_auction_item_prices_all paip
714: WHERE paip.auction_header_id=pbip.auction_header_id
715: AND paip.line_number=pbip.line_number)
716: WHERE pbip.bid_number = p_bid_number
717: -- process only batch, or all lines if currency change

Line 763: pon_auction_item_prices_all aip,

759: 'Y', nvl(pbip.quantity, 1),
760: nvl(aip.quantity, 1)))
761: FROM pon_pf_supplier_formula ppsf,
762: pon_bid_headers pbh,
763: pon_auction_item_prices_all aip,
764: pon_bid_item_prices pbip
765: WHERE pbip.bid_number = pbs.bid_number
766: AND pbip.line_number = pbs.line_number
767: AND ppsf.auction_header_id = pbip.auction_header_id

Line 792: pon_auction_item_prices_all aip,

788: 'Y', nvl(pbip.quantity, 1),
789: nvl(aip.quantity, 1))))),
790: 0)
791: FROM pon_bid_price_elements spf,
792: pon_auction_item_prices_all aip,
793: pon_bid_item_prices pbip
794: WHERE pbip.bid_number = pbs.bid_number
795: AND pbip.line_number = pbs.line_number
796: AND spf.bid_number = p_bid_number