DBA Data[Home] [Help]

APPS.JL_JLMXFIMP_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 4: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;

1: PACKAGE BODY JL_JLMXFIMP_XMLP_PKG AS
2: /* $Header: JLMXFIMPB.pls 120.1 2007/12/25 16:53:01 dwkrishn 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: ERRNO NUMBER;

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY JL_JLMXFIMP_XMLP_PKG AS
2: /* $Header: JLMXFIMPB.pls 120.1 2007/12/25 16:53:01 dwkrishn 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: ERRNO NUMBER;
9: ERRMSG VARCHAR2(1000);

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: JLMXFIMPB.pls 120.1 2007/12/25 16:53:01 dwkrishn 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: ERRNO NUMBER;
9: ERRMSG VARCHAR2(1000);
10: BEGIN

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: ERRNO NUMBER;
9: ERRMSG VARCHAR2(1000);
10: BEGIN
11: BASE_CURR := '';

Line 36: FND_CURRENCIES_VL FCURR,

32: FCURR.DESCRIPTION
33: INTO BASE_CURR,PREC,MIN_AU,DESCR
34: FROM
35: FA_BOOK_CONTROLS_MRC_V BKCTRL,
36: FND_CURRENCIES_VL FCURR,
37: GL_SETS_OF_BOOKS GSBKS
38: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
39: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
40: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line 58: FND_CURRENCIES_VL FCURR,

54: FCURR.DESCRIPTION
55: INTO BASE_CURR,PREC,MIN_AU,DESCR
56: FROM
57: FA_BOOK_CONTROLS BKCTRL,
58: FND_CURRENCIES_VL FCURR,
59: GL_SETS_OF_BOOKS GSBKS
60: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
61: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
62: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;