DBA Data[Home] [Help]

APPS.JL_JLZZPSSR_XMLP_PKG dependencies on FND_CURRENCIES

Line 28: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

24: END;
25:
26: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
27: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
28: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
29: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
30: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
31: BEGIN
32: BASE_CURR := '';

Line 29: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

25:
26: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
27: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
28: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
29: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
30: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
31: BEGIN
32: BASE_CURR := '';
33: PREC := 0;

Line 30: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;

26: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
27: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
28: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
29: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
30: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
31: BEGIN
32: BASE_CURR := '';
33: PREC := 0;
34: MIN_AU := 0;

Line 44: FND_CURRENCIES_VL C

40: C.DESCRIPTION
41: INTO BASE_CURR,PREC,MIN_AU,DESCR
42: FROM
43: AP_SYSTEM_PARAMETERS P,
44: FND_CURRENCIES_VL C
45: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
46: C_BASE_CURRENCY_CODE := BASE_CURR;
47: C_BASE_PRECISION := PREC;
48: C_BASE_MIN_ACCT_UNIT := MIN_AU;

Line 520: PREC FND_CURRENCIES.PRECISION%TYPE;

516: ,CF_GROUP_PRECISION));
517: END CF_SUPP_BBFORMULA;
518:
519: FUNCTION CF_GROUP_PRECISIONFORMULA(GROUP_CURRENCY IN VARCHAR2) RETURN NUMBER IS
520: PREC FND_CURRENCIES.PRECISION%TYPE;
521: BEGIN
522: IF GROUP_CURRENCY = C_BASE_CURRENCY_CODE THEN
523: RETURN (C_BASE_PRECISION);
524: ELSE

Line 530: FND_CURRENCIES C

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

Line 549: PREC FND_CURRENCIES.PRECISION%TYPE;

545: RETURN (CF_SUPP_BB + CS_AMOUNT_APPLIED);
546: END CF_REMAIN_BALANCEFORMULA;
547:
548: FUNCTION CF_TRX_PRECISIONFORMULA(TRANS_CURRENCY IN VARCHAR2) RETURN NUMBER IS
549: PREC FND_CURRENCIES.PRECISION%TYPE;
550: BEGIN
551: IF TRANS_CURRENCY = C_BASE_CURRENCY_CODE THEN
552: RETURN (C_BASE_PRECISION);
553: ELSE

Line 559: FND_CURRENCIES C

555: SELECT
556: C.PRECISION
557: INTO PREC
558: FROM
559: FND_CURRENCIES C
560: WHERE C.CURRENCY_CODE = TRANS_CURRENCY;
561: RETURN (PREC);
562: END IF;
563: RETURN NULL;