2327: --get sequence
2328: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2329:
2330: -- take snapshot now
2331: AHL_SNAPSHOTS_PKG.INSERT_ROW
2332: (
2333: X_SNAPSHOT_ID => l_snapshot_id,
2334:
2335: X_OBJECT_VERSION_NUMBER => 1,
2635: --get sequence
2636: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2637:
2638: -- take snapshot now
2639: AHL_SNAPSHOTS_PKG.INSERT_ROW
2640: (
2641: X_SNAPSHOT_ID => l_snapshot_id,
2642: X_OBJECT_VERSION_NUMBER => 1,
2643: X_SNAPSHOT_NUMBER => l_snapshot_number,
2702: --get sequence
2703: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_id FROM DUAL;
2704:
2705: -- take snapshot now
2706: AHL_SNAPSHOTS_PKG.INSERT_ROW
2707: (
2708: X_SNAPSHOT_ID => l_snapshot_id,
2709: X_OBJECT_VERSION_NUMBER => 1,
2710: X_SNAPSHOT_NUMBER => l_snapshot_number,