1 PACKAGE IEC_STATUS_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECOCSTS.pls 120.1 2006/03/28 08:03:37 minwang noship $ */
3
4 -----------------------------++++++-------------------------------
5 --
6 -- Start of comments
7 --
8 -- API name : HANDLE_STATUS_TRANSITIONS
9 -- Type : Public
10 -- Pre-reqs : None
11 -- Function : Called by the Status plugin to execute status
12 -- transitions.
13 -- Parameters : P_SERVER_ID IN NUMBER Required
14 --
15 -- Version : Initial version 1.0
16 --
17 -- End of comments
18 --
19 -----------------------------++++++-------------------------------
20 PROCEDURE HANDLE_STATUS_TRANSITIONS
21 ( P_SERVER_ID IN NUMBER
22 );
23
24 -----------------------------++++++-------------------------------
25 --
26 -- Start of comments
27 --
28 -- API name : Update_Schedule_Status
29 -- Type : Public
30 -- Pre-reqs : None
31 -- Function : Makes call to AMS_CAMP_SCHEDULE_PUB.Update_Camp_Schedule to change the value of the
32 -- particular schedule's status value.
33 --
34 -- Parameters : p_schedule_id IN NUMBER Required
35 -- p_status IN NUMBER Required
36 -- p_user_id IN NUMBER Required
37 --
38 -- Version : Initial version 1.0
39 --
40 -- End of comments
41 --
42 -----------------------------++++++-------------------------------
43 PROCEDURE Update_Schedule_Status
44 ( p_schedule_id IN NUMBER
45 , p_status IN NUMBER
46 , p_user_id IN NUMBER
47 );
48
49 -----------------------------++++++-------------------------------
50 --
51 -- Start of comments
52 --
53 -- API name : Update_List_Status
54 -- Type : Public
55 -- Pre-reqs : None
56 -- Function : Updates the Advanced Outbound list status, and
57 -- makes call to AMS_LISTHEADER_PVT.UpdateListheader
58 -- to update the Marketing list status as well.
59 --
60 -- Parameters : p_list_id IN NUMBER Required
61 -- p_status IN VARCHAR2 Required
62 --
63 -- Version : Initial version 1.0
64 --
65 -- End of comments
66 --
67 -----------------------------++++++-------------------------------
68 PROCEDURE Update_List_Status
69 ( p_list_id IN NUMBER
70 , p_status IN VARCHAR2
71 );
72
73 -----------------------------++++++-------------------------------
74 --
75 -- Start of comments
76 --
77 -- API name : Update_List_Status
78 -- Type : Public
79 -- Pre-reqs : None
80 -- Function : Updates the Advanced Outbound list status, and
81 -- makes call to AMS_LISTHEADER_PVT.UpdateListheader
82 -- to update the Marketing list status as well.
83 -- Accepts a parameter p_api_init_flag that is used
84 -- to flag whether or not a call to a public api
85 -- initiated the status change (i.e. start purge).
86 -- In most cases, this flag isn't relevant and the
87 -- overloaded procedure Update_List_Status that accepts
88 -- only p_list_id and p_status parameters should be used.
89 --
90 -- Parameters : p_list_id IN NUMBER Required
91 -- p_status IN VARCHAR2 Required
92 -- p_api_init_flag IN VARCHAR2 Required
93 --
94 -- Version : Initial version 1.0
95 --
96 -- End of comments
97 --
98 -----------------------------++++++-------------------------------
99 PROCEDURE Update_List_Status
100 ( p_list_id IN NUMBER
101 , p_status IN VARCHAR2
102 , p_api_init_flag IN VARCHAR2
103 );
104
105 -----------------------------++++++-------------------------------
106 --
107 -- Start of comments
108 --
109 -- API name : Start_ListExecution
110 -- Type : Public
111 -- Pre-reqs : None
112 -- Function : Set the list status to 'EXECUTING' and update
113 -- the execution start time.
114 --
115 -- Parameters : p_list_id IN NUMBER
116 --
117 -- Version : Initial version 1.0
118 --
119 -- End of comments
120 --
121 -----------------------------++++++-------------------------------
122 PROCEDURE Start_ListExecution (p_list_id IN NUMBER);
123
124 -----------------------------++++++-------------------------------
125 --
126 -- Start of comments
127 --
128 -- API name : Stop_ListExecution
129 -- Type : Public
130 -- Pre-reqs : None
131 -- Function : Set the list status to 'LOCKED' and make sure
132 -- that all entries are checked back into list.
133 --
134 -- Parameters : p_list_id IN NUMBER
135 --
136 -- Version : Initial version 1.0
137 --
138 -- End of comments
139 --
140 -----------------------------++++++-------------------------------
141 PROCEDURE Stop_ListExecution (p_list_id IN NUMBER);
142
143 -----------------------------++++++-------------------------------
144 --
145 -- Start of comments
146 --
147 -- API name : Pause_ListExecution
148 -- Type : Public
149 -- Pre-reqs : None
150 -- Function : Set the schedule status to 'ON_HOLD'.
151 --
152 -- Parameters : p_schedule_id IN NUMBER
153 -- p_user_id IN NUMBER
154 --
155 -- Version : Initial version 1.0
156 --
157 -- End of comments
158 --
159 -----------------------------++++++-------------------------------
160 PROCEDURE Pause_ScheduleExecution
161 ( p_schedule_id IN NUMBER
162 , p_user_id IN NUMBER
163 );
164
165 -----------------------------++++++-------------------------------
166 --
167 -- Start of comments
168 --
169 -- API name : Clean_ListEntries
170 -- Type : Public
171 -- Pre-reqs : None
172 -- Function : Remove database entries and set the target group status to 'DELETED'.
173 --
174 -- Parameters : p_list_id IN NUMBER
175 --
176 -- Version : Initial version 1.0
177 --
178 -- End of comments
179 --
180 -----------------------------++++++-------------------------------
181 PROCEDURE Clean_ListEntries (p_list_id IN NUMBER);
182
183 -----------------------------++++++-------------------------------
184 --
185 -- Start of comments
186 --
187 -- API name : Stop_ScheduleExecution_Pub
188 -- Type : Public
189 -- Pre-reqs : None
190 -- Function : Called by public api to stop schedule execution.
191 --
192 -- Parameters : p_schedule_id IN NUMBER
193 -- p_commit IN BOOLEAN
194 -- x_return_status OUT NOCOPY VARCHAR2
195 --
196 -- Version : Initial version 1.0
197 --
198 -- End of comments
199 --
200 -----------------------------++++++-------------------------------
201 PROCEDURE Stop_ScheduleExecution_Pub
202 ( p_schedule_id IN NUMBER
203 , p_commit IN BOOLEAN
204 , x_return_status OUT NOCOPY VARCHAR2);
205
206
207 END IEC_STATUS_PVT;