DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on FND_CURRENCIES

Line 8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_BID_DEFAULTING_PKG';
5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;

Line 172: p_curr_prec IN fnd_currencies.precision%TYPE,

168: p_full_qty IN VARCHAR2,
169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS
176: l_skip_pf_for_batch VARCHAR2(1);

Line 1699: l_curr_prec fnd_currencies.precision%TYPE;

1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;
1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1703: BEGIN

Line 1713: fnd_currencies cu

1709: INTO l_price_prec,
1710: l_curr_prec,
1711: l_rate
1712: FROM pon_bid_headers bh,
1713: fnd_currencies cu
1714: WHERE bh.bid_number = p_bid_number
1715: AND cu.currency_code = bh.bid_currency_code;
1716:
1717: -- Get the price factor type info

Line 2802: fnd_currencies cu

2798: INTO g_curr_prec,
2799: g_bid_rate,
2800: l_surrog_bid_flag
2801: FROM pon_bid_headers bh,
2802: fnd_currencies cu
2803: WHERE bh.bid_number = x_bid_number
2804: AND cu.currency_code = bh.bid_currency_code;
2805:
2806: --do the following only if complex work neg

Line 3065: l_curr_prec fnd_currencies.precision%TYPE;

3061: l_blanket VARCHAR2(1);
3062: l_full_qty VARCHAR2(1);
3063: l_rate pon_bid_headers.rate%TYPE;
3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3068: l_batch_start pon_bid_item_prices.line_number%TYPE;
3069: l_batch_end pon_bid_item_prices.line_number%TYPE;

Line 3098: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu

3094: l_userid,
3095: l_rate,
3096: l_price_prec,
3097: l_curr_prec
3098: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3099: WHERE bh.bid_number = p_bid_number
3100: AND ah.auction_header_id = bh.auction_header_id
3101: AND cu.currency_code = bh.bid_currency_code;
3102: