DBA Data[Home] [Help]

APPS.JG_JGZZARIN_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 389: C_ZERO AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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;

Line 390: C_THOUSAND AP_LOOKUP_CODES.DISPLAYED_FIELD%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;

Line 391: C_MILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%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;

Line 392: C_BILLION AP_LOOKUP_CODES.DISPLAYED_FIELD%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;

Line 433: AP_LOOKUP_CODES

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));

Line 455: AP_LOOKUP_CODES LC1,

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,

Line 456: AP_LOOKUP_CODES LC2,

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,

Line 457: AP_LOOKUP_CODES LC3,

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,

Line 458: AP_LOOKUP_CODES LC4,

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

Line 459: AP_LOOKUP_CODES LC5,

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'

Line 460: AP_LOOKUP_CODES LC6,

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'

Line 461: AP_LOOKUP_CODES LC7,

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'

Line 462: AP_LOOKUP_CODES LC8

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'