eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;

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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;

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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;
27: c_and ap_lookup_codes.displayed_field%TYPE;

Line 24: c_millions 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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;
27: c_and ap_lookup_codes.displayed_field%TYPE;
28: g_user_lang fnd_languages.nls_language%TYPE := 'junk';

Line 25: c_billion ap_lookup_codes.displayed_field%TYPE;

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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;
27: c_and ap_lookup_codes.displayed_field%TYPE;
28: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
29:

Line 26: c_billions 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_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;
27: c_and ap_lookup_codes.displayed_field%TYPE;
28: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
29:
30: TYPE num_lookupTab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 27: c_and ap_lookup_codes.displayed_field%TYPE;

23: c_million ap_lookup_codes.displayed_field%TYPE;
24: c_millions ap_lookup_codes.displayed_field%TYPE;
25: c_billion ap_lookup_codes.displayed_field%TYPE;
26: c_billions ap_lookup_codes.displayed_field%TYPE;
27: c_and ap_lookup_codes.displayed_field%TYPE;
28: g_user_lang fnd_languages.nls_language%TYPE := 'junk';
29:
30: TYPE num_lookupTab IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
31: g_numlookup num_lookupTab;

Line 386: from ap_lookup_codes

382: -1,null,
383: p_sub_unit_plural)
384: ))
385: into l_currency_word
386: from ap_lookup_codes
387: where lookup_code = 'AND'
388: and lookup_type = 'NLS TRANSLATION';
389:
390: else

Line 408: from ap_lookup_codes

404: 1,p_sub_unit_singular,
405: p_sub_unit_plural)
406: ))
407: into l_currency_word
408: from ap_lookup_codes
409: where lookup_code = 'AND'
410: and lookup_type = 'NLS TRANSLATION';
411: end if;
412:

Line 427: from ap_lookup_codes

423: when no_data_found then
424:
425: select description
426: into g_numlookup(p_num)
427: from ap_lookup_codes
428: where lookup_code = to_char(p_num)
429: and lookup_type = 'NUMBERS';
430:
431: iby_debug_pub.add(debug_msg => 'Adding to lookup cache ' || p_num || ': ' || g_numlookup(p_num),

Line 501: from ap_lookup_codes lc1,

497: c_millions,
498: c_thousand,
499: c_zero,
500: c_and
501: from ap_lookup_codes lc1,
502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,

Line 502: ap_lookup_codes lc2,

498: c_thousand,
499: c_zero,
500: c_and
501: from ap_lookup_codes lc1,
502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,

Line 503: ap_lookup_codes lc3,

499: c_zero,
500: c_and
501: from ap_lookup_codes lc1,
502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,
507: ap_lookup_codes lc7

Line 504: ap_lookup_codes lc4,

500: c_and
501: from ap_lookup_codes lc1,
502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,
507: ap_lookup_codes lc7
508: where lc1.lookup_code = 'BILLION'

Line 505: ap_lookup_codes lc5,

501: from ap_lookup_codes lc1,
502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,
507: ap_lookup_codes lc7
508: where lc1.lookup_code = 'BILLION'
509: and lc1.lookup_type = 'NLS TRANSLATION'

Line 506: ap_lookup_codes lc6,

502: ap_lookup_codes lc2,
503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,
507: ap_lookup_codes lc7
508: where lc1.lookup_code = 'BILLION'
509: and lc1.lookup_type = 'NLS TRANSLATION'
510: and lc2.lookup_code = 'MILLION'

Line 507: ap_lookup_codes lc7

503: ap_lookup_codes lc3,
504: ap_lookup_codes lc4,
505: ap_lookup_codes lc5,
506: ap_lookup_codes lc6,
507: ap_lookup_codes lc7
508: where lc1.lookup_code = 'BILLION'
509: and lc1.lookup_type = 'NLS TRANSLATION'
510: and lc2.lookup_code = 'MILLION'
511: and lc2.lookup_type = 'NLS TRANSLATION'