eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_RESPONSE_PVT dependencies on PON_BID_PRICE_ELEMENTS

Line 534: -- All BPF and SPF values that are stored in the pon_bid_price_elements

530:
531: WHILE (v_batch_start <= v_max_line_number) LOOP
532:
533: -- RECALCULATE SPF/BPF VALUES
534: -- All BPF and SPF values that are stored in the pon_bid_price_elements
535: -- table need to be recalculated. There are two parts to this task:
536: -- (1) recalculate BPF values from auction-currency prices
537: -- to bid-currency
538: -- (2) recalculate SPF values from bid-currency prices to

Line 541: -- (1) For BPF values in the pon_bid_price_elements table,

537: -- to bid-currency
538: -- (2) recalculate SPF values from bid-currency prices to
539: -- auction-currency
540:
541: -- (1) For BPF values in the pon_bid_price_elements table,
542: -- we need to recalculate the bid-currency values from
543: -- the auction-currency values.
544:
545: -- NOTE: does not apply for spreadsheet upload, only if currency_changed

Line 551: UPDATE pon_bid_price_elements pbpe

547: AND p_curr_changed = 'Y') THEN
548:
549: -- recalculate bid-currency BPF values from auction-currency values.
550: -- Bid-currency BPF value should be rounded.
551: UPDATE pon_bid_price_elements pbpe
552: SET pbpe.bid_currency_value =
553: DECODE(pbpe.pricing_basis,
554: 'PER_UNIT', round(pbpe.auction_currency_value*v_rate, v_precision),
555: 'FIXED_AMOUNT', round(pbpe.auction_currency_value*v_rate, v_fnd_precision),

Line 570: UPDATE pon_bid_price_elements pbpe

566: -- be rounded.
567:
568: IF(v_display_price_factors_flag = 'Y') THEN
569:
570: UPDATE pon_bid_price_elements pbpe
571: SET pbpe.auction_currency_value = pbpe.bid_currency_value / decode(pbpe.pricing_basis, 'PERCENTAGE', 1, v_rate)
572: WHERE pbpe.bid_number = p_bid_number
573: AND pbpe.pf_type = 'SUPPLIER'
574: -- process only batch, or all SUPPLIER price elements if currency changed

Line 587: -- pon_bid_price_elements table and adding to the result of (1)

583: -- there are two steps to recalculating auction-currency transformed
584: -- bid price:
585: -- (1) apply BPF values by using pon_pf_supplier_formula
586: -- (2) apply SPF values by summing up all applicable SPF values from
587: -- pon_bid_price_elements table and adding to the result of (1)
588:
589: -- first, calculate v_is_spo_transformed flag
590: IF (v_supplier_view_type = 'TRANSFORMED' AND
591: v_contract_type = 'STANDARD') THEN

Line 641: FROM pon_bid_price_elements spf,

637: (spf.bid_currency_value / decode(v_is_spo_transformed,
638: 'Y', nvl(pbip.quantity, 1),
639: nvl(aip.quantity, 1)))))),
640: 0)
641: FROM pon_bid_price_elements spf,
642: pon_auction_item_prices_all aip
643: WHERE spf.bid_number = p_bid_number
644: AND spf.line_number = pbip.line_number
645: AND spf.sequence_number <> -10

Line 748: -- pon_bid_price_elements table and adding to the result of (1)

744: -- there are two steps to recalculating auction-currency transformed
745: -- shipment price:
746: -- (1) apply BPF values by using pon_pf_supplier_formula
747: -- (2) apply SPF values by summing up all applicable SPF values from
748: -- pon_bid_price_elements table and adding to the result of (1)
749:
750: -- NOTE: does not apply for spreadsheet upload, only if currency changed
751: --comment this out for price tier: IF (v_contract_type <> 'STANDARD') THEN
752:

Line 791: FROM pon_bid_price_elements spf,

787: (spf.bid_currency_value / decode(v_is_spo_transformed,
788: 'Y', nvl(pbip.quantity, 1),
789: nvl(aip.quantity, 1))))),
790: 0)
791: FROM pon_bid_price_elements spf,
792: pon_auction_item_prices_all aip,
793: pon_bid_item_prices pbip
794: WHERE pbip.bid_number = pbs.bid_number
795: AND pbip.line_number = pbs.line_number

Line 1482: DELETE FROM pon_bid_price_elements pbpe

1478:
1479: -- remove:
1480: -- 1) empty price elements
1481: -- 2) price elements for lines with hasBid=N
1482: DELETE FROM pon_bid_price_elements pbpe
1483: WHERE pbpe.bid_number = p_bid_number
1484: AND EXISTS (SELECT null
1485: FROM pon_bid_item_prices pbip
1486: WHERE pbip.bid_number = pbpe.bid_number