APPS.IEX_CALL_HISTORY dependencies on JTF_OBJECTS_VL

Line 36: p_object_name OUT NOCOPY JTF_OBJECTS_VL.name%TYPE) ;

32: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE) ;
33:
34: Procedure Get_Object_Name
35: (p_doc_ref IN Varchar2,
36: p_object_name OUT NOCOPY JTF_OBJECTS_VL.name%TYPE) ;
37: ---------------------------------------------------------------------
38: -- QUERY_INTERACTION_RECORDS
39: ---------------------------------------------------------------------
40: -- Queries and returns history records for the passed date range

Line 353: -- description from JTF_OBJECTS_VL view

349: ---------------------------------------------------------------------
350: -- GET_OBJECT_NAME
351: ---------------------------------------------------------------------
352: -- Takes Object Code as parameter and returns the corresponding
353: -- description from JTF_OBJECTS_VL view
354: ---------------------------------------------------------------------
355: Procedure Get_Object_Name
356: (p_doc_ref IN Varchar2,
357: p_object_name OUT NOCOPY JTF_OBJECTS_VL.name%TYPE)

Line 357: p_object_name OUT NOCOPY JTF_OBJECTS_VL.name%TYPE)

353: -- description from JTF_OBJECTS_VL view
354: ---------------------------------------------------------------------
355: Procedure Get_Object_Name
356: (p_doc_ref IN Varchar2,
357: p_object_name OUT NOCOPY JTF_OBJECTS_VL.name%TYPE)
358: IS
359: v_sql Varchar2(200) ;
360: Begin
361: v_sql :=

Line 363: from JTF_Objects_vl

359: v_sql Varchar2(200) ;
360: Begin
361: v_sql :=
362: 'Select Name
363: from JTF_Objects_vl
364: where object_code = :p_doc_ref' ;
365:
366: EXECUTE IMMEDIATE v_sql
367: INTO p_object_name