DBA Data[Home] [Help]

APPS.PAY_CA_AMT_IN_WORDS dependencies on AP_LOOKUP_CODES

Line 50: c_zero ap_lookup_codes.displayed_field%TYPE;

46: p_language IN VARCHAR2,
47: p_denomination IN VARCHAR2,
48: p_sub_denomination IN VARCHAR2) return varchar2 is
49:
50: c_zero ap_lookup_codes.displayed_field%TYPE;
51: c_thousand ap_lookup_codes.displayed_field%TYPE;
52: c_million ap_lookup_codes.displayed_field%TYPE;
53: c_billion ap_lookup_codes.displayed_field%TYPE;
54: number_too_large exception;

Line 51: c_thousand ap_lookup_codes.displayed_field%TYPE;

47: p_denomination IN VARCHAR2,
48: p_sub_denomination IN VARCHAR2) return varchar2 is
49:
50: c_zero ap_lookup_codes.displayed_field%TYPE;
51: c_thousand ap_lookup_codes.displayed_field%TYPE;
52: c_million ap_lookup_codes.displayed_field%TYPE;
53: c_billion ap_lookup_codes.displayed_field%TYPE;
54: number_too_large exception;
55: abs_num varchar2(25) := to_char(in_numeral,'999999999990.00');

Line 52: c_million ap_lookup_codes.displayed_field%TYPE;

48: p_sub_denomination IN VARCHAR2) return varchar2 is
49:
50: c_zero ap_lookup_codes.displayed_field%TYPE;
51: c_thousand ap_lookup_codes.displayed_field%TYPE;
52: c_million ap_lookup_codes.displayed_field%TYPE;
53: c_billion ap_lookup_codes.displayed_field%TYPE;
54: number_too_large exception;
55: abs_num varchar2(25) := to_char(in_numeral,'999999999990.00');
56: numeral integer := abs(in_numeral);

Line 53: c_billion ap_lookup_codes.displayed_field%TYPE;

49:
50: c_zero ap_lookup_codes.displayed_field%TYPE;
51: c_thousand ap_lookup_codes.displayed_field%TYPE;
52: c_million ap_lookup_codes.displayed_field%TYPE;
53: c_billion ap_lookup_codes.displayed_field%TYPE;
54: number_too_large exception;
55: abs_num varchar2(25) := to_char(in_numeral,'999999999990.00');
56: numeral integer := abs(in_numeral);
57: max_digit integer := 12; -- for numbers less than a trillion