743: END IF;
744:
745: ----------------------------DML Operation---------------------------------
746: --Call table handler generated package to insert a record
747: AHL_SIMULATION_PLANS_PKG.INSERT_ROW (
748: X_ROWID => l_rowid,
749: X_SIMULATION_PLAN_ID => l_simulation_plan_id,
750: X_PRIMARY_PLAN_FLAG => 'N',
751: X_OBJECT_VERSION_NUMBER => 1,
988: END IF;
989:
990: ----------------------------DML Operation---------------------------------
991: --Call table handler generated package to update a record
992: AHL_SIMULATION_PLANS_PKG.UPDATE_ROW
993: (
994: X_SIMULATION_PLAN_ID => l_Asimulation_plan_rec.simulation_plan_id,
995: X_PRIMARY_PLAN_FLAG => 'N',
996: X_SIMULATION_PLAN_NAME => l_Asimulation_plan_rec.simulation_plan_name,
1251: FND_MSG_PUB.add;
1252: RAISE FND_API.g_exc_error;
1253: END IF;
1254: -------------------Call Table handler generated procedure------------
1255: AHL_SIMULATION_PLANS_PKG.DELETE_ROW (
1256: X_SIMULATION_PLAN_ID => l_simulation_plan_id
1257: );
1258: ---------------------------End of Body---------------------------------------
1259: --Standard check to count messages
3068: CLOSE visit_detail_cur;
3069: END IF;
3070: --Remove simulation plan
3071: -------------------Call Table handler generated procedure------------
3072: AHL_SIMULATION_PLANS_PKG.DELETE_ROW (
3073: X_SIMULATION_PLAN_ID => p_plan_id);
3074: ---------------------------End of Body---------------------------------------
3075:
3076: -- Changes by mpothuku end