APPS.JA_CN_UTILITY dependencies on FND_LOOKUP_VALUES

Line 401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;

397: --===========================================================================
398: FUNCTION Get_Lookup_Meaning(p_Lookup_Code IN VARCHAR2) RETURN VARCHAR2 IS
399:
400: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

Line 410: FROM Fnd_Lookup_Values Flv

406:
407: -- this cursor is to get looup_meaning under some lookup_code
408: CURSOR c_Lookup IS
409: SELECT Flv.Meaning
410: FROM Fnd_Lookup_Values Flv
411: WHERE Flv.LANGUAGE = Userenv('LANG')
412: AND Flv.Lookup_Type = 'JA_CN_DUPOBJECTS_TOKENS'
413: AND Flv.View_Application_Id = 0
414: AND Flv.Security_Group_Id = 0

Line 641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;

637: p_Security_Group_Id IN NUMBER DEFAULT 0)
638: RETURN VARCHAR2 IS
639:
640: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
644: --l_statement_level NUMBER := fnd_log.level_statement;
645: --l_exception_level NUMBER := fnd_log.level_exception;

Line 650: FROM Fnd_Lookup_Values Flv

646:
647: -- this cursor is to get looup_meaning under some lookup_code
648: CURSOR c_Lookup IS
649: SELECT Flv.Lookup_Code
650: FROM Fnd_Lookup_Values Flv
651: WHERE Flv.LANGUAGE = Userenv('LANG')
652: AND Flv.Lookup_Type = p_Lookup_Type
653: AND Flv.Meaning = p_Lookup_Meaning
654: AND Flv.View_Application_Id = p_View_Application_Id