7: g_glb_name_tl ff_globals_f_tl.global_name%type;
8: --
9: procedure translate
10: is
11: l_upper_limit hr_lookups.meaning%type;
12: l_lower_limit hr_lookups.meaning%type;
13: l_max hr_lookups.meaning%type;
14: l_min hr_lookups.meaning%type;
15: --
8: --
9: procedure translate
10: is
11: l_upper_limit hr_lookups.meaning%type;
12: l_lower_limit hr_lookups.meaning%type;
13: l_max hr_lookups.meaning%type;
14: l_min hr_lookups.meaning%type;
15: --
16: l_user_name ff_database_items.user_name%type;
9: procedure translate
10: is
11: l_upper_limit hr_lookups.meaning%type;
12: l_lower_limit hr_lookups.meaning%type;
13: l_max hr_lookups.meaning%type;
14: l_min hr_lookups.meaning%type;
15: --
16: l_user_name ff_database_items.user_name%type;
17: l_tl_user_name ff_database_items_tl.translated_user_name%type;
10: is
11: l_upper_limit hr_lookups.meaning%type;
12: l_lower_limit hr_lookups.meaning%type;
13: l_max hr_lookups.meaning%type;
14: l_min hr_lookups.meaning%type;
15: --
16: l_user_name ff_database_items.user_name%type;
17: l_tl_user_name ff_database_items_tl.translated_user_name%type;
18: --
78: function decode_lookup(
79: p_lookup_type in varchar2,
80: p_lookup_code in varchar2) return varchar2
81: is
82: l_meaning hr_lookups.meaning%type;
83: begin
84: -- need to refer to fnd_lookup_values
85: -- because JA japanese dbi suffix should be derived
86: -- when adpatch runs with US lang.