APPS.IBY_AMOUNT_IN_WORDS dependencies on AP_LOOKUP_CODES

Line 21: c_zero ap_lookup_codes.displayed_field%TYPE;

17: APXPBFOR_P_SUB_UNIT_SINGULAR CONSTANT VARCHAR2(100) := 'Cent';
18: APXPBFOR_P_SUB_UNIT_PLURAL CONSTANT VARCHAR2(100) := 'Cents';
19: APXPBFOR_P_UNIT_RATIO CONSTANT NUMBER := 100;
20:
21: c_zero ap_lookup_codes.displayed_field%TYPE;
22: c_thousand ap_lookup_codes.displayed_field%TYPE;
23: c_million ap_lookup_codes.displayed_field%TYPE;
24: c_billion ap_lookup_codes.displayed_field%TYPE;
25: g_user_lang fnd_languages.nls_language%TYPE := 'junk';

Line 22: c_thousand ap_lookup_codes.displayed_field%TYPE;

18: APXPBFOR_P_SUB_UNIT_PLURAL CONSTANT VARCHAR2(100) := 'Cents';
19: APXPBFOR_P_UNIT_RATIO CONSTANT NUMBER := 100;
20:
21: c_zero ap_lookup_codes.displayed_field%TYPE;
22: c_thousand ap_lookup_codes.displayed_field%TYPE;
23: c_million ap_lookup_codes.displayed_field%TYPE;
24: c_billion ap_lookup_codes.displayed_field%TYPE;
25: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
26:

Line 23: c_million ap_lookup_codes.displayed_field%TYPE;

19: APXPBFOR_P_UNIT_RATIO CONSTANT NUMBER := 100;
20:
21: c_zero ap_lookup_codes.displayed_field%TYPE;
22: c_thousand ap_lookup_codes.displayed_field%TYPE;
23: c_million ap_lookup_codes.displayed_field%TYPE;
24: c_billion ap_lookup_codes.displayed_field%TYPE;
25: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
26:
27: TYPE num_lookupTab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 24: c_billion ap_lookup_codes.displayed_field%TYPE;

20:
21: c_zero ap_lookup_codes.displayed_field%TYPE;
22: c_thousand ap_lookup_codes.displayed_field%TYPE;
23: c_million ap_lookup_codes.displayed_field%TYPE;
24: c_billion ap_lookup_codes.displayed_field%TYPE;
25: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
26:
27: TYPE num_lookupTab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
28: g_numlookup num_lookupTab;

Line 370: from ap_lookup_codes

366: 1,p_sub_unit_singular,
367: p_sub_unit_plural)
368: ))
369: into l_currency_word
370: from ap_lookup_codes
371: where lookup_code = 'AND'
372: and lookup_type = 'NLS TRANSLATION';
373: end if;
374:

Line 389: from ap_lookup_codes

385: when no_data_found then
386:
387: select description
388: into g_numlookup(p_num)
389: from ap_lookup_codes
390: where lookup_code = to_char(p_num)
391: and lookup_type = 'NUMBERS';
392:
393: iby_debug_pub.add(debug_msg => 'Adding to lookup cache ' || p_num || ': ' || g_numlookup(p_num),

Line 456: from ap_lookup_codes lc1,

452: into c_billion,
453: c_million,
454: c_thousand,
455: c_zero
456: from ap_lookup_codes lc1,
457: ap_lookup_codes lc2,
458: ap_lookup_codes lc3,
459: ap_lookup_codes lc4
460: where lc1.lookup_code = 'BILLION'

Line 457: ap_lookup_codes lc2,

453: c_million,
454: c_thousand,
455: c_zero
456: from ap_lookup_codes lc1,
457: ap_lookup_codes lc2,
458: ap_lookup_codes lc3,
459: ap_lookup_codes lc4
460: where lc1.lookup_code = 'BILLION'
461: and lc1.lookup_type = 'NLS TRANSLATION'

Line 458: ap_lookup_codes lc3,

454: c_thousand,
455: c_zero
456: from ap_lookup_codes lc1,
457: ap_lookup_codes lc2,
458: ap_lookup_codes lc3,
459: ap_lookup_codes lc4
460: where lc1.lookup_code = 'BILLION'
461: and lc1.lookup_type = 'NLS TRANSLATION'
462: and lc2.lookup_code = 'MILLION'

Line 459: ap_lookup_codes lc4

455: c_zero
456: from ap_lookup_codes lc1,
457: ap_lookup_codes lc2,
458: ap_lookup_codes lc3,
459: ap_lookup_codes lc4
460: where lc1.lookup_code = 'BILLION'
461: and lc1.lookup_type = 'NLS TRANSLATION'
462: and lc2.lookup_code = 'MILLION'
463: and lc2.lookup_type = 'NLS TRANSLATION'