APPS.IEX_CALL_HISTORY dependencies on JTF_IH_ACTIVITIES

Line 34: Interaction_Id JTF_IH_ACTIVITIES.Interaction_id%TYPE ,

30: v_resource_name_tbl resource_name_tbl ;
31:
32: -- Actual History Activity PL/SQl Record that is passed back to the Form
33: TYPE Interaction_Activity_Rec is RECORD(
34: Interaction_Id JTF_IH_ACTIVITIES.Interaction_id%TYPE ,
35: Action_id JTF_IH_ACTIVITIES.Action_Id%TYPE ,
36: Action_Description JTF_IH_ACTIONS_TL.Short_Description%TYPE,
37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,
38: Outcome_Description JTF_IH_OUTCOMES_TL.Short_Description%TYPE,

Line 35: Action_id JTF_IH_ACTIVITIES.Action_Id%TYPE ,

31:
32: -- Actual History Activity PL/SQl Record that is passed back to the Form
33: TYPE Interaction_Activity_Rec is RECORD(
34: Interaction_Id JTF_IH_ACTIVITIES.Interaction_id%TYPE ,
35: Action_id JTF_IH_ACTIVITIES.Action_Id%TYPE ,
36: Action_Description JTF_IH_ACTIONS_TL.Short_Description%TYPE,
37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,
38: Outcome_Description JTF_IH_OUTCOMES_TL.Short_Description%TYPE,
39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,

Line 37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,

33: TYPE Interaction_Activity_Rec is RECORD(
34: Interaction_Id JTF_IH_ACTIVITIES.Interaction_id%TYPE ,
35: Action_id JTF_IH_ACTIVITIES.Action_Id%TYPE ,
36: Action_Description JTF_IH_ACTIONS_TL.Short_Description%TYPE,
37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,
38: Outcome_Description JTF_IH_OUTCOMES_TL.Short_Description%TYPE,
39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,
40: Reason_Description JTF_IH_REASONS_TL.Short_Description%TYPE,
41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,

Line 39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,

35: Action_id JTF_IH_ACTIVITIES.Action_Id%TYPE ,
36: Action_Description JTF_IH_ACTIONS_TL.Short_Description%TYPE,
37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,
38: Outcome_Description JTF_IH_OUTCOMES_TL.Short_Description%TYPE,
39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,
40: Reason_Description JTF_IH_REASONS_TL.Short_Description%TYPE,
41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,
42: Result_Description JTF_IH_RESULTS_TL.Short_Description%TYPE,
43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,

Line 41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,

37: OutCome_Id JTF_IH_ACTIVITIES.Outcome_id%TYPE ,
38: Outcome_Description JTF_IH_OUTCOMES_TL.Short_Description%TYPE,
39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,
40: Reason_Description JTF_IH_REASONS_TL.Short_Description%TYPE,
41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,
42: Result_Description JTF_IH_RESULTS_TL.Short_Description%TYPE,
43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,
44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,

Line 43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,

39: Reason_id JTF_IH_ACTIVITIES.Reason_Id%TYPE ,
40: Reason_Description JTF_IH_REASONS_TL.Short_Description%TYPE,
41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,
42: Result_Description JTF_IH_RESULTS_TL.Short_Description%TYPE,
43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,
44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,

Line 44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,

40: Reason_Description JTF_IH_REASONS_TL.Short_Description%TYPE,
41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,
42: Result_Description JTF_IH_RESULTS_TL.Short_Description%TYPE,
43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,
44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,

Line 45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,

41: Result_id JTF_IH_ACTIVITIES.Result_Id%TYPE ,
42: Result_Description JTF_IH_RESULTS_TL.Short_Description%TYPE,
43: Duration JTF_IH_ACTIVITIES.Duration%TYPE ,
44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,

Line 48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,

44: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
50: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
51: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE) ;
52:

Line 49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,

45: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
50: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
51: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE) ;
52:
53: -- History Activity pl/sql Table that is passed back to the form

Line 50: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,

46: Object_Name JTF_OBJECTS_VL.Name%TYPE ,
47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
50: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
51: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE) ;
52:
53: -- History Activity pl/sql Table that is passed back to the form
54: TYPE Interaction_Activity_Tbl is TABLE of Interaction_Activity_Rec

Line 51: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE) ;

47: Object_Description JTF_OBJECTS_VL.Description%TYPE ,
48: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
49: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
50: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
51: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE) ;
52:
53: -- History Activity pl/sql Table that is passed back to the form
54: TYPE Interaction_Activity_Tbl is TABLE of Interaction_Activity_Rec
55: Index By Binary_Integer ;

Line 59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,

55: Index By Binary_Integer ;
56:
57: -- Internal Selection Record, used to build the main activity record
58: TYPE Activity_Select_rec IS RECORD(
59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,
60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,

Line 60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,

56:
57: -- Internal Selection Record, used to build the main activity record
58: TYPE Activity_Select_rec IS RECORD(
59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,
60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,

Line 61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,

57: -- Internal Selection Record, used to build the main activity record
58: TYPE Activity_Select_rec IS RECORD(
59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,
60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,

Line 62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,

58: TYPE Activity_Select_rec IS RECORD(
59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,
60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,

Line 63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,

59: Interaction_id JTF_IH_ACTIVITIES.interaction_id%TYPE ,
60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,

Line 64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,

60: Activity_Id JTF_IH_ACTIVITIES.activity_id%TYPE ,
61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,

Line 65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,

61: Action_Id JTF_IH_ACTIVITIES.action_id%TYPE ,
62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,

Line 66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,

62: OutCome_ID JTF_IH_ACTIVITIES.outcome_id%TYPE ,
63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,

Line 67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,

63: Reason_ID JTF_IH_ACTIVITIES.reason_id%TYPE ,
64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;

Line 68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,

64: Result_Id JTF_IH_ACTIVITIES.result_id%TYPE ,
65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;
72:

Line 69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,

65: Duration JTF_IH_ACTIVITIES.duration%TYPE ,
66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;
72:
73: -- Ref cursors to select the History and Activity Data

Line 70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,

66: Doc_Id JTF_IH_ACTIVITIES.doc_id%TYPE ,
67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;
72:
73: -- Ref cursors to select the History and Activity Data
74: TYPE INTERACTION_CURSOR IS REF CURSOR ;

Line 71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;

67: Doc_ref JTF_IH_ACTIVITIES.doc_ref%TYPE ,
68: Object_Id JTF_IH_ACTIVITIES.Object_Id%TYPE ,
69: Object_Type JTF_IH_ACTIVITIES.Object_Type%TYPE ,
70: Source_Code_Id JTF_IH_ACTIVITIES.Source_Code_Id%TYPE ,
71: Source_Code_Type JTF_IH_ACTIVITIES.Source_Code%TYPE ) ;
72:
73: -- Ref cursors to select the History and Activity Data
74: TYPE INTERACTION_CURSOR IS REF CURSOR ;
75: TYPE INTERACTION_ACTIVITY_CURSOR IS REF CURSOR ;