[Home] [Help]
450: IF (l_skip_pf_for_batch = 'N') THEN
451:
452: -- Insert missing SUPPLIER price factors only if they exist
453: IF (p_has_pe_flag = 'Y') THEN
454: INSERT INTO pon_bid_price_elements
455: (
456: BID_NUMBER,
457: LINE_NUMBER,
458: PRICE_ELEMENT_TYPE_ID,
484: AND apf.pf_type = 'SUPPLIER' -- only supplier price factors
485: AND apf.line_number BETWEEN p_batch_start AND p_batch_end
486: AND NOT EXISTS
487: (SELECT pbpe.price_element_type_id
488: FROM pon_bid_price_elements pbpe
489: WHERE pbpe.bid_number = p_bid_number
490: AND pbpe.line_number = apf.line_number
491: AND pbpe.price_element_type_id = apf.price_element_type_id));
492:
502:
503: -- Insert missing BUYER price factors if applicable
504: IF (p_supp_seq_number IS NOT null) THEN
505:
506: INSERT INTO pon_bid_price_elements
507: (
508: BID_NUMBER,
509: LINE_NUMBER,
510: PRICE_ELEMENT_TYPE_ID,
554: AND nvl(pf.value, 0) <> 0
555: AND apf.line_number BETWEEN p_batch_start AND p_batch_end
556: AND NOT EXISTS
557: (SELECT pbpe.price_element_type_id
558: FROM pon_bid_price_elements pbpe
559: WHERE pbpe.bid_number = p_bid_number
560: AND pbpe.line_number = apf.line_number
561: AND pbpe.price_element_type_id = apf.price_element_type_id));
562:
741: WHERE ba.bid_number = p_bid_number
742: AND ba.line_number BETWEEN p_batch_start AND p_batch_end;
743:
744: -- Update SUPPLIER price factor old value columns
745: UPDATE pon_bid_price_elements bpf
746: SET bpf.old_bid_currency_value =
747: (SELECT old_bpf.bid_currency_value
748: FROM pon_bid_price_elements old_bpf
749: WHERE old_bpf.bid_number = p_source_bid_num
744: -- Update SUPPLIER price factor old value columns
745: UPDATE pon_bid_price_elements bpf
746: SET bpf.old_bid_currency_value =
747: (SELECT old_bpf.bid_currency_value
748: FROM pon_bid_price_elements old_bpf
749: WHERE old_bpf.bid_number = p_source_bid_num
750: AND old_bpf.line_number = bpf.line_number
751: AND old_bpf.price_element_type_id = bpf.price_element_type_id)
752: WHERE bpf.bid_number = p_bid_number
1955: -- copy over all supplier price factors, including line price
1956: -- do not copy line price pf for lines with display_price_factors_flag = N
1957: IF (l_supplier_view <> 'UNTRANSFORMED') THEN
1958:
1959: INSERT INTO pon_bid_price_elements
1960: (
1961: BID_NUMBER,
1962: LINE_NUMBER,
1963: PRICE_ELEMENT_TYPE_ID,
1992: p_userid, -- LAST_UPDATED_BY
1993: apf.pf_type, -- PF_TYPE
1994: decode(p_rebid_flag, 'Y', bpf.bid_currency_value, null) -- OLD_BID_CURRENCY_VALUE
1995: FROM pon_price_elements apf,
1996: pon_bid_price_elements bpf,
1997: pon_bid_item_prices bl
1998: WHERE apf.auction_header_id = p_auc_header_id
1999: AND apf.pf_type = 'SUPPLIER' -- only for supplier price factors
2000: AND bl.bid_number = p_bid_number
2010: -- display flag checked and have nonzero value
2011: -- need to populate bid_currency_value, rounding as necessary
2012: IF (p_supp_seq_number IS NOT null AND l_pf_type <> 'SUPPLIER') THEN
2013:
2014: INSERT INTO pon_bid_price_elements
2015: (
2016: BID_NUMBER,
2017: LINE_NUMBER,
2018: PRICE_ELEMENT_TYPE_ID,
2785: OR EXISTS
2786:
2787: -- Check price factors
2788: (SELECT bpf.line_number
2789: FROM pon_bid_price_elements bpf
2790: WHERE bpf.bid_number = bl.bid_number
2791: AND bpf.line_number = bl.line_number
2792: AND bpf.pf_type = 'SUPPLIER'
2793: AND bpf.bid_currency_value IS NOT null
2939: AND pbip.line_number(+) = paip.line_number;
2940:
2941: CURSOR supplier_pf_curr(v_line_number pon_bid_item_prices.line_number%TYPE) IS
2942: SELECT PRICING_BASIS, BID_CURRENCY_VALUE, PRICE_ELEMENT_TYPE_ID
2943: FROM PON_BID_PRICE_ELEMENTS
2944: WHERE AUCTION_HEADER_ID = p_auc_header_id
2945: AND BID_NUMBER = x_bid_number
2946: AND LINE_NUMBER = v_line_number
2947: AND PF_TYPE <> 'BUYER';
5562: )
5563: )
5564: ,0)
5565: INTO l_bid_line_pf_unit_price
5566: FROM pon_bid_price_elements spf,
5567: pon_auction_item_prices_all aip
5568: WHERE spf.bid_number = p_prev_auc_active_bid_number
5569: AND spf.line_number = p_line_number
5570: AND spf.sequence_number <> -10