APPS.AP_APXVCHCR_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 6: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;

2: /* $Header: APXVCHCRB.pls 120.1 2008/06/18 11:01:44 npannamp noship $ */
3:
4: FUNCTION get_base_curr_data RETURN BOOLEAN IS
5:
6: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;
7: BEGIN
8:
9: base_curr := '';
10: prec := 0;

Line 23: fnd_currencies_vl c

19: prec,
20: min_au,
21: descr
22: FROM ap_system_parameters p,
23: fnd_currencies_vl c
24: WHERE p.base_currency_code = c.currency_code;
25:
26: c_base_currency_code := base_curr;
27: c_base_precision := prec;

Line 346: l_pay_curr_name FND_CURRENCIES_VL.name%TYPE;

342: function c_pay_curr_nameformula(C_PAY_CURR_CODE in varchar2) return varchar2 is
343: begin
344:
345: declare
346: l_pay_curr_name FND_CURRENCIES_VL.name%TYPE;
347: begin
348: select c2.name
349: into l_pay_curr_name
350: from FND_CURRENCIES_VL c2

Line 350: from FND_CURRENCIES_VL c2

346: l_pay_curr_name FND_CURRENCIES_VL.name%TYPE;
347: begin
348: select c2.name
349: into l_pay_curr_name
350: from FND_CURRENCIES_VL c2
351: where c2.currency_code = C_PAY_CURR_CODE;
352:
353: return(l_pay_curr_name);
354: end;

Line 361: l_bank_curr_name FND_CURRENCIES_VL.name%TYPE;

357: function c_bank_curr_nameformula(C_BANK_CURR_CODE in varchar2) return varchar2 is
358: begin
359:
360: declare
361: l_bank_curr_name FND_CURRENCIES_VL.name%TYPE;
362: begin
363: select c1.name
364: into l_bank_curr_name
365: from FND_CURRENCIES_VL c1

Line 365: from FND_CURRENCIES_VL c1

361: l_bank_curr_name FND_CURRENCIES_VL.name%TYPE;
362: begin
363: select c1.name
364: into l_bank_curr_name
365: from FND_CURRENCIES_VL c1
366: where c1.currency_code = C_BANK_CURR_CODE;
367:
368: if C_FIRST_REC = 'Y' then
369: C_OLD_BANK_CURR_CODE := C_BANK_CURR_CODE;