DBA Data[Home] [Help]

APPS.XLA_LOOKUPS_PKG dependencies on XLA_UTILITY_PKG

Line 39: xla_utility_pkg.trace('> xla_lookups_pkg.get_meaning' , 10);

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:

Line 41: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);

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

Line 42: xla_utility_pkg.trace('Lookup_code = '||p_lookup_code , 20);

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

Line 51: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);

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;

Line 53: xla_utility_pkg.trace('< xla_lookups_pkg.get_meaning' , 10);

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

Line 85: xla_utility_pkg.trace('> xla_lookups_pkg.get_lookuptype_meaning' , 10);

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:

Line 87: xla_utility_pkg.trace('Lookup type = '||p_lookup_type , 20);

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

Line 88: xla_utility_pkg.trace('Lookup_code = '||p_view_application_id , 20);

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

Line 97: xla_utility_pkg.trace('Meaning = '||l_meaning , 20);

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;

Line 99: xla_utility_pkg.trace('< xla_lookups_pkg.get_lookuptype_meaning' , 10);

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