1 PACKAGE OKC_ARTICLE_VERSIONS_PVT AS
2 /* $Header: OKCVAVNS.pls 120.1.12000000.1 2007/01/17 11:32:06 appldev ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_article_version_id IN NUMBER := NULL,
13 p_article_id IN NUMBER,
14 p_article_version_number IN NUMBER := NULL,
15 p_article_text IN CLOB,
16 p_provision_yn IN VARCHAR2,
17 p_insert_by_reference IN VARCHAR2,
18 p_lock_text IN VARCHAR2,
19 p_global_yn IN VARCHAR2,
20 p_article_language IN VARCHAR2,
21 p_article_status IN VARCHAR2,
22 p_sav_release IN VARCHAR2,
23 p_start_date IN DATE,
24 p_end_date IN DATE,
25 p_std_article_version_id IN NUMBER,
26 p_display_name IN VARCHAR2,
27 p_translated_yn IN VARCHAR2,
28 p_article_description IN VARCHAR2,
29 p_date_approved IN DATE,
30 p_default_section IN VARCHAR2,
31 p_reference_source IN VARCHAR2,
32 p_reference_text IN VARCHAR2,
33 p_orig_system_reference_code IN VARCHAR2,
34 p_orig_system_reference_id1 IN VARCHAR2,
35 p_orig_system_reference_id2 IN VARCHAR2,
36 p_additional_instructions IN VARCHAR2,
37 p_variation_description IN VARCHAR2,
38 p_program_id IN NUMBER := NULL,
39 p_program_login_id IN NUMBER := NULL,
40 p_program_application_id IN NUMBER := NULL,
41 p_request_id IN NUMBER := NULL,
42 p_current_org_id IN NUMBER := NULL,
43 p_date_published IN DATE DEFAULT NULL,
44
45 p_attribute_category IN VARCHAR2 := NULL,
46 p_attribute1 IN VARCHAR2 := NULL,
47 p_attribute2 IN VARCHAR2 := NULL,
48 p_attribute3 IN VARCHAR2 := NULL,
49 p_attribute4 IN VARCHAR2 := NULL,
50 p_attribute5 IN VARCHAR2 := NULL,
51 p_attribute6 IN VARCHAR2 := NULL,
52 p_attribute7 IN VARCHAR2 := NULL,
53 p_attribute8 IN VARCHAR2 := NULL,
54 p_attribute9 IN VARCHAR2 := NULL,
55 p_attribute10 IN VARCHAR2 := NULL,
56 p_attribute11 IN VARCHAR2 := NULL,
57 p_attribute12 IN VARCHAR2 := NULL,
58 p_attribute13 IN VARCHAR2 := NULL,
59 p_attribute14 IN VARCHAR2 := NULL,
60 p_attribute15 IN VARCHAR2 := NULL,
61
62 x_earlier_adoption_type OUT NOCOPY VARCHAR2,
63 x_earlier_version_id OUT NOCOPY NUMBER,
64 x_article_version_id OUT NOCOPY NUMBER
65 );
66
67 PROCEDURE lock_row(
68 x_return_status OUT NOCOPY VARCHAR2,
69
70 p_article_version_id IN NUMBER,
71
72 p_object_version_number IN NUMBER
73 );
74
75 PROCEDURE update_row(
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT NOCOPY VARCHAR2,
78
79 p_article_version_id IN NUMBER,
80 p_article_id IN NUMBER,
81 p_article_version_number IN NUMBER,
82 p_article_text IN CLOB,
83 p_provision_yn IN VARCHAR2,
84 p_insert_by_reference IN VARCHAR2,
85 p_lock_text IN VARCHAR2,
86 p_global_yn IN VARCHAR2,
87 p_article_language IN VARCHAR2,
88 p_article_status IN VARCHAR2,
89 p_sav_release IN VARCHAR2,
90 p_start_date IN DATE,
91 p_end_date IN DATE,
92 p_std_article_version_id IN NUMBER,
93 p_display_name IN VARCHAR2,
94 p_translated_yn IN VARCHAR2,
95 p_article_description IN VARCHAR2,
96 p_date_approved IN DATE,
97 p_default_section IN VARCHAR2,
98 p_reference_source IN VARCHAR2,
99 p_reference_text IN VARCHAR2,
100 p_orig_system_reference_code IN VARCHAR2,
101 p_orig_system_reference_id1 IN VARCHAR2,
102 p_orig_system_reference_id2 IN VARCHAR2,
103 p_additional_instructions IN VARCHAR2,
104 p_variation_description IN VARCHAR2,
105 p_program_id IN NUMBER := NULL,
106 p_program_login_id IN NUMBER := NULL,
107 p_program_application_id IN NUMBER := NULL,
108 p_request_id IN NUMBER := NULL,
109 p_current_org_id IN NUMBER := NULL,
110 p_date_published IN DATE DEFAULT NULL,
111
112 p_attribute_category IN VARCHAR2 := NULL,
113 p_attribute1 IN VARCHAR2 := NULL,
114 p_attribute2 IN VARCHAR2 := NULL,
115 p_attribute3 IN VARCHAR2 := NULL,
116 p_attribute4 IN VARCHAR2 := NULL,
117 p_attribute5 IN VARCHAR2 := NULL,
118 p_attribute6 IN VARCHAR2 := NULL,
119 p_attribute7 IN VARCHAR2 := NULL,
120 p_attribute8 IN VARCHAR2 := NULL,
121 p_attribute9 IN VARCHAR2 := NULL,
122 p_attribute10 IN VARCHAR2 := NULL,
123 p_attribute11 IN VARCHAR2 := NULL,
124 p_attribute12 IN VARCHAR2 := NULL,
125 p_attribute13 IN VARCHAR2 := NULL,
126 p_attribute14 IN VARCHAR2 := NULL,
127 p_attribute15 IN VARCHAR2 := NULL,
128
129 p_object_version_number IN NUMBER,
130 x_article_status IN VARCHAR2,
131 x_article_id OUT NOCOPY NUMBER,
132 x_earlier_version_id OUT NOCOPY NUMBER
133 );
134
135 PROCEDURE delete_row(
136 x_return_status OUT NOCOPY VARCHAR2,
137
138 p_article_version_id IN NUMBER,
139
140 p_object_version_number IN NUMBER
141 );
142
143 PROCEDURE validate_row(
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 p_import_action IN VARCHAR2 := NULL,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_earlier_adoption_type OUT NOCOPY VARCHAR2,
148 x_earlier_version_id OUT NOCOPY NUMBER,
149 x_earlier_version_number OUT NOCOPY NUMBER,
150 p_article_version_id IN NUMBER,
151 p_article_id IN NUMBER,
152 p_article_version_number IN NUMBER,
153 p_article_text IN CLOB,
154 p_provision_yn IN VARCHAR2,
155 p_insert_by_reference IN VARCHAR2,
156 p_lock_text IN VARCHAR2,
157 p_global_yn IN VARCHAR2,
158 p_article_language IN VARCHAR2,
159 p_article_status IN VARCHAR2,
160 p_sav_release IN VARCHAR2,
161 p_start_date IN DATE,
162 p_end_date IN DATE,
163 p_std_article_version_id IN NUMBER,
164 p_display_name IN VARCHAR2,
165 p_translated_yn IN VARCHAR2,
166 p_article_description IN VARCHAR2,
167 p_date_approved IN DATE,
168 p_default_section IN VARCHAR2,
169 p_reference_source IN VARCHAR2,
170 p_reference_text IN VARCHAR2,
171 p_orig_system_reference_code IN VARCHAR2,
172 p_orig_system_reference_id1 IN VARCHAR2,
173 p_orig_system_reference_id2 IN VARCHAR2,
174 p_additional_instructions IN VARCHAR2,
175 p_variation_description IN VARCHAR2,
176 p_program_id IN NUMBER := NULL,
177 p_program_login_id IN NUMBER := NULL,
178 p_program_application_id IN NUMBER := NULL,
179 p_request_id IN NUMBER := NULL,
180 p_current_org_id IN NUMBER := NULL,
181 p_date_published IN DATE DEFAULT NULL,
182 p_attribute_category IN VARCHAR2 := NULL,
183 p_attribute1 IN VARCHAR2 := NULL,
184 p_attribute2 IN VARCHAR2 := NULL,
185 p_attribute3 IN VARCHAR2 := NULL,
186 p_attribute4 IN VARCHAR2 := NULL,
187 p_attribute5 IN VARCHAR2 := NULL,
188 p_attribute6 IN VARCHAR2 := NULL,
189 p_attribute7 IN VARCHAR2 := NULL,
190 p_attribute8 IN VARCHAR2 := NULL,
191 p_attribute9 IN VARCHAR2 := NULL,
192 p_attribute10 IN VARCHAR2 := NULL,
193 p_attribute11 IN VARCHAR2 := NULL,
194 p_attribute12 IN VARCHAR2 := NULL,
195 p_attribute13 IN VARCHAR2 := NULL,
196 p_attribute14 IN VARCHAR2 := NULL,
197 p_attribute15 IN VARCHAR2 := NULL,
198
199 p_object_version_number IN NUMBER := NULL
200 );
201
202 FUNCTION get_rec (
203 p_article_version_id IN NUMBER,
204
205 x_article_id OUT NOCOPY NUMBER,
206 x_article_version_number OUT NOCOPY NUMBER,
207 x_article_text OUT NOCOPY CLOB,
208 x_provision_yn OUT NOCOPY VARCHAR2,
209 x_insert_by_reference OUT NOCOPY VARCHAR2,
210 x_lock_text OUT NOCOPY VARCHAR2,
211 x_global_yn OUT NOCOPY VARCHAR2,
212 x_article_language OUT NOCOPY VARCHAR2,
213 x_article_status OUT NOCOPY VARCHAR2,
214 x_sav_release OUT NOCOPY VARCHAR2,
215 x_start_date OUT NOCOPY DATE,
216 x_end_date OUT NOCOPY DATE,
217 x_std_article_version_id OUT NOCOPY NUMBER,
218 x_display_name OUT NOCOPY VARCHAR2,
219 x_translated_yn OUT NOCOPY VARCHAR2,
220 x_article_description OUT NOCOPY VARCHAR2,
221 x_date_approved OUT NOCOPY DATE,
222 x_default_section OUT NOCOPY VARCHAR2,
223 x_reference_source OUT NOCOPY VARCHAR2,
224 x_reference_text OUT NOCOPY VARCHAR2,
225 x_orig_system_reference_code OUT NOCOPY VARCHAR2,
226 x_orig_system_reference_id1 OUT NOCOPY VARCHAR2,
227 x_orig_system_reference_id2 OUT NOCOPY VARCHAR2,
228 x_additional_instructions OUT NOCOPY VARCHAR2,
229 x_variation_description OUT NOCOPY VARCHAR2,
230 x_date_published OUT NOCOPY DATE,
231 x_program_id OUT NOCOPY NUMBER,
232 x_program_login_id OUT NOCOPY NUMBER,
233 x_program_application_id OUT NOCOPY NUMBER,
234 x_request_id OUT NOCOPY NUMBER,
235 x_attribute_category OUT NOCOPY VARCHAR2,
236 x_attribute1 OUT NOCOPY VARCHAR2,
237 x_attribute2 OUT NOCOPY VARCHAR2,
238 x_attribute3 OUT NOCOPY VARCHAR2,
239 x_attribute4 OUT NOCOPY VARCHAR2,
240 x_attribute5 OUT NOCOPY VARCHAR2,
241 x_attribute6 OUT NOCOPY VARCHAR2,
242 x_attribute7 OUT NOCOPY VARCHAR2,
243 x_attribute8 OUT NOCOPY VARCHAR2,
244 x_attribute9 OUT NOCOPY VARCHAR2,
245 x_attribute10 OUT NOCOPY VARCHAR2,
246 x_attribute11 OUT NOCOPY VARCHAR2,
247 x_attribute12 OUT NOCOPY VARCHAR2,
248 x_attribute13 OUT NOCOPY VARCHAR2,
249 x_attribute14 OUT NOCOPY VARCHAR2,
250 x_attribute15 OUT NOCOPY VARCHAR2,
251 x_object_version_number OUT NOCOPY NUMBER,
252 x_created_by OUT NOCOPY NUMBER,
253 x_creation_date OUT NOCOPY DATE,
254 x_last_updated_by OUT NOCOPY NUMBER,
255 x_last_update_login OUT NOCOPY NUMBER,
256 x_last_update_date OUT NOCOPY DATE
257
258 ) RETURN VARCHAR2;
259
260 -- The following is a direct call to Validate Record without going through
261 -- get_rec as in validate_row. This API will be used by import and migration
262 -- only. In this API the actual values are being passed i.e. NULL is NULL and
263 -- hence should not be called with G_MISS_XXX
264
265 FUNCTION Validate_Record (
266 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267 p_import_action IN VARCHAR2 := NULL,
268
269 p_article_version_id IN NUMBER,
270 p_article_id IN NUMBER,
271 p_article_version_number IN NUMBER,
272 p_article_text IN CLOB,
273 p_provision_yn IN VARCHAR2,
274 p_insert_by_reference IN VARCHAR2,
275 p_lock_text IN VARCHAR2,
276 p_global_yn IN VARCHAR2,
277 p_article_language IN VARCHAR2,
278 p_article_status IN VARCHAR2,
279 p_sav_release IN VARCHAR2,
280 p_start_date IN DATE,
281 p_end_date IN DATE,
282 p_std_article_version_id IN NUMBER,
283 p_display_name IN VARCHAR2,
284 p_translated_yn IN VARCHAR2,
285 p_article_description IN VARCHAR2,
286 p_date_approved IN DATE,
287 p_default_section IN VARCHAR2,
288 p_reference_source IN VARCHAR2,
289 p_reference_text IN VARCHAR2,
290 p_orig_system_reference_code IN VARCHAR2,
291 p_orig_system_reference_id1 IN VARCHAR2,
292 p_orig_system_reference_id2 IN VARCHAR2,
293 p_additional_instructions IN VARCHAR2,
294 p_variation_description IN VARCHAR2,
295 p_program_id IN NUMBER := NULL,
296 p_program_login_id IN NUMBER := NULL,
297 p_program_application_id IN NUMBER := NULL,
298 p_request_id IN NUMBER := NULL,
299 p_current_org_id IN NUMBER := NULL,
300 p_date_published IN DATE DEFAULT NULL,
301 p_attribute_category IN VARCHAR2,
302 p_attribute1 IN VARCHAR2,
303 p_attribute2 IN VARCHAR2,
304 p_attribute3 IN VARCHAR2,
305 p_attribute4 IN VARCHAR2,
306 p_attribute5 IN VARCHAR2,
307 p_attribute6 IN VARCHAR2,
308 p_attribute7 IN VARCHAR2,
309 p_attribute8 IN VARCHAR2,
310 p_attribute9 IN VARCHAR2,
311 p_attribute10 IN VARCHAR2,
312 p_attribute11 IN VARCHAR2,
313 p_attribute12 IN VARCHAR2,
314 p_attribute13 IN VARCHAR2,
315 p_attribute14 IN VARCHAR2,
316 p_attribute15 IN VARCHAR2,
317 x_earlier_adoption_type OUT NOCOPY VARCHAR2,
318 x_earlier_version_number OUT NOCOPY NUMBER,
319 x_earlier_version_id OUT NOCOPY NUMBER,
320 x_article_language OUT NOCOPY VARCHAR2
321 ) RETURN VARCHAR2;
322
323 FUNCTION ArticleClob RETURN CLOB;
324
325 END OKC_ARTICLE_VERSIONS_PVT;