DBA Data[Home] [Help]

APPS.FA_UTILS_PKG dependencies on FA_LOOKUPS

Line 286: l_meaning fa_lookups.meaning%TYPE;

282: FUNCTION faxlkp_meaning(X_lookup_type IN VARCHAR2,
283: X_lookup_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
284: return VARCHAR2 is
285:
286: l_meaning fa_lookups.meaning%TYPE;
287: l_hash_value NUMBER;
288:
289: BEGIN
290: IF X_lookup_code IS NOT NULL AND

Line 304: from FA_LOOKUPS_TL T

300: ELSE
301: /*modified the following query for bug no.3876060 */
302: select T.MEANING
303: into l_meaning
304: from FA_LOOKUPS_TL T
305: where T.LANGUAGE = USERENV('LANG')
306: and T.LOOKUP_TYPE = X_lookup_type
307: and T.LOOKUP_CODE = X_lookup_code;
308:

Line 330: l_lookup_code fa_lookups.Lookup_code%TYPE;

326: FUNCTION faxlkp_code(X_lookup_type IN VARCHAR2,
327: X_meaning IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
328: return VARCHAR2 is
329:
330: l_lookup_code fa_lookups.Lookup_code%TYPE;
331: l_hash_value NUMBER;
332:
333: BEGIN
334: IF X_Meaning IS NOT NULL AND

Line 347: FROM FA_LOOKUPS_TL T

343: ELSE
344: /* modified the following query for bug no.3876060 */
345: SELECT T.LOOKUP_CODE
346: into l_lookup_code
347: FROM FA_LOOKUPS_TL T
348: WHERE T.LANGUAGE = USERENV('LANG')
349: AND T.LOOKUP_TYPE = X_lookup_type
350: AND T.MEANING = X_meaning;
351: