DBA Data[Home] [Help]

APPS.AP_APXVDLET_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 6: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

2: /* $Header: APXVDLETB.pls 120.0 2007/12/27 08:47:25 vjaganat noship $ */
3: DO_SQL_FAILURE EXCEPTION;
4: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
5: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
7: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
8: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
9: BEGIN
10: BASE_CURR := '';

Line 7: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

3: DO_SQL_FAILURE EXCEPTION;
4: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
5: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
7: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
8: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
9: BEGIN
10: BASE_CURR := '';
11: PREC := 0;

Line 8: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;

4: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
5: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
7: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
8: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
9: BEGIN
10: BASE_CURR := '';
11: PREC := 0;
12: MIN_AU := 0;

Line 26: FND_CURRENCIES_VL C

22: ,MIN_AU
23: ,DESCR
24: FROM
25: AP_SYSTEM_PARAMETERS P,
26: FND_CURRENCIES_VL C
27: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
28: C_BASE_CURRENCY_CODE := BASE_CURR;
29: C_BASE_PRECISION := PREC;
30: C_BASE_MIN_ACCT_UNIT := MIN_AU;