385: RETURN FND_DATE.DATE_TO_CHARDATE(TAX_DATE);
386: END CF_TAX_DATEFORMULA;
387:
388: FUNCTION JE_AMOUNT_UTILITIES(IN_NUMERAL IN NUMBER) RETURN VARCHAR2 IS
389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
386: END CF_TAX_DATEFORMULA;
387:
388: FUNCTION JE_AMOUNT_UTILITIES(IN_NUMERAL IN NUMBER) RETURN VARCHAR2 IS
389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
387:
388: FUNCTION JE_AMOUNT_UTILITIES(IN_NUMERAL IN NUMBER) RETURN VARCHAR2 IS
389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
388: FUNCTION JE_AMOUNT_UTILITIES(IN_NUMERAL IN NUMBER) RETURN VARCHAR2 IS
389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
393: C_PL_THOUSAND FND_LOOKUPS.MEANING%TYPE;
394: C_PL_THOUSAND_Y FND_LOOKUPS.MEANING%TYPE;
395: C_PL_THOUSAND_E FND_LOOKUPS.MEANING%TYPE;
396: C_PL_MILLION FND_LOOKUPS.MEANING%TYPE;
429: SELECT
430: ' ' || DISPLAYED_FIELD || ' '
431: INTO C_ZERO
432: FROM
433: AP_LOOKUP_CODES
434: WHERE LOOKUP_CODE = 'ZERO';
435: RETURN (C_ZERO);
436: END IF;
437: BILLION_SEG := TO_CHAR(TRUNC(NUMERAL / BILLION));
451: LC7.DESCRIPTION,
452: LC8.DESCRIPTION
453: INTO C_BILLION,C_MILLION,C_THOUSAND,C_ZERO,BILLION_LOOKUP,MILLION_LOOKUP,THOUSAND_LOOKUP,UNITS_LOOKUP
454: FROM
455: AP_LOOKUP_CODES LC1,
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
452: LC8.DESCRIPTION
453: INTO C_BILLION,C_MILLION,C_THOUSAND,C_ZERO,BILLION_LOOKUP,MILLION_LOOKUP,THOUSAND_LOOKUP,UNITS_LOOKUP
454: FROM
455: AP_LOOKUP_CODES LC1,
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
453: INTO C_BILLION,C_MILLION,C_THOUSAND,C_ZERO,BILLION_LOOKUP,MILLION_LOOKUP,THOUSAND_LOOKUP,UNITS_LOOKUP
454: FROM
455: AP_LOOKUP_CODES LC1,
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
454: FROM
455: AP_LOOKUP_CODES LC1,
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
462: AP_LOOKUP_CODES LC8
455: AP_LOOKUP_CODES LC1,
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
462: AP_LOOKUP_CODES LC8
463: WHERE LC1.LOOKUP_CODE = 'BILLION'
456: AP_LOOKUP_CODES LC2,
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
462: AP_LOOKUP_CODES LC8
463: WHERE LC1.LOOKUP_CODE = 'BILLION'
464: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
457: AP_LOOKUP_CODES LC3,
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
462: AP_LOOKUP_CODES LC8
463: WHERE LC1.LOOKUP_CODE = 'BILLION'
464: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
465: AND LC2.LOOKUP_CODE = 'MILLION'
458: AP_LOOKUP_CODES LC4,
459: AP_LOOKUP_CODES LC5,
460: AP_LOOKUP_CODES LC6,
461: AP_LOOKUP_CODES LC7,
462: AP_LOOKUP_CODES LC8
463: WHERE LC1.LOOKUP_CODE = 'BILLION'
464: AND LC1.LOOKUP_TYPE = 'NLS TRANSLATION'
465: AND LC2.LOOKUP_CODE = 'MILLION'
466: AND LC2.LOOKUP_TYPE = 'NLS TRANSLATION'