[Home] [Help]
PACKAGE: APPS.AMS_IMPORT_LIST_PUB
Source
1 PACKAGE AMS_Import_List_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspimps.pls 115.5 2002/11/12 23:34:57 jieli noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Import_List_PUB
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 -- ams_import_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- import_list_header_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- view_application_id
33 -- name
34 -- version
35 -- import_type
36 -- owner_user_id
37 -- custom_setup_id
38 -- country
39 -- list_source_type_id
40 -- status_code
41 -- status_date
42 -- user_status_id
43 -- source_system
44 -- vendor_id
45 -- pin_id
46 -- org_id
47 -- scheduled_time
48 -- loaded_no_of_rows
49 -- loaded_date
50 -- rows_to_skip
51 -- processed_rows
52 -- headings_flag
53 -- expiry_date
54 -- purge_date
55 -- description
56 -- keywords
57 -- transactional_cost
58 -- transactional_currency_code
59 -- functional_cost
60 -- functional_currency_code
61 -- terminated_by
62 -- enclosed_by
63 -- data_filename
64 -- process_immed_flag
65 -- dedupe_flag
66 -- attribute_category
67 -- attribute1
68 -- attribute2
69 -- attribute3
70 -- attribute4
71 -- attribute5
72 -- attribute6
73 -- attribute7
74 -- attribute8
75 -- attribute9
76 -- attribute10
77 -- attribute11
78 -- attribute12
79 -- attribute13
80 -- attribute14
81 -- attribute15
82 -- usage
83 -- rented_list_flag
84 -- server_flag
85 -- log_file_name
86 -- number_of_failed_records
87 -- number_of_duplicate_records
88 -- enable_word_replacement_flag
89 --
90 -- Required
91 --
92 -- Defaults
93 --
94 -- Note: This is automatic generated record definition, it includes all columns
95 -- defined in the table, developer must manually add or delete some of the attributes.
96 --
97 -- End of Comments
98
99 --===================================================================
100 TYPE ams_import_rec_type IS RECORD
101 (
102 import_list_header_id NUMBER := FND_API.G_MISS_NUM,
103 last_update_date DATE := FND_API.G_MISS_DATE,
104 last_updated_by NUMBER := FND_API.G_MISS_NUM,
105 creation_date DATE := FND_API.G_MISS_DATE,
106 created_by NUMBER := FND_API.G_MISS_NUM,
107 last_update_login NUMBER := FND_API.G_MISS_NUM,
108 object_version_number NUMBER := FND_API.G_MISS_NUM,
109 view_application_id NUMBER := FND_API.G_MISS_NUM,
110 name VARCHAR2(240) := FND_API.G_MISS_CHAR,
111 version VARCHAR2(10) := FND_API.G_MISS_CHAR,
112 import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113 owner_user_id NUMBER := FND_API.G_MISS_NUM,
114 custom_setup_id NUMBER := FND_API.G_MISS_NUM,
115 country NUMBER := FND_API.G_MISS_NUM,
116 list_source_type_id NUMBER := FND_API.G_MISS_NUM,
117 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
118 status_date DATE := FND_API.G_MISS_DATE,
119 user_status_id NUMBER := FND_API.G_MISS_NUM,
120 source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
121 vendor_id NUMBER := FND_API.G_MISS_NUM,
122 pin_id NUMBER := FND_API.G_MISS_NUM,
123 org_id NUMBER := FND_API.G_MISS_NUM,
124 scheduled_time DATE := FND_API.G_MISS_DATE,
125 loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
126 loaded_date DATE := FND_API.G_MISS_DATE,
127 rows_to_skip NUMBER := FND_API.G_MISS_NUM,
128 processed_rows NUMBER := FND_API.G_MISS_NUM,
129 headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
130 expiry_date DATE := FND_API.G_MISS_DATE,
131 purge_date DATE := FND_API.G_MISS_DATE,
132 description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
133 keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134 transactional_cost NUMBER := FND_API.G_MISS_NUM,
135 transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
136 functional_cost NUMBER := FND_API.G_MISS_NUM,
137 functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
138 terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
139 enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
140 data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
141 process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
142 dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
143 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
144 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159 usage NUMBER := FND_API.G_MISS_NUM,
160 rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
161 server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162 log_file_name NUMBER := FND_API.G_MISS_NUM,
163 number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
164 number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
165 enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
166 );
167
168 g_miss_ams_import_rec ams_import_rec_type;
169 TYPE ams_import_tbl_type IS TABLE OF ams_import_rec_type INDEX BY BINARY_INTEGER;
170 g_miss_ams_import_tbl ams_import_tbl_type;
171
172 TYPE ams_import_sort_rec_type IS RECORD
173 (
174 -- Please define your own sort by record here.
175 last_update_date NUMBER := NULL
176 );
177
178 -- ==============================================================================
179 -- Start of Comments
180 -- ==============================================================================
181 -- API Name
182 -- Create_Import_List
183 -- Type
184 -- Public
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_ams_import_rec IN ams_import_rec_type Required
194 --
195 -- OUT
196 -- x_return_status OUT VARCHAR2
197 -- x_msg_count OUT NUMBER
198 -- x_msg_data OUT VARCHAR2
199 -- Version : Current version 1.0
200 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
201 -- and basic operation, developer must manually add parameters and business logic as necessary.
202 --
203 -- End of Comments
204 -- ==============================================================================
205 --
206
207 PROCEDURE Create_Import_List(
208 p_api_version_number IN NUMBER,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215
216 p_ams_import_rec IN ams_import_rec_type := g_miss_ams_import_rec,
217 x_import_list_header_id OUT NOCOPY NUMBER
218 );
219
220 -- ==============================================================================
221 -- Start of Comments
222 -- ==============================================================================
223 -- API Name
224 -- Update_Import_List
225 -- Type
226 -- Public
227 -- Pre-Req
228 --
229 -- Parameters
230 --
231 -- IN
232 -- p_api_version_number IN NUMBER Required
233 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
234 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
235 -- p_ams_import_rec IN ams_import_rec_type Required
236 --
237 -- OUT
238 -- x_return_status OUT VARCHAR2
239 -- x_msg_count OUT NUMBER
240 -- x_msg_data OUT VARCHAR2
241 -- Version : Current version 1.0
242 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
243 -- and basic operation, developer must manually add parameters and business logic as necessary.
244 --
245 -- End of Comments
246 -- ==============================================================================
247 --
248
249 PROCEDURE Update_Import_List(
250 p_api_version_number IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252 p_commit IN VARCHAR2 := FND_API.G_FALSE,
253
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257
258 p_ams_import_rec IN ams_import_rec_type,
259 x_object_version_number OUT NOCOPY NUMBER
260 );
261
262 -- ==============================================================================
263 -- Start of Comments
264 -- ==============================================================================
265 -- API Name
266 -- Delete_Import_List
267 -- Type
268 -- Public
269 -- Pre-Req
270 --
271 -- Parameters
272 --
273 -- IN
274 -- p_api_version_number IN NUMBER Required
275 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277 -- p_IMPORT_LIST_HEADER_ID IN NUMBER
278 -- p_object_version_number IN NUMBER Optional Default = NULL
279 --
280 -- OUT
281 -- x_return_status OUT VARCHAR2
282 -- x_msg_count OUT NUMBER
283 -- x_msg_data OUT VARCHAR2
284 -- Version : Current version 1.0
285 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
286 -- and basic operation, developer must manually add parameters and business logic as necessary.
287 --
288 -- End of Comments
289 -- ==============================================================================
290 --
291
292 PROCEDURE Delete_Import_List(
293 p_api_version_number IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295 p_commit IN VARCHAR2 := FND_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_import_list_header_id IN NUMBER,
300 p_object_version_number IN NUMBER
301 );
302
303 -- ==============================================================================
304 -- Start of Comments
305 -- ==============================================================================
306 -- API Name
307 -- Lock_Import_List
308 -- Type
309 -- Public
310 -- Pre-Req
311 --
312 -- Parameters
313 --
314 -- IN
315 -- p_api_version_number IN NUMBER Required
316 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
317 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
318 -- p_ams_import_rec IN ams_import_rec_type Required
319 --
320 -- OUT
321 -- x_return_status OUT VARCHAR2
322 -- x_msg_count OUT NUMBER
323 -- x_msg_data OUT VARCHAR2
324 -- Version : Current version 1.0
325 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
326 -- and basic operation, developer must manually add parameters and business logic as necessary.
327 --
328 -- End of Comments
329 -- ==============================================================================
330 --
331
332 PROCEDURE Lock_Import_List(
333 p_api_version_number IN NUMBER,
334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338
339 p_import_list_header_id IN NUMBER,
340 p_object_version IN NUMBER
341 );
342
343 END AMS_Import_List_PUB;