DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_CURRENCIES

Line 4033: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;

4029: l_shipment_to_req_rate NUMBER := 0;
4030: l_price_tolerance_allowed NUMBER := 0;
4031:
4032: --
4033: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
4034: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
4035: l_po_curr FND_CURRENCIES.currency_code%TYPE;
4036: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
4037: l_rate_date DATE;

Line 4034: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;

4030: l_price_tolerance_allowed NUMBER := 0;
4031:
4032: --
4033: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
4034: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
4035: l_po_curr FND_CURRENCIES.currency_code%TYPE;
4036: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
4037: l_rate_date DATE;
4038: l_rate NUMBER;

Line 4035: l_po_curr FND_CURRENCIES.currency_code%TYPE;

4031:
4032: --
4033: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
4034: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
4035: l_po_curr FND_CURRENCIES.currency_code%TYPE;
4036: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
4037: l_rate_date DATE;
4038: l_rate NUMBER;
4039: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;

Line 4036: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;

4032: --
4033: l_pou_func_curr FND_CURRENCIES.currency_code%TYPE;
4034: l_pou_func_curr_ext_precn FND_CURRENCIES.extended_precision%TYPE;
4035: l_po_curr FND_CURRENCIES.currency_code%TYPE;
4036: l_req_ou_func_curr FND_CURRENCIES.currency_code%TYPE;
4037: l_rate_date DATE;
4038: l_rate NUMBER;
4039: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
4040: l_requesting_org_id NumTab;

Line 4314: FROM fnd_currencies FND, financials_system_parameters FSP,

4310: --used for rounding while checking for tolerance
4311: BEGIN
4312: SELECT FND.currency_code, nvl(FND.extended_precision,5)
4313: INTO l_pou_func_curr, l_pou_func_curr_ext_precn
4314: FROM fnd_currencies FND, financials_system_parameters FSP,
4315: gl_sets_of_books SOB
4316: WHERE FSP.set_of_books_id = SOB.set_of_books_id
4317: AND SOB.currency_code = FND.currency_code;
4318: EXCEPTION