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_AWARD_PKG dependencies on STANDARD

Line 1573: IF l_contract_type = 'STANDARD' THEN

1569: END IF;
1570: IF l_bid_lines_rec.AWARD_STATUS = 'REJECTED' THEN
1571: l_rejected_lines := l_rejected_lines + 1;
1572: END IF;
1573: IF l_contract_type = 'STANDARD' THEN
1574: l_award_amount := nvl(l_award_amount,0) + nvl(l_bid_lines_rec.award_price,0);
1575: END IF;
1576: END LOOP;
1577:

Line 1744: IF (l_award_made) AND (NOT (l_contract_type = 'STANDARD' AND l_line_type = 'QUANTITY'))

1740: END IF;
1741: END LOOP;
1742: CLOSE c_bid_items;
1743: --
1744: IF (l_award_made) AND (NOT (l_contract_type = 'STANDARD' AND l_line_type = 'QUANTITY'))
1745: AND (l_group_type <> 'LOT_LINE' AND l_group_type <> 'GROUP') THEN
1746: l_award_quantity := 1;
1747: END IF ;
1748: --

Line 3092: SELECT SUM(DECODE(ah.contract_type, 'STANDARD', bh.total_award_amount, bh.po_agreed_amount * (1/nvl(bh.rate, 1))))

3088: l_award_amount NUMBER;
3089: BEGIN
3090:
3091: BEGIN
3092: SELECT SUM(DECODE(ah.contract_type, 'STANDARD', bh.total_award_amount, bh.po_agreed_amount * (1/nvl(bh.rate, 1))))
3093: INTO l_award_amount
3094: FROM
3095: pon_auction_headers_all ah,
3096: pon_bid_headers bh