DBA Data[Home] [Help]

APPS.ZX_ZXXINUTR_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY ZX_ZXXINUTR_XMLP_PKG AS
2: /* $Header: ZXXINUTRB.pls 120.1.12010000.1 2008/07/28 13:28:00 appldev ship $ */
3: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
8: BEGIN
9: BASE_CURR := P_CURR_CODE;

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: ZXXINUTRB.pls 120.1.12010000.1 2008/07/28 13:28:00 appldev ship $ */
3: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
8: BEGIN
9: BASE_CURR := P_CURR_CODE;
10: PREC := 0;

Line 7: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;

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

Line 19: FND_CURRENCIES_VL C

15: C.MINIMUM_ACCOUNTABLE_UNIT,
16: C.DESCRIPTION
17: INTO PREC,MIN_AU,DESCR
18: FROM
19: FND_CURRENCIES_VL C
20: WHERE CURRENCY_CODE = BASE_CURR;
21: C_BASE_CURRENCY_CODE := BASE_CURR;
22: C_BASE_PRECISION := PREC;
23: C_BASE_MIN_ACCT_UNIT := MIN_AU;