[Home] [Help]
156:
157: CURSOR c_plce_citems(l_citem_version_id IN NUMBER) IS
158: SELECT civ.CONTENT_ITEM_ID c_item_id ,civ.CITEM_VERSION_ID c_version_id
159: FROM IBC_COMPOUND_RELATIONS cr, IBC_ATTRIBUTE_TYPES_VL attr, IBC_CONTENT_TYPES_VL ct,IBC_CITEM_VERSIONS_VL civ,
160: IBC_CONTENT_ITEMS ci WHERE
161: cr.ATTRIBUTE_TYPE_CODE = attr.ATTRIBUTE_TYPE_CODE AND
162: cr.CONTENT_TYPE_CODE = attr.CONTENT_TYPE_CODE AND
163: ct.CONTENT_TYPE_CODE = ci.CONTENT_TYPE_CODE AND
164: ci.CONTENT_ITEM_ID = civ.CONTENT_ITEM_ID AND
168: cr.CITEM_VERSION_ID = l_citem_version_id;
169:
170: CURSOR c_citem_ver_id(l_content_item_id IN NUMBER) IS
171: SELECT LIVE_CITEM_VERSION_ID
172: FROM IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_content_item_id;
173:
174: citem_rec c_plce_citems%rowtype;
175:
176: BEGIN
1004: -- Need to verify the Content Type Code Presence in IBC Schema Also
1005:
1006: CURSOR c_content_id_exists (l_content_item_id IN NUMBER) IS
1007: SELECT CONTENT_TYPE_CODE from
1008: IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_content_item_id AND CONTENT_ITEM_STATUS = 'APPROVED';
1009:
1010:
1011: BEGIN
1012:
1129: SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;
1130:
1131: CURSOR c_content_id_exists(l_campaign_activity_id IN NUMBER) IS
1132: SELECT Assn.content_item_id , Citem.live_citem_version_id
1133: FROM IBC_ASSOCIATIONS Assn, IBC_CONTENT_ITEMS Citem
1134: WHERE Assn.ASSOCIATED_OBJECT_VAL1 = TO_CHAR(l_campaign_activity_id)
1135: AND Assn.CONTENT_ITEM_ID = Citem.CONTENT_ITEM_ID
1136: AND Citem.CONTENT_ITEM_STATUS <> 'APPROVED'
1137: AND Assn.ASSOCIATION_TYPE_CODE in ('AMS_PLCE') ;