APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_ASSOCIATIONS_TL

Line 1470: FROM ahl_item_associations_b b, ahl_item_associations_tl tl

1466: b.ATTRIBUTE15,
1467: b.LAST_UPDATE_DATE,
1468: b.LAST_UPDATED_BY,
1469: b.LAST_UPDATE_LOGIN
1470: FROM ahl_item_associations_b b, ahl_item_associations_tl tl
1471: WHERE b.item_association_id = tl.item_association_id
1472: and b.rowid = p_rowid
1473: AND tl.LANGUAGE = USERENV('LANG')
1474: FOR UPDATE OF object_version_number NOWAIT;

Line 1713: DELETE ahl_item_associations_tl

1709: -- Delete record.
1710: DELETE ahl_item_associations_b
1711: WHERE item_association_id = p_item_assoc_rec.item_association_id;
1712:
1713: DELETE ahl_item_associations_tl
1714: WHERE item_association_id = p_item_assoc_rec.item_association_id;
1715:
1716: CLOSE Item_assoc_csr;
1717:

Line 2670: DELETE AHL_ITEM_ASSOCIATIONS_TL

2666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2667: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2668: END IF;
2669:
2670: DELETE AHL_ITEM_ASSOCIATIONS_TL
2671: WHERE item_association_id IN ( SELECT item_association_id
2672: FROM ahl_item_associations_b
2673: WHERE item_group_id = p_item_group_rec.item_group_id );
2674:

Line 4071: Delete from ahl_item_associations_tl

4067: -- procedure.The validation of Item group updates for active UCs is now
4068: -- being done in procedure Modify_Item_group. Refer to old version of
4069: -- the package for details.
4070:
4071: Delete from ahl_item_associations_tl
4072: where item_association_id in
4073: ( Select item_association_id
4074: from ahl_item_associations_b
4075: where item_group_id = l_itemgroup_det.Source_Item_group_id);