1 PACKAGE IEC_RETURNS_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECVRETS.pls 115.14 2004/05/10 22:57:20 jezhu ship $ */
3
4 -- statement string holders
5
6 L_ADD_ENTRY_STMT VARCHAR2(2000);
7
8 L_UPDATE_ALL_STMT VARCHAR2(2000);
9
10 L_UPDATE_SUBSET_STMT VARCHAR2(2000);
11
12 TYPE t_outcome IS VARRAY(21) OF NUMBER(10);
13 TYPE t_time IS VARRAY(21) OF DATE;
14
15 -- Sub-Program Unit Declarations
16
17 PROCEDURE ADD_ENTRY
18 (P_LIST_ENTRY_ID IN NUMBER
19 ,P_LIST_HEADER_ID IN NUMBER
20 ,P_SUBSET_ID IN NUMBER DEFAULT 0
21 ,P_CPN_SCHEDULE_ID IN NUMBER DEFAULT 0
22 ,P_OUTCOME_ID IN NUMBER
23 ,P_REASON_ID IN NUMBER
24 ,P_RESULT_ID IN NUMBER
25 ,P_CONTACT_POINT IN VARCHAR2 DEFAULT null
26 ,P_CONTACT_POINT_ID IN NUMBER DEFAULT 0
27 ,P_CALL_START_TIME IN VARCHAR2 DEFAULT null
28 ,P_CALL_END_TIME IN VARCHAR2 DEFAULT null
29 ,P_NEXT_CALL_TIME IN VARCHAR2 DEFAULT null
30 ,P_CALL_TYPE IN VARCHAR2
31 ,P_DELIVER_IH_FLAG IN VARCHAR2
32 ,P_LIST_VIEW_NAME IN VARCHAR2
33 ,P_RECYCLE_FLAG IN VARCHAR2
34 ,X_RETURNS_ID OUT NOCOPY NUMBER
35 );
36
37 PROCEDURE ADD_ENTRY
38 (P_LIST_ENTRY_ID IN NUMBER
39 ,P_LIST_HEADER_ID IN NUMBER
40 ,P_SUBSET_ID IN NUMBER DEFAULT 0
41 ,P_CPN_SCHEDULE_ID IN NUMBER DEFAULT 0
42 ,P_OUTCOME_ID IN NUMBER
43 ,P_REASON_ID IN NUMBER
44 ,P_RESULT_ID IN NUMBER
45 ,P_CONTACT_POINT IN VARCHAR2 DEFAULT null
46 ,P_CONTACT_POINT_ID IN NUMBER DEFAULT 0
47 ,P_CALL_START_TIME IN DATE DEFAULT null
48 ,P_CALL_END_TIME IN DATE DEFAULT null
49 ,P_NEXT_CALL_TIME IN DATE DEFAULT null
50 ,P_CALL_TYPE IN VARCHAR2
51 ,P_DELIVER_IH_FLAG IN VARCHAR2
52 ,P_LIST_VIEW_NAME IN VARCHAR2
53 ,P_RECYCLE_FLAG IN VARCHAR2
54 ,X_RETURNS_ID OUT NOCOPY NUMBER
55 );
56 -- convenience methods for most common updates.
57 -- Mainly used by AODS to return the entries.
58 PROCEDURE UPDATE_ENTRY
59 (P_RETURNS_ID IN NUMBER
60 ,P_SUBSET_ID IN NUMBER
61 ,P_CALL_START_TIME IN VARCHAR2
62 ,P_CALL_END_TIME IN VARCHAR2
63 ,P_NEXT_CALL_TIME IN VARCHAR2
64 ,P_OUTCOME_ID IN NUMBER
65 ,P_REASON_ID IN NUMBER
66 ,P_RESULT_ID IN NUMBER
67 ,P_DELIVER_IH_FLAG IN VARCHAR2
68 );
69
70 PROCEDURE UPDATE_ENTRY
71 (P_RETURNS_ID IN NUMBER
72 ,P_SUBSET_ID IN NUMBER
73 ,P_CALL_START_TIME IN DATE
74 ,P_CALL_END_TIME IN DATE
75 ,P_NEXT_CALL_TIME IN DATE
76 ,P_OUTCOME_ID IN NUMBER
77 ,P_REASON_ID IN NUMBER
78 ,P_RESULT_ID IN NUMBER
79 ,P_DELIVER_IH_FLAG IN VARCHAR2
80 );
81
82 -- used by AODS to return the entries.
83 PROCEDURE UPDATE_ENTRY
84 (P_RETURNS_ID IN NUMBER
85 ,P_SUBSET_ID IN NUMBER
86 ,P_CALL_START_TIME IN DATE
87 ,P_CALL_END_TIME IN DATE
88 ,P_AGENT_RECYCLE_ACTION IN VARCHAR2
89 ,P_OUTCOME_ID IN NUMBER
90 ,P_REASON_ID IN NUMBER
91 ,P_RESULT_ID IN NUMBER
92 ,P_DELIVER_IH_FLAG IN VARCHAR2
93 );
94
95 -- used by OCS to update the subset_id
96 PROCEDURE UPDATE_ENTRY
97 (P_LIST_ENTRY_ID IN NUMBER
98 ,P_LIST_HEADER_ID IN NUMBER
99 ,P_CPN_SCHEDULE_ID IN NUMBER
100 ,P_SUBSET_ID IN NUMBER
101 ,X_RETURNS_ID OUT NOCOPY NUMBER
102 );
103
104 -- used by recycle to add call history
105 PROCEDURE ADD_CALL_HISTORY
106 (P_RETURNS_ID IN NUMBER
107 ,P_CONTACT_POINT IN VARCHAR2
108 ,P_OUTCOME_ID IN NUMBER
109 ,P_TIME IN DATE
110 );
111
112 END IEC_RETURNS_UTIL_PVT;