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 163: fnd_currencies_vl c

159: p_sys_info_rec.default_exchange_rate_type,
160: p_sys_info_rec.base_curr_name,
161: p_sys_info_rec.sys_multi_curr_flag
162: FROM ap_system_parameters s,
163: fnd_currencies_vl c
164: WHERE c.currency_code = s.base_currency_code;
165:
166: RETURN TRUE;
167: EXCEPTION

Line 197: fnd_currencies_vl c

193: BEGIN
194: SELECT s.default_exchange_rate_type
195: INTO p_default_exchange_rate_type
196: FROM ap_system_parameters s,
197: fnd_currencies_vl c
198: WHERE c.currency_code = s.base_currency_code;
199:
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN

Line 223: p_vend_pay_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE

219: FUNCTION GetVendorInfoOfEmp(
220: p_employee_id IN vendors_employeeID,
221: p_vendor_id OUT NOCOPY vendors_vendorID,
222: p_vend_pay_curr_code OUT NOCOPY vendors_paymentCurrCode,
223: p_vend_pay_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
224: ) RETURN BOOLEAN IS
225: ----------------------------------------------------------
226: l_expense_check_address_flag VARCHAR2(1);
227: l_get_from_vendor VARCHAR2(1) := 'N';

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

256: BEGIN
257: --Bug 13604446: To default the currency properly, when the language changed
258: SELECT vdr.vendor_id, site.payment_currency_code, c.name
259: INTO p_vendor_id, p_vend_pay_curr_code, p_vend_pay_curr_name
260: FROM ap_suppliers vdr, ap_supplier_sites site, fnd_currencies_vl c
261: WHERE site.vendor_id = vdr.vendor_id
262: AND ( (vdr.employee_id = p_employee_id and l_vendor_id is null ) OR (l_vendor_id is not null and l_vendor_id = vdr.vendor_id)) -- Bug 6978871(sodash) ,#12916260
263: AND c.currency_code(+) = site.payment_currency_code
264: AND upper(site.vendor_site_code) IN

Line 293: fnd_currencies_vl c

289: INTO p_vendor_id,
290: p_vend_pay_curr_code,
291: p_vend_pay_curr_name
292: FROM ap_suppliers v,
293: fnd_currencies_vl c
294: WHERE ( ( v.employee_id = p_employee_id and l_vendor_id is null ) OR (l_vendor_id is not null and l_vendor_id = v.vendor_id)) -- Bug 6978871(sodash),#12916260
295: AND c.currency_code(+) = v.payment_currency_code;
296: END IF;
297:

Line 484: p_reimb_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,

480: FUNCTION ApproverHasAuthority(
481: p_approver_id IN signingLimits_employeeID,
482: p_doc_cost_center IN signingLimits_costCenter,
483: p_approval_amount IN NUMBER,
484: p_reimb_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
485: p_item_type IN signingLimits_docType,
486: p_payment_curr_code IN VARCHAR2,
487: p_week_end_date IN DATE,
488: p_has_authority OUT NOCOPY BOOLEAN

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

1188: FUNCTION GetInvoiceAmt(
1189: p_invoiceId IN invAll_id,
1190: p_invoiceAmt OUT NOCOPY invLines_amount,
1191: p_exchangeRate OUT NOCOPY invAll_exchangeRate,
1192: p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE,
1193: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
1194: ) RETURN BOOLEAN IS
1195: BEGIN
1196:

Line 1193: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE

1189: p_invoiceId IN invAll_id,
1190: p_invoiceAmt OUT NOCOPY invLines_amount,
1191: p_exchangeRate OUT NOCOPY invAll_exchangeRate,
1192: p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE,
1193: p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
1194: ) RETURN BOOLEAN IS
1195: BEGIN
1196:
1197: SELECT inv.invoice_amount, inv.exchange_rate,

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

1196:
1197: SELECT inv.invoice_amount, inv.exchange_rate,
1198: F.minimum_accountable_unit, F.precision
1199: INTO p_invoiceAmt, p_exchangeRate, p_minAcctUnit, p_precision
1200: FROM AP_INVOICES inv, ap_system_parameters sp, fnd_currencies F
1201: WHERE inv.invoice_id = p_invoiceId
1202: AND inv.set_of_books_id = sp.set_of_books_id
1203: AND F.currency_code = sp.base_currency_code;
1204: