APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_LOOKUPS

Line 2014: l_meaning ar_lookups.meaning%TYPE;

2010:
2011: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
2012: p_lookup_code IN VARCHAR2)
2013: RETURN VARCHAR2 IS
2014: l_meaning ar_lookups.meaning%TYPE;
2015: l_hash_value NUMBER;
2016: BEGIN
2017: IF p_lookup_code IS NOT NULL AND
2018: p_lookup_type IS NOT NULL THEN

Line 2025: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN

2021: p_lookup_type||'@*?'||p_lookup_code,
2022: 1000,
2023: 25000);
2024:
2025: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
2026: l_meaning := pg_ar_lookups_rec(l_hash_value);
2027: ELSE
2028:
2029: SELECT meaning

Line 2026: l_meaning := pg_ar_lookups_rec(l_hash_value);

2022: 1000,
2023: 25000);
2024:
2025: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
2026: l_meaning := pg_ar_lookups_rec(l_hash_value);
2027: ELSE
2028:
2029: SELECT meaning
2030: INTO l_meaning

Line 2031: FROM ar_lookups

2027: ELSE
2028:
2029: SELECT meaning
2030: INTO l_meaning
2031: FROM ar_lookups
2032: WHERE lookup_type = p_lookup_type
2033: AND lookup_code = p_lookup_code ;
2034:
2035: pg_ar_lookups_rec(l_hash_value) := l_meaning;

Line 2035: pg_ar_lookups_rec(l_hash_value) := l_meaning;

2031: FROM ar_lookups
2032: WHERE lookup_type = p_lookup_type
2033: AND lookup_code = p_lookup_code ;
2034:
2035: pg_ar_lookups_rec(l_hash_value) := l_meaning;
2036:
2037: END IF;
2038:
2039: END IF;