1380: --Gets the sequence Number
1381: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
1382: l_item_association_id from DUAL;
1383:
1384: AHL_ITEM_ASSOCIATIONS_PKG.INSERT_ROW(
1385: X_ROWID => l_row_id,
1386: X_ITEM_ASSOCIATION_ID => l_item_association_id,
1387: X_SOURCE_ITEM_ASSOCIATION_ID => NULL,
1388: X_OBJECT_VERSION_NUMBER => 1,
1636: l_item_assoc_rec.SOURCE_LANG := NULL;
1637: END IF;
1638: */
1639:
1640: AHL_ITEM_ASSOCIATIONS_PKG.UPDATE_ROW(
1641: X_ITEM_ASSOCIATION_ID => l_item_assoc_rec.item_association_id,
1642: X_SOURCE_ITEM_ASSOCIATION_ID => l_old_item_assoc_rec.SOURCE_ITEM_ASSOCIATION_ID,
1643: X_OBJECT_VERSION_NUMBER => l_old_item_assoc_rec.object_version_number + 1,
1644: X_ITEM_GROUP_ID => l_item_assoc_rec.item_group_id,
2664: WHERE item_group_id = p_item_group_rec.item_group_id;
2665: END IF;
2666:
2667: -- Delete item associations.
2668: /* AHL_ITEM_ASSOCIATIONS_PKG.DELETE_ROW(
2669: X_ITEM_ASSOCIATION_ID => p_item_group_rec.item_group_id
2670: );
2671:
2672: */
3435: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
3436: l_item_association_id from DUAL;
3437:
3438:
3439: ahl_item_associations_pkg.insert_row
3440: (
3441: x_rowid => l_rowid,
3442: x_item_association_id => l_item_association_id,
3443: x_source_item_association_id => I.source_item_association_id,