1 Package IEX_CALL_HISTORY AUTHID CURRENT_USER AS
2 /* $Header: iexhicls.pls 120.0 2004/01/24 03:18:50 appldev noship $ */
3 TYPE Interaction_Rec is RECORD(
4 Interaction_id JTF_IH_INTERACTIONS.Interaction_Id%TYPE,
5 start_date Varchar2(25) ,
6 start_time Varchar2(25) ,
7 resource_name jtf_rs_resource_extns_vl.resource_name%TYPE,
8 Disputed Varchar2(5) ,
9 Paid Varchar2(5) ,
10 Correspondence_sent Varchar2(5) ,
11 Promise_to_pay Varchar2(5) ) ;
12
13 -- Interaction pl/sql Table that is passed back to the form
14 TYPE Interaction_tbl is TABLE of Interaction_rec
15 Index By Binary_Integer ;
16
17 TYPE interaction_id_tbl IS TABLE OF
18 JTF_IH_INTERACTIONS.Interaction_Id%TYPE
19 Index By Binary_Integer ;
20
21
22 TYPE start_date_time_tbl IS TABLE OF Date
23 Index By Binary_Integer ;
24 TYPE resource_name_tbl IS TABLE OF
25 jtf_rs_resource_extns_vl.resource_name%TYPE
26 Index By Binary_Integer ;
27
28 v_interaction_id_tbl Interaction_id_tbl ;
29 v_start_date_time_tbl start_date_time_tbl ;
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,
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 ,
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 ;
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 ,
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
74 TYPE INTERACTION_CURSOR IS REF CURSOR ;
75 TYPE INTERACTION_ACTIVITY_CURSOR IS REF CURSOR ;
76
77
78 PROCEDURE QUERY_INTERACTION_RECORDS (
79 p_mode IN Varchar2,
80 p_id IN Number ,
81 P_From_Date IN Date ,
82 P_To_Date IN Date ,
83 p_Interaction_tbl IN OUT NOCOPY Interaction_Tbl,
84 p_error_code IN OUT NOCOPY Varchar2 ,
85 p_error_mesg IN OUT NOCOPY Varchar2 ) ;
86
87 PROCEDURE QUERY_ACTIVITY_RECORDS
88 (P_Interaction_id IN OUT NOCOPY Number ,
89 p_Interaction_activity_tbl IN OUT NOCOPY Interaction_Activity_Tbl,
90 p_error_code IN OUT NOCOPY Varchar2,
91 p_error_mesg IN OUT NOCOPY Varchar2) ;
92
93
94 End IEX_CALL_HISTORY ;