DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_CURRENCIES

Line 5946: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;

5942: l_shipment_to_req_rate NUMBER := 0;
5943: l_price_tolerance_allowed NUMBER := 0;
5944:
5945: --
5946: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
5947: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;
5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
5950: l_rate_date DATE;

Line 5947: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;

5943: l_price_tolerance_allowed NUMBER := 0;
5944:
5945: --
5946: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
5947: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;
5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
5950: l_rate_date DATE;
5951: l_rate NUMBER;

Line 5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;

5944:
5945: --
5946: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
5947: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;
5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
5950: l_rate_date DATE;
5951: l_rate NUMBER;
5952: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;

Line 5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;

5945: --
5946: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
5947: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
5948: l_po_curr FND_CURRENCIES.currency_code%TYPE;
5949: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
5950: l_rate_date DATE;
5951: l_rate NUMBER;
5952: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
5953: l_requesting_org_id NumTab;

Line 5963: TYPE CurrencyTab IS TABLE of FND_CURRENCIES.CURRENCY_CODE%TYPE;

5959: --
5960:
5961: l_is_complex_po BOOLEAN := FALSE; --
5962: -- Start of Bug# 13857241
5963: TYPE CurrencyTab IS TABLE of FND_CURRENCIES.CURRENCY_CODE%TYPE;
5964: l_is_same_foreign_currency VARCHAR2(1);
5965: l_req_line_curr_unit_price NumTab;
5966: l_req_line_curr_code CurrencyTab;
5967: l_po_line_type PO_LINES_ALL.ORDER_TYPE_LOOKUP_CODE%TYPE;

Line 6294: FROM fnd_currencies FND, financials_system_parameters FSP,

6290: --used for rounding while checking for tolerance
6291: BEGIN
6292: SELECT FND.currency_code, nvl(FND.extended_precision,5)
6293: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
6294: FROM fnd_currencies FND, financials_system_parameters FSP,
6295: gl_sets_of_books SOB
6296: WHERE FSP.set_of_books_id = SOB.set_of_books_id
6297: AND SOB.currency_code = FND.currency_code;
6298: EXCEPTION