DBA Data[Home] [Help]

APPS.IEX_CALL_HISTORY dependencies on JTF_IH_RESULTS_VL

Line 32: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE) ;

28: p_REASON_Desc OUT NOCOPY JTF_IH_REASONS_VL.Short_Description%TYPE) ;
29:
30: Procedure Get_result_description
31: (p_result_id IN Number,
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) ;

Line 435: -- description from JTF_IH_RESULTS_VL view

431: ---------------------------------------------------------------------
432: -- GET_RESULT_DESCRIPTION
433: ---------------------------------------------------------------------
434: -- Takes result_id as parameter and returns the corresponding
435: -- description from JTF_IH_RESULTS_VL view
436: ---------------------------------------------------------------------
437: Procedure Get_result_description
438: (p_result_id IN Number,
439: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE)

Line 439: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE)

435: -- description from JTF_IH_RESULTS_VL view
436: ---------------------------------------------------------------------
437: Procedure Get_result_description
438: (p_result_id IN Number,
439: p_result_Desc OUT NOCOPY JTF_IH_RESULTS_VL.Short_Description%TYPE)
440: IS
441: v_sql Varchar2(100) ;
442: Begin
443: v_sql :=

Line 445: from JTF_IH_RESULTS_VL

441: v_sql Varchar2(100) ;
442: Begin
443: v_sql :=
444: 'Select Short_Description
445: from JTF_IH_RESULTS_VL
446: where result_id = :result_id' ;
447:
448: EXECUTE IMMEDIATE v_sql
449: INTO p_result_desc