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_CITEM_RUNTIME_PVT dependencies on IBC_CONTENT_ITEMS

Line 29: l_wd_restricted_flag IBC_CONTENT_ITEMS.WD_RESTRICTED_FLAG%TYPE;

25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2
28: ) AS
29: l_wd_restricted_flag IBC_CONTENT_ITEMS.WD_RESTRICTED_FLAG%TYPE;
30: l_content_item_status IBC_CONTENT_ITEMS.CONTENT_ITEM_STATUS%TYPE;
31: l_parent_item_id NUMBER;
32: --
33: CURSOR Get_Citem IS

Line 30: l_content_item_status IBC_CONTENT_ITEMS.CONTENT_ITEM_STATUS%TYPE;

26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2
28: ) AS
29: l_wd_restricted_flag IBC_CONTENT_ITEMS.WD_RESTRICTED_FLAG%TYPE;
30: l_content_item_status IBC_CONTENT_ITEMS.CONTENT_ITEM_STATUS%TYPE;
31: l_parent_item_id NUMBER;
32: --
33: CURSOR Get_Citem IS
34: select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, WD_RESTRICTED_FLAG, LIVE_CITEM_VERSION_ID,

Line 36: from IBC_CONTENT_ITEMS

32: --
33: CURSOR Get_Citem IS
34: select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, WD_RESTRICTED_FLAG, LIVE_CITEM_VERSION_ID,
35: CONTENT_ITEM_STATUS, ENCRYPT_FLAG, PARENT_ITEM_ID
36: from IBC_CONTENT_ITEMS
37: where content_item_id = p_content_item_id;
38: BEGIN
39: -- Initialize message list if p_init_msg_list is set to TRUE.
40: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 224: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

220: -- // retrieve the based language version translation
221: CURSOR Get_Citem_Meta_BLang IS
222: select t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.DEFAULT_RENDITION_MIME_TYPE,
223: t.ATTACHMENT_FILE_NAME, t.ATTACHMENT_FILE_ID
224: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
225: where i.CONTENT_ITEM_ID = p_content_item_id
226: and t.citem_version_id = l_citem_version_id
227: and t.language = i.BASE_LANGUAGE;
228:

Line 372: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;

368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2
371: ) AS
372: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
373: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
374: l_live_citem_version_id NUMBER;
375: l_citem_version_id NUMBER;
376: l_encrypt_flag VARCHAR2(1);

Line 373: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;

369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2
371: ) AS
372: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
373: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
374: l_live_citem_version_id NUMBER;
375: l_citem_version_id NUMBER;
376: l_encrypt_flag VARCHAR2(1);
377:

Line 422: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

418: -- // retrieve the based language version translation
419: CURSOR Get_Citem_Meta_BLang IS
420: select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
421: t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
422: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
423: where i.CONTENT_ITEM_ID = p_content_item_id
424: and t.citem_version_id = l_citem_version_id
425: and t.language = i.BASE_LANGUAGE;
426:

Line 429: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

425: and t.language = i.BASE_LANGUAGE;
426:
427: CURSOR Get_Compound_Item_Ref IS
428: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG
429: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
430: where r.CITEM_VERSION_ID = l_citem_version_id
431: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
432: order by r.SORT_ORDER;
433:

Line 853: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;

849: x_return_status OUT NOCOPY VARCHAR2,
850: x_msg_count OUT NOCOPY NUMBER,
851: x_msg_data OUT NOCOPY VARCHAR2
852: ) AS
853: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
854: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
855: l_live_citem_version_id NUMBER;
856: l_citem_version_id NUMBER;
857: l_encrypt_flag VARCHAR2(1);

Line 854: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;

850: x_msg_count OUT NOCOPY NUMBER,
851: x_msg_data OUT NOCOPY VARCHAR2
852: ) AS
853: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
854: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
855: l_live_citem_version_id NUMBER;
856: l_citem_version_id NUMBER;
857: l_encrypt_flag VARCHAR2(1);
858: -----

Line 1046: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;

1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2
1045: ) AS
1046: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
1047: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
1048: l_live_citem_version_id NUMBER;
1049: l_citem_version_id NUMBER;
1050: l_encrypt_flag VARCHAR2(1);

Line 1047: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;

1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2
1045: ) AS
1046: l_content_type_code IBC_CONTENT_ITEMS.CONTENT_TYPE_CODE%TYPE;
1047: l_item_reference_code IBC_CONTENT_ITEMS.ITEM_REFERENCE_CODE%TYPE;
1048: l_live_citem_version_id NUMBER;
1049: l_citem_version_id NUMBER;
1050: l_encrypt_flag VARCHAR2(1);
1051:

Line 1091: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t

1087: -- // retrieve the based language version translation
1088: CURSOR Get_Citem_Meta_BLang IS
1089: select i.BASE_LANGUAGE, t.ATTRIBUTE_FILE_ID, t.CONTENT_ITEM_NAME, t.DESCRIPTION, t.ATTACHMENT_ATTRIBUTE_CODE,
1090: t.ATTACHMENT_FILE_ID, t.ATTACHMENT_FILE_NAME, t.DEFAULT_RENDITION_MIME_TYPE
1091: from IBC_CONTENT_ITEMS i, IBC_CITEM_VERSIONS_TL t
1092: where i.CONTENT_ITEM_ID = p_content_item_id
1093: and t.citem_version_id = p_citem_version_id
1094: and t.language = i.BASE_LANGUAGE;
1095:

Line 1099: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

1095:
1096: CURSOR Get_Compound_Item_Ref IS
1097: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG,
1098: nvl(SUBITEM_VERSION_ID, nvl(LIVE_CITEM_VERSION_ID, (select max(VERSION_NUMBER) from IBC_CITEM_VERSIONS_B where CONTENT_ITEM_ID = r.CONTENT_ITEM_ID))) child_version_id
1099: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
1100: where r.CITEM_VERSION_ID =p_citem_version_id
1101: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
1102: order by r.SORT_ORDER;
1103: