3615: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3616: END IF;
3617:
3618:
3619: Select ahl_item_associations_b_h_s.nextval
3620: into l_item_associations_h_id from dual;
3621:
3622: INSERT INTO ahl_item_groups_b_h
3623: (item_group_h_id ,
3722:
3723:
3724: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP
3725:
3726: Select ahl_item_associations_b_h_s.nextval
3727: into l_item_associations_h_id from dual;
3728:
3729: AHL_ITEM_ASSOCIATIONS_H_PKG.INSERT_ROW(
3730: X_ROWID => l_rowid,