DBA Data[Home] [Help]

APPS.AMS_SCHEDULER_PVT dependencies on IBC_ASSOCIATIONS

Line 242: FROM ibc_associations

238: l_errcode VARCHAR2(80);
239:
240: CURSOR c_get_assoc IS
241: SELECT content_item_id
242: FROM ibc_associations
243: WHERE association_type_code = 'AMS_CSCH'
244: AND ASSOCIATED_OBJECT_VAL1 = to_char(p_parent_sched_id); -- fix for bug # 4145845
245: l_content_item_id NUMBER;
246:

Line 459: IBC_ASSOCIATIONS_GRP.Create_Association (

455: THEN
456: -- this if statement added by soagrawa on 23-mar-2004
457: IF l_content_item_id IS NOT null
458: THEN
459: IBC_ASSOCIATIONS_GRP.Create_Association (
460: p_api_version => 1.0,
461: p_assoc_type_code => 'AMS_CSCH',
462: p_assoc_object1 => l_new_sched_id,
463: p_content_item_id => l_content_item_id,