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_ATTRIBUTE_VALUES

Line 1462: DELETE FROM pon_bid_attribute_values pbav

1458:
1459: -- 1) empty attributes (including header attributes)
1460: -- 2) display only attributes (including header attributes)
1461: -- 3) attributes on lines that have hasBid = N
1462: DELETE FROM pon_bid_attribute_values pbav
1463: WHERE pbav.bid_number = p_bid_number
1464: AND (EXISTS (SELECT null
1465: FROM pon_auction_attributes paa
1466: WHERE pbav.auction_header_id = paa.auction_header_id

Line 2242: UPDATE pon_bid_attribute_values pbav1

2238: -- pbav2 - evaluation scores
2239: -- pbh1 - bid header for supplier response
2240: -- pbh2 - bid header for evaluation
2241:
2242: UPDATE pon_bid_attribute_values pbav1
2243: SET (pbav1.score, pbav1.weighted_score) =
2244: (SELECT AVG(pbav2.score) score,
2245: AVG(pbav2.score)*paa2.weight/paa2.attr_max_score weighted_score
2246: FROM pon_bid_attribute_values pbav2,

Line 2246: FROM pon_bid_attribute_values pbav2,

2242: UPDATE pon_bid_attribute_values pbav1
2243: SET (pbav1.score, pbav1.weighted_score) =
2244: (SELECT AVG(pbav2.score) score,
2245: AVG(pbav2.score)*paa2.weight/paa2.attr_max_score weighted_score
2246: FROM pon_bid_attribute_values pbav2,
2247: pon_auction_attributes paa2
2248: WHERE pbav2.auction_header_id = p_auction_header_id
2249: AND pbav2.bid_number IN
2250: (SELECT pbh2.bid_number