1 PACKAGE AMS_List_Assoc_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvascs.pls 115.6 2002/11/22 08:55:00 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Assoc_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_assoc_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- list_contact_restrictions_id
26 -- list_header_id
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- object_version_number
33 -- do_not_contact_flag
34 -- media_id
35 -- list_used_by
36 -- list_used_by_id
37 --
38 -- Required
39 --
40 -- Defaults
41 --
42 -- Note: This is automatic generated record definition, it includes all columns
43 -- defined in the table, developer must manually add or delete some of the attributes.
44 --
45 -- End of Comments
46
47 --===================================================================
48 TYPE list_assoc_rec_type IS RECORD
49 (
50 list_cont_restrictions_id NUMBER := FND_API.G_MISS_NUM,
51 list_header_id NUMBER := FND_API.G_MISS_NUM,
52 last_update_date DATE := FND_API.G_MISS_DATE,
53 last_updated_by NUMBER := FND_API.G_MISS_NUM,
54 creation_date DATE := FND_API.G_MISS_DATE,
55 created_by NUMBER := FND_API.G_MISS_NUM,
56 last_update_login NUMBER := FND_API.G_MISS_NUM,
57 object_version_number NUMBER := FND_API.G_MISS_NUM,
58 do_not_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59 media_id NUMBER := FND_API.G_MISS_NUM,
60 list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
61 list_used_by_id NUMBER := FND_API.G_MISS_NUM
62 );
63
64 g_miss_list_assoc_rec list_assoc_rec_type;
65 TYPE list_assoc_tbl_type IS TABLE OF list_assoc_rec_type INDEX BY BINARY_INTEGER;
66 g_miss_list_assoc_tbl list_assoc_tbl_type;
67
68 -- ==============================================================================
69 -- Start of Comments
70 -- ==============================================================================
71 -- API Name
72 -- Create_List_Assoc
73 -- Type
74 -- Private
75 -- Pre-Req
76 --
77 -- Parameters
78 --
79 -- IN
80 -- p_api_version_number IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84 -- p_list_assoc_rec IN list_assoc_rec_type Required
85 --
86 -- OUT
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 -- Version : Current version 1.0
91 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
92 -- and basic operation, developer must manually add parameters and business logic as necessary.
93 --
94 -- End of Comments
95 -- ==============================================================================
96 --
97
98 PROCEDURE Create_List_Assoc(
99 p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107
108 p_list_assoc_rec IN list_assoc_rec_type := g_miss_list_assoc_rec,
109 x_list_cont_restrictions_id OUT NOCOPY NUMBER
110 );
111
112 -- ==============================================================================
113 -- Start of Comments
114 -- ==============================================================================
115 -- API Name
116 -- Update_List_Assoc
117 -- Type
118 -- Private
119 -- Pre-Req
120 --
121 -- Parameters
122 --
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_list_assoc_rec IN list_assoc_rec_type Required
129 --
130 -- OUT
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 -- ==============================================================================
140 --
141
142 PROCEDURE Update_List_Assoc(
143 p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_list_assoc_rec IN list_assoc_rec_type,
153 x_object_version_number OUT NOCOPY NUMBER
154 );
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Delete_List_Assoc
161 -- Type
162 -- Private
163 -- Pre-Req
164 --
165 -- Parameters
166 --
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172 -- p_LIST_CONTACT_RESTRICTIONs_ID IN NUMBER
173 -- p_object_version_number IN NUMBER Optional Default = NULL
174 --
175 -- OUT
176 -- x_return_status OUT VARCHAR2
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2
179 -- Version : Current version 1.0
180 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
181 -- and basic operation, developer must manually add parameters and business logic as necessary.
182 --
183 -- End of Comments
184 -- ==============================================================================
185 --
186
187 PROCEDURE Delete_List_Assoc(
188 p_api_version_number IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_list_cont_restrictions_id IN NUMBER,
196 p_object_version_number IN NUMBER
197 );
198
199 -- ==============================================================================
200 -- Start of Comments
201 -- ==============================================================================
202 -- API Name
203 -- Lock_List_Assoc
204 -- Type
205 -- Private
206 -- Pre-Req
207 --
208 -- Parameters
209 --
210 -- IN
211 -- p_api_version_number IN NUMBER Required
212 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215 -- p_list_assoc_rec IN list_assoc_rec_type Required
216 --
217 -- OUT
218 -- x_return_status OUT VARCHAR2
219 -- x_msg_count OUT NUMBER
220 -- x_msg_data OUT VARCHAR2
221 -- Version : Current version 1.0
222 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
223 -- and basic operation, developer must manually add parameters and business logic as necessary.
224 --
225 -- End of Comments
226 -- ==============================================================================
227 --
228
229 PROCEDURE Lock_List_Assoc(
230 p_api_version_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236
237 p_list_cont_restrictions_id IN NUMBER,
238 p_object_version IN NUMBER
239 );
240
241
242 -- Start of Comments
243 --
244 -- validation procedures
245 --
246 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- Note: 1. This is automated generated item level validation procedure.
249 -- The actual validation detail is needed to be added.
250 -- 2. We can also validate table instead of record. There will be an option for user to choose.
251 -- End of Comments
252
253 PROCEDURE Validate_list_assoc(
254 p_api_version_number IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257 p_list_assoc_rec IN list_assoc_rec_type,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2
261 );
262
263 -- Start of Comments
264 --
265 -- validation procedures
266 --
267 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
268 -- For create: G_CREATE, for update: G_UPDATE
269 -- Note: 1. This is automated generated item level validation procedure.
270 -- The actual validation detail is needed to be added.
271 -- 2. Validate the unique keys, lookups here
272 -- End of Comments
273
274 PROCEDURE Check_list_assoc_Items (
275 P_list_assoc_rec IN list_assoc_rec_type,
276 p_validation_mode IN VARCHAR2,
277 x_return_status OUT NOCOPY VARCHAR2
278 );
279
280 -- Start of Comments
281 --
282 -- Record level validation procedures
283 --
284 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
285 -- For create: G_CREATE, for update: G_UPDATE
286 -- Note: 1. This is automated generated item level validation procedure.
287 -- The actual validation detail is needed to be added.
288 -- 2. Developer can manually added inter-field level validation.
289 -- End of Comments
290
291 PROCEDURE Validate_list_assoc_rec(
292 p_api_version_number IN NUMBER,
293 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_list_assoc_rec IN list_assoc_rec_type
298 );
299 END AMS_List_Assoc_PVT;