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_COMPOUND_RELATIONS

Line 612: FROM ibc_compound_relations

608: l_dummy VARCHAR2(2);
609: l_result BOOLEAN;
610: CURSOR cur IS
611: SELECT 'X'
612: FROM ibc_compound_relations
613: WHERE content_item_id = p_content_item_id;
614:
615: BEGIN
616: l_result := FALSE;

Line 1322: FROM ibc_compound_relations

1318: SELECT content_item_id ciid
1319: ,attribute_type_code atc
1320: ,content_type_code ctc
1321: ,sort_order sod
1322: FROM ibc_compound_relations
1323: WHERE citem_version_id = p_citem_version_id;
1324:
1325: CURSOR c_renditions(p_citem_version_id NUMBER,
1326: p_language VARCHAR2) IS

Line 1526: IBC_COMPOUND_RELATIONS_PKG.insert_row(

1522: FOR r_component IN c_components(px_citem_ver_id) LOOP
1523: --resetting id
1524: compound_id := NULL;
1525:
1526: IBC_COMPOUND_RELATIONS_PKG.insert_row(
1527: x_rowid => row_id
1528: ,px_compound_relation_id => compound_id
1529: ,p_content_item_id => r_component.ciid
1530: ,p_attribute_type_code => r_component.atc

Line 2232: Ibc_Compound_Relations_Pkg.insert_row(

2228: l_subitem_version_id := p_citem_ver_ids(counter);
2229: END IF;
2230:
2231:
2232: Ibc_Compound_Relations_Pkg.insert_row(
2233: x_ROWID => row_id
2234: ,px_COMPOUND_RELATION_ID => compound_id
2235: ,p_CONTENT_ITEM_ID => p_content_item_ids(counter)
2236: ,p_ATTRIBUTE_TYPE_CODE => p_attribute_type_codes(counter)

Line 2347: FROM ibc_compound_relations

2343: p_content_type_code VARCHAR2,
2344: p_citem_version_id NUMBER)
2345: IS
2346: SELECT content_item_id
2347: FROM ibc_compound_relations
2348: WHERE attribute_type_code = p_attribute_type_code
2349: AND content_Type_code = p_content_type_code
2350: AND citem_version_id = p_citem_version_id;
2351:

Line 3420: ibc_compound_relations b,

3416: p_status IN VARCHAR2)
3417: IS
3418: SELECT 'X'
3419: FROM ibc_citem_versions_b a,
3420: ibc_compound_relations b,
3421: ibc_content_items c
3422: WHERE a.citem_version_id = b.citem_version_id
3423: AND b.content_item_id = c.content_item_id
3424: AND a.citem_version_id = p_citem_ver_id

Line 5286: ibc_compound_relations

5282: MIN(compound_relation_id)
5283: INTO
5284: temp
5285: FROM
5286: ibc_compound_relations
5287: WHERE
5288: content_item_id = content_item_id
5289: AND
5290: content_type_code = ctype_code

Line 5305: Ibc_Compound_Relations_Pkg.delete_row(temp);

5301: FND_MESSAGE.Set_Name('IBC', 'INVALID_COMPOUND_RELATIONSHIP');
5302: FND_MSG_PUB.ADD;
5303: RAISE FND_API.G_EXC_ERROR;
5304: ELSE
5305: Ibc_Compound_Relations_Pkg.delete_row(temp);
5306: --***************************************************
5307: --************ADDING TO AUDIT LOG********************
5308: --***************************************************
5309: Ibc_Utilities_Pvt.log_action(

Line 6170: SELECT ibc_compound_relations.content_item_id ciid

6166:
6167: CURSOR c_components(p_citem_version_id NUMBER,
6168: p_language VARCHAR2)
6169: IS
6170: SELECT ibc_compound_relations.content_item_id ciid
6171: ,ibc_content_items.owner_resource_id orid
6172: ,ibc_content_items.owner_resource_type ort
6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin

Line 6173: ,ibc_compound_relations.attribute_type_code atc

6169: IS
6170: SELECT ibc_compound_relations.content_item_id ciid
6171: ,ibc_content_items.owner_resource_id orid
6172: ,ibc_content_items.owner_resource_type ort
6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin
6175: ,ibc_compound_relations.sort_order sor
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations

Line 6175: ,ibc_compound_relations.sort_order sor

6171: ,ibc_content_items.owner_resource_id orid
6172: ,ibc_content_items.owner_resource_type ort
6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin
6175: ,ibc_compound_relations.sort_order sor
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6179: ,ibc_citem_versions_b b1

Line 6176: ,ibc_compound_relations.subitem_version_id svid

6172: ,ibc_content_items.owner_resource_type ort
6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin
6175: ,ibc_compound_relations.sort_order sor
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6179: ,ibc_citem_versions_b b1
6180: ,ibc_citem_versions_tl

Line 6177: FROM ibc_compound_relations

6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin
6175: ,ibc_compound_relations.sort_order sor
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6179: ,ibc_citem_versions_b b1
6180: ,ibc_citem_versions_tl
6181: WHERE b1.citem_version_id = ibc_citem_versions_tl.citem_version_id

Line 6183: AND ibc_content_items.content_item_id = ibc_compound_relations.content_item_id

6179: ,ibc_citem_versions_b b1
6180: ,ibc_citem_versions_tl
6181: WHERE b1.citem_version_id = ibc_citem_versions_tl.citem_version_id
6182: AND b1.content_item_id = ibc_content_items.content_item_id
6183: AND ibc_content_items.content_item_id = ibc_compound_relations.content_item_id
6184: AND b1.version_number = (SELECT MAX(b2.version_number)
6185: FROM ibc_citem_versions_b b2
6186: WHERE b1.content_item_id = b2.content_item_id
6187: )

Line 6189: AND ibc_compound_relations.citem_version_id = p_citem_version_id

6185: FROM ibc_citem_versions_b b2
6186: WHERE b1.content_item_id = b2.content_item_id
6187: )
6188: AND ibc_citem_versions_tl.LANGUAGE = p_language
6189: AND ibc_compound_relations.citem_version_id = p_citem_version_id
6190: ORDER BY ibc_compound_relations.sort_order;
6191:
6192: CURSOR c_renditions(p_citem_version_id NUMBER,
6193: p_language VARCHAR2)

Line 6190: ORDER BY ibc_compound_relations.sort_order;

6186: WHERE b1.content_item_id = b2.content_item_id
6187: )
6188: AND ibc_citem_versions_tl.LANGUAGE = p_language
6189: AND ibc_compound_relations.citem_version_id = p_citem_version_id
6190: ORDER BY ibc_compound_relations.sort_order;
6191:
6192: CURSOR c_renditions(p_citem_version_id NUMBER,
6193: p_language VARCHAR2)
6194: IS

Line 12370: ibc_compound_relations

12366: IF ( (do_version = G_COMMAND_UPDATE) AND (p_update = FND_API.g_true) ) THEN
12367: --delete all components before adding new ones!
12368: --DBMS_OUTPUT.put_line('DELETING OLD COMPONENTS');
12369: DELETE FROM
12370: ibc_compound_relations
12371: WHERE
12372: citem_version_id = px_citem_ver_id;
12373: END IF;
12374:

Line 13385: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CITEM_VERSION_ID = l_citem_version_id;

13381: -- Delete Attribute bundle
13382: DELETE FROM IBC_ATTRIBUTE_BUNDLES WHERE attribute_bundle_id = l_citem_version_attr_id;
13383:
13384: -- Delete compound relations
13385: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CITEM_VERSION_ID = l_citem_version_id;
13386:
13387: --***************************************************
13388: --************ADDING TO AUDIT LOG********************
13389: --***************************************************

Line 13640: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CITEM_VERSION_ID = citem_version_rec.CITEM_VERSION_ID;

13636: -- Delete Attribute bundle
13637: DELETE FROM IBC_ATTRIBUTE_BUNDLES WHERE attribute_bundle_id = citem_version_rec.ATTRIBUTE_FILE_ID;
13638:
13639: -- Delete compound relations
13640: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CITEM_VERSION_ID = citem_version_rec.CITEM_VERSION_ID;
13641: END LOOP;
13642:
13643: -- Delete citem keywords
13644: DELETE FROM ibc_citem_keywords WHERE CONTENT_ITEM_ID = l_citem_id;

Line 13648: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CONTENT_ITEM_ID = l_citem_id;

13644: DELETE FROM ibc_citem_keywords WHERE CONTENT_ITEM_ID = l_citem_id;
13645:
13646: -- Delete itself from being a child (this should not be needed,
13647: -- if UI disable deletion of children items)
13648: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CONTENT_ITEM_ID = l_citem_id;
13649:
13650: -- Delete itself
13651: DELETE FROM IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_citem_id;
13652: