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