1 PACKAGE AMS_List_Group_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvlgps.pls 115.3 2002/11/22 08:55:28 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Group_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- list_group_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- act_list_group_id
26 -- act_list_used_by_id
27 -- arc_act_list_used_by
28 -- group_code
29 -- group_priority
30 -- last_update_date
31 -- last_updated_by
32 -- creation_date
33 -- created_by
34 -- last_update_login
35 -- object_version_number
36 -- status_code
37 -- user_status_id
38 -- calling_calendar_id
39 -- release_control_alg_id
40 -- release_strategy
41 -- recycling_alg_id
42 -- callback_priority_flag
43 -- call_center_ready_flag
44 -- dialing_method
45 -- quantum
46 -- quota
47 -- quota_reset
48 --
49 -- Required
50 --
51 -- Defaults
52 --
53 -- Note: This is automatic generated record definition, it includes all columns
54 -- defined in the table, developer must manually add or delete some of the attributes.
55 --
56 -- End of Comments
57
58 --===================================================================
59 TYPE list_group_rec_type IS RECORD
60 (
61 act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62 act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63 arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65 group_priority NUMBER := FND_API.G_MISS_NUM,
66 last_update_date DATE := FND_API.G_MISS_DATE,
67 last_updated_by NUMBER := FND_API.G_MISS_NUM,
68 creation_date DATE := FND_API.G_MISS_DATE,
69 created_by NUMBER := FND_API.G_MISS_NUM,
70 last_update_login NUMBER := FND_API.G_MISS_NUM,
71 object_version_number NUMBER := FND_API.G_MISS_NUM,
72 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 user_status_id NUMBER := FND_API.G_MISS_NUM,
74 calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75 release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76 release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77 recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78 callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79 call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80 dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81 quantum NUMBER := FND_API.G_MISS_NUM,
82 quota NUMBER := FND_API.G_MISS_NUM,
83 quota_reset NUMBER := FND_API.G_MISS_NUM
84 );
85
86 g_miss_list_group_rec list_group_rec_type;
87 TYPE list_group_tbl_type IS TABLE OF list_group_rec_type INDEX BY BINARY_INTEGER;
88 g_miss_list_group_tbl list_group_tbl_type;
89
90 -- ==============================================================================
91 -- Start of Comments
92 -- ==============================================================================
93 -- API Name
94 -- Create_List_Group
95 -- Type
96 -- Private
97 -- Pre-Req
98 --
99 -- Parameters
100 --
101 -- IN
102 -- p_api_version_number IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106 -- p_list_group_rec IN list_group_rec_type Required
107 --
108 -- OUT
109 -- x_return_status OUT VARCHAR2
110 -- x_msg_count OUT NUMBER
111 -- x_msg_data OUT VARCHAR2
112 -- Version : Current version 1.0
113 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
114 -- and basic operation, developer must manually add parameters and business logic as necessary.
115 --
116 -- End of Comments
117 -- ==============================================================================
118 --
119
120 PROCEDURE Create_List_Group(
121 p_api_version_number IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129
130 p_list_group_rec IN list_group_rec_type := g_miss_list_group_rec,
131 x_act_list_group_id OUT NOCOPY NUMBER
132 );
133
134 -- ==============================================================================
135 -- Start of Comments
136 -- ==============================================================================
137 -- API Name
138 -- Update_List_Group
139 -- Type
140 -- Private
141 -- Pre-Req
142 --
143 -- Parameters
144 --
145 -- IN
146 -- p_api_version_number IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150 -- p_list_group_rec IN list_group_rec_type Required
151 --
152 -- OUT
153 -- x_return_status OUT VARCHAR2
154 -- x_msg_count OUT NUMBER
155 -- x_msg_data OUT VARCHAR2
156 -- Version : Current version 1.0
157 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
158 -- and basic operation, developer must manually add parameters and business logic as necessary.
159 --
160 -- End of Comments
161 -- ==============================================================================
162 --
163
164 PROCEDURE Update_List_Group(
165 p_api_version_number IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167 p_commit IN VARCHAR2 := FND_API.G_FALSE,
168 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173
174 p_list_group_rec IN list_group_rec_type,
175 x_object_version_number OUT NOCOPY NUMBER
176 );
177
178 -- ==============================================================================
179 -- Start of Comments
180 -- ==============================================================================
181 -- API Name
182 -- Delete_List_Group
183 -- Type
184 -- Private
185 -- Pre-Req
186 --
187 -- Parameters
188 --
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194 -- p_ACT_LIST_GROUP_ID IN NUMBER
195 -- p_object_version_number IN NUMBER Optional Default = NULL
196 --
197 -- OUT
198 -- x_return_status OUT VARCHAR2
199 -- x_msg_count OUT NUMBER
200 -- x_msg_data OUT VARCHAR2
201 -- Version : Current version 1.0
202 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
203 -- and basic operation, developer must manually add parameters and business logic as necessary.
204 --
205 -- End of Comments
206 -- ==============================================================================
207 --
208
209 PROCEDURE Delete_List_Group(
210 p_api_version_number IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_act_list_group_id IN NUMBER,
218 p_object_version_number IN NUMBER
219 );
220
221 -- ==============================================================================
222 -- Start of Comments
223 -- ==============================================================================
224 -- API Name
225 -- Lock_List_Group
226 -- Type
227 -- Private
228 -- Pre-Req
229 --
230 -- Parameters
231 --
232 -- IN
233 -- p_api_version_number IN NUMBER Required
234 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237 -- p_list_group_rec IN list_group_rec_type Required
238 --
239 -- OUT
240 -- x_return_status OUT VARCHAR2
241 -- x_msg_count OUT NUMBER
242 -- x_msg_data OUT VARCHAR2
243 -- Version : Current version 1.0
244 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
245 -- and basic operation, developer must manually add parameters and business logic as necessary.
246 --
247 -- End of Comments
248 -- ==============================================================================
249 --
250
251 PROCEDURE Lock_List_Group(
252 p_api_version_number IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258
259 p_act_list_group_id IN NUMBER,
260 p_object_version IN NUMBER
261 );
262
263
264 -- Start of Comments
265 --
266 -- validation procedures
267 --
268 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
269 -- For create: G_CREATE, for update: G_UPDATE
270 -- Note: 1. This is automated generated item level validation procedure.
271 -- The actual validation detail is needed to be added.
272 -- 2. We can also validate table instead of record. There will be an option for user to choose.
273 -- End of Comments
274
275 PROCEDURE Validate_list_group(
276 p_api_version_number IN NUMBER,
277 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
279 p_list_group_rec IN list_group_rec_type,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2
283 );
284
285 -- Start of Comments
286 --
287 -- validation procedures
288 --
289 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
290 -- For create: G_CREATE, for update: G_UPDATE
291 -- Note: 1. This is automated generated item level validation procedure.
292 -- The actual validation detail is needed to be added.
293 -- 2. Validate the unique keys, lookups here
294 -- End of Comments
295
296 PROCEDURE Check_list_group_Items (
297 P_list_group_rec IN list_group_rec_type,
298 p_validation_mode IN VARCHAR2,
299 x_return_status OUT NOCOPY VARCHAR2
300 );
301
302 -- Start of Comments
303 --
304 -- Record level validation procedures
305 --
306 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
307 -- For create: G_CREATE, for update: G_UPDATE
308 -- Note: 1. This is automated generated item level validation procedure.
309 -- The actual validation detail is needed to be added.
310 -- 2. Developer can manually added inter-field level validation.
311 -- End of Comments
312
313 PROCEDURE Validate_list_group_rec(
314 p_api_version_number IN NUMBER,
315 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319 p_list_group_rec IN list_group_rec_type
320 );
321 END AMS_List_Group_PVT;