APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_ASSOCIATIONS_TL

Line 1472: FROM ahl_item_associations_b b, ahl_item_associations_tl tl

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

Line 1715: DELETE ahl_item_associations_tl

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

Line 2680: DELETE AHL_ITEM_ASSOCIATIONS_TL

2676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2677: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Deleting Item Group');
2678: END IF;
2679:
2680: DELETE AHL_ITEM_ASSOCIATIONS_TL
2681: WHERE item_association_id IN ( SELECT item_association_id
2682: FROM ahl_item_associations_b
2683: WHERE item_group_id = p_item_group_rec.item_group_id );
2684:

Line 4097: Delete from ahl_item_associations_tl

4093: -- procedure.The validation of Item group updates for active UCs is now
4094: -- being done in procedure Modify_Item_group. Refer to old version of
4095: -- the package for details.
4096:
4097: Delete from ahl_item_associations_tl
4098: where item_association_id in
4099: ( Select item_association_id
4100: from ahl_item_associations_b
4101: where item_group_id = l_itemgroup_det.Source_Item_group_id);