1 PACKAGE AMS_Imp_Doc_Con_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvidcs.pls 115.3 2002/11/12 23:38:19 jieli noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Imp_Doc_Con_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_doccon_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_doccon_rec_type IS RECORD
62 (
63 imp_doc_content_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 file_id NUMBER,
72 file_name VARCHAR2(2000)
73 );
74
75 g_miss_imp_doc_rec imp_doccon_rec_type := NULL;
76 TYPE imp_doc_tbl_type IS TABLE OF imp_doccon_rec_type INDEX BY BINARY_INTEGER;
77 g_miss_imp_doc_tbl imp_doc_tbl_type;
78
79 -- ==============================================================================
80 -- Start of Comments
81 -- ==============================================================================
82 -- API Name
83 -- Create_Imp_Doc
84 -- Type
85 -- Private
86 -- Pre-Req
87 --
88 -- Parameters
89 --
90 -- IN
91 -- p_api_version_number IN NUMBER Required
92 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
93 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
94 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
95 -- p_imp_doc_rec IN imp_doccon_rec_type Required
96 --
97 -- OUT
98 -- x_return_status OUT VARCHAR2
99 -- x_msg_count OUT NUMBER
100 -- x_msg_data OUT VARCHAR2
101 -- Version : Current version 1.0
102 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
103 -- and basic operation, developer must manually add parameters and business logic as necessary.
104 --
105 -- History
106 --
107 -- NOTE
108 --
109 -- End of Comments
110 -- ==============================================================================
111
112 PROCEDURE Create_Imp_Doc_Content(
113 p_api_version_number IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121
122 p_imp_doc_rec IN imp_doccon_rec_type := g_miss_imp_doc_rec,
123 x_imp_doccontent_id OUT NOCOPY NUMBER
124 );
125
126 -- ==============================================================================
127 -- Start of Comments
128 -- ==============================================================================
129 -- API Name
130 -- Update_Imp_Doc_Con
131 -- Type
132 -- Private
133 -- Pre-Req
134 --
135 -- Parameters
136 --
137 -- IN
138 -- p_api_version_number IN NUMBER Required
139 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
140 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
141 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
142 -- p_imp_doc_rec IN imp_doccon_rec_type Required
143 --
144 -- OUT
145 -- x_return_status OUT VARCHAR2
146 -- x_msg_count OUT NUMBER
147 -- x_msg_data OUT VARCHAR2
148 -- Version : Current version 1.0
149 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
150 -- and basic operation, developer must manually add parameters and business logic as necessary.
151 --
152 -- History
153 --
154 -- NOTE
155 --
156 -- End of Comments
157 -- ==============================================================================
158
159 PROCEDURE Update_Imp_Doc_Con(
160 p_api_version_number IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162 p_commit IN VARCHAR2 := FND_API.G_FALSE,
163 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168
169 p_imp_doc_rec IN imp_doccon_rec_type,
170 x_object_version_number OUT NOCOPY NUMBER
171 );
172
173 -- ==============================================================================
174 -- Start of Comments
175 -- ==============================================================================
176 -- API Name
177 -- Delete_Imp_Doc_Con
178 -- Type
179 -- Private
180 -- Pre-Req
181 --
185 -- p_api_version_number IN NUMBER Required
182 -- Parameters
183 --
184 -- IN
186 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189 -- p_imp_document_id IN NUMBER
190 -- p_object_version_number IN NUMBER Optional Default = NULL
191 --
192 -- OUT
193 -- x_return_status OUT VARCHAR2
194 -- x_msg_count OUT NUMBER
195 -- x_msg_data OUT VARCHAR2
196 -- Version : Current version 1.0
197 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
198 -- and basic operation, developer must manually add parameters and business logic as necessary.
199 --
200 -- History
201 --
202 -- NOTE
203 --
204 -- End of Comments
205 -- ==============================================================================
206
207 PROCEDURE Delete_Imp_Doc_Con(
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 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_imp_doccontent_id IN NUMBER,
216 p_object_version_number IN NUMBER
217 );
218
219 -- ==============================================================================
220 -- Start of Comments
221 -- ==============================================================================
222 -- API Name
223 -- Lock_Imp_Doc_Con
224 -- Type
225 -- Private
226 -- Pre-Req
227 --
228 -- Parameters
229 --
230 -- IN
231 -- p_api_version_number IN NUMBER Required
232 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
233 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
234 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
235 -- p_imp_doc_rec IN imp_doccon_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 -- History
246 --
247 -- NOTE
248 --
249 -- End of Comments
250 -- ==============================================================================
251
252 PROCEDURE Lock_Imp_Doc_Con(
256 x_return_status OUT NOCOPY VARCHAR2,
253 p_api_version_number IN NUMBER,
254 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
255
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259
260 p_imp_doccontent_id IN NUMBER,
261 p_object_version IN NUMBER
262 );
263
264 -- ==============================================================================
265 -- Start of Comments
266 -- ==============================================================================
267 -- API Name
268 -- add_language
269 -- Type
270 -- Private
271 -- History
272 --
273 -- NOTE
274 --
275 -- End of Comments
276 -- ===============================================================
277
278 --PROCEDURE Add_Language;
279
280 -- ==============================================================================
281 -- Start of Comments
282 -- ==============================================================================
283 -- API Name
284 -- Validate_Imp_Doc
285 --
286 -- Version : Current version 1.0
287 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation procedure.
290 -- The actual validation detail is needed to be added.
291 -- 2. We can also validate table instead of record. There will be an option for user to choose.
292 --
293 -- History
294 --
295 -- NOTE
296 --
297 -- End of Comments
298 -- ==============================================================================
299
300
301 PROCEDURE Validate_Imp_Doc(
302 p_api_version_number IN NUMBER,
303 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305 p_imp_doc_rec IN imp_doccon_rec_type,
306 p_validation_mode IN VARCHAR2,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2
310 );
311
312 -- ==============================================================================
313 -- Start of Comments
314 -- ==============================================================================
315 -- API Name
316 -- Imp_Doc_Items
317 --
318 -- Version : Current version 1.0
319 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
320 -- For create: G_CREATE, for update: G_UPDATE
321 -- Note: 1. This is automated generated item level validation procedure.
322 -- The actual validation detail is needed to be added.
323 -- 2. Validate the unique keys, lookups here
324 --
325 -- History
326 --
327 -- NOTE
328 --
329 -- End of Comments
330 -- ==============================================================================
331
332
336 x_return_status OUT NOCOPY VARCHAR2
333 PROCEDURE Check_Imp_Doc_Items (
334 P_imp_doc_rec IN imp_doccon_rec_type,
335 p_validation_mode IN VARCHAR2,
337 );
338
339 -- ==============================================================================
340 -- Start of Comments
341 -- ==============================================================================
342 -- API Name
343 -- Validate_Imp_Doc_Rec
344 --
345 -- Version : Current version 1.0
346 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
347 -- For create: G_CREATE, for update: G_UPDATE
348 -- Note: 1. This is automated generated item level validation procedure.
349 -- The actual validation detail is needed to be added.
350 -- 2. Developer can manually added inter-field level validation.
351 --
352 -- History
353 --
354 -- NOTE
355 --
356 -- End of Comments
357 -- ==============================================================================
358
359
360 PROCEDURE Validate_Imp_Doc_Rec (
361 p_api_version_number IN NUMBER,
362 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363 x_return_status OUT NOCOPY VARCHAR2,
364 x_msg_count OUT NOCOPY NUMBER,
365 x_msg_data OUT NOCOPY VARCHAR2,
366 p_imp_doc_rec IN imp_doccon_rec_type
367 );
368
369 END AMS_Imp_Doc_Con_PVT;