APPS.JL_JLARPCFF_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 4: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;

1: PACKAGE BODY JL_JLARPCFF_XMLP_PKG AS
2: /* $Header: JLARPCFFB.pls 120.2 2008/01/11 07:51:42 abraghun noship $ */
3: PROCEDURE GET_BASE_CURR_DATA IS
4: BASE_CURR FND_CURRENCIES_VL.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: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY JL_JLARPCFF_XMLP_PKG AS
2: /* $Header: JLARPCFFB.pls 120.2 2008/01/11 07:51:42 abraghun noship $ */
3: PROCEDURE GET_BASE_CURR_DATA IS
4: BASE_CURR FND_CURRENCIES_VL.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: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
9: BEGIN

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: JLARPCFFB.pls 120.2 2008/01/11 07:51:42 abraghun noship $ */
3: PROCEDURE GET_BASE_CURR_DATA IS
4: BASE_CURR FND_CURRENCIES_VL.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: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
9: BEGIN
10: BASE_CURR := '';

Line 7: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;

3: PROCEDURE GET_BASE_CURR_DATA IS
4: BASE_CURR FND_CURRENCIES_VL.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: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
9: BEGIN
10: BASE_CURR := '';
11: PREC := 0;

Line 24: FND_CURRENCIES_VL FCURR

20: FCURR.DESCRIPTION
21: INTO BASE_CURR,PREC,MIN_AU,DESCR
22: FROM
23: AP_SYSTEM_PARAMETERS ASP,
24: FND_CURRENCIES_VL FCURR
25: WHERE ASP.BASE_CURRENCY_CODE = FCURR.CURRENCY_CODE;
26: EXCEPTION
27: WHEN NO_DATA_FOUND THEN
28: RAISE_ERR('200XX'