APPS.AMS_ACTPRODUCT_PVT dependencies on IBC_ASSOCIATIONS

Line 2442: FROM ibc_associations assoc, ibc_content_Items ci

2438: l_Return_status varchar2(20);
2439:
2440: CURSOR c_citem_assoc (l_csch_id IN NUMBER) IS
2441: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
2442: FROM ibc_associations assoc, ibc_content_Items ci
2443: --by musman:as per r12 requirement,live version stamping should be done for collab content
2444: WHERE assoc.association_type_code in ('AMS_PLCE') --('AMS_COLB','AMS_PLCE')
2445: AND assoc.associated_object_val1 = to_char(l_csch_id) --musman:bug 4145845 Fix
2446: AND assoc.content_item_id = ci.content_Item_id;

Line 2474: Ibc_Associations_Pkg.UPDATE_ROW(

2470: IF l_association_id IS NOT null
2471: AND l_citem_id IS NOT null
2472: AND l_citem_ver_id IS NOT NULl
2473: THEN
2474: Ibc_Associations_Pkg.UPDATE_ROW(
2475: p_association_id => l_association_id
2476: ,p_citem_version_id => l_citem_ver_id
2477: );
2478: END IF;

Line 2516: FROM IBC_ASSOCIATIONS IbcAssn,

2512: )
2513: IS
2514: cursor C_Content( l_sch_id IN NUMBER) IS
2515: SELECT count(*)
2516: FROM IBC_ASSOCIATIONS IbcAssn,
2517: ibc_content_items citem
2518: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_sch_id )-- musman:bug 4145845 Fix
2519: AND IbcAssn.Content_item_id = citem.content_item_id
2520: AND citem.content_item_status <> 'APPROVED'