[Home] [Help]
PACKAGE BODY: APPS.IBC_CONTENT_ITEMS_PKG
Source
1 PACKAGE BODY Ibc_Content_Items_Pkg AS
2 /* $Header: ibctconb.pls 120.2 2006/11/15 10:10:34 sharma ship $*/
3
4 -- Purpose: Table Handler for Ibc_Content_Items_Pkg table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11 -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
12 -- to the APIs
13 -- Edward Nunez 12/04/2003 Got rid of handling of ovn in update_row
14 -- Edward Nunez 12/09/2003 Hardcoding 'F' to wd_restricted_flag as it is
15 -- not support for current release. Only in insert_row
16 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
17 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
18
19 G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CONTENT_ITEMS_PKG';
20 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibctconb.pls';
21
22 G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
23 G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
24
25
26 PROCEDURE INSERT_ROW (
27 x_rowid OUT NOCOPY VARCHAR2
28 ,px_content_item_id IN OUT NOCOPY NUMBER
29 ,p_content_type_code IN VARCHAR2
30 ,p_item_reference_code IN VARCHAR2
31 ,p_directory_node_id IN NUMBER
32 ,p_parent_item_id IN NUMBER
33 ,p_live_citem_version_id IN NUMBER
34 ,p_content_item_status IN VARCHAR2
35 ,p_locked_by_user_id IN NUMBER
36 ,p_wd_restricted_flag IN VARCHAR2
37 ,p_base_language IN VARCHAR2
38 ,p_translation_required_flag IN VARCHAR2
39 ,p_owner_resource_id IN NUMBER
40 ,p_owner_resource_type IN VARCHAR2
41 ,p_application_id IN NUMBER
42 ,p_request_id IN NUMBER
43 ,p_object_version_number IN NUMBER --DEFAULT 1
44 ,p_creation_date IN DATE --DEFAULT NULL
45 ,p_created_by IN NUMBER --DEFAULT NULL
46 ,p_last_update_date IN DATE --DEFAULT NULL
47 ,p_last_updated_by IN NUMBER --DEFAULT NULL
48 ,p_last_update_login IN NUMBER --DEFAULT NULL
49 ,p_encrypt_flag IN VARCHAR2 --DEFAULT NULL
50 ) IS
51 CURSOR C IS SELECT ROWID FROM IBC_CONTENT_ITEMS
52 WHERE CONTENT_ITEM_ID = px_CONTENT_ITEM_ID;
53
54 CURSOR c2 IS SELECT ibc_content_items_s1.NEXTVAL FROM dual;
55
56 G_API_NAME CONSTANT VARCHAR2(30) := 'INSERT_ROW';
57
58 BEGIN
59
60 -- Primary key validation check
61
62 IF ((px_CONTENT_ITEM_ID IS NULL) OR
63 (px_CONTENT_ITEM_ID = FND_API.G_MISS_NUM))
64 THEN
65 OPEN c2;
66 FETCH c2 INTO px_CONTENT_ITEM_ID;
67 CLOSE c2;
68 END IF;
69
70 INSERT INTO IBC_CONTENT_ITEMS (
71 CONTENT_ITEM_ID,
72 CONTENT_TYPE_CODE,
73 ITEM_REFERENCE_CODE,
74 DIRECTORY_NODE_ID,
75 parent_item_id,
76 LIVE_CITEM_VERSION_ID,
77 CONTENT_ITEM_STATUS,
78 LOCKED_BY_USER_ID,
79 WD_RESTRICTED_FLAG,
80 BASE_LANGUAGE,
81 TRANSLATION_REQUIRED_FLAG,
82 OWNER_RESOURCE_ID,
83 OWNER_RESOURCE_TYPE,
84 APPLICATION_ID,
85 REQUEST_ID,
86 OBJECT_VERSION_NUMBER,
87 CREATION_DATE,
88 CREATED_BY,
89 LAST_UPDATE_DATE,
90 LAST_UPDATED_BY,
91 LAST_UPDATE_LOGIN,
92 encrypt_flag
93 ) VALUES (
94 px_content_item_id
95 ,p_content_type_code
96 ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))
97 ,p_directory_node_id
98 ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99 ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100 ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)
101 ,DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,p_locked_by_user_id)
102 ,'F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
103 ,p_base_language
104 ,p_translation_required_flag
105 ,DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_owner_resource_id)
106 ,p_owner_resource_type
107 ,DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,FND_GLOBAL.resp_appl_id,p_application_id)
108 ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
109 ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
110 ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
111 ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
112 ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
113 ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
114 ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
115 ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,p_encrypt_flag)
116
117 );
118
119 OPEN c;
120 FETCH c INTO X_ROWID;
121 IF (c%NOTFOUND) THEN
122 CLOSE c;
123 FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
124 FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
125 FND_MESSAGE.Set_token('API_NAME' , G_api_name);
126 FND_MSG_PUB.ADD;
127 RAISE FND_API.G_EXC_ERROR;
128 -- RAISE NO_DATA_FOUND;
129 END IF;
130 CLOSE c;
131
132 END INSERT_ROW;
133
134 PROCEDURE LOCK_ROW (
135 p_CONTENT_ITEM_ID IN NUMBER,
136 p_CONTENT_TYPE_CODE IN VARCHAR2,
137 p_ITEM_REFERENCE_CODE IN VARCHAR2,
138 p_DIRECTORY_NODE_ID IN NUMBER,
139 p_parent_item_ID IN NUMBER,
140 p_LIVE_CITEM_VERSION_ID IN NUMBER,
141 p_CONTENT_ITEM_STATUS IN VARCHAR2,
142 p_LOCKED_BY_USER_ID IN NUMBER,
143 p_WD_RESTRICTED_FLAG IN VARCHAR2,
144 p_BASE_LANGUAGE IN VARCHAR2,
145 p_TRANSLATION_REQUIRED_FLAG IN VARCHAR2,
146 p_OWNER_RESOURCE_ID IN NUMBER,
147 p_APPLICATION_ID IN NUMBER,
148 p_REQUEST_ID IN NUMBER,
149 p_OBJECT_VERSION_NUMBER IN NUMBER
150 ) IS
151 CURSOR c IS SELECT
152 CONTENT_TYPE_CODE,
153 ITEM_REFERENCE_CODE,
154 DIRECTORY_NODE_ID,
155 LIVE_CITEM_VERSION_ID,
156 CONTENT_ITEM_STATUS,
157 LOCKED_BY_USER_ID,
158 WD_RESTRICTED_FLAG,
159 BASE_LANGUAGE,
160 TRANSLATION_REQUIRED_FLAG,
161 OWNER_RESOURCE_ID,
162 APPLICATION_ID,
163 REQUEST_ID,
164 OBJECT_VERSION_NUMBER
165 FROM IBC_CONTENT_ITEMS
166 WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
167 FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;
168 recinfo c%ROWTYPE;
169
170
171 G_API_NAME CONSTANT VARCHAR2(30) := 'LOCK_ROW';
172
173 BEGIN
174 OPEN c;
175 FETCH c INTO recinfo;
176 IF (c%NOTFOUND) THEN
177 CLOSE c;
178 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
179 app_exception.raise_exception;
180 END IF;
181 CLOSE c;
182 IF ( (recinfo.CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE)
183 AND (recinfo.DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID)
184 AND ((recinfo.LIVE_CITEM_VERSION_ID = p_LIVE_CITEM_VERSION_ID)
185 OR ((recinfo.LIVE_CITEM_VERSION_ID IS NULL) AND (p_LIVE_CITEM_VERSION_ID IS NULL)))
186 AND ((recinfo.ITEM_REFERENCE_CODE = p_ITEM_REFERENCE_CODE)
187 OR ((recinfo.ITEM_REFERENCE_CODE IS NULL) AND (p_ITEM_REFERENCE_CODE IS NULL)))
188 AND ((recinfo.CONTENT_ITEM_STATUS = p_CONTENT_ITEM_STATUS)
189 OR ((recinfo.CONTENT_ITEM_STATUS IS NULL) AND (p_CONTENT_ITEM_STATUS IS NULL)))
190 AND ((recinfo.LOCKED_BY_USER_ID = p_LOCKED_BY_USER_ID)
191 OR ((recinfo.LOCKED_BY_USER_ID IS NULL) AND (p_LOCKED_BY_USER_ID IS NULL)))
192 AND (recinfo.WD_RESTRICTED_FLAG = p_WD_RESTRICTED_FLAG)
193 AND (recinfo.BASE_LANGUAGE = p_BASE_LANGUAGE)
194 AND (recinfo.TRANSLATION_REQUIRED_FLAG = p_TRANSLATION_REQUIRED_FLAG)
195 AND (recinfo.OWNER_RESOURCE_ID = p_OWNER_RESOURCE_ID)
196 AND (recinfo.APPLICATION_ID = p_APPLICATION_ID)
197 AND ((recinfo.REQUEST_ID = p_REQUEST_ID)
198 OR ((recinfo.REQUEST_ID IS NULL) AND (p_REQUEST_ID IS NULL)))
199 AND (recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
200 ) THEN
201 NULL;
202 ELSE
203 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
204 app_exception.raise_exception;
205 END IF;
206
207 END LOCK_ROW;
208
209 PROCEDURE UPDATE_ROW (
210 p_content_item_id IN NUMBER
211 ,p_content_type_code IN VARCHAR2 --DEFAULT NULL
212 ,p_item_reference_code IN VARCHAR2 --DEFAULT NULL
213 ,p_directory_node_id IN NUMBER --DEFAULT NULL
214 ,p_parent_item_id IN NUMBER --DEFAULT NULL
215 ,p_live_citem_version_id IN NUMBER --DEFAULT NULL
216 ,p_content_item_status IN VARCHAR2 --DEFAULT NULL
217 ,p_locked_by_user_id IN NUMBER --DEFAULT NULL
218 ,p_wd_restricted_flag IN VARCHAR2 --DEFAULT NULL
219 ,p_base_language IN VARCHAR2 --DEFAULT NULL
220 ,p_translation_required_flag IN VARCHAR2 --DEFAULT NULL
221 ,p_owner_resource_id IN NUMBER --DEFAULT NULL
222 ,p_owner_resource_type IN VARCHAR2 --DEFAULT NULL
223 ,p_application_id IN NUMBER --DEFAULT NULL
224 ,p_request_id IN NUMBER --DEFAULT NULL
225 ,px_object_version_number IN OUT NOCOPY NUMBER
226 ,p_last_update_date IN DATE --DEFAULT NULL
227 ,p_last_updated_by IN NUMBER --DEFAULT NULL
228 ,p_last_update_login IN NUMBER --DEFAULT NULL
229 ,p_encrypt_flag IN VARCHAR2 --DEFAULT NULL
230 ) IS
231
232 G_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
233 CURSOR cur_object_version(cv_content_item_id NUMBER) IS
234 SELECT object_version_number
235 FROM ibc_content_items
236 WHERE content_item_id = cv_content_item_id;
237 l_object_version_number NUMBER;
238
239 BEGIN
240 UPDATE IBC_CONTENT_ITEMS SET
241 content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242 ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243 ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244 ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245 ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246 ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247 ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248 -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249 ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
250 ,base_language = DECODE(p_base_language,FND_API.G_MISS_CHAR,NULL,NULL,base_language,p_base_language)
251 ,translation_required_flag = DECODE(p_translation_required_flag,FND_API.G_MISS_CHAR,NULL,NULL,translation_required_flag,p_translation_required_flag)
252 ,owner_resource_id = DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,NULL,NULL,owner_resource_id,p_owner_resource_id)
253 ,owner_resource_type = DECODE(p_owner_resource_type,FND_API.G_MISS_CHAR,NULL,NULL,owner_resource_type,p_owner_resource_type)
254 ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,application_id,p_application_id)
255 ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
256 -- ,object_version_number = NVL(object_version_number,0) + 1
257 ,object_version_number = 1
258 ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
259 ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
260 ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
261 ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,p_encrypt_flag)
262 WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
263
264 -- AND object_version_number = DECODE(px_object_version_number,
265 -- FND_API.G_MISS_NUM,
266 -- object_version_number,
267 -- NULL,
268 -- object_version_number,
269 -- px_object_version_number);
270
271 px_object_version_number := 1;
272
273 -- IF (
274 -- (px_object_version_number IS NULL)
275 -- OR
276 -- (px_object_version_number = FND_API.G_MISS_NUM )
277 -- ) THEN
278 -- OPEN cur_object_version(p_CONTENT_ITEM_ID);
279 -- FETCH cur_object_version INTO l_object_version_number;
280 -- CLOSE cur_object_version;
281 -- px_object_version_number := l_object_version_number;
282 -- ELSE
283 -- px_object_version_number := px_object_version_number + 1;
284 -- END IF;
285 --
286
287 IF (SQL%NOTFOUND) THEN
288 FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
289 FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
290 FND_MESSAGE.Set_token('API_NAME' , G_api_name);
291 FND_MSG_PUB.ADD;
292 RAISE FND_API.G_EXC_ERROR;
293 -- RAISE NO_DATA_FOUND;
294 END IF;
295
296 END UPDATE_ROW;
297
298 PROCEDURE DELETE_ROW (
299 p_CONTENT_ITEM_ID IN NUMBER
300 ) IS
301
302 G_API_NAME CONSTANT VARCHAR2(30) := 'DELETE_ROW';
303
304 BEGIN
305
306 DELETE FROM IBC_CONTENT_ITEMS
307 WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
308
309 IF (SQL%NOTFOUND) THEN
310 FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
311 FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
312 FND_MESSAGE.Set_token('API_NAME' , G_api_name);
313 FND_MSG_PUB.ADD;
314 RAISE FND_API.G_EXC_ERROR;
315 -- RAISE NO_DATA_FOUND;
316 END IF;
317 END DELETE_ROW;
318
319 PROCEDURE LOAD_ROW (
320 p_UPLOAD_MODE VARCHAR2,
321 p_CONTENT_ITEM_ID NUMBER,
322 p_ITEM_REFERENCE_CODE VARCHAR2,
323 p_CONTENT_TYPE_CODE VARCHAR2,
324 p_DIRECTORY_NODE_ID NUMBER,
325 p_parent_item_ID IN NUMBER ,--DEFAULT NULL,
326 p_LIVE_CITEM_VERSION_ID NUMBER,
327 p_CONTENT_ITEM_STATUS VARCHAR2,
328 p_LOCKED_BY_USER_ID NUMBER,
329 --p_REUSABLE_FLAG VARCHAR2 ,--DEFAULT NULL,
330 p_WD_RESTRICTED_FLAG VARCHAR2,
331 p_BASE_LANGUAGE VARCHAR2,
332 p_TRANSLATION_REQUIRED_FLAG VARCHAR2,
333 p_OWNER_RESOURCE_ID NUMBER,
334 p_OWNER_RESOURCE_TYPE VARCHAR2,
335 p_APPLICATION_ID NUMBER,
336 p_OWNER IN VARCHAR2,
337 p_ENCRYPT_FLAG IN VARCHAR2, --DEFAULT NULL
338 p_LAST_UPDATE_DATE VARCHAR2
339 ) IS
340 BEGIN
341 DECLARE
342 l_user_id NUMBER := 0;
343 l_row_id VARCHAR2(64);
344 lx_object_version_number NUMBER := FND_API.G_MISS_NUM;
345 lx_CONTENT_ITEM_ID NUMBER := p_CONTENT_ITEM_ID;
346 l_last_update_date DATE;
347
348 db_user_id NUMBER := 0;
349 db_last_update_date DATE;
350
351 BEGIN
352 --get last updated by user id
353 l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
354
355 --translate data type VARCHAR2 to DATE for last_update_date
356 l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
357
358 -- get updatedby and update_date values if existing in db
359 SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
360 FROM IBC_CONTENT_ITEMS
361 WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
362
363 IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
364 db_user_id, db_last_update_date, p_upload_mode )) THEN
365
366
367 Ibc_Content_Items_Pkg.UPDATE_ROW (
368 p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369 ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370 ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371 ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372 ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373 ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374 ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375 ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376 ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377 ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378 ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379 ,p_owner_resource_id => l_user_id
380 ,p_owner_resource_type => 'USER'
381 ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
382 ,p_last_updated_by => l_user_id
383 ,p_last_update_date => l_last_update_date
384 ,p_last_update_login => 0
385 ,px_object_version_number => lx_object_version_number
386 ,p_encrypt_flag => NVL(p_encrypt_flag,FND_API.G_MISS_CHAR)
387 );
388 END IF;
389 EXCEPTION
390 WHEN no_data_found THEN
391 Ibc_Content_Items_Pkg.INSERT_ROW (
392 X_ROWID => l_row_id,
393 px_CONTENT_ITEM_ID => lx_CONTENT_ITEM_ID,
394 p_ITEM_REFERENCE_CODE => p_ITEM_REFERENCE_CODE,
395 p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
396 p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
397 p_parent_item_ID => p_parent_item_ID,
398 p_LIVE_CITEM_VERSION_ID => p_LIVE_CITEM_VERSION_ID,
399 p_CONTENT_ITEM_STATUS => p_CONTENT_ITEM_STATUS,
400 p_LOCKED_BY_USER_ID => p_LOCKED_BY_USER_ID,
401 p_WD_RESTRICTED_FLAG => p_WD_RESTRICTED_FLAG,
402 p_BASE_LANGUAGE => p_BASE_LANGUAGE,
403 p_TRANSLATION_REQUIRED_FLAG => p_TRANSLATION_REQUIRED_FLAG,
404 p_OWNER_RESOURCE_ID => l_user_id,
405 p_OWNER_RESOURCE_TYPE => 'USER',
406 p_APPLICATION_ID => p_APPLICATION_ID,
407 p_request_id => NULL,
408 p_OBJECT_VERSION_NUMBER => 1,
409 p_CREATION_DATE => SYSDATE,
410 p_CREATED_BY => l_user_id,
411 p_LAST_UPDATE_DATE => l_last_update_date,
412 p_LAST_UPDATED_BY => l_user_id,
413 p_LAST_UPDATE_LOGIN => 0,
414 p_encrypt_flag => p_encrypt_flag);
415 END;
416 END LOAD_ROW;
417
418
419 PROCEDURE LOAD_SEED_ROW (
420 p_UPLOAD_MODE VARCHAR2,
421 p_CONTENT_ITEM_ID NUMBER,
422 p_ITEM_REFERENCE_CODE VARCHAR2,
423 p_CONTENT_TYPE_CODE VARCHAR2,
424 p_DIRECTORY_NODE_ID NUMBER,
425 p_parent_item_ID IN NUMBER ,--DEFAULT NULL,
426 p_LIVE_CITEM_VERSION_ID NUMBER,
427 p_CONTENT_ITEM_STATUS VARCHAR2,
428 p_LOCKED_BY_USER_ID NUMBER,
429 --p_REUSABLE_FLAG VARCHAR2 DEFAULT NULL,
430 p_WD_RESTRICTED_FLAG VARCHAR2,
431 p_BASE_LANGUAGE VARCHAR2,
432 p_TRANSLATION_REQUIRED_FLAG VARCHAR2,
433 p_OWNER_RESOURCE_ID NUMBER,
434 p_OWNER_RESOURCE_TYPE VARCHAR2,
435 p_APPLICATION_ID NUMBER,
436 p_OWNER IN VARCHAR2,
437 p_ENCRYPT_FLAG IN VARCHAR2 DEFAULT NULL,
438 p_LAST_UPDATE_DATE VARCHAR2) IS
439
440 BEGIN
441 IF (p_UPLOAD_MODE = 'NLS') THEN
442 NULL;
443 ELSE
444 IBC_CONTENT_ITEMS_PKG.LOAD_ROW (
445 p_UPLOAD_MODE => p_UPLOAD_MODE,
446 p_CONTENT_ITEM_ID => TO_NUMBER(p_CONTENT_ITEM_ID),
447 p_ITEM_REFERENCE_CODE => p_ITEM_REFERENCE_CODE,
448 p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
449 p_DIRECTORY_NODE_ID => TO_NUMBER(p_DIRECTORY_NODE_ID),
450 p_LIVE_CITEM_VERSION_ID => TO_NUMBER(p_LIVE_CITEM_VERSION_ID),
451 p_CONTENT_ITEM_STATUS => p_CONTENT_ITEM_STATUS,
452 p_LOCKED_BY_USER_ID => TO_NUMBER(p_LOCKED_BY_USER_ID),
453 p_PARENT_ITEM_ID => TO_NUMBER(p_PARENT_ITEM_ID),
454 p_WD_RESTRICTED_FLAG => p_WD_RESTRICTED_FLAG,
455 p_BASE_LANGUAGE => p_BASE_LANGUAGE,
456 p_TRANSLATION_REQUIRED_FLAG =>p_TRANSLATION_REQUIRED_FLAG,
457 p_OWNER_RESOURCE_ID => TO_NUMBER(p_OWNER_RESOURCE_ID),
458 p_OWNER_RESOURCE_TYPE => p_OWNER_RESOURCE_TYPE,
459 p_APPLICATION_ID => TO_NUMBER(p_APPLICATION_ID),
460 p_ENCRYPT_FLAG => p_ENCRYPT_FLAG,
461 p_OWNER => p_OWNER,
462 p_LAST_UPDATE_DATE => p_LAST_UPDATE_DATE );
463 END IF;
464
465 END LOAD_SEED_ROW;
466
467
468 END Ibc_Content_Items_Pkg;