1211: RAISE FND_API.g_exc_error;
1212: END IF;
1213:
1214: -- There is a bug in IBC Code. The field attachment_attribute_code in the
1215: -- table ibc_citem_versions_tl is getting updated some times. Filed a bug on IBC
1216: -- to track this issue.
1217: -- Bug # is : 2290924.
1218:
1219: UPDATE ibc_citem_versions_tl
1215: -- table ibc_citem_versions_tl is getting updated some times. Filed a bug on IBC
1216: -- to track this issue.
1217: -- Bug # is : 2290924.
1218:
1219: UPDATE ibc_citem_versions_tl
1220: SET attachment_attribute_code = 'ATTACHMENT' -- hardcoding as ATTACHMENT for Rich Content.
1221: WHERE citem_version_id = l_citem_ver_id ;
1222:
1223: -- We do not approve this item at this point.
6019: RAISE FND_API.g_exc_error;
6020: END IF;
6021:
6022: -- There is a bug in IBC Code. The field attachment_attribute_code in the
6023: -- table ibc_citem_versions_tl is getting updated some times. Filed a bug on IBC
6024: -- to track this issue.
6025: -- Bug # is : 2290924.
6026:
6027: UPDATE ibc_citem_versions_tl
6023: -- table ibc_citem_versions_tl is getting updated some times. Filed a bug on IBC
6024: -- to track this issue.
6025: -- Bug # is : 2290924.
6026:
6027: UPDATE ibc_citem_versions_tl
6028: SET attachment_attribute_code = 'QUESTIONS_XML' -- hardcoding as QUESTIONS_XML for Questions Section.
6029: WHERE citem_version_id = l_section_citem_ver_id ;
6030:
6031: -- Delete all the records from ams_list_src_type_usages for this content item