eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CONTENT_ITEMS_PKG dependencies on IBC_CONTENT_ITEMS

Line 1: PACKAGE BODY Ibc_Content_Items_Pkg AS

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:

Line 4: -- Purpose: Table Handler for Ibc_Content_Items_Pkg table.

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: -- --------- ------ ------------------------------------------

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CONTENT_ITEMS_PKG';

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;

Line 51: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_ITEMS

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:

Line 54: CURSOR c2 IS SELECT ibc_content_items_s1.NEXTVAL FROM dual;

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

Line 70: INSERT INTO IBC_CONTENT_ITEMS (

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,

Line 165: FROM IBC_CONTENT_ITEMS

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:

Line 235: FROM ibc_content_items

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

Line 240: UPDATE IBC_CONTENT_ITEMS SET

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)

Line 306: DELETE FROM IBC_CONTENT_ITEMS

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');

Line 360: FROM IBC_CONTENT_ITEMS

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

Line 367: Ibc_Content_Items_Pkg.UPDATE_ROW (

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)

Line 391: Ibc_Content_Items_Pkg.INSERT_ROW (

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,

Line 444: IBC_CONTENT_ITEMS_PKG.LOAD_ROW (

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,

Line 468: END Ibc_Content_Items_Pkg;

464:
465: END LOAD_SEED_ROW;
466:
467:
468: END Ibc_Content_Items_Pkg;