[Home] [Help]
491: SET partial_response_flag = 'Y'
492: WHERE bh.bid_number = p_bidNumber
493: AND (EXISTS (select 'x'
494: from pon_bid_item_prices bl,
495: pon_auction_item_prices_all al
496: where bl.bid_number = bh.bid_number
497: and bl.auction_header_id = al.auction_header_id
498: and bl.line_number = al.line_number
499: and al.group_type <> 'GROUP'
503: and bl.quantity is not null)
504: OR
505: EXISTS (select 'x'
506: from pon_bid_item_prices bl,
507: pon_auction_item_prices_all al
508: where bl.bid_number(+) = bh.bid_number
509: and al.auction_header_id = bh.auction_header_id
510: and bl.auction_header_id(+) = al.auction_header_id
511: and bl.line_number(+) = al.line_number
530: print_log(l_api_name || '.BEGIN', p_bidNumber ||' Begin - update_group_amount');
531: update pon_bid_item_prices bl
532: set group_amount = (select sum(nvl(bl2.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))*bl2.price)
533: from pon_bid_item_prices bl2,
534: pon_auction_item_prices_all al
535: where bl2.auction_header_id = al.auction_header_id
536: and bl2.line_number = al.line_number
537: and bl2.bid_number = bl.bid_number
538: and al.parent_line_number = bl.line_number)
537: and bl2.bid_number = bl.bid_number
538: and al.parent_line_number = bl.line_number)
539: where bl.bid_number = p_bidNumber
540: and (select a2.group_type
541: from pon_auction_item_prices_all a2
542: where a2.auction_header_id = bl.auction_header_id
543: and a2.line_number = bl.line_number) = 'GROUP';
544:
545: print_log(l_api_name || '.END', p_bidNumber ||' End - update_group_amount');
1115: WHERE auction_header_id = p_auctionHeaderId
1116: AND bid_number = p_bidNumber;
1117: --
1118: --
1119: UPDATE pon_auction_item_prices_all
1120: SET best_bid_number = v_nextBid,
1121: lowest_bid_number = decode(lowest_bid_number, null, null,
1122: v_nextBid)
1123: WHERE auction_header_id = p_auctionHeaderId
1122: v_nextBid)
1123: WHERE auction_header_id = p_auctionHeaderId
1124: AND best_bid_number = p_bidNumber;
1125:
1126: UPDATE pon_auction_item_prices_all
1127: SET best_bid_bid_number = v_nextBid
1128: WHERE auction_header_id = p_auctionHeaderId
1129: AND best_bid_bid_number = p_bidNumber;
1130:
1234: AND bid_number = p_bidNum
1235: AND line_number = p_line;
1236:
1237: --
1238: UPDATE pon_auction_item_prices_all
1239: SET best_bid_price = p_price,
1240: best_bid_currency_price = p_bid_curr_price,
1241: lowest_bid_price = decode (lowest_bid_price, null,null,
1242: p_price)
1243: WHERE auction_header_id = p_auctionHeaderId
1244: AND line_number = p_line
1245: AND best_bid_number = p_bidNum;
1246:
1247: UPDATE pon_auction_item_prices_all
1248: SET best_bid_bid_price = p_price,
1249: best_bid_bid_currency_price = p_bid_curr_price
1250: WHERE auction_header_id = p_auctionHeaderId
1251: AND line_number = p_line
1785: WHERE bid_number = p_bidNumber
1786: AND line_number = p_lineNumber;
1787: --
1788: -- if current bid is the winner, reset proxy limit price in item
1789: UPDATE pon_auction_item_prices_all
1790: SET best_bid_proxy_limit_price = best_bid_price
1791: WHERE auction_header_id = p_auctionHeaderId
1792: AND line_number = p_lineNumber
1793: AND best_bid_number = p_bidNumber;
1826: pbip.price,
1827: pbip.proxy_bid_limit_price
1828: FROM
1829: pon_bid_item_prices pbip,
1830: pon_auction_item_prices_all paip,
1831: pon_auction_headers_all paha
1832: WHERE
1833: pbip.bid_number = p_bidNumber
1834: AND paip.auction_header_id = p_auctionHeaderId
2042: -- where we set the publish_date on the lines based on this flag.
2043: SELECT paip.line_number
2044: INTO v_negotiation_closed_line_num
2045: FROM pon_bid_item_prices pbip,
2046: pon_auction_item_prices_all paip,
2047: pon_auction_headers_all paha
2048: WHERE paip.auction_header_id = p_auctionHeaderId
2049: AND pbip.auction_header_id = p_auctionHeaderId
2050: AND paha.auction_header_id = p_auctionHeaderId
2249: IS
2250:
2251: l_api_name CONSTANT VARCHAR2(30) := 'update_disq_lines';
2252:
2253: v_bestBidNumber pon_auction_item_prices_all.lowest_bid_number%TYPE;
2254: v_bestBidBidNumber pon_auction_item_prices_all.best_bid_bid_number%TYPE;
2255:
2256: TYPE t_tbl_number IS TABLE OF NUMBER
2257: INDEX BY PLS_INTEGER;
2250:
2251: l_api_name CONSTANT VARCHAR2(30) := 'update_disq_lines';
2252:
2253: v_bestBidNumber pon_auction_item_prices_all.lowest_bid_number%TYPE;
2254: v_bestBidBidNumber pon_auction_item_prices_all.best_bid_bid_number%TYPE;
2255:
2256: TYPE t_tbl_number IS TABLE OF NUMBER
2257: INDEX BY PLS_INTEGER;
2258:
2288: ORDER BY pbip.line_number;
2289:
2290: CURSOR best_bid_lines_cursor IS
2291: SELECT line_number
2292: FROM pon_auction_item_prices_all
2293: WHERE auction_header_id = p_auctionHeaderId
2294: AND best_bid_number = p_bidNumber
2295: AND line_number >= p_batchStart
2296: AND line_number <= p_batchEnd
2297: ORDER BY line_number;
2298:
2299: CURSOR best_bid_bid_lines_cursor IS
2300: SELECT line_number
2301: FROM pon_auction_item_prices_all
2302: WHERE auction_header_id = p_auctionHeaderId
2303: AND best_bid_bid_number = p_bidNumber
2304: AND line_number >= p_batchStart
2305: AND line_number <= p_batchEnd
2329:
2330: -- Get auction item price information corresponding to this bid item
2331: SELECT best_bid_number
2332: INTO v_bestBidNumber
2333: FROM pon_auction_item_prices_all
2334: WHERE auction_header_id = p_auctionHeaderId
2335: AND line_number = best_bid_item_record.line_number;
2336:
2337: IF (v_bestBidNumber = p_bidNumber) THEN -- {
2402: END LOOP; -- }
2403:
2404: print_log(l_api_name, p_bidNumber || ': updating best bid info with data structs');
2405: FORALL x IN 1..t_line_number.COUNT
2406: UPDATE pon_auction_item_prices_all
2407: SET best_bid_price = t_price(x),
2408: best_bid_quantity = t_quantity(x),
2409: best_bid_promised_date = t_promised_date(x),
2410: best_bid_number = t_bid_number(x),
2431: FOR best_bid_bid_item_record IN best_bid_bid_lines_cursor LOOP
2432:
2433: SELECT best_bid_bid_number
2434: INTO v_bestBidBidNumber
2435: FROM pon_auction_item_prices_all
2436: WHERE auction_header_id = p_auctionHeaderId
2437: AND line_number = best_bid_bid_item_record.line_number;
2438:
2439: IF (v_bestBidBidNumber = p_bidNumber) THEN
2490: END LOOP;
2491:
2492: print_log(l_api_name, p_bidNumber || ': updating best bid bid info with data structs');
2493: FORALL x IN 1..t_line_number.COUNT
2494: UPDATE pon_auction_item_prices_all
2495: SET best_bid_bid_price = t_price(x),
2496: best_bid_score = t_score(x),
2497: best_bid_bid_number = t_bid_number(x),
2498: best_bid_bid_currency_price = t_bid_currency_price(x),
2521: AND bip.line_number = bid_item_record.line_number),
2522: line_number
2523: INTO t_number_of_bids(v_counter),
2524: t_line_number(v_counter)
2525: FROM pon_auction_item_prices_all
2526: WHERE auction_header_id = p_auctionHeaderId
2527: AND line_number = bid_item_record.line_number;
2528:
2529: -- UPDATE RANK FOR BIDS LOWER THAN THE DISQ BID
2550: END LOOP; -- }
2551:
2552: print_log(l_api_name, p_bidNumber || ': for each line, update the numOfBids and rank using structs');
2553: FORALL x IN 1..t_line_number.COUNT
2554: UPDATE pon_auction_item_prices_all
2555: SET number_of_bids = t_number_of_bids(x)
2556: WHERE auction_header_id = p_auctionHeaderId
2557: AND line_number = t_line_number(x);
2558:
3060: l_auc_pf_fixed_amount_formula,
3061: l_auc_pf_percentage_formula
3062: FROM
3063: pon_auction_headers_all auctions,
3064: pon_auction_item_prices_all items,
3065: pon_pf_supplier_formula pf_formula
3066: WHERE
3067: auctions.auction_header_id = p_auction_header_id
3068: AND items.line_number = p_line_number
3302: pbip.price)
3303: -- hack to set bid total to null if at least one line has a quantity of null
3304: + decode(min(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(paip.quantity, -9999))), -9999, NULL, 0) bid_total
3305: FROM pon_bid_item_prices pbip,
3306: pon_auction_item_prices_all paip
3307: WHERE pbip.auction_header_id = pbh.auction_header_id AND
3308: pbip.bid_number = pbh.bid_number AND
3309: pbip.auction_header_id = paip.auction_header_id AND
3310: pbip.line_number = paip.line_number AND
3528: -- extend all lines
3529: IF (p_autoExtendAllLinesFlag ='Y') THEN
3530:
3531: update
3532: pon_auction_item_prices_all
3533: SET
3534: number_of_extensions = nvl(number_of_extensions,0) + 1,
3535: close_bidding_date = close_bidding_date + p_extensionInterval
3536: WHERE
3540: AND line_number <= p_batchEnd;
3541:
3542: ELSE
3543: -- extend only the lines with new bids
3544: UPDATE pon_auction_item_prices_all
3545: SET number_of_extensions = nvl(number_of_extensions, 0) + 1,
3546: close_bidding_date = decode(p_autoExtendTypeFlag, 'FROM_AUCTION_CLOSE_DATE',
3547: nvl(close_bidding_date, p_hdrCloseBiddingDate) + p_hdrExtensionTime,
3548: p_bidPublishDate + p_hdrExtensionTime)
3550: AND line_number IN
3551: (SELECT al.line_number
3552: FROM pon_bid_headers bh,
3553: pon_bid_item_prices bl,
3554: pon_auction_item_prices_all al
3555: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3556: AND bl.bid_number = bh.bid_number
3557: AND al.auction_header_id = bh.auction_header_id
3558: AND bl.line_number = al.line_number
3581:
3582: -- auto extend all group lines which had at least one
3583: -- other line in the group extended
3584:
3585: UPDATE pon_auction_item_prices_all al
3586: SET (number_of_extensions,
3587: close_bidding_date) =
3588: (SELECT max(number_of_extensions),
3589: max(close_bidding_date)
3586: SET (number_of_extensions,
3587: close_bidding_date) =
3588: (SELECT max(number_of_extensions),
3589: max(close_bidding_date)
3590: FROM pon_auction_item_prices_all al2
3591: WHERE al2.auction_header_id = al.auction_header_id
3592: AND nvl(al2.parent_line_number, al2.line_number) =
3593: nvl(al.parent_line_number, al.line_number))
3594: WHERE auction_header_id = p_auctionHeaderId
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3687:
3688: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3689: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;
3690:
3691: v_extensionInterval NUMBER;
3692:
3774: into
3775: v_triggerLineCloseBiddingDate,
3776: v_bidPublishDate
3777: from
3778: pon_auction_item_prices_all a,
3779: pon_bid_item_prices b
3780: where
3781: -- We need to consider every bid generated during this publish - the current bid + all proxy bids
3782: b.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3961: NVL(bestbid.rate,1.0) as best_bid_rate,
3962: NVL(bestbid.number_price_decimals,10) as best_bid_decimals
3963: from pon_bid_headers bestbid,
3964: pon_bid_item_prices biditem,
3965: pon_auction_item_prices_all item
3966: where bestbid.bid_number = item.best_bid_number
3967: and item.auction_header_id = biditem.auction_header_id
3968: and item.line_number = biditem.line_number
3969: and biditem.auction_header_id= p_auctionHeaderId
4193: print_log(l_api_name, p_bidNumber || ': (proxy) we have ' || t_itm_line_number.COUNT || ' lines');
4194:
4195: -- Update pon auction item prices, setting the no of bids and the new proxy limit price
4196: FORALL x IN 1..t_itm_line_number.COUNT
4197: UPDATE pon_auction_item_prices_all
4198: SET number_of_bids = t_itm_number_of_bids(x),
4199: best_bid_proxy_limit_price = t_itm_best_bid_proxy_limit_prc(x)
4200: WHERE auction_header_id = p_auctionHeaderId
4201: AND line_number = t_itm_line_number(x);
4321: l_api_name CONSTANT VARCHAR2(30) := 'update_and_rerank_group_lines';
4322: CURSOR groups_to_be_reranked(v_publish_date DATE) IS
4323: SELECT groupline.line_number
4324: FROM pon_bid_item_prices groupline,
4325: pon_auction_item_prices_all auctionline
4326: WHERE groupline.bid_number = p_bidNumber
4327: AND groupline.publish_date = v_publish_date
4328: AND auctionline.auction_header_id = groupline.auction_header_id
4329: AND auctionline.line_number = groupline.line_number
4406: END IF; -- end if (p_rankIndicator = 'NUMBERING')
4407:
4408: END LOOP;
4409:
4410: -- set the pon_auction_item_prices_all.best_bid* attributes
4411: -- using rank #1 bid
4412: FORALL x in 1..t_itm_bid_number.COUNT
4413: UPDATE pon_auction_item_prices_all
4414: SET best_bid_number = t_itm_bid_number(x),
4409:
4410: -- set the pon_auction_item_prices_all.best_bid* attributes
4411: -- using rank #1 bid
4412: FORALL x in 1..t_itm_bid_number.COUNT
4413: UPDATE pon_auction_item_prices_all
4414: SET best_bid_number = t_itm_bid_number(x),
4415: best_bid_bid_number = decode(p_bidRanking,
4416: 'MULTI_ATTRIBUTE_SCORING',
4417: t_itm_bid_number(x),
4452: SELECT bidline.line_number
4453: FROM pon_bid_item_prices bidline,
4454: pon_bid_headers bidheader,
4455: pon_bid_headers bestbidheader,
4456: pon_auction_item_prices_all auctionline
4457: WHERE auctionline.auction_header_id = bidline.auction_header_id
4458: AND bidline.bid_number = p_bidNumber
4459: AND bidline.line_number = auctionline.line_number
4460: AND bidheader.bid_number = bidline.bid_number
4469: SELECT bidline.line_number
4470: FROM pon_bid_item_prices bidline,
4471: pon_bid_headers bidheader,
4472: pon_bid_headers bestbidheader,
4473: pon_auction_item_prices_all auctionline
4474: WHERE auctionline.auction_header_id = bidline.auction_header_id
4475: AND bidline.bid_number = p_bidNumber
4476: AND bidline.line_number = auctionline.line_number
4477: AND bidheader.bid_number = bidline.bid_number
4574:
4575: END LOOP;
4576:
4577: FORALL x IN 1..t_line_number.COUNT
4578: UPDATE pon_auction_item_prices_all
4579: SET best_bid_price = t_price(x),
4580: best_bid_quantity = t_quantity(x),
4581: best_bid_promised_date = t_promised_date(x),
4582: best_bid_number = t_bid_number(x),
4645:
4646: END LOOP;
4647:
4648: FORALL x IN 1..t_line_number.COUNT
4649: UPDATE pon_auction_item_prices_all
4650: SET best_bid_bid_price = t_price(x),
4651: best_bid_score = t_score(x),
4652: best_bid_bid_number = t_bid_number(x),
4653: best_bid_bid_currency_price = t_bid_currency_price(x),
4676: IS
4677:
4678: BEGIN
4679:
4680: UPDATE pon_auction_item_prices_all auctionline
4681: SET (auctionline.best_bid_number,
4682: auctionline.best_bid_price,
4683: auctionline.best_bid_quantity,
4684: auctionline.best_bid_promised_date,
4725:
4726:
4727: IF (p_bidRanking = 'MULTI_ATTRIBUTE_SCORING') THEN
4728:
4729: UPDATE pon_auction_item_prices_all auctionline
4730: SET (auctionline.best_bid_bid_number,
4731: auctionline.best_bid_bid_price,
4732: auctionline.best_bid_score,
4733: auctionline.best_bid_bid_currency_price,
4795: bidline.total_weighted_score,
4796: bidline.proxy_bid_flag,
4797: NVL(oldBidline.rank, DEAD_LAST) as old_rank
4798: FROM pon_bid_item_prices bidline,
4799: pon_auction_item_prices_all auctionline,
4800: pon_bid_item_prices oldBidline
4801: WHERE bidline.bid_number = p_bidNumber
4802: AND bidline.publish_date = v_publish_date
4803: AND auctionline.auction_header_id = bidline.auction_header_id
4930: p_batchEnd IN NUMBER)
4931: IS
4932: BEGIN
4933:
4934: UPDATE pon_auction_item_prices_all
4935: SET best_bid_number = p_bidNumber
4936: WHERE auction_header_id = p_auctionHeaderId
4937: AND best_bid_number = p_oldBidNumber
4938: AND line_number >= p_batchStart
4937: AND best_bid_number = p_oldBidNumber
4938: AND line_number >= p_batchStart
4939: AND line_number <= p_batchEnd;
4940:
4941: UPDATE pon_auction_item_prices_all
4942: SET best_bid_bid_number = p_bidNumber
4943: WHERE auction_header_id = p_auctionHeaderId
4944: AND best_bid_bid_number = p_oldBidNumber
4945: AND line_number >= p_batchStart
4959: BEGIN
4960:
4961: -- UPDATE GROUPS
4962: -- applies to lines: GROUP lines that were affected by this bid
4963: -- action performed: (1) re-set best_bid* attributes in pon_auction_item_prices_all
4964: -- (2) if ranking is NUMBERING, rerank all bids for each GROUP
4965: update_and_rerank_group_lines(p_auctionHeaderId, p_bidNumber, p_publishDate,
4966: p_rankIndicator, p_bidRanking, p_discard_tech_nonshort);
4967:
5032: update_old_best_bid_number(p_auctionHeaderId, p_oldBidNumber, p_bidNumber, p_batchStart, p_batchEnd);
5033:
5034: -- 4) UPDATE NUMBER_OF_BIDS
5035: -- for all lines on which this bid has a new bid on, we must
5036: -- increment the pon_auction_item_prices_all.number_of_bids
5037: -- by 1.
5038: UPDATE pon_auction_item_prices_all
5039: SET number_of_bids = nvl(number_of_bids,0) + 1
5040: WHERE auction_header_id = p_auctionHeaderId
5034: -- 4) UPDATE NUMBER_OF_BIDS
5035: -- for all lines on which this bid has a new bid on, we must
5036: -- increment the pon_auction_item_prices_all.number_of_bids
5037: -- by 1.
5038: UPDATE pon_auction_item_prices_all
5039: SET number_of_bids = nvl(number_of_bids,0) + 1
5040: WHERE auction_header_id = p_auctionHeaderId
5041: AND line_number IN (SELECT line_number
5042: FROM pon_bid_item_prices
5147: -- This procedure performs two tasks:
5148: --
5149: -- 1) UPDATE GROUPS
5150: -- applies to lines: GROUP lines that were affected by this bid
5151: -- action performed: (1) re-set best_bid* attributes in pon_auction_item_prices_all
5152: -- (2) if ranking is NUMBERING, rerank all bids for each GROUP
5153: -- 2) UPDATE WORSENED LINES
5154: -- applies to lines: non-GROUP lines where this supplier user previously held the
5155: -- best bid, but on this bid, he worsened his bid.
5177: -- action performed: reranks all the bids for each of these lines
5178: --
5179: -- 3) UPDATE NUMBER_OF_BIDS
5180: -- for all lines on which this bid has a new bid on, we must
5181: -- increment the pon_auction_item_prices_all.number_of_bids
5182: -- by 1.
5183: print_log(l_api_name, p_bidNumber || ' - do batched part second');
5184: IF (v_batchingRequired) THEN
5185: update_batched_part_batch(p_auctionHeaderId, p_bidNumber, v_publishDate,
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5232: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5233: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5234: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5235: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5236: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5237: v_publishDate DATE;
5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5232: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5233: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5234: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5235: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5236: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5237: v_publishDate DATE;
5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5542: print_log(l_api_name, p_bidNumber || ' - updating aution_item_prices by replacing old_bid_number with bid_number in best_bid_number');
5543:
5544: -- (woojin) may need to add batching here
5545:
5546: UPDATE pon_auction_item_prices_all
5547: SET best_bid_number = p_bidNumber
5548: WHERE auction_header_id = p_auctionHeaderId
5549: AND best_bid_number = v_oldBidNumber;
5550:
5547: SET best_bid_number = p_bidNumber
5548: WHERE auction_header_id = p_auctionHeaderId
5549: AND best_bid_number = v_oldBidNumber;
5550:
5551: UPDATE pon_auction_item_prices_all
5552: SET best_bid_bid_number = p_bidNumber
5553: WHERE auction_header_id = p_auctionHeaderId
5554: AND best_bid_bid_number = v_oldBidNumber;
5555:
5576: SELECT max(close_bidding_date),
5577: max(number_of_extensions)
5578: INTO v_max_close_bidding_date,
5579: v_max_num_of_extensions
5580: FROM pon_auction_item_prices_all al
5581: WHERE al.auction_header_id = p_auctionHeaderId;
5582:
5583: IF (v_max_close_bidding_date IS NOT NULL AND
5584: v_max_num_of_extensions IS NOT NULL) THEN
5648: v_closeBiddingDateH := v_closeBiddingDate_old;
5649:
5650: select max(close_bidding_date)
5651: into v_closeBiddingDateH
5652: from pon_auction_item_prices_all
5653: where auction_header_id = p_auctionHeaderId;
5654:
5655: -- we need to update all the deliverables
5656: -- if and only if this bid has caused auto-extension
5813: nvl(aip.quantity, 1)
5814: )
5815: INTO l_auc_pf_unit_price
5816: FROM pon_pf_supplier_formula ppsf,
5817: pon_auction_item_prices_all aip,
5818: pon_bid_headers pbh
5819: WHERE ppsf.auction_header_id = p_auction_header_id
5820: AND ppsf.line_number = p_line_number
5821: AND ppsf.trading_partner_id = pbh.trading_partner_id
5851: )
5852: ,0)
5853: INTO l_bid_line_pf_unit_price
5854: FROM pon_bid_price_elements spf,
5855: pon_auction_item_prices_all aip
5856: WHERE spf.bid_number = p_prev_auc_active_bid_number
5857: AND spf.line_number = p_line_number
5858: AND spf.sequence_number <> -10
5859: AND spf.pf_type = 'SUPPLIER'
5926: -- line.
5927: -- 3. If there is atleast one bid then check to see if this is the
5928: -- best bid for this line.
5929: -- 4. If this is the best bid then ignoring this bid line find out
5930: -- the best bid for this line and update pon_auction_item_prices_all
5931: -- 5. If this is not the best bid then proceed to next step.
5932: -- 6. Re-order all the bid lines (ranks) ignoring the bids that have
5933: -- not been shortlisted.
5934: --========================================================================
5946:
5947: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
5948:
5949: v_bid_number pon_bid_headers.bid_number%TYPE;
5950: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
5951: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
5953: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
5954: t_price pon_bid_item_prices.price%TYPE;
5947: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
5948:
5949: v_bid_number pon_bid_headers.bid_number%TYPE;
5950: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
5951: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
5953: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
5954: t_price pon_bid_item_prices.price%TYPE;
5955: t_quantity pon_bid_item_prices.quantity%TYPE;
5949: v_bid_number pon_bid_headers.bid_number%TYPE;
5950: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
5951: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
5953: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
5954: t_price pon_bid_item_prices.price%TYPE;
5955: t_quantity pon_bid_item_prices.quantity%TYPE;
5956: t_promised_date pon_bid_item_prices.promised_date%TYPE;
5957: t_bid_number pon_bid_item_prices.bid_number%TYPE;
5965: v_rank_bulk PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
5966:
5967: CURSOR all_lines_cursor IS
5968: SELECT line_number
5969: FROM pon_auction_item_prices_all
5970: WHERE auction_header_id = p_auction_header_id
5971: AND line_number >= p_batch_start
5972: AND line_number <= p_batch_end
5973: ORDER BY line_number;
6037: v_best_bid_number,
6038: v_best_bid_bid_number,
6039: v_currentline_group_type
6040: FROM
6041: pon_auction_item_prices_all paip
6042: WHERE
6043: paip.auction_header_id = p_auction_header_id
6044: AND paip.line_number = auction_item_record.line_number;
6045:
6200: || 'just best_bid_number and best_bid_bid_number');
6201: END IF; --}
6202:
6203: UPDATE
6204: pon_auction_item_prices_all
6205: SET
6206: best_bid_number = t_bid_number
6207: WHERE
6208: auction_header_id = p_auction_header_id
6216: message => 'This is not a GROUP line.');
6217: END IF; --}
6218:
6219: UPDATE
6220: pon_auction_item_prices_all
6221: SET
6222: best_bid_price = t_price,
6223: best_bid_quantity = t_quantity,
6224: best_bid_promised_date = t_promised_date,
6235:
6236: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6237: FND_LOG.string(log_level => FND_LOG.level_statement,
6238: module => g_module_prefix || l_module_name,
6239: message => 'Updated pon_auction_item_prices_all');
6240: END IF; --}
6241:
6242: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6243:
6249:
6250: IF (v_currentline_group_type = 'GROUP') THEN -- {
6251:
6252: UPDATE
6253: pon_auction_item_prices_all
6254: SET
6255: best_bid_bid_number = decode (p_bid_ranking,
6256: 'MULTI_ATTRIBUTE_SCORING', t_bid_number,
6257: null)
6315: t_bid_currency_code);
6316: END IF; --}
6317:
6318: UPDATE
6319: pon_auction_item_prices_all
6320: SET
6321: best_bid_bid_price = t_price,
6322: best_bid_score = t_score,
6323: best_bid_bid_number = t_bid_number,
6329:
6330: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6331: FND_LOG.string(log_level => FND_LOG.level_statement,
6332: module => g_module_prefix || l_module_name,
6333: message => 'Updated pon_auction_item_prices_all');
6334: END IF; --}
6335:
6336: END IF; -- }
6337: