DBA Data[Home] [Help]

APPS.AP_APXFPMDR_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 4: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

1: PACKAGE BODY AP_APXFPMDR_XMLP_PKG AS
2: /* $Header: APXFPMDRB.pls 120.0 2007/12/27 07:39:22 vjaganat noship $ */
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

Line 20: AP_SYSTEM_PARAMETERS P,

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

Line 175: AP_SYSTEM_PARAMETERS ASP

171: CHART_OF_ACCOUNTS_ID
172: INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
173: FROM
174: GL_SETS_OF_BOOKS GSB,
175: AP_SYSTEM_PARAMETERS ASP
176: WHERE GSB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID;
177: C_COMPANY_NAME_HEADER := L_NAME;
178: C_CHART_OF_ACCOUNTS_ID := L_CHART_OF_ACCOUNTS_ID;
179: C_REPORT_START_DATE := L_REPORT_START_DATE;