DBA Data[Home] [Help]

APPS.JL_JLMXFISR_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 4: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;

1: PACKAGE BODY JL_JLMXFISR_XMLP_PKG AS
2: /* $Header: JLMXFISRB.pls 120.2 2008/01/11 05:07:34 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: BEGIN

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY JL_JLMXFISR_XMLP_PKG AS
2: /* $Header: JLMXFISRB.pls 120.2 2008/01/11 05:07:34 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: BEGIN
9: BASE_CURR := '';

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: JLMXFISRB.pls 120.2 2008/01/11 05:07:34 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: BEGIN
9: BASE_CURR := '';
10: PREC := 0;

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: BEGIN
9: BASE_CURR := '';
10: PREC := 0;
11: MIN_AU := 0;

Line 29: FND_CURRENCIES_VL FCURR,

25: FCURR.DESCRIPTION
26: INTO BASE_CURR,PREC,MIN_AU,DESCR
27: FROM
28: FA_BOOK_CONTROLS_MRC_V BKCTRL,
29: FND_CURRENCIES_VL FCURR,
30: GL_SETS_OF_BOOKS GSBKS
31: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
32: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
33: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line 51: FND_CURRENCIES_VL FCURR,

47: FCURR.DESCRIPTION
48: INTO BASE_CURR,PREC,MIN_AU,DESCR
49: FROM
50: FA_BOOK_CONTROLS BKCTRL,
51: FND_CURRENCIES_VL FCURR,
52: GL_SETS_OF_BOOKS GSBKS
53: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
54: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
55: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;