APPS.ARI_UTILITIES dependencies on AR_LOOKUPS

Line 357: l_meaning ar_lookups.meaning%TYPE;

353: *=======================================================================*/
354: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
355: p_lookup_code IN VARCHAR2)
356: RETURN VARCHAR2 IS
357: l_meaning ar_lookups.meaning%TYPE;
358: l_hash_value NUMBER;
359: l_procedure_name VARCHAR2(50);
360: l_debug_info VARCHAR2(200);
361:

Line 379: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN

375: p_lookup_type||'@*?'||p_lookup_code||USERENV('LANG'),
376: 1000,
377: 25000);
378:
379: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
380: l_meaning := pg_ar_lookups_rec(l_hash_value);
381: ELSE
382:
383: SELECT meaning

Line 380: l_meaning := pg_ar_lookups_rec(l_hash_value);

376: 1000,
377: 25000);
378:
379: IF pg_ar_lookups_rec.EXISTS(l_hash_value) THEN
380: l_meaning := pg_ar_lookups_rec(l_hash_value);
381: ELSE
382:
383: SELECT meaning
384: INTO l_meaning

Line 385: FROM ar_lookups

381: ELSE
382:
383: SELECT meaning
384: INTO l_meaning
385: FROM ar_lookups
386: WHERE lookup_type = p_lookup_type
387: AND lookup_code = p_lookup_code;
388:
389: ----------------------------------------------------------------------------------------

Line 396: pg_ar_lookups_rec(l_hash_value) := l_meaning;

392: IF (PG_DEBUG = 'Y') THEN
393: arp_standard.debug(l_debug_info);
394: END IF;
395:
396: pg_ar_lookups_rec(l_hash_value) := l_meaning;
397:
398: END IF;
399:
400: END IF;