174: ELSE
175: -- bundle exists, now delete it (if it is not null)!
176: IF (old_file_id IS NOT NULL) THEN
177: DELETE
178: FROM ibc_attribute_bundles
179: WHERE attribute_bundle_id = old_file_id;
180:
181: -- Log it!
182: IF ( f_log_action = FND_API.g_true) THEN
1310: LANGUAGE = p_language;
1311:
1312: CURSOR c_abundle IS
1313: SELECT attribute_bundle_data file_data
1314: FROM IBC_ATTRIBUTE_BUNDLES
1315: WHERE attribute_bundle_id = o_attrib_fid;
1316:
1317: CURSOR c_components(p_citem_version_id NUMBER) IS
1318: SELECT content_item_id ciid
13378: -- Delete Renditions
13379: DELETE FROM ibc_renditions WHERE citem_Version_id = l_citem_version_id;
13380:
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:
13633: -- Delete Renditions
13634: DELETE FROM ibc_renditions WHERE citem_version_id = citem_version_Rec.citem_version_id;
13635:
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;