APPS.JA_CN_UTILITY dependencies on FND_LOOKUP_VALUES

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

407: --===========================================================================
408: FUNCTION Get_Lookup_Meaning(p_Lookup_Code IN VARCHAR2) RETURN VARCHAR2 IS
409:
410: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
411: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

Line 420: FROM Fnd_Lookup_Values Flv

416:
417: -- this cursor is to get looup_meaning under some lookup_code
418: CURSOR c_Lookup IS
419: SELECT Flv.Meaning
420: FROM Fnd_Lookup_Values Flv
421: WHERE Flv.LANGUAGE = Userenv('LANG')
422: AND Flv.Lookup_Type = 'JA_CN_DUPOBJECTS_TOKENS'
423: AND Flv.View_Application_Id = 0
424: AND Flv.Security_Group_Id = 0

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

653: p_Security_Group_Id IN NUMBER DEFAULT 0)
654: RETURN VARCHAR2 IS
655:
656: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
657: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
660: --l_statement_level NUMBER := fnd_log.level_statement;
661: --l_exception_level NUMBER := fnd_log.level_exception;

Line 666: FROM Fnd_Lookup_Values Flv

662:
663: -- this cursor is to get looup_meaning under some lookup_code
664: CURSOR c_Lookup IS
665: SELECT Flv.Lookup_Code
666: FROM Fnd_Lookup_Values Flv
667: WHERE Flv.LANGUAGE = Userenv('LANG')
668: AND Flv.Lookup_Type = p_Lookup_Type
669: AND Flv.Meaning = p_Lookup_Meaning
670: AND Flv.View_Application_Id = p_View_Application_Id

Line 1636: FROM fnd_lookup_values

1632: END IF; --l_proc_level>=l_dbg_level
1633:
1634: SELECT tag
1635: INTO ln_xml_encoding
1636: FROM fnd_lookup_values
1637: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
1638: AND lookup_code =
1639: SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.') + 1)
1640: AND LANGUAGE = 'US';

Line 2133: lv_kookup_meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;

2129: ,pv_from_period IN VARCHAR2
2130: ,pv_to_period IN VARCHAR2)
2131: RETURN VARCHAR2
2132: IS
2133: lv_kookup_meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
2134: lv_filename VARCHAR2(200);
2135: ln_accounting_year_len NUMBER;
2136: ln_from_month NUMBER;
2137: ln_to_month NUMBER;

Line 2147: fnd_lookup_values flv

2143: CURSOR lookup_cur IS
2144: SELECT
2145: flv.meaning
2146: FROM
2147: fnd_lookup_values flv
2148: WHERE flv.LANGUAGE = Userenv('LANG')
2149: AND flv.lookup_type = 'JA_CN_OUTPUTFILE_PREFIX'
2150: AND flv.view_application_Id = 0
2151: AND flv.security_group_id = 0