APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_LOOKUPS

Line 1924: l_meaning ar_lookups.meaning%TYPE;

1920:
1921: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
1922: p_lookup_code IN VARCHAR2)
1923: RETURN VARCHAR2 IS
1924: l_meaning ar_lookups.meaning%TYPE;
1925: l_hash_value NUMBER;
1926: BEGIN
1927: IF p_lookup_code IS NOT NULL AND
1928: p_lookup_type IS NOT NULL THEN

Line 1935: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN

1931: p_lookup_type||'@*?'||p_lookup_code,
1932: 1000,
1933: 25000);
1934:
1935: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
1936: l_meaning := pg_ar_lookups_rec(l_hash_value);
1937: ELSE
1938:
1939: SELECT meaning

Line 1936: l_meaning := pg_ar_lookups_rec(l_hash_value);

1932: 1000,
1933: 25000);
1934:
1935: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
1936: l_meaning := pg_ar_lookups_rec(l_hash_value);
1937: ELSE
1938:
1939: SELECT meaning
1940: INTO l_meaning

Line 1941: FROM ar_lookups

1937: ELSE
1938:
1939: SELECT meaning
1940: INTO l_meaning
1941: FROM ar_lookups
1942: WHERE lookup_type = p_lookup_type
1943: AND lookup_code = p_lookup_code ;
1944:
1945: pg_ar_lookups_rec(l_hash_value) := l_meaning;

Line 1945: pg_ar_lookups_rec(l_hash_value) := l_meaning;

1941: FROM ar_lookups
1942: WHERE lookup_type = p_lookup_type
1943: AND lookup_code = p_lookup_code ;
1944:
1945: pg_ar_lookups_rec(l_hash_value) := l_meaning;
1946:
1947: END IF;
1948:
1949: END IF;