1 PACKAGE AMS_Imp_Doc_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvidos.pls 115.3 2002/11/12 23:38:25 jieli noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Imp_Doc_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- imp_doc_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- imp_document_id
29 -- last_updated_by
30 -- object_version_number
31 -- last_update_by
32 -- created_by
33 -- last_update_login
34 -- last_update_date
35 -- creation_date
36 -- object_version_number
37 -- import_list_header_id
38 -- import_list_header_id
39 -- content_text
40 -- content_text
41 -- dtd_text
42 -- dtd_text
43 -- file_type
44 -- filter_content_text
45 -- filter_content_text
46 -- file_type
47 -- file_size
48 -- file_size
49 -- last_updated_by
50 --
51 -- Required
52 --
53 -- Defaults
54 --
55 -- Note: This is automatic generated record definition, it includes all columns
56 -- defined in the table, developer must manually add or delete some of the attributes.
57 --
58 -- End of Comments
59
60 --===================================================================
61 TYPE imp_doc_rec_type IS RECORD
62 (
63 imp_document_id NUMBER,
64 last_updated_by NUMBER,
65 object_version_number NUMBER,
66 created_by NUMBER,
67 last_update_login NUMBER,
68 last_update_date DATE,
69 creation_date DATE,
70 import_list_header_id NUMBER,
71 --content_text CLOB,
72 --dtd_text CLOB,
73 file_type VARCHAR2(10),
74 --filter_content_text CLOB,
75 file_size NUMBER
76 );
77
78 g_miss_imp_doc_rec imp_doc_rec_type := NULL;
79 TYPE imp_doc_tbl_type IS TABLE OF imp_doc_rec_type INDEX BY BINARY_INTEGER;
80 g_miss_imp_doc_tbl imp_doc_tbl_type;
81
82 -- ==============================================================================
83 -- Start of Comments
84 -- ==============================================================================
85 -- API Name
86 -- Create_Imp_Doc
87 -- Type
88 -- Private
89 -- Pre-Req
90 --
91 -- Parameters
92 --
93 -- IN
94 -- p_api_version_number IN NUMBER Required
95 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
96 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
97 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
98 -- p_imp_doc_rec IN imp_doc_rec_type Required
99 --
100 -- OUT
101 -- x_return_status OUT VARCHAR2
102 -- x_msg_count OUT NUMBER
103 -- x_msg_data OUT VARCHAR2
104 -- Version : Current version 1.0
105 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
106 -- and basic operation, developer must manually add parameters and business logic as necessary.
107 --
108 -- History
109 --
110 -- NOTE
111 --
112 -- End of Comments
113 -- ==============================================================================
114
115 PROCEDURE Create_Imp_Doc(
116 p_api_version_number IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124
125 p_imp_doc_rec IN imp_doc_rec_type := g_miss_imp_doc_rec,
126 x_imp_document_id OUT NOCOPY NUMBER
127 );
128
129 -- ==============================================================================
130 -- Start of Comments
131 -- ==============================================================================
132 -- API Name
133 -- Update_Imp_Doc
134 -- Type
135 -- Private
136 -- Pre-Req
137 --
138 -- Parameters
139 --
140 -- IN
141 -- p_api_version_number IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145 -- p_imp_doc_rec IN imp_doc_rec_type Required
146 --
147 -- OUT
148 -- x_return_status OUT VARCHAR2
149 -- x_msg_count OUT NUMBER
150 -- x_msg_data OUT VARCHAR2
151 -- Version : Current version 1.0
152 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
153 -- and basic operation, developer must manually add parameters and business logic as necessary.
154 --
155 -- History
156 --
157 -- NOTE
158 --
159 -- End of Comments
160 -- ==============================================================================
161
162 PROCEDURE Update_Imp_Doc(
163 p_api_version_number IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171
172 p_imp_doc_rec IN imp_doc_rec_type,
173 x_object_version_number OUT NOCOPY NUMBER
174 );
175
176 -- ==============================================================================
177 -- Start of Comments
178 -- ==============================================================================
179 -- API Name
180 -- Delete_Imp_Doc
181 -- Type
182 -- Private
183 -- Pre-Req
184 --
185 -- Parameters
186 --
187 -- IN
188 -- p_api_version_number IN NUMBER Required
189 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192 -- p_imp_document_id IN NUMBER
193 -- p_object_version_number IN NUMBER Optional Default = NULL
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 -- History
204 --
205 -- NOTE
206 --
207 -- End of Comments
208 -- ==============================================================================
209
210 PROCEDURE Delete_Imp_Doc(
211 p_api_version_number IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_imp_document_id IN NUMBER,
219 p_object_version_number IN NUMBER
220 );
221
222 -- ==============================================================================
223 -- Start of Comments
224 -- ==============================================================================
225 -- API Name
226 -- Lock_Imp_Doc
227 -- Type
228 -- Private
229 -- Pre-Req
230 --
231 -- Parameters
232 --
233 -- IN
234 -- p_api_version_number IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238 -- p_imp_doc_rec IN imp_doc_rec_type Required
239 --
240 -- OUT
241 -- x_return_status OUT VARCHAR2
242 -- x_msg_count OUT NUMBER
243 -- x_msg_data OUT VARCHAR2
244 -- Version : Current version 1.0
245 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
246 -- and basic operation, developer must manually add parameters and business logic as necessary.
247 --
248 -- History
249 --
250 -- NOTE
251 --
252 -- End of Comments
253 -- ==============================================================================
254
255 PROCEDURE Lock_Imp_Doc(
256 p_api_version_number IN NUMBER,
257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262
263 p_imp_document_id IN NUMBER,
264 p_object_version IN NUMBER
265 );
266
267 -- ==============================================================================
268 -- Start of Comments
269 -- ==============================================================================
270 -- API Name
271 -- add_language
272 -- Type
273 -- Private
274 -- History
275 --
276 -- NOTE
277 --
278 -- End of Comments
279 -- ===============================================================
280
281 --PROCEDURE Add_Language;
282
283 -- ==============================================================================
284 -- Start of Comments
285 -- ==============================================================================
286 -- API Name
287 -- Validate_Imp_Doc
288 --
289 -- Version : Current version 1.0
290 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
291 -- For create: G_CREATE, for update: G_UPDATE
292 -- Note: 1. This is automated generated item level validation procedure.
293 -- The actual validation detail is needed to be added.
294 -- 2. We can also validate table instead of record. There will be an option for user to choose.
295 --
296 -- History
297 --
298 -- NOTE
299 --
300 -- End of Comments
301 -- ==============================================================================
302
303
304 PROCEDURE Validate_Imp_Doc(
305 p_api_version_number IN NUMBER,
306 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308 p_imp_doc_rec IN imp_doc_rec_type,
309 p_validation_mode IN VARCHAR2,
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2
313 );
314
315 -- ==============================================================================
316 -- Start of Comments
317 -- ==============================================================================
318 -- API Name
319 -- Imp_Doc_Items
320 --
321 -- Version : Current version 1.0
322 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. Validate the unique keys, lookups here
327 --
328 -- History
329 --
330 -- NOTE
331 --
332 -- End of Comments
333 -- ==============================================================================
334
335
336 PROCEDURE Check_Imp_Doc_Items (
337 P_imp_doc_rec IN imp_doc_rec_type,
338 p_validation_mode IN VARCHAR2,
339 x_return_status OUT NOCOPY VARCHAR2
340 );
341
342 -- ==============================================================================
343 -- Start of Comments
344 -- ==============================================================================
345 -- API Name
346 -- Validate_Imp_Doc_Rec
347 --
348 -- Version : Current version 1.0
349 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 -- 2. Developer can manually added inter-field level validation.
354 --
355 -- History
356 --
357 -- NOTE
358 --
359 -- End of Comments
360 -- ==============================================================================
361
362
363 PROCEDURE Validate_Imp_Doc_Rec (
364 p_api_version_number IN NUMBER,
365 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366 x_return_status OUT NOCOPY VARCHAR2,
367 x_msg_count OUT NOCOPY NUMBER,
368 x_msg_data OUT NOCOPY VARCHAR2,
369 p_imp_doc_rec IN imp_doc_rec_type
370 );
371
372 END AMS_Imp_Doc_PVT;