[Home] [Help]
1015: END IF;
1016:
1017: -- Generate next bid number
1018: SELECT pon_bid_headers_s.nextval INTO x_bid_number
1019: FROM dual;
1020:
1021: INSERT INTO pon_bid_headers
1022: (
1023: BID_NUMBER,
1725: -- Bug 5046909 - Determine if team scoring is enabled
1726: -- If team scoring is enabled, we do not copy the score over from the
1727: -- earlier bid. If team scoring is not enabled, we copy the score over
1728: -- for a header attribute only if the attribute has not been modified.
1729: -- In both cases, scores by individual scorers are not copied over -
1730: -- only the final one is
1731: -- Adding this SELECT from auction_headers_all - ideally, this should
1732: -- be combined and only one call made for the entire flow...will log a
1733: -- tracking bug for this
3425: IF(l_transformed_price IS NOT NULL) THEN
3426: l_total_price := l_total_price + l_transformed_price;
3427: END IF;
3428:
3429: select ROUND(l_total_price, decode(l_precision, 10000, 10, l_precision)) INTO l_truncated_value FROM dual;
3430:
3431: IF(l_supplier_view = 'UNTRANSFORMED') THEN
3432: IF(l_amount IS NULL OR l_amount = 0) THEN
3433: l_unit_pf_amt := 0;
3449: ELSIF(l_supplier_view = 'TRANSFORMED') THEN
3450: l_trans_price := l_transformed_price;
3451: END IF;
3452:
3453: SELECT ROUND(l_trans_price, decode(l_precision, 10000, 10, l_precision)) INTO l_bid_curr_trans_price FROM dual;
3454:
3455: l_price := l_trans_price/l_rate;
3456:
3457: UPDATE PON_BID_ITEM_PRICES
3485: ELSIF(l_supplier_view = 'TRANSFORMED') THEN
3486: l_trans_price := l_bid_curr_unit_price;
3487: END IF;
3488:
3489: SELECT ROUND(l_trans_price, decode(l_precision, 10000, 10, l_precision)) INTO l_bid_curr_trans_price FROM dual;
3490:
3491: l_price := l_trans_price/l_rate;
3492:
3493: UPDATE PON_BID_ITEM_PRICES
5423: -- Else l_can_create_payment = 'N';
5424:
5425: SELECT 'Y'
5426: INTO x_can_create_payments
5427: FROM dual
5428: WHERE EXISTS (SELECT 1
5429: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
5430: PON_BID_ITEM_PRICES pbi,
5431: PON_AUCTION_HEADERS_ALL pah