eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_AP_INT_PKG dependencies on FND_CURRENCIES

Line 47: p_curr_code IN FND_CURRENCIES_VL.currency_code%TYPE,

43: end get_ap_system_params;
44:
45: --------------------------------------------------------------------------------
46: FUNCTION GetCurrNameForCurrCode(
47: p_curr_code IN FND_CURRENCIES_VL.currency_code%TYPE,
48: p_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
49: ) RETURN BOOLEAN IS
50: --------------------------------------------------------------------------------
51: BEGIN

Line 48: p_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE

44:
45: --------------------------------------------------------------------------------
46: FUNCTION GetCurrNameForCurrCode(
47: p_curr_code IN FND_CURRENCIES_VL.currency_code%TYPE,
48: p_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
49: ) RETURN BOOLEAN IS
50: --------------------------------------------------------------------------------
51: BEGIN
52: SELECT name

Line 54: FROM fnd_currencies_vl

50: --------------------------------------------------------------------------------
51: BEGIN
52: SELECT name
53: INTO p_curr_name
54: FROM fnd_currencies_vl
55: WHERE currency_code = p_curr_code;
56:
57: RETURN TRUE;
58: EXCEPTION

Line 159: fnd_currencies_vl c

155: p_sys_info_rec.default_exchange_rate_type,
156: p_sys_info_rec.base_curr_name,
157: p_sys_info_rec.sys_multi_curr_flag
158: FROM ap_system_parameters s,
159: fnd_currencies_vl c
160: WHERE c.currency_code = s.base_currency_code;
161:
162: RETURN TRUE;
163: EXCEPTION

Line 182: fnd_currencies_vl c

178: BEGIN
179: SELECT s.default_exchange_rate_type
180: INTO p_default_exchange_rate_type
181: FROM ap_system_parameters s,
182: fnd_currencies_vl c
183: WHERE c.currency_code = s.base_currency_code;
184:
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN

Line 203: p_vend_pay_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE

199: FUNCTION GetVendorInfoOfEmp(
200: p_employee_id IN vendors_employeeID,
201: p_vendor_id OUT NOCOPY vendors_vendorID,
202: p_vend_pay_curr_code OUT NOCOPY vendors_paymentCurrCode,
203: p_vend_pay_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
204: ) RETURN BOOLEAN IS
205: ----------------------------------------------------------
206: l_expense_check_address_flag VARCHAR2(1);
207: l_get_from_vendor VARCHAR2(1) := 'N';

Line 239: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c

235: IF l_expense_check_address_flag IS NOT NULL THEN
236: BEGIN
237: SELECT vdr.vendor_id, site.payment_currency_code, c.name
238: INTO p_vendor_id, p_vend_pay_curr_code, p_vend_pay_curr_name
239: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c
240: WHERE site.vendor_id = vdr.vendor_id
241: AND (vdr.employee_id = p_employee_id OR (l_vendor_id is not null and l_vendor_id = vdr.vendor_id)) -- Bug 6978871(sodash)
242: AND c.currency_code(+) = site.payment_currency_code
243: AND upper(site.vendor_site_code) =

Line 272: fnd_currencies_vl c

268: INTO p_vendor_id,
269: p_vend_pay_curr_code,
270: p_vend_pay_curr_name
271: FROM ap_suppliers v,
272: fnd_currencies_vl c
273: WHERE (v.employee_id = p_employee_id OR (l_vendor_id is not null and l_vendor_id = v.vendor_id)) -- Bug 6978871(sodash)
274: AND c.currency_code(+) = v.payment_currency_code;
275: END IF;
276:

Line 463: p_reimb_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,

459: FUNCTION ApproverHasAuthority(
460: p_approver_id IN signingLimits_employeeID,
461: p_doc_cost_center IN signingLimits_costCenter,
462: p_approval_amount IN NUMBER,
463: p_reimb_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
464: p_item_type IN signingLimits_docType,
465: p_payment_curr_code IN VARCHAR2,
466: p_week_end_date IN DATE,
467: p_has_authority OUT NOCOPY BOOLEAN

Line 1150: p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE,

1146: FUNCTION GetInvoiceAmt(
1147: p_invoiceId IN invAll_id,
1148: p_invoiceAmt OUT NOCOPY invLines_amount,
1149: p_exchangeRate OUT NOCOPY invAll_exchangeRate,
1150: p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE,
1151: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
1152: ) RETURN BOOLEAN IS
1153: BEGIN
1154:

Line 1151: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE

1147: p_invoiceId IN invAll_id,
1148: p_invoiceAmt OUT NOCOPY invLines_amount,
1149: p_exchangeRate OUT NOCOPY invAll_exchangeRate,
1150: p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE,
1151: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
1152: ) RETURN BOOLEAN IS
1153: BEGIN
1154:
1155: SELECT inv.invoice_amount, inv.exchange_rate,

Line 1158: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F

1154:
1155: SELECT inv.invoice_amount, inv.exchange_rate,
1156: F.minimum_accountable_unit, F.precision
1157: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1158: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1159: WHERE inv.invoice_id = p_invoiceId
1160: AND inv.set_of_books_id = sp.set_of_books_id
1161: AND F.currency_code = sp.base_currency_code;
1162: