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_ADMIN_GRP dependencies on IBC_RENDITIONS

Line 1331: FROM ibc_renditions

1327: SELECT LANGUAGE,
1328: file_id,
1329: file_name,
1330: mime_type
1331: FROM ibc_renditions
1332: WHERE citem_version_id = p_citem_version_id
1333: AND LANGUAGE = p_language;
1334:
1335: BEGIN

Line 1504: IBC_RENDITIONS_PKG.insert_row(

1500: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1501:
1502: FOR r_rendition IN c_renditions(px_citem_ver_id, p_language) LOOP
1503: l_rendition_id := NULL;
1504: IBC_RENDITIONS_PKG.insert_row(
1505: Px_rowid => row_id
1506: ,Px_RENDITION_ID => l_rendition_id
1507: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
1508: ,P_LANGUAGE => r_rendition.LANGUAGE

Line 2516: FROM IBC_RENDITIONS

2512: WHERE content_type_code = p_content_type_code;
2513:
2514: CURSOR c_count_renditions IS
2515: SELECT COUNT(*)
2516: FROM IBC_RENDITIONS
2517: WHERE CITEM_VERSION_ID = p_citem_ver_id
2518: AND LANGUAGE = p_language;
2519:
2520:

Line 2989: FROM ibc_renditions

2985: )IS
2986: SELECT file_id
2987: ,file_name
2988: ,mime_type
2989: FROM ibc_renditions
2990: WHERE citem_version_id = cv_citem_version_id
2991: AND LANGUAGE = cv_language;
2992:
2993: CURSOR c_populate_rend(cv_citem_version_id NUMBER

Line 3109: ibc_renditions_pkg.insert_row(

3105: -- Bug Fix: 3416463
3106: FOR cr_populate_ren IN c_populate_rend(p_citem_ver_id,p_base_lang) LOOP
3107: FOR cr_base_ren IN c_base_renditions(p_citem_ver_id,p_base_lang) LOOP
3108: l_rendition_id := NULL;
3109: ibc_renditions_pkg.insert_row(
3110: px_rowid => row_id
3111: ,px_rendition_id => l_rendition_id
3112: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
3113: ,p_language => cr_populate_ren.LANGUAGE

Line 6196: FROM ibc_renditions

6192: CURSOR c_renditions(p_citem_version_id NUMBER,
6193: p_language VARCHAR2)
6194: IS
6195: SELECT file_id, file_name, mime_type
6196: FROM ibc_renditions
6197: WHERE citem_version_id = p_citem_version_id
6198: AND LANGUAGE = p_language;
6199:
6200: CURSOR c_keywords(p_content_item_id NUMBER) IS

Line 9932: DELETE FROM ibc_renditions

9928: RAISE FND_API.G_EXC_ERROR;
9929: END IF;
9930:
9931: -- Delete default rendition
9932: DELETE FROM ibc_renditions
9933: WHERE citem_version_id = p_citem_ver_id
9934: AND LANGUAGE = p_language
9935: AND file_id = l_current_attachment_file_id;
9936:

Line 9944: DELETE FROM ibc_renditions

9940: att_file_name := NULL;
9941: att_type_code := NULL;
9942: l_attach_rendition_mtype := NULL;
9943: -- Delete all renditions for particular language
9944: DELETE FROM ibc_renditions
9945: WHERE citem_version_id = p_citem_ver_id
9946: AND LANGUAGE = p_language;
9947: END IF;
9948:

Line 10019: IBC_RENDITIONS_PKG.insert_row(

10015: --***************************************************
10016:
10017: IF p_attach_file_id IS NOT NULL THEN
10018: l_rendition_id := NULL;
10019: IBC_RENDITIONS_PKG.insert_row(
10020: Px_rowid => l_row_id
10021: ,Px_RENDITION_ID => l_rendition_id
10022: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
10023: ,P_LANGUAGE => p_language

Line 11999: DELETE FROM ibc_renditions

11995: IF ((p_item_renditions IS NULL) AND
11996: (do_version <> G_COMMAND_POST_APPROVAL_UPDATE)) THEN
11997:
11998: -- Delete all existing renditions
11999: DELETE FROM ibc_renditions
12000: WHERE citem_version_id = px_citem_ver_id
12001: AND LANGUAGE = lang;
12002:
12003: END IF;

Line 12016: DELETE FROM ibc_renditions

12012: IF ((p_item_renditions IS NOT NULL) AND
12013: (do_version <> G_COMMAND_POST_APPROVAL_UPDATE)) THEN
12014:
12015: -- Delete existing renditions
12016: DELETE FROM ibc_renditions
12017: WHERE citem_version_id = px_citem_ver_id
12018: AND LANGUAGE = lang;
12019:
12020: FOR I IN 1..p_item_renditions.COUNT LOOP

Line 12346: IBC_RENDITIONS_PKG.insert_row(

12342: CLOSE c_lob;
12343: l_attach_rendition_mtype := GET_MIME_TYPE(l_attach_rendition_mtype);
12344:
12345: l_rendition_id := NULL;
12346: IBC_RENDITIONS_PKG.insert_row(
12347: Px_rowid => row_id
12348: ,Px_RENDITION_ID => l_rendition_id
12349: ,p_object_version_number => G_OBJ_VERSION_DEFAULT
12350: ,P_LANGUAGE => lang

Line 13380: DELETE FROM ibc_renditions WHERE citem_Version_id = l_citem_version_id;

13376: -- Delete version
13377: Ibc_Citem_Versions_Pkg.DELETE_ROW(l_citem_version_id);
13378:
13379: -- Delete Renditions
13380: DELETE FROM ibc_renditions WHERE citem_Version_id = l_citem_version_id;
13381:
13382: -- Delete Attribute bundle
13383: DELETE FROM IBC_ATTRIBUTE_BUNDLES WHERE attribute_bundle_id = l_citem_version_attr_id;
13384:

Line 13635: DELETE FROM ibc_renditions WHERE citem_version_id = citem_version_Rec.citem_version_id;

13631: -- Delete version
13632: Ibc_Citem_Versions_Pkg.DELETE_ROW(citem_version_rec.CITEM_VERSION_ID);
13633:
13634: -- Delete Renditions
13635: DELETE FROM ibc_renditions WHERE citem_version_id = citem_version_Rec.citem_version_id;
13636:
13637: -- Delete Attribute bundle
13638: DELETE FROM IBC_ATTRIBUTE_BUNDLES WHERE attribute_bundle_id = citem_version_rec.ATTRIBUTE_FILE_ID;
13639: