DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_LOOKUP_VALUES

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

210: p_Security_Group_Id IN NUMBER DEFAULT 0)
211: RETURN VARCHAR2 IS
212:
213: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
214: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

Line 223: FROM Fnd_Lookup_Values Flv

219:
220: -- this cursor is to get looup_meaning under some lookup_code
221: CURSOR c_Lookup IS
222: SELECT Flv.Lookup_Code
223: FROM Fnd_Lookup_Values Flv
224: WHERE Flv.LANGUAGE = Userenv('LANG')
225: AND Flv.Lookup_Type = p_Lookup_Type
226: AND Flv.Meaning = p_Lookup_Meaning
227: AND Flv.View_Application_Id = p_View_Application_Id

Line 1536: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1532: l_Result BOOLEAN;
1533: l_Submit_Fail_Module VARCHAR2(100);
1534: l_Execution_Fail_Module VARCHAR2(100);
1535: l_Post_Con_Req_Id NUMBER := 0;
1536: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1537: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1538: l_Request_Submit_Fail EXCEPTION;
1539: l_Request_Execution_Fail EXCEPTION;
1540: l_Post_Fail EXCEPTION;

Line 1537: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1533: l_Submit_Fail_Module VARCHAR2(100);
1534: l_Execution_Fail_Module VARCHAR2(100);
1535: l_Post_Con_Req_Id NUMBER := 0;
1536: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1537: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1538: l_Request_Submit_Fail EXCEPTION;
1539: l_Request_Execution_Fail EXCEPTION;
1540: l_Post_Fail EXCEPTION;
1541: