[Home] [Help]
510: SET partial_response_flag = 'Y'
511: WHERE bh.bid_number = p_bidNumber
512: AND (EXISTS (select 'x'
513: from pon_bid_item_prices bl,
514: pon_auction_item_prices_all al
515: where bl.bid_number = bh.bid_number
516: and bl.auction_header_id = al.auction_header_id
517: and bl.line_number = al.line_number
518: and al.group_type <> 'GROUP'
523: and Nvl(al.clm_info_flag,'N') <> 'Y') -- bug#9745944
524: OR
525: EXISTS (select 'x'
526: from pon_bid_item_prices bl,
527: pon_auction_item_prices_all al
528: where bl.bid_number(+) = bh.bid_number
529: and al.auction_header_id = bh.auction_header_id
530: and bl.auction_header_id(+) = al.auction_header_id
531: and bl.line_number(+) = al.line_number
551: print_log(l_api_name || '.BEGIN', p_bidNumber ||' Begin - update_group_amount');
552: update pon_bid_item_prices bl
553: set group_amount = (select sum(nvl(bl2.quantity, decode(al.ORDER_TYPE_LOOKUP_CODE, 'FIXED PRICE', 1, al.quantity))*bl2.price)
554: from pon_bid_item_prices bl2,
555: pon_auction_item_prices_all al
556: where bl2.auction_header_id = al.auction_header_id
557: and bl2.line_number = al.line_number
558: and bl2.bid_number = bl.bid_number
559: and al.parent_line_number = bl.line_number)
558: and bl2.bid_number = bl.bid_number
559: and al.parent_line_number = bl.line_number)
560: where bl.bid_number = p_bidNumber
561: and (select a2.group_type
562: from pon_auction_item_prices_all a2
563: where a2.auction_header_id = bl.auction_header_id
564: and a2.line_number = bl.line_number) = 'GROUP';
565:
566: print_log(l_api_name || '.END', p_bidNumber ||' End - update_group_amount');
1138: WHERE auction_header_id = p_auctionHeaderId
1139: AND bid_number = p_bidNumber;
1140: --
1141: --
1142: UPDATE pon_auction_item_prices_all
1143: SET best_bid_number = v_nextBid,
1144: lowest_bid_number = decode(lowest_bid_number, null, null,
1145: v_nextBid)
1146: WHERE auction_header_id = p_auctionHeaderId
1145: v_nextBid)
1146: WHERE auction_header_id = p_auctionHeaderId
1147: AND best_bid_number = p_bidNumber;
1148:
1149: UPDATE pon_auction_item_prices_all
1150: SET best_bid_bid_number = v_nextBid
1151: WHERE auction_header_id = p_auctionHeaderId
1152: AND best_bid_bid_number = p_bidNumber;
1153:
1257: AND bid_number = p_bidNum
1258: AND line_number = p_line;
1259:
1260: --
1261: UPDATE pon_auction_item_prices_all
1262: SET best_bid_price = p_price,
1263: best_bid_currency_price = p_bid_curr_price,
1264: lowest_bid_price = decode (lowest_bid_price, null,null,
1265: p_price)
1266: WHERE auction_header_id = p_auctionHeaderId
1267: AND line_number = p_line
1268: AND best_bid_number = p_bidNum;
1269:
1270: UPDATE pon_auction_item_prices_all
1271: SET best_bid_bid_price = p_price,
1272: best_bid_bid_currency_price = p_bid_curr_price
1273: WHERE auction_header_id = p_auctionHeaderId
1274: AND line_number = p_line
1842: WHERE bid_number = p_bidNumber
1843: AND line_number = p_lineNumber;
1844: --
1845: -- if current bid is the winner, reset proxy limit price in item
1846: UPDATE pon_auction_item_prices_all
1847: SET best_bid_proxy_limit_price = best_bid_price
1848: WHERE auction_header_id = p_auctionHeaderId
1849: AND line_number = p_lineNumber
1850: AND best_bid_number = p_bidNumber;
1883: pbip.price,
1884: pbip.proxy_bid_limit_price
1885: FROM
1886: pon_bid_item_prices pbip,
1887: pon_auction_item_prices_all paip,
1888: pon_auction_headers_all paha
1889: WHERE
1890: pbip.bid_number = p_bidNumber
1891: AND paip.auction_header_id = p_auctionHeaderId
2103: -- where we set the publish_date on the lines based on this flag.
2104: SELECT paip.line_number
2105: INTO v_negotiation_closed_line_num
2106: FROM pon_bid_item_prices pbip,
2107: pon_auction_item_prices_all paip,
2108: pon_auction_headers_all paha
2109: WHERE paip.auction_header_id = p_auctionHeaderId
2110: AND pbip.auction_header_id = p_auctionHeaderId
2111: AND paha.auction_header_id = p_auctionHeaderId
2320: IS
2321:
2322: l_api_name CONSTANT VARCHAR2(30) := 'update_disq_lines';
2323:
2324: v_bestBidNumber pon_auction_item_prices_all.lowest_bid_number%TYPE;
2325: v_bestBidBidNumber pon_auction_item_prices_all.best_bid_bid_number%TYPE;
2326:
2327: TYPE t_tbl_number IS TABLE OF NUMBER
2328: INDEX BY PLS_INTEGER;
2321:
2322: l_api_name CONSTANT VARCHAR2(30) := 'update_disq_lines';
2323:
2324: v_bestBidNumber pon_auction_item_prices_all.lowest_bid_number%TYPE;
2325: v_bestBidBidNumber pon_auction_item_prices_all.best_bid_bid_number%TYPE;
2326:
2327: TYPE t_tbl_number IS TABLE OF NUMBER
2328: INDEX BY PLS_INTEGER;
2329:
2359: ORDER BY pbip.line_number;
2360:
2361: CURSOR best_bid_lines_cursor IS
2362: SELECT line_number
2363: FROM pon_auction_item_prices_all
2364: WHERE auction_header_id = p_auctionHeaderId
2365: AND best_bid_number = p_bidNumber
2366: AND line_number >= p_batchStart
2367: AND line_number <= p_batchEnd
2368: ORDER BY line_number;
2369:
2370: CURSOR best_bid_bid_lines_cursor IS
2371: SELECT line_number
2372: FROM pon_auction_item_prices_all
2373: WHERE auction_header_id = p_auctionHeaderId
2374: AND best_bid_bid_number = p_bidNumber
2375: AND line_number >= p_batchStart
2376: AND line_number <= p_batchEnd
2400:
2401: -- Get auction item price information corresponding to this bid item
2402: SELECT best_bid_number
2403: INTO v_bestBidNumber
2404: FROM pon_auction_item_prices_all
2405: WHERE auction_header_id = p_auctionHeaderId
2406: AND line_number = best_bid_item_record.line_number;
2407:
2408: IF (v_bestBidNumber = p_bidNumber) THEN -- {
2473: END LOOP; -- }
2474:
2475: print_log(l_api_name, p_bidNumber || ': updating best bid info with data structs');
2476: FORALL x IN 1..t_line_number.COUNT
2477: UPDATE pon_auction_item_prices_all
2478: SET best_bid_price = t_price(x),
2479: best_bid_quantity = t_quantity(x),
2480: best_bid_promised_date = t_promised_date(x),
2481: best_bid_number = t_bid_number(x),
2502: FOR best_bid_bid_item_record IN best_bid_bid_lines_cursor LOOP
2503:
2504: SELECT best_bid_bid_number
2505: INTO v_bestBidBidNumber
2506: FROM pon_auction_item_prices_all
2507: WHERE auction_header_id = p_auctionHeaderId
2508: AND line_number = best_bid_bid_item_record.line_number;
2509:
2510: IF (v_bestBidBidNumber = p_bidNumber) THEN
2561: END LOOP;
2562:
2563: print_log(l_api_name, p_bidNumber || ': updating best bid bid info with data structs');
2564: FORALL x IN 1..t_line_number.COUNT
2565: UPDATE pon_auction_item_prices_all
2566: SET best_bid_bid_price = t_price(x),
2567: best_bid_score = t_score(x),
2568: best_bid_bid_number = t_bid_number(x),
2569: best_bid_bid_currency_price = t_bid_currency_price(x),
2592: AND bip.line_number = bid_item_record.line_number),
2593: line_number
2594: INTO t_number_of_bids(v_counter),
2595: t_line_number(v_counter)
2596: FROM pon_auction_item_prices_all
2597: WHERE auction_header_id = p_auctionHeaderId
2598: AND line_number = bid_item_record.line_number;
2599:
2600: -- UPDATE RANK FOR BIDS LOWER THAN THE DISQ BID
2621: END LOOP; -- }
2622:
2623: print_log(l_api_name, p_bidNumber || ': for each line, update the numOfBids and rank using structs');
2624: FORALL x IN 1..t_line_number.COUNT
2625: UPDATE pon_auction_item_prices_all
2626: SET number_of_bids = t_number_of_bids(x)
2627: WHERE auction_header_id = p_auctionHeaderId
2628: AND line_number = t_line_number(x);
2629:
3135: l_auc_pf_fixed_amount_formula,
3136: l_auc_pf_percentage_formula
3137: FROM
3138: pon_auction_headers_all auctions,
3139: pon_auction_item_prices_all items,
3140: pon_pf_supplier_formula pf_formula
3141: WHERE
3142: auctions.auction_header_id = p_auction_header_id
3143: AND items.line_number = p_line_number
3398: pbip.price)
3399: -- hack to set bid total to null if at least one line has a quantity of null
3400: + decode(min(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(paip.quantity, -9999))), -9999, NULL, 0) bid_total
3401: FROM pon_bid_item_prices pbip,
3402: pon_auction_item_prices_all paip
3403: WHERE pbip.auction_header_id = pbh.auction_header_id AND
3404: pbip.bid_number = pbh.bid_number AND
3405: pbip.auction_header_id = paip.auction_header_id AND
3406: pbip.line_number = paip.line_number AND
3413: SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(pbip.quantity, paip.quantity)) * pbip.price)
3414: + decode(min(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(paip.quantity, -9999))), -9999, NULL, 0) bid_total
3415: INTO l_neg_line_total
3416: FROM pon_bid_item_prices pbip,
3417: pon_auction_item_prices_all paip
3418: WHERE pbip.auction_header_id = p_auction_header_id AND
3419: pbip.bid_number = p_bid_number AND
3420: pbip.auction_header_id = paip.auction_header_id AND
3421: pbip.line_number = paip.line_number AND
3695: -- extend all lines
3696: IF (p_autoExtendAllLinesFlag ='Y') THEN
3697:
3698: update
3699: pon_auction_item_prices_all
3700: SET
3701: number_of_extensions = nvl(number_of_extensions,0) + 1,
3702: close_bidding_date = close_bidding_date + p_extensionInterval
3703: WHERE
3707: AND line_number <= p_batchEnd;
3708:
3709: ELSE
3710: -- extend only the lines with new bids
3711: UPDATE pon_auction_item_prices_all
3712: SET number_of_extensions = nvl(number_of_extensions, 0) + 1,
3713: close_bidding_date = decode(p_autoExtendTypeFlag, 'FROM_AUCTION_CLOSE_DATE',
3714: nvl(close_bidding_date, p_hdrCloseBiddingDate) + p_hdrExtensionTime,
3715: p_bidPublishDate + p_hdrExtensionTime)
3717: AND line_number IN
3718: (SELECT al.line_number
3719: FROM pon_bid_headers bh,
3720: pon_bid_item_prices bl,
3721: pon_auction_item_prices_all al
3722: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3723: AND bl.bid_number = bh.bid_number
3724: AND al.auction_header_id = bh.auction_header_id
3725: AND bl.line_number = al.line_number
3748:
3749: -- auto extend all group lines which had at least one
3750: -- other line in the group extended
3751:
3752: UPDATE pon_auction_item_prices_all al
3753: SET (number_of_extensions,
3754: close_bidding_date) =
3755: (SELECT max(number_of_extensions),
3756: max(close_bidding_date)
3753: SET (number_of_extensions,
3754: close_bidding_date) =
3755: (SELECT max(number_of_extensions),
3756: max(close_bidding_date)
3757: FROM pon_auction_item_prices_all al2
3758: WHERE al2.auction_header_id = al.auction_header_id
3759: AND nvl(al2.parent_line_number, al2.line_number) =
3760: nvl(al.parent_line_number, al.line_number))
3761: WHERE auction_header_id = p_auctionHeaderId
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3854:
3855: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3856: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;
3857:
3858: v_extensionInterval NUMBER;
3859:
3941: into
3942: v_triggerLineCloseBiddingDate,
3943: v_bidPublishDate
3944: from
3945: pon_auction_item_prices_all a,
3946: pon_bid_item_prices b
3947: where
3948: -- We need to consider every bid generated during this publish - the current bid + all proxy bids
3949: b.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
4128: NVL(bestbid.rate,1.0) as best_bid_rate,
4129: NVL(bestbid.number_price_decimals,10) as best_bid_decimals
4130: from pon_bid_headers bestbid,
4131: pon_bid_item_prices biditem,
4132: pon_auction_item_prices_all item
4133: where bestbid.bid_number = item.best_bid_number
4134: and item.auction_header_id = biditem.auction_header_id
4135: and item.line_number = biditem.line_number
4136: and biditem.auction_header_id= p_auctionHeaderId
4360: print_log(l_api_name, p_bidNumber || ': (proxy) we have ' || t_itm_line_number.COUNT || ' lines');
4361:
4362: -- Update pon auction item prices, setting the no of bids and the new proxy limit price
4363: FORALL x IN 1..t_itm_line_number.COUNT
4364: UPDATE pon_auction_item_prices_all
4365: SET number_of_bids = t_itm_number_of_bids(x),
4366: best_bid_proxy_limit_price = t_itm_best_bid_proxy_limit_prc(x)
4367: WHERE auction_header_id = p_auctionHeaderId
4368: AND line_number = t_itm_line_number(x);
4488: l_api_name CONSTANT VARCHAR2(30) := 'update_and_rerank_group_lines';
4489: CURSOR groups_to_be_reranked(v_publish_date DATE) IS
4490: SELECT groupline.line_number
4491: FROM pon_bid_item_prices groupline,
4492: pon_auction_item_prices_all auctionline
4493: WHERE groupline.bid_number = p_bidNumber
4494: AND groupline.publish_date = v_publish_date
4495: AND auctionline.auction_header_id = groupline.auction_header_id
4496: AND auctionline.line_number = groupline.line_number
4573: END IF; -- end if (p_rankIndicator = 'NUMBERING')
4574:
4575: END LOOP;
4576:
4577: -- set the pon_auction_item_prices_all.best_bid* attributes
4578: -- using rank #1 bid
4579: FORALL x in 1..t_itm_bid_number.COUNT
4580: UPDATE pon_auction_item_prices_all
4581: SET best_bid_number = t_itm_bid_number(x),
4576:
4577: -- set the pon_auction_item_prices_all.best_bid* attributes
4578: -- using rank #1 bid
4579: FORALL x in 1..t_itm_bid_number.COUNT
4580: UPDATE pon_auction_item_prices_all
4581: SET best_bid_number = t_itm_bid_number(x),
4582: best_bid_bid_number = decode(p_bidRanking,
4583: 'MULTI_ATTRIBUTE_SCORING',
4584: t_itm_bid_number(x),
4619: SELECT bidline.line_number
4620: FROM pon_bid_item_prices bidline,
4621: pon_bid_headers bidheader,
4622: pon_bid_headers bestbidheader,
4623: pon_auction_item_prices_all auctionline
4624: WHERE auctionline.auction_header_id = bidline.auction_header_id
4625: AND bidline.bid_number = p_bidNumber
4626: AND bidline.line_number = auctionline.line_number
4627: AND bidheader.bid_number = bidline.bid_number
4636: SELECT bidline.line_number
4637: FROM pon_bid_item_prices bidline,
4638: pon_bid_headers bidheader,
4639: pon_bid_headers bestbidheader,
4640: pon_auction_item_prices_all auctionline
4641: WHERE auctionline.auction_header_id = bidline.auction_header_id
4642: AND bidline.bid_number = p_bidNumber
4643: AND bidline.line_number = auctionline.line_number
4644: AND bidheader.bid_number = bidline.bid_number
4741:
4742: END LOOP;
4743:
4744: FORALL x IN 1..t_line_number.COUNT
4745: UPDATE pon_auction_item_prices_all
4746: SET best_bid_price = t_price(x),
4747: best_bid_quantity = t_quantity(x),
4748: best_bid_promised_date = t_promised_date(x),
4749: best_bid_number = t_bid_number(x),
4812:
4813: END LOOP;
4814:
4815: FORALL x IN 1..t_line_number.COUNT
4816: UPDATE pon_auction_item_prices_all
4817: SET best_bid_bid_price = t_price(x),
4818: best_bid_score = t_score(x),
4819: best_bid_bid_number = t_bid_number(x),
4820: best_bid_bid_currency_price = t_bid_currency_price(x),
4843: IS
4844:
4845: BEGIN
4846:
4847: UPDATE pon_auction_item_prices_all auctionline
4848: SET (auctionline.best_bid_number,
4849: auctionline.best_bid_price,
4850: auctionline.best_bid_quantity,
4851: auctionline.best_bid_promised_date,
4892:
4893:
4894: IF (p_bidRanking = 'MULTI_ATTRIBUTE_SCORING') THEN
4895:
4896: UPDATE pon_auction_item_prices_all auctionline
4897: SET (auctionline.best_bid_bid_number,
4898: auctionline.best_bid_bid_price,
4899: auctionline.best_bid_score,
4900: auctionline.best_bid_bid_currency_price,
4962: bidline.total_weighted_score,
4963: bidline.proxy_bid_flag,
4964: NVL(oldBidline.rank, DEAD_LAST) as old_rank
4965: FROM pon_bid_item_prices bidline,
4966: pon_auction_item_prices_all auctionline,
4967: pon_bid_item_prices oldBidline
4968: WHERE bidline.bid_number = p_bidNumber
4969: AND bidline.publish_date = v_publish_date
4970: AND auctionline.auction_header_id = bidline.auction_header_id
5097: p_batchEnd IN NUMBER)
5098: IS
5099: BEGIN
5100:
5101: UPDATE pon_auction_item_prices_all
5102: SET best_bid_number = p_bidNumber
5103: WHERE auction_header_id = p_auctionHeaderId
5104: AND best_bid_number = p_oldBidNumber
5105: AND line_number >= p_batchStart
5104: AND best_bid_number = p_oldBidNumber
5105: AND line_number >= p_batchStart
5106: AND line_number <= p_batchEnd;
5107:
5108: UPDATE pon_auction_item_prices_all
5109: SET best_bid_bid_number = p_bidNumber
5110: WHERE auction_header_id = p_auctionHeaderId
5111: AND best_bid_bid_number = p_oldBidNumber
5112: AND line_number >= p_batchStart
5126: BEGIN
5127:
5128: -- UPDATE GROUPS
5129: -- applies to lines: GROUP lines that were affected by this bid
5130: -- action performed: (1) re-set best_bid* attributes in pon_auction_item_prices_all
5131: -- (2) if ranking is NUMBERING, rerank all bids for each GROUP
5132: update_and_rerank_group_lines(p_auctionHeaderId, p_bidNumber, p_publishDate,
5133: p_rankIndicator, p_bidRanking, p_discard_tech_nonshort);
5134:
5199: update_old_best_bid_number(p_auctionHeaderId, p_oldBidNumber, p_bidNumber, p_batchStart, p_batchEnd);
5200:
5201: -- 4) UPDATE NUMBER_OF_BIDS
5202: -- for all lines on which this bid has a new bid on, we must
5203: -- increment the pon_auction_item_prices_all.number_of_bids
5204: -- by 1.
5205: UPDATE pon_auction_item_prices_all
5206: SET number_of_bids = nvl(number_of_bids,0) + 1
5207: WHERE auction_header_id = p_auctionHeaderId
5201: -- 4) UPDATE NUMBER_OF_BIDS
5202: -- for all lines on which this bid has a new bid on, we must
5203: -- increment the pon_auction_item_prices_all.number_of_bids
5204: -- by 1.
5205: UPDATE pon_auction_item_prices_all
5206: SET number_of_bids = nvl(number_of_bids,0) + 1
5207: WHERE auction_header_id = p_auctionHeaderId
5208: AND line_number IN (SELECT line_number
5209: FROM pon_bid_item_prices
5314: -- This procedure performs two tasks:
5315: --
5316: -- 1) UPDATE GROUPS
5317: -- applies to lines: GROUP lines that were affected by this bid
5318: -- action performed: (1) re-set best_bid* attributes in pon_auction_item_prices_all
5319: -- (2) if ranking is NUMBERING, rerank all bids for each GROUP
5320: -- 2) UPDATE WORSENED LINES
5321: -- applies to lines: non-GROUP lines where this supplier user previously held the
5322: -- best bid, but on this bid, he worsened his bid.
5344: -- action performed: reranks all the bids for each of these lines
5345: --
5346: -- 3) UPDATE NUMBER_OF_BIDS
5347: -- for all lines on which this bid has a new bid on, we must
5348: -- increment the pon_auction_item_prices_all.number_of_bids
5349: -- by 1.
5350: print_log(l_api_name, p_bidNumber || ' - do batched part second');
5351: IF (v_batchingRequired) THEN
5352: update_batched_part_batch(p_auctionHeaderId, p_bidNumber, v_publishDate,
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5399: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5400: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5401: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5402: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5403: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5404: v_publishDate DATE;
5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5399: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5400: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5401: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5402: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5403: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5404: v_publishDate DATE;
5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5710: print_log(l_api_name, p_bidNumber || ' - updating aution_item_prices by replacing old_bid_number with bid_number in best_bid_number');
5711:
5712: -- (woojin) may need to add batching here
5713:
5714: UPDATE pon_auction_item_prices_all
5715: SET best_bid_number = p_bidNumber
5716: WHERE auction_header_id = p_auctionHeaderId
5717: AND best_bid_number = v_oldBidNumber;
5718:
5715: SET best_bid_number = p_bidNumber
5716: WHERE auction_header_id = p_auctionHeaderId
5717: AND best_bid_number = v_oldBidNumber;
5718:
5719: UPDATE pon_auction_item_prices_all
5720: SET best_bid_bid_number = p_bidNumber
5721: WHERE auction_header_id = p_auctionHeaderId
5722: AND best_bid_bid_number = v_oldBidNumber;
5723:
5744: SELECT max(close_bidding_date),
5745: max(number_of_extensions)
5746: INTO v_max_close_bidding_date,
5747: v_max_num_of_extensions
5748: FROM pon_auction_item_prices_all al
5749: WHERE al.auction_header_id = p_auctionHeaderId;
5750:
5751: IF (v_max_close_bidding_date IS NOT NULL AND
5752: v_max_num_of_extensions IS NOT NULL) THEN
5816: v_closeBiddingDateH := v_closeBiddingDate_old;
5817:
5818: select max(close_bidding_date)
5819: into v_closeBiddingDateH
5820: from pon_auction_item_prices_all
5821: where auction_header_id = p_auctionHeaderId;
5822:
5823: -- we need to update all the deliverables
5824: -- if and only if this bid has caused auto-extension
5981: nvl(aip.quantity, 1)
5982: )
5983: INTO l_auc_pf_unit_price
5984: FROM pon_pf_supplier_formula ppsf,
5985: pon_auction_item_prices_all aip,
5986: pon_bid_headers pbh
5987: WHERE ppsf.auction_header_id = p_auction_header_id
5988: AND ppsf.line_number = p_line_number
5989: AND ppsf.trading_partner_id = pbh.trading_partner_id
6019: )
6020: ,0)
6021: INTO l_bid_line_pf_unit_price
6022: FROM pon_bid_price_elements spf,
6023: pon_auction_item_prices_all aip
6024: WHERE spf.bid_number = p_prev_auc_active_bid_number
6025: AND spf.line_number = p_line_number
6026: AND spf.sequence_number <> -10
6027: AND spf.pf_type = 'SUPPLIER'
6094: -- line.
6095: -- 3. If there is atleast one bid then check to see if this is the
6096: -- best bid for this line.
6097: -- 4. If this is the best bid then ignoring this bid line find out
6098: -- the best bid for this line and update pon_auction_item_prices_all
6099: -- 5. If this is not the best bid then proceed to next step.
6100: -- 6. Re-order all the bid lines (ranks) ignoring the bids that have
6101: -- not been shortlisted.
6102: --========================================================================
6114:
6115: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
6116:
6117: v_bid_number pon_bid_headers.bid_number%TYPE;
6118: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
6119: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
6121: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
6122: t_price pon_bid_item_prices.price%TYPE;
6115: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
6116:
6117: v_bid_number pon_bid_headers.bid_number%TYPE;
6118: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
6119: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
6121: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
6122: t_price pon_bid_item_prices.price%TYPE;
6123: t_quantity pon_bid_item_prices.quantity%TYPE;
6117: v_bid_number pon_bid_headers.bid_number%TYPE;
6118: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
6119: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
6121: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
6122: t_price pon_bid_item_prices.price%TYPE;
6123: t_quantity pon_bid_item_prices.quantity%TYPE;
6124: t_promised_date pon_bid_item_prices.promised_date%TYPE;
6125: t_bid_number pon_bid_item_prices.bid_number%TYPE;
6133: v_rank_bulk PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
6134:
6135: CURSOR all_lines_cursor IS
6136: SELECT line_number
6137: FROM pon_auction_item_prices_all
6138: WHERE auction_header_id = p_auction_header_id
6139: AND line_number >= p_batch_start
6140: AND line_number <= p_batch_end
6141: ORDER BY line_number;
6205: v_best_bid_number,
6206: v_best_bid_bid_number,
6207: v_currentline_group_type
6208: FROM
6209: pon_auction_item_prices_all paip
6210: WHERE
6211: paip.auction_header_id = p_auction_header_id
6212: AND paip.line_number = auction_item_record.line_number;
6213:
6368: || 'just best_bid_number and best_bid_bid_number');
6369: END IF; --}
6370:
6371: UPDATE
6372: pon_auction_item_prices_all
6373: SET
6374: best_bid_number = t_bid_number
6375: WHERE
6376: auction_header_id = p_auction_header_id
6384: message => 'This is not a GROUP line.');
6385: END IF; --}
6386:
6387: UPDATE
6388: pon_auction_item_prices_all
6389: SET
6390: best_bid_price = t_price,
6391: best_bid_quantity = t_quantity,
6392: best_bid_promised_date = t_promised_date,
6403:
6404: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6405: FND_LOG.string(log_level => FND_LOG.level_statement,
6406: module => g_module_prefix || l_module_name,
6407: message => 'Updated pon_auction_item_prices_all');
6408: END IF; --}
6409:
6410: IF (p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING') THEN -- {
6411:
6417:
6418: IF (v_currentline_group_type = 'GROUP') THEN -- {
6419:
6420: UPDATE
6421: pon_auction_item_prices_all
6422: SET
6423: best_bid_bid_number = decode (p_bid_ranking,
6424: 'MULTI_ATTRIBUTE_SCORING', t_bid_number,
6425: null)
6483: t_bid_currency_code);
6484: END IF; --}
6485:
6486: UPDATE
6487: pon_auction_item_prices_all
6488: SET
6489: best_bid_bid_price = t_price,
6490: best_bid_score = t_score,
6491: best_bid_bid_number = t_bid_number,
6497:
6498: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6499: FND_LOG.string(log_level => FND_LOG.level_statement,
6500: module => g_module_prefix || l_module_name,
6501: message => 'Updated pon_auction_item_prices_all');
6502: END IF; --}
6503:
6504: END IF; -- }
6505: