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 1931: l_curr_prec fnd_currencies.precision%TYPE;

1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;
1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1935: BEGIN

Line 1945: fnd_currencies cu

1941: INTO l_price_prec,
1942: l_curr_prec,
1943: l_rate
1944: FROM pon_bid_headers bh,
1945: fnd_currencies cu
1946: WHERE bh.bid_number = p_bid_number
1947: AND cu.currency_code = bh.bid_currency_code;
1948:
1949: -- Get the price factor type info

Line 3115: fnd_currencies cu

3111: INTO g_curr_prec,
3112: g_bid_rate,
3113: l_surrog_bid_flag
3114: FROM pon_bid_headers bh,
3115: fnd_currencies cu
3116: WHERE bh.bid_number = x_bid_number
3117: AND cu.currency_code = bh.bid_currency_code;
3118:
3119: --do the following only if complex work neg

Line 3635: l_curr_prec fnd_currencies.precision%TYPE;

3631: l_blanket VARCHAR2(1);
3632: l_full_qty VARCHAR2(1);
3633: l_rate pon_bid_headers.rate%TYPE;
3634: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3638: l_batch_start pon_bid_item_prices.line_number%TYPE;
3639: l_batch_end pon_bid_item_prices.line_number%TYPE;

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

3664: l_userid,
3665: l_rate,
3666: l_price_prec,
3667: l_curr_prec
3668: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3669: WHERE bh.bid_number = p_bid_number
3670: AND ah.auction_header_id = bh.auction_header_id
3671: AND cu.currency_code = bh.bid_currency_code;
3672:

Line 5625: l_curr_prec fnd_currencies.precision%TYPE;

5621: p_bid_line_number IN NUMBER) IS
5622:
5623: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
5624: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
5625: l_curr_prec fnd_currencies.precision%TYPE;
5626: l_rate pon_bid_headers.rate%TYPE;
5627: BEGIN
5628: SELECT bh.number_price_decimals,
5629: cu.precision,

Line 5635: fnd_currencies cu

5631: INTO l_price_prec,
5632: l_curr_prec,
5633: l_rate
5634: FROM pon_bid_headers bh,
5635: fnd_currencies cu
5636: WHERE bh.bid_number = p_bid_number
5637: AND cu.currency_code = bh.bid_currency_code;
5638:
5639: IF p_po_type = 'QUANTITY' THEN