APPS.AMS_WEBMARKETING_PVT dependencies on IBC_ASSOCIATIONS

Line 317: --- This API would be calling OCM API's for Associations ( IBC_ASSOCIATIONS)

313:
314: END IF;
315:
316:
317: --- This API would be calling OCM API's for Associations ( IBC_ASSOCIATIONS)
318: -- p_assoc_type_code => 'AMS_PLCE',
319: -- p_assoc_object1 => object_used_by_id
320: -- p_assoc_object2 => placementid
321: --p_content_item_id => p_content_item_id,

Line 327: Ibc_Associations_Grp.Create_Association( p_api_version => p_api_version_number,

323:
324: l_assoc_object1 := p_web_mp_rec.object_used_by_id;
325: l_assoc_object2 := p_web_mp_rec.placement_id;
326:
327: Ibc_Associations_Grp.Create_Association( p_api_version => p_api_version_number,
328: p_init_msg_list => p_init_msg_list,
329: p_commit => p_commit,
330: p_assoc_type_code => 'AMS_PLCE',
331: p_assoc_object1 => l_assoc_object1,

Line 1133: FROM IBC_ASSOCIATIONS Assn, IBC_CONTENT_ITEMS Citem

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') ;