APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_LOOKUP_VALUES

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

229: p_Security_Group_Id IN NUMBER DEFAULT 0)
230: RETURN VARCHAR2 IS
231:
232: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
233: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

Line 242: FROM Fnd_Lookup_Values Flv

238:
239: -- this cursor is to get looup_meaning under some lookup_code
240: CURSOR c_Lookup IS
241: SELECT Flv.Lookup_Code
242: FROM Fnd_Lookup_Values Flv
243: WHERE Flv.LANGUAGE = Userenv('LANG')
244: AND Flv.Lookup_Type = p_Lookup_Type
245: AND Flv.Meaning = p_Lookup_Meaning
246: AND Flv.View_Application_Id = p_View_Application_Id

Line 490: FROM FND_LOOKUP_VALUES FLV

486: --Get COA segments and their assocaiated subsidiary segments defined in subsidiary account source form
487: CURSOR c_sub_coa_segment IS
488: SELECT NULL CONTEXT_CODE,
489: FLV.LOOKUP_CODE SUBSIDIARY_SEGMENT_CODE
490: FROM FND_LOOKUP_VALUES FLV
491: WHERE FLV.LOOKUP_TYPE = 'JA_CN_SUB_ACC_SEGMENT'
492: AND FLV.LANGUAGE = USERENV('LANG')
493: AND NOT EXISTS(
494: SELECT * FROM JA_CN_SUB_ACC_MAPPING SAM,

Line 1955: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1951: l_Result BOOLEAN;
1952: l_Submit_Fail_Module VARCHAR2(100);
1953: l_Execution_Fail_Module VARCHAR2(100);
1954: l_Post_Con_Req_Id NUMBER := 0;
1955: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1956: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1957: l_Request_Submit_Fail EXCEPTION;
1958: l_Request_Execution_Fail EXCEPTION;
1959: l_Post_Fail EXCEPTION;

Line 1956: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1952: l_Submit_Fail_Module VARCHAR2(100);
1953: l_Execution_Fail_Module VARCHAR2(100);
1954: l_Post_Con_Req_Id NUMBER := 0;
1955: l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1956: l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1957: l_Request_Submit_Fail EXCEPTION;
1958: l_Request_Execution_Fail EXCEPTION;
1959: l_Post_Fail EXCEPTION;
1960: --Begin: Chaoqun updated for CNAOV2 on 01-20-2010