DBA Data[Home] [Help]

APPS.PON_AWARD_PKG dependencies on STANDARD

Line 2735: IF l_contract_type = 'STANDARD' THEN

2731: END IF;
2732: IF l_bid_lines_rec.AWARD_STATUS = 'REJECTED' THEN
2733: l_rejected_lines := l_rejected_lines + 1;
2734: END IF;
2735: IF l_contract_type = 'STANDARD' THEN
2736: l_award_amount := nvl(l_award_amount,0) + nvl(l_bid_lines_rec.award_price,0);
2737: END IF;
2738: END LOOP;
2739:

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

2909: END IF;
2910: END LOOP;
2911: CLOSE c_bid_items;
2912: --
2913: IF (l_award_made) AND (NOT (l_contract_type = 'STANDARD' AND l_line_type = 'QUANTITY'))
2914: AND (l_group_type <> 'LOT_LINE' AND l_group_type <> 'GROUP') THEN
2915: l_award_quantity := 1;
2916: END IF ;
2917: --

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

4285: l_award_amount NUMBER;
4286: BEGIN
4287:
4288: BEGIN
4289: SELECT SUM(DECODE(ah.contract_type, 'STANDARD', bh.total_award_amount, bh.po_agreed_amount * (1/nvl(bh.rate, 1))))
4290: INTO l_award_amount
4291: FROM
4292: pon_auction_headers_all ah,
4293: pon_bid_headers bh