DBA Data[Home] [Help]

APPS.JE_JEPLPSSR_XMLP_PKG dependencies on FND_CURRENCIES

Line 5: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

1: PACKAGE BODY JE_JEPLPSSR_XMLP_PKG AS
2: /* $Header: JEPLPSSRB.pls 120.2 2008/01/11 08:02:07 abraghun 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
9: BASE_CURR := '';

Line 6: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

2: /* $Header: JEPLPSSRB.pls 120.2 2008/01/11 08:02:07 abraghun 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
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 489: PREC FND_CURRENCIES.PRECISION%TYPE;

485: ,CF_GROUP_PRECISION));
486: END CF_SUPP_BBFORMULA;
487:
488: FUNCTION CF_GROUP_PRECISIONFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN NUMBER IS
489: PREC FND_CURRENCIES.PRECISION%TYPE;
490: BEGIN
491: IF GROUP_CURRENCY = C_BASE_CURRENCY_CODE THEN
492: RETURN (C_BASE_PRECISION);
493: ELSE

Line 499: FND_CURRENCIES C

495: SELECT
496: C.PRECISION
497: INTO PREC
498: FROM
499: FND_CURRENCIES C
500: WHERE C.CURRENCY_CODE = GROUP_CURRENCY;
501: RETURN (PREC);
502: END IF;
503: RETURN NULL;

Line 518: PREC FND_CURRENCIES.PRECISION%TYPE;

514: RETURN (CF_SUPP_BB + CS_AMOUNT_APPLIED);
515: END CF_REMAIN_BALANCEFORMULA;
516:
517: FUNCTION CF_TRX_PRECISIONFORMULA(TRANS_CURRENCY IN VARCHAR2) RETURN NUMBER IS
518: PREC FND_CURRENCIES.PRECISION%TYPE;
519: BEGIN
520: IF TRANS_CURRENCY = C_BASE_CURRENCY_CODE THEN
521: RETURN (C_BASE_PRECISION);
522: ELSE

Line 528: FND_CURRENCIES C

524: SELECT
525: C.PRECISION
526: INTO PREC
527: FROM
528: FND_CURRENCIES C
529: WHERE C.CURRENCY_CODE = TRANS_CURRENCY;
530: RETURN (PREC);
531: END IF;
532: RETURN NULL;