35:
36: l_meaning VARCHAR2(80);
37:
38: BEGIN
39: xla_utility_pkg.trace('> xla_lookups_pkg.get_meaning' , 10);
40:
41: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
42: xla_utility_pkg.trace('Lookup_code = '||p_lookup_code , 20);
43:
37:
38: BEGIN
39: xla_utility_pkg.trace('> xla_lookups_pkg.get_meaning' , 10);
40:
41: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
42: xla_utility_pkg.trace('Lookup_code = '||p_lookup_code , 20);
43:
44: SELECT meaning
45: INTO l_meaning
38: BEGIN
39: xla_utility_pkg.trace('> xla_lookups_pkg.get_meaning' , 10);
40:
41: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
42: xla_utility_pkg.trace('Lookup_code = '||p_lookup_code , 20);
43:
44: SELECT meaning
45: INTO l_meaning
46: FROM xla_lookups
47: WHERE lookup_type = p_lookup_type
48: AND lookup_code = p_lookup_code
49: ;
50:
51: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);
52:
53: xla_utility_pkg.trace('< xla_lookups_pkg.get_meaning' , 10);
54:
55: RETURN l_meaning;
49: ;
50:
51: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);
52:
53: xla_utility_pkg.trace('< xla_lookups_pkg.get_meaning' , 10);
54:
55: RETURN l_meaning;
56:
57: EXCEPTION
81:
82: l_meaning VARCHAR2(80);
83:
84: BEGIN
85: xla_utility_pkg.trace('> xla_lookups_pkg.get_lookuptype_meaning' , 10);
86:
87: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
88: xla_utility_pkg.trace('Lookup_code = '||p_view_application_id , 20);
89:
83:
84: BEGIN
85: xla_utility_pkg.trace('> xla_lookups_pkg.get_lookuptype_meaning' , 10);
86:
87: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
88: xla_utility_pkg.trace('Lookup_code = '||p_view_application_id , 20);
89:
90: SELECT meaning
91: INTO l_meaning
84: BEGIN
85: xla_utility_pkg.trace('> xla_lookups_pkg.get_lookuptype_meaning' , 10);
86:
87: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);
88: xla_utility_pkg.trace('Lookup_code = '||p_view_application_id , 20);
89:
90: SELECT meaning
91: INTO l_meaning
92: FROM fnd_lookup_types_vl
93: WHERE lookup_type = p_lookup_type
94: AND view_application_id = p_view_application_id
95: ;
96:
97: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);
98:
99: xla_utility_pkg.trace('< xla_lookups_pkg.get_lookuptype_meaning' , 10);
100:
101: RETURN l_meaning;
95: ;
96:
97: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);
98:
99: xla_utility_pkg.trace('< xla_lookups_pkg.get_lookuptype_meaning' , 10);
100:
101: RETURN l_meaning;
102:
103: EXCEPTION