APPS.IEX_CALL_HISTORY dependencies on JTF_IH_ACTIONS_VL

Line 20: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE) ;

16: ---------------------------------------------------------------------
17:
18: Procedure Get_Action_Description
19: (p_Action_id IN Number,
20: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE) ;
21:
22: Procedure Get_OUTCOME_Description
23: (p_Outcome_Id IN Number,
24: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE) ;

Line 325: -- description from JTF_IH_ACTIONS_VL view

321: ---------------------------------------------------------------------
322: -- GET_ACTION_DESCRIPTION
323: ---------------------------------------------------------------------
324: -- Takes Action_id as parameter and returns the corresponding
325: -- description from JTF_IH_ACTIONS_VL view
326: ---------------------------------------------------------------------
327: Procedure Get_Action_Description
328: (p_Action_id IN Number,
329: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE)

Line 329: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE)

325: -- description from JTF_IH_ACTIONS_VL view
326: ---------------------------------------------------------------------
327: Procedure Get_Action_Description
328: (p_Action_id IN Number,
329: p_Action_Desc OUT NOCOPY JTF_IH_ACTIONS_VL.Short_Description%TYPE)
330: IS
331: v_sql Varchar2(100) ;
332: Begin
333: v_sql :=

Line 335: from JTF_IH_ACTIONS_VL

331: v_sql Varchar2(100) ;
332: Begin
333: v_sql :=
334: 'Select Short_Description
335: from JTF_IH_ACTIONS_VL
336: where Action_id = :Action_id' ;
337:
338: EXECUTE IMMEDIATE v_sql
339: INTO p_action_desc

Line 379: -- description from JTF_IH_ACTIONS_VL view

375: ---------------------------------------------------------------------
376: -- GET_Outcome_DESCRIPTION
377: ---------------------------------------------------------------------
378: -- Takes Action_id as parameter and returns the corresponding
379: -- description from JTF_IH_ACTIONS_VL view
380: ---------------------------------------------------------------------
381: Procedure Get_OUTCOME_Description
382: (p_Outcome_Id IN Number,
383: p_Outcome_Desc OUT NOCOPY JTF_IH_OUTCOMES_VL.Short_Description%TYPE)