APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_BID_ITEM_PRICES

Line 98: FROM pon_bid_item_prices pbip,

94: /*SELECT 'N'
95: INTO v_has_est_qty_on_all_bid_lines
96: FROM dual
97: WHERE EXISTS (SELECT null
98: FROM pon_bid_item_prices pbip,
99: pon_auction_item_prices_all paip
100: WHERE pbip.auction_header_id = p_auction_header_id AND
101: pbip.bid_number = p_bid_number AND
102: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 116: FROM pon_bid_item_prices pbip,

112: SELECT 'N'
113: INTO v_has_est_qty_on_all_bid_lines
114: FROM dual
115: WHERE EXISTS ((SELECT null
116: FROM pon_bid_item_prices pbip,
117: pon_auction_item_prices_all paip
118: WHERE pbip.auction_header_id = p_auction_header_id AND
119: pbip.bid_number = p_bid_number AND
120: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 128: FROM pon_bid_item_prices pbip1

124: paip.order_type_lookup_code <> 'FIXED PRICE' AND
125: paip.quantity is null)
126: UNION
127: (SELECT null
128: FROM pon_bid_item_prices pbip1
129: WHERE pbip1.auction_header_id = p_auction_header_id AND
130: pbip1.bid_number = p_bid_number AND
131: pbip1.auction_line_number = -1 AND
132: nvl(pbip1.has_bid_flag, 'N') = 'Y' AND

Line 156: FROM PON_BID_ITEM_PRICES pbip

152: --Fix for bug 13565622 - To handle unsol lines with out quantity in case of BPA
153: SELECT sum(pbip.quantity * pbip.price)
154: + decode(Min(nvl(pbip.quantity, -9999)), -9999, NULL, 0)
155: into v_unsol_line_total
156: FROM PON_BID_ITEM_PRICES pbip
157: WHERE
158: pbip.bid_number = p_bid_number and
159: pbip.auction_line_number = -1 and
160: nvl(pbip.clm_info_flag,'N') <> 'Y';

Line 200: FROM pon_bid_item_prices pbip,

196: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
197: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
198: nvl(pbip.price,0)) bid_total
199: INTO v_bid_total
200: FROM pon_bid_item_prices pbip,
201: pon_auction_item_prices_all paip
202: WHERE pbip.auction_header_id = p_auction_header_id AND
203: pbip.bid_number = p_bid_number AND
204: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 216: FROM pon_bid_item_prices pbip,

212: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
213: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
214: paip.quantity, p_tpid, p_site),0)) bid_total
215: INTO v_bid_total
216: FROM pon_bid_item_prices pbip,
217: pon_auction_item_prices_all paip
218: WHERE pbip.auction_header_id = p_auction_header_id AND
219: pbip.bid_number = p_bid_number AND
220: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 232: FROM pon_bid_item_prices

228:
229: --IF v_bid_total is not null then
230: BEGIN
231: SELECT count(*) INTO v_unsol_line_count
232: FROM pon_bid_item_prices
233: WHERE bid_number = p_bid_number
234: AND auction_line_number = -1
235: AND Nvl(clm_info_flag, 'N') = 'N'
236: AND Nvl(clm_cost_constraint, 'X') NOT IN ('NSP', 'NC');

Line 545: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

541:
542: SELECT DECODE (al.group_type, 'GROUP', bl.group_amount,
543: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity)) * bl.price)
544: INTO v_quote_amount
545: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
546: WHERE bl.bid_number = p_bid_number
547: AND bl.line_number = p_line_number
548: AND bl.auction_header_id = al.auction_header_id
549: AND bl.line_number = al.line_number;

Line 565: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

561: nvl(bl.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))
562: * nvl(PON_TRANSFORM_BIDDING_PKG.untransform_one_price(p_auction_header_id,
563: bl.line_number, bl.price, al.quantity, p_tpid, p_site), 0)
564: INTO v_quote_amount
565: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
566: WHERE bl.bid_number = p_bid_number
567: AND bl.line_number = p_line_number
568: AND al.auction_header_id = bl.auction_header_id
569: AND al.line_number = bl.line_number;

Line 875: FROM pon_bid_item_prices pbip,

871: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,
872: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
873: nvl(pbip.price,0)) bid_total
874: INTO v_bid_total
875: FROM pon_bid_item_prices pbip,
876: pon_auction_item_prices_all paip
877: WHERE pbip.auction_header_id = p_auction_header_id AND
878: pbip.bid_number = p_bid_number AND
879: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 897: FROM pon_bid_item_prices pbip,

893: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
894: nvl(untransform_one_price(paip.auction_header_id, paip.line_number, pbip.price,
895: paip.quantity, p_tpid, p_site),0)) bid_total
896: INTO v_bid_total
897: FROM pon_bid_item_prices pbip,
898: pon_auction_item_prices_all paip
899: WHERE pbip.auction_header_id = p_auction_header_id AND
900: pbip.bid_number = p_bid_number AND
901: nvl(pbip.has_bid_flag, 'N') = 'Y' AND

Line 915: FROM pon_bid_item_prices

911: -- Unsolicited Lines Project : Calculate unsolicited lines total.
912: --IF v_bid_total is not null then
913: BEGIN
914: SELECT count(*) INTO v_unsol_line_count
915: FROM pon_bid_item_prices
916: WHERE bid_number = p_bid_number
917: AND auction_line_number = -1
918: AND Nvl(clm_info_flag, 'N') = 'N'
919: AND Nvl(clm_cost_constraint, 'X') NOT IN ('NSP', 'NC');

Line 966: FROM PON_BID_ITEM_PRICES pbip

962: v_unsol_line_total NUMBER;
963: BEGIN
964: SELECT SUM(nvl(pbip.quantity,0) * nvl(pbip.price,0))
965: into v_unsol_line_total
966: FROM PON_BID_ITEM_PRICES pbip
967: WHERE
968: pbip.bid_number = p_bid_number and
969: pbip.auction_line_number <> -1 and
970: nvl(pbip.clm_info_flag,'N') <> 'Y';

Line 989: FROM pon_bid_item_prices

985: BEGIN
986:
987: SELECT Sum(Nvl(quantity, 0) * Nvl(price, 0))
988: INTO v_unawarded_bid_total
989: FROM pon_bid_item_prices
990: WHERE auction_header_id = p_auction_header_id
991: AND bid_number = p_bid_number
992: AND auction_line_number IN (SELECT line_number
993: FROM pon_auction_item_prices_all