APPS.AP_APXWTGNR_XMLP_PKG dependencies on FND_CURRENCIES

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY AP_APXWTGNR_XMLP_PKG AS
2: /* $Header: APXWTGNRB.pls 120.0.12020000.3 2012/07/31 10:10:37 asansari 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 := '';

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: APXWTGNRB.pls 120.0.12020000.3 2012/07/31 10:10:37 asansari 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 := '';
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 := '';
10: PREC := 0;
11: MIN_AU := 0;

Line 21: FND_CURRENCIES_VL C

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;
25: C_BASE_MIN_ACCT_UNIT := MIN_AU;

Line 364: FND_CURRENCIES_VL

360: CURSOR C_NAME IS
361: SELECT
362: NAME
363: FROM
364: FND_CURRENCIES_VL
365: WHERE ( CURRENCY_CODE = C_BASE_CURRENCY_CODE );
366: CURR_NAME FND_CURRENCIES_VL.NAME%TYPE;
367: BEGIN
368: OPEN C_NAME;

Line 366: CURR_NAME FND_CURRENCIES_VL.NAME%TYPE;

362: NAME
363: FROM
364: FND_CURRENCIES_VL
365: WHERE ( CURRENCY_CODE = C_BASE_CURRENCY_CODE );
366: CURR_NAME FND_CURRENCIES_VL.NAME%TYPE;
367: BEGIN
368: OPEN C_NAME;
369: FETCH C_NAME
370: INTO CURR_NAME;

Line 1752: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

1748: FUNCTION AP_ROUND_CURRENCY(P_AMOUNT IN NUMBER
1749: ,P_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER IS
1750: X0 NUMBER;
1751: /*Bug 13921905*/
1752: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
1753: l_precision FND_CURRENCIES.precision%TYPE;
1754:
1755: begin
1756:

Line 1753: l_precision FND_CURRENCIES.precision%TYPE;

1749: ,P_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER IS
1750: X0 NUMBER;
1751: /*Bug 13921905*/
1752: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
1753: l_precision FND_CURRENCIES.precision%TYPE;
1754:
1755: begin
1756:
1757: Begin

Line 1760: from fnd_currencies FC

1756:
1757: Begin
1758: select FC.minimum_accountable_unit, FC.precision
1759: into l_minimum_acct_unit, l_precision
1760: from fnd_currencies FC
1761: where FC.currency_code = P_Currency_Code;
1762:
1763: Exception
1764: When No_Data_Found Then